Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Multi-index dataframe from sequence of dataframes [duplicate]

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      ...       ...      ...          ...
like image 891
Josh Avatar asked Mar 20 '14 21:03

Josh


1 Answers

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'])
like image 94
joris Avatar answered Oct 17 '22 23:10

joris