df = pd.DataFrame({'Color': 'Red Red Blue'.split(), 'Value': [100, 150, 50]})
df['Counts'] = [sum(df['Color'] == df['Color'][i]) for i in range(len(df))]
I want to create a column of value_counts in my pandas dataframe