[R] subsetting by NA

Spencer Graves spencer.graves at pdf.com
Fri Feb 25 18:12:33 CET 2005


      Have you considered "is.na"? 

      My favorite tool for answering questions like this is 
www.r-project.org -> search -> "R site search".  When I asked there for 
"subsetting by NA" just now, I got 101 hits, the third of which 
mentioned "is.na".  Also, the posting guide 
"R-project.org/posting-guide.html" gives other useful tips for how to 
find information about R. 

      hope this helps.  spencer graves

Benjamin M. Osborne wrote:

>I want to know where all the NAs are in a matrix.  The data frame looks like
>this:
>
>  
>
>>vmc[1:5,]
>>    
>>
>       date year month day snow.new prcp      tmin snow.dep       tmax
>1 01NOV1954 1954    11   1       NA   NA -14.44444       NA 12.2222222
>2 02NOV1954 1954    11   2       NA   NA -13.88889       NA  2.2222222
>3 03NOV1954 1954    11   3       NA   NA -16.66667       NA -1.1111111
>4 04NOV1954 1954    11   4       NA   NA        NA       NA -0.5555556
>5 05NOV1954 1954    11   5       NA   NA -17.22222       NA -2.7777778
>       tmean yearmo
>1  -1.111111 195411
>2  -5.833333 195411
>3  -8.888889 195411
>4         NA 195411
>5 -10.000000 195411
>  
>
>
>This does not work:
>  
>
>>subset(vmc, snow.new==NA)
>>    
>>
> [1] date     year     month    day      snow.new prcp     tmin     snow.dep
> [9] tmax     tmean    yearmo
><0 rows> (or 0-length row.names)
>
>
>Because:
>  
>
>>NA==NA
>>    
>>
>[1] NA
>
>How can I return all rows of this data frame that contain NA in a particular
>field?
>
>Thanks,
>Ben Osborne
>
>  
>




More information about the R-help mailing list