pyspark.sql.functions.mean#
- pyspark.sql.functions.mean(col)[source]#
- Aggregate function: returns the average of the values in a group. An alias of - avg().- New in version 1.4.0. - Changed in version 3.4.0: Supports Spark Connect. - Parameters
- colColumnor column name
- target column to compute on. 
 
- col
- Returns
- Column
- the column for computed results. 
 
 - Examples - Example 1: Calculating the average age - >>> import pyspark.sql.functions as sf >>> df = spark.createDataFrame([(1982, 15), (1990, 2)], ["birth", "age"]) >>> df.select(sf.mean("age")).show() +--------+ |avg(age)| +--------+ | 8.5| +--------+ - Example 2: Calculating the average age with None - >>> import pyspark.sql.functions as sf >>> df = spark.createDataFrame([(1982, None), (1990, 2), (2000, 4)], ["birth", "age"]) >>> df.select(sf.mean("age")).show() +--------+ |avg(age)| +--------+ | 3.0| +--------+