I have a dataframe
Index hour Disconnection
0 8 Key press
1 8 Key press
2 8 Key press
3 8 Key press
4 8 Key press
5 8 Key press
6 8 Abandon
7 8 Abandon
8 8 Abandon
9 8 Key press
10 8 Abandon
11 8 Key press
12 8 Key press
13 8 Key press
14 9 Abandon
15 9 Abandon
16 9 Key press
17 9 Abandon
18 9 Key press
19 9 Key press
20 9 Key press
I need to first group by hour and then create 2 columns that will take the values from 'Disconnection' which are Key press or Abandon then count each value per hour interval
the result should look like this:
