[R] replace "" to NA.

[vikram ranga]

Hi Arun & Jim & Marc,
Thank you!
The solution worked well!

It seems I am using too many unnecessary loops to solve my problems. I
have tried using is.na() before posting:

for(i in 1:3){
for(j in 1:3){
if(is.na(test[j,i])){
test[j,i]=""
}
}
} # but here the factors were creating problems.

Thanks again!


On Mon, Jan 6, 2014 at 8:27 PM, arun <smartpink111 at yahoo.com> wrote:
> Hi,
> Try:
>
>
> test[test=="" & !is.na(test)] <- NA
> A.K.
>
>
>
>
> On Monday, January 6, 2014 7:51 AM, vikram ranga <babuawara at gmail.com> wrote:
> Dear All,
>
> I am bit stuck to a problem of replacing "" to NA.
> I have big data set but here is the toy example:-
>
> test<-data.frame(
> test1=c("","Hi","Hello"),
> test2=c("Hi","","Bye"),
> test3=c("Hello","",""))
>
> If the data as in above, I could change all "" to NA by this code:-
>
> for(i in 1:3){
> for(j in 1:3){
> if(test[j,i]==""){
> test[j,i]=NA
> }
> }
> }
>
> but the problem arises if data frame has NA at some places
>
> test<-data.frame(
> test1=c("","Hi","Hello"),
> test2=c("Hi",NA,"Bye"),
> test3=c("Hello","",""))
>
> the above loop script does not work on this data frame as NA is has
> logical class and does not return TRUE/FALSE.
>
> Can anyone provide some help?
>
> My sessionInfo is:
> R version 3.0.2 (2013-09-25)
> Platform: i386-w64-mingw32/i386 (32-bit)
>
> locale:
> [1] LC_COLLATE=English_India.1252  LC_CTYPE=English_India.1252
> LC_MONETARY=English_India.1252
> [4] LC_NUMERIC=C                   LC_TIME=English_India.1252
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>
> other attached packages:
> [1] RColorBrewer_1.0-5 plotrix_3.5-2      foreign_0.8-57
> splancs_2.01-34    spatstat_1.34-0
> [6] polyclip_1.1-0     tensor_1.5         abind_1.4-0
> deldir_0.1-1       mgcv_1.7-26
> [11] nlme_3.1-111       xlsx_0.5.1         xlsxjars_0.5.0
> rJava_0.9-4        ggplot2_0.9.3.1
> [16] rgdal_0.8-11       rgeos_0.3-2        maptools_0.8-27    sp_1.0-14
>
> loaded via a namespace (and not attached):
> [1] colorspace_1.2-4 dichromat_2.0-0  digest_0.6.3     grid_3.0.2
>   gtable_0.1.2
> [6] labeling_0.2     lattice_0.20-23  MASS_7.3-29      Matrix_1.0-14
>   munsell_0.4.2
> [11] plyr_1.8         proto_0.3-10     reshape2_1.2.2   scales_0.2.3
>   stringr_0.6.2
> [16] tcltk_3.0.2      tools_3.0.2
>
> ______________________________________________
> R-help at 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.
>