title: Pandas - Filter dataframe using list of tuples
body: <p>I need to create a function that filters a dataframe using a list of tuples - taking as arguments a dataframe and a tuple list, as follows:</p>
  
  <pre><code>tuplelist=[('A', 5, 10), ('B', 0, 4),('C', 10, 11)]
  </code></pre>
  
  <p>What is the proper way to do this?</p>
  
  <p>I have tried the following:</p>
  
  <pre><code>def multcolfilter(data_frame, tuplelist):
  
      def apply_single_cond(df_0,cond):
  
          df_1=df_0[(df_0[cond[0]]&gt;cond[1]) &amp; (df_0[cond[0]]&lt;cond[2])]
          return df_1
  
      for x in range(len(tuplelist)-1):    
  
    df=apply_single_cond(apply_single_cond(data_frame,tuplelist[x-1]),tuplelist[x])
      return df
  </code></pre>