Pandas isin() function for continuous intervals

Question

Let's say I want to construct a dummy variable that is true if a number is between 1 and 10, I can do:

df['numdum'] = df['number'].isin(range(1,11))

Is there a way to do that for a continuous interval? So, create a dummy variable that is true if a number is in a range, allowing for non-integers.

Answer 1

Series objects (including dataframe columns) have a between method:

>>> s = pd.Series(np.linspace(0, 20, 8))
>>> s
0     0.000000
1     2.857143
2     5.714286
3     8.571429
4    11.428571
5    14.285714
6    17.142857
7    20.000000
dtype: float64
>>> s.between(1, 14.5)
0    False
1     True
2     True
3     True
4     True
5     True
6    False
7    False
dtype: bool

Answer 2

This works:

df['numdum'] = (df.number >= 1) & (df.number <= 10)