/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 vote215 views1 answer
Join function
Python
2 votes213 views1 answer
How to clear an array python
Python
0 vote157 views1 answer
Python get text between two comma
Python
1 vote208 views1 answer
Python synonym library
Python
1 vote272 views1 answer
List comprehension - list files with extension in a directory
Python
8 votes196 views2 answers
What does class meta do in django
Python
3 votes246 views2 answers
Install flask on linux mint for python3
Python Flask
4 votes245 views6 answers
Hex to rgb python
Python
0 vote205 views1 answer
Python redis delete many
Python
0 vote152 views1 answer
Django templates directory
Python