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