擅长:python、mysql、java
<p>与<code>series.str.extract</code>一起:</p>
<pre><code>s = df['county'].str.extract(f"({'|'.join(set(df1['county']))})",expand=False)
df['pin'] = s.map(dict(df1[['county','pin']].drop_duplicates().to_numpy()))
</code></pre>
<hr/>
<pre><code>print(df)
name age county pin
0 mark 22 York_USA_TXS 2225
1 stuart 23 kysjk_USA 2225
2 lewis 22 Monty_KYSJK 2226
</code></pre>