Problem to delete rows in my matrix
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Aude Rapet
el 21 de Nov. de 2016
Comentada: Aude Rapet
el 21 de Nov. de 2016
Hi, I am a beginner in matlab and I try to delete rows from my matrix when two following values in my 3rd column are the same. I tried this :
for q=1:length(res)-1
if res(q,3)==res(q+1,3)
res(q,:) = [];
end
end
But I have the error message :
Index exceeds matrix dimensions.
Error in trackthebeads (line 8)
if res(q,3)==res(q+1,3)
I had 4020 values at the beginning, it managed to delete 36 but then it blocked I don't know why. Can you help me? Thanks, Aude
3 comentarios
Roger Stafford
el 21 de Nov. de 2016
Editada: Roger Stafford
el 21 de Nov. de 2016
@Per. I think this method might have the difficulty that a row might be deleted which might have provided a match in column 3 on the next step down, and that would abort another valid deletion. That is to say, there might be three successive equal elements in column 3 but only one row deletion as a result instead of two.
@Per Correction: On second thought I think your revised method actually does work properly. Forget the above paragraph.
Respuesta aceptada
Roger Stafford
el 21 de Nov. de 2016
The problem here is that you are reducing the row count of ‘res’ whenever you get a successive pair in column 3 that match. Hence when q gets near its upper end ‘res’ is no longer as large as it was initially.
One way of proceeding would be to simply collect all the row indices that need to be deleted, and then afterwards delete them all at once:
d = [];
for q=1:length(res)-1
if res(q,3)==res(q+1,3)
d = [d,q];
end
end
res(d) = [];
4 comentarios
Roger Stafford
el 21 de Nov. de 2016
That would appear to violate the rule that you originally stated: “delete rows from my matrix when two following values in my 3rd column are the same”. Can you carefully restate your criterion for deleting rows so as to include the case you mentioned here?
Más respuestas (0)
Ver también
Categorías
Más información sobre Matrix Indexing en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!