擅长:python、mysql、java
<p>我们做<code>str.findall</code>然后<code>map</code></p>
<pre><code>s=df.RepairName.str.findall('|'.join(cat.SearchTerm.tolist())).str[0].\
map(cat.set_index('SearchTerm').Category)
0 A/C
1 Tyre
2 Tyre
3 A/C
Name: RepairName, dtype: object
df['Category']=s
</code></pre>