count unique values by column in pandas code example
Example 1: 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 2: 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
Example 3: how to count unique values in a column dataframe in python
dataframe.column.nunique()