Open In App
Related Articles

Python | Pandas Series.between()

Like Article
Save Article
Report issue
Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas between() method is used on series to check which values lie between first and second argument.
Syntax: Series.between(left, right, inclusive=True) Parameters: left: A scalar value that defines the left boundary right: A scalar value that defines the right boundary inclusive: A Boolean value which is True by default. If False, it excludes the two passed arguments while checking.
Return Type: A Boolean series which is True for every element that lies between the argument values. To download the CSV file used, Click Here.
Example #1:Values of salary column are checked. If they lie between 80000 and 100000, True is returned.
# importing pandas package
import pandas as pd
# making data frame from csv file
data = pd.read_csv("employees.csv")
# making a bool series
bool_series = data["Salary"].between(80000, 100000, inclusive = True)
# returning dataframe with salary between above values

Output: As shown in the output image, the data frame is having rows only with salary between 80000 and 100000. Error and exceptions:
  • This method doesn’t work on strings.
  • This method is only for Series (1D data frame)

Last Updated : 17 Sep, 2018
Like Article
Save Article
Share your thoughts in the comments
Similar Reads