Hi R-helpers,
I have imported data from Excel using the following code:
library(xlsReadWrite)
data <- read.xls(data,colClasses=c("character"))
and this results in all of the empty (blank) cells in the imported
Excel file also being empty (blank) in the resulting dataframe.
I am not used to having blanks (rather NAs) and I think these are
caused by the colClasses argument.
I would like to convert all the empty (blank) cells in my dataframe to NA.
Thanks for any help you might provide.
Mark
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
