Just adjust the formula for Qtr appropriately if your quarters are not Jan/Feb/Mar, Apr/May/Jun, Jul/Aug/Sep, Oct/Nov/Dec as I assumed.
On Dec 1, 2007 5:21 PM, Sherri Heck <[EMAIL PROTECTED]> wrote: > Hi Gabor, > > Thank you for your help. I think I need to clarify a bit more. I am > trying to say > > average all 2pms for months march + april + may (for example). I hope this is > clearer. > > here's a larger subset of my data set: > > year, month, hour, co2(ppm), num1,num2 > > 2006 1 0 384.2055 14 14 > 2006 1 1 384.0304 14 14 > 2006 1 2 383.9672 14 14 > 2006 1 3 383.8452 14 14 > 2006 1 4 383.8594 14 14 > 2006 1 5 383.7318 14 14 > 2006 1 6 383.6439 14 14 > 2006 1 7 383.7019 14 14 > 2006 1 8 383.7487 14 14 > 2006 1 9 383.8376 14 14 > 2006 1 10 383.8684 14 14 > 2006 1 11 383.8301 14 14 > 2006 1 12 383.8058 14 14 > 2006 1 13 383.9419 14 14 > 2006 1 14 383.7876 14 14 > 2006 1 15 383.7744 14 14 > 2006 1 16 383.8566 14 14 > 2006 1 17 384.1014 14 14 > 2006 1 18 384.1312 14 14 > 2006 1 19 384.1551 14 14 > 2006 1 20 384.099 14 14 > 2006 1 21 384.1408 14 14 > 2006 1 22 384.3637 14 14 > 2006 1 23 384.1491 14 14 > 2006 2 0 384.7082 27 27 > 2006 2 1 384.6139 27 27 > 2006 2 2 384.7453 26 26 > 2006 2 3 384.9224 28 28 > 2006 2 4 384.8581 28 28 > 2006 2 5 384.9208 28 28 > 2006 2 6 384.9086 28 28 > 2006 2 7 384.837 28 28 > 2006 2 8 384.6163 27 27 > 2006 2 9 384.7406 28 28 > 2006 2 10 384.7468 28 28 > 2006 2 11 384.6992 28 28 > 2006 2 12 384.6388 28 28 > 2006 2 13 384.6346 28 28 > 2006 2 14 384.6037 28 28 > 2006 2 15 384.5295 28 28 > 2006 2 16 384.5654 28 28 > 2006 2 17 384.6466 28 28 > 2006 2 18 384.6344 28 28 > 2006 2 19 384.5911 28 28 > 2006 2 20 384.6084 28 28 > 2006 2 21 384.6318 28 28 > 2006 2 22 384.6181 27 27 > 2006 2 23 384.6087 27 27 > > > thanks you again for your assistance- > > s.heck > > > > Gabor Grothendieck wrote: > > Try aggregate: > > > > > > Lines <- "Year Month Hour co2 num1 num2 > > 2006 11 0 383.3709 28 28 > > 2006 11 1 383.3709 28 28 > > 2006 11 2 383.3709 28 28 > > 2006 11 3 383.3709 28 28 > > 2006 11 4 383.3709 28 28 > > 2006 11 5 383.3709 28 28 > > 2006 11 6 383.3709 28 28 > > 2006 11 7 383.3709 28 28 > > 2006 11 8 383.3709 28 28 > > 2006 11 9 383.3709 27 27 > > 2006 11 10 383.3709 28 28 > > " > > DF <- read.table(textConnection(Lines), header = TRUE) > > aggregate(DF[4:6], > > with(DF, data.frame(Year, Qtr = (Month - 1) %/% 3 + 1, Hour)), > > mean) > > > > On Dec 1, 2007 3:57 PM, Sherri Heck <[EMAIL PROTECTED]> wrote: > > > >> Hi all- > >> > >> I have a dataset (year, month, hour, co2(ppm), num1,num2) > >> > >> > >> [49,] 2006 11 0 383.3709 28 28 > >> [50,] 2006 11 1 383.3709 28 28 > >> [51,] 2006 11 2 383.3709 28 28 > >> [52,] 2006 11 3 383.3709 28 28 > >> [53,] 2006 11 4 383.3709 28 28 > >> [54,] 2006 11 5 383.3709 28 28 > >> [55,] 2006 11 6 383.3709 28 28 > >> [56,] 2006 11 7 383.3709 28 28 > >> [57,] 2006 11 8 383.3709 28 28 > >> [58,] 2006 11 9 383.3709 27 27 > >> [59,] 2006 11 10 383.3709 28 28 > >> > >> that repeats in this style for each month. I would like to compute the > >> mean for each hour in three month intervals. > >> i.e. average all 2pms for each day for months march, april and may. and > >> then do this for each hour interval. > >> i have been messing around with 'for loops' but can't seem to get the > >> output I want. > >> > >> thanks in advance for any help- > >> > >> s.heck > >> CU, Boulder > >> > >> ______________________________________________ > >> R-help@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. > >> > >> > ______________________________________________ R-help@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.