reorder
Returns DataFrame with a new order of selected columns.
reorder { columns }
[.cast<ColumnType>() ]
.by { columnExpression } | .byDesc { columnExpression } | .byName(desc = false)
columnExpression: DataColumn.(DataColumn) -> ValueRelated operations: Move / rename / reorder columns
See column selectors for how to select the columns for this operation.
df.reorder { age..isHappy }.byName()df.reorder { "age".."isHappy" }.byName()
}When a subset of columns is selected they will be reordered among their original positions. Positions of other columns will not change.
If selected columns belong to different column groups they will be reordered within their groups, so column grouping will be preserved.
val df = dataFrameOf("c", "d", "a", "b")(
3, 4, 1, 2,
1, 1, 1, 1,
)
df.reorder("d", "b").cast<Int>().by { sum() } // [c, b, a, d]When exactly one ColumnGroup is selected, reordering is applied to its nested columns.
df.reorder { name }.byName(desc = true) // [name.lastName, name.firstName]Reorders all columns
reorderColumnsBy(atAnyDepth = true, desc = false) { columnExpression }Parameters:
atAnyDepth— reorder columns insideColumnGroupsandFrameColumnrecursivelydesc— apply descending order
reorderColumnsByName(atAnyDepth = true, desc = false)Parameters:
atAnyDepth— reorder columns insideColumnGroupsandFrameColumnrecursivelydesc— apply descending order