notebook-guidance

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

Updated Jan 8, 2026
One-click install
npx skills add https://github.com/arslan9024/White-Caves --skill notebook-guidance-arslan9024
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/arslan9024/White-Caves/tree/main/.agents/skills/notebook_guidance
Command: npx skills add https://github.com/arslan9024/White-Caves --skill notebook-guidance-arslan9024

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-cell, execute-cell, validate-output loop when an execution tool is available, or full notebook generation with user-run verification when it is not. - BigQuery Integration Rules: Mandates the %%bqsql BigFrames magic for SQL queries, forbids the Python BigQuery client library, and requires BigFrames (not pandas or scikit-learn) for manipulation and ML. - Notebook Structure & Visualization Standards: 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 stored in BigQuery. The Skill guides the agent to identify the correct table, query it with %%bqsql, visualize cohort trends cell by cell, and finish with a grounded summary. ## 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 magic from the bigframes library instead of the Python BigQuery client. Load it with %load_ext bigframes, then write cells like %%bqsql df_name followed by standard BigQuery SQL, which exports results to a BigFrames DataFrame.

When should I use a notebook for data analysis?▼

Use a notebook when the task involves insights, trends, visualizations, or iterative exploration where each query depends on previous results. Skip notebooks for simple single-value lookups like row counts or schema previews.

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

No, this workflow requires BigFrames methods for data manipulation and bigframes.ml for machine learning tasks. Avoid to_pandas() except for small visualization-ready subsets, and never use read_gbq for SQL queries.

What happens if a notebook cell fails during execution?▼

Failed cells must be fixed before proceeding, and any failed attempt versions must be deleted so the final notebook has no errors. If a kernel-not-found error occurs, stop immediately and wait until the user activates the correct kernel.

How do I install Python packages in remote Spark or Colab kernels?▼

First run %pip list or try importing the package, since managed runtimes like Dataproc Serverless and Colab pre-install many libraries. Only use %pip install for packages confirmed missing, typically in the first cell.