how to remove a row that contains inf from a table

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?

Answer 1

[Adam Danz]

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.

[alpedhuez]

Thank you!