Pyspark SQL:如何创建一个由column的值加上另一个列名组成的新值？

from pyspark.sql import SparkSession
from pyspark.sql.functions import concat, col

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

# 创建一个DataFrame
data = [(1, "Alice", 25), (2, "Bob", 30), (3, "Charlie", 35)]
df = spark.createDataFrame(data, ["id", "name", "age"])

# 使用withColumn()方法创建新列
df_new = df.withColumn("new_value", concat(col("name"), col("age")))

# 显示结果
df_new.show()