0

I can't seem to get this down I am trying to merge two datasets of different sizes with them both having one different field in each.

DF1:

 ID        Job_Title        Job_ID  
 101       Sales Assc.      1906
 102       Sales Assc.      1906
 103       Sales Manager    1632
 104       Tech Supervisor  2302
 105       Sales Manager    1632
 106       Tech Support     1826
 .
 .
 . 
 405       Tech Supervisor  2302

DF2:

 Job_ID     Job_Title         Emp_Type
 1630       Sales Director      Mgr
 1631       Office Assistance   Ast 
 1632       Sales Manager       Mgr
 1826       Tech Support        Emp
 1900       Sales Consult.      Emp
 1904       Tech Consultant     Emp
 1905       Tech Director       Mgr
 1907       Admin Assistance    Ast
 2300       Lead Tech           Emp
 2302       Tech Supervisor     Mgr 
 

I would like to merege it to look like this:

DF3:

 ID    Job_Title       Job_ID      Emp_Type 
101    Sales Assc.      1906        Emp
102    Sales Assc.      1906        Emp 
103    Sales Manager    1632        Mgr  
104    Tech Supervisor  2302        Mgr
105    Sales Manager    1632        Mgr
106    Tech Support     1826        Emp
.
.
.
405    Tech Supervisor  2302        Mgr     

0 Answers0