Extracting data from an array
1 次查看(过去 30 天)
显示 更早的评论
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!
2 个评论
采纳的回答
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 个评论
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
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!