Pandas: Create a time series using three months frequency
10. Quarterly Time-Series Creation
Write a Pandas program to create a time series using three months frequency.
Sample Solution:
Python Code :
import pandas as pd
time_series = pd.date_range('1/1/2021', periods = 36, freq='3M')
print("Time series using three months frequency:")
print(time_series)
Sample Output:
Time series using three months frequency:
DatetimeIndex(['2021-01-31', '2021-04-30', '2021-07-31', '2021-10-31',
'2022-01-31', '2022-04-30', '2022-07-31', '2022-10-31',
'2023-01-31', '2023-04-30', '2023-07-31', '2023-10-31',
'2024-01-31', '2024-04-30', '2024-07-31', '2024-10-31',
'2025-01-31', '2025-04-30', '2025-07-31', '2025-10-31',
'2026-01-31', '2026-04-30', '2026-07-31', '2026-10-31',
'2027-01-31', '2027-04-30', '2027-07-31', '2027-10-31',
'2028-01-31', '2028-04-30', '2028-07-31', '2028-10-31',
'2029-01-31', '2029-04-30', '2029-07-31', '2029-10-31'],
dtype='datetime64[ns]', freq='3M')
For more Practice: Solve these Related Problems:
- Write a Pandas program to generate a time-series with data points every three months and calculate the quarterly sums.
- Write a Pandas program to create a quarterly time-series and then interpolate any missing data points.
- Write a Pandas program to build a three-month frequency time-series and then plot it with custom markers.
- Write a Pandas program to generate a quarterly time-series and verify its periodicity using autocorrelation analysis.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to create a whole month of dates in daily frequencies. Also find the maximum, minimum timestamp and indexs.
Next: Write a Pandas program to create a sequence of durations increasing by an hour.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.