Pandas between_time() Method | DatetimeIndex Series

Introduction

The Pandas between_time() method is used to select values between specified times of the day in a Pandas Series object. It returns a new Series object consisting of the values within the specified time range. If the index is not a DatetimeIndex, it raises a TypeError.

VM Tips

After the VM startup is done, click the top left corner to switch to the Notebook tab to access Jupyter Notebook for practice.

Sometimes, you may need to wait a few seconds for Jupyter Notebook to finish loading. The validation of operations cannot be automated because of limitations in Jupyter Notebook.

If you face issues during learning, feel free to ask Labby. Provide feedback after the session, and we will promptly resolve the problem for you.

Skills Graph

%%%%{init: {'theme':'neutral'}}%%%% flowchart RL python(("`Python`")) -.-> python/BasicConceptsGroup(["`Basic Concepts`"]) python(("`Python`")) -.-> python/FileHandlingGroup(["`File Handling`"]) python(("`Python`")) -.-> python/DataStructuresGroup(["`Data Structures`"]) python(("`Python`")) -.-> python/ModulesandPackagesGroup(["`Modules and Packages`"]) python(("`Python`")) -.-> python/DataScienceandMachineLearningGroup(["`Data Science and Machine Learning`"]) python(("`Python`")) -.-> python/FunctionsGroup(["`Functions`"]) python/BasicConceptsGroup -.-> python/comments("`Comments`") python/FileHandlingGroup -.-> python/with_statement("`Using with Statement`") python/BasicConceptsGroup -.-> python/booleans("`Booleans`") python/DataStructuresGroup -.-> python/lists("`Lists`") python/DataStructuresGroup -.-> python/tuples("`Tuples`") python/ModulesandPackagesGroup -.-> python/importing_modules("`Importing Modules`") python/DataScienceandMachineLearningGroup -.-> python/numerical_computing("`Numerical Computing`") python/DataScienceandMachineLearningGroup -.-> python/data_analysis("`Data Analysis`") python/FunctionsGroup -.-> python/build_in_functions("`Build-in Functions`") subgraph Lab Skills python/comments -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/with_statement -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/booleans -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/lists -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/tuples -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/importing_modules -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/numerical_computing -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/data_analysis -.-> lab-68748{{"`Pandas Series Between_time Method`"}} python/build_in_functions -.-> lab-68748{{"`Pandas Series Between_time Method`"}} end

Create a Series with a DatetimeIndex

The first step is to create a Pandas Series with a DatetimeIndex. This can be done using the pd.date_range() function to generate a range of dates and times, and passing it as the index parameter when creating the Series object.

import pandas as pd

## Generate a range of dates and times
values = pd.date_range('2021-01-01', periods=5, freq='H')

## Create a Series with a DatetimeIndex
series = pd.Series([1, 2, 3, 4, 5], index=values)

## Print the Series
print(series)

Use the `between_time()` method to select values between a specific start and end time

The between_time() method can be used to select values between a specific start and end time. Simply pass the start time and end time as arguments to the method. The method returns a new Series object that contains only the values within the specified time range.

## Select values between 8:00 and 12:00
selected_values = series.between_time('8:00', '12:00')

## Print the selected values
print(selected_values)

Customize the `include_start` and `include_end` parameters

By default, the between_time() method includes the start and end times in the result. However, you can customize this behavior by setting the include_start and include_end parameters to False. This can be useful if you want to exclude the start and end times from the result.

## Select values between 8:00 and 12:00 without including the start and end times
selected_values = series.between_time('8:00', '12:00', include_start=False, include_end=False)

## Print the selected values
print(selected_values)

Summary

The between_time() method in Pandas allows you to select values between specified times of the day in a Series object. By customizing the include_start and include_end parameters, you can control whether the start and end times are included in the result. This method is useful for filtering data based on specific time ranges or intervals.

Pandas Series Between_time Method