(sorry for top posting)
Try:
df1['difference'] = (df1 == df2).all(axis=1)
________________________________
From: Python-list <[email protected]> on
behalf of Smith <[email protected]>
Sent: Saturday, July 22, 2017 7:47:59 AM
To: [email protected]
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
--
https://mail.python.org/mailman/listinfo/python-list
