How to create dataframe using two dataframe using pandas

Question

I have two dataframe 'df1' and 'df2'

df1=   a       b
       1       such as
       2       who I'm

df2=   a       keyword
       1       such
       1       as
       2       who
       2       I'm

Based on this two dataframe I want to create following dataframe

result =   a           keyword
           such as     such
           such as     as
           who I'm     who
           who I'm     I'm

Can you provide the constructors for your two dataframes?

mozway
– mozway

2022-02-27 06:53:54 +00:00
Commented Feb 27, 2022 at 6:53 — mozway
– mozway, Commented Feb 27, 2022 at 6:53

mozway · Accepted Answer · 2022-02-27 06:48:45Z

1

IIUC, just perform a replacement with map:

df2['a'] = df2['a'].map(df1.set_index('a')['b'])

answered Feb 27, 2022 at 6:48

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

How to create dataframe using two dataframe using pandas

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