How to select rows in a DataFrame between two values, in Python Pandas?

Question

I am trying to modify a DataFrame df to only contain rows for which the values in the column closing_price are between 99 and 101 and trying to do this with the code below.

However, I get the error

ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

and I am wondering if there is a way to do this without using loops.

df = df[(99 <= df['closing_price'] <= 101)]

Answer 1

You should use () to group your boolean vector to remove ambiguity.

For grouping boolean vector to remove ambiguity you should use :

df = df[(df['closing_price'] >= 99) & (df['closing_price'] <= 101)]