How to create a new row with the total sum of a axis

Question

I need create a new row with the total value of axis 0 sum.

I have the follow series values:

INDEX
0      -1.09
1       1.15
2      -0.28
3      -0.14
4       0.62

How can i add a new row at the end of series with the total sum, like this:

INDEX
0      -1.09
1       1.15
2      -0.28
3      -0.14
4       0.62
TOTAL   0.26

score 3 · Answer 1 · answered Jul 07 '17 at 16:09

3

You should find your answer here :

Precisely : df.loc['Total']= df.sum()

answered Jul 07 '17 at 16:09

mouch

score 0 · Accepted Answer · answered Jul 07 '17 at 16:10

0

df.set_value('TOTAL',df.sum())

answered Jul 07 '17 at 16:10

VinceP

2 Answers2