Hi everybody, I am looking for a way to aggregate my data like Query.jl. Usually, I would run something like: test_df = DataFrame(A = [1,1,2,2], B = [missing, 1, missing, 2]) df_agg = test_df |> @groupby(_.A) |> @map({key = key(_), B = first(_.B), B_last = last…

Alternatives to Query.jl for aggregation

tbeason August 8, 2022, 6:32pm 2

regular DataFrames.jl will work

combine(groupby(test_df,"A"), "B" .=> [first,last,mean ∘ skipmissing])

2 Likes

Topic		Replies	Views
Query.jl: Group dataframe along two variables General Usage	4	673	May 2, 2020
DataFrames, aggregate with missings Data dataframes	2	573	May 4, 2020
How can I skip missing values of a DF without deleating them? New to Julia dataframes	4	740	November 11, 2021
[Query.jl] Way to map many variables to a single function Data query	0	459	March 7, 2021
Help with a little query Data	8	1913	July 10, 2017