[R] Counting the number of non-NA values per day
    Tim Chatterton 
    tim.chatterton at uwe.ac.uk
       
    Tue Aug 11 19:26:14 CEST 2009
    
    
  
I have a long dataframe ("pollution") that contains a column of hourly 
date information ("date") and  a column of  pollution  measurements ("pol")
I have been happily calculating daily means and daily maximums using the 
aggregate function
 DMEANpollution =  aggregate(pollution["pol"], 
format(pollution["date"],"%Y-%j"), mean, na.rm = TRUE)
 DMAXpollution =  aggregate(pollution["pol"], 
format(pollution["date"],"%Y-%j"), max, na.rm = TRUE)
However, I also need to count the number of valid measurements for each 
day to check that the mean and max are likely to be valid (for example I 
need at least 18 hourly measurements to calculate a valid daily mean)
Try as I might I have not found a simple way of doing this.
Can anybody help please?
Many thanks,
Tim.
-- 
__________________________________________
Dr Tim Chatterton
Senior Research Fellow
Air Quality Management Resource Centre
Faculty of Environment and Technology
University of the West of England
Frenchay Campus
Bristol
BS16 1QY
Tel: 0117 328 2929
Fax: 0117 328 3360
Email: Tim.Chatterton at uwe.ac.uk
    
    
More information about the R-help
mailing list