MATLAB Answers

return row index of values greater than 0 to a 3 dimensional array

38 views (last 30 days)
Charles
Charles on 21 Apr 2019
Answered: Andrei Bobrov on 21 Apr 2019
I have a Matrix A, of m x n dimensions.
I wish to go through each row from left to right and return the index of values greater than 0. I have tried the folowing which returns the column index for the first row which has values. for example row 26.
I have tried the following but I am not getting the outputmatrix with all entries. I fear the entries are being overwritten
A =[2,-4,-0.5,0.34;0.01,4,-0.5,0.34;-10,4,-0.2,0.6;-10,4,-0.2,0.6;-19,15,-0.7,0.6];
% Now we have input matrix A we want to return the col index of each row element greater than 0.
% inputMatrix= A
outputMatrix=zeros(1,[],size(A,1));
for i = 26:size(A(2:end,:),1)
for ij = 1:size(A(2:end,:),2)
[rows, columns] = find(inputMatrix > 0)
outputMatrix=columns;
end
end
A =
2 -4 -0.5 0.34
0.01 4 -0.5 0.34
-10 4 -0.2 0.6
-10 4 -0.2 0.6
-19 15 -0.7 0.6
However I wish to go through each row, and store these column indices in a 3 dimensional array where each page represents the set of column indices from each row of A
Example output is a 3 dimensional array of column indices. - Matrix E
1, 4 (page 1)
1, 2, 4 (page 2)
2, 4 (page 3
2, 4 (page 4)
2,4 (page 5)
I then want to use these column indices to return the value from the corresponding rows of a matrix C and matrix D. Matrix C and D are the same dimentions as A
I then want to multiply C values by D values and return a 3 dimension array of results. - Matrix F
The results will be of the same dimension as Matrix E
Any help appreciated.

  7 Comments

Show 4 older comments
Walter Roberson
Walter Roberson on 21 Apr 2019
Your page 2 output is longer than the other outputs. How do you want to handle varying lengths of output ?
Charles
Charles on 21 Apr 2019
i have updated the code somewhat. I hope its clearer.
Yes i understaqdn the page 2 is longer. Note sure what the answet is. Perhaps I can fill with zeros to make all the same length, but not sure how to do this
Charles
Charles on 21 Apr 2019
i also want to store the output in the output matrix and i wonder if i have the last line of the code
correct,s o that is store all indices and not overtirwe anything
outputMatrix=columns;

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 21 Apr 2019
Try this:
A = [2,-4,-0.5,0.34;0.01,4,-0.5,0.34;-10,4,-0.2,0.6;-10,4,-0.2,0.6;-19,15,-0.7,0.6];
[rows, columns] = find(A > 0)

  4 Comments

Show 1 older comment
Image Analyst
Image Analyst on 21 Apr 2019
Explain which of those (row, column) pairs do not represent a non-zero value.
for example A(2,1) is zero when rows(2) and columns(2), which give a (row, column) pair of (2, 1) say that it's non-zero (in fact for this location, A(2,1) is 0.01 which is in fact non-zero)
Are you sure you're thinking in terms of (x,y) and not (row, column)? Matrices are not indexed (x,y) as you probably (or should) know.
In your example up top, explain how you get each element of E.
Charles
Charles on 21 Apr 2019
Hi Thanks for this. Your correct, but what I am seeking as output is merely the column index for elements > 0. in each row vector
Thus I am expecting is
1, 4
1,2,4
2, 4
2, 4
2, 4
i now know that in row 1 i have columns 1 and 4,
in row two, i have columns 1, 2, and 4 etc etc
I guress your output if correct afterall. I need to savre these answer in the outout matrix. how do I do that?
Charles
Charles on 21 Apr 2019
Output E, does represent the column indices you have prodcued with your answer, so your correct. i would like to fit the row and columns into the output matrix, so i I can use it to index into another matrix. How do i pllace tyhe indcies into the output matrix?

Sign in to comment.

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 21 Apr 2019
[ii,jj] = find(A > 0);
out = accumarray(ii,jj,[],@(x){sort(x)'});
out{:}

  0 Comments

Sign in to comment.

Sign in to answer this question.