[R] counting missing values
Thomas Lumley
tlumley at u.washington.edu
Thu Jun 5 17:57:49 CEST 2003
On Thu, 5 Jun 2003, Uwe Ligges wrote:
> vincent.stoliaroff at socgen.com wrote:
>
> > Hello R lovers
> > I have written a little cute function to count the number of missing value
> > per row in a matrix and return the percentage of missing value
> >
> > it takes a lot of time to run with a 1000 rows matrix
> >
> > I'd like to know if there is a function already implemented to count the
> > number of occurence of a given values in a vector
> >
> >
> > For information,
> > here is the function
> > count<-0
> > for (i in 1:nrow(Matrix))
> > {
> > for (j in 1:ncol(Matrix)) {if (is.na(Matrix[i,j])) count<-count+1}
> > Result[i,1]<-((count/(ncol(Matrix)))*100);
> > count<-0
> > }
> > Result
> >
> > thanks for any help
> > Vincent
>
> Well, it's pretty easy to do it:
>
> apply(Matrix, 1, function(x) sum(is.na(x))) / ncol(Matrix) * 100
>
and
rowMeans(is.na(Matrix))*100
should be faster
-thomas
More information about the R-help
mailing list