What is your current level of experience in freelance work?
I have a very large data file of corporate spend data for a large manufacturing company. It is 14 million lines of data in a single, 6GB CSV file. I need to merge / enrich the data with certain more detailed attributes from some separate files I have. In the large file -- many of the columns provide a unique ID number, such as "vendor ID number," and I then need to find those numbers in the "vendor ID master list" file, and populate the vendor data back into new columns in the large original file. Then, once the large file is fully filled out with the supporting data all merged in -- we need to create various analyses and visualizations of the data.