在spark dataframe中执行透视时，'GroupedData‘对象没有属性’show

# 导入必要的模块
from pyspark.sql import SparkSession

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

# 创建示例DataFrame
data = [("Alice", "Math", 90),
        ("Alice", "English", 85),
        ("Bob", "Math", 80),
        ("Bob", "English", 75),
        ("Bob", "Science", 95)]

df = spark.createDataFrame(data, ["Name", "Subject", "Score"])

# 执行透视操作
pivot_df = df.groupBy("Name").pivot("Subject").sum("Score")

# 显示透视结果
pivot_df.show()

# 执行透视操作
pivot_df = df.groupBy("Name").pivot("Subject").agg({"Score": "sum"})

# 显示透视结果
pivot_df.show()