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

155 votes321 views6 answers
Python os if file exists
Python
1 vote258 views1 answer
Explode dictionary pandas
Python
-3 votes266 views1 answer
Django socketio web chat example
Python
2 votes255 views1 answer
Python tkinter underline text
Python
0 vote278 views2 answers
Numpy roundup to nearest 5
Python
4 votes353 views2 answers
Read binary file python
Python
1 vote302 views1 answer
Get csrf_token value in django template
Python Django
-1 vote291 views3 answers
Play Video in Google Colab
Python
1 vote219 views1 answer
Django auto increment field
Python Django
-1 vote274 views3 answers
Transpose of a matrix in python numpy
Python