I have a dataframe in pandas as following:
columns Year_1 Year_2
Idx_lvl_0 Idx_lvl_1
Cons. Prod_1 156 1541
Prod_2 312 2311
Del. Prod_1 23 12
Prod_2 0 4
问题:如何根据Idx_lvl_0
获取以下子总计(Cons_total和Del_total)。
columns Year_1 Year_2
Idx_lvl_0 Idx_lvl_1
Cons. Prod_1 156 1541
Prod_2 312 2311
Cons_total 468 3852
Del. Prod_1 23 12
Prod_2 0 4
Del_total 23 16