Thanks a lot Jim, this is perfect!! Thank you, Nandini Badarinarayan
> Date: Fri, 29 Apr 2011 09:49:26 -0400 > From: jmac...@med.umich.edu > To: nandini...@hotmail.com > CC: r-help@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@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@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.