get unique values of all column pandas code example

Example 1: pandas unique values in column

#List unique values in the df['name'] column
df.name.unique()

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

df['hID'].nunique()
5

Example 3: 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 4: dataframe unique values in each column

for col in df:
    print(df[col].unique())

Example 5: if df[col].unique()==2

df_dict = dict(zip([i for i in df.columns] , [pd.DataFrame(df[i].unique(), columns=[i]) for i in df.columns]))