pandas count unique values with condition code example
Example 1: return count of unique values pandas
#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}
Example 2: unique values in dataframe column count
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