Mean of Columns & Rows of pandas DataFrame in Python (2 Examples)


On this page you’ll learn how to calculate the column and row means of a pandas DataFrame in the Python programming language.

The content of the tutorial looks as follows:

You’re here for the answer, so let’s get straight to the exemplifying Python syntax:


Example Data & Libraries

If we want to use the functions of the pandas library, we first need to import pandas:

import pandas as pd                                # Import pandas

Next, I’ll also have to create some example data:

data = pd.DataFrame({'x1':[6, 2, 7, 9, 7, 1, 9],  # Create example DataFrame
                     'x2':[2, 5, 9, 2, 5, 2, 3],
                     'x3':range(10, 3, - 1)})
print(data)                                       # Print example DataFrame


table 1 DataFrame mean columns rows pandas dataframe python


As you can see based on Table 1, our example data is a DataFrame made of seven rows and the three columns “x1”, “x2”, and “x3”.


Example 1: Calculate Mean of Each Column in pandas DataFrame

The following syntax shows how to get the average of each variable in a pandas DataFrame using the Python programming language.

For this, we can apply the mean function as shown below:

print(data.mean())                                # Get column means
# x1    5.857143
# x2    4.000000
# x3    7.000000
# dtype: float64

As you can see based on the previous console output, the means of our columns are 5.857143, 4.0, and 7.0.


Example 2: Calculate Mean of Each Row in pandas DataFrame

In this example, I’ll show how to return the average of each row of a pandas DataFrame.

To do this, we can use the mean function once again (as in Example 1), but this time we have to specify the axis argument to be equal to 1.

Have a look at the Python syntax below:

print(data.mean(axis = 1))                        # Get row means
# 0    6.000000
# 1    5.333333
# 2    8.000000
# 3    6.000000
# 4    6.000000
# 5    2.666667
# 6    5.333333
# dtype: float64

The previous output shows the mean values of each of the rows of our example data set.


Video & Further Resources

Would you like to learn more about metrics such as the mean, mode, and median? Then you might check out the video of the PortEXE YouTube channel that you can find below.


Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.

YouTube Content Consent Button Thumbnail

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.


In addition, you might read the related articles on this homepage:


To summarize: You have learned in this article how to get the column and row means of a pandas DataFrame in Python. Tell me about it in the comments section, if you have any further questions.


Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.