How to index DataFrame by Boolean values in python?

Question

I want to index a DataFrame using Boolean values, for example:

x = pd.DataFrame((100,2), columns = ("a", "b"))
s = x.b > 0

How to choose rows where s is true?

TaxpayersMoney · Accepted Answer · 2020-01-27 09:48:59Z

1

Try this:

mask = x.b > 0
subset = x[mask]

answered Jan 27, 2020 at 9:48

TaxpayersMoney

6892 gold badges8 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Welcome_back · Accepted Answer · 2020-01-27 12:20:41Z

0

 bool_value=x['b']>0
 required_rows=x[bool_value]

 # one line code
 required_rows=x[(x['b']>0)]

answered Jan 27, 2020 at 12:20

Welcome_back

1,47515 silver badges21 bronze badges

Please add some explanation with your answer so that others can learn as well.