Thanks a lot Duncan, this is what I was looking for!!Thank you,Nandini
> Date: Fri, 29 Apr 2011 09:53:06 -0400
> From: murdoch.dun...@gmail.com
> To: nandini...@hotmail.com
> CC: r-help@r-project.org
> 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]]
______________________________________________
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.
