python基于pandas使两个表格之间匹配某一属性

import pandas as pd
import numpy as np
#编码距离，用于匹配最相近的中文字符串
def edit_distance(word1, word2):
    len1 = len(word1)
    len2 = len(word2)
    dp = np.zeros((len1 + 1, len2 + 1))
    for i in range(len1 + 1):
        dp[i][0] = i
    for j in range(len2 + 1):
        dp[0][j] = j

    for i in range(1, len1 + 1):
        for j in range(1, len2 + 1):
            delta = 0 if word1[i - 1] == word2[j - 1] else 1
            dp[i][j] = min(dp[i - 1][j - 1] + delta, min(dp[i - 1][j] + 1, dp[i][j - 1] + 1))
    return dp[len1][len2]


a=pd.read_csv(r'表格路径')
b=pd.read_excel(r'表格路径')
A=a['属性3'].tolist()
print(A)

Azl=a['属性1']
Arj=a['属性2']
B=b['属性3'].tolist()
count=0
for i in A:
    list1=[]
    dic1={}
    for j in B:
        distance=edit_distance(i,j)
        if distance==0:
            dic1