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())
data = df.groupby('ColumnName')['IDColumnName'].nunique() print(data)
# get the unique values (rows) df.drop_duplicates()
1 # get the unique values (rows) by retaining last row 2 df.drop_duplicates(keep='last')