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	382	December 13, 2022
How to convert a column of a dataframe to an array of Float64 General Usage question	3	1318	June 3, 2018
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	599	January 29, 2021
Broadcasting nothing to DataFrame entries raises MethodError New to Julia	5	299	August 15, 2021
Insert missing/nan elements in BitMatrix General Usage	2	393	April 28, 2021