datascience.tables.Table.sort¶
-
Table.
sort
(column_or_label, descending=False, distinct=False)[source]¶ Return a Table of rows sorted according to the values in a column.
- Args:
column_or_label
: the column whose values are used for sorting.descending
: if True, sorting will be in descending, rather than ascending order.distinct
: if True, repeated values incolumn_or_label
will be omitted.- Returns:
- An instance of
Table
containing rows sorted based on the values incolumn_or_label
.
>>> marbles = Table().with_columns([ ... "Color", ["Red", "Green", "Blue", "Red", "Green", "Green"], ... "Shape", ["Round", "Rectangular", "Rectangular", "Round", "Rectangular", "Round"], ... "Amount", [4, 6, 12, 7, 9, 2], ... "Price", [1.30, 1.30, 2.00, 1.75, 1.40, 1.00]]) >>> marbles Color | Shape | Amount | Price Red | Round | 4 | 1.3 Green | Rectangular | 6 | 1.3 Blue | Rectangular | 12 | 2 Red | Round | 7 | 1.75 Green | Rectangular | 9 | 1.4 Green | Round | 2 | 1 >>> marbles.sort("Amount") Color | Shape | Amount | Price Green | Round | 2 | 1 Red | Round | 4 | 1.3 Green | Rectangular | 6 | 1.3 Red | Round | 7 | 1.75 Green | Rectangular | 9 | 1.4 Blue | Rectangular | 12 | 2 >>> marbles.sort("Amount", descending = True) Color | Shape | Amount | Price Blue | Rectangular | 12 | 2 Green | Rectangular | 9 | 1.4 Red | Round | 7 | 1.75 Green | Rectangular | 6 | 1.3 Red | Round | 4 | 1.3 Green | Round | 2 | 1 >>> marbles.sort(3) # the Price column Color | Shape | Amount | Price Green | Round | 2 | 1 Red | Round | 4 | 1.3 Green | Rectangular | 6 | 1.3 Green | Rectangular | 9 | 1.4 Red | Round | 7 | 1.75 Blue | Rectangular | 12 | 2 >>> marbles.sort(3, distinct = True) Color | Shape | Amount | Price Green | Round | 2 | 1 Red | Round | 4 | 1.3 Green | Rectangular | 9 | 1.4 Red | Round | 7 | 1.75 Blue | Rectangular | 12 | 2