notebook-guidance

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

9|Updated Jul 8, 2026
One-click install
npx skills add https://github.com/jerrylin96/dotgemini --skill notebook-guidance-jerrylin96
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/jerrylin96/dotgemini/tree/main/skills/notebook-guidance
Command: npx skills add https://github.com/jerrylin96/dotgemini --skill notebook-guidance-jerrylin96

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, but ad-hoc scripts lose state and produce unstructured output. This Skill provides structured rules for building Jupyter notebooks that query BigQuery, clean data, and present insights as a readable story. ## Core Features & Use Cases - Conditional Execution Flow: Enforces a generate-execute-validate loop per cell when an execution tool is available, or full notebook generation with user-run instructions when it is not. - BigQuery Integration via %%bqsql: Mandates BigFrames magics for SQL queries with named dataframe export, prohibiting the Python BigQuery client library and pandas.read_gbq. - Notebook Structure & Plotting Rules: Defines a markdown-and-cell layout with title, sections, verification cells, visualizations, and a final summary containing 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 the data with %%bqsql, validates each result, plots retention curves, and ends with a grounded summary. ## Quick Start Create a Jupyter notebook that analyzes trends in my BigQuery table using %%bqsql queries and visualizations.

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 after running %load_ext bigframes. Always assign a dataframe name like %%bqsql df_name so results can be used in later Python cells, and avoid the google.cloud.bigquery client library or pandas.read_gbq.

When should I use a notebook for data analysis?

Use a notebook when the task involves insights, trends, visualizations, or iterative exploration where state must persist between 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, BigFrames dataframes must be manipulated with BigFrames methods, and machine learning must use BQML SQL or bigframes.ml. Avoid calling .to_pandas() except for small, reduced datasets needed by visualization libraries.

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.

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

First run %pip list or try importing the package, since managed runtimes pre-install many common libraries. Only use %pip install for packages confirmed missing, and ask the user when the kernel type or install method is unclear.