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

Google sheets equipment borrowing system -

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

c# - Convert type 'System.Collections.Generic.List<string>' to 'System.Collections.Generic.IList<>' -