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

0 vote289 views1 answer
Inpuit inf terfminal ppython
Python
0 vote227 views1 answer
Django create ap
Python
0 vote211 views1 answer
Round list of floats python
Python
0 vote189 views1 answer
Tensorflow Bert implementation
Python
0 vote232 views1 answer
Shutdown flask server with request
Python Flask
0 vote195 views1 answer
Entropy formula pyhon
Python
19 votes159 views2 answers
Ignore warnings
Python
1 vote185 views1 answer
Insert row in any position pandas dataframe
Python
2 votes181 views1 answer
QTextEdit get text
Python
15 votes168 views3 answers
Save numpy array to csv
Python