[enter image description here]
Suppose I have multiple entries in a column search term, I want to calculate the percentage of occurrence of the brand. I know how to get the count of each brand but can someone suggest a way to get these in percentage?
df = df.groupby(["searchterm","brand"]).size().reset_index(name='count')
>Solution :
You should be able to use
df.groupby('searchterm')['brand'].value_counts(normalize=True)