roman_max
☆    

Russia,
2017-08-03 18:12
(2428 d 21:50 ago)

Posting: # 17656
Views: 5,656
 

 Data errors in csv file [🇷 for BE/BA]

Dear all,

I faced with the problem using bear 2.8.3 (R 3.4.1, x64) when I run NCA. After importing a csv file at the end I received a message about some data errors. In the data_err_log.txt file it looks like this:

*** The error occurs in 'time'.

subj seq prd time conc
1 2 1 0,00 0,000
1 2 1 0,17 NA
1 2 1 0,33 NA
1 2 1 0,50 0,098
1 2 1 0,67 0,150
1 2 1 0,83 0,252
1 2 1 1,00 0,337
I've checked all data fields manually and no errors have been detected. Surprisingly, when I use bear 2.7.7 and the same csv file no errors detected and the bear do his job.

Does anybody know how to exactly detect the particular "errors in time" and resolve this issue in bear 2.8.3?

Regards,
Roman
yjlee168
★★★
avatar
Homepage
Kaohsiung, Taiwan,
2017-08-03 18:53
(2428 d 21:09 ago)

@ roman_max
Posting: # 17659
Views: 4,842
 

 Data errors in csv file

Dear roman_max,

Wait. I will check the codes again. Your data looks OK for me. If you need to run analysis immediately, please replace the comma (,) with the period (.) for the decimal. It then should be OK (I have confirmed this). Sorry about my previous messages.

❝ *** The error occurs in 'time'.


❝ subj seq prd time conc

❝ 1 2 1 0,00 0,000

❝ 1 2 1 0,17 NA

❝ 1 2 1 0,33 NA

❝ 1 2 1 0,50 0,098

❝ 1 2 1 0,67 0,150

❝ 1 2 1 0,83 0,252

❝ 1 2 1 1,00 0,337


All the best,
-- Yung-jin Lee
bear v2.9.1:- created by Hsin-ya Lee & Yung-jin Lee
Kaohsiung, Taiwan https://www.pkpd168.com/bear
Download link (updated) -> here
roman_max
☆    

Russia,
2017-08-03 20:36
(2428 d 19:26 ago)

@ yjlee168
Posting: # 17661
Views: 4,840
 

 Data errors in csv file

Dear yjlee168,

Thanks for the propmpt reply and the tip concerning separators. But I had to change systemic defaults (from comma to dot) because traditionally in Russia the decimal separator is comma. Now everythig is fine with the data and analysis as well.

Regards,
Roman
yjlee168
★★★
avatar
Homepage
Kaohsiung, Taiwan,
2017-08-03 22:03
(2428 d 17:59 ago)

(edited by yjlee168 on 2017-08-03 23:18)
@ roman_max
Posting: # 17662
Views: 4,866
 

 Data errors in csv file

Dear roman_max,

Sorry about this error. I did not notice that the function fread() from package data.table is no longer working as smartly as previously. It cannot automatically identify the decimal separator correctly. It used to be able to do that. The decimal point should be either comma or period. However identification of the column separator still works fine with fread(). It sounds like that I need add an extra option for this in GUI (hopefully not), like the old version. But I will keep searching for solution for this. The error affects all dataset using comma as decimal separator. Thank you so much for bringing up this error here.

All the best,
-- Yung-jin Lee
bear v2.9.1:- created by Hsin-ya Lee & Yung-jin Lee
Kaohsiung, Taiwan https://www.pkpd168.com/bear
Download link (updated) -> here
UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,638 registered users;
72 visitors (0 registered, 72 guests [including 7 identified bots]).
Forum time: 15:02 CET (Europe/Vienna)

Nothing shows a lack of mathematical education more
than an overly precise calculation.    Carl Friedrich Gauß

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5