如何使用groupby和aggregate将pyspark dataframe中的行与多列连接起来

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

spark = SparkSession.builder.appName("DataFrameGroupByAggregate").getOrCreate()

data = [("Alice", 25, 100), ("Bob", 30, 200), ("Alice", 35, 150), ("Bob", 40, 300)]
df = spark.createDataFrame(data, ["Name", "Age", "Salary"])
df.show()

+-----+---+------+
| Name|Age|Salary|
+-----+---+------+
|Alice| 25|   100|
|  Bob| 30|   200|
|Alice| 35|   150|
|  Bob| 40|   300|
+-----+---+------+

result = df.groupBy("Name").agg({"Age": "max", "Salary": "sum"})
result.show()

+-----+--------+-----------+
| Name|max(Age)|sum(Salary)|
+-----+--------+-----------+
|Alice|      35|        250|
|  Bob|      40|        500|
+-----+--------+-----------+