Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Working with dates
#1
Hi everyone,

I have been trawling through the pandas documentation trying to figure out how to set my index dates to the beginning of each month for each quarter (the quarters are not standard quarterly months), first date is 1990-03-01 next is 1990-06-01 etc. The closest I have got is this code below, but it sets the day to end of each month.

dates = pd.date_range(start='1990-03', freq='Q', periods=len(df_gdp.columns))
dates
Any help is appreciated.

Thanks
Reply
#2
This is outside of pandas, but you can adjust:
>>> from datetime import datetime
>>> from dateutil.relativedelta import relativedelta
>>> current_date = datetime.now()
>>> current_date
datetime.datetime(2019, 4, 21, 20, 17, 12, 288899)
>>> current_quarter = int((current_date.month - 1) / 3 + 1)
>>> current_quarter
2
>>> first_day_of_quarter = datetime(current_date.year, 3 * current_quarter -2, 1)
>>> first_day_of_quarter
datetime.datetime(2019, 4, 1, 0, 0)
>>> last_day_of_quarter = first_day_of_quarter + relativedelta(months=3, days=-1)
>>> last_day_of_quarter
datetime.datetime(2019, 6, 30, 0, 0)
>>>
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020