Rows can also be selected by using Boolean selection, using an array calculated from the result of applying a logical condition on the values in any of the columns. This allows us to build more complicated selections than those based simply upon index labels or positions.
Consider the following that is an array of all companies that have a price below
In : # what rows have a price < 100? sp500.Price < 100 Out: Symbol MMM False ABT True ABBV True ... ZMH False ZION True ZTS True Name: Price, Length: 500, dtype: bool
This results in a
Series that can be used to select the rows where the value is
True, exactly the same way it was done with a
Series or a NumPy array:
In : ...