0

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.

mozway
  • 194,879
  • 13
  • 39
  • 75

0 Answers0