我在
fuzzywuzzy这里用
from fuzzywuzzy import fuzzfrom fuzzywuzzy import processdf2['key']=df2.Name.apply(lambda x : [process.extract(x, df1.Name, limit=1)][0][0][0])df2.merge(df1,left_on='key',right_on='Name')Out[1238]: Name_x gender key Age Name_y0 adam Smith M Adam Smith 43 Adam Smith1 Annie Kim F Anne Kim 21 Anne Kim2 John Weber M John Weber 55 John Weber3 Ian Ford M Ian Ford 24 Ian Ford
