How to convert Nan to zero
950 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi guys; Please I need urgent help
I have matrix of experiment data in excel file, this excel matrix has some blank cells The problem is that the blank element shows as NaN when import the matrix to matlab for processing. Is there any function or .. to convert the Nan to zero
I appreciate your help.
0 commentaires
Réponse acceptée
Laurent
le 25 Août 2013
To set all NaN in Q to zero:
Q(isnan(Q))=0;
Is that what you need?
5 commentaires
Plus de réponses (2)
Santosh Shakya
le 24 Déc 2021
i want to replace nan with 0 in an array
can you help me?
1 commentaire
Walter Roberson
le 24 Déc 2021
a = rand(5,5)
a([2, 7, 23]) = nan
b = fillmissing(a, 'constant', 0)
%OR
c = a; c(isnan(c)) = 0
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!