Pandas group by two columns and count the second column value by each group

Question

I have a dataset of domains could someone tell me how I can filter domains with more than one extension with Pandas.

I grouped it by this code but I got this result:

dfActive.groupby(['domain','ext'])['ext'].nunique()

Result:

domain         com     1
sample         com     1
mashhadmap     com     1
               net     1

Expected Result:

mashhadmap     2

jezrael · Accepted Answer · 2022-07-06 06:52:41Z

1

IIUC use if need count per first level domain by aggregate sum:

dfActive.groupby(['domain','ext'])['ext'].nunique().groupby(level=0).sum()

If need filter values if duplicated per first level:

s = dfActive.groupby(['domain','ext'])['ext'].nunique()
s = s[s.index.get_level_values(0).duplicated(keep=False)]

#and then if need aggregate sum
out = s.groupby(level=0).sum()

answered Jul 6, 2022 at 6:52

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Pandas group by two columns and count the second column value by each group

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related