如何在pyspark中格式化数字列？

from pyspark.sql import SparkSession
from pyspark.sql.functions import format_number

# 创建SparkSession
spark = SparkSession.builder.getOrCreate()

# 创建示例数据
data = [(1, 1234567.89123456789), (2, 9876543.21098765432)]
df = spark.createDataFrame(data, ["id", "number"])

# 格式化数字列
df_formatted = df.withColumn("formatted_number", format_number("number", 2))

# 显示结果
df_formatted.show()

+---+------------------+----------------+
| id|            number|formatted_number|
+---+------------------+----------------+
|  1|1234567.8912345678|    1,234,567.89|
|  2|9876543.2109876543|    9,876,543.21|
+---+------------------+----------------+