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

MATLABtable

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.

Best Answer

Use standardizeMissing.

t = array2table(magic(4));
t{2, 'Var3'} = -999
t2 = standardizeMissing(t, -999)

Related Solutions

MATLAB: Replacing elements in a table

A=table2array(A);
A(isinf(A)|-isinf(A))=nan;
A=array2table(A)

MATLAB: Find values in a table with multiple data types and set them to NA or NaN

I think standardizeMissing is the way to go here. It's "straight-forward" to do it explicitly

>> t = table(["a";"b";"c"],[1;999;3],[999;5;999])
t =
  3×3 table
    Var1    Var2    Var3
    ____    ____    ____
    "a"       1     999 
    "b"     999       5 
    "c"       3     999 
>> idx = t{:,2:3} == 999
idx =
  3×2 logical array
   0   1
   1   0
   0   1
>> t{:,2:3}(idx) = NaN
t =
  3×3 table
    Var1    Var2    Var3
    ____    ____    ____
    "a"       1     NaN 
    "b"     NaN       5 
    "c"       3     NaN

but it takes a little thought to get your head around all of what's going on there. Which is why standardizeMissing exists.

>> t = table(["a";"b";"c"],[1;999;3],[999;5;999]);
>> standardizeMissing(t,999)
ans =
  3×3 table
    Var1    Var2    Var3
    ____    ____    ____
    "a"       1     NaN 
    "b"     NaN       5 
    "c"       3     NaN

Best Answer

Related Solutions

MATLAB: Replacing elements in a table

MATLAB: Find values in a table with multiple data types and set them to NA or NaN

Related Question