Info
此问题已关闭。 请重新打开它进行编辑或回答。
Delete Lines if there are three e qual lines
1 次查看(过去 30 天)
显示 更早的评论
Hi, i have this problem. I have a matrix A(m ; 8). I would have new Matrix B where are delete the Lines Whith this idea: if in matrix A There are three Numbers that are the same in Colomn 3 and 5, in the new Matrix delete this three Lines.
7 个评论
jonas
2018-10-29
编辑:jonas
2018-10-29
Let me guess
A =
1 3 7 8 9 7 2 8
9 0 3 5 2 1 4 9
0 2 3 6 2 7 7 7
3 2 3 5 2 2 5 7
↑ ↑
Delete rows where three or more (consecutive???) columns share the same value? Clarify:
- consecutive duplicates only?
- limit the check to columns 3 & 5?
- exactly three duplicates or more than three?
- is the matrix always 4 rows?
- What if only column 3 has consecutive duplicates? Or only column 5?
To summarize: I don't think you have thought this through.
回答(1 个)
Stephen23
2018-10-29
编辑:Stephen23
2018-10-29
This should get you started:
>> A = [1,3,7,8,9,7,2,8;9,0,3,5,2,1,4,9;0,2,3,6,2,7,7,7;3,2,3,5,2,2,5,7]
A =
1 3 7 8 9 7 2 8
9 0 3 5 2 1 4 9
0 2 3 6 2 7 7 7
3 2 3 5 2 2 5 7
>> B = [1,3,7,8,9,7,2,8] % expected output
B =
1 3 7 8 9 7 2 8
>> X = diff(A(:,[3,5]),1,1)==0;
>> Y = X(1:end-1,:) & X(2:end,:);
>> Z = any(conv2(Y,[1;1;1])>0,2); % either column 3 OR 5
>> B = A(~Z,:)
B =
1 3 7 8 9 7 2 8
If you want both columns to fit the condition:
Z = all(conv2(Y,[1;1;1])>0,2)
1 个评论
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!