Pandas: Create a time series combining hour and minute

Last update on May 02 2025 12:54:57 (UTC/GMT +8 hours)

16. Time Series Combining Hour and Minute

Write a Pandas program to create a time series combining hour and minute.

Sample Solution:

Python Code :

import pandas as pd
result = pd.timedelta_range(0, periods=30, freq="1H20T")
print("For a frequency of 1 hours 20 minutes, here we have combined the hour (H) and minute (T):\n")
print(result)

Sample Output:

For a frequency of 1 hours 20 minutes, here we have combined the hour (H) and minute (T):

TimedeltaIndex(['0 days 00:00:00', '0 days 01:20:00', '0 days 02:40:00',
                '0 days 04:00:00', '0 days 05:20:00', '0 days 06:40:00',
                '0 days 08:00:00', '0 days 09:20:00', '0 days 10:40:00',
                '0 days 12:00:00', '0 days 13:20:00', '0 days 14:40:00',
                '0 days 16:00:00', '0 days 17:20:00', '0 days 18:40:00',
                '0 days 20:00:00', '0 days 21:20:00', '0 days 22:40:00',
                '1 days 00:00:00', '1 days 01:20:00', '1 days 02:40:00',
                '1 days 04:00:00', '1 days 05:20:00', '1 days 06:40:00',
                '1 days 08:00:00', '1 days 09:20:00', '1 days 10:40:00',
                '1 days 12:00:00', '1 days 13:20:00', '1 days 14:40:00'],
               dtype='timedelta64[ns]', freq='80T')

For more Practice: Solve these Related Problems:

Write a Pandas program to combine separate hour and minute columns into a unified datetime index and then verify its frequency.
Write a Pandas program to create a time-series from discrete hour and minute values and then compute differences between consecutive timestamps.
Write a Pandas program to merge hour and minute offsets into a datetime series and then resample it to minute-level frequency.
Write a Pandas program to generate a time-series by combining given hour and minute inputs and then check the data type of the index.

Go to:

Previous: Write a Pandas program to get a time series with the last working days of each month of a specific year.
Next: Write a Pandas program to convert unix/epoch time to a regular time stamp in UTC. Also convert the said timestamp in to a given time zone.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.