Conversational Analytics Code Interpreter

Conversational Analytics is an AI-powered data analytics tool that helps you derive advanced insights from your data by asking questions in regular, natural (conversational) language. You don't need coding experience or data expertise to use Conversational Analytics.

The Code Interpreter in Conversational Analytics translates your natural language questions into Python code and executes that code to provide advanced analysis and visualizations. In contrast to standard SQL-powered BI experiences, the Code Interpreter supports a wide variety of data analytics—from basic computations and charting to more advanced tasks like time series forecasting. The Code Interpreter enhances Conversational Analytics by enabling users to perform these types of advanced analysis, which otherwise would typically require specialized knowledge of advanced coding or statistical methods.

Learn how and when Gemini for Google Cloud uses your data. As an early-stage technology, Gemini for Google Cloud products can generate output that seems plausible but is factually incorrect. We recommend that you validate all output from Gemini for Google Cloud products before you use it. For more information, see Gemini for Google Cloud and responsible AI.

Sign up for the experimental preview

The Code Interpreter will be available for experimental preview in Q2 2025. To receive a notification when the preview is available, fill out the preview interest form.

Known limitations

  • The Code Interpreter uses Python to solve problems. Since Python is more flexible than structured query languages, Code Interpreter responses might have more variability than responses from the core Conversational Analytics experience.
  • For Looker data, Conversational Analytics can return a maximum of 5,000 rows per query.
  • The Code Interpreter supports these Python libraries. To request support for additional Python libraries, send an email to conversational-analytics-feedback@google.com.

For information about additional limitations, see the documentation on known limitations in Conversational Analytics.

Supported Python libraries

Show supported Python libraries

The Code Interpreter supports the following Python libraries:

  • altair
  • attrs
  • chess
  • contourpy
  • cycler
  • entrypoints
  • fonttools
  • fpdf
  • geopandas
  • imageio
  • jinja2
  • joblib
  • jsonschema
  • jsonschema-specifications
  • kiwisolver
  • lxml
  • markupsafe
  • matplotlib
  • mpmath
  • numexpr
  • numpy
  • opencv-python
  • openpyxl
  • packaging
  • pandas
  • patsy
  • pdfminer-six
  • pillow
  • plotly
  • protobuf
  • pylatex
  • pyparsing
  • PyPDF2
  • python-dateutil
  • python-docx
  • python-pptx
  • pytz
  • referencing
  • reportlab
  • rpds-py
  • scikit-image
  • scikit-learn
  • scipy
  • seaborn
  • six
  • statsmodels
  • striprtf
  • sympy
  • tabulate
  • tensorflow
  • threadpoolctl
  • toolz
  • torch
  • tzdata
  • xlrd

Supported questions

When you enable the Code Interpreter, Python's advanced analytic capabilities enable Conversational Analytics to answer a wider range of questions, in addition to the standard types of supported questions. For example:

  • What is the lifetime value for each of my customer segments, taking into account the average purchase frequency and the average order value?
  • How do sales this year compare to sales last year?
  • Identify outliers in my sales data to help identify products or regions that are performing particularly well or particularly poorly.
  • Perform a cohort analysis to understand customer retention.
  • Are my highest margin products also the most popular products? Use this answer to provide a suggestion on how to optimize my product mix.