title: How to check if any value of a column is in a range (in between two values) in Pandas?
body: <p>I have a DataFrame and I would like to check if any of the values (v) of a column satisfies <code>x&lt;=v&lt;=y</code>.</p>
  
  <pre><code>equal = any(df['columnX'] == value) # No problems here
  in_between = any(x &lt;= df['columnX'] &lt;= y) # ValueError :/
  </code></pre>
  
  <p>The error I get is <code>ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().</code>  But I am using <code>any()</code> already! </p>
  
  <p>So what's the problem here? Why does it work with <code>==</code> but not with <code>x&lt;=v&lt;=y</code>?</p>