Create third dataframe with existing two dataframe columns

Question

I have two dataframes, and I want to create third dataframe with the columns of existing dataframes df1

╔═══════╦═══════╦════════╗
║   A   ║   B   ║   C    ║
╠═══════╬═══════╬════════╣
║ Bob   ║ David ║ George ║
║ Jon   ║ Aron  ║ Cathy  ║
║ Cathy ║ Vinod ║ Wills  ║
╚═══════╩═══════╩════════╝

df2

╔════════╦═════════╦════════╗
║   D    ║    E    ║   F    ║
╠════════╬═════════╬════════╣
║ Robert ║ Stephen ║ Martin ║
║ Arthur ║ Allen   ║ Lilly  ║
║ Kristy ║ Calvin  ║ Olive  ║
║ James  ║ Danies  ║ Harry  ║
╚════════╩═════════╩════════╝

And I need a dataframe like this with columns of df1 & df2 with same empty cells

df3

╔═══════╦════════╦═════════╦════════╗
║   B   ║   C    ║    E    ║   F    ║
╠═══════╬════════╬═════════╬════════╣
║ David ║ George ║ Stephen ║ Martin ║
║ Aron  ║ Cathy  ║ Allen   ║ Lilly  ║
║ Vinod ║ Wills  ║ Calvin  ║ Olive  ║
║       ║        ║ Danies  ║ Harry  ║
╚═══════╩════════╩═════════╩════════╝

I can't see in your question what have you already tried.

Egl
– Egl

2018-02-19 11:53:14 +00:00
Commented Feb 19, 2018 at 11:53 — Egl
– Egl, Commented Feb 19, 2018 at 11:53

Zero · Accepted Answer · 2018-02-19 11:54:47Z

2

Use

In [335]: pd.concat([df1[['B', 'C']], df2[['E', 'F']]], axis=1)
Out[335]:
       B       C        E       F
0  David  George  Stephen  Martin
1   Aron   Cathy    Allen   Lilly
2  Vinod   Wills   Calvin   Olive
3    NaN     NaN   Danies   Harry

answered Feb 19, 2018 at 11:54

Zero

77.4k22 gold badges153 silver badges153 bronze badges

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

Collectives™ on Stack Overflow

Create third dataframe with existing two dataframe columns

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