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
Creating new dataframe column! General Usage question , dataframes	3	328	April 21, 2021
How to average column values in a dataframe based on multiple other matching columns? General Usage question	2	1193	February 22, 2023
How to take the mean of entries across an array of DataFrames conditional upon the value of a separate column? General Usage statistics , dataframes	5	1387	May 11, 2022
Easier way to split-apply-combine in DataFrames.jl General Usage dataframes	5	1143	December 14, 2020
Combining a col from each DF group into a single DF New to Julia question , dataframes	5	329	August 25, 2022