Replace NaN's in a cell array with blanks (not empty char/string)

Question

Dubstep Dublin 2017-10-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363866-replace-nan-s-in-a-cell-array-with-blanks-not-empty-char-string

评论： Walter Roberson 2017-10-29

Hello, I am using R2015. I am reading my data using xlsread. I have a cell array of numbers/strings and NaN's. I need to replace NaN's with blank cells (not empty char/string).

Thanks :)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-10-29

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363866-replace-nan-s-in-a-cell-array-with-blanks-not-empty-char-string#answer_288311

在 MATLAB Online 中打开

mask = cellfun(@(C) isnumeric(C) && isscalar(C) && isnan(C), YourCell);
YourCell(mask) = {[]};   %guessing that "blank cells" means "empty array"

2 个评论
显示无隐藏无

Dubstep Dublin 2017-10-29

Thanks Walter.

Walter Roberson 2017-10-29

在 MATLAB Online 中打开

YourCell = cell(10,10);
for K = randperm(100,80); YourCell{K} = randi(5,randi(5),randi(5)); end
for K = randperm(100,20); YourCell{K} = char('A' + randi(10,1,randi(8))); end
for K = randperm(100,10); YourCell{K} = nan; end
CopyOfCell = YourCell;
mask = cellfun(@(C) isnumeric(C) && isscalar(C) && isnan(C), YourCell);
YourCell(mask) = {[]};   %guessing that "blank cells" means "empty array"