MATLAB: Classification of a matrix to 0 and 1 matrix

accumarrayarraymatrixnumel

Hello everyone,

I want matrix A to be like matrix B

ID, age and sex groups are repeated in matrix A. Matrix B is classified age based on the sex group with counting the value from matrix A. if any value in any group was repeated more than 1, then total will appear in matrix B. For example, in matrix A: ID=5, Age group=2, Sex group=2—>Then in matrix B: the value (4,5) is equal by 2

Best Answer

Assuming A and B are numerical arrays arranged as shown in your diagram,

   B = accumarray([2*A(:,2)+A(:,3)-2,A(:,1)],1,[2*max(A(:,2)),max(A(:,1))]);

Related Solutions

MATLAB: Grouping rows on the first two columns

A = [13  30  7
13  30  6
13  40  5
13  40  6
12  30  7
12  37  5] ;
% engine
[B,~,gi] = unique(A(:,[1 2]),'rows','stable') % unique rows, with grouping index
B(:,3) = accumarray(gi(:), A(:,3), [], @max)

MATLAB: How to apply for loop for cell arrays

a =(1000-0).*rand(10,2)+0
[r,c] = size(a)
mina = [1 7] ;
maxa = [6 10] ;
b = cell(numel(mina),1) ;
for o = 1:numel(mina)
  b{o} = a(mina(o): maxa(o),:);
end
for k=1:numel(b)
  bb=b{k};
  [r,c]=size(bb);
  max_a= zeros(r,c);
  for i = 1:r
      for j = 1:c
          max_a(i,j) = max(a(1:i,j)) ;
      end
  end
  max_b{k}=max_a
end

Best Answer

Related Solutions

MATLAB: Grouping rows on the first two columns

MATLAB: How to apply for loop for cell arrays

Related Question