利用python提取两个excel对比后的重复值的信息 

import pandas
 
 
def read_excel():
    data1 = pandas.read_excel(r'C:\Users\admin\Desktop\1.xlsx')
    data2 = pandas.read_excel(r'C:\Users\admin\Desktop\2.xlsx')
    data3=pandas.merge(data1, data2, on=['名称'], how='outer')
    print(data3)
    data3.to_excel(r'C:\Users\admin\Desktop\3.xlsx',index=False)
 
 
read_excel()

 

posted @ 2021-07-14 18:15  akihi2325  阅读(887)  评论(0)  编辑  收藏  举报