title: Pandas Equivalent of Excel COUNTIFS
body: <p>I've read through some previous questions and am having trouble implementing. Here is my table.</p>
  
  <pre><code>Value Bool
  abc   TRUE
  abc   TRUE
  bca   TRUE
  bca   FALSE
  asd   FALSE
  asd   FALSE
  </code></pre>
  
  <p>I want this:</p>
  
  <pre><code>Value  Bool  Count
  abc    TRUE  2
  abc    TRUE  2
  bca    TRUE  1
  bca    FALSE 1
  asd    FALSE 0
  asd    FALSE 0
  </code></pre>
  
  <p>For each group of terms in Value, count the number of occurrences of TRUE, which is a boolean in my df.</p>
  
  <p>In Excel you can do COUNTIFS to do this. Can someone please show me the way in Pandas?</p>