Jan-16-2018, 06:36 AM
(This post was last modified: Jan-16-2018, 06:36 AM by saibottrenham.)
Hey guys,
I have a data frame such as
Means whenever jobtag from dfA matches jobtag from dfB I want the suc_score from the row in dfA to be added to dfB
How can I achieve that?
Cheers
I have a data frame such as
dfA = id jobtag suc_score 0 54 channel manager 25 1 77 channel manager 18 2 99 client manager 23 3 80 corporate account manager 4 4 110 compliance manager 25and another dataframe such as
dfB = jobTag occ median_salary suc_score 0 software development engineer iv 1 0 nan 1 senior engineer 17 0 nan 2 marriage and family therapist 1 0 nan 3 founder 1 0 nan 4 principal network engineer 1 0 nanwhat I want to do is map the suc_score from dfA to dfB based on the Jobtag
Means whenever jobtag from dfA matches jobtag from dfB I want the suc_score from the row in dfA to be added to dfB
How can I achieve that?
Cheers