如何将一个数据框中的一列字符串值映射到另一个数据框中的另一列？

尝试用series.replace与regex=True创建从第二DF的字典后：

df1['Column 2'] = df1['Column 1'].replace(df2.set_index('Column 1')
                                           ['Column 2'],regex=True)

print(df1)

  Column 1            Column 2
0  A; B; C  Apple; Banana; Cat
1  A; D; E     Apple; Dog; Egg
2     B; C         Banana; Cat

• Nice one man. +1. I was thinking to split and explode and then map. This looks way better.
• Good Ideas......