如何计算字符串在PySpark数据帧列中的出现次数？

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

spark = SparkSession.builder.getOrCreate()

data = [("apple",), ("banana",), ("apple",), ("orange",), ("banana",)]
df = spark.createDataFrame(data, ["fruits"])
df.show()

+------+
|fruits|
+------+
| apple|
|banana|
| apple|
|orange|
|banana|
+------+

result = df.groupBy("fruits").count().orderBy(col("count").desc())
result.show()

+------+-----+
|fruits|count|
+------+-----+
| apple|    2|
|banana|    2|
|orange|    1|
+------+-----+