/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 vote227 views1 answer
Django get child element
Python Django
1 vote235 views1 answer
Pandas timedelta to seconds
Python
1 vote240 views1 answer
How to take second largest value in pandas
Python
-2 votes258 views6 answers
Python List Comprehension
Python
6 votes227 views1 answer
Get all combinations from two lists python
Python
2 votes242 views2 answers
How to read a json resposnse from a link in python
Python
17 votes254 views5 answers
Python add element to array
Python
5 votes222 views1 answer
How to count things in a list python
Python
1 vote248 views3 answers
Isinstance python
Python
0 vote229 views1 answer
Networkx max degree node
Python