Subtraction of values between two values when group by is applied to multiple columns in pandas

Question

So my issue is I want to get the value of the subtraction of the secondary groups for each primary group.

I applied groupby() for two columns 'Country' and 'doc_type' and I want the subtraction of the values (SAL-SRT) obtained for each Country, using pythons pandas

Country      doc_type
Afghanistan  SAL         4375.0
             SRT          144.0
Algeria      SAL         8613.0
             SRT           28.0
Australia    SAL          356.0

Welcome to StackOverflow. You could improve your question by showing us the code you have tried so far and your desired results. — rajah9, Jun 08 '21 at 11:09

score 1 · Answer 1 · answered Jun 08 '21 at 09:57

1

try pivot()

df.pivot(index='Country', columns='doc_type', values='values')

reset_index() & fillna(0), then subtract:

df['delta'] = df.SAL - df.SRT

answered Jun 08 '21 at 09:57

MAFiA303

1,157
11
10

Subtraction of values between two values when group by is applied to multiple columns in pandas

1 Answers1