Removing all non NaN Values to a new matrix.

84 views (last 30 days)
Hi,
I have got a 261x3733 double array temp with numbers and NaN.
I would like to get in matrix a only the nonnan values. Conditions: a should be of the same size as temp and all nonnan values shouldn't change place.
I tried this code:
a=temp(~isnan(temp))
However I get the vector with size 330227x1
Do you have any suggestions for solving this issue?
  2 Comments
BN
BN on 5 Feb 2020
I'm Agree with Adam.
So you want to remove NaN and save the result in a new matrix BUT you want a new matrix to have exactly the same size as an original matrix?
What do you want to instead of NaN?
This data seems to be the temperature. You can fill them using the nearest station linear regression or using fillmissing function.

Sign in to comment.

Accepted Answer

JESUS DAVID ARIZA ROYETH
JESUS DAVID ARIZA ROYETH on 5 Feb 2020
a solution:
a=sparse(temp)
a(isnan(a))=[]

More Answers (2)

BdS
BdS on 5 Feb 2020
I would like to apply the function winsorising on the elements with values only. The function winsorising accounts unfortunatelly for NaN elements.
  1 Comment
Adam
Adam on 5 Feb 2020
I don't know what the function is, but can you not just pass the non-nan values to it and then if you want the result in your matrix you can put the results back in to the non-nan locations of a new result matrix.

Sign in to comment.


BdS
BdS on 5 Feb 2020

Community Treasure Hunt

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

Start Hunting!

Translated by