title: Comparing from Multiple Data Sheets within pandas (python)
body: <p>I would like to make a new data frame from different excel files.</p>
  
  <p>I have a unique code in one data sheet that shows location and another data sheet containing a person's name with a unique code. What I would like to do is show the location of a person by comparing their unique code.</p>
  
  <p>Similar to the concept below:</p>
  
  <p><strong>Data Frame 1.xlsx</strong> </p>
  
  <pre><code> code = 1234, Location = serpong
   code = 9876, Location = cisauk
  </code></pre>
  
  <p><strong>Data Frame 2.xlsx</strong> : </p>
  
  <pre><code>code = 1234, Name = Dino
  code = 9876, Name = ventura
  </code></pre>
  
  <p><strong>expected data frame.xlsx</strong> (result by python) : </p>
  
  <pre><code>Name = dino, Location = serpong
  Name = ventura, Location = cisauk 
  </code></pre>
  
  <p>Is it possible to do this with <code>pandas</code>? Or do I need another library to do this?</p>