Create MultiIndex Dataframe from Dictionary of Lists

Question

I would like to create an empty, MultiIndex DataFrame where the first level of columns contains the dictionary keys, with the second level of columns containing the values for each key.

Example:

dictionary = {"Col 1": ["foo", "bar"], "Col 2": ["one", "two"]}

anky · Accepted Answer · 2020-01-30 15:47:37Z

2

You can flatten the dictionary for each key and value , then use pd.MultiIndex.from_arrays , then swaplevel:

d = {i:k for k,v in dictionary.items() for i in v}
df = (pd.DataFrame(columns=pd.MultiIndex.from_arrays((d.keys(),d.values())))
      .swaplevel(axis=1).rename_axis(columns=['first','second']))

#df.to_excel(...)

answered Jan 30, 2020 at 15:47

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

1 Comment

JR1 Over a year ago

What about if the second level column names are the same? E.g. Col 1: "foo", "bar", Col 2: "foo", "bar". This works perfectly except I have some second level names that are getting lost as they repeat.

Collectives™ on Stack Overflow

Create MultiIndex Dataframe from Dictionary of Lists

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related