I apologize for a very low-level question but I’ve just started learning the language and getting stumped. I am trying to take a dataframe and create a new column that’s the average of two other columns. I understand that this is what the transform function is supposed to do, but I’m having a hard t…

A way to use transform is the following: transform(df, [:A, :B] => ((a, b) -> (a .+ b) ./ 2) => :Average) i.e., you need to provide original_columns => some_function => new_column. Note that the function takes the whole column vectors as arguments and usually requires explicit broadcasting. DataF…

How to use the transform function on data frames

General Usage

ginger_snaps October 4, 2023, 8:06pm 2

Why not just
df.Average = (df.A + df.B) / 2
?

3 Likes

Topic		Replies	Views
Transform operation using two or more columns in a DataFrame Data dataframes	6	433	February 28, 2022
Transform multiple columns of a DataFrame using the same function Data dataframes	12	4296	January 23, 2023
Dataframe transform operation on multiple columns General Usage dataframes	10	4264	August 8, 2020
Dataframes transform! General Usage dataframes	8	1462	July 11, 2022
Rewriting dplyr code which uses a function of columns in Julia -style using DataFrames.jl General Usage dataframes	5	635	March 25, 2021

How to use the transform function on data frames

Related topics