Teradata Package for Python Function Reference | 20.00 - distinct - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.

Teradata® Package for Python Function Reference - 20.00

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-10
dita:id
TeradataPython_FxRef_Enterprise_2000
Product Category
Teradata Vantage
teradataml.dataframe.sql.DataFrameColumn.distinct = distinct(self)
DESCRIPTION:
    Generates a new _SQLColumnExpression which removes the duplicate
    rows while processing the function.
    Note:
        This function is supported only in Projection. It is neither
        supported in sorting the records nor supported in filtering
        the records.
 
RAISES:
    None
 
RETURNS:
    ColumnExpression
 
EXAMPLES:
    >>> from teradataml import *
    >>> load_example_data("dataframe","sales")
    >>> df = DataFrame.from_table('sales')
    >>> df
                  Feb    Jan    Mar    Apr    datetime
    accounts
    Blue Inc     90.0   50.0   95.0  101.0  04/01/2017
    Alpha Co    210.0  200.0  215.0  250.0  04/01/2017
    Jones LLC   200.0  150.0  140.0  180.0  04/01/2017
    Yellow Inc   90.0    NaN    NaN    NaN  04/01/2017
    Orange Inc  210.0    NaN    NaN  250.0  04/01/2017
    Red Inc     200.0  150.0  140.0    NaN  04/01/2017
    >>>
    >>> df.assign(drop_columns=True, distinct_feb=df.Feb.distinct())
       distinct_feb
    0         210.0
    1          90.0
    2         200.0
    >>>