Sum up values in a certain range with logical indexing (better performance)

4 次查看（过去 30 天）

显示更早的评论

buhmatlab 2020-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543950-sum-up-values-in-a-certain-range-with-logical-indexing-better-performance

编辑： Stephen23 2020-6-7

在 MATLAB Online 中打开

Hi,

Since my script runs very slowly, I try to optimize the code and wonder if anybody is able help?

The (old and slow) code does the following:

In each row, the sum of all values from rows, that feature the name of the corresonding row and appear before the EventDate of the corresponding row, is calulated.

csum = zeros(size(values));
for i=1:length(values)
    csum(i) = sum(values(find(Name==Name(i) & EventDate < EventDate(i))));
end

Later on, my project also requires to calculate the sum of other ranges, so for example not all values of EventDate < EventDate(i) and Name==Name(i)but only the last two values of rows row where EventDate < EventDate(i) and Name==Name(i), another example would only focus on the last value which would not need to calculate the sum at all since it is only one value.

In this case I would adjust the code:

sum(values(find(Name==Name(i) & EventDate<EventDate(i) ,n,'last')));

However, I wonder if there is any way to improve the code by avoiding loops and using for example logical indexing. The performance of the current code is by far not good enough.

Thank you so much!