79 views (last 30 days)

Show older comments

Hey guys,

I'm sorting an 82x4 arraywith sortrows. I want it to be sorted in a descending way. First the second column shall be significant and for tiebreakers the third column.

My code is:

Knotenpaare=sortrows(Auswertung,[2 3],'descend')

where Auswertung is the array. The first 40 rows of the array are sorted beautifully. But at the moment the values in the second column switch from positive to negative the sorting changes.

Why are the values in the third column now ascending?

Is there a better way to sort these kinds of arrays ?

dpb
on 24 Feb 2021

"Is there an option to cut the number after 5 digits off? and not only visual."

node_Num=sign(node_Num).*floor(abs(node_Num)*1E5)/1E5;

Stephen Cobeldick
on 24 Feb 2021

There are probably nicer ways to do this, as this unfortunately changes the data itself. If required, you could use the index output from sortrows to sort the original data matrix.

format long g

S = load('Auswertungsknoten.mat');

A = S.Auswertung

for k = 1:size(A,2)

[U,X,Y] = uniquetol(A(:,k),1e-3);

A(:,k) = U(Y);

end

A

B = sortrows(A,[-2,-3])

B(38:48,:)

the cyclist
on 19 Feb 2021

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

Start Hunting!