Pandas dataframe cell divided by subtotals

Question

I have a dataframe which looks like this:

My end goal is to calculate the percent of each purpose and for each origin

So the final table should look this:

Any assistance or direction will be greatly appreciated

`df.dropna(how='any').pop('values')` ? – Umar.H Dec 24 '20 at 00:31 — Umar.H, Dec 24 '20 at 00:31

score 0 · Accepted Answer · answered Dec 24 '20 at 00:59

0

Use this to drop the unwanted rows

i = df[(df.Origin == 'total origin')].index
df = df.drop(i)

And this to drop the Values column

df = df.drop(columns='Values')

answered Dec 24 '20 at 00:59

Etch

1 Answers1