Selecting rows using Boolean selection

Rows can be selected by using Boolean selection. When applied to a DataFrame, a Boolean selection can utilize data from multiple columns.

How to do it...

Consider the following query, which identifies all stocks with a price less than 100:

This result can then be applied to the DataFrame using the [] operator to return only the rows where the result was true:

Multiple conditions can be put together using parentheses. The following retrieves the symbols and price for all stocks with a price between 6 and 10:

It is common to perform selection using multiple variables. The following demonstrates this by finding all rows where the Sector is Health Care and the Price is greater than or...