Deleting runs of zeros
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Lauren
el 14 de Mayo de 2015
Comentada: Lauren
el 14 de Mayo de 2015
Hello! I have a dataset that occasionally has runs of zeros. I would like to delete those runs from my data. How do I state that for any run of 3 or more zeros in my data, I would like Matlab to completely delete those observations from my dataset.
So for example, I have a dataset that looks like
[1 5;2 7;3 0;4 0;5 0;6 3]
I would like the that run of zeros deleted so that my new dataset looks like...
[1 5;2 7;6 3]
Any help is greatly appreciated!!
0 comentarios
Respuesta aceptada
Guillaume
el 14 de Mayo de 2015
one possible way, use strfind (which works with numbers despite the name). Using a more complex example (to show that it works regardless of the numbers of 0 in the run):
data = [1 5; 2 0; 3 0; 4 2; 5 3; 6 0; 7 0; 8 0; 9 0; 10 1; 11 0; 12 0; 13 0]
startseq = strfind(data(:, 2)', [0 0 0]);
toremove = unique([startseq, startseq+1, startseq+2]);
data(toremove, :) = []
Más respuestas (2)
Joseph Cheng
el 14 de Mayo de 2015
you would find the indexes that equal zero then if the number is greater or equal to three then delete them from original like in the example below;
x = [1 5;2 7;3 0;4 0;5 0;6 3]
[r c v]=find(x==0);
if numel(r)>=3
x(r,:)=[];
end
2 comentarios
Stephen23
el 14 de Mayo de 2015
@ Joseph Cheng: do not put empty lines in your code, and then this page will format the entire code in one box.
Also while this certainly detects zeros, it does not detect runs of zeros, which by definition must be consecutive. This code does not resolve this issue.
Joseph Cheng
el 14 de Mayo de 2015
?when did the page layout change? oh and yes i didn't see the comment on runs of zeros. However quick modification of taking the diff of r (diff(r)) and looking for values of 1, one can determine runs of zeros.
Ver también
Categorías
Más información sobre Predictive Maintenance Toolbox 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!