rowfun (or other function?) to access multiple rows in a table (as in current + previous 5 rows)

Following the excel typical example, where a new column can be a formula accessing current row + values in row(s) above / below - based on a row-delta (that specifies how many rows above/below to access), what is the best way to accomplish this in Matlab?
looking at towfun grouping function - the grouping should be dynamic, as in: for Row N, the row function / formula should only access the previous 5 lines ... type of thing - not sure how could this be achievable through the rowfun
thanks

1 commentaire

Rowfun doesn't work like that. It will do calculations on groups of rows, but not overlapping groups.
I'm guessing you can do what you want as something like t.NewVar = movsum(t.OldVar,...).

Connectez-vous pour commenter.

Réponses (0)

Produits

Version

R2020b

Question posée :

le 14 Nov 2020

Commenté :

le 19 Nov 2020

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by