擅长:python、mysql、java
<p>您可以进行拆分、分解,然后映射和分组:</p>
<pre><code>df['id'] = (df['name'].str.split(',\s*')
.explode()
.map(df2.set_index('Fullname')['id'])
.groupby(level=0).agg(list)
)
</code></pre>
<p>输出:</p>
<pre><code> name id
0 richard Finn, Tim Maltby [500, 699]
1 Fernando Lebrija [300]
</code></pre>