Resolved: Python pandas: shows rows based on unique values

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.

Answer:

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

If you have better answer, please add a comment about this, thank you!

Resolved: Python pandas: shows rows based on unique values

Resolved: Reshape tensors of unknown shape with tf.function

Resolved: Use Svelte Component as Slot

Resolved: Vaadin 14.9 – Redirect on Session Destroy Event

Leave A Reply