assert_frame_equal asserting for two same pandas dataframe

Question

I am doing 2 pandas dataframe comparison and this is where my assertion is failing.

pd.testing.assert_frame_equal

This is the assertion error

E   AssertionError: DataFrame.iloc[:, 8] (column name="xxxxx") are different
E
E   DataFrame.iloc[:, 8] (column name="xxxxx") values are different (50.0 %)
E   [left]:  [143455434, None]
E   [right]: [143455434, None]

Both left and right are same still it is giving error. Both columns are object types

I can't help, but I'm getting the same. Perhaps a bug. If I use df1.equals(df2) I get equality, and similarly when I use assert_series_equal on the apparently offending column I get equality too. I did use this answer to help one of my cases pass: stackoverflow.com/questions/43088121/… — Zach Cleary
– Zach Cleary, Commented Feb 3, 2020 at 10:31
Strangely I converted them to str and it worked. Could possibly a bug — Nipun
– Nipun, Commented Feb 4, 2020 at 17:28

Matias David Lee · Accepted Answer · 2022-04-14 11:06:24Z

1

I had the same issue. In the end, I used the option check_dtype=False from assert_frame_equal, and the assert works.

... types, who need them?

answered Apr 14, 2022 at 11:06

Matias David Lee

1011 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nipun · Accepted Answer · 2020-02-08 06:42:01Z

0

Possibly a bug. Workaround is to convert to str and then check

answered Feb 8, 2020 at 6:42

Nipun

4,3189 gold badges53 silver badges89 bronze badges

Collectives™ on Stack Overflow

assert_frame_equal asserting for two same pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related