/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 vote173 views1 answer
Label with list comprehension python
Python
0 vote168 views1 answer
How to go sown a line in pyton
Python
-1 vote170 views1 answer
Python Sort Lists
Python
14 votes189 views6 answers
Python print variable
Python
0 vote195 views1 answer
Compare input with list python
Python
0 vote168 views1 answer
NameError: name 'accuracy_score' is not defined
Python
0 vote171 views1 answer
Multipart Encoder
Python
1 vote174 views1 answer
Numpy divide array by scalar
Python
3 votes162 views1 answer
How to encrypt a string python
Python
0 vote179 views1 answer
How add a favicon to django
Python