Data cleaning / list matching
- or -
Post a project like this2656
$$
- Posted:
- Proposals: 21
- Remote
- #1394122
- Awarded
Full Stack Developer : WordPress | Shopify | Next.js | Nuxt.js | RN ( Mobile App Development)
Kanpur
Translator,Virtual Assistant / Internet Researcher / Administrator / PA (Data Entry, Scraping, Analyst, Photo editor, Excel, Powerpoint, Graphics Designer)
Prague
Virtual assistant, translation, Data entry, lead genaretion, English, web research, SEO, social media marketing, Email marketing, Etc.
Bogra
admin support Expert Data entry, seo, Date recharch, produce add, produce sourching,
Jessore
WordPress Data Entry, Data Scraping, Website research, PDF to Excel/Word, Micfosoft Office, Contact synchronization in Excel, Photoshop, InDesign
Zagreb - Centar
10465061467898227087146657814521151449061143218914298861356766133120312203361196463
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
We require 5060 job titles to be matched to the closest job titles found in another list. There are no exact matches in the lists, so the job requires individuals with good general knowledge of job titles to scan the second list for the most suitable match. Upon completion of the job we will review the quality of a random sample of the mappings.
You will be provided with a single spreadsheet that contains 10300 job titles in column A, and the 5300 job titles to match with in column D. Upon finding the closest match, you will copy a number corresponding to the matched job title from column E, and paste it in column B. See the attached screenshot which should make this clear.
Some of the job titles are misspellings or alternative spellings and can be matched easily with the correct job title. Others will require careful consideration against the available options, and some might not be matchable at all (and will have to be skipped).
Please provide your fixed price quotation for all 5060 matches and number of days needed to complete the job.
You will be provided with a single spreadsheet that contains 10300 job titles in column A, and the 5300 job titles to match with in column D. Upon finding the closest match, you will copy a number corresponding to the matched job title from column E, and paste it in column B. See the attached screenshot which should make this clear.
Some of the job titles are misspellings or alternative spellings and can be matched easily with the correct job title. Others will require careful consideration against the available options, and some might not be matchable at all (and will have to be skipped).
Please provide your fixed price quotation for all 5060 matches and number of days needed to complete the job.
Geir H.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
5 Jan 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Geir. Just a few clarifications.
1. Are titles to be matched within close numbers of each other or are there situations when one has to scan through hundreds of entries in the next column to get a match?
2. Is it possible for entries in column D to have more than one match in column A and if so what should one do.
3. In case of misspellings, any room for editing the spelling before or after matching?
If you wouldn't mind, I could do with an invitation.
Thanks
263712
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies