Grouping rows by hours

[DTimothy]

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!

[Felipe_Ribeir0 · Accepted solution]

Hi @DTimothy 

Here is one way of assigning these group periods

[DTimothy]

Thank you, @Felipe_Ribeir0 !

It worked perfectly.