My situation involves having a pair of .csv files that resemble the following example:
date,type,brand,model,price
2014-11-27, electric, tesla, model s , 100000
2014-11-27, diesel, bmw, m3, 90000
2014-12-13, hybrid, toyota, yaris , 20000
How do I go about combining these files to create a single entity?
Both files contain a header row with column names. Can this row be removed or added back in if I receive the files without it?