How to replace -999 values with NaN in a Matlab table?
36 ビュー (過去 30 日間)
古いコメントを表示
I have a Matlab table T1, with columns like the below:
T1.year
T1.month
T1.day
T1.var1
T1.var2
...
Some of its columns are numerical and some of them are strings. For the numerical columns, there could be some -999 values in some of the columns to indicate NaN values.
Is it possible to replace all of the -999 values with NaN values, without specifying each of the columns?
I wish I could do someting as simple as that?
T1(T1==-999) = NaN
Like I do in a column data.
2 件のコメント
Walter Roberson
2020 年 10 月 13 日
Are you reading from a text file? If so then use 'TreatAsMissing', '-999' option when you do the readtable()
採用された回答
Steven Lord
2020 年 10 月 13 日
Use standardizeMissing.
t = array2table(magic(4));
t{2, 'Var3'} = -999
t2 = standardizeMissing(t, -999)
その他の回答 (1 件)
Walter Roberson
2020 年 10 月 13 日
T1 = convertvars(T1, @isnumeric, @no999);
function x = no999(x)
x(x==-999) = nan;
end
参考
カテゴリ
Help Center および File Exchange で String Parsing についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!