Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 143 of 167

Python Pandas — I — Question 33

Back to all questions
33
Question

Question 27

Consider the following dataframe, and answer the questions given below:

import pandas as pd
df = pd.DataFrame( { "Quarter1": [2000, 4000, 5000, 4400, 10000],  
"Quarter2": [5800, 2500, 5400, 3000, 2900],  
"Quarter3": [20000, 16000, 7000, 3600, 8200],  
"Quarter4": [1400, 3700, 1700, 2000, 6000]})

(i) Write the code to find mean value from above dataframe df over the index and column axis.

(ii) Use sum() function to find the sum of all the values over the index axis.

Answer

(i)

import pandas as pd
df = pd.DataFrame( { "Quarter1": [2000, 4000, 5000, 4400, 10000],  
"Quarter2": [5800, 2500, 5400, 3000, 2900],  
"Quarter3": [20000, 16000, 7000, 3600, 8200],  
"Quarter4": [1400, 3700, 1700, 2000, 6000]})
mean_over_columns = df.sum(axis=1) / df.count(axis=1)
print("Mean over columns: \n", mean_over_columns)

mean_over_rows = df.sum(axis=0) / df.count(axis=0)
print("Mean over rows: \n", mean_over_rows)
Output
Mean over columns: 
0    7300.0
1    6550.0
2    4775.0
3    3250.0
4    6775.0
dtype: float64

Mean over rows:
Quarter1     5080.0
Quarter2     3920.0
Quarter3    10960.0
Quarter4     2960.0
dtype: float64

(ii)

import pandas as pd
df = pd.DataFrame( { "Quarter1": [2000, 4000, 5000, 4400, 10000],  
"Quarter2": [5800, 2500, 5400, 3000, 2900],  
"Quarter3": [20000, 16000, 7000, 3600, 8200],  
"Quarter4": [1400, 3700, 1700, 2000, 6000]})
sum_over_index = df.sum(axis=0)
print("Sum over index (columns):\n", sum_over_index)
Output
Sum over index (columns):
Quarter1    25400
Quarter2    19600
Quarter3    54800
Quarter4    14800
dtype: int64