[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