Skip to content
Related Articles

Related Articles

Improve Article

Get the index of minimum value in DataFrame column

  • Last Updated : 18 Dec, 2018

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.




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

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






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

Output:

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




   
  
# 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]

Output:

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




# 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)

Output:

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




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

Output:

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course




My Personal Notes arrow_drop_up
Recommended Articles
Page :