Split Latitude and Longitude - but extra column

Question

I have a dataset that has latitude and longitude listed as follows under the column name location_1:

   (34.0545, -118.2499)

See I can remove the parenthesis and can able to move them into separate columns under normal circumstances, but I don't know how to make it work while dropping the first comma before the numbers.

Answer 1

I think this should work with the tidyr::extract, following with the regex().

tidyr::extract(df, location_1, c('lat', 'lon'), 

                  regex = ',?\\s*\\((\\d+\\.\\d+).*(-?\\d+\\.\\d+)\\)')

If you are a beginner in R then do check out the R programming tutorial.