Check and eliminate rows based on conditions.

2 Ansichten (letzte 30 Tage)
yue ishida
yue ishida am 2 Aug. 2016
Kommentiert: yue ishida am 5 Jul. 2017
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 Kommentare
Walter Roberson
Walter Roberson am 2 Aug. 2016
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 am 2 Aug. 2016
Bearbeitet: yue ishida am 2 Aug. 2016
Thanks for your correction. You're right. I'm missing on row 11, 12, and 13 too. I already improved my question.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Walter Roberson
Walter Roberson am 2 Aug. 2016
mask = A(:,3) == max(A(:,3));
A = A(mask,:);
  5 Kommentare
Walter Roberson
Walter Roberson am 4 Jul. 2017
Please explain your question. What are the expected results and what are the rules?
yue ishida
yue ishida am 5 Jul. 2017
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.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by