Pandas: convert date in month to the 1st day of next month

by

You can use pd.offsets.MonthBegin()

In [261]: d = pd.to_datetime(['2011-09-30', '2012-02-28'])

In [262]: d
Out[262]: DatetimeIndex(['2011-09-30', '2012-02-28'], dtype="datetime64[ns]", freq=None)

In [263]: d + pd.offsets.MonthBegin(1)
Out[263]: DatetimeIndex(['2011-10-01', '2012-03-01'], dtype="datetime64[ns]", freq=None)

You’ll find a lot of examples in the official Pandas docs

More Related Contents:

  1. How do I melt a pandas dataframe?
  2. How to split data into 3 sets (train, validation and test)?
  3. Pandas bar plot changes date format
  4. Make Pandas DataFrame apply() use all cores?
  5. Requirements for converting Spark dataframe to Pandas/R dataframe
  6. pandas reading CSV data formatted with comma for thousands separator
  7. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  8. Pandas: add a column to a multiindex column dataframe
  9. After rename column get keyerror
  10. Jupyter notebook display two pandas tables side by side
  11. Adding a column thats result of difference in consecutive rows in pandas
  12. collect() or toPandas() on a large DataFrame in pyspark/EMR
  13. Python/Pandas: counting the number of missing/NaN in each row
  14. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  15. Pandas: fill in NaN values with dictionary references another column
  16. pandas dataframe group and sort by weekday
  17. Standard implementation of vectorize_sequences
  18. Suppress output of object when plotting in IPython
  19. Convert a spark DataFrame to pandas DF
  20. Getting Colorbar instance of scatter plot in pandas/matplotlib
  21. Pandas- Select rows from DataFrame based on condition
  22. Pandas & AWS Lambda
  23. Scrape tables into dataframe with BeautifulSoup
  24. How to remove illegal characters so a dataframe can write to Excel
  25. Plot pandas dataframe containing NaNs
  26. Turn pandas dataframe into a file-like object in memory?
  27. concise way of flattening multiindex columns
  28. use Featureunion in scikit-learn to combine two pandas columns for tfidf
  29. Convert dataframe with start and end date to daily data
  30. computing the mean for python datetime

Leave a Comment