bigquery-bigframes

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

1|Updated Mar 19, 2026
One-click install
npx skills add https://github.com/tottenjordan/me-skittles --skill bigquery-bigframes-tottenjordan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-bigframes
Source: https://github.com/tottenjordan/me-skittles/tree/main/gemini/bigquery-bigframes
Command: npx skills add https://github.com/tottenjordan/me-skittles --skill bigquery-bigframes-tottenjordan

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 idioms, and common mistakes like materializing data locally or using raw SQL break lazy execution and cause out-of-memory errors. ## Core Features & Use Cases - BigFrames DataFrame Best Practices: Enforces partial ordering mode, peek() previews, accessor-based transformations, and schema verification instead of local materialization. - BigQuery ML Integration: Guides model training, evaluation, and prediction through bigframes.bigquery.ml so computation stays in BigQuery rather than client memory. - Legacy BigFrames ML Support: Covers the legacy bigframes.ml package including ARIMA Plus forecasting, PCA, and model persistence with to_gbq(). - Use Case: In a notebook, ask for a logistic regression model trained on the public penguins dataset, and receive correct BigFrames code that trains and evaluates the model entirely inside BigQuery. ## Quick Start Write BigFrames code that loads the penguins dataset from BigQuery and trains a linear regression model to predict penguin body mass.

Frequently Asked Questions about bigquery-bigframes

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

FAQPage Schema
How do I write pandas-style code that runs on BigQuery?▼

Use BigQuery DataFrames (BigFrames), which exposes a pandas-like API that compiles operations into BigQuery SQL. Import bigframes.pandas, enable partial ordering mode, and use DataFrame methods so computation stays in BigQuery.

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

Use BigFrames for pandas-style DataFrame analysis and ML workflows against BigQuery. Use the google-cloud-bigquery client library for SQL-first workflows, job management, and administrative operations instead.

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 and works regardless of ordering mode.

Can I use scikit-learn models with BigQuery DataFrames?▼

No, scikit-learn requires pulling data into local client memory. Import models from bigframes.bigquery.ml instead, which delegates training directly to BigQuery's ML engine and keeps data in the cloud.

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

Avoid to_pandas() whenever possible because it downloads all data to client memory, bypassing distributed computation and risking OOM errors. Only use it for small datasets, explicit error requirements, or after aggregating data for plotting.