count no. of records having a particular value dataframe python pandas 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')