Replace 32767 with NaN in entire table

Question

Marcel345614 2022-1-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1636845-replace-32767-with-nan-in-entire-table

评论： Marcel345614 2022-1-27

采纳的回答： ANKUR KUMAR

在 MATLAB Online 中打开

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
Data(Data==32767)=NaN;
%Method 2
for j=1:size(Data,2)
    Data(Data(:,j)==32676,j)=NaN;
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

ANKUR KUMAR 2022-1-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1636845-replace-32767-with-nan-in-entire-table#answer_882405

编辑：ANKUR KUMAR 2022-1-26

在 MATLAB Online 中打开

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.

load outdoors
tt=outdoors(1:5,:);
mat = tt.Variables;
mat(mat==48.9) = nan;
tt.Variables = mat
tt = 5×3 timetable
           Time            Humidity    TemperatureF    PressureHg
    ___________________    ________    ____________    __________

    2015-11-15 00:00:24        49          51.3          29.61   
    2015-11-15 01:30:24       NaN          51.5          29.61   
    2015-11-15 03:00:24       NaN          51.5          29.61   
    2015-11-15 04:30:24      48.8          51.5          29.61   
    2015-11-15 06:00:24      48.7          51.5           29.6   