title: Merging 2 csv files inorder
body: <p>I'm trying to prepare a data set(labels) for my deep Neural network.<a href="https://i.stack.imgur.com/eVjFL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eVjFL.png" alt="enter image description here"></a></p>
  
  <p>The above Image shows the data which struggling to prepare.
  I want to merge image column with their respective level in a perfect manner.
  As we can the Data is splitted
  I would like to both in one single manner for eg</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Image Column     level column
  1_left            0
  1_right           0
  ...
  ...
  10_left           0
  10_right          0
  ...
  15_left           2  
  15_right          2  
  ... </code></pre>
  </div>
  </div>
  
  The excel sheet can be downloaded from <a href="https://drive.google.com/open?id=151IyX9O2gyAtvgFE4ivxDDg7nRZUxcMA" rel="nofollow noreferrer">here</a>
  pandas merge and join is not able to result it the way I would like to have it.
  Please guide me
  Yours Sincerely,
  Vidit Shah</p>