dlpy.timeseries.TimeseriesTable.timeseries_accumlation

TimeseriesTable.timeseries_accumlation(acc_interval='day', timeid=None, timeseries=None, groupby=None, extra_num_columns=None, default_ts_acc='sum', default_col_acc='avg', acc_method_byvar=None, user_defined_interval=None)

Accumulate the TimeseriesTable into regular consecutive intervals

Parameters
acc_intervalstring, optional

The accumulation interval, such as ‘year’, ‘qtr’, ‘month’, ‘week’, ‘day’, ‘hour’, ‘minute’, ‘second’.

timeidstring, optional

Specifies the column name for the timeid. If None, it will take the timeid specified in timeseries_formatting. Default: None

timeseriesstring or list-of-strings, optional

Specifies the column name for the timeseries, that will be part of the input or output of the RNN. If str, then it is univariate time series. If list of strings, then it is multivariate timeseries. If None, it will take the timeseries specified in timeseries_formatting. Default: None

groupbystring or list-of-strings, optional

The groupby variables. Default: None

extra_num_columnsstring or list-of-strings, optional

Specifies the addtional numeric columns to be included for accumulation. These columns can include static feature, and might be accumulated differently than the timeseries that will be used in RNN. if None, it means no additional numeric columns will be accumulated for later processing and modeling. Default: None

default_ts_accstring, optional

Default accumulation method for timeseries. Default: sum

default_col_accstring, optional

Default accumulation method for additional numeric columns Default: avg

acc_method_byvardict, optional

It specifies specific accumulation method for individual columns, if the method is different from the default. It has following structure: {‘column1 name’: ‘accumulation method1’, ‘column2 name’: ‘accumulation method2’, …} Default: None

user_defined_interval: string, optional

Use the user-defined interval to overwrite acc_interval See more details here: https://go.documentation.sas.com/?docsetId=casforecast&docsetTarget=casforecast_tsmodel_syntax04.htm&docsetVersion=8.4