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

The Programming Expert

Solving All of Your Programming Headaches

  • HTML
  • JavaScript
  • jQuery
  • PHP
  • Python
  • SAS
  • Ruby
  • About
You are here: Home / Python / pandas median – Find Median of Series or Columns in DataFrame

pandas median – Find Median of Series or Columns in DataFrame

January 4, 2022 Leave a Comment

To find the medians of the columns in a DataFrame, or the median value of a Series in pandas, the easiest way is to use the pandas median() function.

df.median()

You can also use the numpy median() function.

np.median(df["Column"])

When working with data, many times we want to calculate summary statistics to understand our data better. One such statistic is the median, or the middle number of a variable.

Finding the median in a column, or the median for all columns or rows in a DataFrame using pandas is easy. We can use the pandas median() function to find the median value of a column of numbers, or a DataFrame.

Let’s say we have the following DataFrame.

df = pd.DataFrame({'Age': [43,23,71,49,52,37], 
      'Test_Score':[90,87,92,96,84,79]})

print(df)
# Output: 
   Age  Test_Score
0   43          90
1   23          87
2   71          92
3   49          96
4   52          84
5   37          79

To get the medians for all columns, we can call the pandas median() function.

print(df.median())

# Output:
Age           46.0
Test_Score    88.5
dtype: float64

If we only want to get the median of one column, we can do this using the pandas median() function in the following Python code:

print(df["Test_Score"].median())

# Output:
88.5

This is the same output as if we called the pandas quantile() function for the 50th percentile:

print(df["Test_Score"].quantile(0.5))

# Output:
88.5

Using numpy median to Calculate Medians in pandas DataFrame

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

To get the median of the numbers in the column “Test_Score”, we can use the numpy median() function in the following Python code:

print(np.median(df["Test_Score"]))

# Output:
88.5

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

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

Other Articles You'll Also Like:

  • 1.  Sorting with Lambda Functions in Python
  • 2.  Python ljust Function – Left Justify String Variable
  • 3.  How to Return Nothing in Python from Function
  • 4.  Find All Pythagorean Triples in a Range using Python
  • 5.  pandas Correlation – Find Correlation of Series or DataFrame Columns
  • 6.  Using Python to Read File Word by Word
  • 7.  Using Python to Print Degree Symbol
  • 8.  Sum Columns Dynamically with pandas in Python
  • 9.  Check if a Number is Divisible by 2 in Python
  • 10.  Length of Dictionary Python – Get Dictionary Length with len() Function

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