Data frame challenge [🇷 for BE/BA]

posted by zizou – Plzeň, Czech Republic, 2016-12-19 19:41 (2973 d 23:56 ago) – Posting: # 16857
Views: 4,500

Dear ElMaestro.

I think there should be a warning message when you have apples and bananas in your data. x)

Function as.numeric() produces Warning message because there is no numeric value in case of "Banana" (etc.) resulting in NA.

If you expect numeric values with some text known before you can use:
A=read.table("SomeFile.csv", colClasses="numeric", na.strings=c("Banana","Apple"), header=T)
If colClasses set to numeric and there is a string not mentioned in na.strings (e.g. "Orange"), then there will be an error in function read.table().

If Bananas and Apples should be managed in different way, I would read the data as character (no specification of colClasses). Then change e.g. "Banana" for "0" and "Apple" for NA and change type to numeric using as.numeric().
text=c("Apple","Banana")
#text=c("Apple","Banana","Orange")
for (i in 1:length(text)){
 if(text[i]=="Apple"){text[i]="0"}
 if(text[i]=="Banana"){text[i]=NA}
}
as.numeric(text)
#[1]  0 NA # no error and no warning

If "Orange" will be also in text/data, it will be treated as NA by coercion with the warning message.

In such data with numeric+character values in one variable I would store it as character only (with no statistics or whatever).

The principle of change all string values (in many of numeric values) to zero without warnings seems strange to me to me (simple example is to have a wrong value 1,25 in the data instead of correct value 1.25). It seems Ok. to have a warning about changing the value to NA. But of course, when all data are correct and there are many of string values which should be a zero, the warning is unwished.
To avoid supressing using suppressWarnings(as.numeric(text)) it must be done as mittyri wrote, i.e. replace all character values to "0" before using the function as.numeric(). (Nevertheless the result is similar, the values of type "1,25" or "1.25*" will be changed to zero without warnings.)

Best regards,
zizou

No one likes warnings even though they can help!

Complete thread:

UA Flag
Activity
 Admin contact
23,376 posts in 4,912 threads, 1,662 registered users;
243 visitors (0 registered, 243 guests [including 13 identified bots]).
Forum time: 19:37 CET (Europe/Vienna)

There are sadistic scientists who hurry to hunt down errors
instead of establishing the truth.    Marie Curie

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