I’m trying to write a program to replace all NaN values or -999 values in my matrix B with missing values (write down nothing) before I use Dataframe to put them into CSV files). Below is my code: B = [-0 0 1; NaN 0.2 7; 0 NaN -999; NaN 15 NaN]; replace!(x -> (isnan.(x) || x .== -999) ? missing : …

You want to use B = Matrix{Union{Float64,Missing}}(B).

Debugging a script to replace NaN or -999 values with missing values

leon October 22, 2021, 2:15pm 7

Many thanks, All. This addressed my issue nicely.

1 Like

Topic		Replies	Views
Trapped in a int -> missing -> float loop General Usage	10	398	December 13, 2022
Broadcasting nothing to DataFrame entries raises MethodError New to Julia	5	311	August 15, 2021
I have a DataFrame with multiple columns of type Union{Missing, String}. What is the most concise manner of converting the non-missing values in Float? General Usage	2	605	January 29, 2021
Insert missing/nan elements in BitMatrix General Usage	2	403	April 28, 2021
Not able convert string to missing New to Julia	2	833	April 26, 2022