Pandas: rolling mean by time interval

by

In the meantime, a time-window capability was added. See this link.

In [1]: df = DataFrame({'B': range(5)})

In [2]: df.index = [Timestamp('20130101 09:00:00'),
   ...:             Timestamp('20130101 09:00:02'),
   ...:             Timestamp('20130101 09:00:03'),
   ...:             Timestamp('20130101 09:00:05'),
   ...:             Timestamp('20130101 09:00:06')]

In [3]: df
Out[3]: 
                     B
2013-01-01 09:00:00  0
2013-01-01 09:00:02  1
2013-01-01 09:00:03  2
2013-01-01 09:00:05  3
2013-01-01 09:00:06  4

In [4]: df.rolling(2, min_periods=1).sum()
Out[4]: 
                       B
2013-01-01 09:00:00  0.0
2013-01-01 09:00:02  1.0
2013-01-01 09:00:03  3.0
2013-01-01 09:00:05  5.0
2013-01-01 09:00:06  7.0

In [5]: df.rolling('2s', min_periods=1).sum()
Out[5]: 
                       B
2013-01-01 09:00:00  0.0
2013-01-01 09:00:02  1.0
2013-01-01 09:00:03  3.0
2013-01-01 09:00:05  3.0
2013-01-01 09:00:06  7.0

More Related Contents:

  1. How to calculate rolling / moving average using python + NumPy / SciPy?
  2. Combine Date and Time columns using python pandas
  3. Python – rolling functions for GroupBy object
  4. Pandas finding local max and min
  5. Pandas: resample timeseries with groupby
  6. Resampling Within a Pandas MultiIndex
  7. Pandas compare next row
  8. How to plot stacked event duration (Gantt Charts)
  9. How do you plot a vertical line on a time series plot in Pandas?
  10. pandas .plot() x-axis tick frequency — how can I show more ticks?
  11. Find date range overlap in python
  12. Combine Date and Time columns using pandas
  13. Can Pandas plot a histogram of dates?
  14. Pandas rolling apply using multiple columns
  15. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  16. Selecting Data between Specific hours in a pandas dataframe
  17. How to resample a dataframe with different functions applied to each column?
  18. Split Python sequence (time series/array) into subsequences with overlap
  19. how to understand closed and label arguments in pandas resample method?
  20. Filter dataframe rows if value in column is in a set list of values [duplicate]
  21. Convert unix time to readable date in pandas dataframe
  22. Is it possible to insert a row at an arbitrary position in a dataframe using pandas?
  23. How to keep index when using pandas merge
  24. pandas dataframe columns scaling with sklearn
  25. Unpack dictionary from Pandas Column
  26. which is faster for load: pickle or hdf5 in python
  27. Python Pandas – Merge based on substring in string
  28. Add numpy array as column to Pandas data frame
  29. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  30. Why is NaN considered as a float?

Leave a Comment