Pandas Series | between method
Start your free 7-days trial now!
Pandas Series.between(~) method returns a vector of booleans indicating whether each element in the Series is within the provided range. NaN values are considered as False.
Parameters
1. left | scalar
The lower boundary.
2. right | scalar
The upper boundary.
3. inclusive | string | optional
Specifies whether left and right bounds should be inclusive. Defaults to "both". Other options include, "neither", "left", "right".
Return value
A new Series of boolean indicating whether each element lies between the left and right bounds.
Examples
Basic usage
To check if elements in the Series lie between 3 and 5 (both ends inclusive):
0 False1 False2 True3 True4 True5 False
inclusive
To check if elements in the Series lie between 3 and 5 (both ends exclusive):
s = pd.Series([1,2,3,4,5,6])s.between(3, 5, inclusive="neither")
0 False1 False2 False3 True4 False5 False
Note how 3 and 5 now return False as we are excluding the left and right bounds using inclusive="neither".
NaN
To check if elements in the Series lie between 3 and 5 (both ends inclusive):
s = pd.Series([1,2,3,np.NaN,5,6])s.between(3,5)
0 False1 False2 True3 False4 True5 False
Note that np.NaN evaluates to False
