search
Search
Login
Math ML Join our weekly DS/ML newsletter
menu
menu search toc more_vert
Robocat
Guest 0reps
Thanks for the thanks!
close
Comments
Log in or sign up
Cancel
Post
account_circle
Profile
exit_to_app
Sign out
help Ask a question
Share on Twitter
search
keyboard_voice
close
Searching Tips
Search for a recipe:
"Creating a table in MySQL"
Search for an API documentation: "@append"
Search for code: "!dataframe"
Apply a tag filter: "#python"
Useful Shortcuts
/ to open search panel
Esc to close search panel
to navigate between search results
d to clear all current filters
Enter to expand content preview
icon_star
Doc Search
icon_star
Code Search Beta
SORRY NOTHING FOUND!
mic
Start speaking...
Voice search is only supported in Safari and Chrome.
Navigate to
A
A
brightness_medium
share
arrow_backShare
Twitter
Facebook

Pandas Series | between method

Pandas
chevron_right
Documentation
chevron_right
Series
schedule Jul 1, 2022
Last updated
local_offer PythonPandas
Tags

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):

import pandas as pd
s = pd.Series([1,2,3,4,5,6])
s.between(3,5)
0 False
1 False
2 True
3 True
4 True
5 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 False
1 False
2 False
3 True
4 False
5 False
NOTE

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 False
1 False
2 True
3 False
4 True
5 False
NOTE

Note that np.NaN evaluates to False

mail
Join our newsletter for updates on new DS/ML comprehensive guides (spam-free)
robocat
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!