Adding sub headers to pandas Dataframe

Question

I have a large dataframe with lots of columns, each with their own header. I'd like to group them in sub headers so readability is more clear. For example, here are my column headers:

df1 = df1[['Date', 'Time', 'USA', 'Canada', 'SD', 'HD']]

I'd like have headers above certain columns to output like this:

When               Country            Channel
Date     Time      USA     Canada     SD     HD

However, I'm not sure how to go about this. Any assistance or direction is much appreciated.

Thanks!

Muhammad Hassan · Accepted Answer · 2021-10-12 19:31:15Z

4

You can use:

df.columns = pd.MultiIndex.from_tuples([('When', 'Date'), ('When', 'Time'),
                                        ('Country', 'USA'), ('Country', 'Canada'),
                                        ('Channel', 'SD'), ('Channel', 'HD')])

answered Oct 12, 2021 at 19:31

Muhammad Hassan

4,2492 gold badges16 silver badges30 bronze badges

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

2 Comments

Rocky5 Over a year ago

Thank you! Exactly what I was looking for!

Muhammad Hassan Over a year ago

Plz consider accepting the answer if it helped.

Collectives™ on Stack Overflow

Adding sub headers to pandas Dataframe

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related