desc | Teradata Package for Python - desc - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Published
November 2021
Language
English (United States)
Last Update
2022-01-14
dita:mapPath
bol1585763678431.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4006
lifecycle
previous
Product Category
Teradata Vantage

The desc() function generates a new ColumnExpression which sorts the actual expression in descending order.

  • This function is supported only while sorting data.
  • This function is neither supported in projection nor supported in filtering data.

Example

>>> from teradataml import load_example_data
>>> load_example_data("dataframe","sales")
# Create teradataml dataframe.
>>> df = DataFrame.from_table('sales')
>>> df.csum(sort_columns=[df.accounts, df.Feb.desc()], drop_columns=True)
   csum_Feb  csum_Jan  csum_Mar  csum_Apr
0     500.0       400       450       531
1     910.0       550       590       781
2    1000.0       550       590       781
3     710.0       400       450       781
4     300.0       250       310       351
5     210.0       200       215       250