excel内容的比对

import xlsxwriter
import pandas as pd

save_path = 'C:/Users/user/Desktop/2.xls'
workbook = xlsxwriter.Workbook(save_path)
worksheet = workbook.add_worksheet('Result')

# 指定读取的列
df = pd.read_excel('C:/Users/user/Desktop/1.xlsx', usecols=[1])
txt_list = df.values.tolist()
list1 = ['张磊', '小磊']
list2 = ['小红', '你好']

x = 0
for i in txt_list:
    x = x + 1
    if i[0] in list1:
        worksheet.write(x, 0, str('张磊'))
    if i[0] in list2:
        worksheet.write(x, 0, str('小红'))
    else:
        worksheet.write(x, 0, str(i[0]))

workbook.close()