/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 vote202 views1 answer
Updating column values
Python
39 votes177 views3 answers
ModuleNotFoundError: No module named 'matplotlib'
Python
1 vote170 views1 answer
Removing features pandas
Python
5 votes162 views4 answers
Brew update python
Python
0 vote157 views1 answer
Print only strings in list python
Python
4 votes274 views1 answer
How to make sun as first day in calendar python
Python
4 votes162 views2 answers
Remove all 0 from list python
Python
2 votes182 views3 answers
Python pywin32 get current cursor row
Python
0 vote164 views1 answer
How to make a password generating program in python
Python
1 vote161 views1 answer
Rename coordinate netcdf python xarray
Python