I’m looking for a Julian way of selecting a subset of each group. I have a DataFrame with (among others) two columns, say name and length. I want to group over all names and pick the 5 tallest people within each name. I tried this, but it does not return the correct result: df = ... sort!(df, [:len…

using just DataFrames and Pipe you have using DataFrames, Pipe @pipe df |> groupby(_, :name) |> combine(_) do sdf sorted = sort(df, :length) first(sorted, 5) end

How to select top 5 results per group in dataframe?

New to Julia

conditionality September 23, 2020, 7:42pm 3

Thanks! It feels like the Julian way of doing things is to know which library to use

Do you mean to use “df” or “sdf” on line 5?

Topic		Replies	Views
Applying group selection conditions using groupeddataframes New to Julia dataframes	21	2161	September 20, 2020
How to get the first row of each group of a DataFrame? New to Julia	7	4347	December 20, 2022
Column selection in DataFrames comb New to Julia	3	458	April 20, 2021
Dataframes: Split combined result to different columns General Usage dataframes	3	298	December 13, 2021
DataFrame Groupby New to Julia dataframes	2	2139	April 26, 2018

How to select top 5 results per group in dataframe?

Related topics