How to make a sum row for two columns python dataframe

Question

I have a pandas dataframe:

    Col1  Col2  Col3
0    1     2     3
1    2     3     4

And I want to add a new row summing over two columns [Col1,Col2] like:

      Col1  Col2  Col3
0      1     2     3
1      2     3     4
Total  3     5     NaN

Ignoring Col3. What should I do? Thanks in advance.

When you say dataframe, do you mean pandas? Then it should be tagged accordingly. And what have you tried, why did it fail? — Mr. T
– Mr. T, Commented Jul 7, 2018 at 9:37

nijm · Accepted Answer · 2018-07-07 12:48:54Z

1

You can use the pandas.DataFrame.append and pandas.DataFrame.sum methods:

df2 = df.append(df.sum(), ignore_index=True)
df2.iloc[-1, df2.columns.get_loc('Col3')] = np.nan

edited Jul 7, 2018 at 12:48

answered Jul 7, 2018 at 9:46

nijm

2,21815 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nijm Over a year ago

jpp's answer is better, as it doesn't calculate the third column

jpp · Accepted Answer · 2018-07-07 09:48:45Z

0

You can use pd.DataFrame.loc. Note the final column will be converted to float since NaN is considered float:

import numpy as np

df.loc['Total'] = [df['Col1'].sum(), df['Col2'].sum(), np.nan]
df[['Col1', 'Col2']] = df[['Col1', 'Col2']].astype(int)

print(df)

       Col1  Col2  Col3
0         1     2   3.0
1         2     3   4.0
Total     3     5   NaN

answered Jul 7, 2018 at 9:48

jpp

166k37 gold badges301 silver badges363 bronze badges

Collectives™ on Stack Overflow

How to make a sum row for two columns python dataframe

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related