Geocodes NC SBE Statewide Voter Registration using the NC SBE address points.
import pandas as pd
#Read in Wake voter data and address list
dfVoter = pd.read_csv('./data/NCSBE/ncvoter_Wake.csv')
dfAddresses = pd.read_csv('./data/NCSBE/address_points_sboe/Shapefiles/Address_pts/address/address_points_wake.csv',
usecols=['st_address','city','zip','latitude','longitude'])
#Clean street address
dfVoter['addr'] = dfVoter.res_street_address.apply(lambda x: "{} {} {}".format(x.split()[0],x.split()[1],x.split()[2]))
#Join coords to dfVoter
dfX = pd.merge(left=dfVoter,
right=dfAddresses,
how='left',
left_on=['addr','res_city_desc','zip_code'],
right_on=['st_address','city','zip']
)
#Save to file
dfX.to_csv('./data/NCSBE/ncvoter_Wake_geo.csv')