Let’s say I have a data frame with columns A1,A2,A3,…,An, where A1,A2,A3 are categorical variables and the rest are floats. I want to create a new data frame (or equivalent) with the following features: there is one row for each possible combination of variables A1, A2, A3 The columns are A4,…,An T…

Collapsing data into the level of certain variables and taking averages

pdeffebach March 6, 2021, 5:28am 2

combine(groupby(df, [:A1, :A2, :A3]), names(df, Between(:A4, :A10)) .=> mean)

3 Likes

Topic		Replies	Views
Split-Apply-Combine on many columns at once? Looking for equivalent to Stata's collapse New to Julia question , dataframes	7	2009	November 9, 2021
Data Cleaning: Split, Combine, Apply? New to Julia dataframes	9	778	October 28, 2021
How to group by multiple data types? General Usage dataframes	4	379	February 22, 2022
Dataframes: Split combined result to different columns General Usage dataframes	3	304	December 13, 2021
Grouping by values in either of two columns Data question	13	775	April 14, 2024