Multi-index dataframe from sequence of dataframes [duplicate]

Question

Say I have a list of dataframes [df1, df2, df3], where each single dataframe looks as follows:

> df1 

            median   std
control        0.4   0.2
experiment     0.2   0.3

How can I create a multi-index dataframe that stitches them together? Like this:

                         df1                 df2                  df3
          control experiment  control experiment  control  experiment
median        0.4        0.2      ...       ...      ...          ...
std           0.2        0.3      ...       ...      ...          ...

Your column and index labels are also switched. Is this also the question? — joris
– joris, Commented Mar 20, 2014 at 22:08
Thanks @joris. I am all set. I can .T the resulting multi-index dataframe. — Josh
– Josh, Commented Mar 20, 2014 at 22:10

Community · Accepted Answer · 2017-05-23 12:02:31Z

19

So you can provide the dataframes as a dict (as in duplicate question: python/pandas: how to combine two dataframes into one with hierarchical column index?), and then the dict keys are used:

pd.concat({'df1':df1, 'df2':df2, 'df3':df3}, axis=1)

or another option is to use the keys keyword argument:

pd.concat([df1, df2, df3], axis=1, keys=['df1', 'df2', 'df3'])

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Mar 20, 2014 at 22:04

joris

140k37 gold badges257 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Multi-index dataframe from sequence of dataframes [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related