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 numpyimport pandas as pdimport numpy as np# data of 2018 drivers world championshipdict1 = {'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 constructordf = 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 constructordf = 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 constructordf = 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 constructordf = 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 constructordf = 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 constructordf = 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 constructordf = 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 constructordf = pd.DataFrame(dict1)# Which row has maximum age |# who is the youngest driver ?print(df[df.Age == df.Age.min()]) |
Output:
