This Python application correctly generate Longitude and Latitude of an any spatial object that is defined by it's address features in Pandas (Python module) dataframe by using OpenStreetMap API that is very friendly with Python environment and add those Longitudes and Latitudes to an existing data table.

OpenStreetMapAPIFindLotLat.py

import pandas, os

os.listdir()

df1=pandas.read_csv('supermarkets.csv')

import geopy
dir(geopy)

from geopy.geocoders import Nominatim

nom = Nominatim()
n=nom.geocode("London tower")
print(n.latitude, n.longitude)

#add a new Adresss column
df1["Address"]=df1["Address"]+", "+df1["City"]+", "+df1["State"]+", "+df1["Country"]

#send this string to Geocode method
df1["Coordinates"]=df1["Address"].apply(nom.geocode)

#Set values to Longitudes and Latitudes
df1["Latitude"]=df1["Coordinates"].apply(lambda x: x.latitude if x != None else None)
df1["Longitude"]=df1["Coordinates"].apply(lambda x: x.longitude if x != None else None)

supermarkets.csv

Hi,
this code BELOW can produce error because of TIME....

#send this string to Geocode method
df1["Coordinates"]=df1["Address"].apply(nom.geocode)

Code with time delay will be useful example !

Best regards,
Isaco