Replace 32767 with NaN in entire table

6 ビュー (過去 30 日間)
Marcel345614
Marcel345614 2022 年 1 月 26 日
コメント済み: Marcel345614 2022 年 1 月 27 日
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

採用された回答

ANKUR KUMAR
ANKUR KUMAR 2022 年 1 月 26 日
編集済み: ANKUR KUMAR 2022 年 1 月 26 日
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
  3 件のコメント
Marcel345614
Marcel345614 2022 年 1 月 27 日
Thanks a lot! Now this was helpful ;-)

サインインしてコメントする。

その他の回答 (0 件)

タグ

製品


リリース

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by