Using Geocode by Awesome Table

Ok so I have two files with addresses and I wanted to know if they will match altogether, the idea is to bring string to something numeric like a number.

so we have Address 1: Block 5 Lot 21, Pamplona Park subdivision Metro Manila

and we have Address 2: Unit 2721 Block 6, Lot 21 Pamplona Park, Las Pinas Subdivision

we turn this into Latitude and Longitude values and we try to compute the distance between two addresses.

we can do this by using an add on extension from Google sheets, I found this nifty add on called Geocode by Awesome table (you can add this plug in by going to Extensions >Add Ons > Geocode by Awesome Table) Once installed, you can run at least 10,000 rows on it for free. and So I started using it and it took me around 15 minutes to finish on at least one file with 5000 rows.

After inspecting the file, there were some null values as well, but Google was able to highlight those automatically by highlighting them in Red.

There is also a Haversine formula I found on Google that seems so handy:

= 2 * 6371000 * ASIN(SQRT((SIN((E2*(3.14159/180)-B2*(3.14159/180))/2))^2+COS(E2*(3.14159/180))*COS(B2*(3.14159/180))*SIN(((F2*(3.14159/180)-C2*(3.14159/180))/2))^2))

all you have to do is plug in the values for address 1 with Latitude 1 and Longitude 1 and address 2 with Latitude 2 and Longitude values.

you can adjust the value of 6,371,000 since it is being used for "meters" adjust it to 6,371 if you want it in "kilometers"

So there you go, a handy tool where you can do batch Geocoding without manually inputting each Latitude and Longitude value for an address.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Bert is a Data Science Manager who likes to work on Data and Data Science Algorithms that can make compelling stories or insights useful to the Organization. He likes working with Data Teams and Use Cases that can bring ROI or cost savings to the company. He has twenty years experience and has a Math and an MBA degree from De La Salle University.