comparing columns in matlab

Hello,
say, A==[0,0,1,2,3,3,6,6; 8,4,5,6,7,7,8,2; 9,9,10,10,11,12,22,45; 0,1,0,2,7,8,16,17; 0 0 0 0 0 0 1 1];
I need to delete the entire rows if any one of them happens:
a) column 1= column2
b) column3 =column4
c)column5 = column6
d)column7 = column8
e) column 5=column8
so finally, i''ll get,
A= [0,1,0,2,7,8,16,17]
Could you please help me knowing this how to do?
(edited)

 Risposta accettata

Andrei Bobrov
Andrei Bobrov il 23 Gen 2019

1 voto

out = A(all(A(:,1:2:end) ~= A(:,2:2:end),2),:)

4 Commenti

Sky Scrapper
Sky Scrapper il 23 Gen 2019
Modificato: Sky Scrapper il 23 Gen 2019
sorry, i''ll have to put one more condition that if:
column 5=column8
then i will have to delete that row also.
Sky Scrapper
Sky Scrapper il 23 Gen 2019
please answer on the edited question.
Andrei Bobrov
Andrei Bobrov il 24 Gen 2019
out = A(all(A(:,[5,1:2:end]) ~= A(:,[end,2:2:end]),2),:)
Sky Scrapper
Sky Scrapper il 24 Gen 2019
thanks

Accedi per commentare.

Più risposte (0)

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by