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

Pradeep_KankalaPradeep_Kankala Member Posts: 2 Contributor I
edited June 2019 in Help

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

Best Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist
    Solution Accepted

    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

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Pradeep_KankalaPradeep_Kankala Member Posts: 2 Contributor I
    Solution Accepted

    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


     

Sign In or Register to comment.