After removing some rows from a dataframe, I would like to keep only groups (grouping on a variable) which have “complete” observations (households always have 2 members in this data in the dataset I start with, so for any fewer I can consider that household incomplete). The following MWE works, i…

Drop incomplete groups from a DataFrame

bkamins July 16, 2020, 8:48am 6

There is also filter that will be added in the next release (see https://github.com/JuliaData/DataFrames.jl/pull/2279).

3 Likes

Topic		Replies	Views
Applying group selection conditions using groupeddataframes New to Julia dataframes	21	2311	September 20, 2020
Group, Mutate, Ungroup Data question , dataframes	2	1793	February 4, 2018
DataFramesMeta custom filter: by groups of A, apply filter on B Data	4	1442	May 27, 2019
Dropmissing(!) is undefined for GroupedDataFrames Data dataframes	15	667	April 6, 2022
Is there a dropna() for DataFrame? Statistics question	23	10349	March 22, 2017