/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

3 votes197 views4 answers
Tkinter maximize window
Python
0 vote217 views2 answers
Django edit object foreign key id
Python Django
0 vote218 views1 answer
Pandas get size of each group
Python
0 vote202 views1 answer
List to string without loop
Python
0 vote199 views1 answer
Python list all but first
Python
0 vote193 views1 answer
Pandas dataframe row names
Python
5 votes242 views2 answers
Get_object_or_404 django
Python Django
0 vote189 views1 answer
Menu extension in mit app inventor
Python
21 votes200 views8 answers
Translator
Python
0 vote211 views1 answer
How to make ui dialog pop in front pyqt
Python