python 统计两个EXCEL表不同的行

问题描述

统计两个EXCEL表不同的行数，并且打印出来

代码

import pandas as pd


# 返回list of list 格式
def read_excel(IO):
    df_news = pd.read_excel(io = IO,header = None ) #不然默认第一行是 列名，会去掉
    df_li = df_news.values.tolist()
    result = []
    for s_li in df_li:
        result.append(s_li[0])
    return result

if __name__ == '__main__':
    result1 = read_excel(r'C:\XXXXXXXXX') #多的
    result2 = read_excel(r'C:\XXXXXXXXX') #少的
    
    for line1 in result1:
        flag = 0
        for line2 in result2:
            if line1 == line2:
                flag = 1
        if flag == 0:
            print(line1)
            print("------------------------------------")