MATLAB: Creating a three column table from matrix

matrix manipulation

If I have a matrix, how can I make a table with three columns that are row number, column number, and then the value for that row-column? And then, add a 4th column with the row-column number? example in picture

Best Answer

Hi,

because you want a string in your 4th column, you need a cell array. here's my q&d solution:

A=rand(3,3);
new = cell(numel(A),4);
kk=1;
for ii = 1:size(A,1);
  for jj = 1:size(A,2);
  new{kk,1}=ii;
  new{kk,2}=jj;
  new{kk,3}=A(ii,jj);
  new{kk,4}=[num2str(ii) '-' num2str(jj)];
  kk=kk+1;
  end;
end

Regards

Julian

Related Solutions

MATLAB: How to retain only the rows of a matrix based on the unique numbers in the first column of the matrix

[ii,jj,kk]=unique(a(:,1),'stable');
out1=a(jj,:)
out2=cell2mat(accumarray(kk,1:numel(kk),[],@(x) {a(max(x),:)}));

MATLAB: Random matrix with maximum values.

You could do this:

w = floor(sqrt(30))
rows = 1 : w
counter = 1;
for k = 1 : length(rows)
	columns(k) = floor(30/rows(k));
	for col = 1 : columns(k)
		fprintf('For %d rows, and %d columns, there are %d elements.\n',...
			rows(k), col, rows(k) * col);
		allMatrices{counter} = rand(rows(k), col);
		counter = counter + 1;
	end
end

You'll get every possible matrix size with 30 or fewer elements in it. And each one will be a cell in the allMatrices cell array. It has to be a cell array rather than a 3-D matrix because the matrices are not all the same size. You'll see in the command window:

w =

rows =

1 2 3 4 5

For 1 rows, and 1 columns, there are 1 elements.

For 1 rows, and 2 columns, there are 2 elements.

For 1 rows, and 3 columns, there are 3 elements.

For 1 rows, and 4 columns, there are 4 elements.

For 1 rows, and 5 columns, there are 5 elements.

For 1 rows, and 6 columns, there are 6 elements.

For 1 rows, and 7 columns, there are 7 elements.

For 1 rows, and 8 columns, there are 8 elements.

For 1 rows, and 9 columns, there are 9 elements.

For 1 rows, and 10 columns, there are 10 elements.

For 1 rows, and 11 columns, there are 11 elements.

For 1 rows, and 12 columns, there are 12 elements.

For 1 rows, and 13 columns, there are 13 elements.

For 1 rows, and 14 columns, there are 14 elements.

For 1 rows, and 15 columns, there are 15 elements.

For 1 rows, and 16 columns, there are 16 elements.

For 1 rows, and 17 columns, there are 17 elements.

For 1 rows, and 18 columns, there are 18 elements.

For 1 rows, and 19 columns, there are 19 elements.

For 1 rows, and 20 columns, there are 20 elements.

For 1 rows, and 21 columns, there are 21 elements.

For 1 rows, and 22 columns, there are 22 elements.

For 1 rows, and 23 columns, there are 23 elements.

For 1 rows, and 24 columns, there are 24 elements.

For 1 rows, and 25 columns, there are 25 elements.

For 1 rows, and 26 columns, there are 26 elements.

For 1 rows, and 27 columns, there are 27 elements.

For 1 rows, and 28 columns, there are 28 elements.

For 1 rows, and 29 columns, there are 29 elements.

For 1 rows, and 30 columns, there are 30 elements.

For 2 rows, and 1 columns, there are 2 elements.

For 2 rows, and 2 columns, there are 4 elements.

For 2 rows, and 3 columns, there are 6 elements.

For 2 rows, and 4 columns, there are 8 elements.

For 2 rows, and 5 columns, there are 10 elements.

For 2 rows, and 6 columns, there are 12 elements.

For 2 rows, and 7 columns, there are 14 elements.

For 2 rows, and 8 columns, there are 16 elements.

For 2 rows, and 9 columns, there are 18 elements.

For 2 rows, and 10 columns, there are 20 elements.

For 2 rows, and 11 columns, there are 22 elements.

For 2 rows, and 12 columns, there are 24 elements.

For 2 rows, and 13 columns, there are 26 elements.

For 2 rows, and 14 columns, there are 28 elements.

For 2 rows, and 15 columns, there are 30 elements.

For 3 rows, and 1 columns, there are 3 elements.

For 3 rows, and 2 columns, there are 6 elements.

For 3 rows, and 3 columns, there are 9 elements.

For 3 rows, and 4 columns, there are 12 elements.

For 3 rows, and 5 columns, there are 15 elements.

For 3 rows, and 6 columns, there are 18 elements.

For 3 rows, and 7 columns, there are 21 elements.

For 3 rows, and 8 columns, there are 24 elements.

For 3 rows, and 9 columns, there are 27 elements.

For 3 rows, and 10 columns, there are 30 elements.

For 4 rows, and 1 columns, there are 4 elements.

For 4 rows, and 2 columns, there are 8 elements.

For 4 rows, and 3 columns, there are 12 elements.

For 4 rows, and 4 columns, there are 16 elements.

For 4 rows, and 5 columns, there are 20 elements.

For 4 rows, and 6 columns, there are 24 elements.

For 4 rows, and 7 columns, there are 28 elements.

For 5 rows, and 1 columns, there are 5 elements.

For 5 rows, and 2 columns, there are 10 elements.

For 5 rows, and 3 columns, there are 15 elements.

For 5 rows, and 4 columns, there are 20 elements.

For 5 rows, and 5 columns, there are 25 elements.

For 5 rows, and 6 columns, there are 30 elements.

Best Answer

Related Solutions

MATLAB: How to retain only the rows of a matrix based on the unique numbers in the first column of the matrix

MATLAB: Random matrix with maximum values.

Related Question