Try this:
sapply(x, function(f){is.na(f)<-which(f == '');f})
On Tue, Jun 2, 2009 at 4:14 PM, Mark Na <mtb...@gmail.com> wrote:
> 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
[[alternative HTML version deleted]]
______________________________________________
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.
