[Tutor] Creating a match file

[Emile van Sebille]

On 9/20/2015 12:19 PM, EILEEN CHURCH CARSON wrote:

> I want to write a program that reads in data from two csv files with 6
> columns each. I want it to determines if the data in the first two columns
> is the same, and if so read all six columns in that line from each of the
> two files into a 12 column output file.

I think I'd read in the first file and create a dictionary using the 
first two fields as the key, and the remaining six fields as the data. 
then, read in the second file, loop through again creating a key of the 
first two fields and if that exists in the first dictionary, get that 
data and write all 12 fields to a new dictionary.  When done, write the 
results to the output file.

Emile