title: How to move data from one dataframe to another based on matching column values with pandas?
body: <p>I have two pandas DataFrames containing differently ordered data, and I am trying to move data from one to the other based on content.  I've tried a lambda function, but I don't think I'm understanding how this is supposed to work.  Here are simplified versions of my data:</p>
  
  <pre><code>df1 = 
     Name  Pos  Opponent  DPAvPos
  1  Dave  QB   DEN       NaN
  2  Bill  QB   GB        NaN
  3  Sean  QB   DET       NaN
  
  df2 =
     Name  DKP/Game
  1  DET   20.1
  2  DEN   10.4
  3  GB    15.2
  </code></pre>
  
  <p>I would like to move data from the DKP/Game column of df2 to the DPAvPos column df1 by matching data from the Opponent column of df1 with the Name column of df2.  So far everything I've tried hasn't worked.</p>