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

Counting events by date

jricgarjricgar Member Posts: 2 Contributor I
edited December 2018 in Help

Hi all,

 

I have a exampleset with events including this properties:

- ID

- Init time

- End time

- Type of event

...

 

I want to detect anomalies based on the number of these event by date. But aggegrating these events using standar aggregation operator (by date) only takes into account dates with events, and there are quite dates dont have any. So, I suposse before aggregating I need to outer join events exampleset with a list of dates (between first and last day), because there are some days without events that have to be taken into account. How can I create this dates list? ¿Any other way to aggregate or count events in ALL days?

 

Thanks in advance.

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

    Hi!

    Yes, an outer join with the additional dates you need is the standard procedure, just like with a database.

    Aggregate will only work on the elements that are in the input.

     

    Regards,

    Balázs

  • Options
    jricgarjricgar Member Posts: 2 Contributor I

    That is what I thought. And, what would be the easiest way to get that list/exampleset using RM operators?

     

    Thanks for your help :)

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

    There's a Generate Date Series operator in the Operator Toolbox extension.

     

Sign In or Register to comment.