Getting percent occurence of each item in pandas column

Asked Jun 04 '19 at 16:05

Active Jun 04 '19 at 16:05

Viewed 36 times

I have a pandas column Reason with 89 entries, consisting of a,b,c,d,e. I'm trying to find the % occurrence of each Reason.

Now, I'm doing np.sum(df.eval('Reason == "a"').groupby(keys).sum())*(100/89) for each Reason separately. Is there a faster way?

asked Jun 04 '19 at 16:05

srkdb

3

Is this what you're looking for? https://stackoverflow.com/a/50558594/4909087 `df['Reason'].value_counts(normalize=True) * 100` – cs95 Jun 04 '19 at 16:06
1

Perfect! Thank you. – srkdb Jun 04 '19 at 16:08

0 Answers0