Extracting data from an array
显示 更早的评论
I have an array of 69 x 1 cells. All cells are either 12 x 2 or 13 x 2 matrices. I want to make a matrix, with all second columns from the matrices in the array.
So for example:
This is my array: (I havent given names to the cells yet, but just for the example)
[y1; y2; y3; y4; y5.......]
y1 = 12 x 2 matrix y2 = 12 x 2 matrix y3 = 13 x 2 matrix y4 = 12 x 2 matrix y5 = 13 x 2 matrix
I want all second columns from y1 till y69 in a n x 69 matrix.
Thanks for the help!
采纳的回答
Guillaume
2015-9-28
You're mixing up terms and notations, so it's not clear what you have and want. My understanding it that you have a cell array (size 69 x 1) consisting of matrices (size N x 2). The notation for cell arrays uses {}:
carr = {y1; y2; y3; ...} %yn can all be of different size and even type
Because the number of rows in each of these matrices is different (either 12 or 13), it's not possible to combine these seconds column into a matrix. It is however possible to combine them into a cell array. This is easily done with cellfun:
carr = {rand(12, 2); rand(13, 2); rand(12, 2); rand(13, 2)}; %demo data
column2 = cellfun(@(m) m(:, 2), carr, 'UniformOutput', false);
If cellfun is too complex for you, you can use a loop. The cellfun above is exactly equivalent to:
column2 = cell(size(carr));
for cidx = 1:numel(carr)
column2{cidx} = carr{cidx}(:, 2);
end
5 个评论
Walter Roberson
2015-9-28
With the trimming you can put it all together in one array:
column2 = cellfun(@(m) m(1:12, 2), carr, 'UniformOutput', false);
output = horzcat(column2{:});
Royvg94
2015-9-28
Royvg94
2015-9-28
Guillaume
2015-9-28
The principle is still the same, use cellfun or a loop to extract and do whatever you want with each column. In this case, simply add 13-number of rows 0 to the column:
column2 = cellfun(@(m) [m(:, 2); zeros(13-size(m,1), 1)], carr, 'UniformOutput', false);
column2 = [column2{:}]
更多回答（1 个）
Andrei Bobrov
2015-9-28
x = arrayfun(@(x)randi(56,randi([12 13]),2),(1:69)','un',0); % x - your array
n = cellfun(@(x)size(x,1),x);
nm = max(n);
m = numel(x);
out = nan(nm,numel(x));
for ii = 1:m
out(1:n(ii),ii) = x{ii}(:,2);
end
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Translated by 
