Find maximum value of a column and return the corresponding row values using Pandas

by

Assuming df has a unique index, this gives the row with the maximum value:

In [34]: df.loc[df['Value'].idxmax()]
Out[34]: 
Country        US
Place      Kansas
Value         894
Name: 7

Note that idxmax returns index labels. So if the DataFrame has duplicates in the index, the label may not uniquely identify the row, so df.loc may return more than one row.

Therefore, if df does not have a unique index, you must make the index unique before proceeding as above. Depending on the DataFrame, sometimes you can use stack or set_index to make the index unique. Or, you can simply reset the index (so the rows become renumbered, starting at 0):

df = df.reset_index()

More Related Contents:

  1. Find the column name which has the maximum value for each row
  2. Set maximum value (upper bound) in pandas DataFrame
  3. return max value from pandas dataframe as a whole, not based on column or rows
  4. Get max value from row of a dataframe in python [duplicate]
  5. error when applying function to a series object
  6. Groupby value counts on the dataframe pandas
  7. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  8. How to add pandas data to an existing csv file?
  9. How to explode a list inside a Dataframe cell into separate rows
  10. How to print pandas DataFrame without index
  11. Reversing ‘one-hot’ encoding in Pandas
  12. Repeat rows in a pandas DataFrame based on column value
  13. Accessing every 1st element of Pandas DataFrame column containing lists
  14. Update a dataframe in pandas while iterating row by row
  15. Conditionally format Python pandas cell
  16. How to concatenate multiple column values into a single column in Pandas dataframe
  17. How to create a dictionary of two pandas DataFrame columns
  18. How can I use cumsum within a group in Pandas?
  19. Pandas dataframe – running sum with reset
  20. What is dtype(‘O’), in pandas?
  21. Why does df.apply(tuple) work but not df.apply(list)?
  22. Merge a list of pandas dataframes
  23. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  24. Move column by name to front of table in pandas
  25. Convert List to Pandas Dataframe Column
  26. How to repeat a Pandas DataFrame?
  27. Get column name where value is something in pandas dataframe
  28. dataframe to dict such that one column is the key and the other is the value [duplicate]
  29. Is there a way to speed up handling large CSVs and dataframes in python?
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment