How to replace -999 values with NaN in a Matlab table?
34 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Walter Roberson
am 13 Okt. 2020
Are you reading from a text file? If so then use 'TreatAsMissing', '-999' option when you do the readtable()
Akzeptierte Antwort
Steven Lord
am 13 Okt. 2020
Use standardizeMissing.
t = array2table(magic(4));
t{2, 'Var3'} = -999
t2 = standardizeMissing(t, -999)
Weitere Antworten (1)
Walter Roberson
am 13 Okt. 2020
T1 = convertvars(T1, @isnumeric, @no999);
function x = no999(x)
x(x==-999) = nan;
end
Siehe auch
Kategorien
Mehr zu String Parsing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!