My dataframe looks as above. I want to group the data by using Hour2 column and show the count for each Light_condition category in front of it. But not able to figure how is to be done. I want something like:
Night- time |category-name| category count