extract the same coloumn from multiple mtrix

Hi! I'm new here i want to ask if there is a solution in Matlab to extract the same column number from multiple matrix. I have 640 matrix and I want to extract from each mtrix the column indexed 70 and save this column in one new matrix .I thank you in advance for your help

 Accepted Answer

Matt J
Matt J on 19 Oct 2012
Edited: Matt J on 19 Oct 2012
If your data exists as an MxNx640 array, then it's easy
newmatrix= data(:,70,:);
newmatrix=reshape(newmatrix,M,640);

5 Comments

thank you how can create a MxNx640 array from 640 matrices ?
We need to know more about the form of your data and how they got that way.
Do you have 640 separate matrix variables in your workspace? If so, how did you create them?
Are the matrices in a cell array A{1}, A{2},...A{640}? If the latter, you can just do
M=cat(3,A{:})
the 640 matrices are 150*19 Double matrices and are named device1_1 to device1_80 device2_2 to device2_80 and so on 8 times
Sigh... Well, first we'll have to undo the damage. Nothing will be fast until we do:
M=cell(8, 80);
for i=1:8
for j=1:80
M{i,j}=eval(['device' num2str(i) '_' num2str(j)]);
end
end
Now you can do as before
data=cat3(M{:});
newmatrix= data(:,70,:);
newmatrix=reshape(newmatrix,M,640);

Sign in to comment.

More Answers (2)

To extract column 70 from matrix M you do
C = M(:,70);
To add this column to another matrix (M2) you do
M2 = [M2, C];

3 Comments

thank you for your response. I now that but I won't do it manually 640 times. there is no faster solution ?
how are named your 640 matrix? , or do you import them each iteration
the 640 matrices are 150*19 Double matrices and are named device1_1 to device1_80 device2_2 to device2_80 and so on 8 times

Sign in to comment.

M=[]
for k=1:8
s=['M=[M' sprintf([',device%d_%d(:,70)'],[k*ones(1,80);(1:80)]) ']']
eval(s)
end

Asked:

on 19 Oct 2012

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!