Sum multiple multiindex column dataframe

Question

I have a dataframe like

  0       1             One                       Two
Tech    Tool    First  Second  Third      First  Second  Third
Auto     UIP     23      18      5          59     56      3
 AI      ALT     45      34      11         32     12      20

Need an output like

  0       1             One                       Two                      Sum
Tech    Tool    First  Second  Third      First  Second  Third    First   Second    Third
Auto     UIP     23      18      5          59     56      3        82      74        8
 AI      ALT     45      34      11         32     12      20       77      46        31

Here for Sum First 82=23+59, Second 74=18+56, Third 8=5+3 Similarly for others. I am beginner in multiindex dataframe please help

@ash can you provide code that generates your example dataframe? — Paul H
– Paul H, Commented Jan 6, 2021 at 17:18
I import this file from external source in html format then i convert this into dataframe. So i don't have code to generate this dataframe — ash
– ash, Commented Jan 6, 2021 at 17:20
I'm saying you need to write that code and provide it here — Paul H
– Paul H, Commented Jan 6, 2021 at 17:41
See here for more information: stackoverflow.com/questions/20109391/… — Paul H
– Paul H, Commented Jan 6, 2021 at 17:42

MaxYarmolinsky · Accepted Answer · 2021-01-06 17:11:35Z

1

You can try:

df.groupby(level=1, axis=1).sum()

answered Jan 6, 2021 at 17:11

MaxYarmolinsky

1,1491 gold badge10 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sum multiple multiindex column dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related