How can I select the rows on dataframe where specific column are different from each other

Question

I have this example of pandas dataframe:

C1	C2
ciao	type1
anna	type1
anna	type2

I would run a query on this dataframe to get all rows that are different on the column C2, but are equal on the column C1. In this specific example, I would like to get this table:

C1	C2
anna	type1
anna	type2

Is it possible? THANKS!

BENY · Accepted Answer · 2021-09-07 14:35:06Z

1

You can try with groupby and nunique

out = df.groupby('C1').filter(lambda x : any((len(x)>1) & (len(x) == x.nunique())))
Out[167]: 
     C1     C2
1  anna  type1
2  anna  type2

answered Sep 7, 2021 at 14:35

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

giupardeb Over a year ago

thank you so much for your answer...But I have a big problem..I don't know why with this csv (ufile.io/xb83mgop) your code doesn't work. Can you help to understand why?

Collectives™ on Stack Overflow

How can I select the rows on dataframe where specific column are different from each other

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related