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.
import pandas as pd
df.head( 10 )
|
Code #1: Check the index at which minimum weight value is present.
import pandas as pd
df = pd.read_csv( "nba.csv" )
df[[ 'Weight' ]].idxmin()
|
Output:
We can verify whether the minimum value is present in index or not.
import pandas as pd
df = pd.read_csv( "nba.csv" )
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.
import pandas as pd
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.
Output:
Last Updated :
18 Dec, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...