replacing Nan with 0

24 次查看（过去 30 天）
Caroline Prekker
Caroline Prekker 2020-7-25
评论： Walter Roberson 2022-8-10
I have an excel file that I need to replace nan with zeros
I am using this piece of code and am getting error : Array indices must be positive integers or logical values
Error in "isnan(auPoints(r,c)) = 0;
I am not sure how to fix it or what I am doing wrong
for r = 4:1:22
for c = 2:1:29
if isnan(auPoints(r,c))
isnan(auPoints(r,c))
end
end
end

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

回答（3 个）

Star Strider
Star Strider 2020-7-25
Try this:
auPoints - fillmissing(auPoints, 'constant',0);
It might be advisable to save the output to a different variable, in order to preserve the original ‘auPoints’ matrix.
See the documentation for fillmissing (R2016b and later versions) for details.
madhan ravi
madhan ravi 2020-7-25
编辑：madhan ravi 2020-7-25
auPoints(isnan(auPoints(r, c))) = 0
  2 个评论
Caroline Prekker
Caroline Prekker 2020-7-25
I'm not sure where I would put that. It is telling me that c exceeds array bounds
madhan ravi
madhan ravi 2020-7-25
编辑：madhan ravi 2020-7-26
Well it’s assumed that c was within the bounds.
Try this: (OBSCURE)
auPoints = subsasgn(auPoints, substruct('()', {isnan(auPoints)}), 0)

请先登录，再进行评论。

jonas
jonas 2020-7-25
The line does not work because the left part just returns a logical.
isnan(auPoints(r,c)) = 0
It is similar to writing
isnan(NaN) = 0
...which makes no sense but returns the same error message
For this type of basic operation it is better to make use of logical indexing. For example, if you want to replace all your NaNs with zeros, you can write the following
mask = isnan(auPoints);
auPoints(mask) = 0;
The first line returns a logical array (1's and 0's) with the same size as the original array. This array is then used to index the original array. Faster and easier than loops.
More about logical indexing and indexing in general here.
  4 个评论
显示 2更早的评论
Houss Leng
Houss Leng 2022-8-10
I have this error Undefined function 'isnan' for input arguments of type 'table'.
Walter Roberson
Walter Roberson 2022-8-10
https://www.mathworks.com/help/matlab/ref/fillmissing.html like Star Strider suggests

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by