Teradata Package for Python Function Reference | 17.10 - sort - Teradata Package for Python
Teradata® Package for Python Function Reference
- Product
- Teradata Package for Python
- Release Number
- 17.10
- Published
- April 2022
- Language
- English (United States)
- Last Update
- 2022-08-19
- Product Category
- Teradata Vantage
- teradataml.geospatial.geodataframe.GeoDataFrame.sort = sort(self, columns, ascending=True)
- DESCRIPTION:
Get sorted data by one or more columns in either ascending or descending order
for a GeoDataFrame.
Unsupported column types for sorting: ['BLOB', 'CLOB', 'ARRAY', 'VARRAY']
PARAMETERS:
columns:
Required Argument.
Column names as a string or a list of strings to sort on.
Types: str OR list of Strings (str)
ascending:
Optional Argument.
Order ASC or DESC to be applied for each column.
True for ascending order and False for descending order.
Default value: True
Types: bool
RETURNS:
teradataml GeoDataFrame
RAISES:
TeradataMlException
EXAMPLES:
>>> load_example_data("geodataframe","sample_streets")
>>> df = GeoDataFrame('sample_streets')
>>> df
street_name street_shape
skey
1 Coast Blvd LINESTRING (12 12,18 17)
1 Main Street LINESTRING (2 2,3 2,4 1)
>>> df.sort("street_shape")
street_name street_shape
skey
1 Main Street LINESTRING (2 2,3 2,4 1)
1 Coast Blvd LINESTRING (12 12,18 17)
>>>