• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Programming Expert

Solving All of Your Programming Headaches

  • Home
  • Learn to Code
    • Python
    • JavaScript
  • Code Snippets
    • HTML
    • JavaScript
    • jQuery
    • PHP
    • Python
    • SAS
    • Ruby
  • About
You are here: Home / Python / pandas max – Find Maximum Value of Series or DataFrame

pandas max – Find Maximum Value of Series or DataFrame

December 20, 2021 Leave a Comment

To find the maximum value of a column in pandas, the easiest way is to use the pandas max() function.

df["Column"].max()

You can also use the numpy max() function.

np.max(df["Column"])

Finding the maximum value of numbers in a column, or the maximum value of all numbers in a DataFrame using pandas is easy. We can use the pandas max() function to find the maximum values in a column of numbers, or a DataFrame.

Let’s say we have the following DataFrame.

df = pd.DataFrame({'Name': ['Jim', 'Sally', 'Bob', 'Sue', 'Jill', 'Larry'],
                   'Weight': [160.20, 123.81, 209.45, 150.35, 102.43, 187.52]})

print(df)
# Output: 
    Name  Weight
0    Jim  160.20
1  Sally  123.81
2    Bob  209.45
3    Sue  150.35
4   Jill  102.43
5  Larry  187.52

To get the maximum value of the numbers in the column “Weight”, we can use the pandas max() function in the following Python code:

print(df["Weight"].max())

# Output:
209.45

Please note, you can use the pandas max() function on an entire DataFrame if the DataFrame only contains numbers. If we call it on the DataFrame from above, we will receive an error because the “Name” column is made up of strings.

Using numpy max to Calculate Maximum Value in pandas DataFrame

We can also use the numpy max() function to calculate the maximum value of the numbers in a column in a pandas DataFrame.

To get the maximum value of the numbers in the column “Weight”, we can use the numpy max() function in the following Python code:

print(np.max(df["Weight"]))

# Output:
209.45

As you can see above, this is the same value we received from the pandas min() function.

If you are looking to find the maximum value of a set of numbers in regular Python, you can use the python max() function.

If on the other hand you are looking to find the minimum value of a set of numbers, you can use the pandas min() function.

Hopefully this article has been helpful for you to understand how to find the maximum value of numbers in a Series or DataFrame in pandas.

Other Articles You'll Also Like:

  • 1.  How to Draw a Triangle in Python Using turtle Module
  • 2.  Python Even or Odd – Check if Number is Even or Odd Using % Operator
  • 3.  Python Square Root – Finding Square Roots Using math.sqrt() Function
  • 4.  PROC MIXED Equivalent in Python for Least Squared Means ANOVA
  • 5.  How to Add Two Numbers in Python
  • 6.  How to Write Python Dictionary to File
  • 7.  Using Python to Count Odd Numbers in List
  • 8.  Python issubset() Function – Check if Set is Subset of Another Set
  • 9.  Divide Each Element in List by Scalar Value with Python
  • 10.  How to Check if List is Empty in Python

About The Programming Expert

The Programming Expert is a compilation of a programmer’s findings in the world of software development, website creation, and automation of processes.

Programming allows us to create amazing applications which make our work more efficient, repeatable and accurate.

At the end of the day, we want to be able to just push a button and let the code do it’s magic.

You can read more about us on our about page.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

About The Programming Expert

the programming expert main image

Welcome to The Programming Expert. We are a group of US-based programming professionals who have helped companies build, maintain, and improve everything from simple websites to large-scale projects.

We built The Programming Expert to help you solve your programming problems with useful coding methods and functions in various programming languages.

Search

Learn Coding from Experts on Udemy

Looking to boost your skills and learn how to become a programming expert?

Check out the links below to view Udemy courses for learning to program in the following languages:

Copyright © 2023 · The Programming Expert · About · Privacy Policy