Extracting a matrix element which is within a cell containing cells.

5 次查看（过去 30 天）
omid zandi
omid zandi 2021-3-16
评论： omid zandi 2021-3-16
Hi everybody.
I have a cell contaning cells, within each inner cell there is a matrix. By the way the aforementioned cell is attached. Now the question is that i want to extract the maximum value of a desired element of matrices. I have written a code, but does not seem to be an efficient one. does any can help me to make it more vectorized?
Thanks for your attention.
clc, clear, close all
% Loading mat file.
load('Sample.mat')
% Desired row and column.
Row = 5;
Col = 7;
% Preallocation.
Extracted = cell(length(Sample), 1);
Extracted(:) = {cell(12, 1)};
for yr = 1:length(Sample)
for m = 1:12
Extracted{yr,1}{m,1} = Sample{yr}{m}(Row,Col);
end
end
% Finally converting cell to multidimensional array.
Extracted = cell2mat(cat(3,Extracted{:}));
% Finding max of all pages.
FinalOutput = max(max(Extracted, [], 3));
  3 个评论
显示 1更早的评论
omid zandi
omid zandi 2021-3-16
First: I run the profiler and attached the result screen shot, but can't get much out of it. How can it help? The point is that sample.mat in future can become much larger than what i have loaded right now. so later this code will put me in trouble.
Second: Thanks for your comments about loading to structure and not using clc, clear at the start of the code.
Rik
Rik 2021-3-16
If you click on 'Problem' that will take you to a breakdown of the runtime of that function where you can see which lines take the most time.

请先登录，再进行评论。

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

采纳的回答

Stephen23
Stephen23 2021-3-16
编辑：Stephen23 2021-3-16
Ran in:
Putting scalar numeric data into nested cell arrays is pointlessly complex and inefficient. Get rid of the cell arrays:
S = load('Sample.mat');
% Desired row and column.
Row = 5;
Col = 7;
% Preallocation of one numeric matrix:
N = numel(S.Sample);
M = nan(N,12);
for yr = 1:N
for m = 1:12
M(yr,m) = S.Sample{yr}{m}(Row,Col);
end
end
max(M(:))
ans = 63
The storage of the original data would also be improved by not using nested cell arrays.
  1 个评论
omid zandi
omid zandi 2021-3-16
Thanks. It is faster than my code.
Although nested cell arrays are a beat confusing and inefficient, they make sense to me, and they are a very helpful in iterative operations.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by