Sort matrix based on unique values in one column

29 次查看（过去 30 天）
Ida Rosendahl
Ida Rosendahl 2016-4-14
评论： Ranjith K 2022-9-15
Hi guys. I can't seem to overcome my problem. I have a matrix with 5 columns and a lot of rows. I need to sort the whole matrix based on unique values in column 1. How do I do that? So I need to find the unique values (its a timestamp from my experiment) in column one and also the corresponding values in the rest of the columns and everything else needs to be deleted. Thanks!

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

采纳的回答

Stephen23
Stephen23 2016-4-14
编辑：Stephen23 2016-4-14
[~,idx] = sort(mat(:,1)); % sort just the first column
sortedmat = mat(idx,:); % sort the whole matrix using the sort indices
You can even do the same thing with unique to get the rows corresponding to unique values in the first column:
[~,idu] = unique(mat(:,1))
uniquerows = mat(idu,:);
Note that unique has options for controlling the order of its outputs, and whether it takes the first or last matching element. You should check its documentation and pick the best options for you requirements.
  11 个评论
显示 9更早的评论
Ranjith K
Ranjith K 2022-9-15
[~,idu] = unique(mat(:,1))
how to mention the name inside of 1 2 ....10
For example B1 B2 B3.............B10

请先登录，再进行评论。

更多回答（2 个）

Guillaume
Guillaume 2016-4-14
I'm not sure what you mean by "and everything else needs to be deleted". Does that means that rows with identical first column also have the exact same values for all the other columns, or that you want to somehow merge these identical rows into just one?
Assuming all duplicate rows are identical (but then why would you say unique values in one column?):
b = unique(a, 'rows');
Assuming you want to just keep one arbitrary row out of the ones that have identical first column:
[~, rows] = unique(a(:, 1));
b = a(rows, :);
If you want to somehow merge the duplicate rows, it probably can be done but you need to give more details.
Mohammad Bhat
Mohammad Bhat 2018-2-15
sir, If we want to keep only maximum value besides second unique column value...

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by