我有两个数据帧df1和df2，我想连接它们并创建新的数据帧DF3.
我想要联接工作，即使df1的dest列中有df2列的dest中有一个匹配.
加入密钥是对org,dest
df1个
Name org dest
Ashok A B
Rahul A C
Anupa B A
Sam A B
df2个
org dest Amount
A A/B/C 10
B C 20
A W 30
Expected Output
Name org dest Amount
Ashok A B 10
Rahul A C
Anupa B A
Sam A B 10
如何在python中实现这一点？
split和explode是"DEST"中的ID，然后是merge:
out = df1.merge(df2.assign(dest=df2['dest'].str.split('/'))
.explode('dest'),
on=['org', 'dest'], how='left')
输出:
Name org dest Amount
0 Ashok A B 10.0
1 Rahul A C 10.0
2 Anupa B A NaN
3 Sam A B 10.0
可重现的输入:
df1 = pd.DataFrame({'A': [1, 2, 3, 4], 'B': [5, 6, 7, 8]})
df2 = pd.DataFrame({'C': [1, 2, 2, 3, 3, 3, 4],
'D': [9, 10, 11, 12, 13, 14, 15]})