Very helpful article!

For all you SQL lovers out there, pandas has a "query" function which allows you to filter a dataframe like you would a SQL table. For example,

df.query("column1 >= 5 and column2 == 10 or column3 in (1,2,3)")