how to remove a row that contains inf from a table
40 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
alpedhuez
el 8 de Jul. de 2020
Comentada: alpedhuez
el 8 de Jul. de 2020
https://www.mathworks.com/help/matlab/ref/rmmissing.html does not remove inf (I think they should put options to include inf).
https://www.mathworks.com/matlabcentral/answers/369480-delete-row-in-matrix-if-the-row-contain-inf-value does not work for tables.
Then what should one do?
0 comentarios
Respuesta aceptada
Adam Danz
el 8 de Jul. de 2020
inf values are definitly not missing-value indicators. They are no different than the value 7 or pi.
The solution in the 2nd link you provided is designed for matrices. It needs to be adapted to tables.
If your table only contains numeric scalars, you could convert the table to an array (matrix), apply that solution, and then convert back to a table.
If you want to apply that solution to specific columns of a table that contain numeric scalars, you can do so using
T.col(isinf(T.col)) = NaN;
where T is your table and col is the column name.
Note that you cannot remove numeric values from the table unless you remove the entire row. You can, however, replace their values with NaN or some other value.
If you run into any problems, show us what you've done, describe the variables, and the problem.
Más respuestas (0)
Ver también
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!