Compare files excel

[Albert-Jan Roskam]

(sorry for top posting)

Try:
df1['difference'] = (df1 == df2).all(axis=1)
________________________________
From: Python-list <python-list-bounces+sjeik_appie=hotmail.com at python.org> on behalf of Smith <smith at smith.it>
Sent: Saturday, July 22, 2017 7:47:59 AM
To: python-list at python.org
Subject: Compare files excel

Hello to all,
I should compare two excel files with pandas.
Who can help me?


Do you have any links?


i tried this, but not working
import pandas as pd
df1 = pd.read_excel('excel1.xlsx')
df2 = pd.read_excel('excel2.xlsx')
difference = df1[df1!=df2]
print (difference)

Thank you
--
https://mail.python.org/mailman/listinfo/python-list