Pandas date_range to generate monthly data at beginning of the month

by

You can do this by changing the freq argument from 'M' to 'MS':

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

This should now 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 into the offset aliases part of the documentation. There it states that 'M' is for the end of the month (month end frequency) while 'MS' for the beginning (month start frequency).

More Related Contents:

  1. Merge pandas dataframes where one value is between two others [duplicate]
  2. Python generating a list of dates between two dates
  3. Difference between map, applymap and apply methods in Pandas
  4. Python Pandas : group by in group by and average?
  5. Python pandas insert list into a cell
  6. Stacked Bar Chart with Centered Labels
  7. How to replace text in a string column of a Pandas dataframe?
  8. Pandas dataframe get first row of each group
  9. pandas .at versus .loc
  10. What does the term “broadcasting” mean in Pandas documentation?
  11. Add column to dataframe with constant value
  12. Pandas: compare list objects in Series
  13. Python / Pandas – GUI for viewing a DataFrame or Matrix [closed]
  14. The difference between double brace `[[…]]` and single brace `[..]` indexing in Pandas
  15. merging 2 dataframes vertically [duplicate]
  16. How to do “(df1 & not df2)” dataframe merge in pandas?
  17. Pandas Dataframe Find Rows Where all Columns Equal
  18. How do I assign values based on multiple conditions for existing columns?
  19. Python Pandas replace NaN in one column with value from corresponding row of second column
  20. Xticks by pandas plot, rename with the string
  21. How to automatically annotate maximum value in pyplot
  22. Pandas: split list in column into multiple rows [duplicate]
  23. Pandas groupby with bin counts
  24. Pandas groupby and qcut
  25. how to convert monthly data to quarterly in pandas
  26. Average time for datetime list
  27. How to constuct a column of data frame recursively with pandas-python?
  28. Pandas explode multiple columns [duplicate]
  29. Horizontal stacked bar chart in Matplotlib
  30. pandas combine two strings ignore nan values

Leave a Comment