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.

(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