Removing all non NaN Values to a new matrix.

71 次查看(过去 30 天)
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 个评论
Adam
Adam 2020-2-5
What you want in place of the NaNs? You can't have nothingness is elements of a numeric array. If you extract only the non-nan values then you inevitably loose the shape of the matrix.
BN
BN 2020-2-5
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.

请先登录,再进行评论。

采纳的回答

JESUS DAVID ARIZA ROYETH
a solution:
a=sparse(temp)
a(isnan(a))=[]

更多回答(2 个)

BdS
BdS 2020-2-5
I would like to apply the function winsorising on the elements with values only. The function winsorising accounts unfortunatelly for NaN elements.
  1 个评论
Adam
Adam 2020-2-5
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.

请先登录,再进行评论。


BdS
BdS 2020-2-5

类别

Help CenterFile Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by