How To Find the Maximum Element of All Columns/Rows in Pandas DataFrame

How To Find the Maximum Element of All Columns/Rows in Pandas DataFrame

Working with Pandas DataFrames, you'll eventually face the situation where you need to find the maximum value for all of its columns or rows. Let's assume you already have a properly formatted DataFrame:

import pandas as pd 

df_data = { 
	"column1": [24, 9, 20, 24], 
	"column2": [17, 16, 201, 16] 
} 

df = pd.DataFrame(df_data) 
print(df)
   column1  column2
0       24       17
1        9       16
2       20      201
3       24       16

Finding the maximum element of each column of this DataFrame is pretty straightforward. All you need to do is to call the max() method:

max_elements = df.max()
print(max_elements)

This will give you a list of maximum elements for each column:

Get free courses, guided projects, and more

No spam ever. Unsubscribe anytime. Read our Privacy Policy.

column1 24 
column2 201 
dtype: int64

The same applies when you need to find the max element of each row of this DataFrame. The only difference is that you need to provide one additional argument to the max() method:

max_elements = df.max(axis=1)
print(max_elements)

This will give you the maximum value for each row of the df:

0 24 
1 16 
2 201 
3 24 
dtype: int64

Advice: If you want to get know more about Pandas DataFrames, consider reading our in-depth guide "Python with Pandas: DataFrame Tutorial with Examples".

Last Updated: July 20th, 2022
Was this helpful?
Course

Data Visualization in Python with Matplotlib and Pandas

# python# pandas# matplotlib

Data Visualization in Python with Matplotlib and Pandas is a course designed to take absolute beginners to Pandas and Matplotlib, with basic Python knowledge, and...

David Landup
David Landup
Details
Free
Course

Graphs in Python - Theory and Implementation

# python# data structures# algorithms# computer science

Graphs are an extremely versatile data structure. More so than most people realize! Graphs can be used to model practically anything, given their nature of...

David Landup
Dimitrije Stamenic
Jovana Ninkovic
Details

© 2013-2022 Stack Abuse. All rights reserved.

DisclosurePrivacyTerms