How to add a column onto a dataframe to sum the rows

Question

I am looking to add in a column to my data frame in order to sum the total of all values in a respective row

For example:

1  2       Column I Want to Add

4  9                13
7  1                8

How to find the of two or more columns is a common problem, please look at the duplicate listed above. — cs95, Jun 07 '19 at 18:45

DjaouadNM · Accepted Answer · 2019-06-07T18:46:43.820

2

You can df.sum(axis = 1), which will create a new column (not a row):

import pandas as pd
df = pd.DataFrame({1: [4, 7], 2: [9, 1]})

df['COLUMN I Want to Add'] = df.sum(axis = 1)
print(df)

Output:

   1  2  COLUMN I Want to Add
0  4  9                    13
1  7  1                     8

edited Jun 07 '19 at 18:46

answered Jun 07 '19 at 18:42

DjaouadNM

1

Yeah nice. Just a small comment though: the name "Row I want to Add" makes no sense. You are creating a column. – Anton vBR Jun 07 '19 at 18:43
@AntonvBR xD right it makes no sense, I guess that's the OP's problem. I'll edit anyway. – DjaouadNM Jun 07 '19 at 18:51
Thanks, works perfectly! My mistake on the rows instead fo columns typo – Ryan Reid Jun 07 '19 at 19:37

score 0 · Answer 2 · answered Jun 07 '19 at 18:41

0

df['new_col'] = df['col1'] + df['col2']

answered Jun 07 '19 at 18:41

Ahmed

2 Answers2