Accessing contents inside Nested cell

4 views (last 30 days)
Ketan Shende
Ketan Shende on 23 Jun 2021
Commented: dpb on 24 Jun 2021
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

Answers (2)

dpb
dpb on 23 Jun 2021
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 Comments
Ketan Shende
Ketan Shende on 24 Jun 2021
Also, I see in the code that zeros are added. Is there a way to leave it blank if possible?
dpb
dpb on 24 Jun 2021
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)

Sign in to comment.


Ketan Shende
Ketan Shende on 24 Jun 2021
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 Comment
dpb
dpb on 24 Jun 2021
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.

Sign in to comment.

Categories

Find more on Structures in Help Center and File Exchange

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!