DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • Snowflake Horizon Catalog
    • Applications and tools for connecting to Snowflake
    • Virtual warehouses
    • Databases, Tables, & Views
    • Data types
      • Data Integration
        1. Snowflake Openflow
        2. Apache Iceberg™
          1. Apache Iceberg™ Tables
          2. Snowflake Open Catalog
      • Data Engineering
        1. Data Loading
        2. Dynamic Tables
        3. Streams and Tasks
        4. dbt Projects on Snowflake
        5. Data Unloading
      • Storage Lifecycle Policies
      • Migrations
      • Queries
      • Listings
      • Collaboration
      • Snowflake AI & ML
      • Alerts & Notifications
      • Security
      • Data Governance
      • Privacy
      • Organizations & Accounts
      • Business continuity & data recovery
      • Performance optimization
      • Cost & Billing

      snowflake.snowpark.functions.mean¶

      snowflake.snowpark.functions.mean(e: Union[Column, str]) → Column[source]¶

      Return the average for the specific numeric columns. Alias of avg().

      Example:

      >>> df = session.create_dataframe([1, 3, 10, 1, 3], schema=["x"])
      >>> df.select(mean("x").as_("x")).collect()
      [Row(X=Decimal('3.600000'))]
      
      Copy

      Was this page helpful?

      Visit Snowflake
      Join the conversation
      Develop with Snowflake
      Share your feedback
      Read the latest on our blog
      Get your own certification
      Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
      Language: English
      • English
      • Français
      • Deutsch
      • 日本語
      • 한국어
      • Português