df['hID'].nunique() 5
df['column'].nunique()
#TO count repetition of each unique values(to find How many times the same- # unique value is appearing in the data) item_counts = df["Your_Column"].value_counts() #Returns Dictionary => {"Value_name" : number_of_appearences}
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
data = df.groupby('ColumnName')['IDColumnName'].nunique() print(data)
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
pd.value_counts(df.Account_Type) Gold 3 Platinum 1 Name: Account_Type, dtype: int64
df.nunique()
