Replace -99 with NaN

5 views (last 30 days)
Megan Mirkhanian
Megan Mirkhanian on 20 Jan 2020
Commented: Stephen23 on 27 Feb 2022
How do I repalce -99 values with NaN?

Answers (3)

Stijn Haenen
Stijn Haenen on 20 Jan 2020
x=[1 2 -99 3 4 -99 5 6 -99];
x(x==-99)=NaN;

Steven Lord
Steven Lord on 21 Jan 2020
Consider using the standardizeMissing function. The first example on that documentation page does exactly what you described.

VBBV
VBBV on 27 Feb 2022
Edited: VBBV on 27 Feb 2022
Data = load('precip.txt'); % use load function
Data(Data == -99) = NaN
Use load function instead of readtable and try with commented line, in your snapshot code
  1 Comment
Stephen23
Stephen23 on 27 Feb 2022
Use READMATRIX instead of LOAD.
That fact that LOAD imports a limited set of text files is really for compatilbilty with ancient MATLAB versions.

Sign in to comment.

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!