Suppose I have a dataframe as below
a b c
1 1 45
0 2 74
2 2 54
1 4 44
Now I want the rows where column a and b are not same. So the expected outpu is
a b c
0 2 74
1 4 44
How can I do this?
I am a fan of readability, use query
:
df.query('a != b')
Output:
a b c
1 0 2 74
3 1 4 44
Try this:
df.loc[df['a'] != df['b']]
By using nunique
df.loc[df[['a','b']].nunique(1)>1]
Out[335]:
a b c
1 0 2 74
3 1 4 44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With