The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

Time/Rolling Window Calculations

igauzigauz Member Posts: 1 Contributor I
edited November 2018 in Help
Hi - I'm new to RapidMiner! I've some time series/tick data and wish to calculate rolling mean or run a custom aggregation function over last few minutes/hours of tick data. How can I do that? Or is there a way I can specify a frequency to re-sample the data (say '5m') and then do a rolling mean over the end result?

I've seen the Window feature but that seems to be based on event count and doesn't aggregate by time interval components (days, minutes, hours, etc).

Answers

  • Options
    JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    Several ways to do this

    I would suggest an easy way which would be to create an attribute which groups your customer time frequencies together - o for example you might use date to numerical to convert your dates to minutes from epoch, otherwise generate attributes. 
    Next perform your aggregation of that data grouped by your grouping attribute, then use the Moving Average operator with a window of (5 for 5 minute intervals) to calculate the values you want. 

    Also the Moving Average operator is a bit sneaky in it's name it can also perform sum, variance, std dev, etc so isn't just limited to averages. 
Sign In or Register to comment.