w3resource

Pandas: Sequences of fixed-frequency dates and time spans


23. Fixed-Frequency Date Sequences

Write a Pandas program to generate sequences of fixed-frequency dates and time spans intervals.

Sample Solution:

Python Code :

import pandas as pd
print("Sequences of fixed-frequency dates and time spans (1 H):\n")
r1 = pd.date_range('2030-01-01', periods=10, freq='H')
print(r1)
print("\nSequences of fixed-frequency dates and time spans (3 H):\n")
r2 = pd.date_range('2030-01-01', periods=10, freq='3H')
print(r2)

Sample Output:

Sequences of fixed-frequency dates and time spans (1 H):

DatetimeIndex(['2030-01-01 00:00:00', '2030-01-01 01:00:00',
               '2030-01-01 02:00:00', '2030-01-01 03:00:00',
               '2030-01-01 04:00:00', '2030-01-01 05:00:00',
               '2030-01-01 06:00:00', '2030-01-01 07:00:00',
               '2030-01-01 08:00:00', '2030-01-01 09:00:00'],
              dtype='datetime64[ns]', freq='H')

Sequences of fixed-frequency dates and time spans (3 H):

DatetimeIndex(['2030-01-01 00:00:00', '2030-01-01 03:00:00',
               '2030-01-01 06:00:00', '2030-01-01 09:00:00',
               '2030-01-01 12:00:00', '2030-01-01 15:00:00',
               '2030-01-01 18:00:00', '2030-01-01 21:00:00',
               '2030-01-02 00:00:00', '2030-01-02 03:00:00'],
              dtype='datetime64[ns]', freq='3H')

For more Practice: Solve these Related Problems:

  • Write a Pandas program to generate a sequence of fixed-frequency dates and then calculate the total time span of the sequence.
  • Write a Pandas program to create a time-series with a fixed interval and then identify any gaps in the sequence.
  • Write a Pandas program to generate a fixed-frequency date range and then merge overlapping intervals into single spans.
  • Write a Pandas program to create a fixed-frequency date series and then compute the interval differences between consecutive dates.

Python Code Editor:

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

Previous: Write a Pandas program to find the all the business quarterly begin and end dates of a specified year.
Next: Write a Pandas program to generate time series combining day and intraday offsets intervals.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.