Accessing contents inside Nested cell

3 次查看（过去 30 天）
Ketan Shende
Ketan Shende 2021-6-23
评论： dpb 2021-6-24
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
end
edges is my nested cell

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

回答（2 个）

dpb
dpb 2021-6-23
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
  1. write as string data converting to formatted values instead of numeric or
  2. write each row individually if really leaving blanks is the mandatory requirement of varying-length records.
  8 个评论
显示 6更早的评论
Ketan Shende
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
dpb 2021-6-24
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)

请先登录，再进行评论。

Ketan Shende
Ketan Shende 2021-6-24
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 个评论
dpb
dpb 2021-6-24
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.

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by