How do I remove NaN values from a matrix and retain matrix shape?

55 vues (au cours des 30 derniers jours)
Manny Kins
Manny Kins le 3 Avr 2019
Commenté : Les Beckham le 8 Juin 2023
Say for example I have the following array
X = [1 3 4; 5 6 8; NaN NaN NaN]
X =
1 3 4
5 6 8
NaN NaN NaN
I want to get rid of all the NaN values so I use
X(~isnan(X))
ans =
1
5
3
6
4
8
Now the array has changed from a 3x3 to a 1x6. I want to be able to retain the matrix layout and only remove the NaN values giving a 2x3
X =
1 3 4
5 6 8
Thanks

Réponse acceptée

madhan ravi
madhan ravi le 3 Avr 2019
X(all(isnan(X),2),:)=[]
  1 commentaire
Manny Kins
Manny Kins le 3 Avr 2019
Thank you for your quick response! This is a very elegant solution that can be applied to much larger matrices!

Connectez-vous pour commenter.

Plus de réponses (1)

Monik gupta
Monik gupta le 8 Juin 2023
Is there any way to remove NaN values without changing shape of the matrix? in case matrix is like following:
X = [1 3 4; 5 NaN 8; 3 4 NaN];
Thanks in Advance.
  1 commentaire
Les Beckham
Les Beckham le 8 Juin 2023
You really shouldn't ask questions using an answer to someone else's question.
Nevertheless...
You can't remove them, but you can replace them with something other than NaN. Only you can decide what value to use for the replacement in your particular application.
For example, this will replace them with zero:
X = [1 3 4; 5 NaN 8; 3 4 NaN]
X = 3×3
1 3 4 5 NaN 8 3 4 NaN
X(isnan(X)) = 0
X = 3×3
1 3 4 5 0 8 3 4 0

Connectez-vous pour commenter.

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by