I am a beginner Python user and I am having troubles understanding some things. I want to convert 2 whole columns (lat, long) in a.csv file from degrees minutes seconds (dms) to decimal degrees (dd) (ie. 46°57'01'N to 46.950278). I'm probably doing this the long way around, but I don't know any better. So far I have renamed the headings in my.csv to be readable in ArcGIS.
![Convert excel to json Convert excel to json](http://slideplayer.com/5853391/19/images/3/Introduction.jpg)
![Convert excel to json Convert excel to json](/uploads/1/2/4/2/124228775/365450561.jpg)
Then I used Excel to replace the °, ', and 'N with spaces and then put them in a new.csv file with their respective ID number (Accnum).wanted to use Python, but couldn't figure it out for the life of me. Then I replaced the spaces with commas to be able to convert each section coordinate. I also made a def to convert dms to dd, dm to dd and d to dd.did this because some of my coordinates are only degrees and some are only degrees minutes. Here is an overview of my.csv file current format: Accnum lat long881138 80,2273 89843 56,55,28 7004 48 91,58I don't know how to apply my defs to the.csv file to do the final conversion to dd.
Converting coordinate DD to DMS in Excel (increase the decimal number for the seconds) Please community and friends. When I use the function to convert degree in DMS in the excel, as the follow below, in the visual basic, someone knows how can I increase the number of decimal places for the seconds?