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.
There are refined Excel matching methods. Exact matches can be filtered out easily, the remaining part shall also be partially matched and visually supervised for 100% accuracy. If you send me a sample, I'm going to show you, how it shall be done!
I am a 1st class degree holder in Computing and Information Systems at London Metropolitan University, UK. I am with 5 years experience in data entry and online researches. I have done so many similar projects and I am happy to do this for you. Please refer PM for more details. Thanks in advance!
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.