如何比較2個txt檔案和輸出的差異并將其列印到shell?
此鏈接中的作業檔案

uj5u.com熱心網友回復:
當然使用 diff
difflib.Diff
uj5u.com熱心網友回復:
drop_duplicates與熊貓一起使用:
df1 = pd.read_csv('members_1.txt', header=None).drop_duplicates()
df2 = pd.read_csv('members_2.txt', header=None).drop_duplicates()
out = pd.concat([df1, df2]).drop_duplicates(keep=False)
輸出
>> print(*out[0].to_list(), sep='\n')
LEE RI KE
LIM YONG
KOH CHEE KIAT
LEE YONG
KOH CHEW KIAT
LEE RI KHEE
或者
set在 Python 中使用:
with open('members_1.txt') as fp1, open('members_2.txt') as fp2:
data1 = set([l.strip() for l in fp1])
data2 = set([l.strip() for l in fp2])
out = data1.symmetric_difference(data2)
輸出:
>>> print(*out, sep='\n')
KOH CHEW KIAT
LEE RI KE
LEE YONG
KOH CHEE KIAT
LEE RI KHEE
LIM YONG
轉載請註明出處,本文鏈接:https://www.uj5u.com/ruanti/333440.html
上一篇:pandasdf.to_sql到Oracle資料庫資料型別不一致
下一篇:同時創建新資料框和新列
