Hi, given this DataFrame : A=DataFrame(a=[1:2;missing;4], b=1:4) 4×2 DataFrames.DataFrame │ Row │ a │ b │ ├─────┼─────────┼───┤ │ 1 │ 1 │ 1 │ │ 2 │ 2 │ 2 │ │ 3 │ missing │ 3 │ │ 4 │ 4 │ 4 │ eltypes(A) 2-element Array{Type,1}: Union{Int64, Missings.Missing} Int64 h…

Oh and then if you want the column types to not allow for missing values, you will need to call disallowmissing! on the result as well. So: julia> A = DataFrame(a = [1:2;missing;4], b = 1:4) 4×2 DataFrames.DataFrame │ Row │ a │ b │ ├─────┼─────────┼───┤ │ 1 │ 1 │ 1 │ │ 2 │ 2 │…

How to remove rows containing missing from DataFrame?

New to Julia

Alec_Loudenback July 22, 2019, 10:07pm 7

Found the answer in the docs. In this case, it would be:

dropmissing(df, :a)

6 Likes

Topic		Replies	Views
How do I drop only rows that are fully filled with missing values? General Usage question , package , dataframes	3	183	January 24, 2023
Problems about dealing with missing values, maybe connected to DataFrames.jl Data question	4	759	December 4, 2018
How to filter out missings (using DataFramesMeta @where) New to Julia dataframes	2	691	July 22, 2019
Filter a number when missing values are in column New to Julia dataframes , missing-values	23	2598	February 11, 2022
Find DataFrame row with missing values present General Usage dataframes	8	689	January 9, 2023

How to remove rows containing missing from DataFrame?

Related topics