I'll provide a list of addresses in 1 excel column.
The addresses are formatted like this:
Knutton Lane<br> Newcastle-under-Lyme<br> Staffordshire<br> ST5 2GB<br> <a target="_blank" href="[login to view URL],-2.237987">Find on Google map
The task will consist in splitting the address in 4 columns:
In this example shown it will be like this:
Column4=Postal Code=ST5 2GB
Column5=Country=England...this is not appearing in the excel, it has to be filled with England/Wales/Scotland/Northern Ireland depending on the County (a list with all the towns/counties/Countries will be provided).
Issues to take into account:
1. This is not only a mechanic task (like splitting text inside <br> tags): some addresses will not have the data regarding street address or county or town or Postal Code. This has to be taken into account.
2. Names of cities: have to be standarized. For example: "Newcastle-under-Lyme" could appear in the list as "Newcastle under Lyme" or "newcastle-under-lyme". All the city names have to be standarized. The same for the names of counties.
3. Names of counties have to be filled if they are empty. A list of cities/counties will be provided, see it attached.
The task has to be done fast: in 1 day or 2 days maximum.
37 freelancers estão ofertando em média $104 para esse trabalho
Hi there, I can standardize a list of addresses in excel. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Hello! I can finish the task in 1 day. I can start now. I will standardize your file without error. You will not be dissapointed, I have a big 34% rehire rate. Thank you!
Hello, this is strictly data manipulation task and i can do this using python, can you please message me so that we can discuss more? well i need 1-2 days MAX, thanks!
Hi, I gone through task description and attached excel and csv. I understood your requirement. I can do this job perfectly within budget and within time frame. thanks Pallavi
Hello Sir/Madam Data is in tagging mode. I can give you the output in required mode on deadline time (2-3 days). Please come to chat to discuss more. Thank you.