Open In App
Related Articles

Select row with maximum and minimum value in Pandas dataframe

Improve Article
Improve
Save Article
Save
Like Article
Like

Let’s see how can we select rows with maximum and minimum values in Pandas Dataframe with help of different examples using Python.

Creating a Dataframe to select rows with max and min values in Dataframe

Python3




# importing pandas and numpy
import pandas as pd
import numpy as np
 
# data of 2018 drivers world championship
dict1 = {'Driver': ['Hamilton', 'Vettel', 'Raikkonen',
                    'Verstappen', 'Bottas', 'Ricciardo',
                    'Hulkenberg', 'Perez', 'Magnussen',
                    'Sainz', 'Alonso', 'Ocon', 'Leclerc',
                    'Grosjean', 'Gasly', 'Vandoorne',
                    'Ericsson', 'Stroll', 'Hartley', 'Sirotkin'],
 
         'Points': [408, 320, 251, 249, 247, 170, 69, 62, 56,
                    53, 50, 49, 39, 37, 29, 12, 9, 6, 4, 1],
 
         'Age': [33, 31, 39, 21, 29, 29, 31, 28, 26, 24, 37,
                 22, 21, 32, 22, 26, 28, 20, 29, 23]}
 
# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
print(df.head(10))


Output:

 

Select row with maximum value in Pandas Dataframe

Example 1: Shows max on Driver, Points, and Age columns. 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# the result shows max on
# Driver, Points, Age columns.
print(df.max())


Output:

 

Example 2: Who scored max points 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# Who scored more points ?
print(df[df.Points == df.Points.max()])


Output: 

 

Example 3: What is the maximum age 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# what is the maximum age ?
print(df.Age.max())


Output:

39

Example 4: Which row has maximum age in the Dataframe | who is the oldest driver? 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# Which row has maximum age |
# who is the oldest driver ?
print(df[df.Age == df.Age.max()])


Output: 

 

Select row with maximum value in Pandas Dataframe

Example 1: Shows min on Driver, Points, Age columns. 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# the result shows min on
# Driver, Points, Age columns.
print(df.min())


Output:

 

Example 2: Who scored fewer points 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# Who scored less points ?
print(df[df.Points == df.Points.min()])


Output:

 

Example 3: Which row has minimum age in the Dataframe who is the youngest driver 

Python3




# creating dataframe using DataFrame constructor
df = pd.DataFrame(dict1)
 
# Which row has maximum age |
# who is the youngest driver ?
print(df[df.Age == df.Age.min()])


Output:

 


Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 07 Sep, 2022
Like Article
Save Article
Similar Reads
Related Tutorials