COnvert x,y, time array into 3D matrix
1 view (last 30 days)
Show older comments
Hello,
I have an array of events captured at different pixels at different times. Each row has x, y and time values.
Here a simple example (x, y, time) with a short list of events:
1, 3, 2
1, 3, 2.3
1, 3, 2
1, 3, 2.1
1, 3, 2.4
4, 5, 1
4, 5, 1.4
4, 5 , 1
4, 5, 1.2
3 , 4, 1
3, 4, 1.4
3, 4 ,2
As can be seen, some times are duplicates for the same x,y.
I would like to create a 3D matrix made of x,y slices arranged according to time.
Duplicate times for the same pixel should be summed.
I would appreciate any suggestion.
0 Comments
Accepted Answer
Star Strider
on 16 May 2022
Try this —
xyt = [1, 3, 2
1, 3, 2.3
1, 3, 2
1, 3, 2.1
1, 3, 2.4
4, 5, 1
4, 5, 1.4
4, 5 , 1
4, 5, 1.2
3 , 4, 1
3, 4, 1.4
3, 4 ,2];
[Uxytr,~,ix] = unique(xyt(:,3));
Out = accumarray(ix,(1:size(xyt,1))',[],@(x){[sum(xyt(x,[1 2]),1) unique(xyt(x,3))]})
There are 7 unique times, and the (x,y) values for those times are summed, with the times themselves remaining unchanged.
.
4 Comments
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!