May-19-2018, 08:55 AM
The first question that pops into my mind is: Why isn't that a database? :D
But nonetheless, since your last column is somehow a key for your output (both tables share it and it is individual for each table) read in the first file and create a dictionary where the 6th column is the key and the other elements are stored in a list which is the element for the key of the dictionary, so that when you read the second file you can search for the key and extend the list by the given new elements. the only thing left to do is to prettify the output :)
But nonetheless, since your last column is somehow a key for your output (both tables share it and it is individual for each table) read in the first file and create a dictionary where the 6th column is the key and the other elements are stored in a list which is the element for the key of the dictionary, so that when you read the second file you can search for the key and extend the list by the given new elements. the only thing left to do is to prettify the output :)