Teradata Package for Python Function Reference - 17.00 - lower - Teradata Package for Python

Teradata® Package for Python Function Reference

Product
Teradata Package for Python
Release Number
17.00
Release Date
April 2021
Content Type
Programming Reference
Publication ID
B700-4008-070K
Language
English (United States)
teradataml.dataframe.sql.DataFrameColumn.lower = lower(self)
This function maps character values to lowercase.
 
REFERENCE:
    SQL Functions, Operators, Expressions, and Predicates
    Chapter 26 String Operators and Functions
 
RETURNS:
    A str Series with values lowercased
 
EXAMPLES:
    >>> tdf = DataFrame('iris')
    >>> tdf
       SepalLength  SepalWidth  PetalLength  PetalWidth             Name
    0        5.500       2.400        3.800        1.10  Iris-versicolor
    1        4.900       2.400        3.300        1.00  Iris-versicolor
    2        7.700       2.600        6.900        2.30   Iris-virginica
    3        5.700       2.800        4.500        1.30  Iris-versicolor
    4        7.700       3.000        6.100        2.30   Iris-virginica
    5        6.300       2.500        4.900        1.50  Iris-versicolor
    6        5.700       3.000        4.200        1.20  Iris-versicolor
    7        6.900       3.200        5.700        2.30   Iris-virginica
    8        5.000       3.500        1.300        0.30      Iris-setosa
    9        1.012       1.202        3.232        4.23             None
 
    >>> tdf.assign(drop_columns = True, lower = tdf.Name.str.lower())
               lower
    0   iris-virginica
    1   iris-virginica
    2  iris-versicolor
    3  iris-versicolor
    4  iris-versicolor
    5   iris-virginica
    6   iris-virginica
    7  iris-versicolor
    8  iris-versicolor
    9      iris-setosa
 
    >>> tdf[tdf.Name.str.lower() == 'iris-virginica']
     SepalLength  SepalWidth  PetalLength  PetalWidth            Name
    0          6.9         3.1          5.4         2.1  Iris-virginica
    1          6.4         3.1          5.5         1.8  Iris-virginica
    2          5.8         2.8          5.1         2.4  Iris-virginica
    3          6.9         3.2          5.7         2.3  Iris-virginica
    4          7.7         3.0          6.1         2.3  Iris-virginica
    5          6.5         3.0          5.5         1.8  Iris-virginica
    6          6.3         2.8          5.1         1.5  Iris-virginica
    7          7.9         3.8          6.4         2.0  Iris-virginica
    8          7.7         2.6          6.9         2.3  Iris-virginica
    9          7.7         2.8          6.7         2.0  Iris-virginica