使用groupBy并按最小值和最大值聚合：

import pyspark.sql.functions as F

df = spark.createDataFrame(data=[["John",1,2],["John",3,4],["Mary",2,1],["Mary",4,3],["Peter",3,6]], schema=["Name","Value1","Value2"])

df = df.groupBy("Name") \
      .agg( \
          F.min("Value1").alias("Value1"), \
          F.max("Value2").alias("Value2") \
      )

输出：

+-----+------+------+
|Name |Value1|Value2|
+-----+------+------+
|Mary |2     |3     |
|John |1     |4     |
|Peter|3     |6     |
+-----+------+------+