python - Pandas date_range to generate monthly data at beginning of the month -


i'm trying generate date range of monthly data day @ beginning of month:

pd.date_range(start='1/1/1980', end='11/1/1991', freq='m') 

this generates 1/31/1980, 2/29/1980, , on. instead, want 1/1/1980, 2/1/1980,...

i've seen other question ask generating data on specific day of month, answers saying wasn't possible, beginning of month surely must possible!

you can changing freq argument 'm' 'ms':

d = pandas.date_range(start='1/1/1980', end='11/1/1990', freq='ms')     print(d) 

this should print:

datetimeindex(['1980-01-01', '1980-02-01', '1980-03-01', '1980-04-01',                '1980-05-01', '1980-06-01', '1980-07-01', '1980-08-01',                '1980-09-01', '1980-10-01',                 ...                '1990-02-01', '1990-03-01', '1990-04-01', '1990-05-01',                '1990-06-01', '1990-07-01', '1990-08-01', '1990-09-01',                '1990-10-01', '1990-11-01'],               dtype='datetime64[ns]', length=131, freq='ms', tz=none) 

look offset aliases part of documentation. there states 'm' end of month (month end frequency) while 'ms' beginning (month start frequency).


Comments

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

routes - Laravel 4 Wildcard Routing to Different Controllers -

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -