Pandas: Get rows with max value of group
df.groupby('Sp').apply(lambda t: t[t.Count==t.Count.max()])
Via StackOverflow.
Francis T. O'Donovan
Principal Data Scientist at TriNet – Planet discoverer, researcher, developer, geek.
You may also enjoy
Why You’re Not Getting Value from Your Data Science
1 minute read
If companies want to get value from their data, they need to focus on accelerating human understanding of data, scaling the number of modeling questions they...
List only untracked files
less than 1 minute read
Using ls-files
Pandas: Display DataFrames side by side
less than 1 minute read
Using html in a Jupyter Notebook
Pandas: Transforming two DataFrame columns into a dictionary
less than 1 minute read
Using the zip command
Leave a comment