Address-Normalization-For-Taiwan-Based-on-GoogleAPI-and-Regular-Expression

What You Need To Do?

1.You need to apply an Google map api from :https://cloud.google.com/ .

2.You need to set excel file table name as 'address', you can reference example file : test2.xlsx

How it work?

1. This project use Regular-Expression to deal with these addresses in first stage that make sure it conform to the Google api format.

2. It may get wrong if the fotmat is incorrect,so need to fix it first.(Stage1.)(Example : 三民路十三號 --> 三民路13號 , 6段 --> 六段 , 3民路 --> 三民路)

3. In second stage use google map api to patch these addresses.

4. Folder 'Log' is for logging all processes and also error.

5. This Project support csv & xlsx

6. It handle blank symbols and also transform full-shaped to half-shaped.

Result

Orginal Data

After First Stage

After Second Stage

Final

1.You may get some error in some special cases that are not thought of , cause I'm not very familiar with Geographical.

2.If there are some logical errors , please let me know.

3.If you find any error or you have any questions,please contact we for free , welcome everyone to discuss.

This Project is actually used in corporate customer address , according to that case I fix some mistakes in ver1.0(Now is Ver2.0) , and it still need lots of cases for better result.