How to reshape based on like values?

조회 수: 2 (최근 30일)
Dc215905
Dc215905 2021년 7월 10일
댓글: Walter Roberson 2021년 7월 10일
Hello,
I have the following example array:
A = [1 1 1 2 2 3 3 3 3 3 5]
I would like to rehsape it into a matrix based on like values. Since the values are not uniform, I would like toi fill in the rest with Nan. The ultimate goal is to have it look like:
A =
1 2 3 5
1 2 3 NaN
1 NaN 3 NaN
NaN NaN 3 NaN
NaN NaN 3 NaN
Any suggestions?
  댓글 수: 1
Walter Roberson
Walter Roberson 2021년 7월 10일
Suppose there had been two more 1 after the 3s and before the 5. What result would you want then?

댓글을 달려면 로그인하십시오.

답변 (1개)

Simon Chan
Simon Chan 2021년 7월 10일
If I guess the logic correctly:
A = [1 1 1 2 2 3 3 3 3 3 5];
N = histcounts(A);
rowA = max(N);
B= unique(A);
colA = length(B);
C = NaN(rowA,colA);
E = N(B);
for k=1:colA
C(1:E(k),k)=B(k);
end
C =
1 2 3 5
1 2 3 NaN
1 NaN 3 NaN
NaN NaN 3 NaN
NaN NaN 3 NaN
  댓글 수: 1
Walter Roberson
Walter Roberson 2021년 7월 10일
This is why I inquired about what should happen if there were more ones later: that information would tell us whether order needs to be preserved.

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 NaNs에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by