[R] How to convert blanks to NA
Hans-Peter Suter
gchappi at gmail.com
Wed Jun 3 21:54:41 CEST 2009
2009/6/2 Mark Na <mtb954 at gmail.com>:
> 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.
The pro version has an 'naStrings' argument. But this is something
that should be supported since longtime also in the normal
xlsReadWrite. Thanks for reminding me :-) and it's now - at least -
in my Redmine tracker.
Cheers,
Hans-Peter
More information about the R-help
mailing list