Groupby generic table-shaped things

General Usage
,
1

I know of Query.jl but frankly I hate both its syntaxes [1, 2]. (And also weirdly doesn’t depend on Tables.jl?)

In the Tables.jl universe, I know of TableOperations.jl and TableTransforms.jl but weirdly neither of them supports groupby? And why are there two of them?

DataFrames.jl has the best syntax by far in my opinion. It’s as simple as I can imagine a groupby being, for example

gdf = groupby(df, :key)
fdf = combine(gdf, :colname => sum => :colname_sum)

but it’s not generic, it’s specific to DataFrames.jl

So how do I manipulate table-shaped things in a generic manner? My requirements are light: is just needs to be generic and support a groupby.

[1] Standalone Query Commands · Query.jl
[2] LINQ Style Query Commands · Query.jl

2 Likes