How to sort the column of matrix according to amount of NaN for each column?

2 次查看（过去 30 天）
Isti
Isti 2012-4-21
In simple case, I have the matrix like this:
NaN 1 4 6 NaN
9 NaN 6 1 2
NaN 3 2 8 3
7 NaN 1 9 3
7 1 8 2 4
and from the matrix we can see the amount of the NaNs: column 1= 2, column 2= 2, column 3= 0, column 4= 0, column 5= 1,
so i want to sort the columns in the matrix according to their NaNs and become like this:
4 6 NaN NaN 1
6 1 2 9 NaN
2 8 3 NaN 3
1 9 3 7 NaN
8 2 4 7 1
May somebody help me with the code? Thanks before :')

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

采纳的回答

Rick Rosson
Rick Rosson 2012-4-21
n = sum(isnan(A));
  1 个评论
Isti
Isti 2012-4-21
Thanks for this helping answer. it's produce the amount of the NaN from each column.
And i still have the problem with exchange the column according to that amount.
Is there any code to sort the columns?

请先登录，再进行评论。

更多回答（1 个）

Rick Rosson
Rick Rosson 2012-4-21
n = sum(isnan(A));
B = transpose([ n ; A ]);
C = sortrows(B);
R = transpose(C(:,2:end));

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by