notebook-guidance

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

Updated Aug 26, 2026
One-click install
npx skills add https://github.com/Lathika-laa/Recipe_Box --skill notebook-guidance-lathika-laa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/Lathika-laa/Recipe_Box/tree/main/.github/.gemini/skills/notebook-guidance
Command: npx skills add https://github.com/Lathika-laa/Recipe_Box --skill notebook-guidance-lathika-laa

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: Adapts behavior based on tool availability, using an incremental generate-execute-validate loop when a cell execution tool exists, or generating the full notebook for user execution otherwise. - BigQuery Integration via %%bqsql Magics: Enforces BigFrames-based querying with mandatory dataframe export, prohibiting the Python BigQuery client library and pandas.read_gbq. - Notebook Structure & Visualization Rules: Defines a story-like layout with markdown sections, plotting rules, 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 creating a notebook that queries data with %%bqsql, validates each cell's output, plots retention curves, and ends with a grounded summary of findings. ## Quick Start Create a Jupyter notebook that analyzes sales trends from my BigQuery table and visualizes the key findings.

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 the %%bqsql cell magic from the bigframes library instead of the Python BigQuery client. Load it with %load_ext bigframes, then write %%bqsql df_name followed by your SQL to export results directly into a BigFrames dataframe.

When should I use a notebook for data analysis?▼

Use a notebook for tasks involving insights, trends, exploration, or requested visualizations, and for iterative stateful analysis. Skip it for simple single-value lookups like row counts or schema previews.

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

No. BigFrames dataframes should be manipulated with BigFrames methods, and machine learning must use BQML SQL or bigframes.ml. Avoid .to_pandas() except for small, reduced datasets needed by visualization libraries.

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

The bigframes library must be version 2.38.0 or above for %%bqsql magic support. If it is missing or outdated in the notebook runtime, ask the user before upgrading the environment.

What should I do when a notebook cell reports no active kernel?▼

Stop immediately and do not generate further cells. Inform the user which kernel is needed, such as PySpark or Dataproc Serverless, and wait for confirmation that a kernel is active before continuing execution.