如何根据PySpark数据帧的另一列中的值修改一列？F.when边缘情况

from pyspark.sql import SparkSession
from pyspark.sql.functions import when

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

# 创建示例数据帧
data = [("Alice", 25, "F"), ("Bob", 30, "M"), ("Charlie", 35, "M")]
df = spark.createDataFrame(data, ["name", "age", "gender"])

# 使用when函数根据gender列的值修改新列new_gender
df = df.withColumn("new_gender", when(df.gender == "F", "Female").otherwise("Male"))

# 显示修改后的数据帧
df.show()

+-------+---+------+-----------+
|   name|age|gender|new_gender |
+-------+---+------+-----------+
|  Alice| 25|     F|     Female|
|    Bob| 30|     M|       Male|
|Charlie| 35|     M|       Male|
+-------+---+------+-----------+