staircase.StairsSlicer.agg#

StairsSlicer.agg(funcs) pandas.core.frame.DataFrame#

Facilitates multiple aggregations applied at once

Parameters
funcsstr, or list of str

The aggregation functions to apply. Currently supports “min”, “max”, “mean”, “median”, “mode”, “integral”.

Returns
pandas.Dataframe

Examples

>>> df = sc.make_test_data(seed=0)
>>> sf = sc.Stairs(df, "start", "end", "value")
>>> sf.plot()
../../_images/staircase-StairsSlicer-agg-1.png
>>> cuts = pd.date_range("2021", periods=12, freq="MS")
>>> sf.slice(cuts).agg(["min", "max"])
                            min    max
[2021-01-01, 2021-02-01)  354.0  492.0
[2021-02-01, 2021-03-01)  338.0  418.0
[2021-03-01, 2021-04-01)  401.0  587.0
[2021-04-01, 2021-05-01)  437.0  564.0
[2021-05-01, 2021-06-01)  356.0  463.0
[2021-06-01, 2021-07-01)  344.0  480.0
[2021-07-01, 2021-08-01)  436.0  543.0
[2021-08-01, 2021-09-01)  426.0  502.0
[2021-09-01, 2021-10-01)  399.0  486.0
[2021-10-01, 2021-11-01)  434.0  505.0
[2021-11-01, 2021-12-01)  434.0  509.0