The Altair Community and the RapidMiner community is on read-only mode until further notice. 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
Finding Frequency of a datatype
I'm working with data that is essentially a bunch of timestamps for checkins. I've separated the dates into separate variables for month, day, hour but for the past hour I've been trying (to no avail) to basically convert this data into a format similar to what is displayed on a histogram.
Currently my data looks similar to this:
Month | Day | Hour
1 |1 | 1
1 |1 | 1
1 |1 | 1
1 |1 | 4
1 |1 | 4
1 |1 | 5
How do I convert in into data similar to this:
Month | Day | Hour | Frequency
1 |1 |1 | 3
1 |1 |2 | 0
1 |1 |3 | 0
1 |1 |4 | 2
1 |1 |5 | 1
Any help will be much appreciated, thank you so much
Currently my data looks similar to this:
Month | Day | Hour
1 |1 | 1
1 |1 | 1
1 |1 | 1
1 |1 | 4
1 |1 | 4
1 |1 | 5
How do I convert in into data similar to this:
Month | Day | Hour | Frequency
1 |1 |1 | 3
1 |1 |2 | 0
1 |1 |3 | 0
1 |1 |4 | 2
1 |1 |5 | 1
Any help will be much appreciated, thank you so much
![:) :)](https://community.rapidminer.com/resources/emoji/smile.png)
0
Answers