title: Python equivalent of select * from a where account_id in (select account_id from b)
body: <p>As the title suggests. I come from an SQL background was looking for the best way of doing this.</p>
  <pre><code>c = a.account_id.isin(b.account_id).astype(bool) 
  a[c]
  </code></pre>
  <p>Is the above the most efficient way?</p>