Unable to compare data frame using python Tool

Question

Hello,

I have executed the python with Pycharm and Jupyter Notebook tool as well as Python Exe using Run command from Alteryx.

The Script executed successfully.

But when i am trying to run the exact same code using python its gives me error.

I am trying to compare two data frames with below code

comparision=df1.values==df2.values

rows,cols=np.where(comparision=='False')

This code executed in all the IDEs. but using Python Tool it is showing error as below

Error: elementwise comparison failed this will raise an error in the future

ValueError: not enough values to unpack (expected 2, got 1)

Please help to resolve the issue

philipmannering · Answer

Ah, I see. And what does,

df1.shape

and

df2.shape

Give you if you run this after reading the Excel?

NamrataDhiwar · Answer

Emp NameTestABC123XYZ345

I am using engine=Openpyxl while reading xlsx file

df1=pd.read_excel('File1.xlsx',engine='openpyxl')
df2=pd.read_excel('File2.xlsx',engine='openpyxl')

philipmannering · Answer

That's not what I asked for. I need to know what the dataframes look like to be able to help.