当我尝试将字符串列转换为数字时，PySpark返回异常

from pyspark.sql.functions import col

df = df.withColumn("numeric_column", col("string_column").cast("double"))

from pyspark.sql.functions import regexp_replace

df = df.withColumn("numeric_column", regexp_replace(col("string_column"), "[^0-9.]", ""))

from pyspark.sql.functions import when, col

df = df.withColumn("numeric_column", when(col("string_column").rlike("^[0-9.]+$"), col("string_column").cast("double")).otherwise(None))

try:
    df = df.withColumn("numeric_column", col("string_column").cast("double"))
except Exception as e:
    print("Error occurred:", str(e))