Compare files excel
Albert-Jan Roskam
sjeik_appie at hotmail.com
Sat Jul 22 16:21:27 EDT 2017
(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
More information about the Python-list
mailing list