python pandas adding 2 dataframe with specific column

Question

I have 2 dataframe the one looks like this :

      Date     id    name    amount    period   
2011-06-30      1       A     10000         1
2011-06-30      2       B     10000         1
2011-06-30      3       C     10000         1

And another one looks like this :

id   amount    period   
 1    10000         1
 3    10000         0

And the result that i want looks like this :

id     amount    period   
 1      20000         2
 2      10000         1
 3      20000         1

How can i do that in python pandas?

jezrael · Accepted Answer · 2020-05-12 05:36:52Z

2

Use concat with filtered columns with aggregate sum:

df = pd.concat([df1[['id','amount','period']], df2]).groupby('id', as_index=False).sum()
print (df)
   id  amount  period
0   1   20000       2
1   2   10000       1
2   3   20000       1

EDIT:

If need subtract by id create index for id and then use DataFrame.sub:

df11 = df1[['id','amount','period']].set_index('id')
df22 = df2.set_index('id')

df3 = df11.sub(df22, fill_value=0).reset_index()
print (df3)
   id   amount  period
0   1      0.0     0.0
1   2  10000.0     1.0
2   3      0.0     1.0

edited May 12, 2020 at 5:36

answered May 12, 2020 at 5:16

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

giri hanbudi Over a year ago

but how if i have other calculation like substract or whatever?

Collectives™ on Stack Overflow

python pandas adding 2 dataframe with specific column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related