Re: [R] Creating quarterly data

Thanks, Allan, that did the trick :) Best, Thomas On Jun 28, 2010, at 6:13 PM, Allan Engelhardt wrote: One approach: d <- data.frame(x1=c(2,3,4,1,5,8), x2=c(4,1,6,4,6,5), time=1:6) d$quarter <- (d$time-1) %/% 4 # Or whatever your logic is aggregate(cbind(x1,x2) ~ quarter, data = d, sum) #

Re: [R] Creating quarterly data

One approach: d <- data.frame(x1=c(2,3,4,1,5,8), x2=c(4,1,6,4,6,5), time=1:6) d$quarter <- (d$time-1) %/% 4 # Or whatever your logic is aggregate(cbind(x1,x2) ~ quarter, data = d, sum) # quarter x1 x2 # 1 0 10 15 # 2 1 13 11 Hope this helps Allan On 28/06/10 13:23, Thomas Jen

[R] Creating quarterly data

Dear R Experts, I have data in the following format x1 x2 time 2 4 1 3 1 2 4 6 3 1 4 4 5 6 5 8 5 6 . . . . . . . . . 1 5 399 3 4 400 Time r