Delete row not following pattern

1 次查看(过去 30 天)
Hi,
I have....
a = [ 2 5 1 0.504;
3 6 2 0.507;
3 4 1 0.589;
9 4 2 0.503;
8 3 1 0.592;
3 2 2 0.203;
9 5 2 0.341;
4 8 1 0.592]
Notice how the 2nd to the last column, column #3, follows a pattern of 1, 2, 1, 2..and so on. The 7th row however has a 2 in the 2nd last column just like the 6th row before...thus does not follow the pattern. I want to delete one of these two rows based on the value in the last column. I want to delete which ever row has a value in the last column further away from the number 0.500.
I would want to delete any row where the 2nd last column does not follow the pattern 1,2,1,2 and when deciding between which row out of the two rows to delete...base it on whichever is further from the number 0.500. Thanks!
  1 个评论
Image Analyst
Image Analyst 2015-7-10
Do you startup the pattern again after deleting the row? In other words, is row 8 correct because you're starting up fresh with the next number in the pattern (1)? Or is it wrong because row 7 should have been a 1 and row 8 should have been a 2. Since row 8 should have been a 2 and it's a 1, it's wrong, unless you're restarting the pattern after deleting row 7.

请先登录,再进行评论。

采纳的回答

James Tursa
James Tursa 2015-7-10
编辑:James Tursa 2015-7-10
Assuming the pattern in the next-to-last column must be 1-2-1-2-...etc exactly
[m,n] = size(a);
n1 = n - 1;
expected = 1; % initialize expected value in 1st row
x = false(m,1); % initialize the deletion flag array
keep = 0; % initialize row to keep when marking for deletion
v = 0.5; % discriminator value for deciding which line to delete
for k=1:m
if( a(k,n1) ~= expected ) % if not as expected, mark one line for deletion
if( keep == 0 || abs(a(k,n)-v) > abs(a(keep,n)-v) )
x(k) = true; % mark current line for deletion
else
x(keep) = true; % mark previous line for deletion
keep = k;
end
else
expected = 3 - expected; % if as expected, update expected
keep = k;
end
end
a(x,:) = []; % delete the unexpected pattern rows
If the first line can start with a 2 rather than a 1, change this line:
expected = a(1,n1); % initialize expected value in 1st row

更多回答(1 个)

Azzi Abdelmalek
Azzi Abdelmalek 2015-7-10
编辑:Azzi Abdelmalek 2015-7-10
a = [ 2 5 2 0.504; 3 6 2 0.507; 3 4 1 0.589; 9 4 2 0.503; 8 3 1 0.592; 3 2 2 0.203; 9 5 2 0.341; 4 8 1 0.592]
c3=a(:,3)
c4=a(:,4)
id=[1 diff(c3)' ]
ii=find(id==0)
for k=1:numel(ii)
[~,jd]=min(c4(ii(k)-1:ii(k)))
idx(k)=ii(k)+jd-2
end
a(idx,:)=[]

类别

Help CenterFile Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by