Compute row average in pandas

Question

       Y1961      Y1962      Y1963      Y1964      Y1965  Region 0  82.567307  83.104757  83.183700  83.030338  82.831958  US 1   2.699372   2.610110   2.587919   2.696451   2.846247  US 2  14.131355  13.690028  13.599516  13.649176  13.649046  US 3   0.048589   0.046982   0.046583   0.046225   0.051750  US 4   0.553377   0.548123   0.582282   0.577811   0.620999  US 

In the above dataframe, I would like to get average of each row. currently, I am doing this:

df.mean(axis=0) 

However, this does away with the Region column as well. how can I compute mean and also retain Region column

Answer 1

You can specify a new column. You also need to compute the mean along the rows, so use axis=1.

df['mean'] = df.mean(axis=1) >>> df        Y1961      Y1962      Y1963      Y1964      Y1965 Region       mean 0  82.567307  83.104757  83.183700  83.030338  82.831958     US  82.943612 1   2.699372   2.610110   2.587919   2.696451   2.846247     US   2.688020 2  14.131355  13.690028  13.599516  13.649176  13.649046     US  13.743824 3   0.048589   0.046982   0.046583   0.046225   0.051750     US   0.048026 4   0.553377   0.548123   0.582282   0.577811   0.620999     US   0.576518