Pandas GroupBy and select rows with the minimum value in a specific column

by

I feel like you’re overthinking this. Just use groupby and idxmin:

df.loc[df.groupby('A').B.idxmin()]

   A  B   C
2  1  2  10
4  2  4   4

df.loc[df.groupby('A').B.idxmin()].reset_index(drop=True)

   A  B   C
0  1  2  10
1  2  4   4

More Related Contents:

  1. How can I pivot a dataframe?
  2. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  3. How do I create a new column from the output of pandas groupby().sum()?
  4. GroupBy pandas DataFrame and select most common value
  5. Pandas GroupBy.apply method duplicates first group
  6. pandas GroupBy columns with NaN (missing) values
  7. Count unique values per groups with Pandas [duplicate]
  8. How to access pandas groupby dataframe by key
  9. group by pandas dataframe and select latest in each group
  10. why does pandas rolling use single dimension ndarray
  11. Group dataframe and get sum AND count?
  12. Sample each group after pandas groupby
  13. Pandas groupby with categories with redundant nan
  14. Is there an “ungroup by” operation opposite to .groupby in pandas?
  15. get first and last values in a groupby
  16. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  17. Get the row corresponding to the max in pandas GroupBy [duplicate]
  18. How to get number of groups in a groupby object in pandas?
  19. Aggregation in Pandas
  20. Pandas groupby mean – into a dataframe?
  21. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  22. Make Pandas groupby act similarly to itertools groupby
  23. Python pandas – filter rows after groupby
  24. Pandas groupby nlargest sum
  25. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  26. group by week in pandas
  27. Pandas groupby to to_csv
  28. Pandas groupby with bin counts
  29. Pandas groupby and qcut
  30. how to convert monthly data to quarterly in pandas

Leave a Comment