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
Declare your python dependencies within your Jupyter notebook
less than 1 minute read
Reproducible workflows are simplified with tools like Nix for shell scripts and juv for Jupyter notebooks, enabling dependency declarations directly within s...
Why you should really prepare for your one-on-ones
less than 1 minute read
Maximize the impact of your 1-on-1 meetings by preparing thoroughly, not just with your direct reports but also with your managers, to boost both job perform...
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
Leave a comment