Python pandas: shows rows based on unique values [duplicate]

Question

I'm a new Python learner, and I can't figure out how to do this.

Let's say I have a data frame like this:

week  category  title  hours_viewed
1     Eng       aaa    100
2     Eng       aaa    95
3     Non-Eng   bbb    105
4     Non-Eng   bbb    100
5     Eng       ccc    80
6     Eng       ccc    115

I want to select rows only for each title with most hours_viewed, the result will look like this:

week  category  title  hours_viewed
1     Eng       aaa    100
3     Non-Eng   bbb    105
6     Eng       ccc    115

Thank you in advance.

Naveed · Accepted Answer · 2022-06-17 00:04:15Z

0

here is one way to do it

using groupby, we take the max across category & title and then comparing the result with the original df.

df[df['hours_viewed'].eq(df.groupby(['category','title']).hours_viewed.transform(max))]

    week    category    title   hours_viewed
0   1       Eng         aaa     100
2   3       Non-Eng     bbb     105
5   6       Eng         ccc     115

answered Jun 17, 2022 at 0:04

Naveed

11.7k2 gold badges16 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python pandas: shows rows based on unique values [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related