notebook-guidance

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

Updated Jul 20, 2026
One-click install
npx skills add https://github.com/Jatinkrmahato993203/crime --skill notebook-guidance-jatinkrmahato993203
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/Jatinkrmahato993203/crime/tree/main/skills/notebook-guidance
Command: npx skills add https://github.com/Jatinkrmahato993203/crime --skill notebook-guidance-jatinkrmahato993203

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 data manipulation and ML. - Notebook Structure & Storytelling: Defines a layout of markdown headers, small logical cells, visualizations, and a final summary with Q&A, key findings, and next steps. - Use Case: A user asks to explore crime trends in a BigQuery dataset. The Skill guides kernel selection, library checks, step-by-step %%bqsql queries, plotting with proper figure sizing, and a grounded summary of findings. ## Quick Start Ask the assistant to analyze a BigQuery table in a Jupyter notebook and visualize the key trends it finds.

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 after running %load_ext bigframes. Always assign results to a dataframe name (e.g., %%bqsql df_name) so subsequent Python cells can use the BigQuery DataFrame directly. Do not use the google.cloud.bigquery client or pandas.read_gbq.

When should I use a notebook for data analysis?▼

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

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

No. 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 during execution?▼

Failed cells must be fixed before proceeding, and failed attempt cells must be deleted so the final notebook has no errors. If execution reports no active kernel, stop immediately and wait for the user to activate the correct kernel.

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

First run %pip list or import the package to check whether it is already installed, since managed runtimes pre-install many packages. Only use %pip install for confirmed missing packages, and ask the user when the kernel type is unclear.