asc | Teradata Package for Python - asc - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Use the asc() function to generate a new ColumnExpression which sorts the actual expression in ascending 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")
>>> df = DataFrame.from_table('sales')
>>> df.csum(sort_columns=[df.accounts, df.Feb.asc()], drop_columns=True)
   csum_Feb  csum_Jan  csum_Mar  csum_Apr
0     380.0     200.0     235.0     281.0
1     790.0     350.0     375.0     531.0
2    1000.0     550.0     590.0     781.0
3     580.0     350.0     375.0     281.0
4     180.0      50.0      95.0     101.0
5      90.0       NaN       NaN       NaN