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
Data Science Manager at Hospital IQ – Planet discoverer, researcher, developer, geek.
You May Also Enjoy
Git: Clone a specific branch
less than 1 minute read
If you want a specific branch of a repo, rather than running:
Nix: Streaming gsutil transfers
less than 1 minute read
Cloud Storage supports streaming transfers, which allow you to stream data to and from your Cloud Storage account without requiring that the data first be...
SQL: Calculate percentage of column
less than 1 minute read
```sql Starting with a table. select * from sales; +——-+——+ | rep | sale | +——-+——+ | Bob | 15 | | Sally | 30 | | Peter | 15 | +——-+——+ Use a ...
SQL: Select a random sample
less than 1 minute read
To pick a random subsample of 1,000 rows from a table:
Comments