How to count daily occurrences?
Hi,
I have a data source where each row consists of a id and a date . How do I get the amount of ids per day; so that i can work on this time serie.
Thank you
Tagged:
0
💬0 Comments | 🔥0 Discussions | 👤0 Members | 🔌0 Online |
Hi,
I have a data source where each row consists of a id and a date . How do I get the amount of ids per day; so that i can work on this time serie.
Thank you
Answers
hello @puserc - so without the ability to look at your data and your process (did you read the instructions when you were posting this message? ), it is hard to say exactly. It sounds like you need to do a simple Aggregate by day. But you may need to add a new feature if you have more than one timestamp per day. Can you please post the data and XML?
Scott
Hi @puserc,
Like @sgenzer said, you need a simple aggregation.
However, I assume you have datetimes somewhere, so here is an example for you, a process that generates the day, month and year separately, creates an aggregation filtering by these columns, generating dates from days, months and years, and selecting only the required fields. The only "weird" thing I used was the Create ExampleSet operator that is included in the Operator Toolbox extension of RapidMiner, but you can get rid of it and connect your data.
That way you'll have a lot to work with.
All the best,