python pandas how many times a value appears code example

Example 1: how to count special values in data in python

df['sex'].value_counts()

Example 2: pd count how many item occurs in another column

df['Counts'] = df.groupby(['Color'])['Value'].transform('count')