5.5 Row Sorting

DataFramesMeta.jl has a macro for sorting rows: @orderby. @orderby does not have an in-place or vectorized variant.

Let’s sort our leftjoined by grade in 2021:

@orderby leftjoined :grade_2021

By default, @orderby will sort in ascending order. But you can change this to decreasing order with the minus sign - in front of the column:

@orderby leftjoined -:grade_2021

Like all the other DataFramesMeta.jl macros, @orderby also supports multiple operations inside a begin ... end statement:

@orderby leftjoined begin
    :grade_2021
    :name
end

Here, we are sorting first by grade in 2020 then by name. Both in ascending order.

Support this project
CC BY-NC-SA 4.0 Jose Storopoli, Rik Huijzer, Lazaro Alonso