Exclude one row from calculation

Hello, i am new in MATLAB. I am searching for a way to calculate with every but one row (in this example it is the second row).

This is my code, which doesn`t work:

Reference=2;

ABC=[1;2;3;4;5;6];

logodds(1:5,:)=log(ABC(:~=Reference,1)./ABC(Reference,1));

What i could do would be:

logodds(1:5,:)=log(ABC([1 3 4 5 6],1)./ABC(Reference,1));

But the first part of the calculation ABC([1 3 4 5 6],1) musst be dependent on "Reference" because the value of Reference can change between 1 and 6. It should be a solution, where i don´t have to enumerate every row seperately. I want to express something like: Use for calculation every row (:) except the Reference-row (~=Reference).

I will greatly appreciate any assistance.

Answer 1

[Rik]

The easiest way to do this is with a logical vector:

Reference=2;
ABC=[1;2;3;4;5;6];
L=ABC~=Reference;
logodds(1:5,:)=log(ABC(L,1)./ABC(Reference,1));

However, this might fail for decimal values that have float rounding errors. In that case you may want to use ismembertol to generate the vector, or use

L= abs(ABC-Reference) < 2*eps;

[Max Bornemann]

Thank you for your answer.

It was just coincidental that Reference = 2 AND at the same time the second row has the value 2 in my example.

Imagine the second row has different values than 2 and maybe also more than one column like:

ABC=[1 1 1; 3 4 4; 3 3 3; 4 4 4; 5 5 5; 6 6 6]

I don't get in this case.

[Rik]

You can use the all or any functions to convert L back to a vector to suit your needs. This method does not rely on the 2 being in the second row, so that does not matter.

[Max Bornemann]

Didn't know all of any functions. Thanks again! :-)