Check and eliminate rows based on conditions.

2 次查看（过去 30 天）
yue ishida
yue ishida 2016-8-2
评论： yue ishida 2017-7-5
Hi. I have a matrix as below. I need help to code this problem.
A=
1 0 0 0 0 0 0
0 1 0 0 0 0 0
0 0 1 0 0 0 0
0 0 0 1 0 0 0
0 0 0 0 1 0 0
0 0 0 0 0 1 0
0 0 0 0 0 0 1
1 0 0 0 0 0 0
0 1 0 0 0 0 0
0 0 1 0 0 0 0
0 0 0 1 0 0 0
0 0 0 0 1 0 0
0 0 0 0 0 1 0
1. Therefore, I have to check every row in third column.
2. For every row in third column, I have to ensure that all previous rows have more value than current row value. If any previous row value in third column is less than current value, that previous row will be eliminated. Else, previous row will maintain.
3. For matrix A, as result, all rows except row 3, 10, 11, 12, and 13 will eliminate. End result after check and eliminate will produce matrix B as below.
B=
0 0 1 0 0 0 0
0 0 1 0 0 0 0
0 0 0 1 0 0 0
0 0 0 0 1 0 0
0 0 0 0 0 1 0
Thank you.
  2 个评论
Walter Roberson
Walter Roberson 2016-8-2
According to your rules, rows 11, 12, and 13 should be retained. The entry in the third column for those is 0, and no previous row has a value less than 0.
yue ishida
yue ishida 2016-8-2
编辑：yue ishida 2016-8-2
Thanks for your correction. You're right. I'm missing on row 11, 12, and 13 too. I already improved my question.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2016-8-2
mask = A(:,3) == max(A(:,3));
A = A(mask,:);
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2017-7-4
Please explain your question. What are the expected results and what are the rules?
yue ishida
yue ishida 2017-7-5
can we apply similar code to cell? the cell is like this. algorithm is same.
step2 =
'Q1' [1x117 char] [22] [0.8148]
'Q2' [1x86 char] [17] [0.6296]
'Q3' [1x57 char] [12] [0.4444]
'Q4' [1x86 char] [17] [0.6296]
'Q5' [1x67 char] [14] [0.5185]
'Q6' [1x113 char] [22] [0.8148]
This is algorithm needed.
1. Therefore, I have to check every row in third column.
2. For every row in third column, I have to ensure that all previous rows have more value than current row value. If any previous row value in third column is less than current value, that previous row will be eliminated. Else, previous row will maintain.
3. For cell step 2,, as result, all rows except row 1 (Q1) and last (Q6) will eliminate.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by