notebook-guidance

Guides creation and execution of Jupyter notebooks for BigQuery data analysis and visualization.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires bigframes, ipykernel.

What problem does it solve? Data analysis tasks often require multi-step queries, iterative exploration, and visualizations that are hard to manage in one-off scripts. This Skill provides structured rules for building, executing, and validating Jupyter notebooks, especially when querying BigQuery, so analyses are reproducible, readable, and error-free. ## Core Features & Use Cases - Conditional Execution Workflow: Enforces a generate-execute-validate cell-by-cell flow when a notebook execution tool is available, or full-notebook generation with user-run verification when it is not. - BigQuery Integration via %%bqsql Magics: Mandates BigFrames %%bqsql magic cells instead of the Python BigQuery client library, with required dataframe export for downstream Python cells. - Notebook Structure & Visualization Rules: Defines a story-like layout with markdown sections, plotting rules (distinct colors, sizing, PCA for clustering), data cleaning constraints, and a mandatory final summary with Q&A, key findings, and next steps. - Use Case: A user asks to explore user retention trends in a BigQuery table. The Skill guides kernel selection, library checks, incremental %%bqsql query cells, BigFrames-based transformation, charts, and a grounded summary. ## Quick Start Create a Jupyter notebook that analyzes trends in my BigQuery table using %%bqsql queries and visualizations, executing and validating each cell step by step.

Frequently Asked Questions about notebook-guidance

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

FAQPage Schema
How do I query BigQuery from a Jupyter notebook?▼

Use BigFrames %%bqsql magic cells instead of the Python BigQuery client library or pandas.read_gbq. Load the extension with %load_ext bigframes, then write %%bqsql df_name followed by your SQL to export results into a BigFrames DataFrame.

When should I use a notebook for data analysis?▼

Use a notebook when the task involves insights, trends, visualizations, or iterative stateful exploration across multiple queries. Skip it for simple single-value lookups like row counts or schema previews.

Can I use pandas or scikit-learn with BigQuery DataFrames?▼

No. You must use BigFrames methods for data manipulation and bigframes.ml for machine learning tasks instead of pandas or scikit-learn. Avoid .to_pandas() except for small, reduced datasets needed by visualization libraries.

What happens if a notebook cell fails or no kernel is active?▼

Failed cells must be fixed and failed attempts deleted before presenting the notebook. If execution returns a no-active-kernel error, stop immediately, tell the user which kernel is needed, and wait for confirmation before continuing.

What bigframes version is required for %%bqsql magics?▼

The bigframes library version 2.38.0 or above must be installed in the notebook runtime. If it is missing or outdated, ask the user whether they want it upgraded before proceeding.