Problem:

I have a data frame containing GPS coordinates where instead of using the symbols for degrees and minutes, they are written in the format where decimal points have been used instead, which is incorrect:

I’d like to convert all the GPS coordinates into DMS (degrees, minutes, seconds), whereby all the coordinates are written in this format:

27°57’67.9, 33°88’02.7

It’s quite labour-intensive to manually revert all the GPS coordinates individually as the coordinates are written in two separate columns with over 800 rows.

I can’t figure out how to do this conversion where I can add the symbols for degrees (°), and minutes (‘) to all the coordinates in my data frame using R.

In my data frame, some of the GPS positions are unknown and they are written in this format in the cells:

The code needs to recognise these missing GPS positions.

If anyone can help, I’d be deeply appreciative