Construct a multiindexed dataframe from dataframes

Question

Suppose x = pd.DataFrame({'a': range(0,3), 'b': range(1, 4)}) and y = pd.DataFrame({'a': range(-1,2), 'b': range(2, 5)}). I want to construct a dataframe t = pd.DataFrame('x': x, 'y': y). The expected result is a multiindexed dataframe. However, an error message tells me ValueError: If using all scalar values, you must pass an index.

import panda as pd
x = pd.DataFrame({'a': range(0,3), 'b': range(1, 4)})
y = pd.DataFrame({'a': range(-1,2), 'b': range(2, 5)}) 
t = pd.DataFrame('x': x, 'y': y)

jezrael · Accepted Answer · 2018-07-23 11:39:54Z

2

I believe need concat by indexes (dafault axis=0 is omited) for MultiIndex in indices:

t = pd.concat({'x': x, 'y': y})

Or:

t = pd.concat([x, y], keys=('x','y'))

Or by columns by axis=1 for MultiIndex in columns:

t = pd.concat({'x': x, 'y': y}, axis=1)
t = pd.concat([x, y], keys=('x','y'), axis=1)

print (t)
   x     y   
   a  b  a  b
0  0  1 -1  2
1  1  2  0  3
2  2  3  1  4

answered Jul 23, 2018 at 11:39

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Construct a multiindexed dataframe from dataframes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related