Effacer les filtres
Effacer les filtres

How to reshape based on like values?

3 vues (au cours des 30 derniers jours)
Dc215905
Dc215905 le 10 Juil 2021
Commenté : Walter Roberson le 10 Juil 2021
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 commentaire
Walter Roberson
Walter Roberson le 10 Juil 2021
Suppose there had been two more 1 after the 3s and before the 5. What result would you want then?

Connectez-vous pour commenter.

Réponses (1)

Simon Chan
Simon Chan le 10 Juil 2021
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 commentaire
Walter Roberson
Walter Roberson le 10 Juil 2021
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.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Creating and Concatenating Matrices dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by