Sort rows of matrix by matching column with another matrix column

5 次查看（过去 30 天）
John Hernandez
John Hernandez 2020-2-10
评论： John Hernandez 2020-2-11
Hello All!
So I have two matrices, both the same size (88 rows and 31 columns).
In one matrix (A), I have the row data sorted in descending order based off of columns 28, 29 and 30 and in column 31 I have the identifiers for each individual.
In matrix B, I want to sort rows so that all of column 31 identifiers match column 31 of matrix A.
I'm more than happy to give an example, but the data set is pretty large and didn't want to copy and paste.

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

采纳的回答

James Tursa
James Tursa 2020-2-10
E.g., assuming everything in column 31 has a match
[~,x] = ismember(A(:,31),B(:,31));
Bsort = B(x,:);

更多回答（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!

Translated by