How to transform 'double' into 'cell array'?

4 次查看（过去 30 天）
John
John 2017-1-9
编辑： Guillaume 2017-1-9
My code:
B = zeros(height(A),1);
col_names = A.Properties.VariableNames; % Replicate header names
for k = 1:height(A)
% the following 'cellfun' compares each column to the values in A.L{k},
% and returns a cell array of the result for each of them, then
% 'cell2mat' converts it to logical array, and 'any' combines the
% results for all elements in A.L{k} to one logical vector:
C = any(cell2mat(...
cellfun(@(x) strcmp(col_names,x),A.L{k},...
'UniformOutput', false).'),1);
% then a logical indexing is used to define the columns for summation:
B(k) = sum(A{k,C});
end
generates the following error message. Thanks for helping out!
Error using cellfun
Input #2 expected to be a cell array, was double instead.
This is how table 'A' looks like:
  2 个评论
Beder
Beder 2017-1-9
Not sure about it - without trying - maybe you need so replace sum(A{k,C}) by sum(A(k,C))?
John
John 2017-1-9
thanks, @Peter Albrecht. I tried this one, but the following error occurs: Undefined function 'sum' for input arguments of type 'table'.

请先登录，再进行评论。

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

回答（1 个）

Guillaume
Guillaume 2017-1-9
编辑：Guillaume 2017-1-9
Clearly from the error message, one of the rows of A has a double matrix instead of a cell array in column L. The simplest way to find out:
dbstop if error
run your code and look at the value of k when it breaks into the debugger. This is the offending row.
edit: the following will give you all the offending rows:
find(cellfun(@(r) ~iscell(r), A.L))

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by