max() simply returns the maximum value.

idmax() returns the index of the (first occurrence of the) maximum value, not the maximum value itself.

Hi @charlesd, You can try the following: df.iloc[df['column_name'].idxmax()] idxmax() will return the index position of the row with the highest value. Then you can use iloc to return the row with that index. WARNING: If there are multiple max values this method will only return the first row w…

It's not that big a dataset, just load it into pandas, e.g.: In []: import pandas as pd df = pd.read_csv('kills.csv') df.groupby('Killer').count().Victim.idxmax() Out[]: 'SKT Bang'

I got the same error when I used idmax(). The actual function is idxmax(), use this and the error will disappear.

Use DataFrame.agg with idxmax and max:

Copydf = df.agg(['idxmax','max'],axis=1)
print (df)
           idxmax max
Student1    Test6   9
Student2    Test2   7
Student3    Test3   9
Student4    Test1   8
Student5    Test3   9
Student6   Test10   9
Student7    Test4   9
Student8    Test6   9
Student9    Test2   8
Student10   Test4   9

---

Copydf1 = df.agg(['idxmax','max'],axis=1).astype({'max':int}).nlargest(5, 'max')
print (df1)

          idxmax  max
Student1   Test6    9
Student3   Test3    9
Student5   Test3    9
Student6  Test10    9
Student7   Test4    9