Sometimes, we want to get percentage of total with groupby with Python Pandas.

In this article, we’ll look at how to get percentage of total with groupby with Python Pandas.

How to get percentage of total with groupby with Python Pandas?

To get percentage of total with groupby with Python Pandas, we can use the transform method.

For instance, we write

df['sales'] / df.groupby('state')['sales'].transform('sum')

to get the total with

df.groupby('state')['sales'].transform('sum')

Then we use that as the divisor for df['sales'] to divide each value in the sales column by the total.

Conclusion

To get percentage of total with groupby with Python Pandas, we can use the transform method.