title: vlookup in Pandas using join
body: <p>I have the following 2 dataframes </p>
  
  <pre><code>Example1
  sku loc flag  
  122  61 True 
  123  61 True
  113  62 True 
  122  62 True 
  123  62 False
  122  63 False
  301  63 True 
  
  Example2 
  sku dept 
  113 a
  122 b
  123 b
  301 c 
  </code></pre>
  
  <p>I want to perform a merge, or join opertation using Pandas (or whichever Python operator is best) to produce the below data frame. </p>
  
  <pre><code>Example3
  sku loc flag   dept  
  122  61 True   b
  123  61 True   b
  113  62 True   a
  122  62 True   b
  123  62 False  b
  122  63 False  b
  301  63 True   c
  
  Both 
  df_Example1.join(df_Example2,lsuffix='_ProdHier')
  df_Example1.join(df_Example2,how='outer',lsuffix='_ProdHier')
  </code></pre>
  
  <p>Aren't working.
  What am I doing wrong? </p>