Hello,
I have a large dataset, and I’m trying to group rows based on hours.
I’ve split the date and time as I don’t need date, so now I have the data as follows:
Time Count
00:58:02 452
06:38:01 716
13:44:06 24
15:14:23 8
I have approximately 18,000 rows and would like to generate four rows into time periods as follows:
Row 1: 00:00:00 – 05:59:00
Row 2: 06:00:00 – 11:59:59
Row 3: 12:00:00 – 17:59:59
Row 4: 18:00:00 – 24:00:00
The time field is Time datatype, and Count is Int64
Is it possible to group these with the corresponding counts for these time periods?
Thank you!
