/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

2 votes356 views1 answer
How to set google chrome as default browser when coding with python using webbroiwser module
Python
0 vote329 views1 answer
Passport parsing python
Python
0 vote366 views1 answer
Open file find and replace commas python
Python
-1 vote333 views1 answer
Python return double quotes instead of single
Python
2 votes320 views1 answer
How to return a value from a function in python
Python
-3 votes343 views2 answers
Python list of characters
Python
0 vote343 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python
7 votes395 views2 answers
Mongodb aggregate count
Python
0 vote352 views1 answer
Confusion matrix seaborn
Python
0 vote358 views1 answer
Range function in python use cases
Python