Find maximum value of a column and return the corresponding row values using Pandas
Using Python Pandas I am trying to find the 'Country' & 'Place' with the maximum value.
This returns the maximum value:
But how do I get the corresponding 'Country' and 'Place' name?
df has a unique index, this gives the row with the maximum value:
In : df.loc[df['Value'].idxmax()] Out: Country US Place Kansas Value 894 Name: 7
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.
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
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()
★ Back to homepage or read more recommendations: