Aggregating, restructuring hourly time series data in R

Posted by Advait Godbole on Stack Overflow See other posts from Stack Overflow or by Advait Godbole
Published on 2012-03-26T04:49:17Z Indexed on 2012/03/26 17:29 UTC
Read the original article Hit count: 379

Filed under:

r

|

time-series

I have a year's worth of hourly data in a data frame in R:

> str(df.MHwind_load)   # compactly displays structure of data frame
'data.frame':   8760 obs. of  6 variables:
 $ Date         : Factor w/ 365 levels "2010-04-01","2010-04-02",..: 1 1 1 1 1 1 1 1 1 1 ...
     $ Time..HRs.   : int  1 2 3 4 5 6 7 8 9 10 ...
 $ Hour.of.Year : int  1 2 3 4 5 6 7 8 9 10 ...
     $ Wind.MW      : int  375 492 483 476 486 512 421 396 456 453 ...
 $ MSEDCL.Demand: int  13293 13140 12806 12891 13113 13802 14186 14104 14117 14462 ...
     $ Net.Load     : int  12918 12648 12323 12415 12627 13290 13765 13708 13661 14009 ...

While preserving the hourly structure, I would like to know how to extract

a particular month/group of months
the first day/first week etc of each month
all mondays, all tuesdays etc of the year

I have tried using "cut" without result and after looking online think that "lubridate" might be able to do so but haven't found suitable examples. I'd greatly appreciate help on this issue.

Related posts about time-series

How to remove some of the TimeSeries titles in a AChartEngine Time Series View

as seen on Stack Overflow - Search for 'Stack Overflow'
As a workaround of not being able to change colors of selected points in a series on an AChartEngine Time Chart, I was using an additional series for each point whose color has to be changed. I need to disable series titles for those additional series. Using empty string as the argument to the… >>> More
Converting a ts (Time Series) object to a Vector in R

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to use a function on a vector that does not take a ts object. I'm trying to convert it to a plain old vector but I just can't seem to figure it out. I googled around but mostly people are trying to convert data types into ts object. I want to go the other way. Any help would be appreciated. >>> More
Best Data Structure For Time Series Data

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I wonder if someone could take a minute out of their day to give their two cents on my problem. I would like some suggestions on what would be the best data structure for representing, on disk, a large data set of time series data. The main priority is speed of insertion, with other priorities… >>> More
R Question: calculating deltas in a timeseries

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a timeseries of samples in R: > str(d) 'data.frame': 5 obs. of 3 variables: $ date: POSIXct, format: "2010-03-04 20:47:00" "2010-03-04 21:47:00" ... $ x : num 0 10 11 15.2 20 $ y : num 0 5 7.5 8.4 12.5 > d date x y 1 2010-03-04 20:47:00 0.0 0.0 2 2010-03-04… >>> More
jfreechart time series chart with events

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using jfreechart (specially ChartFactory.createTimeSeriesChart()). Is there a way to signal events like Google Finance charts, see the A, B, C etc on the right and in the chart. >>> More

Developer IT

Aggregating, restructuring hourly time series data in R - Developer IT

Aggregating, restructuring hourly time series data in R

r

time-series

Related posts about r

Related posts about time-series

How to remove some of the TimeSeries titles in a AChartEngine Time Series View

Converting a ts (Time Series) object to a Vector in R

Best Data Structure For Time Series Data

R Question: calculating deltas in a timeseries

jfreechart time series chart with events

Categories cloud