Assigning a value to 0's
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hey
I have a ColumnA(108x1), this column has values when B(say) is ON. But non-zeros are present for only 104rows, 4rows are still zeros(the lousy data).
What I am trying to do is replace these 0's to a large value or NaN so that it doesn't affect my code later down. However, now Column A exists for Test 1, when B is ON. Also, I get a new ColumnA for Test 2 when B is OFF, where all rows are 0.
I was thinking of doing a cursory check for 0's at the beginning 5-10 rows and create a NewColumnA if the conditioned is satisfied. But wasn't sure how to complete it.
So, something like an "iszero" function for rows 1 to 10 should do it for a NewColumnA. Would "find", to find the number of 0's, do it?
2 comentarios
Image Analyst
el 4 de Abr. de 2012
So A is nonzero for B = ON or B = OFF, and A = 0 for B = lousy data. What are the ranges of B for the 3 cases: (1) ON, (2) OFF, and (3) lousy data?
Respuesta aceptada
Honglei Chen
el 4 de Abr. de 2012
Since ColumnA is a column, you can do
ColumnA(ColumnA==0) = nan
3 comentarios
Honglei Chen
el 4 de Abr. de 2012
Will the following work?
if ~all(ColumnA==0)
ColumnA(ColumnA==0) = nan;
end
Más respuestas (0)
Ver también
Categorías
Más información sobre Testing Frameworks 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!