I have a dataframe like this:

I need to compute the average of all the columns and need the dataframe looks like this:

I'm trying this but it gives me error

df = df.append({'user_id':'Average', df.mean}, ignore_index=True)

CodePudding user response：

Also working:

df = pd.concat([df, df.mean().to_frame('Average').T])

which will create the following result.

           A    B     C    D
1        1.0  0.0  0.00  1.0
2        2.0  1.0  0.00  2.0
3        2.0  3.0  1.00  3.0
4        3.0  2.0  0.00  4.0
Average  2.0  1.5  0.25  2.5

Comment

If you really want to mix floats and integers, please use

pd.concat([df, df.mean().to_frame('Average', ).T.astype(object)])

This will result in

           A    B     C    D
1          1    0     0    1
2          2    1     0    2
3          2    3     1    3
4          3    2     0    4
Average  2.0  1.5  0.25  2.5

I want to quote from the