across

across() is a helper function that is typically used inside @mutate() or @summarize to operate on multiple columns and/or multiple functions. Notice that across() accepts two arguments, a set of variables and a set of functions. If providing multiple variables or functions, these should be provided as a tuple – in other words, wrapped in parentheses and separated by commas. If you want to skip missing values, you can "fuse" the summary function (such as mean()) with the skipmissing() function by using the fuction fusion operator, which you can type out in Julia by typing \circ and then pressing [Tab] such that it reads mean∘skipmissing.

using TidierData
using RDatasets

movies = dataset("ggplot2", "movies");

One variable, one function

@chain movies begin
  @mutate(Budget = Budget / 1_000_000)
  @summarize(across(Budget, mean∘skipmissing))
end

1×1 DataFrame

Row	Budget_mean_skipmissing
	Float64
1	13.4125

One variable, one anonymous function

@chain movies begin
  @mutate(Budget = Budget / 1_000_000)
  @summarize(across(Budget, (x -> mean(skipmissing(x)))))
end

1×1 DataFrame

Row	Budget_function
	Float64
1	13.4125

Note: compound functions are not correctly supported inside of anonymous functions. As of right now, the above function works, but (x -> mean∘skipmissing(x)) does not work. This is a known bug and will be fixed in a future update.

Multiple variables, multiple functions

@chain movies begin
    @mutate(Budget = Budget / 1_000_000)
    @summarize(across((Rating, Budget), (mean∘skipmissing, median∘skipmissing)))
end

1×4 DataFrame

Row	Rating_mean_skipmissing	Budget_mean_skipmissing	Rating_median_skipmissing	Budget_median_skipmissing
	Float64	Float64	Float64	Float64
1	5.93285	13.4125	6.1	3.0

Multiple selection helpers, multiple functions

@chain movies begin
  @mutate(Budget = Budget / 1_000_000)
  @summarize(across((starts_with("Bud"), ends_with("ting")), (mean∘skipmissing, median∘skipmissing)))
end

1×4 DataFrame

Row	Budget_mean_skipmissing	Rating_mean_skipmissing	Budget_median_skipmissing	Rating_median_skipmissing
	Float64	Float64	Float64	Float64
1	13.4125	5.93285	3.0	6.1

---

This page was generated using Literate.jl.