Ignore NaN values when sorting

25 次查看（过去 30 天）
Marco Sartori
Marco Sartori 2020-7-22
评论： Walter Roberson 2020-7-22
Good afternoon everybody!
I have a matrix of the type:
A = [10 NaN 20 NaN]
and I want to put a rank in ascending order to these values but, if there is a NaN value, it is ignored or set equal to 0.
For instance, the result can be:
rank = [1 0 2 0]
It would be awesome if you can help me with this enigma.
Thank you!

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-7-22
validmask = ~isnan(A);
[~, nonnanrank] = sort(A(validmask));
rank = zeros(size(A));
rank(validmask) = nonnanrank;
However I recommand that you use a different variable name rather than rank to avoid interfering with using the MATLAB function rank() . rank() is used less frequently than sum() or length() are, so this is perhaps less of an issue than using those variables would be.
  3 个评论
显示 1更早的评论
Marco Sartori
Marco Sartori 2020-7-22
At the same time, what if i'm working with a matrix instead of the simple vector above?
the process would be something like this but i cannot procede by specifing A(validmask(i,:)) for A(i,:)
ranks = zeros(size(A));
for i = 1:t
validmask(i,:) = ~isnan(A(i,:));
?
?
end
Walter Roberson
Walter Roberson 2020-7-22
The easiest way would probably be to work column by column.
I can think of a vectorized algorithm, but it involves some sub2ind() tricks that are less than clear to read. Sometimes it just isn't worth doing unless your arrays are large enough that performance gets really important but at the same time not so large that the extra memory needed for vectorization is not a factor.

请先登录，再进行评论。

更多回答（1 个）

madhan ravi
madhan ravi 2020-7-22
[~, where] = sort(A);
Wanted = where .* ~isnan(A)

类别

在 Help Center 和 File 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