title: Combining csv files using pandas (merging and duplication)
body: <p>The task I want to do is a bit complicated so i'll try to explain it in the best way I can. </p>
  
  <p>I have two cv files in the following format:</p>
  
  <p>CSV1:</p>
  
  <pre><code>     Name     Var2 Var3
       John      6    7
       John      7    8
       Mike      5    6
  </code></pre>
  
  <p>CSV2:</p>
  
  <pre><code>    Name     Var4 Var5
      John      8    8
      John      9    9
      Mike      1    1
      Mike      2    2
  </code></pre>
  
  <p>What I essentially want to do is merge the files but in the following format:</p>
  
  <pre><code>    Name    Var2 Var3 Var4 Var5
      John      6    7   8    8
      John      6    7   9    9
      John      7    8   8    8
      John      7    8   9    9
      Mike      5    6   1    1
      Mike      5    6   2    2
  </code></pre>
  
  <p>It essentially duplicates every Name entry in the first csv depending on how many same name entries there are in the second csv and adds the respective columns from the second csv</p>
  
  <p>I can check if the name in csv1 matches the name in csv 2 but from there on i'm not sure how to go on about it</p>