Skip to main content

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 from order, 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