Breaking News: Grepper is joining You.com. Read the official announcement!

pyspark.sql.functions mode

Excel Experts answered on November 21, 2022 Popularity 7/10 Helpfulness 1/10

answer pyspark.sql.functions mode

pyspark.sql.functions mode

Comment

-1

import numpy as np
np.random.seed(1)

df = sc.parallelize([
    (int(x), ) for x in np.random.randint(50, size=10000)
]).toDF(["x"])

cnts = df.groupBy("x").count()
mode = cnts.join(
    cnts.agg(max("count").alias("max_")), col("count") == col("max_")
).limit(1).select("x")
mode.first()[0]
## 0

Popularity 7/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: mode python

Link to this answer
Share Copy Link