stormtrooper12 stormtrooper12 - 1 month ago 17
Python Question

Create a DataFrame with a MultiIndex

I would like to make my DataFrame like the one below and export it to excel. I have all the data available for all the '-' that I have put. I want to know what data structure to pass to pd.Dataframe() to make a table like this.

Would like to know how pandas read these data structures to form a DataFrame.

enter image description here

Answer
idx = pd.MultiIndex.from_product([['Zara', 'LV', 'Roots'],
                                  ['Orders', 'GMV', 'AOV']],
                                 names=['Brand', 'Metric'])
col = ['Yesterday', 'Yesterday-1', 'Yesterday-7', 'Thirty day average']

df = pd.DataFrame('-', idx, col)
df

Jupyter screen shot

enter image description here

df.to_excel('test.xlsx')

Mac Numbers screen shot

enter image description here

Comments