Compare columns and show unequal rows in Python?

Asked Jun 22 '18 at 12:51

Active Jun 22 '18 at 12:56

Viewed 384 times

I have a dataset where I want to check two columns if they have the same values and if there are any unequal rows to show them.

(inte_s['CA']==inte_s['CI']).all()

which returns

False

I tried also:

inte_s['CA][~inte_s['CA'].isin(inte_s['CI'])]

but doesn't work.

How to show the unequal values?

asked Jun 22 '18 at 12:51

user122244

1

`inte_s[inte_s['CA'] != inte_s['CI']]`? – miradulo Jun 22 '18 at 12:52
1

unbelievable haha – user122244 Jun 22 '18 at 12:54
You should read over the [Pandas docs](https://pandas.pydata.org/pandas-docs/stable/dsintro.html), won't take long and will help a lot! – miradulo Jun 22 '18 at 12:54
I have read it in the past but I simply couldn't think of this right now. – user122244 Jun 22 '18 at 12:56

0 Answers0