Data Scrub

We have a business directory db with 65,000 records that needs to be cleaned up and all entries assigned relevant category and sub-category id's. We will provide the category codes for assignment. Most records will be assignable to a main category and possibly multiple sub-categories. (Example: A record for an automobile body shop main be matched to: Main category: Automobiles / Sub-Cat: Auto Body / Sub-Sub Cat: Auto Body Repair, etc. The categories / sub-categories go 5 levels deep. The data is in a .csv format. Project requires data admin experience and ability to look at a record and identify which sub-category(s) the record should be matched to. Also, will require good QA checking to ensure accuracy. ## Deliverables We have a business directory db with 65,000 records that needs to be cleaned up and all entries assigned relevant category and sub-category id's. We will provide the category codes for assignment. Most records will be assignable to a main category and possibly multiple sub-categories. (Example: A record for an automobile body shop main be matched to: Main category: Automobiles / Sub-Cat: Auto Body / Sub-Sub Cat: Auto Body Repair, etc. The categories / sub-categories go 5 levels deep. The data is in a .csv format. Project requires data admin experience and ability to look at a record and identify which sub-category(s) the record should be matched to. Also, will require good QA checking to ensure accuracy. Attached you will fnd a small project I started and a excel file as sample how data should look like, on the project out of 23795 data just about 450 was updated I need help to fix what is wrong that I can rich at least 20000 matchs, not all records will match because of the Company Name is not clear? but I should get more than what Im getting. SOme will need to be updated manualy I need this ASAP, yesterday