pythonpandas读取csv和另外一个csv进行比较_将两个csv文件与python pandas进行比较

可以将df转换为集合，在比较数据时忽略索引，然后使用set symmetric_differenceds1 = set([ tuple(values) for values in df1.values.tolist()])

ds2 = set([ tuple(values) for values in df2.values.tolist()])

ds1.symmetric_difference(ds2)

print df1 ,'\n\n'

print df2,'\n\n'

print pd.DataFrame(list(ds1.difference(ds2))),'\n\n'

print pd.DataFrame(list(ds2.difference(ds1))),'\n\n'

df1型id Name score isEnrolled Comment

0 111 Jack 2.17 True He was late to class

1 112 Nick 1.11 False Graduated

2 113 Zoe 4.12 True NaN

df2型id Name score isEnrolled Comment

0 111 Jack 2.17 True He was late to class

1 112 Nick 1.21 False Graduated

2 113 Zoe 4.12 False On vacation

输出0 1 2 3 4

0 113 Zoe 4.12 True NaN

1 112 Nick 1.11 False Graduated

0 1 2 3 4

0 113 Zoe 4.12 False On vacation

1 112 Nick 1.21 False Graduated