Pandas ttable with sum totals

import numpy as np
import pandas as pd


df = pd.DataFrame({'a': [10,20],'b':[100,200],'c': ['a','b']})

df.loc['Column_Total']= df.sum(numeric_only=True, axis=0)
df.loc[:,'Row_Total'] = df.sum(numeric_only=True, axis=1)

print(df)

                 a      b    c  Row_Total
0             10.0  100.0    a      110.0
1             20.0  200.0    b      220.0
Column_Total  30.0  300.0  NaN      330.0

Source: stackoverflow.com

Similar codes

38 votes141 views6 answers
Remove substring from string python
Python
14 votes128 views5 answers
Read excel sheet in python
Python
0 vote142 views1 answer
Install sorting
Python
33 votes137 views2 answers
Python b to string
Python
0 vote128 views1 answer
Expand alphabets in python
Python
0 vote140 views1 answer
Circular list python
Python
0 vote128 views1 answer
Python autotrader web
Python
2 votes124 views2 answers
Convert pdf to csv python
Python
3 votes127 views1 answer
How to change python version on linux
Python
7 votes124 views2 answers
Traceback python
Python