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

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,...).

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

제품

릴리스

R2020b

태그

질문:

2020년 11월 14일

댓글:

2020년 11월 19일

Community Treasure Hunt

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

Start Hunting!

Translated by