title: Using a Pandas DataFrame as Lookup
body: <p>I have 2 pandas DataFrames, this one:</p>
  
  <pre><code>item    inStock     description  
  Apples    10        a juicy treat
  Oranges   34        mediocre at best
  Bananas   21        can be used as phone prop
  &lt;...many other fruits...&gt;
  Kiwi       0        too fuzzy
  </code></pre>
  
  <p>and a lookup table with only a subset of the items above:</p>
  
  <pre><code>item     Price
  Apples   1.99
  Oranges  6.99
  </code></pre>
  
  <p>I would like to scan through the first table and fill in a price column for the DataFrame when the fruit in the first DataFrame matches the fruit in the second:</p>
  
  <pre><code>item    inStock     description                   Price
  Apples    10        a juicy treat                 1.99
  Oranges   34        mediocre at best              6.99
  Bananas   21        can be used as phone prop
  &lt;...many other fruits...&gt;
  Kiwi       0        too fuzzy
  </code></pre>
  
  <p>I've looked at examples with the built-in lookup function, as well as using a where-in type function but I cannot seem to get the syntax to work.  Can someone help me out?</p>