/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

1 vote251 views1 answer
How to find which 2 rows of a df are the most similar
Python
-1 vote253 views2 answers
Pandas dataframe apply function with multiple arguments
Python
1 vote274 views2 answers
GuruTheCoder
Python
2 votes253 views1 answer
Termcolor python
Python
0 vote264 views1 answer
When was barracoon written
Python
0 vote296 views1 answer
Extract images from html page based on src attribute using beatutiful soup
Python
0 vote260 views1 answer
Python "urllib3" download and save pdf
Python
16 votes262 views1 answer
Python reload function in shell
Python
0 vote241 views1 answer
Remove inner list from outer list python
Python
0 vote257 views1 answer
Pandas snippets
Python