🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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

User: "Pradeep_Kankala"
Pradeep_Kankala
New Altair Community Member
Updated by Jocelyn

Timeseries.PNGHow 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

Timeseries.PNG

Find more posts tagged with

AI Studio
Aggregate
Time Series
Getting Started
Sort by:
1 - 2 of 21
    User: "MartinLiebig"
    MartinLiebig
    Altair Employee
    Accepted Answer

    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

    User: "Pradeep_Kankala"
    Pradeep_Kankala
    New Altair Community Member
    OP
    Accepted Answer

    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

     

Quick Links