pyspark.sql.functions.format_number

pyspark.sql.functions.format_number(col: ColumnOrName, d: int) → pyspark.sql.column.Column[source]

Formats the number X to a format like ‘#,–#,–#.–’, rounded to d decimal places with HALF_EVEN round mode, and returns the result as a string.

New in version 1.5.0.

Parameters
colColumn or str

the column name of the numeric value to be formatted

dint

the N decimal places

>>> spark.createDataFrame([(5,)], [‘a’]).select(format_number(‘a’, 4).alias(‘v’)).collect()
[Row(v=’5.0000’)]