我知道如何映射查找表。但是如果要查找的鍵隱藏在字串中怎么辦：
source-df
ColA
"Pete eats apple."
"I like chocolate more."
"Orange from Carla."
查找-df：
Col1 Col2
Orange orange
chocolate brown
apple green
應該像這樣擴展 source-df 。
ColA Color
"Pete eats apple." green
"I like chocolate more." brown
"Orange from Carla." orange
uj5u.com熱心網友回復：
使用Series.str.extract有Series.map：
d = lookupdf.set_index('Col1')['Col2'].to_dict()
pat = '|'.join(d)
#if words boundaries are important
#pat = '|'.join(r"\b{}\b".format(x) for x in d)
df['Color'] = df['ColA'].str.extract('(' pat ')', expand=False).map(d)
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/357465.html