MATLAB Answers

Extract multiple data points from matrix

30 views (last 30 days)
Dylan George
Dylan George on 9 Jan 2019
Commented: Matt Tearle on 16 Jan 2019
Hi everyone, anyone know how to make a loop, or automate this somehow, got 30+ lines of this! Thanks
xdata1 = data([extendedX1coordinates(:,1):X2coordinates(:,1)],[Y1coordinates(:,1):Y2coordinates(:,1)],:) ;
xdata2 = data([extendedX1coordinates(:,2):X2coordinates(:,2)],[Y1coordinates(:,2):Y2coordinates(:,2)],:) ;
xdata3 = data([extendedX1coordinates(:,3):X2coordinates(:,3)],[Y1coordinates(:,3):Y2coordinates(:,3)],:) ;
xdata4 = data([extendedX1coordinates(:,4):X2coordinates(:,4)],[Y1coordinates(:,4):Y2coordinates(:,4)],:) ;
xdata5 = data([extendedX1coordinates(:,5):X2coordinates(:,5)],[Y1coordinates(:,5):Y2coordinates(:,5)],:) ;
xdata6 = data([extendedX1coordinates(:,6):X2coordinates(:,6)],[Y1coordinates(:,6):Y2coordinates(:,6)],:) ;

  0 Comments

Sign in to comment.

Answers (3)

madhan ravi
madhan ravi on 9 Jan 2019
xdata=cell(1,size(extendedXicoordinates,2)); % preallocate
for i = 1:size(extendedXicoordinates,2)
xdata{i} = data(extendedXicoordinates(:,i):X2coordinates(:,i),Yicoordinates(:,i):Y2coordinates(:,i),:) ;
end
celldisp(xdata)

  1 Comment

Dylan George
Dylan George on 9 Jan 2019
thanks for your help so far madhan.! It only gives me 3x4x100 though :/ I should have been clearer in my question. the x1,y1,x2,y2 are multiple coordinates, matricies of 1x34.

Sign in to comment.


Matt Tearle
Matt Tearle on 9 Jan 2019
It might help to know a bit more about what you're actually trying to do. Given that you're indexing with (:,k), it seems that the variables XXXcoordinates are matrices...? But then you're extracting columns, so column:column would be weird and may not be doing what you want. So maybe those variables are vectors?
Then what are you going to do with the result? As Madhan points out, you don't want 30 uniquely named variables in your workspace. What's the end goal here?

  2 Comments

Dylan George
Dylan George on 9 Jan 2019
Hi, Thanks for answering. Yeah the columns x1,y1,x2,y2 are all matricies (1x34) which means i need to find the difference between the two columns containing indicies and create a loop for it (1:34). The end goal is to crop the 3d matrix into 34 'areas' of interest so i want something like 120x120x100 to start with then I'd like to plot the intensity of these areas of interest individually against the z axis (100) to get 34 time frames. Thanks for your time
Matt Tearle
Matt Tearle on 16 Jan 2019
OK, if the coordinates are row vector (1-by-34), then data(x1(:,i):x2(:,i)) is valid, although I'd still prefer to write it as data(x1(i):x2(i)) for clarity. I find the use of row, column indexing with the colon confusing when the result is a single index value.
But now I don't see why Madhan's code isn't doing what you want.
xdata{i} = data(x1(i):x2(i),y1(i):y2(i),:)
The ith cell of xdata will be a portion of data, with the rows and columns extracted being defined by x1, x2, y1, and y2. If the size of xdata{i} isn't what you'd expect, you'll need to look at the values of x1(i), x2(i), y1(i), and y2(i).
One thing to be wary of: if you think of x and y in our normal mathematical arrangement (x horizontal, y vertical), then as indices x would correspond to columns and y to rows. (So data(y1(i):y(2),x1(i):x2(i),:).)

Sign in to comment.


Dylan George
Dylan George on 9 Jan 2019
thanks for your help so far madhan.! It only gives me 3x4x100 though :/

  0 Comments

Sign in to comment.

Sign in to answer this question.