RE: [R] remove missing values from matrix or data frame

From: Berton Gunter <gunter.berton_at_gene.com>
Date: Wed 10 Nov 2004 - 09:31:33 EST

?na.omit

as in A<-na.omit(A)

"The business of the statistician is to catalyze the scientific learning process." - George E. P. Box    

> -----Original Message-----
> From: r-help-bounces@stat.math.ethz.ch
> [mailto:r-help-bounces@stat.math.ethz.ch] On Behalf Of Spencer Graves
> Sent: Tuesday, November 09, 2004 2:19 PM
> To: William Briggs
> Cc: r-help@stat.math.ethz.ch
> Subject: Re: [R] remove missing values from matrix or data frame
>
> 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@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
>
> ______________________________________________
> R-help@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
>



R-help@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 Received on Wed Nov 10 09:47:05 2004

This archive was generated by hypermail 2.1.8 : Wed 10 Nov 2004 - 11:09:26 EST