Find negative in every n rows

2 views (last 30 days)
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.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 12 May 2017
Edited: Andrei Bobrov on 15 May 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 Comments
David du Preez
David du Preez on 15 May 2017
Edited: David du Preez on 15 May 2017
That does not work. It does not find any negative neither removes them. attached in the matrix in question
Andrei Bobrov
Andrei Bobrov on 15 May 2017
I'm fixed my answer.

Sign in to comment.

More Answers (1)

Jan
Jan on 15 May 2017
Edited: Jan on 15 May 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);

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!