Thanks a lot Duncan, this is what I was looking for!!Thank you,Nandini
> Date: Fri, 29 Apr 2011 09:53:06 -0400 > From: [email protected] > To: [email protected] > CC: [email protected] > Subject: Re: [R] replace non numeric with "NA" > > On 29/04/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 > > > > > > 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 ? > > You don't tell use the types of the columns, so I'll assume they are > factors. If so, call > > as.numeric(as.character()) > > on each of them to convert the number-like values to numbers, the others > to NA. For example, > > df$day <- as.numeric(as.character(df$day)) > > Duncan Murdoch [[alternative HTML version deleted]] ______________________________________________ [email protected] 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.
