Thanks for the brilliant solution. ***AGAIN***
Now - just to go deeper into the **same subject** on which I'm really supposed to work very soon - if I want to aggregate by date only data, say, before noon (12.00.00) what should I do? Ciao Vittorio Alle 16:13, venerdì 07 aprile 2006, Whit Armstrong ha scritto: > aggregate(base,by=list(as.factor(format(dates(base),"%Y%m%d"))),mean,na. > rm=T) > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Vittorio > Sent: Friday, April 07, 2006 11:38 AM > To: r-help@stat.math.ethz.ch > Subject: [R] Aggregating an its series > > I'm using a very long irregular time-series of air temperature and > relative humidity of this kind (this is an extract only) > > its.format("% > Y%d%m %X) > > > base > > T H > 20020601 12.00.00 27.1 47 > 20020601 15.00.00 29.1 39 > 20020601 18.00.00 27.4 39 > 20020601 21.00.00 24.0 40 > 20020602 0.00.00 22.0 73 > 20020602 3.00.00 19.2 49 > 20020602 6.00.00 19.5 74 > 20020602 9.00.00 24.8 45 > 20020602 12.00.00 27.7 NA > 20020602 15.00.00 29.2 39 > 20020602 18.00.00 27.2 44 > 20020602 21.00.00 23.9 50 > 20020603 0.00.00 21.0 75 > 20020603 3.00.00 19.6 65 > 20020603 6.00.00 19.8 71 > 20020603 9.00.00 23.2 67 > 20020603 12.00.00 24.9 65 > 20020603 15.00.00 21.7 74 > 20020603 18.00.00 22.8 63 > 20020603 21.00.00 21.2 75 > 20020604 0.00.00 18.0 91 > > I would like to > aggregate T and H by day and produce another its of this kind > > > aggr > > T H > 20020601 NA NA > 20020602 NA NA > 20020603 NA NA > 20020604 NA NA > > where the daily average of T and H (not counting the NA > values) is is put in aggr. > > What is the quickest way to get this > result? > > Thanks > > Vittorio > > ______________________________________________ > 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 ______________________________________________ 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