/Python/Pandas count the number of unique values in a column

Pandas count the number of unique values in a 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}

How to count number of unique values in a column python

pd.value_counts(df.Account_Type)

Gold        3
Platinum    1
Name: Account_Type, dtype: int64

Source: stackoverflow.com

Unique values in dataframe column count

df.groupby('mID').agg(['count', 'size', 'nunique']).stack()


             dID  hID  uID
mID                       
A   count      5    5    5
    size       5    5    5
    nunique    3    5    5
B   count      2    2    2
    size       2    2    2
    nunique    2    2    2
C   count      1    1    1
    size       1    1    1
    nunique    1    1    1

Source: stackoverflow.com

Pandas count the number of unique values in a column

df['hID'].nunique()
5

Source: stackoverflow.com

Similar codes

-1 vote135 views1 answer
Python how to find the highest even in a list
Python
7 votes135 views3 answers
How to add multiple commands to tkinter button
Python
4 votes136 views3 answers
Display prime numbers between two intervals in python
Python
19 votes195 views6 answers
Install Django Windows
Python Django
0 vote141 views1 answer
How to accept invalidfileexception in python
Python
-2 votes143 views2 answers
Python list ascii
Python
-1 vote141 views1 answer
Why women are better than men
Python
8 votes134 views5 answers
Find common elements in two lists python
Python
0 vote177 views2 answers
Python enumerate in list comprehension with if statement
Python
2 votes126 views1 answer
When did guido van rossum create python
Python