looking condition in matrix

Hey,

I got matrix

[ 2 9841 5 4 2 1;

3 79463 1 3 1 0;

3 79463 4 3 1 0;

3 79463 5 3 1 0;

3 79463 1 3 2 0;

3 79463 4 3 2 0;

3 79463 5 3 2 0;

3 79463 1 4 1 0;

3 79463 4 4 1 0;

3 79463 5 4 1 0;

3 79463 1 4 2 0;

3 79463 4 4 2 0;

3 79463 5 4 2 0;

3 79463 1 4 1 1;

3 79463 4 4 1 1;

3 79463 5 4 1 1;

3 79463 4 4 1 1;

3 79463 5 4 1 1;

3 79212 1 3 1 0;]

I have to look for every row in column 1,2,4,5, if they match, then i check last column 6th, where is information if row data is correct or wrong.

If there are both correct and wrong data for rows that all include same values in column 1,2,4,5 than i must keep only correct data and erase wrong. If there is only wrong data for row than i keeep it.

The result should erase those two rows...

3 79463 4 4 1 0;

3 79463 5 4 1 0;

Thank you for your suggestions and solutions, take care.

Nejc

[Yao Li]

Do you mean in each row, the 1st element should be 3, the 2nd should be 79463, the 4th element should be 4 and the 5th element should be 1? If not, the wrong element should be corrected and the 6th element is 0.

[Nejc]

The 1st, 2nd, 4th and 5th must be same (have large data with all kind values, i've just took a sample). If thats correct than i have to look for 6 column what kind of data is..0-wrong, 1-correct. if both exist for i must keep only rows with 1, otherwise if just 0 exist for rows(same 1,2,4,5 parameters) than i keep 0-wrong data, because there arent correct data :) I hope now is more clear what my problem is...sorry for my english

[Yao Li]

Sorry, I haven't got it yet. Maybe you can take the first 5 rows for example. Pls. give the results for the first 5 rows.

[Nejc]

No problem, first 5 rows: 2 9841 5 4 2 1; this row is only one which got same 1st,2nd,4th,5th parameters, we look for 6th and it's 1, ok we keep that row...

now next 3 rows have same 1st,2nd,4th,5th parameters, again we check for 6th column and each row have value 0...becasue we dont have 1 in that 6th, we keep that 3 rows.

The crucial here are rows which consist of 1st-3 2nd- 79463 4th-4 5th-1 parameters....We have 8 rows that meet those parameters. So we look 6 column now and there are both 0-wrong and 1- correct, because there are both options i want to keep just correct rows and erase wrong.

Answer 1

[Andrei Bobrov]

a = [ 2 9841 5 4 2 1;3 79463 1 3 1 0;3 79463 4 3 1 0;3 79463 5 3 1 0;3 79463 1 3 2 0;3 79463 4 3 2 0;3 79463 5 3 2 0;3 79463 1 4 1 0;3 79463 4 4 1 0;3 79463 5 4 1 0;3 79463 1 4 2 0;3 79463 4 4 2 0;3 79463 5 4 2 0;3 79463 1 4 1 1;3 79463 4 4 1 1;3 79463 5 4 1 1;3 79463 4 4 1 1;3 79463 5 4 1 1;3 79212 1 3 1 0;];

[~,~,ii] = unique(a(:,[1 2 4 5]),'rows');
i1 = histc(ii,1:max(ii));
out = a(ismember(ii,find(i1 > 1)) & a(:,end) == 1,:);

[Nejc]

[ 2 9841 5 4 2 1;

3 79463 1 3 1 0;

3 79463 4 3 1 0;

3 79463 5 3 1 0;

3 79463 1 3 2 0;

3 79463 4 3 2 0;

3 79463 5 3 2 0;

3 79463 1 4 2 0;

3 79463 4 4 2 0;

3 79463 5 4 2 0;

3 79463 1 4 1 1;

3 79463 4 4 1 1;

3 79463 5 4 1 1;

3 79463 4 4 1 1;

3 79463 5 4 1 1;

3 79212 1 3 1 0;]

without

3 79463 1 4 1 0;

3 79463 4 4 1 0;

3 79463 5 4 1 0;

but i appreciate your effort.