/Python/Pandas count unique values in column

Pandas count unique values in column

Return count of unique values pandas

#TO count repetition of each unique values(to find How many times the same-
# unique value is appearing in the data)

item_counts = df["Your_Column"].value_counts()
#Returns Dictionary => {"Value_name" : number_of_appearences}

Count unique pandas

df['column'].nunique()

Dataframe unique values in each column

for col in df:
    print(df[col].unique())

Source: stackoverflow.com

Values of unique from dataframe with count

data = df.groupby('ColumnName')['IDColumnName'].nunique()
print(data)

Get count of unique values in column pandas

df = df.groupby('domain')['ID'].nunique()

print (df)
domain
'facebook.com'    1
'google.com'      1
'twitter.com'     2
'vk.com'          3
Name: ID, dtype: int64

Source: stackoverflow.com

Pandas count unique values in column

df.nunique()

Similar codes

4 votes165 views4 answers
Virtualenv python2
Python
0 vote168 views1 answer
Tkinter background image python 3
Python
61 votes187 views6 answers
Python pause
Python
2 votes190 views2 answers
Or in django query
Python Django
2 votes159 views1 answer
Number to list in python
Python
1 vote235 views1 answer
Disable DevTools listening on ws://127.0.0.1 python
Python
1 vote178 views1 answer
Issue TypeError: can’t multiply sequence by non-int of type str
Python
0 vote170 views1 answer
Python coule nod import the module virtualenvwrapper.hook_loader
Python
0 vote166 views1 answer
Python 123 + 0.00
Python
0 vote174 views1 answer
Write a python program to find the most frequent word in text file
Python