[R] Odp: conditional data replace (recode, change or whatsoever)
Petr PIKAL
petr.pikal at precheza.cz
Wed Aug 3 11:18:39 CEST 2011
Hi
>
> Hello,
> I have a big data.frame, a piece of it as follows.
>
> a b c d
> 1 58009 2010-11-02 0 NA
> 2 114761 NA 1 2008-11-05
> 3 184440 NA 1 2009-12-08
> 4 189372 NA 0 NA
> 5 105286 NA 0 NA
> 6 186717 NA 0 NA
> 7 189106 NA 0 NA
> 8 127306 NA 0 NA
> 9 157342 2011-04-25 0 NA
>
> I want to replace b[NA] values with "20011-07-28" where c==0. I use
rstudio
> and i'm a novice.
I believe there are better solutions but I would use two steps
select rows where c==0 (see also FAQ 7.31)
sel<-which(big.data.frame$c==0)
change NA values in b column based on sel
big.data.frame$b[sel][is.na(big.data.frame$b[sel])]<-"20011-07-28"
Beware of data types AFAIK R can not accept "20011-07-28" as a date.
Regards
Petr
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/conditional-
> data-replace-recode-change-or-whatsoever-tp3714715p3714715.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
More information about the R-help
mailing list