Python Pandas: Get index of rows which column matches certain value (max)

Asked Dec 20 '16 at 09:09

Active Dec 20 '16 at 09:10

Viewed 303 times

I am trying to get the index of the row that has the maximum value in the column '% Renewable'. This is the dataframe:

df = pd.DataFrame({'% Renewable': [np.NaN, 12, np.NaN, 11, 17, 62, 18, 15, np.NaN, 2, np.NaN, np.NaN, 6, np.NaN, 70]},
   index=['China', 'United States', 'Japan', 'United Kingdom', 'Russian Federation', 'Canada', 'Germany', 'India', 'France', 'South Korea', 'Italy', 'Spain', 'Iran', 'Australia', 'Brazil'])

I get the maximum value using the max method:

 df[['% Renewable']].max()

'70' is the maximum value and it is associated to the index key 'Brazil'. But which command line does return 'Brazil'? My try:

df[df['% Renewable'] == float(70)].index.tolist()

Unfortunately, I get an empty list. Any idea?

asked Dec 20 '16 at 09:09

Antonio Serrano

4

You need `print (df['% Renewable'].idxmax())` – jezrael Dec 20 '16 at 09:10
@jezrael how to get both? id as well as value? – Mohammad Yusuf Dec 20 '16 at 09:12
1

Then use `loc` - `print (df.loc[df['% Renewable'].idxmax()])` – jezrael Dec 20 '16 at 09:13
1

@jezrael thanks :). Can you answer this one better: http://stackoverflow.com/questions/41236061/python-pandas-how-to-combine-the-pandas-with-the-same-column-value – Mohammad Yusuf Dec 20 '16 at 09:15
thank you for tip. I answer it. – jezrael Dec 20 '16 at 09:19
@jezrael :D. I knew you might be knowing some better trick :P – Mohammad Yusuf Dec 20 '16 at 09:19
@Antonio Serrano - If duplicates answer does not help or need something else, be free modify question and give me a comment, I can reopen your question. – jezrael Dec 20 '16 at 09:22
It works! Many thanks @jezrael :) – Antonio Serrano Dec 20 '16 at 09:58

Python Pandas: Get index of rows which column matches certain value (max)

0 Answers0