Rowfun and sum of array elements based on start and stop position from another array
3 次查看(过去 30 天)
显示 更早的评论
Hi everybody,
I'm trying to sum values of a timetable based on start and endposition from another array. The results will be inserted in the timetable in a new column.
It works with loops but the size of my table makes it quite slow and since I use vectorization for other purposes, and it is quite fast, I only assume that there is a way to achive it with rowfun for example. But I tried several scenarios but it does not work.
Here is what I try to achieve through an example .
start position array : Start=[1;3;6]
stop position array : Stop=[2;5;8]
Values from timetable: Values=[10;20;10;30;50;40;80;20;10]
I want an output vector with the sum based on start and stop position, so a 3X1.
For example:
First result: sum of Values from position 1 to 2: 10+20=30
Second result: sum of Values from position 3 to 5: 10+30+50=90
Third result: sum of Values from position 6 to 8: 40+80+20=140
So, how to achieve that simple operation with rowfun?
Thanks.
Michel Rathé
0 个评论
采纳的回答
Matt J
2020-10-30
编辑:Matt J
2020-10-30
It works with loops but the size of my table makes it quite slow
It shouldn't be. Even with several thousand table columns, a loop should still run in well less than 1 sec.
T=array2table(rand(1e4,3e3));
[M,N]=size(T);
Start=ones(1,N);
Stop=M*Start; %Worst case
matrix=table2array(T);
result=nan(1,N);
tic
for i=1:N
result(i)=sum(matrix(Start(i):Stop(i),i));
end
toc
更多回答(1 个)
Matt J
2020-10-30
编辑:Matt J
2020-10-30
So, how to achieve that simple operation with rowfun?
I don't see rowfun as being part of the solution. Just pull the values out into matrices as you have done and use matrix operations,
Start=[1;3;6];
Stop=[2;5;8];
Values=[10;20;10;30;50;40;80;20;10];
e=(1:size(Values,1)).';
result=sum( (e<=Stop(:).' & e>=Start(:).').*Values ,1)
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!