How to do a vector of dates in python?

Asked Mar 03 '20 at 18:09

Active Mar 03 '20 at 18:27

Viewed 19 times

I need to create a vector of dates from 2018-01-01 to 2020-01-01, the vector can not be continuous (eg 2018-01-01, 2018-01-02, 2018-01-03 ...), dates need not be symmetrical and include the head and the tail.

The closest I got was:

import pandas as pd
date_list = pd.date_range(start='2018-01-01', end='2020-01-11', freq = '3M', closed= 'left')
date_list
Out[3]: 
DatetimeIndex(['2018-01-31', '2018-04-30', '2018-07-31', '2018-10-31',
           '2019-01-31', '2019-04-30', '2019-07-31', '2019-10-31'],
          dtype='datetime64[ns]', freq='3M')

However, it does not include the head (2018-01-01) or the tail (2020-01-01).

edited Mar 03 '20 at 18:27

asked Mar 03 '20 at 18:09

Márcio Mocellin

1

You are almost there, use MS (month start) instead of M and no closed parameter, date_list = pd.date_range(start='2018-01-01', end='2020-01-01', freq = '3MS') – Vaishali Mar 03 '20 at 18:14
1

`freq = '3MS'`. – BENY Mar 03 '20 at 18:15
Ok, but in the case ''end='2020-01-11' ? – Márcio Mocellin Mar 03 '20 at 18:26
Then the problem is with freq parameter. What would be the expected output if end = '2020-01-11' ? – Vaishali Mar 03 '20 at 18:47

How to do a vector of dates in python?

0 Answers0