Re: [R] Quick recode of -999 to NA in R

From: Uwe Ligges <ligges_at_statistik.tu-dortmund.de>
Date: Wed, 30 Mar 2011 15:24:04 +0200

On 30.03.2011 15:15, Christopher Desjardins wrote:
> Hi,
> I am trying to write a loop to recode my data from -999 to NA in R. What's
> the most efficient way to do this? Below is what I'm presently doing, which
> is inefficient. Thanks,
> Chris

I think read.table(na.string="-999.00000000") is.

Uwe Ligges

>
> dat0<- read.table("time1.dat")
>
> colnames(dat0)<- c("e1dq", "e1arcp", "e1dev", "s1prcp", "s1nrcp", "s1ints",
> "a1gpar", "a1pias", "a1devt")
>
> dat0[dat0$e1dq==-999.00000000,"e1dq"]<- NA
>
> dat0[dat0$e1arcp==-999.00000000,"e1arcp"]<- NA
>
> dat0[dat0$e1dev==-999.00000000,"e1dev"]<- NA
>
> dat0[dat0$s1prcp==-999.00000000,"s1prcp"]<- NA
>
> dat0[dat0$s1nrcp==-999.00000000,"s1nrcp"]<- NA
>
> dat0[dat0$s1ints==-999.00000000,"s1ints"]<- NA
>
> dat0[dat0$a1gpar==-999.00000000,"a1gpar"]<- NA
>
> dat0[dat0$a1pias==-999.00000000,"a1pias"]<- NA
>
> dat0[dat0$a1devt==-999.00000000,"a1devt"]<- NA
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.



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. Received on Wed 30 Mar 2011 - 13:29:47 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 30 Mar 2011 - 13:30:29 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive