Bioequivalence and Bioavailability Forum

Main page Policy/Terms of Use Abbreviations Latest Posts

 Log-in |  Register |  Search

Back to the forum  Query: 2017-12-13 08:32 CET (UTC+1h)
 
roman_max
Junior

Russia,
2017-08-03 16:12

Posting: # 17656
Views: 1,033
 

 Data errors in csv file [R 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
Senior
Homepage
Kaohsiung, Taiwan,
2017-08-03 16:53
(edited by yjlee168 on 2017-08-03 17:30)

@ roman_max
Posting: # 17659
Views: 875
 

 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
[image]bear v2.8.3:- created by Hsin-ya Lee & Yung-jin Lee
Kaohsiung, Taiwan http://pkpd.kmu.edu.tw/bear
Download link (updated) -> here
roman_max
Junior

Russia,
2017-08-03 18:36

@ yjlee168
Posting: # 17661
Views: 854
 

 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
Senior
Homepage
Kaohsiung, Taiwan,
2017-08-03 20:03
(edited by yjlee168 on 2017-08-03 23:18)

@ roman_max
Posting: # 17662
Views: 835
 

 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
[image]bear v2.8.3:- created by Hsin-ya Lee & Yung-jin Lee
Kaohsiung, Taiwan http://pkpd.kmu.edu.tw/bear
Download link (updated) -> here
Back to the forum Activity
 Thread view
Bioequivalence and Bioavailability Forum | Admin contact
17,556 Posts in 3,758 Threads, 1,091 registered users;
30 users online (0 registered, 30 guests).

The purpose of models is not to fit the data,
but to sharpen the questions.    Samuel Karlin

The BIOEQUIVALENCE / BIOAVAILABILITY FORUM is hosted by
BEBAC Ing. Helmut Schütz
XHTML/CSS RSS Feed