python pandas count data in a single column code example
Example 1: pandas get count of column
df['column_name'].value_counts()
Example 2: python count variable and put the count in a column of data frame
df['freq'] = df.groupby('myvar')['myvar'].transform('count')