I want to know the cell number i.e. row and column of the matrix, whichever is above 10% of the normal vlaue. and i also want to get the values in the cell.

Hi I have a matrix with 338 rows and 210 columns.

I want to know the cell number i.e. row and column of the matrix, whichever is above 10% of the normal value. and i also want to get the values in the cell.

the code i have written TBS_down=AUC_final_TBS_down

TBS_down(abs(TBS_down)<0.1)=0; [I,J]=find(abs(TBS_down)>0);

it is just to find all values above 0.1 but i also need to get the row and column i.e. I and J (which correspond to certain parameters) values and also the value in the corresponding cell so i dont have to look manually. Help would be so great. Thanks

Answer 1

[Venkata Siva Krishna Madala]

Hello Parul,

You are doing the extraction of the row and column number properly. However, to get the value in the cell you can do any of the following

extracted_values=TBS_down(I,J)
extracted_values=AUC_final_TBS_down(I,J)

If you want the row, column, and the value then you can probably iterate as shown below and put the elements into a cell array.

c={}
temp=[I,J]
for i=1:size(temp,1)
    c{i}=[temp(i,1) temp(j,1) TBS_down(temp(i,1),temp(j,1))];
end

Regards,

Krishna Madala

Answer 2

[Jos (10584)]

I am unsure if I understand your question completely, but here is my 2p:

X = rand(4,3)  % example data
TF = X > 0.1 
[rownum, colnum] = find(TF)
value = X(TF)