Looking for someone to help create a python script that will take a messy address like this:
1060 Salk Road, 7, Pickering Ontario
and return a clean address like:
1060 Salk Rd, Pickering, ON L1W 3C5, Canada
I am using a script but it sometimes shows incorrect unit (sub premise #)
And also the latitude and longitude.
This will need to be done for excel file. The code has already been started. Need help making it work.