Sorting a matrix column to match another column
7 ビュー (過去 30 日間)
古いコメントを表示
I have a 20x3 table and a 20x6 double.
The table has a bunch of strings and a column of identifying numbers in no particular order.
example:
[a b 44;
c d 16;
e f 03;
g h 63];
A column of the other matrix has the exact same numbers in a different order.
example:
[63;
16;
44;
3];
My question is if there's any way to sort the data in the table to match the order of the other matrix.
example:
[g h 63;
c d 16;
a b 44;
e f 03];
回答 (1 件)
Voss
2022 年 11 月 28 日
t = table( ...
["a";"c";"e";"g"],["b";"d";"f";"h"],[44; 16; 03; 63])
d = [63; 16; 44; 3];
[~,idx] = ismember(d,t{:,3});
t_sorted = t(idx,:)
0 件のコメント
参考
カテゴリ
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!