I would like a small application that interfaces with Google maps to provide driving time and distance. The application inputs will be 2 .csv files of identifiers and addresses. The application output should be 1 .csv file that contains the driving distance and time returned by gmaps for each combination of the 2 input files.
## Deliverables
The 2 input .csv files will contain for each record, two unique identifier fields that are not relevant to gmaps but need to be retained .
Example for first input .csv is "ALU0,Lunsford,***1019 ann ave,61021***" and may contain from 1 - 500 individual records. (GMaps is only concerned with the highlighted portion)
Example for second input .csv is "10255, Bobs Barber Supply, ***129 Cherokee Dr, 28117***" and may conatin from 1 - 500 individual records. (again, Gmaps is only concerned with the highlighted portion)
If the above example comprise the entirety of input files 1 and 2, the output file would look something like this ""ALU0,Lunsford,1019 ann ave,61021,10255,Bobs Barber Supply,129 Cherokee Dr,28117,***829,0,13,37***"
Where- **829** is the miles, **** is the travel days, **13** is the travel hours, and **37** is the travel minutes.
If input .csv 1 conatined 10 records and input .csv 2 contained 20 records, the output .csv would contain 200 records.
I am open to suggestion but this seems simple enough to me.