#List unique values in the df['name'] column df.name.unique()
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
for col in df: print(df[col].unique())
df['Column_name'].value_counts()
df.nunique()
# get the unique values (rows) df.drop_duplicates()