/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

2 votes137 views1 answer
Int' object is not callable python
Python
19 votes146 views5 answers
Save matplotlib figure
Python
0 vote162 views1 answer
Index.py:14: RuntimeWarning: invalid value encountered in true_divide return np.dot(user, user2) / (norm(user) * norm(user2))
Python
10 votes173 views2 answers
Adding static file and its usage in Django
Python Django
6 votes186 views4 answers
Flask get with parameters
Python Flask
0 vote135 views2 answers
Callbacks to function pysimplegui
Python
0 vote174 views1 answer
Covert docx to pdf with libraoffice in python
Python
76 votes170 views6 answers
Python file open
Python
39 votes144 views2 answers
Create text in python if not exists
Python
87 votes140 views6 answers
Write dataframe to csv python
Python