If isnan then set to text

Question

Matthew 2014-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/125254-if-isnan-then-set-to-text

评论： Image Analyst 2014-4-14

for i=1:length(Table1.Columnname)
    if isnan(Table1.Columnname(i))
        Table1.Columnname(i) = 'NO';
    end
end

I have the above code but it does not work. I think it has to do with how I have defined Table1.Columnname(i) = 'NO';

Please can someone tell me how to code this properly for my isnan i.e. to set that cell in the table to "NO"?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2014-4-10

在 MATLAB Online 中打开

Format your code so it's legible, please...

But, the problem is more than likely that since you have a table, there's no NaN but a string 'NaN' is my guess. Have you tested w/ debugger or w/ debugging output what

isnan(Table1.Columnname(i))

returns for the cell in question?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2014-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/125254-if-isnan-then-set-to-text#answer_132932

What datatype is Table1.Columnname ? If it is a char array (string) then you cannot store two elements 'N' and 'O' in one location. If it is a cell array then you need to work with its contents rather than with the cell, such as Table1.Columnname{i} = 'NO' . And as Duane points out, you need to know whether the cell would hold NaN (a numeric value) or 'NaN' (a string)

6 个评论
显示 4更早的评论隐藏 4更早的评论

Matthew 2014-4-14

Thanks Walter!

Image Analyst 2014-4-14

在 MATLAB Online 中打开

I'm confused. Do you really have a table? How did you import? Did you do

T = readtable(yourFileName);

? Let's use the example in the help, and replace one of the items in the cell with nan and see what happens:

T = table(['M';'F';'M'],[45;32;34],...
    {'NY';nan;'MA'},logical([1;0;0]),...
    'VariableNames',{'Gender' 'Age' 'State' 'Vote'})
class('T.State') % Reports char.
whos T.State % Strangely silent - reports nothing.
YourCellArray = T.State % Extract column 3 into a cell array.
% The following line bombs.
YourCellArray(cellfun(@isnan, YourCellArray)) = {'NO'};