RapidMiner

How to aggregate time series data to daily/weekly data in Rapidminer

SOLVED
Contributor

How to aggregate time series data to daily/weekly data in Rapidminer

How to aggregate these rows of data into daily or weekly data based on aggregation of all attributes.How to aggregate these rows of data into daily or weekly data based on aggregation of all attributes.

Hello ,

 

I am looking to aggregate the timeseries data of energy consumption which has been recorded for every minute into a daily or weekly average and work on it, as this dataset has humongous rows, i need it to be minimized to days or weekly.
looking forward to hear for guidance.

 

Best Regards,

 

Pradeep

2 REPLIES
Highlighted
Moderator

Re: How to aggregate time series data to daily/weekly data in Rapidminer

Hi,

 

you can first use Date to Numerical to get the #weeks since 1970 (or days). Afterwards you can use the usual aggregate Smiley Happy.

 

Best,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Contributor

Re: How to aggregate time series data to daily/weekly data in Rapidminer

Thank you Schmitz.


mschmitz wrote:

Hi,

 

you can first use Date to Numerical to get the #weeks since 1970 (or days). Afterwards you can use the usual aggregate Smiley Happy.

 

Best,

Martin