How to sort chunks of data file in descending order

Hello,

I have the attached data file (one column) where there are chunks of numbers separated by rows of zeros. I would like to know a quick way to sort every chunk of non zero numbers in descending order.

Thanks!

Answer 1

[KSSV]

Read the data using readtable and then use function sort.

[Nick Elias]

I tried this:

data=xlsread('Data.xlsx');
[rows, columns] = size(data);
sorted_X = reshape(sort(data(:), 'descend'), [columns, rows])';

But the output is just the whole column ranked in descending order. I need to rank every chunk of nonzero numbers separately and leave zeros in between.

[KSSV]

data=xlsread('Data.xlsx');
A = data' ; 

ii = zeros(size(A));
jj = abs(A) > 0;
ii(strfind([0,jj(:)'],[0 1])) = 1;
idx = cumsum(ii).*jj;
c = unique(idx) ; 
iwant = A' ; 
for i = 2:length(idx)
    iwant(idx==i) = sort(A(idx==i),'descend') ; 
end

Refer: https://in.mathworks.com/matlabcentral/answers/104614-grouping-continuous-nonzero-in-a-row-vector