How to sort only nonzeros values of an array that is linked to cell array ?

Hello,

I did a combination between 5 elements (A, B, C, D, E). Each combination corresponds to a value. As shown below.

T =

6×3 cell array

{'A' } {'D'} {[ 0]}

{'B'} {'D'} {[ 0]}

{'C'} {'D'} {[ 0]}

{'A' } {'E' } {[ 0]}

{'B'} {'E' } {[6.008]}

{'C'} {'E' } {[4.385]}

Now I would like to sort in another matrix, with only non zeros values, by keeping the relation between number and combinations.

For example,

I need to extract 6.008 and I want that it shows that this numbers correponds to {'B'} and {'E' }

Could you help me ?

[Jos (10584)]

The question is unclear. What is the input and the expected out precisely? What is "to sort in another matrix"?

[Rachel Sabioni]

I want to sort just that:

{'B'} {'E' } {[6.008]}

{'C'} {'E' } {[4.385]}

[Rachel Sabioni]

It means, all non zero values and their correspondant combinations

Answer 1

[madhan ravi]

[~,I] = sort(vertcat(T{:,3}));
sorted_T = T(I,:);
Corresponding_matche_s = T(vertcat(T{:,3})==6.008,:)

[madhan ravi]

Or maybe you want:

T(~(~vertcat(T{:,3})),:)
%or
T(find(vertcat(T{:,3})),:)
%or
T(any(vertcat(T{:,3}),2),:)

[Rachel Sabioni]

Perfect, it worked ! Thank you.

Now, it would be possible to order these elements according to the value ?

Example, order that from the smaller number to the highest number ?

{'B'} {'E' } {[6.008]}

{'C'} {'E' } {[4.385]}

[madhan ravi]

d = T(find(vertcat(T{:,3})),:)
[~,I]=sort(vertcat(d{:,3}));
d(I,:)

[Rachel Sabioni]

I am really grateful, thank you so much Madhan !!

I have another question. I would like to create a conditional loop to select some elements. For example.

If the value of combinations (6.008 or 4.385) is >= 5 I exclude, if it is less than 5 >I consider in a new matrix.

Is it possible to work with conditional statements like that by using cell arrays ?

[madhan ravi]

D = d( I, : );
New = D( cat( 1, D{:,3} ) < 5, : )

https://in.mathworks.com/learn/tutorials/matlab-onramp.html - please have a look at it , useful and free to learn Matlab.

[Rachel Sabioni]

Thanks. It worked.

However I would like to do that by using if loops, bcause I would like to insert many different conditions.