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

Pradeep_Kankala

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

MartinLiebig

Hi,

 

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

 

Best,

Martin

Pradeep_Kankala

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 .

 

Best,

Martin

---

 

MartinLiebig

Hi,

 

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

 

Best,

Martin

Pradeep_Kankala

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 .

 

Best,

Martin

---