Column.sort
sortordermissing_lastby
Group: Selections
Aliases: order_by
Documentation
Sorts the column according to the specified rules.
Arguments
order
: specifies the default sort order for this operation.missing_last
: specifies the default placement of missing values when compared to non-missing ones. Note that this argument is independent fromorder
, i.e. missing values will always be sorted according to this rule, ignoring the ascending / descending setting.by
: function taking two items in this column and returning an ordering. If specified, it is used instead of the natural ordering of the values.
Examples
Sorting a column in ascending order.
import Standard.Examples
example_sort = Examples.integer_column.sort
Sorting a column in descending order, placing missing values at the
top of the resulting column.
import Standard.Examples
example_sort =
Examples.integer_column.sort Sort_Direction.Descending missing_last=False
Sorting column
in ascending order, using a custom comparison
function.
import Standard.Examples
example_sort =
my_compare a b = Ordering.compare a.abs b.abs
Examples.decimal_column.sort by=my_compare