Eliminate repeating values in column, but keep one set and append the following column's value to kept values in first column:

2 次查看（过去 30 天）
fernando aguirre
fernando aguirre 2018-5-25
评论： fernando aguirre 2018-5-25
Need to convert matrix A(250000x2) to A(14x250000) where values in first column repeat. Values in second column next to repeated values from first column need to be appended to the rows corresponding to that repeated value (and repeated values removed). Basically shifting. I can use unique to pull the values from the first column along with their index, but I am having trouble finding a way to transfer those values "up". Any suggestions?
[14 #1; 13 #1;...;1 #1;14 #2; 13 #2;...;1 #2;...14 #n; 13 #n;...;1 #n]
to
[14 #1 #2...#n;13 #1 #2...#n;...;1 #1 #2...#n]

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

采纳的回答

Ameer Hamza
Ameer Hamza 2018-5-25
Try
splitapply(@(x) {x}, A(:,2), findgroups(A(:, 1)));
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT-Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by