Borrar filtros
Borrar filtros

How to reshape based on like values?

3 visualizaciones (últimos 30 días)
Dc215905
Dc215905 el 10 de Jul. de 2021
Comentada: Walter Roberson el 10 de Jul. de 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 comentario
Walter Roberson
Walter Roberson el 10 de Jul. de 2021
Suppose there had been two more 1 after the 3s and before the 5. What result would you want then?

Iniciar sesión para comentar.

Respuestas (1)

Simon Chan
Simon Chan el 10 de Jul. de 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 comentario
Walter Roberson
Walter Roberson el 10 de Jul. de 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.

Iniciar sesión para comentar.

Categorías

Más información sobre Creating and Concatenating Matrices en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by