[R] aggregating data with Zoo
Alfonso Sammassimo
cincinattikid at bigpond.com
Wed Mar 28 23:20:23 CEST 2007
Thankyou Achim.
Along these lines, how might I extract subsets from that set by day of week?
eg: create a new series that includes Mondays only.
Thanks,
Alf
----- Original Message -----
From: "Achim Zeileis" <Achim.Zeileis at R-project.org>
To: "Alfonso Sammassimo" <cincinattikid at bigpond.com>
Cc: <r-help at stat.math.ethz.ch>
Sent: Thursday, March 29, 2007 1:16 AM
Subject: Re: [R] aggregating data with Zoo
> On Wed, 28 Mar 2007, Alfonso Sammassimo wrote:
>
>> Is there a way of aggregating 'zoo' daily data according to day of week?
>> eg
>> all Thursdays
>
> Sure, the easiest way will probably differ depending on the time stamp
> class. One example might be this:
> ## small example with Date index
> z <- read.zoo(file.path(.find.package("zoo"), "doc", "demo1.txt"),
> sep = "|", format = "%d %b %Y")
> ## visualization
> plot(z)
> ## aggregate along week days (via POSIXlt representation)
> aggregate(z, as.POSIXlt(time(z))$wday, mean)
>
> hth,
> Z
>
>> I came across the 'nextfri' function in the documentation but am unsure
>> how
>> to change this so any day of week can be aggregated.
>>
>> I have used POSIX to arrange the data (not as 'zoo' series) according to
>> day
>> of week, but am curious if I've missed if a similar option available with
>> zoo.
>>
>> Thank you for any help,
>>
>> Alf Sammassimo
>> Melbourne, Australia
>>
>> ______________________________________________
>> R-help at 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
>> and provide commented, minimal, self-contained, reproducible code.
>>
>>
>
More information about the R-help
mailing list