如何使用panda创建使用两个数据帧的数据帧

Question

我有两个数据帧"df1"one_answers"df2">

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

基于这两个数据帧，我想创建以下数据帧

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

Answer 1

IIUC，只需用map:执行替换即可

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