Richard Herron
Richard Herron

Reputation: 10092

Aggregate by week in R

In R I frequently aggregate daily data (in a zoo) by month, using something like this:

result <- aggregate(x, as.yearmon, "mean", na.rm=TRUE)

Is there a way that I can do this by week?

Upvotes: 17

Views: 7970

Answers (1)

Shane
Shane

Reputation: 100154

The easiest thing to do is to use the apply.weekly function from xts.

> apply.weekly(zoo(1:10, as.Date("2010-01-01") + 1:10), mean)
2010-01-03 2010-01-10 2010-01-11 
         3         42         10

Upvotes: 24

Related Questions