Screen Link:
data-cleaning-walkthrough-13
My Code:
pattern = r"(\(.+\))"
geodata=data["hs_directory"]["Location 1"].str.extract(pattern).str.replace("(","").str.replace(")","").str.split(",")
geoframe=pd.DataFrame(geodata.loc[:].tolist(), columns=["lat","log"])
data["hs_directory"]["lat"]= geoframe["lat"]
data["hs_directory"].head()
This is alternate solution I shared so that we can extract latitudes using string parallel function which is more efficient.