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!
Solucionado! Ir para Solução.
Thank you, @Felipe_Ribeir0 !
It worked perfectly.