replacing Nan with 0
73 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Antworten (3)
Star Strider
am 25 Jul. 2020
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.
0 Kommentare
madhan ravi
am 25 Jul. 2020
Bearbeitet: madhan ravi
am 25 Jul. 2020
auPoints(isnan(auPoints(r, c))) = 0
2 Kommentare
madhan ravi
am 25 Jul. 2020
Bearbeitet: madhan ravi
am 26 Jul. 2020
Well it’s assumed that c was within the bounds.
Try this: (OBSCURE)
auPoints = subsasgn(auPoints, substruct('()', {isnan(auPoints)}), 0)
jonas
am 25 Jul. 2020
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.
4 Kommentare
Houss Leng
am 10 Aug. 2022
I have this error Undefined function 'isnan' for input arguments of type 'table'.
Walter Roberson
am 10 Aug. 2022
https://www.mathworks.com/help/matlab/ref/fillmissing.html like Star Strider suggests
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!