title: sql select group by a having count(1) > 1 equivalent in python pandas?
body: <p>I'm having a hard time filtering the <code>groupby</code> items in pandas.  I want to do</p>
  
  <pre><code>select email, count(1) as cnt 
  from customers 
  group by email 
  having count(email) &gt; 1 
  order by cnt desc
  </code></pre>
  
  <p>I did </p>
  
  <pre><code>customers.groupby('Email')['CustomerID'].size()
  </code></pre>
  
  <p>and it gives me the list of emails and their respective counts correctly but I am not able to achieve the <code>having count(email) &gt; 1</code> part.</p>
  
  <pre><code>email_cnt[email_cnt.size &gt; 1]
  </code></pre>
  
  <p>returns <code>1</code></p>
  
  <pre><code>email_cnt = customers.groupby('Email')
  email_dup = email_cnt.filter(lambda x:len(x) &gt; 2)
  </code></pre>
  
  <p>gives the whole record of customers with <code>email &gt; 1</code> but I want the aggregate table.</p>