Update a DF in Pandas based on condition from different DF

Question

I have df1

index   state   fin_salary  new_title
5         CA      1          Data Scientist
8         CA      1          Data Scientist
35        CA    150000       Deep Learning Engineer
36        CA    1            Data Analyst
39        CA    1            Data Engineer
43        CA    1            Data Scientist
56        CA    1            Data Scientist

And another datfarame df2

state   new_title                     fin_salary
CA  Artificial Intelligence Engineer    207500.0
CA  Data Analyst                       64729.0
CA  Data Engineer                      146000.0
CA  Data Scientist                     129092.75
CA  Deep Learning Engineer             162500.0
CA  Machine Learning Engineer          133120.0
CA  Python Developer                   96797.0

So I want to update df1 with fin_salary from df2 based on condition state and new_title and where fin_salary = 1. So my desired output should be

index   state   fin_salary           new_title
5         CA      129092.75         Data Scientist
8         CA      129092.75         Data Scientist
35        CA    150000              Deep Learning Engineer
36        CA    64729.0             Data Analyst
39        CA    146000.0             Data Engineer
43        CA    129092.75            Data Scientist
56        CA    129092.75            Data Scientist

Serge de Gosson de Varennes · Accepted Answer · 2022-02-07 15:03:44Z

1

You can do this:

DF = df1.merge(df2, on=['state','new_title'], how = 'inner')

df_final = DF[DF['fin_salary']==1]

answered Feb 7, 2022 at 15:03

Serge de Gosson de Varennes

11.6k4 gold badges30 silver badges60 bronze badges

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

2 Comments

Rakesh Sharma Over a year ago

Yes it helped. I tweaked a bit more to get my desired result. Thanks a lot.

Serge de Gosson de Varennes Over a year ago

Glad it helped! Happy coding! And welcome to SO!

Collectives™ on Stack Overflow

Update a DF in Pandas based on condition from different DF

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related