Adding row of totals in pandas dataframe without the sum of names?

Question

I have this dataframe:

Data = {'name':  ['a', 'b'],
        'number1': [5, 3],
        'number2': [3, 2]
        }
df = pd.DataFrame(Data, columns = ['name','number1', 'number2'])

I want to add another row which would contain sums of columns number1 and number2. So my desired result is this:

Data2 = {'name':  ['a', 'b', 'total'],
        'number1': [5, 3, 8],
        'number2': [3, 2, 5]
        }
df2 = pd.DataFrame(Data2, columns = ['name','number1', 'number2'])

I tried the solution offered in this thread: Pandas dataframe total row

But this line

df.loc["Total"] = df.sum()

also makes a sum of names so in the end I get Total as my index and in names column I get a value ab (because a+b). Is there a way to get a df that looks exactly the same as my desired result df?

BENY · Accepted Answer · 2019-05-07 14:03:47Z

4

I am using .loc

df.loc[df.index.max()+1]=['total']+df.sum().tolist()[1:]
df
Out[80]: 
    name  number1  number2
0      a        5        3
1      b        3        2
2  total        8        5

answered May 7, 2019 at 14:03

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

Steve3p0 Over a year ago

After 4 hours of trying every other solution under the son, this is the only thing that worked for me in a jupyter notebook. This is insane.

anky · Accepted Answer · 2019-05-07 14:04:38Z

3

Use:

m=df.set_index('name')
m.loc['total']=m.sum()
print(m)

       number1  number2
name                   
a            5        3
b            3        2
total        8        5

You can also reset_index() if you intend to have the name column as column:

print(m.reset_index())

    name  number1  number2
0      a        5        3
1      b        3        2
2  total        8        5

edited May 7, 2019 at 14:04

answered May 7, 2019 at 14:00

anky

75.3k11 gold badges46 silver badges76 bronze badges

Comments

yatu · Accepted Answer · 2019-05-07 14:04:22Z

3

Here's one way:

df.append(df.sum().rename('total').replace({'ab':'total'})).reset_index(drop=True)

     name  number1  number2
0      a        5        3
1      b        3        2
2  total        8        5

answered May 7, 2019 at 14:04

yatu

88.6k12 gold badges93 silver badges148 bronze badges

Comments

jezrael · Accepted Answer · 2019-05-07 14:08:55Z

3

Use Series.append by columns filtered by positions by DataFrame.iloc or only numeric columns by DataFrame.select_dtypes:

df.loc[len(df)] = df.iloc[:, 1:].sum().append(pd.Series({'name':'total'}))
print (df)
    name  number1  number2
0      a        5        3
1      b        3        2
2  total        8        5

Or:

df.loc[len(df)] = df.select_dtypes(np.number).sum().append(pd.Series({'name':'total'}))

edited May 7, 2019 at 14:08

answered May 7, 2019 at 14:01

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Collectives™ on Stack Overflow

Adding row of totals in pandas dataframe without the sum of names?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related