/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 vote290 views4 answers
Python n choose r
Python
0 vote295 views1 answer
Dense(units = 128, activation = 'Leakyrelu'
Python
0 vote273 views1 answer
How to take multiple input form python
Python
0 vote275 views1 answer
Torch split classes stratified
Python
1 vote285 views1 answer
How to get sum specific columns value in machine learning
Python
4 votes285 views2 answers
How to print a specific value in a list python
Python
8 votes274 views2 answers
How to move a column in pandas dataframe
Python
1 vote288 views1 answer
Wrap list python
Python
2 votes305 views1 answer
Distance matrix in python
Python
2 votes300 views2 answers
Cmap seaborn
Python