Azzera filtri
Azzera filtri

Find minimum and create a new matrix

2 visualizzazioni (ultimi 30 giorni)
I have a 242x14 matrix. I want to look at the first 22 lines and find the minimum value in column 10. Then I want to create a new matrix including all the columns before the minimum value and a second new matrix containing the minimum value and all the values after it.
I also want to repeat this for the remaining part of the matrix. So in other words I will have two 121x14 matrices.
  2 Commenti
KSSV
KSSV il 12 Apr 2017
You want to find minimum value for every 22 rows and them split the matrix, is it?
David du Preez
David du Preez il 12 Apr 2017
Yes that is what I want to do

Accedi per commentare.

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 12 Apr 2017
m = size(test_1,1);
i0 = (0:22:m-1)';
ii = ceil((1:m)'/22);
T = test_1(:,10);
T(T == 0) = inf;
idx_min = accumarray(ii,T,[],@(x)find(min(x) == x)) + i0;
ind = zeros(m,1);
ind([idx_min;i0+1]) = 1;
ind = cumsum(ind);
t = rem(ind,2) ~= 0;
Result{1} = test_1(t,:);
Result{2} = test_1(~t,:);

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by