title: Compare two tables in Pandas Python
body: <p>For example I do have two DataFrames in Pandas:</p>
  
  <p>First like:</p>
  
  <pre><code>id brand model
  
  1 BMW E30
  7 Mercedes W222
  5 BMW E46
  3 Mercedes W201
  </code></pre>
  
  <p>Second one like:</p>
  
  <pre><code>id mpg weight
  
  1 15 5000
  3 12 4000
  7 10 3000
  5 20 4500
  </code></pre>
  
  <p>So I need to put second columns (with mpg and weight) into first dataframe with checking by ID:</p>
  
  <pre><code>id brand model mpg weight
  1 BMW E30 15 5000
  7 Mercedes W222 10 3000
  5 BMW E46 20 4500
  3 Mercedes W201 12 4000
  </code></pre>
  
  <p>How can I do that?
  Thank you!</p>