Find negative in every n rows

1 vue (au cours des 30 derniers jours)
David du Preez
David du Preez le 12 Mai 2017
Commenté : Andrei Bobrov le 15 Mai 2017
I have a 2184 x 14 matrix. In column 1 is the datenum value and in column 14 the values that I want to consider. The other columns contain some other data.
I want to consider the first 24rows if any of the values in column 14 are negative. I want to delete the first 24rows and then repeat this for the following 24rows.

Réponse acceptée

Andrei Bobrov
Andrei Bobrov le 12 Mai 2017
Modifié(e) : Andrei Bobrov le 15 Mai 2017
One way
% A - your data [2184 x 14]
ii = ceil((1:size(A,1))'/24);
jj = accumarray(ii,A(:,14),[],@(x)all(x >= 0)); % EDIT
out = A(jj(ii),:);
  2 commentaires
David du Preez
David du Preez le 15 Mai 2017
Modifié(e) : David du Preez le 15 Mai 2017
That does not work. It does not find any negative neither removes them. attached in the matrix in question
Andrei Bobrov
Andrei Bobrov le 15 Mai 2017
I'm fixed my answer.

Connectez-vous pour commenter.

Plus de réponses (1)

Jan
Jan le 15 Mai 2017
Modifié(e) : Jan le 15 Mai 2017
Data = rand(2184, 14) - 0.1; % Test data
D = reshape(Data, 24, [], 14);
Match = any(D(:, :, 14) < 0, 1);
Result = reshape(D(:, Match, :)), [], 14);

Catégories

En savoir plus sur Resizing and Reshaping Matrices dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by