How to get percentage of occurrences of a column, grouped by another column? Python

Question

I am trying to calculate the percentage of occurrences of a product (with hundreds of different products) according to the related Country. And I would like this % to be shown on another column

I managed to do it in a graph, but it is not visually pleasing.

I tried the following code:

df = data1.groupby('Country')
df['percent'] = (df['Products'] /
                df['Products'].value_counts())*100
df

I get the following error message : "ValueError: operands could not be broadcast together with shapes (111,2) (4209,)"

I also tried something like the following by modifying it to fit my dataframe, but without success.

gb = df.groupby("country")
gb['result'].agg(lambda x: len(x[x=="Fail"]) / len(x)).sort_values(by="% fail", ascending=False)

To summarize I would like something that would look like this:

   Countries    Products     Percentage
0  Country 1     Product 1     0.5
1  Country 1     Product 2     0.01
2  Country 2     Product 1     0.2
3  Country 2     Product 2     0.05

And so on.

Thank you in advance for your help!

Quang Hoang · Answer 1 · 2020-10-15T15:16:33.850

0

I think you want:

df['percent'] = df.groupby('Country')['Products'].value_counts(normalize=True) * 100

edited Oct 15 '20 at 15:16

answered Oct 15 '20 at 15:10

Quang Hoang

146,074
10
56
74

I believe you messed up the parentheses somewhere in the code – Killi Mandjaro Oct 15 '20 at 15:15
That doesn't work: AttributeError: 'DataFrameGroupBy' object has no attribute 'groupby' – Killi Mandjaro Oct 15 '20 at 15:18
Please see the code again, it's `df.groupby()` not `gb.groupby`. – Quang Hoang Oct 15 '20 at 15:19

How to get percentage of occurrences of a column, grouped by another column? Python

1 Answers1