Selecting rows using Boolean selection
Rows can be selected by using Boolean selection. When applied to a data frame, a Boolean selection can utilize data from multiple columns. 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 equal to 100.00:
