Get the index of minimum 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 minimum 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 minimum 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 minimum 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 minimum weight
df[['Weight']].idxmin()

chevron_right


Output:

We can verify whether the minimum 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 140 to 154
df.iloc[140:155]

chevron_right


Output:

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

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':99}
                         , index=[0])
   
df = pd.concat([new_row, df]).reset_index(drop=True)
df.head(5)

chevron_right


Output:

Now, let’s check if the minimum 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']].idxmin()

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.