pyspark.pandas.DatetimeIndex.indexer_between_time#

DatetimeIndex.indexer_between_time(start_time, end_time, include_start=True, include_end=True)[source]#

Return index locations of values between particular times of day (example: 9:00-9:30AM).

Parameters

start_time, end_timedatetime.time, str: Time passed either as object (datetime.time) or as string in appropriate format (“%H:%M”, “%H%M”, “%I:%M%p”, “%I%M%p”, “%H:%M:%S”, “%H%M%S”, “%I:%M:%S%p”,”%I%M%S%p”).
include_startbool, default True
include_endbool, default True

Returns

values_between_timeIndex of integers

Examples

>>> psidx = ps.date_range("2000-01-01", periods=3, freq="T")
>>> psidx
DatetimeIndex(['2000-01-01 00:00:00', '2000-01-01 00:01:00',
               '2000-01-01 00:02:00'],
              dtype='datetime64[ns]', freq=None)

>>> psidx.indexer_between_time("00:01", "00:02").sort_values()
Index([1, 2], dtype='int64')

>>> psidx.indexer_between_time("00:01", "00:02", include_end=False)
Index([1], dtype='int64')

>>> psidx.indexer_between_time("00:01", "00:02", include_start=False)
Index([2], dtype='int64')