Cleaning zip code and town in Excel list, via a normalized list of zip code/town
€8-30 EUR
Ukończony
Opublikowano prawie 9 lat temu
€8-30 EUR
Płatne przy odbiorze
We have a list of 3000 addresses which were inputed with no control on zip code or town.
So sometines, we have:
- good zip code, good matching and spelling town: 75001 PARIS
- bad zip code: 79001
- bad spelling town: PARICE
- bad matching: 77001 PARIS
We want to clean these addresses before storing our Excel data file into Access.
To perform this job, we can provide
- a list like: ADDRESS_ID, ZIPCODE, TOWN
- and also the normalized list of zip code/town, as a reference.
At the end, we expect a list of ADDRESS_ID + ZIPCODE
where each ZIPCODE corrects perfectly the initial list:
- good zip code, good matching and spelling town: 75001 PARIS >> 75001
- bad zip code: 79001 >> 75001 (because the city PARIS is 75001)
- bad spelling town: PARICE >> 75001 (because we don't care about the spelling: we need only right ZipCode)
- bad matching: 77001 PARIS >> 75001 (because the city PARIS is 75001)
Thanks in advance for your help
(nb: please, bid only if you can deliver quickly)
Hello,
I have a script already written that does something similar to this and can configure it to these requirements within 15 minutes. Feel free to contact me any time, i can get started right away.
€8 EUR w 0 dzień
3,4 (1 opinia)
0,0
0,0
29 freelancerzy składają oferty o średniej wysokości €35 EUR dla tej pracy
Greetings!!! I am very much interested in your project. Can we discuss details about your project so that I can submit some sample entries and it will help you to understand our Quality of work and It will also help me to give you fair price and exact time frame?...Awaiting for your response.......Thanks
Hi,
I am good at web browsing. I can find out the right zipcode and city.. I have understood ur requirement.
I would like to take up this project and would like to discuss.
Hi,
I have read your project description . i am highly interested to do this task .I will show you a sample based on your instructions ,if you are happy with that then i will start the task.
Let's discuss and start right now.
Awaiting for your positive reply,Hope we will work together for this project.
thanks.
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
Hi, I will perform on this task with excel and this is not a very complicated task, I can get it done in 3 hours max, but for better understanding to this job, please share your sheet.
I have very good expertise in excel with all aspects, you may trust for me smooth and fast turnaround and according to your directions.
I am waiting to have yours feedback in response of my proposal.
Thanks.
Dear Hiring Manager,
We can do this JOB efficiently and effectively
Have a great day to you, I am interested to do this job, I have over 15 years experience in the field of web research, web scraping, data-entry in excel and as admin/ virtual assistant. And I am a computer and web savvy, my goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Thank you
Kind regards
Heric. P.
Note: I am quick, detail oriented and have expert team members with me to do this job and have high speed internet connection and I look forward to hearing from you to start this job soon. Thanks
Hi,
I would like to work on the project.I will be able to get the excel sheet normalized with the data that you need.I have a 100% completion rate.
Hope you hire me on this.
Regards,
Jitin T
It would be glad to work on your project and ready to start now. I will ensure I will work 100% accurate. Please PM me and lets discuss about this project. looking forward to work with you.
thank you
best regards
jovi
Hello. I can do this for you very fast and accurate. Price is negotiable. Please feel free to contact me. Please select me for this job,i dont let you down