Ricky
Ricky

Reputation: 23

filter dataframe after groupby and nunique in pandas

i tried df.groupby("item")["variable"].nunique() and it returns a unique count of every item object.

i want to filter to only return the count of "variable" > 3 conditional on Groupby item... is there a method?

Upvotes: 1

Views: 1427

Answers (1)

cs95
cs95

Reputation: 402723

When you want the groupby to be mapped to every row of the input, think about transform:

df = df[df.groupby("item")["variable"].transform('nunique') > 3]

Upvotes: 5

Related Questions