unique count pandas code example

Example 1: count unique pandas

df['column'].nunique()

Example 2: pandas count the number of unique values in a column

df['hID'].nunique()
5

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: 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 6: values of unique from dataframe with count

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