擅长:python、mysql、java
<p>我们还可以探索<code>series.replace</code>:</p>
<pre><code>s = dict(df2[['Fullname','id']].astype(str).to_numpy())
df1['id'] = df1['name'].replace(s,regex=True)
</code></pre>
<hr/>
<pre><code>print(df1)
name id
0 richard Finn, Tim Maltby 500, 699
1 Fernando Lebrija 300
</code></pre>