Moving sum in a timetable

I'm a little bit confused what you're asking for, but here is a first attempt. As I understand you are looking for each row to have a sum of the next several doubles. That would be done something like:

for i = 1:size(data,1) % I don't know what your data variable is called, replace as needed
    if i+5<=size(data,1)
        data(i,3) = sum(data(i+1:i+5,2));
    elseif i+1<=size(data,1)
        data(i,3) = sum(data(i+1:end,2));
    else
        data(i,3) = NaN;
    end
end

I do not, off the top of my head, know a way to calculate a moving some without a loop in Matlab.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Antonio Melieni 2019-4-10

Thanks Bob :)

Steven Lord 2019-4-10

The limitation of this ability, however, is that the range values must be positive integers, so it is not possible to examine values exclusively in front of the summation index, as including 0 as the kb term will begin the summation at the current index.

If you specify datetime or duration as the value for the SamplePoints name-value pair argument, the window length values may be nonnegative integer values or may be duration values. So for this scenario using the timetable RowTimes as the SamplePoints in movsum would allow you to specify minutes([5 0]) as the window length input.

You are correct that you can't take the moving sum (or use any of the moving functions) and exclude the element around which the window is located. But for purposes of movsum that just leaves one post-movsum step. Use fillmissing or isnan to replace any NaN values in A with 0 if necessary then subtract A from the results of movsum. That should be fairly safe for most data sets.

请先登录，再进行评论。