Accessing contents inside Nested cell

Question

Ketan Shende 2021-6-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/863670-accessing-contents-inside-nested-cell

评论： dpb 2021-6-24

Capture.PNG

I have a nested cell of the size 1x48 and there are multiple cells inside them as shown below in the screen shot. They are of variable length so some matlab functions like cell2mat is not working.

I want to store those values in a matrix one-by-one as per the order of the cells so that it can be easily written to excel files.

Here is my code that I have tried.

clc

e = edges;

e_size = size(e);

for i=1:1:e_size(1)

for j=1:1:e_size(2)

e_new=e{i,j};

end

edges is my nested cell

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2021-6-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/863670-accessing-contents-inside-nested-cell#answer_731950

在 MATLAB Online 中打开

nMax=cellfun(@numel,edges) 
array=cell2mat(cellfun(@(c)cat(2,c,zeros(1,nMax-numel(c))),edges.','UniformOutput',false));

Will augment with zeros, use nan() instead of zeros() for NaN placeholder.

Otherwise, will have to either

write as string data converting to formatted values instead of numeric or
write each row individually if really leaving blanks is the mandatory requirement of varying-length records.

8 个评论
显示 6更早的评论隐藏 6更早的评论

Ketan Shende 2021-6-24

Also, I see in the code that zeros are added. Is there a way to leave it blank if possible?

dpb 2021-6-24

在 MATLAB Online 中打开

My code above works for the values array above as is

You can't have a regular array that doesn't fill to the minimum of the largest row with something, no; see the note I wrote in the original answer about that issue.

But, writecell can handle that case of singly-stored cells--

writecell(values.','Values.xls','UseExcel',1)

请先登录，再进行评论。

Answer 2

Ketan Shende 2021-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/863670-accessing-contents-inside-nested-cell#answer_732770

P.mat

Now I am trying to convert another nested cell that I am attaching here into the matrix by following the same code. I am getting the following error.

Here is the code:

p_nMax=max(cellfun(@numel,P));

P_array=cell2mat(cellfun(@(c)cat(2,c,zeros(1,p_nMax-numel(c))),P.','UniformOutput',false));

Error:

Error using cat

Dimensions of arrays being concatenated are not consistent.

Error in W23rdJune>@(c)cat(2,c,zeros(1,p_nMax-numel(c))) (line 113)

P_array=cell2mat(cellfun(@(c)cat(2,c,zeros(1,p_nMax-numel(c))),P.','UniformOutput',false));

Error in W23rdJune (line 113)

P_array=cell2mat(cellfun(@(c)cat(2,c,zeros(1,p_nMax-numel(c))),P.','UniformOutput',false));

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

dpb 2021-6-24

在 MATLAB Online 中打开

Well, P doesn't follow the form --

> P
P =
  1×4 cell array
    {1×48 cell}    {1×48 cell}    {1×48 cell}    {48×40 double}

of a cell array of doubles -- the last cell is a 2D double array instead of a vector of a cell.

You can make the catenation work to the form of the cell by changing the definitions above to use the appropriate size() arguments in place of the assumed 1 for size(_,1) and numel() for size(_,2) but the double array instead of the cell array will break the cell2mat operation.

You need the consistent way to generate all the cells in the array; whatever process you used for the last is inconsistent with the rest.

请先登录，再进行评论。