/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 vote335 views1 answer
How to make a use of list in python to make your own length function
Python
1 vote380 views1 answer
Rfind() in python
Python
0 vote367 views3 answers
Django prevent duplicate entries
Python Django
33 votes367 views6 answers
Python if else one line
Python
0 vote335 views1 answer
Pyspark groupby sum
Python
0 vote360 views1 answer
Install lz4 python 3
Python
2 votes372 views1 answer
What is modulus in python
Python
1 vote340 views1 answer
Show integer seabron heatmap values
Python
15 votes339 views1 answer
Importing file from another folder python
Python
1 vote337 views1 answer
How to get prime numbers in a list in python using list comprehension
Python