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
DataFrame group by first column, and sort by last column Data dataframes	4	1923	October 16, 2018
How would I sort user transactions by date, and only keep the N most recent entries General Usage question	8	950	February 6, 2020
DataFrame Groupby New to Julia dataframes	2	2160	April 26, 2018
How to get the first row of each group of a DataFrame? New to Julia	7	4488	December 20, 2022
DataFramesMeta custom filter: by groups of A, apply filter on B Data	4	1438	May 27, 2019

How to select top 5 results per group in dataframe?

Related topics