RapidMiner

Learner I jricgar
Learner I

Counting events by date

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.

3 REPLIES
Community Manager Community Manager
Community Manager

Re: Counting events by date

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

--
Balázs Bárány
Data Scientist, Vienna
https://datascientist.at
Learner I jricgar
Learner I

Re: Counting events by date

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

 

Thanks for your help Smiley Happy

Highlighted
Community Manager Community Manager
Community Manager

Re: Counting events by date

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

 

--
Balázs Bárány
Data Scientist, Vienna
https://datascientist.at
Polls
How can RapidMiner increase participation in our new competitions?
Twitter Feed