如何从dataframe中的另一列替换Pyspark Dataframe列中的字符串

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

spark = SparkSession.builder.getOrCreate()

data = [("Alice", "Female"), ("Bob", "Male"), ("Charlie", "Male")]
df = spark.createDataFrame(data, ["Name", "Gender"])
df.show()

+-------+------+
|   Name|Gender|
+-------+------+
|  Alice|Female|
|    Bob|  Male|
|Charlie|  Male|
+-------+------+

df = df.withColumn("Gender", when(df.Gender == "Female", "F").otherwise("M"))
df.show()

+-------+------+
|   Name|Gender|
+-------+------+
|  Alice|     F|
|    Bob|     M|
|Charlie|     M|
+-------+------+