bigquery-bigframes

Generates Python code using BigQuery DataFrames for pandas-style analysis and ML on BigQuery.

1|Updated Aug 30, 2026
One-click install
npx skills add https://github.com/FeexSystems/3WM-SONIK-LABS --skill bigquery-bigframes-feexsystems
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-bigframes
Source: https://github.com/FeexSystems/3WM-SONIK-LABS/tree/main/.gemini/skills/bigquery-bigframes
Command: npx skills add https://github.com/FeexSystems/3WM-SONIK-LABS --skill bigquery-bigframes-feexsystems

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires bigframes, and includes references (resource) components.

What problem does it solve? Writing pandas-style data analysis and machine learning code against BigQuery requires knowing BigFrames-specific APIs and pitfalls, such as partial ordering mode, avoiding local materialization, and using BigQuery-native ML functions instead of scikit-learn. ## Core Features & Use Cases - DataFrame Best Practices: Enforces partial ordering mode, peek() over head(), accessor methods over UDFs and lambdas, and schema verification with .dtypes. - BigQuery-Native ML: Guides model training, evaluation, and prediction through bigframes.bigquery.ml functions like create_model, evaluate, and predict instead of local scikit-learn. - Reference Examples: Includes ready linear regression and logistic regression examples training models on the public penguins dataset. - Use Case: A data scientist in a notebook wants to train a logistic regression model on a large BigQuery table without downloading data locally; the Skill produces BigFrames code that delegates training to BigQuery's ML engine. ## Quick Start Write BigFrames Python code that loads a BigQuery table, cleans it with DataFrame methods, and trains a linear regression model using bigframes.bigquery.ml.

Frequently Asked Questions about bigquery-bigframes

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I use pandas-style DataFrames with BigQuery?▼

Use the BigFrames library by importing bigframes.pandas and loading tables with read_gbq. Enable partial ordering mode via bpd.options.bigquery.ordering_mode = 'partial' for faster processing, and operate with familiar DataFrame methods that execute on BigQuery.

How do I train a machine learning model on BigQuery data in Python?▼

Import functions from bigframes.bigquery.ml and call create_model with your training data and a model_type such as LINEAR_REG or LOGISTIC_REG. Training runs inside BigQuery's ML engine, so data never moves to local memory.

BigFrames vs google-cloud-bigquery client library, which should I use?▼

Use BigFrames when you want pandas-style DataFrame operations and ML with lazy execution on BigQuery. Use the google-cloud-bigquery client library for SQL-first workflows, job management, and administrative tasks.

Why does head() fail in BigFrames partial ordering mode?▼

head() requires strict row ordering, which partial ordering mode relaxes for performance. Use peek(n) instead, which randomly samples n rows quickly, or explicitly sort the DataFrame before calling head().

When should I avoid calling to_pandas() on a BigFrames DataFrame?▼

Avoid to_pandas() for large datasets because it downloads all data into client memory, risking out-of-memory errors and bypassing BigQuery's distributed computation. Only materialize when the data is small, an error requires it, or you have aggregated before plotting.