take average of 2 columns pandas code example

Example 1: get a column that corresponds to the average of two columns pandas

df['avg'] = df.mean(axis=1)

       Monday  Tuesday  Wednesday        avg
Mike       42      NaN         12  27.000000
Jenna     NaN      NaN         15  15.000000
Jon        21        4          1   8.666667

Example 2: getting a column that corresponds to the average of two columns in pandas

df_mean = df[["a", "b"]].mean()