擅长:python、mysql、java
<p>使用链接答案中的<a href="https://stackoverflow.com/a/56315491/9081267">^{<cd1>}</a>函数:</p>
<pre><code>from fuzzywuzzy import fuzz
from fuzzywuzzy import process
mrg = fuzzy_merge(df1, df2, 'Name', 'Name', threshold=70)\
.merge(df2, left_on='matches', right_on='Name', suffixes=['1', '2'])\
.filter(like='ID')
</code></pre>
<p><strong>输出</strong></p>
^{pr2}$