title: How can i do this select in () / Pandas
body: <p>I have two sources of data- One comes from the Database and one from a CSV File. The database comes just as a key.</p>
  
  <p>From the CSV file contains more than one field</p>
  
  <pre><code>Id  firstname  lastname
  1   first1     last1
  2   first2     last2
  3   first3     last3
  </code></pre>
  
  <p>I'm looking to do same with Pandas as what I can do with SQL:</p>
  
  <pre><code>select * from adr_tmp where id in(select id from xyz where key = ‘x’);
  </code></pre>
  
  <p>or</p>
  
  <pre><code>delete from adr_tmp where id in(select id from xyz where key = ‘x’);
  </code></pre>
  
  <p>After this I should have a new data frame with</p>
  
  <pre><code>Id  firstname  lastname
  1   first1     last1
  2   first2     last2
  </code></pre>