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)

Categorie

Scopri di più su Programming in Centro assistenza e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by