title: how do i use vlookup using python having mutliple columns in both dataframe
body: <p>I need help on vlookup using python. I need only one matching column data of df2 in df1 instead of all
  df2 data.
  my input is below two dataframes.</p>
  <pre><code>df1 
  NodeName    NEID    Configured_Speed
  MUM         25234   511.054
  DEL         32251   154.155
  CHN         32584   224.949
  KOL         27076   372.932
  PUN         29743   203.556
  TN          29037   224.949
  </code></pre>
  <pre><code>df2 
  
  NodeName    Address         Region
  KOL         10.134.9.242    East
  DEL         10.51.195.236   North
  CHN         10.139.56.59    South
  TN          10.133.19.251   South
  KEL         10.51.60.6      South
  MUM         10.1.59.193     West
  PUN         10.51.60.66     West
  </code></pre>
  <p>and my Output is</p>
  <pre><code>NodeName    NEID    Configured_Speed    Address
  MUM         25234   511.054             10.1.59.193
  DEL         32251   154.155             10.51.195.236
  CHN         32584   224.949             10.139.56.59
  KOL         27076   372.932             10.134.9.242
  PUN         29743   203.556             10.51.60.66
  TN          29037   224.949             10.133.19.251
  </code></pre>
  <p>I tried below code but getting Address column blank.</p>
  <pre><code>df1['Address']=df1.NodeName.map(df2.Address)
  </code></pre>
  <p>and when i use below code, all columns from <code>df2</code> came in <code>df1</code></p>
  <pre><code>df3 = pd.merge(df1, df2, on ='NodeName',how ='left')
  </code></pre>