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

From: James W. MacDonald <jmacdon_at_med.umich.edu>
Date: Fri, 29 Apr 2011 09:49:26 -0400

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 

______________________________________________
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 - 13:53:09 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 - 16:40:35 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