How to use Pandas rolling_* functions on a forward-looking basis

by

Why not just do it on the reversed Series (and reverse the answer):

In [11]: pd.rolling_sum(ts[::-1], window=3, min_periods=0)[::-1]
Out[11]:
2011-01-10     3
2011-01-11     6
2011-01-12     9
2011-01-13    12
2011-01-14    15
2011-01-15    18
2011-01-16    21
2011-01-17    24
2011-01-18    17
2011-01-19     9
Freq: D, dtype: float64

More Related Contents:

  1. Pandas percentage of total with groupby
  2. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  3. How to add pandas data to an existing csv file?
  4. How to explode a list inside a Dataframe cell into separate rows
  5. How to print pandas DataFrame without index
  6. How to delete rows from a pandas DataFrame based on a conditional expression [duplicate]
  7. Reversing ‘one-hot’ encoding in Pandas
  8. Repeat rows in a pandas DataFrame based on column value
  9. Accessing every 1st element of Pandas DataFrame column containing lists
  10. Dropping infinite values from dataframes in pandas?
  11. How to flatten a nested JSON recursively, with flatten_json
  12. How to invoke pandas.rolling.apply with parameters from multiple column?
  13. Convert commas decimal separators to dots within a Dataframe
  14. Convert pandas DataFrame to a nested dict
  15. How to delete multiple pandas (python) dataframes from memory to save RAM?
  16. Create column of value_counts in Pandas dataframe
  17. How can I use cumsum within a group in Pandas?
  18. How to group DataFrame by a period of time?
  19. Why does df.apply(tuple) work but not df.apply(list)?
  20. Plot multiple columns of pandas DataFrame on the bar chart
  21. Python: Random selection per group
  22. Keep selected column as DataFrame instead of Series
  23. How to get unique values from multiple columns in a pandas groupby
  24. Merge a list of pandas dataframes
  25. How do I delete a column that contains only zeros in Pandas?
  26. Pandas reindex dates in Groupby
  27. How to repeat a Pandas DataFrame?
  28. Pandas ParserError EOF character when reading multiple csv files to HDF5
  29. Get column name where value is something in pandas dataframe
  30. Find index of all rows with null values in a particular column in pandas dataframe

Leave a Comment