Create a Matrix from different ccella array.

2020 7 24
2 个回答
回答已采纳
更新时间：2020 7 24
7 次查看（30 天）

0 个投票

I have a cell array "data" 1x3 cell, each cell having different number of elements with 4 columns. for example data= [13252*4 double];[1516*4] double;[1244*4]double.
Now, I need a matrix which has maximum number of columns equal to 12 (sum of single columns) and rows equal to the maximum number of columns of all the cells. and I want to insert Nan when there is not value.
Thank you so much!!!

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Fredic
Fredic 2020-7-24
I try this code
nCol = cellfun('size', data,1);
nRow = numel(data) ;
Output = NaN(max(nCol), nRow);
for iA = 1:numel(data)
idx = (iA - 1) + 1;
Output(1:nCol(iA), idx:idx+1) = data{iA};
end
But then appers this error
Unable to perform
assignment because the
size of the left side is
1352-by-2 and the size of
the right side is
1352-by-4.
Error in Fitting_function
(line 44)
Output(1:nCol(iA),
idx:idx+1) = data{iA};

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

KSSV
KSSV 2020-7-24

0 个投票

A{1} = rand(10,4) ;
A{2} = rand(5,4) ;
A{3} = rand(6,4) ;
% Get length of each cell
L = cellfun(@length,A) ;
for i = 1:length(L)
if size(A{i},1) < max(L)
T = NaN(max(L),4) ;
T(1:L(i),:) = A{i} ;
A{i} = T ;
end
end
iwant = [A{:}] ;

更多回答（1 个）

madhan ravi
madhan ravi 2020-7-24
编辑：madhan ravi 2020-7-24

0 个投票

m = cellfun(@size, data, 'un', 0);
M = max(cat(1, m{:}));
Data = cellfun(@(x) [x; nan(M(1) - size(x, 1), M(2))], data, 'un', 0)

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Fredic
Fredic 2020-7-24
Thank you so much, but in this way I have another cell array(Data). I want a matrix with lenght 1516 (that is the max value) and 12 columns....
madhan ravi
madhan ravi 2020-7-24
13252 Is the maximum value
Fredic
Fredic 2020-7-24
I have the same columns (number 4) and different lengths (1352,1516,1244)
madhan ravi
madhan ravi 2020-7-24
编辑：madhan ravi 2020-7-24
My answer gives you the desired result. You have some problems in copying.
madhan ravi
madhan ravi 2020-7-24
You just wanted to use loop, ain’t it?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by