WHERE column BETWEEN in pandas

Posted by Kevin

Filtering rows of a SQL table, conditional on a row's given column value between two values, translated to Python's pandas.

SQL's WHERE...BETWEEN in pandas

In SQL:

SELECT 
  * 
FROM 
  table 
WHERE 
  column_1 BETWEEN 5 AND 10;

In pandas, applying a Boolean mask:

table[(table['column_1']>=5) & (table['column_1']<=10)]

References