rollingPanel

rollingPanel(X, window, [groupingCol])

X is a table.

window is a positive integer indicating the length of the moving windows.

groupingCol (optional) is a string scalar/vector indicating one or some columns in table X.

Extract a fixed number of rows from a table with a rolling window to generate a new table. The rolling window moves by 1 row each time until it reaches the bottom of the table.

If groupingCol is specified, perform the aforementioned operation in each group.

The panelNumber column in the result means the index of each extraction operation, which starts from 0.

t=table(1 1 1 1 1 2 2 2 2 2 as id, 1..10 as x);
rollingPanel(t, 3, `id);