Pandas MultiIndex Dataframe to Excel | second Index as column name

Question

Sample Data frame :

import pandas as pd
idx = pd.MultiIndex.from_product([['Microsoft', 'Google', 'Apple'],
                                  ['OS', 'Web']],
                                 names=['Brand', 'Metric'])
col = ['Count']

df = pd.DataFrame(10, idx, col)
df

the data looks like this

When I download it as csv then it download like

df.to_csv('example.csv')

My Requirement is to download this data as pivot table, I am not able to find any way to move the second index as column name, the desired output of data looks like this

jezrael · Accepted Answer · 2018-06-08 07:27:21Z

2

I think need write reshaped DataFrame by unstack with some data cleaning to csv:

df['Count'].unstack().rename_axis(None).rename_axis(None, axis=1).to_csv('example.csv')

Detail:

print (df['Count'].unstack().rename_axis(None).rename_axis(None, axis=1))
           OS  Web
Apple      10   10
Google     10   10
Microsoft  10   10

answered Jun 8, 2018 at 7:27

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Pandas MultiIndex Dataframe to Excel | second Index as column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related