Pandas monthly rolling operation

by

Use the "D" offset rather than "M" and specifically use "30D" for 30 days or approximately one month. 

df = df.rolling("30D").sum()

Initially, I intuitively jumped to using "M" as I figured it stands for one month, but now it’s clear why that doesn’t work.

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. Filter dataframe rows if value in column is in a set list of values [duplicate]
  3. Converting a Pandas GroupBy output from Series to DataFrame
  4. Pandas long to wide reshape, by two variables
  5. How to avoid Python/Pandas creating an index in a saved csv?
  6. Convert floats to ints in Pandas?
  7. datetime dtypes in pandas read_csv
  8. Split a large pandas dataframe
  9. Calculate average of every x rows in a table and create new table
  10. get previous row’s value and calculate new column pandas python
  11. Plotting grouped data in same plot using Pandas
  12. How to move pandas data from index to column after multiple groupby
  13. Parsing a JSON string which was loaded from a CSV using Pandas
  14. sorting by a custom list in pandas
  15. Get last “column” after .str.split() operation on column in pandas DataFrame
  16. How do you update the levels of a pandas MultiIndex after slicing its DataFrame?
  17. pandas equivalent of np.where
  18. Unpack dictionary from Pandas Column
  19. Using Pandas Value_Counts and matplotlib
  20. How to plot two columns of a pandas data frame using points
  21. which is faster for load: pickle or hdf5 in python
  22. Resample Daily Data to Monthly with Pandas (date formatting)
  23. Python Pandas – Merge based on substring in string
  24. How to show a pandas dataframe into a existing flask html table?
  25. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  26. What is the fastest way to output large DataFrame into a CSV file?
  27. Using pandas crosstab to create a bar plot
  28. How to compute jaccard similarity from a pandas dataframe
  29. How to convert DataFrame.append() to pandas.concat()?
  30. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df

Leave a Comment