Table Find/Replace based on condition (greater than)

9 visualizaciones (últimos 30 días)
Dave
Dave el 23 de Nov. de 2019
Editada: Image Analyst el 8 de Jul. de 2021
Morning, In a table, how can I find values greater than 1 and replace them with NaN?
I know about the ismissing family but it does not allow (I think) for a condition (greater than), only for specific number/text.
T = table([0.1;0.2],[7;0.5],'VariableNames',{'varx1','varx2'})
The entry "7" should be NaN

Respuesta aceptada

Image Analyst
Image Analyst el 23 de Nov. de 2019
Try this:
T = table([0.1;0.2],[7;0.5],'VariableNames',{'varx1','varx2'})
rowsToChange = T.varx1 > 1
if ~isempty(rowsToChange)
T.varx1(rowsToChange) = nan
end
rowsToChange = T.varx2 > 1
if ~isempty(rowsToChange)
T.varx2(rowsToChange) = nan
end
  3 comentarios
Image Analyst
Image Analyst el 23 de Nov. de 2019
Editada: Image Analyst el 8 de Jul. de 2021
What are "w conditionals"?
It is vectorized by column.
The reason I did it by columns is that some columns (not in this case though) might not be numeric, in general. So you can't just convert the whole table to a numerical array, then do the whole matrix vectorized at once, then convert back to a table, unless you know what column numbers are numeric.
Giuseppe Degan Di Dieco
Giuseppe Degan Di Dieco el 7 de Jul. de 2021
Dear Image Analyst,
thanks for your tip, easy and straight.
Best.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Tables 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!

Translated by