How to delete a specified string value in a nested cell array
11 次查看(过去 30 天)
显示 更早的评论
I have a cell array which is 3000x1, called 'AOI'. Within this cell array are nested cell arrays, each with a single column but with variable length. For instance, the first cell is 300x1, the second cell is 200x1, etc. Within these nested cells are lists of names describing data. I want to delete all nested cells with the value 'NO AOI' in them, and create a new cell array out of this. Thus, the dimensions of each nested cell array will likely change (decrease in size), and all cells equal to 'NO AOI' are removed. Unfortunately, I'm struggling to execute this code. Can someone help please?
I have tried the following:
for i = 1:numel(AOI)
nested_cell = AOI{i};
idx = strcmp(nested_cell, 'NO AOI');
AOI{i}(idx, :) = [];
end
% Create new cell array
new_AOI = AOI(~cellfun('isempty', AOI));
However, this hasn't worked - new_AOI is simply the same as AOI. Please help!
Thank you so much!
0 个评论
采纳的回答
Voss
2023-3-17
If AOI is a cell array of cell arrays of character vectors, like this:
AOI = {{'AOI 1';'AOI 2';'NO AOI';'AOI 3'}; {'NO AOI';'NO AOI'}; {'AOI 1';'NO AOI';'NO AOI';'AOI 2'}};
AOI{:}
Then the code works:
for i = 1:numel(AOI)
nested_cell = AOI{i};
idx = strcmp(nested_cell, 'NO AOI');
AOI{i}(idx, :) = [];
end
AOI{:}
% Create new cell array
new_AOI = AOI(~cellfun('isempty', AOI));
new_AOI{:}
So I'm guessing you actually have a cell array of cell arrays of strings, like this:
AOI = {{"AOI 1";"AOI 2";"NO AOI";"AOI 3"}; {"NO AOI";"NO AOI"}; {"AOI 1";"NO AOI";"NO AOI";"AOI 2"}};
AOI{:}
If that's the case, you can make an adjustment as follows. [nested_cell{:}] concatenates the contents of nested_cell, in this case producing a string array from the cell array of strings nested_cell, which strcmp works properly on.
for i = 1:numel(AOI)
nested_cell = AOI{i};
idx = strcmp([nested_cell{:}], 'NO AOI');
AOI{i}(idx, :) = [];
end
AOI{:}
% Create new cell array
new_AOI = AOI(~cellfun('isempty', AOI));
new_AOI{:}
An alternative would be to use cellstr to convert nested_cell to a cell array of character vectors regardless of whether it already was one or whether it was a cell array of strings. This might be useful in case AOI contains mixed types. Something like this:
AOI = {{'AOI 1';"AOI 2";"NO AOI";'AOI 3'}; {"NO AOI";"NO AOI"}; {'AOI 1';'NO AOI';'NO AOI';'AOI 2'}};
AOI{:}
for i = 1:numel(AOI)
nested_cell = cellstr(AOI{i});
idx = strcmp(nested_cell, 'NO AOI');
AOI{i}(idx, :) = [];
end
AOI{:}
% Create new cell array
new_AOI = AOI(~cellfun('isempty', AOI));
new_AOI{:}
Of course, new_AOI still contains the original contents (some strings, some character vectors) of those elements that were not 'NO AOI' or "NO AOI". If you want to end up with a cell array of cell arrays of only character vectors instead, you can convert AOI first. Something like this:
AOI = {{'AOI 1';"AOI 2";"NO AOI";'AOI 3'}; {"NO AOI";"NO AOI"}; {'AOI 1';'NO AOI';'NO AOI';'AOI 2'}};
AOI{:}
AOI = cellfun(@cellstr,AOI,'UniformOutput',false);
AOI{:}
Then use your code as you already have it, since it has been shown to work on a cell array of cell arrays of character vectors at the beginning of this answer. Or rewrite the loop without the temporary variables nested_cell and idx:
for i = 1:numel(AOI)
AOI{i}(strcmp(AOI{i}, 'NO AOI'), :) = [];
end
AOI{:}
Also, note that you can avoid creating a separate variable new_AOI, and call the result AOI (which has already been modified in the loop - so preserving it is obviously not a concern):
% call the result AOI instead of new_AOI
AOI = AOI(~cellfun(@isempty, AOI)); % (function handle @isempty works the same as character vector 'isempty' in cellfun)
Or you can just operate on AOI directly:
% or, remove empty cell arrays from AOI
AOI(cellfun(@isempty, AOI)) = [];
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!