Description
In this question, you are required to use TomTom’s Geocode API to find coordinates of S&P 1500’s addresses, and compute each firms’ distances with the White House (38.8976763, 77.0387185). TomTom is a company specialized in GPS navigation and provides in car GPS systems for US, Canada, Europe, Hong Kong and many different countries. Not available in China and Japan though.
Recommended Packages
TomTom
geopy
Useful Links:
https://developer.tomtom.com/search-api/search-api-documentation
https://geopy.readthedocs.io/en/stable/#module-geopy.distance
Input
coname_addresses.xlsx
Output
output.xlsx
Sample Input
CONAME address
AAR CORP address
Sample Output
CONAME address lat lng distance
AAR CORP address 41.9872218 -87.9812063 10919.769252