divide a matrix based on the presence of a coefficient

Hi everyone, I need a hand.

I have 87600 x 4 matrices where, in the fourth column, there is a value that differentiates between holidays = 0.8, pre-holidays = 0.9 and working days = 1.

How is it possible to create a script that allows you to divide the starting matrix into three matrices?

Where a matrix contains all the rows to which the fourth column is associated with the index 0.8, the second matrix contains all the rows in which the fourth column is associated with the index 0.9 and the third all the rows in which the last column is associated with a 1.

I hope I was clear in the question, an infinite thanks to those who know how to help me.

[Giuseppe D'Amico]

heeelp

[Giuseppe D'Amico]

load input
festivi = cell([],4);
[m,n] = size(input);

for i = 1:m
   if input(:,4)== 0.8 
  count = count+1;
  festivi{count,1} = input;
   end
end

I've tried this, but don't work. What should i change?

Answer 1

[Chunru]

A = randi(5, [80, 4]);      % your data
u = unique(A(:, 4));        % unique values of column 4
for i=1:length(u)
    B{i,1} = A( A(:,4) == u(i), :);
end
B

[Giuseppe D'Amico]

sorry I don't understand how to use it

[Chunru]

(1) Change the first line to your own data. I am using some random generated data for testing.

(2) Line 2 find the unique values of column 4

(3) The rest of code groups the matrix according to value in column 4 and assign the reults into a cell array.

Answer 2

[Steven Lord]

Do you need these as separate variables or do you just need to process each group of dates separately? In the latter case, see the findgroups, splitapply, groupsummary, and grouptransform functions and the functions listed in the "See Also" sections on their documentation pages.

Creating three variables from an array is probably okay, but creating a dynamic number of variables (when or if you start separating US holidays from UK holidays from state holidays from ...) is straying into discouraged territory.

[Giuseppe D'Amico]

@Steven Lord

I have for example a matrix created in the following way.

What I want is to divide it according to the value present in the fourth column, creating 3 different matrices.

input= [-600 1 0 0.8

-600 1 0 0.8

-600 1 0 0.8

-588 1 0 0.8

-588 1 1 0.9

-564 1 1 0.9

-540 1 1 0.9

-552 1 1 1

-516 1 2 1

-504 1 2 1

-480 1 2 1]

So:

A =[-600 1 0 0.8

-600 1 0 0.8

-600 1 0 0.8

-588 1 0 0.8]

B = [-588 1 1 0.9

-564 1 1 0.9

-540 1 1 0.9]

C = [-552 1 1 1

-516 1 2 1

-504 1 2 1

-480 1 2 1]