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

53 visualizzazioni (ultimi 30 giorni)
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

Risposta accettata

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

Accedi per commentare.

Più risposte (1)

Monik gupta
Monik gupta il 8 Giu 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 Commento
Les Beckham
Les Beckham il 8 Giu 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

Accedi per commentare.

Tag

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by