Removing NaN from matrix
6 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I am trying to import an excel but the blank cells are coming through as NaN if I class them as a number which I need to do. I have attached a photo. I need the empty cells to be recognised as nothing, not 0 or NaN.![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/431588/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/431588/image.png)
0 Commenti
Risposte (1)
Sulaymon Eshkabilov
il 27 Nov 2020
Use isnan() and assign the value you want or remove the points containing NaNs. See help how to employ it: mathworks.com/help/matlab/ref/isnan.html?searchHighlight=isnan&s_tid=srchtitle
0 Commenti
Vedere anche
Categorie
Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!