[R] efficient is.na tabulation?

Chuck Cleland ccleland at optonline.net
Mon Feb 25 15:04:30 CET 2008


On 2/25/2008 8:59 AM, Angelo Passalacqua wrote:
> I am aware of
> 
> table(is.na(df$var))
> 
> but is there an efficient way of create a table that shows the number of
> missing values in each variable of a data frame?
> 
> Right now I am forced to create a new variable, varna<-is.na(df$var), for
> each variable of the data frame, bind them to a new data frame and tabulate
> it, but surely there is a simpler way?
> 
> any help is greatly appreciated,
> angelo

   Are you looking for colSums(is.na(df)) or colMeans(is.na(df)) ?  The 
is.na function can be applied to whole data frames.

> 	[[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. 

-- 
Chuck Cleland, Ph.D.
NDRI, Inc.
71 West 23rd Street, 8th floor
New York, NY 10010
tel: (212) 845-4495 (Tu, Th)
tel: (732) 512-0171 (M, W, F)
fax: (917) 438-0894



More information about the R-help mailing list