Pandas dataframe add headers above the headers

Question

I'm trying to add another line of headers above the headers in a pandas dataframe.

Turning this :

import pandas as pd

df = pd.DataFrame(data={'A': range(5), 'B': range(5), 'C':range(5)})
print(df)
   A  B  C
0  0  0  0
1  1  1  1
2  2  2  2
3  3  3  3
4  4  4  4

into this (for instance):

Having both A and B under D and C under E. This doesn't seem like something that would be hard with pandas but yet I can't seem to find the answer. How do you do this?

sammywemmy · Accepted Answer · 2021-06-22 22:08:22Z

1

With some help from @Nk03, you can create a mapping of existing column labels to D and E, then create a MultiIndex :

map_dict = {'A': 'D', 'B': 'D' ,'C':'E'}
df.columns = pd.MultiIndex.from_tuples(zip(df.columns.map(map_dict), df.columns))

   D     E
   A  B  C
0  0  0  0
1  1  1  1
2  2  2  2
3  3  3  3
4  4  4  4

answered Jun 22, 2021 at 22:08

sammywemmy

28.9k4 gold badges20 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe add headers above the headers

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related