Combine multiple pandas DataFrames into a multi-index DataFrame

Question

I have three dataframes with equivalent indices, index names and column names:

I'd like to combine all 3 into a single multi-index dataframe, where the old index is now a column, and the new index is now ['DF1', 'DF2', 'DF3'].

             old_index     value
new_index
      DF1            0        a0
                     1        a1
                     2        a2
                     3        a3
      DF2            0        b0
                     1        b1
                     2        b2
                     3        b3
      DF3            0        c0
                     1        c1
                     2        c2
                     3        c3

What's the easiest way to go about this?

BENY · Accepted Answer · 2017-10-26 18:00:06Z

19

IIUC

l=[DF1,DF2,DF3]

pd.concat(l,keys= ['DF1', 'DF2', 'DF3'],axis=0).reset_index(level=1)

edited Oct 26, 2017 at 18:00

answered Oct 26, 2017 at 17:59

BENY

324k22 gold badges176 silver badges250 bronze badges

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

2 Comments

cs95 Over a year ago

Wow, that was fast!

BENY Over a year ago

@cᴏʟᴅsᴘᴇᴇᴅ Thank you ~ :-)

Collectives™ on Stack Overflow

Combine multiple pandas DataFrames into a multi-index DataFrame

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related