Convert County State Names To Coordinates

I want to convert county state name to coordinates. county: fips state_fips county_fips state county 1000 1 0 Alabama Alabama 1005 1 5 Alabama Barbour County

Solution 1:

from time import sleep
from geopy.geocoders import Nominatim
import pandas as pd
import numpy as np

geolocator = Nominatim()

def geocode_with_sleep(query):
    sleep(1)
    return geolocator.geocode(query)

county['coord'] = county['county'].apply(geocode_with_sleep)

Another way is described in http://www.jackmaney.com/2015/01/09/geocoding-rate-limited-queue/