Let’s say that I have a dataframe like df = DataFrame(a=[ 1, 4, missing], b= [1, 4, 5], c=[1., 2, 3]) 3×3 DataFrame Row │ a b c │ Int64? Int64 Float64 ─────┼───────────────────────── 1 │ 1 1 1.0 2 │ 4 4 2.0 3 │ missing 5 3.0 a…

Trapped in a int -> missing -> float loop

rafael.guerra December 12, 2022, 11:34pm 7

Try
coalesce.(df, NaN)

4 Likes

Topic		Replies	Views
Debugging a script to replace NaN or -999 values with missing values General Usage question	6	389	October 22, 2021
Replace missing with 0.0 in dataframe General Usage question	10	4973	December 9, 2019
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	303	August 15, 2021
Iterate over all numeric columns in DataFrames Data	21	4942	February 11, 2018