For my dataset I need to select the video with the most viewers in a specific category. The dataset kinda looks like this:
User Status Video
1 x 1
2 y 2
3 x 2
4 a 1
5 y 2
I need to figure out which video has the most users in status y. How do I select the most occurrences of x?
I already tried groupby('status') and then count()['video'] but that seems to not be right.