[R] remove missing values from matrix or data frame

[Spencer Graves]

      How about the following: 

 > (A <- array(c(1, NA, 3, NA, 4, 5), dim=c(3,2)))
     [,1] [,2]
[1,]    1   NA
[2,]   NA    4
[3,]    3    5
 > A[apply(A, 1, function(x)!any(is.na(x))), , drop=F]
     [,1] [,2]
[1,]    3    5

      hope this helps.  spencer graves

William Briggs wrote:

>
> Is there any way besides looping to remove complete rows from a matrix 
> or data frame where there is at least one NA in any of the columns?
>
> For example
> > a
>        [,1]     [,2]
>   [1,] 0        2.6875
>   [2,] 8.366667 6.625
>   [3,] 15.6     4.375
>   [4,] 23.4     6.25
>   [5,] 29       5.09375
>   [6,] 18       NA
>   [7,] 0        4.15625
>   [8,] 9.366667 6.25
>   [9,] 14.73333 5.875
>  [10,] 31.26667 6.15625
>  [11,] NA       2.357
>  [12,] NA       5.4234
>  [13,] 0        3.34375
>  [14,] 7.666667 2.78125
>  [15,] NA       NA
>
> In a, rows 6, 11, 12, and 15 should be removed.
>
> na.omit(a) does nothing, nor does na.omit(as.data.frame(a)).  I can 
> get a matrix of which are NA and not by "i<-!is.na(a)", but this 
> doesn't seem to help ("a[i]" isn't the thing I'm after).
>
> I know I am missing something simple and standard, but I haven't been 
> able to see it yet (nor on Google).
>
> Thanks.
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html


-- 
Spencer Graves, PhD, Senior Development Engineer
O:  (408)938-4420;  mobile:  (408)655-4567