/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 vote243 views1 answer
Convert multidimentional numpy array to string and back
Python
1 vote229 views2 answers
Python regex get word after string
Python
0 vote271 views1 answer
Day 27: Testing hackerrank solution python
Python
0 vote333 views1 answer
How to pre populate field flask wtforms
Python Flask
3 votes238 views1 answer
Module 'datetime' has no attribute 'strptime'
Python
42 votes237 views5 answers
How to print today's date in python
Python
0 vote254 views1 answer
Python pyautogui projects
Python
0 vote243 views1 answer
Python random email generator
Python
0 vote244 views1 answer
Sring to name variable pyton
Python
11 votes230 views2 answers
Pickle a dictionary
Python