Working with dates

[Scott]

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.

1 2	dates = pd.date_range(start='1990-03', freq='Q', periods=len(df_gdp.columns)) dates

Any help is appreciated.

Thanks

[Larz60+]

This is outside of pandas, but you can adjust:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

>>> 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) >>>