The project is to merge datasets. I have a master dataset of 50,000+ entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have a file of about 10000 entries each that contain business name, address, longitude/latitude. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr).
Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.
60 freelancers are bidding on average $294 for this job
Hello Mrs Judy! I am confident to do this correctly and efficiently using several methods & criteria. Kindly see PM! Experienced ICT & Office professional for over 20yrs. Just give me a chance, please! Thanks!
I am an expert at writing macros in excel and I can write a script that will compare the latitude and longitude which should be unique to each entry and merge the files with that script.