|
Calling Sequence
|
|
sort( DF, index )
sort( DF, index, ordering, options )
|
|
Parameters
|
|
DF
|
-
|
a DataFrame object
|
index
|
-
|
name, string or integer value; specifies the column index for the chosen column
|
ordering
|
-
|
symbol or Boolean function of two arguments; sort ordering
|
options
|
-
|
(optional) equation(s) of the form option=value
|
|
|
|
|
Options
|
|
•
|
nonstrict: specifies to use a nonstrict comparison function type
|
•
|
strict: specifies to use a strict comparison function type
|
•
|
key: specifies to use a key comparison function type
|
•
|
output: sorted or permutation; specify whether to return the sorted DataFrame or the permutation of rows that sorts the DataFrame accordingly
|
|
|
Description
|
|
•
|
The sort command sorts the rows of a DataFrame according to the sorted values in a given column.
|
•
|
The index argument selects which column is used to sort the rows. As a special case, you can supply the value 0 to select sorting by the row labels.
|
•
|
If the ordering option is given, it specifies the ordering for sorting elements. By default, elements are sorted in ascending order for numeric values and lexicographic order for strings and names.
|
–
|
`<`: If ordering is the symbol `<` or numeric, then the DataFrame is sorted in ascending numerical order of values in a given column. The index column of the DataFrame must contain elements of type({numeric, real_infinity}),
|
–
|
`>`: If ordering is the symbol `>`, then the DataFrame is sorted into descending numerical order.
|
–
|
address: If ordering is the symbol address, then the elements are sorted by address (a non-deterministic run-time specific property of the underlying data structure).
|
–
|
length: If ordering is the symbol length, then the elements are sorted by length where length is as determined by the length function.
|
–
|
lexorder: If ordering is the symbol lexorder or string, then lists of strings or symbols are sorted into lexicographic order.
|
–
|
Otherwise, ordering must be a Boolean-valued function, F, of two arguments. Specifically, returns if and only if must precede in the sorted output. That is is a non-strict less than comparison function. In addition, must be defined for all pairs for and in the input structure and must be transitive, that is, if and then .
|
•
|
By specifying comptype=Function, different styles of comparison functions can be given to sort. The supported values for comptype are:
|
–
|
nonstrict: the comparison Function is a non-strict less than function, as described above.
|
–
|
strict: the comparison Function is a strict less than function. That is returns if and only if must precede in the sorted output. Function must still be defined for all pairs of inputs and be transitive, as described above. This argument is necessary if you want to specify a less than or equal to comparison function and want stable sorting. Specifying a strict less than function without using the strict option will result in an non-stable, sorted output.
|
–
|
key: the Function maps each element in the DataFrame to a key value. The DataFrame is sorted by sorting the corresponding keys. Using a key function is preferable to a comparison function because the key function is called times, whereas a comparison function will be called times. This is generally faster. In addition, sorting the keys may be done in parallel, whereas this may not be possible with a comparison function.
|
•
|
If an argument output = sorted is supplied, sort returns the sorted argument. This is the default behavior.
|
|
If an argument output = permutation is supplied, then sort does not return the sorted argument, but the permutation that would be applied to the argument in order to sort it. The permutation is given as a list of integers: the ith entry of the permutation is the integer j such that the jth entry of DataFrame would occur at the ith position in the sorted argument. This means that if then could be obtained as .
|
|
In order to obtain both the sorted argument and the permutation, one can supply the argument output = [sorted, permutation]. This will return a sequence of two elements, the first being the sorted argument, the second the permutation.
|
|
|
Examples
|
|
Consider some data on berries.
>
|
|
>
|
|
>
|
|
>
|
|
>
|
|
| (1) |
It is possible to sort by any column. Here the DataFrame is sorted in order of ascending energy level:
>
|
|
| (2) |
In order of descending carbohydrate level:
>
|
|
| (3) |
It is also possible to sort columns with string and named values:
>
|
|
| (4) |
>
|
|
| (5) |
The output option controls the returned output for the sort command. Using permutation returns the list of numeric indices that sort the original DataFrame.
>
|
|
| (6) |
| (7) |
In order to obtain the data frame sorted by the row labels, you can use 0 as the index argument.
| (8) |
Several other sort options are also supported by the DataFrame sort command:
>
|
|
| (9) |
>
|
|
| (10) |
|
|
Compatibility
|
|
•
|
The DataFrame/sort command was introduced in Maple 2017.
|
•
|
The DataFrame/sort command was updated in Maple 2023.
|
•
|
The index parameter was updated in Maple 2023.
|
|
|
|