On Mon, Feb 27, 2012 at 10:17 PM, knavero <knav...@gmail.com> wrote:
> Here's my code:
>
> http://pastebin.com/0yRxEVtm
>
> The important parts are uncommented and should be easy to find using the
> link above. For the following line of code, I plan on looking for a way to
> offset it up 7 rows so that the 15 minute timestamp would be considered the
> "median" of the subset being averaged to find the mean:
>
> avgCool = aggregate(intCool, trunc(time(intCool), times("00:15:00")), mean)
>
> Currently the issue is that, with the truncate function, it "truncates" but
> really rounds down the time series values to the 15 minute time stamp
> earlier in the series. For example, let's say we have one minute intervals
> 0:00, 0:01, 0:02,....,0:37. It takes 0:00 - 0:14 and replaces that with
> 0:00. Then it sees 0:15, and changes values from 0:15 - 0:29 to 0:15. In
> effect, aggregating the values and creating subsets.
>
> What I want to do here is change 0:00 - 0:07 to 0:00, change 0:08 - 0:22 to
> 0:15, and change 0:23 - 0:37 to 0:30 in which 0:15 and 0:30 are the medians
> of each subset. Anyway, I hope that makes sense. Any ideas on which function
> will make this an easy job? Much thanks in advance.
Add 7.5 minutes before truncating so if x is your times, e.g. x <-
times(0:15/(24 * 60)), then try this:
min15 <- times("00:15:00")
trunc(x + min15/2, min15)
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
______________________________________________
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.
