如何在pyspark中做小写和删除原始列？

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

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

# 创建DataFrame
data = [("John", 25), ("Alice", 30), ("Bob", 35)]
df = spark.createDataFrame(data, ["Name", "Age"])

# 将Name列转换为小写，并使用alias方法给新列起别名
df_lower = df.select(col("Name").alias("name"))

# 显示结果
df_lower.show()

+-----+
| name|
+-----+
| john|
|alice|
|  bob|
+-----+

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

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

# 创建DataFrame
data = [("John", 25), ("Alice", 30), ("Bob", 35)]
df = spark.createDataFrame(data, ["Name", "Age"])

# 删除Name列
df_without_name = df.withColumn("Name", col("Name")).drop("Name")

# 显示结果
df_without_name.show()

+---+
|Age|
+---+
| 25|
| 30|
| 35|
+---+