w3resource

Pandas Practice Set-1: Calculate the mean of each row of diamonds DataFram


27. Calculate Mean of Each Row

Write a Pandas program to calculate the mean of each row of diamonds DataFrame.

Sample Solution:

Python Code:

import pandas as pd
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print("Original Dataframe:")
print(diamonds.head())
print("\nMean of each row of diamonds DataFrame:")
print(diamonds.mean(axis=1).head())

Sample Output:

Original Dataframe:
   carat      cut color clarity  depth  table  price     x     y     z
0   0.23    Ideal     E     SI2   61.5   55.0    326  3.95  3.98  2.43
1   0.21  Premium     E     SI1   59.8   61.0    326  3.89  3.84  2.31
2   0.23     Good     E     VS1   56.9   65.0    327  4.05  4.07  2.31
3   0.29  Premium     I     VS2   62.4   58.0    334  4.20  4.23  2.63
4   0.31     Good     J     SI2   63.3   58.0    335  4.34  4.35  2.75

Mean of each row of diamonds DataFrame:
0    64.727143
1    65.292857
2    65.651429
3    66.535714
4    66.864286
dtype: float64

For more Practice: Solve these Related Problems:

  • Write a Pandas program to calculate the mean value for each row in the diamonds DataFrame for numeric columns.
  • Write a Pandas program to add a new column to the diamonds DataFrame that contains the row-wise mean of numeric values.
  • Write a Pandas program to compute the mean across each row and then filter rows based on a threshold of this mean.
  • Write a Pandas program to calculate and display the row-wise mean values and plot their distribution.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to calculate the mean of each numeric column of diamonds DataFrame.
Next: Write a Pandas program to calculate the mean of price for each cut of diamonds DataFrame.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.