如何用科学记数法以适当的格式显示PySpark数据帧中的列

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

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

# 创建示例数据帧
data = [(1, 1000), (2, 2000), (3, 3000)]
df = spark.createDataFrame(data, ["id", "value"])

# 使用format_number函数格式化列"value"，并显示两位小数
df_formatted = df.withColumn("formatted_value", format_number("value", 2))

# 显示结果
df_formatted.show()

+---+-----+---------------+
| id|value|formatted_value|
+---+-----+---------------+
|  1| 1000|       1,000.00|
|  2| 2000|       2,000.00|
|  3| 3000|       3,000.00|
+---+-----+---------------+