Replace 32767 with NaN in entire table
14 views (last 30 days)
I have a timetable with some strange values(32767 (probably Inf)) in all columns of my table.
How can I replace all these with NaN's ?
I tried the following, but it didn't work:
% Method 1
ANKUR KUMAR on 26 Jan 2022
Edited: ANKUR KUMAR on 26 Jan 2022
You can get the table in a matrix form using .Variables. Once you have a matrix, then you can use boolean to replace any numbers with nan. Here is an example of replacing 48.9 with nan.
mat = tt.Variables;
mat(mat==48.9) = nan;
tt.Variables = mat