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