Teradata Package for Python Function Reference | 17.10 - lower - 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.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