Re: Compare files excel

2017-07-23 Thread Peter Otten
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

Re: Compare files excel

2017-07-23 Thread Smith
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

Re: Compare files excel

2017-07-23 Thread Smith
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)

Re: Compare files excel

2017-07-22 Thread Albert-Jan Roskam
(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: [email protected] Subject: Compare files excel Hello to all, I should compare two excel files with p