diff两列文本不同，并输出对比结果

最新推荐文章于 2024-05-30 11:43:13 发布

东方129

最新推荐文章于 2024-05-30 11:43:13 发布

阅读量347

点赞数

文章标签： python pandas 人工智能

本文链接：https://blog.csdn.net/xiaoruirui1294/article/details/131069516

版权

import pandas as pd
from openpyxl import Workbook
from openpyxl.styles import PatternFill
import difflib
import xlsxwriter


df = pd.read_csv("/compare_Batch/defe.csv")

col1_name = 'defe_uat'
col2_name = 'defe_test'

merged_col = df[col1_name] + df[col2_name]

diffs = []

# 使用嵌套循环逐行对比这两列数据，并将差异添加到列表中。
for i in range (len (df)):
    col1_val = str (df.loc[i, col1_name])
    col2_val = str (df.loc[i, col2_name])
    diff = list (difflib.ndiff (col1_val.splitlines (keepends=True), col2_val.splitlines (keepends=True)))
    for j, d in enumerate (diff):
        if d.startswith ('+'):
            diffs.append ({'index': i, col1_name: col1_val, col2_name: col2_val, 'diff': d.strip ()})
            # diffs.append ({'index': i, col1_name: '', col2_name: d[2:].strip (), 'diff': d.strip ()})
        elif d.startswith ('-'):
            # diffs.append ({'