Question about sorting an array column by column
7 views (last 30 days)
Show older comments
I need to sort each column of a 1073x15 array for a heatmap in MATLAB.
[~,sortdices] = sort(choose_data(:,1),'ascend');
%choose_data = choose_data(:,sortdices);
for i=1:15
choose_data(:,i) = choose_data(sortdices,i)
end
this is my code. choose_data is the 1073x15 array. My output ends up being the first column sorted in ascending order, but the rest not. How do I fix it, such that all columns are sorted in ascending order? (Thank you for any help!)
2 Comments
Walter Roberson
on 27 Sep 2021
Is each column to be sorted independently, or should the columns be sorted "within" each previous column? That is, if two rows have the same value for column 1, then look at column 2 to determine the order; if those are equal, look at column 3, and so on ? If so then sortrows()
Answers (2)
the cyclist
on 27 Sep 2021
Edited: the cyclist
on 27 Sep 2021
choose_data = sort(choose_data)
will sort every column independently. Ascending sorting is the default, so you don't need to specify that. (But it also doesn't hurt, and might make the code clearer.)
2 Comments
the cyclist
on 27 Sep 2021
Edited: the cyclist
on 27 Sep 2021
Strange. Here is an example that illustrates that the syntax works:
M = magic(3)
M = sort(M)
Note that you do not need to do anything in a for loop. That one line of code will sort all columns of the array. You also don't need to do any indexing into the array.
Steven Lord
on 27 Sep 2021
Specify the dim input argument to the sort function.
A = magic(5)
B = sort(A, 1)
% Compare with
C = sort(A, 2)
If you want to sort one of the columns and have the rest of the rows rearrange correspondingly see the sortrows function.
D = sortrows(A, 2) % sort by column 2
0 Comments
See Also
Categories
Find more on Data Distribution Plots in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!