dms2dd4.py

#!/usr/bin/python

import csv 
import re													# imports the special modules that we need to run this program.

input_csv = raw_input('What is the name of your DMS csv? ' )
x_column_input = int(raw_input('Which column is the x value stored? ' ) )
x_column = x_column_input - 1

y_column_input = int(raw_input('Which column is the y value stored? ' ) )
y_column = y_column_input - 1

output_csv = raw_input('What do you want to call your ouput DD csv? ')

dms_input = open(input_csv, 'rb')							# The input file with our coordinates
reader = csv.reader(dms_input)
next(reader, None)											# Skips the Header Row

final_output = open(output_csv, 'wb')				# Creates Output CSV
writer = csv.writer(final_output)							# Function to write data to that CSV

for row in reader:
    dms_x_list = ([re.sub("[^0-9]","", row[x_column])])		# Strips just the numbers out for the x
    for item in dms_x_list:
        x_list = ([float(dms_x_list[0][0:2]) + float(dms_x_list[0][2:4]) * 1/60 + float(dms_x_list[0][4:8]) / 10 * 1/60 * 1/60])
    #print dms_x_list
    dms_y_list = ([re.sub("[^0-9]","", row[y_column])])		# Strips just the numbers out for the y
    for item in dms_y_list:
        y_list = ([float(dms_y_list[0][0:2]) + float(dms_y_list[0][2:4]) * 1/60 + float(dms_y_list[0][4:8]) / 10 * 1/60 * 1/60])
    #print dms_y_list
    combo= dict(zip(x_list, y_list))						# Converts the two numbers as a dictionary
    #print combo
    for key, value in combo.items():
        writer.writerow([key, value])						# Writes the data in the dictionary to a csv


dms_input.close()											# Closes the input file
final_output.close()										# Closes the output file