title: Python Pandas Multiindexing select rows that match all values in a list
body: <p>Consider the following data frame.</p>
  <pre><code>import Pandas as pd
  df = pd.Dataframe
  df = pd.DataFrame()
  df['Folder'] = [2,3,4,5  ,2,4,5, 2,3,4, 2,3,4,5,1]
  df['Country'] = ['USA','USA','USA','USA'  ,'Mexico','Mexico','Mexico', 'UK','UK','UK', 'Canada','Canada','Canada','Canada','Canada']
  df['Data'] = [20,30,43,15  ,25,44,15, 26,37,47, 24,34,47,55,18]
  df.set_index(['Country','Folder'], drop=True, inplace=True)
  df
  
  
                  Data
  Country Folder      
  USA     2         20
          3         30
          4         43
          5         15
  Mexico  2         25
          4         44
          5         15
  UK      2         26
          3         37
          4         47
  Canada  2         24
          3         34
          4         47
          5         55
          1         18
  </code></pre>
  <p>How do I collect the rows where Folder has all of lst=[1,3,4] in level Folder?</p>
  <pre><code>                Data
  Country Folder      
  
  Canada  2         24
          3         34
          4         47
          5         55
          1         18
  </code></pre>
  <p>OR</p>
  <pre><code>                Data
  Country Folder      
  Canada  3         34
          4         47
          1         18
  </code></pre>
  <p>Either would work for me. I want to know that Canada matches all of lst.  lst may be up to 8 items long.</p>
  <p>I have tried df.query(&quot;Folder in @lst&quot;) however that returns rows matching any of lst.  I need matching All of lst.</p>
  <p>Thanks in advance for any help.</p>