Get the index of maximum value in DataFrame column

Pandas DataFrame is two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns).

Let’s see how can we get the index of maximum value in DataFrame column.

Observe this dataset first. We’ll use ‘Weight’ and ‘Salary’ columns of this data in order to get the index of maximum values from a particular column in Pandas DataFrame.



filter_none

edit
close

play_arrow

link
brightness_4
code

# importing pandas module 
import pandas as pd 
    
# making data frame 
  
df.head(10)

chevron_right


Code #1: Check the index at which maximum weight value is present.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing pandas module 
import pandas as pd 
    
# making data frame 
df = pd.read_csv("nba.csv")
  
# Returns index of maximum weight
df[['Weight']].idxmax()

chevron_right


Output:

We can verify whether the maximum value is present in index or not.

filter_none

edit
close

play_arrow

link
brightness_4
code

   
# importing pandas module 
import pandas as pd 
     
# making data frame 
df = pd.read_csv("nba.csv")
   
# from index 400 to 409
df.iloc[400:410]

chevron_right


Output:

 
Code #2: Let’s insert a new row at index 0, having maximum salary and then varify.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing pandas module 
import pandas as pd 
     
# making data frame 
df = pd.read_csv("nba.csv")
  
new_row = pd.DataFrame({'Name':'Geeks', 'Team':'Boston', 'Number':3,
                        'Position':'PG', 'Age':33, 'Height':'6-2',
                        'Weight':189, 'College':'MIT', 'Salary':999999999}
                         , index=[0])
   
df = pd.concat([new_row, df]).reset_index(drop=True)
df.head(5)

chevron_right


Output:

Now, let’s check if the maximum salary is present at index 0 or not.

filter_none

edit
close

play_arrow

link
brightness_4
code

# Returns index of minimum salary
df[['Salary']].idxmax()

chevron_right


Output:



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.