Smith wrote:
> On 22/07/2017 22:21, Albert-Jan Roskam wrote:
>> df1['difference'] = (df1 == df2).all(axis=1)
>
> below here there is the mistake :
>
> In [17]: diff = df1['difference'] = (df1 == df2).all(axis=1)
>
---
> Val
On 22/07/2017 22:21, Albert-Jan Roskam wrote:
df1['difference'] = (df1 == df2).all(axis=1)
below here there is the mistake :
In [17]: diff = df1['difference'] = (df1 == df2).all(axis=1)
---
ValueError
On 22/07/2017 22:21, Albert-Jan Roskam wrote:
(sorry for top posting)
Try:
df1['difference'] = (df1 == df2).all(axis=1)
here below there is the mistake :
In [17]: diff = df1['difference'] = (df1 == df2).all(axis=1)
(sorry for top posting)
Try:
df1['difference'] = (df1 == df2).all(axis=1)
From: Python-list on
behalf of Smith
Sent: Saturday, July 22, 2017 7:47:59 AM
To: python-list@python.org
Subject: Compare files excel
Hello to all,
I should compare two 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.p
