PySpark SQL Functions | lower method

Machine Learning

chevron_right

PySpark

chevron_right

Documentation

chevron_right

PySpark SQL Functions

schedule Jul 1, 2022

Last updated

local_offer PySpark

Parameters

1. col | string or Column

The column to perform the lowercase operation on.

Return Value

A PySpark Column (pyspark.sql.column.Column).

Examples

Consider the following PySpark DataFrame:


        
        
            
                
                
                    df = spark.createDataFrame([["ALEX", 25], ["BoB", 30]], ["name", "age"])
df.show()
                
            
            +----+---+
|name|age|
+----+---+
|ALEX| 25|
| BoB| 30|
+----+---+

Lowercasing strings in PySpark DataFrame

To lower-case the strings in the name column:


        
        
            
                
                
                    import pyspark.sql.functions as F
df.select(F.lower(df.name)).show()
                
            
            +-----------+
|lower(name)|
+-----------+
|       alex|
|        bob|
+-----------+

Note that passing in a column label as a string also works:


        
        
            
                
                
                    import pyspark.sql.functions as F
df.select(F.lower("name")).show()
                
            
            +-----------+
|lower(name)|
+-----------+
|       alex|
|        bob|
+-----------+

Replacing column with lowercased column in PySpark

To replace the name column with the lower-cased version, use the withColumn(~):


        
        
            
                
                
                    import pyspark.sql.functions as F
df.withColumn("name", F.lower(df.name)).show()
                
            
            +----+---+
|name|age|
+----+---+
|alex| 25|
| bob| 30|
+----+---+

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Share on Twitter

Share on Facebook

Ask a question or leave a feedback...

Official PySpark Documentation

https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.functions.lower.html

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!