title: merge two csv file into one csv file using python script
body: <p>I have two CSV files. The file1 has a header with only one record and file2 has a header and multiple records.</p>
  
  <p>file1:</p>
  
  <pre><code>dept_id     dept_role   dept_name   dept_date        dept_ service
  10           man        develop      10/5/2019 13:24    user
  file2:
  id      name    starttime       end time        user manufacturing
  5487    abc     10/5/2019 14:24 10/5/2019 17:24 loc  king           
  5896    egdt    10/5/2019 14:24 10/5/2019 17:24 rgf  king           
  6305    abc     10/5/2019 14:24 10/5/2019 17:24 srf  king      
  6714    egdt    10/5/2019 14:24 10/5/2019 17:24 sd   king   
  7123    abc     10/5/2019 14:24 10/5/2019 17:24 loc  king   
  7532    egdt    10/5/2019 14:24 10/5/2019 17:24 rgf  king   
  7941    abc     10/5/2019 14:24 10/5/2019 17:24 srf  king   
  </code></pre>
  
  <p>expected output like below: </p>
  
  <pre><code>dept_id     dept_role   dept_name   dept_date        dept_ service  id      name    starttime       end time        user manufacturing
  10           man        develop      10/5/2019 13:24    user        5487    abc     10/5/2019 14:24 10/5/2019 17:24 loc  king           
  10           man        develop      10/5/2019 13:24    user        5896    egdt    10/5/2019 14:24 10/5/2019 17:24 rgf  king           
  10           man        develop      10/5/2019 13:24    user        6305    abc     10/5/2019 14:24 10/5/2019 17:24 srf  king      
  10           man        develop      10/5/2019 13:24    user        6714    egdt    10/5/2019 14:24 10/5/2019 17:24 sd   king   
  10           man        develop      10/5/2019 13:24    user        7123    abc     10/5/2019 14:24 10/5/2019 17:24 loc  king   
  10           man        develop      10/5/2019 13:24    user        7532    egdt    10/5/2019 14:24 10/5/2019 17:24 rgf  king   
  10           man        develop      10/5/2019 13:24    user        7941    abc     10/5/2019 14:24 10/5/2019 17:24 srf  king
  </code></pre>
  
  <p>When i run the code below my columns are populated incorrectly - the last columns from files 1 and 2 are merged.</p>