/Python/Python - count number of values without dupicalte in a second column values

Python - count number of values without dupicalte in a second column values

ID, domain
123, 'vk.com'
123, 'vk.com'
123, 'twitter.com'
456, 'vk.com'
456, 'facebook.com'
456, 'vk.com'
456, 'google.com'
789, 'twitter.com'
789, 'vk.com'

df = df.groupby('domain')['ID'].nunique()
print (df)

domain
'facebook.com'    1
'google.com'      1
'twitter.com'     2
'vk.com'          3

Source: stackoverflow.com

Similar codes

0 vote134 views1 answer
Https://raw.githubusercontent.com/tim-yao/lighthouse-ci/d32f465bb6cda08ded4ce25c88c43a3103e4940a/.browserslistrc
Python
0 vote156 views5 answers
TypeError: ‘float’ object is not callable
Python
0 vote140 views1 answer
Concatenating objects in pandas
Python
6 votes129 views6 answers
ModuleNotFoundError: No module named 'Crypto'
Python
8 votes151 views3 answers
Python clone object
Python
0 vote98 views1 answer
Tqdm pandas apply
Python
2 votes171 views2 answers
Pandas how to show the whole series
Python
1 vote149 views1 answer
Python dictionary with list
Python
0 vote167 views2 answers
Django serializer method field read write
Python Django
15 votes132 views6 answers
Google translation
Python