如何反转pyspark dataframe

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

spark = SparkSession.builder.getOrCreate()

df = spark.createDataFrame([(1, 'A', 10), (1, 'B', 20), (2, 'A', 30), (2, 'B', 40)], ['id', 'category', 'value'])
df.show()

+---+--------+-----+
|id |category|value|
+---+--------+-----+
|1  |A       |10   |
|1  |B       |20   |
|2  |A       |30   |
|2  |B       |40   |
+---+--------+-----+

result = df.groupBy('id').pivot('category').agg(col('value'))
result.show()

+---+----+----+
|id |A   |B   |
+---+----+----+
|1  |10  |20  |
|2  |30  |40  |
+---+----+----+