Re: [R] replace non numeric with "NA"

From: Nandini B <nandini_bn_at_hotmail.com>
Date: Fri, 29 Apr 2011 21:03:10 +0530

Thanks a lot Jim, this is perfect!!

Thank you,
Nandini Badarinarayan

> Date: Fri, 29 Apr 2011 09:49:26 -0400
> From: jmacdon_at_med.umich.edu
> To: nandini_bn_at_hotmail.com
> CC: r-help_at_r-project.org
> Subject: Re: [R] replace non numeric with "NA"
>
> Hi Nandini,
>
> On 4/29/2011 6:45 AM, Nandini B wrote:
> >
> > Hello,
> > I have a sample data frame which looks like this
> > day od month
> > 1 1 0.1 2
> > 2 3 #VALUE! 1
> > 3 5 0.4 12
> > 4 7 0.8 10
> > 5 11 - 3
> > 6 14 s 7
> > 7 18 -- 12
> > 8 27 19 7
> >
>
> > x <- data.frame(day=1:8, od =
> c(0.1,"#VALUE!",0.4,0.8,"-","s","--",19), month = c(2,1,12,10,3,7,12,7))
> > x
> day od month
> 1 1 0.1 2
> 2 2 #VALUE! 1
> 3 3 0.4 12
> 4 4 0.8 10
> 5 5 - 3

> 6 6 s 7
> 7 7 -- 12
> 8 8 19 7
> > x$od <- as.numeric(as.character(x$od))
> Warning message:
> NAs introduced by coercion
> > x
> day od month
> 1 1 0.1 2
> 2 2 NA 1
> 3 3 0.4 12
> 4 4 0.8 10
> 5 5 NA 3
> 6 6 NA 7
> 7 7 NA 12
> 8 8 19.0 7
>
>
> Best,
>
> Jim
>
>
> >
> > Now i wish to filter all the non numeric values and replace it with "NA". The data frame is actually huge and the non numeric characters vary from "-" to a string to absolutely anything!!!
> > Can anyone please help ?
> >
> >
> >
> >
> > Thank you,
> > Warm Regards,
> >
> > Nandini
> >
> >
> >
> > [[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.
>
> --
> James W. MacDonald, M.S.
> Biostatistician
> Douglas Lab
> University of Michigan
> Department of Human Genetics
> 5912 Buhl
> 1241 E. Catherine St.
> Ann Arbor MI 48109-5618
> 734-615-7826
> **********************************************************
> Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues
>
                                               

        [[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. Received on Fri 29 Apr 2011 - 15:38:15 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 Fri 29 Apr 2011 - 17:30:34 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