0

I have two dfs of variable length and trying to create a new column df1['CONV_AMOUNT'] by dividing df1['AMOUNT'] by df2['VALUE'] if df1['CURR_CODE'] matches df2['CURR_CODE'].

But after merging im not getting the expected result.

df1:

enter image description here df2: enter image description here

What i have tried from SO solution Multiplying columns in separate pandas dataframe based on similar column values is :

df1['CONV_AMOUNT'] = df1.merge(df2).assign(soln=lambda df: df.AMOUNT / df.VALUE).soln

What im getting as ouptut which is wrong(df1):

enter image description here

Expected df1:

enter image description here

I couldn't able to figure what im missing or doing wrong here. Any help/suggestion is highly appreciated. Thanks in advance!

Mr.B
  • 51
  • 6

0 Answers0