extract
pat = '|'.join(r"\b{}\b".format(x) for x in df1['col_one'].unique())
df2['col_one'] = df2['col_1'].str.extract('(' + pat + ')')
print (df2)
col_1 col_one
0 operate ABBC1, to 2 ABBC1
1 operate JJKS3, FOM JJKS3
df = df1.merge(df2, on='col_one')
print (df)
col_one col_two col_1
0 ABBC1 (1, 2, 3) operate ABBC1, to 2
1 JJKS3 (5, 2, 5) operate JJKS3, FOM
如果可以匹配多个值,请使用
findall
DataFrame
以下内容:
pat = '|'.join(r"\b{}\b".format(x) for x in df1['col_one'].unique())
s = df2['col_1'].str.findall('(' + pat + ')')
print (s)
0 [ABBC1, JJKS3]
1 [JJKS3]
Name: col_1, dtype: object
lens = s.str.len()
a = np.repeat(df2['col_1'], lens)
b = np.concatenate(s)
df2 = pd.DataFrame({'col_1':a, 'col_one':b})
print (df2)
col_1 col_one
0 operate ABBC1, to 2 JJKS3 3 to 5 ABBC1
0 operate ABBC1, to 2 JJKS3 3 to 5 JJKS3
1 operate JJKS3, FOM JJKS3
df = df1.merge(df2, on='col_one')
print (df)
col_one col_two col_1
0 ABBC1 (1, 2, 3) operate ABBC1, to 2 JJKS3 3 to 5
1 JJKS3 (5, 2, 5) operate ABBC1, to 2 JJKS3 3 to 5
2 JJKS3 (5, 2, 5) operate JJKS3, FOM