/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

18 votes227 views3 answers
How to clear command prompt python
Python
0 vote216 views1 answer
From wireframe GUI design to python tkinter
Python
0 vote275 views1 answer
Start a django project
Python Django
0 vote202 views1 answer
Search for a word in pdf using python
Python
0 vote212 views1 answer
Use the "map" function to find all the odd numbers and the even numbers in the list. Print 0 for odd and 1 for even. in python
Python
0 vote195 views2 answers
Django ajax body to json
Python
6 votes186 views6 answers
Pandas drop missing values for any column
Python
0 vote192 views1 answer
Value Error handling
Python
0 vote266 views1 answer
Django cms create page programmatically
Python Django
9 votes236 views5 answers
How to drop the index column in pandas
Python