title: Python - function similar to VLOOKUP (Excel)
body: <p>i am trying to join two data frames but cannot get my head around the possibilities Python has to offer.</p>
  
  <p>First dataframe:</p>
  
  <pre><code>ID MODEL   REQUESTS ORDERS
  1  Golf    123      4
  2  Passat  34       5
  3  Model 3 500      8
  4  M3      5        0
  </code></pre>
  
  <p>Second dataframe:</p>
  
  <pre><code>MODEL   TYPE  MAKE
  Golf    Sedan Volkswagen
  M3      Coupe BMW
  Model 3 Sedan Tesla
  </code></pre>
  
  <p>What I want is to add another column in the first dataframe called "make" so that it looks like this:</p>
  
  <pre><code>ID MODEL   MAKE       REQUESTS ORDERS
  1  Golf    Volkswagen 123      4
  2  Passat  Volkswagen 34       5
  3  Model 3 Tesla      500      8
  4  M3      BMW        5        0
  </code></pre>
  
  <p>I already looked at merge, join and map but all examples just appended the required information at the end of the dataframe.</p>