/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 votes175 views1 answer
How to call super class constructor in python two classes
Python
3 votes178 views2 answers
Change column value based on another column pandas
Python
3 votes202 views1 answer
Python wait 5 seconds then display
Python
0 vote191 views1 answer
Pil
Python
0 vote164 views1 answer
Time.ctime(os.path.getmtime phyton in datetime
Python
29 votes243 views2 answers
Replace values of pandas column
Python
0 vote190 views2 answers
Install iris
Python
1 vote229 views1 answer
Learn python 3 the hard way by by Zed Shaw
Python
0 vote180 views3 answers
How to print a text in python
Python
7 votes207 views6 answers
Dictionary comprehension python
Python