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
Senior Data Science Manager at Hospital IQ – Planet discoverer, researcher, developer, geek.
You May Also Enjoy
Jupyter: View notebook in terminal
less than 1 minute read
You can use the command line tool jut to view a Jupyter notebook in the terminal.
Nix: Play with jq with jq-play
less than 1 minute read
Use jq-play to dry-run your jq filter and optimize any way you want.
Jupyter: Trust notebook from command line
less than 1 minute read
Jupyter uses a security model where you have to ‘trust’ a notebook before Jupyter will perform certain operations. While you can manually trust each notebook...
Match arguments to help text
less than 1 minute read
explainshell.com is a great website tool where you enter a shell command line to see the help text that matches each argument.
Comments