[R] replace non numeric with "NA"

James W. MacDonald jmacdon at med.umich.edu
Fri Apr 29 15:49:26 CEST 2011


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 



More information about the R-help mailing list