title: Match values to table with limiting values in Python
body: <p>I have a dataframe where I would like to append values to if the id value is the same. I do not wish to have duplicate rows in my df1 dataframe</p>
  <p><strong>Data</strong></p>
  <p>df1</p>
  <pre><code>    id      stat        
      aa11rr  y       
      aa11rr  y       
      aa11rr  y       
      bb123   n       
      bb123   n   
  </code></pre>
  <p>df2</p>
  <pre><code>loco    country temp    
  aa11rr  ny      55  
  aa11rr  ny      60  
  aa11rr  ny      65  
  bb123   ca      75  
  bb123   ca      70  
  aa11rr  ny      70  
  bb123   ca      90  
  bb123   ca      95  
  </code></pre>
  <p><strong>Desired</strong></p>
  <pre><code>id      stat    loco    country temp    
  aa11rr  y       aa11rr  ny      55  
  aa11rr  y       aa11rr  ny      55  
  aa11rr  y       aa11rr  ny      60  
  bb123   n       bb123   ca      75  
  bb123   n       bb123   ca      70  
  </code></pre>
  <p><strong>Doing</strong></p>
  <pre><code>pd.concat([df1, df2.reindex(df1.index)], axis=1)
  </code></pre>
  <p>However, I would like my smaller dataset to not have more rows than it started with</p>