Socrata extract Latitude Longitude with Pandas

socrata-extract-latitude-longitude-w-pandas.py

import pandas as pd
#https://data.medicare.gov/Hospital-Compare/Readmissions-and-Deaths-Hospital/ynj2-r877

inCSV = 'Readmissions_and_Deaths_-_Hospital.csv'

df = pd.read_csv(inCSV)

df.head(10)

df['latitude']  = (df.Location.str.split('(',1).str[1]).str.split(',',1).str[0]
df['longitude'] = ((df.Location.str.split('(',1).str[1]).str.split(',',1).str[1]).str.replace(')','')

ouCSV = 'Readmissions_and_Deaths_-_Hospital_cln.csv'

print len(df.index)

df.to_csv(ouCSV,index=False)