from fuzzywuzzy import process
import pandas as pd
excel = pd.ExcelFile(r"C:\Users\Administrator\Desktop\mohu\1.xlsx")
data = excel.parse(0)
find = excel.parse(1)
users = data.user.to_list()
result = find.name.apply(lambda x: next(zip(*process.extract(x, users, limit=1)))).apply(pd.Series)
result.rename(columns=lambda i: f"匹配{i+1}", inplace=True)
result = pd.concat([find, result], axis=1)
result.to_excel(r" fuzzy mapping result.xlsx",index=False)