title: Pandas Add New Columns Based on Vaues from Different DataFrame
body: <p>I have the following dataframe, let's call it df1</p>
  <pre><code>id      level       a   b   c   d
  1       One         1   3   4   4
  1       two         1   3   4   
  2       One         1   3   4   4
  2       two         1   3   4   
  </code></pre>
  <p>Then, there is a second dataframe, df2.</p>
  <pre><code>id      Type    Value
  1       a      11
  1       b      22
  1       c      33
  1       d      44      
  2       a      91
  2       b      92
  2       c      93
  2       d      94 
  </code></pre>
  <p>What I would like is to compare the values from df1 and df2 to add new columns as follow.
  Add new column called <code>type</code>_ <code>s</code> with values from from df2.</p>
  <pre><code>id      level       a   b   c   d   a_s  b_s  c_s  d_s
  1       One         1   3   4   4   11   22   33   44
  1       two         1   3   4       11   22   33   44   
  2       One         1   3   4   4   91   92   93   94
  2       two         1   3   4       91   92   93   94
  </code></pre>