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

2 votes136 views1 answer
Qradiobutton example
Python
5 votes148 views2 answers
Append string variable with integer python
Python
0 vote161 views3 answers
Missing Data Plotly Express px.data
Python
0 vote144 views2 answers
Python suppress exponential notation
Python
0 vote178 views1 answer
Pandas dataframe caption
Python
1 vote137 views1 answer
Convert seconds to hours python
Python
1 vote171 views1 answer
Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'.
Python Django
15 votes136 views1 answer
Python dict to kwargs
Python
1 vote96 views1 answer
Pandas subtract columns
Python
0 vote134 views1 answer
Falcon 900 price
Python