Splitting a column into two columns (Pandas)

Question

I have the following column containing a location (street name, x and y coordinates):

Location
"1139 57 STREET New York (40.632653207600001, -74.000244990799999)"

What I want to do is split it up into three columns: 'Address', 'Longitude' and 'Latitude'. Similar to this:

Location                   Latitude              Longitude
"1139 57 STREET New York   40.632653207600001    -74.000244990799999"

How would I go about doing this?

Possible duplicate of [Pandas Split Column](http://stackoverflow.com/questions/36052257/pandas-split-column) — Stephen Rauch, Apr 03 '17 at 19:27

score 1 · Answer 1 · answered Apr 03 '17 at 19:40

using str.extract

df.Location.str.extract(
    '^(?P<Location>.*)\s*\((?P<Latitude>[^,]*),\s*(?P<Longitude>\S*)\).*$',
    expand=True
)

                   Location            Latitude            Longitude
0  1139 57 STREET New York   40.632653207600001  -74.000244990799999

score 0 · Accepted Answer · answered Apr 03 '17 at 19:47

Another idea that doesn't use regex, assuming your original data is consistently formatted:

def split_location(row):

    Location = row[:row.find('(')-1]
    Latitude = row[row.find('(')+1 : r.find(',')]
    Longitude = row[row.find(',')+2 :-1]

    return {'Location' : Location,
           'Latitude' : Latitude,
           'Longitude' : Longitude}

# original_df is a 1 column dataframe of Location (string) that you want to split
split_df = original_df[Location].apply(lambda x: split_location(x))
split_df = pd.DataFrame(list(split_df))

Splitting a column into two columns (Pandas)

2 Answers2