Sort matrix based on unique values in one column

48 Ansichten (letzte 30 Tage)
Ida Rosendahl
Ida Rosendahl am 14 Apr. 2016
Kommentiert: Ranjith K am 15 Sep. 2022
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!

Akzeptierte Antwort

Stephen23
Stephen23 am 14 Apr. 2016
Bearbeitet: Stephen23 am 14 Apr. 2016
[~,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 Kommentare
ömer canözü
ömer canözü am 20 Mär. 2022
thank you so much
Ranjith K
Ranjith K am 15 Sep. 2022
[~,idu] = unique(mat(:,1))
how to mention the name inside of 1 2 ....10
For example B1 B2 B3.............B10

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (2)

Guillaume
Guillaume am 14 Apr. 2016
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 am 15 Feb. 2018
sir, If we want to keep only maximum value besides second unique column value...

Kategorien

Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by