MATLAB Answers

how to remove a row that contains inf from a table

11 views (last 30 days)
alpedhuez
alpedhuez on 8 Jul 2020
Commented: alpedhuez on 8 Jul 2020
https://www.mathworks.com/help/matlab/ref/rmmissing.html does not remove inf (I think they should put options to include inf).
Then what should one do?

  0 Comments

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 8 Jul 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.

More Answers (0)

Tags