title: How can add a new column in df1 called value that looks up the value from df2 based on the year column?
body: <p>I have two DataFrames,</p>
  
  <p>df1</p>
  
  <pre><code>Name    Year
  A       2008
  A       2009
  B       2008
  B       2008
  </code></pre>
  
  <p>df2</p>
  
  <pre><code>year    value
  2008    10
  2009    15
  </code></pre>
  
  <p>How can add a new column in df1 called value that looks up the value from df2 based on the year column?</p>
  
  <p>Goal</p>
  
  <pre><code>Name  Year  Value
  A     2008  10
  A     2009  15
  B     2008  10
  B     2009  15
  </code></pre>
  
  <p>My issue ended up being datatypes..</p>
  
  <pre><code> df = df.convert_objects(convert_numeric=True)
  </code></pre>
  
  <p>The map solution was the fastest with 76,000 rows</p>