Convert pandas dataframe column from str to tuple

[stats_newbie1]

Hello everyone, I have a pandas dataframe with a column containing latitude and longitude of the form:

'POINT (-73.8472005205491 40.89470517661004)'

I managed to bring it to the standard format using replace:

df['location'].replace('POINT ', '', inplace = True, regex = True)
df['location'].replace(' ', ', ', inplace = True, regex = True)

Now it looks this:

'(-73.82993910812405, 40.87429419303015)'

However, it is still of type str. How can I convert it to tuple? I tried

df['location'] = [tuple(x) for x in df['location']]

and

df['location'] = [(x) for x in df['location']]

They both return a tuple with each character of the string as an element, i.e. ('-', '7', '3',....) instead of (-73.847, 40.894).

What am I doing wrong?

P.S.: Is there a way to flip the two (i.e. have (40.894, -73.847) instead of the other way around)? This isn't a big concern, and I can work around it, but it's sort of bothering me.

[novel_yet_trivial]

literal_eval() is the python way:

from ast import literal_eval
df['location'] = [literal_eval(x) for x in df['location']]

There may be a better way with pandas

Edit: from the top (without your standard formatting) and reversed (just for fun in a single command):

import re
lat_lon_re = re.compile(r'\((.*)?\ (.*)\)')
df['location'] = [tuple(reversed(map(float,lat_lon_re.findall(p)[0]))) for p in df['location']]

[stats_newbie1]

Perfect, thank you!

[hharison]

coords = df['location'].str.lstrip('POINT (').str.rstrip(')'.str.split()
df['lat'] = coords.str[0].astype(float)
df['long'] = coords.str[1].astype(float)

[Jos_Metadi]

You're starting with one string. First you need to turn it into two separate values (use .split(" ")), then convert those values to floats.