0

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?

Improve this question
4
  • 1
    inte_s[inte_s['CA'] != inte_s['CI']]? Commented Jun 22, 2018 at 12:52
  • 1
    unbelievable haha Commented Jun 22, 2018 at 12:54
  • You should read over the Pandas docs, won't take long and will help a lot! Commented Jun 22, 2018 at 12:54
  • I have read it in the past but I simply couldn't think of this right now. Commented Jun 22, 2018 at 12:56
Related questions
4241
How can I iterate over rows in a Pandas DataFrame?
3956
How can I catch multiple exceptions in one line? (in the "except" block)
1429
Which MySQL data type to use for storing boolean values
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.