Hope you all are well. I am looking to merge two datasets however, I want to match them based on specific requirements.
The datasets I have are:
1. Job Information
2. Candidate Information
The job information dataset contains the minimum requirements by the firm. The variables are gender, years of experience, education, and the type of job category this advertised job is. The gender variable takes the value 3 if there are no gender requirements from the job posted.
The data for that is below:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(firmID jobID edu_reqrd) byte yrs_exp_reqrd int job_category byte gender 1 1 7 0 101 3 1 2 8 0 101 3 1 3 8 2 108 3 2 1 4.2 1 101 2 3 1 4.2 0 116 1 4 1 3 0 201 2 5 1 1 3 212 2 6 1 1 3 216 2 7 1 2 4 214 2 8 1 7.5 1 114 3 9 1 8 2 106 3 9 2 8 2 106 3 end label values gender gender label def gender 1 "Male", modify label def gender 2 "Female", modify label def gender 3 "Any", modify label var firmID "ID For firm placing Ad" label var jobID "Job Serial Number for Firm" label var edu_reqrd "Min. Edu rqrd by firm" label var yrs_exp_reqrd "Min. Yrs of Exp" label var job_category "Job code that define type of job" label var gender "Are there gender requirements for job?"
The second dataset contains information of the candidates. The candidate has to be matched to jobs if they meet the criteria set by the firm. Candidates can be matched to multiple jobs even within the same firm. The candidate dataset will also have a variable that specifies whether the candidate wishes to applyto a specific job category or whether the candidate has no preference and would like to be matched to any job which would mean that regardless of the category, if the candidate meets all requirements then he/she should be matched to it. The dataset is below:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte(ID candidate_gender) float education_level byte exp_years_total str71 job_choice_1 str51 job_choice_2 byte job_choice_any 1 2 1 30 "" "201 202 203 206 210 214 217" . 2 2 7 7 "101 102 105 109 112 113 114 115 116 118 119 120" "" . 3 1 7 0 "106 108" "" . 4 2 2 4 "" "201 202 205 206 207 208" 1 5 1 1 0 "" "204 205" 1 6 2 1 20 "" "201 202 205 206 207 208" 1 7 2 2 0 "" "201 202 205 206 208 213" 1 8 2 1 16 "" "201 202 205 206 207 208 213" 1 9 2 7 1 "102 103 104 105 107 108 109 110 111 112 113 114 115 116 117 118 119 120" "" . 10 2 9 0 "102 108 109" "" . 11 2 8 8 "105 108 110 112 113" "" . 12 2 6 2 "101 102 103 104 105 108 109 110 112" "" 1 13 2 8 47 "108 109" "" . 14 2 8 17 " 102 109 112 114" "" . 15 1 8 0 "105 106 109 110 111" "" . 16 2 7.5 1 "101 102 109 112 117" "" . 17 1 4.2 0 "" "201 203 204 207 208 209 210 212" . 18 1 9 0 "106" "" . 19 1 9 1 "106" "" . 20 2 1 15 "" "202 205 206 207 208" 1 21 2 1 20 "" "217" . 22 1 3 0 "" "212" . 23 2 1 7 "" "201 202 205 206 207 208 213" 1 24 1 1 0 "" "201 203 204 205" 1 25 2 2 13 "" "212" . 26 2 1 10 "" "213" . 27 2 2 2 "" "201 202 205 207 213 214 215" 1 28 2 3 0 "" "201 202 205 206 207 211 214 215" 1 29 1 1 15 "" "201 202 203 204 205 206 208 217" . 30 2 8 10 " 102 109 112" "" . 31 1 7 1 "102 105 110 112" "" 1 32 2 8 15 "102 108 109 110 112" "" 1 33 1 2 0 "" "203 204 205" 1 34 2 4.6 10 "" "201 207 217 202 208 213 215" . 35 2 3 15 "" "201 202 205 206 207 208 213" 1 36 2 1 10 "" "201 202 205 206 207 208" 1 37 2 3 7 "" "201 202 205 206 207 208" 1 38 2 3 10 "" "201 202 205 206 207 208" 1 39 2 2 7 "" "201 202 205 206 207 208 213" 1 40 2 3 5 "" "201 202 205 206 207 208 214" 1 41 1 8 0 "102 104 105 106 108 109 110 111 112" "" 1 42 1 1 0 "" "203 205 209 212" 1 43 2 4 0 "" "201 205 207 208" 1 44 2 4 0 "" "201 202 205 207" . 45 2 8 8 "101 102 103 104" "" . 46 2 3 0 "" "201 202 205 206 207 208 211 213 214 215" 1 47 2 1 0 "" "201 202 205 206 207 208 211 213 214 215" 1 48 2 7 3 "101 102 103 104 105 110 113" "" . 49 2 2 5 "" "201 207 213" . 50 2 8 3 "101 102 104 106 107 112 115 116 117" "" . 51 2 1 20 "" "201 202 205 206 207 208" 1 52 1 4 0 "" "204 205 209 212" . 53 2 1 17 "" "201 202 205 206 207 208" 1 54 2 1 25 "" "201 202 205 206 207 208" 1 55 2 2 8 "" "201 202 204 205 206 207 208 209" 1 56 2 4 8 "" "201 202 204 205 206 207" 1 57 2 2 0 "" "201 202 205 206 207 208" 1 58 2 2 9 "" "205 207 208 211" . 59 2 1 6 "" "201 202 205 207" . 60 2 7.5 2 "117" "" . 61 2 7.5 1 "117" "" . 62 2 1 5 "" "201 202 205 208 211 213 214 215" 1 63 1 3 0 "" "204 205" . 64 2 4 2 "" "201 202 205 207 213 214" 1 65 2 3 14 "" "201 202 204 205 206 207 209 211 212 213 217" . 66 2 4 10 "" "201 202 205 207 208 213" 1 67 2 8 5 "101 102 105 108 109 110" "" . 68 2 3 15 "" "204" . 69 1 4 6 "" "201 207 210 212" . 70 2 3 10 "" "201 204 205 207" 1 71 2 1 17 "" "201 202 203 205 206 208 209 211 213 214 215 216 217" . 72 1 1 4 "" "201 202 203 205 206 209 210" . 73 1 9 . "102 110 112 114" "" . 74 2 2 30 "" "202 205 207 215" . 75 1 2 10 "" "203 204 205 212" . 76 2 1 12 "" "201 202 205 207 208 211 214 215" 1 77 2 1 20 "" "201 202 207 214 215" . 78 2 3 0 "" "201 202 205 206 207 208 211 213" 1 79 2 4.6 . "" "202 207 217" . 80 1 4 0 "" "201 204 205 212" 1 81 1 1 0 "" "203 204 209 210" 1 82 1 1 0 "" "203 204 209 212" 1 83 1 1 0 "" "201 203 204 205 210 212" 1 84 2 4 22 "" "208" . 85 1 3 1 "" "201 203 204 205 209 212" 1 86 2 2 3 "" "201 202 205 206 207 208" 1 87 2 3 1 "" "201 202 205 206 207 208" 1 88 1 4 0 "" "203 204 205 208" 1 89 2 2 8 "" "213" 1 90 1 3 2 "" "203 204 205 209" 1 91 2 3 35 "" "205 207 208" 1 92 2 3 3 "" "201 205 207 208 213" 1 93 1 1 12 "" "203 204 205" 1 end label values candidate_gender gender label def gender 1 "Male", modify label def gender 2 "Female", modify label var ID "Candidate ID" label var candidate_gender "Candidate Gender" label var education_level "Candidate Education Level" label var exp_years_total "Candidate Years of Experience (Total)" label var job_choice_1 "Candidate job preference (1st)" label var job_choice_2 "Candidate job preference (2nd)" label var job_choice_any "Candidate will apply to any job?"
Essentially:
candidate_gender == gender
education_level >= edu_rqrd
exp_years_total >= yrs_exp_reqrd
job_catagory should fall within job_choice_1 or job_choice_2 or should be matched if job_choince_many==1
I will be highly grateful if someone from the community can take time out to help me figure this out. Thank you!
0 Response to Matching/merging Job seekers to job posts if they meet requirements
Post a Comment