From the dataframe object created in previous question, write a script to calculate: (a) Average temperatures for each day of the week.

Q. From the dataframe object created in previous question, write a script to calculate :

(a) Average temperatures for each day of the week i.e., average temperature for Mondays, Tuesdays

and so on.

(b) Average temperature per week.

(c) Average temperature of whole month.

Answer =

(a)
print( df.mean(axis = 1, skipna = True) )

(b)
print( df.mean(axis = 0, skipna = True) )

(c)

n=df.isna().sum().sum() #Counting NaN values under an entire DataFrame:
print( df.sum().sum()/(28-n) ) # 28 is number of days in DataFrame

#OR

print( df.stack().mean() )