如何使用Pyspark将字符串列转换为十进制列

from pyspark.sql import SparkSession
from pyspark.sql.functions import col
from pyspark.sql.types import DecimalType

spark = SparkSession.builder.appName("String to Decimal Conversion").getOrCreate()

data = [("John", "123.45"), ("Alice", "67.89"), ("Bob", "987.65")]
df = spark.createDataFrame(data, ["Name", "StringColumn"])
df.show()

def string_to_decimal(string_value):
    return float(string_value)

string_to_decimal_udf = udf(string_to_decimal, DecimalType())

df = df.withColumn("DecimalColumn", string_to_decimal_udf(col("StringColumn")))
df.show()