title: What is the equivalent of SQL "GROUP BY HAVING" on Pandas?
body: <p>what would be the most efficient way to use groupby and in parallel apply a filter in pandas?</p>
  
  <p>Basically I am asking for the equivalent in SQL of</p>
  
  <pre><code>select *
  ...
  group by col_name
  having condition
  </code></pre>
  
  <p>I think there are many uses cases ranging from conditional means, sums, conditional probabilities, etc. which would make such a command very powerful.</p>
  
  <p>I need a very good performance, so ideally such a command would not be the result of several layered operations done in python.</p>