How to create MultiIndex DataFrame from other pandas DataFrames

Question

I have basically two DataFrames from different dates and want to join them into one

let's say this is data from 25 Sep

hour    columnA  columnB
0       12       24
1       45       87
2       10       58
3       12       13
4       12       20

here is data from 26sep

hour    columnA  columnB
0       54       89
1       45       3
2       33       97
3       12       13
4       78       47

now I want to join both DataFrames and get MultiIndex DataFrame like this

25sep hour  columnA  columnB
        0       12       24
        1       45       87
        2       10       58
        3       12       13
        4       12       20
26sep hour  columnA  columnB
        0       54       89
        1       45       3
        2       33       97
        3       12       13
        4       78       47

I read the docs about MultiIndex but am not sure how to apply it to my situation.

Rodalm · Accepted Answer · 2021-10-28 00:37:02Z

1

Use pandas.concat

https://pandas.pydata.org/docs/reference/api/pandas.concat.html

>>> df = pd.concat([df1.set_index('hour'), df2.set_index('hour')],
                   keys=["25sep", "26sep"])
>>> df

            columnA  columnB
      hour                  
25sep 0          12       24
      1          45       87
      2          10       58
      3          12       13
      4          12       20
26sep 0          54       89
      1          45        3
      2          33       97
      3          12       13
      4          78       47

edited Oct 28, 2021 at 0:37

answered Oct 28, 2021 at 0:31

Rodalm

5,7589 silver badges22 bronze badges

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

Comments

BENY · Accepted Answer · 2021-10-28 00:34:34Z

0

Let us try

out = pd.concat({ y : x.set_index('hour') for x, y  in zip([df1,df2],['25sep','26sep'])})
            columnA  columnB
      hour                  
25sep 0          12       24
      1          45       87
      2          10       58
      3          12       13
      4          12       20
26sep 0          54       89
      1          45        3
      2          33       97
      3          12       13
      4          78       47

answered Oct 28, 2021 at 0:34

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

How to create MultiIndex DataFrame from other pandas DataFrames

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related