bigquery-bigframes

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

Updated Aug 16, 2026
One-click install
npx skills add https://github.com/1919114514yasenpai-maker/focus-quest --skill bigquery-bigframes-1919114514yasenpai-maker
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-bigframes
Source: https://github.com/1919114514yasenpai-maker/focus-quest/tree/main/.gemini/skills/bigquery-bigframes
Command: npx skills add https://github.com/1919114514yasenpai-maker/focus-quest --skill bigquery-bigframes-1919114514yasenpai-maker

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill 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, ordering modes, and ML packages that differ from standard pandas and scikit-learn. This Skill provides the correct patterns so generated code runs distributed on BigQuery instead of pulling data into local memory. ## Core Features & Use Cases - BigFrames DataFrame best practices: Enforces partial ordering mode, peek() previews, accessor-based transformations, and avoidance of to_pandas() and raw SQL via read_gbq(). - Serverless ML with bigframes.bigquery.ml: Generates linear regression, logistic regression, and other model training code that delegates computation to BigQuery ML instead of scikit-learn. - Legacy BigFrames ML guidance: Covers bigframes.ml specifics such as DataFrame-returning predict(), no random_state, custom hyperparameter loops, ARIMA Plus forecasting, and model persistence via to_gbq(). - Use Case: In a notebook, ask for a logistic regression model on the public penguins dataset and receive complete BigFrames code that loads data, trains with bbq.ml.create_model, evaluates, and predicts entirely inside BigQuery. ## Quick Start Ask the AI to write BigFrames code that loads a BigQuery table 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 train a machine learning model with BigQuery DataFrames?▼

Use the bigframes.bigquery.ml package, which delegates training to BigQuery's ML engine. Call bbq.ml.create_model with a model type like LINEAR_REG or LOGISTIC_REG, then evaluate and predict with bbq.ml.evaluate and bbq.ml.predict.

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

Use BigFrames when you want pandas-style DataFrame and Series operations that compile to BigQuery SQL lazily. Use the google-cloud-bigquery client library for SQL-first workflows, job management, and administrative tasks instead.

Can I use scikit-learn with BigFrames DataFrames?▼

No, scikit-learn requires pulling data into local client memory. Use bigframes.bigquery.ml for new projects so training runs on BigQuery's scalable ML engine, or the legacy bigframes.ml package only when explicitly requested.

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

In partial ordering mode, row sequence is not guaranteed, so head(n) fails unless the DataFrame has been explicitly sorted. Use peek(n) instead, which randomly samples n rows and is significantly faster.

When should I avoid calling to_pandas() in BigFrames?▼

Avoid to_pandas() for large datasets because it downloads all data to client memory, bypassing BigQuery's distributed computation and risking out-of-memory errors. Only use it for small datasets, explicit error requirements, or after aggregating data for plotting.