ArgSort / Computation Layer

Return indices that would sort the column. Similar to numpy.argsort() or R's order(). Creates a ranking index that can be used for indirect sorting.

Mathematical concept: For input array X, returns index array I where: $X [I_{0}] \leq X [I_{1}] \leq ... \leq X [I_{n - 1}]$

Common applications:

Creating sorted indices for multiple columns
Rank-based statistics
Tournament rankings
Portfolio sorting
Customer segmentation
Performance rankings
Data reordering

Note: Null values are placed at the end in ascending order, start in descending order.

Table

Select

column

The column to generate sort indices for. Common uses:

Numeric scores (test results, ratings)
Timestamps (event ordering)
Measurements (size ordering)
Text (alphabetical sorting)

Any sortable data type supported.

Reverse

bool

false

Sort order direction. Effects:

false (default): Ascending order (smallest to largest)
true: Descending order (largest to smallest)

Choose based on whether higher or lower values should come first.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.