title: How to filter pivot tables on python
body: <p>How do I filter pivot tables to return specific columns. Currently my dataframe is this:</p>
  
  <pre><code>print table
                      sum            
  Sex              Female  Male   All
  Date (Intervals)                   
  April               166   191   357
  August              212   263   475
  December            173   263   436
  February            192   298   490
  January             148   195   343
  July                189   260   449
  June                165   238   403
  March               165   278   443
  May                 236   253   489
  November            167   247   414
  October             185   287   472
  September           175   306   481
  All                2173  3079  5252
  </code></pre>
  
  <p>I want to display results of only the male column. I tried the following code:</p>
  
  <pre><code>table.query('Sex == "Male"')
  </code></pre>
  
  <p>However I got this error</p>
  
  <pre><code>TypeError: Expected tuple, got str
  </code></pre>
  
  <p>How would I be able to filter my table with specified rows or columns. </p>