title: Merge Multiple CSV with different column name but same definition
body: <p>I have different sources(CSV) of similar data set which i want to merge into single data and write it to my DB. Since data is coming from different sources, they use different headers in their CSV, i want to merge these columns with logical meaning.</p>
  
  <p>So far, i have tried reading all headers first and re reading the files to first get all the data in a single data frame and then doing if else to merge the columns together with same meaning. Ideally I would like to create a mapping file with all possible column names per column and then read CSV using that mapping. The data is not ordered or sorted between files. Number of columns might be different too but they all have the columns i am interested in.</p>
  
  <p>Sample data:<br>
  File 1:<br>
  id, name, total_amount...<br>
  1, "test", 123 ..  </p>
  
  <p>File 2:<br>
  member_id, tot_amnt, name<br>
  2, "test2", 1234 ..  </p>
  
  <p>i want this to look like   </p>
  
  <p>id, name, total_amount...<br>
  1, "test", 123...<br>
  2, "test2", 1234...<br>
  ...</p>
  
  <p>I can't think of an elegant way to do this, would be great to get some direction or help with this.</p>
  
  <p>Thanks</p>