pandas count unique rows code example

Example 1: count unique pandas

df['column'].nunique()

Example 2: 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}

Example 3: pandas groupby count unique rows

df = df.groupby(by='domain', as_index=False).agg({'ID': pd.Series.nunique})
print(df)
    domain  ID
0       fb   1
1      ggl   1
2  twitter   2
3       vk   3

Example 4: 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

Example 5: pandas count unique values in column

df.nunique()