Numerical Computing with Python

How it works...

In step 1 and step 2, each set of criteria is built from simpler boolean expressions. It is not necessary to create a different variable for each boolean expression as done here, but it does make it far easier to read and debug any logic mistakes. As we desire both sets of movies, step 3 uses the pandas logical or operator to combine them.

Step 4 shows the exact syntax of how boolean indexing works. You simply pass the Series of booleans created from step 3 directly to the indexing operator. Only the movies with True values from final_crit_all are selected.

Boolean indexing also works with the .loc indexer as seen in step 5 by simultaneously doing boolean indexing and individual column selection. This slimmed DataFrame is ...