Handling Missing values in cell array from Excel cell extraction

3 次查看（过去 30 天）
Ty
Ty 2024-12-5
评论： Walter Roberson 2024-12-6
I am directly referencing this previous question. I believe it is a good response. However, the issue for me is that the cell array I have in matlab is a character array and cellfun is returning a cell array of vectors for each character. MATLAB was throwing an error about setting 'UniformOutput' to false, which I did, and is when I realized this code runs but is not what I need. I should keep it to true so as to properly index which cells to remove.
example cell character array
extractedData.partCategories = {'xyz'} {'xyz'} {'xyz'} {1x1 <missing>} {1x1 <missing>}
Code
% Extract data with type conversion and error handling
% % <custom code to extract from Excel % %
% Clean up missing values in string cell arrays
mask = cellfun(@ismissing, extractedData.partCategories, 'UniformOutput', false);
extractedData.partCategories(mask) = {[]};
Then mask variable outputs:
[false, false, false]
[false, false, false]
[false, false, false]
true
true
Which I need it to output:
false
false
false
true
true

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

采纳的回答

Walter Roberson
Walter Roberson 2024-12-5
mask = cellfun(@(C)any(ismissing(C(:))), extractedData.partCategories, 'UniformOutput', false);
  2 个评论
Ty
Ty 2024-12-6
Hi, thank you! The following code precisely works.
before:
mask = cellfun(@ismissing, extractedData.partCategories, 'UniformOutput', false);
extractedData.partCategories(mask) = {[]};
after:
mask = cell2mat(cellfun(@(C)any(ismissing(C(:))), extractedData.partCategories, 'UniformOutput', false));
extractedData.partCategories(mask) = []; % using {[]} just makes empty matrix cells, using [] removes them
Walter Roberson
Walter Roberson 2024-12-6
mask = cellfun(@(C)any(ismissing(C(:))), extractedData.partCategories);
without the cell2mat should work

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2024b

Community Treasure Hunt

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

Start Hunting!

Translated by