How to replace -999 values with NaN in a Matlab table?

30 次查看（过去 30 天）
Leon
Leon 2020-10-13
评论： Leon 2020-10-13
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
Walter Roberson 2020-10-13
Are you reading from a text file? If so then use 'TreatAsMissing', '-999' option when you do the readtable()
Leon
Leon 2020-10-13
Thanks for sharing that useful tip!
Unfortunately, I'm not reading from a text file. It is a carry-over Matlab table value.

请先登录，再进行评论。

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

采纳的回答

Steven Lord
Steven Lord 2020-10-13
Use standardizeMissing.
t = array2table(magic(4));
t{2, 'Var3'} = -999
t2 = standardizeMissing(t, -999)

更多回答（1 个）

Walter Roberson
Walter Roberson 2020-10-13
T1 = convertvars(T1, @isnumeric, @no999);
function x = no999(x)
x(x==-999) = nan;
end
https://www.mathworks.com/help/matlab/ref/convertvars.html

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by