notebook-guidance

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

Updated Aug 11, 2026
One-click install
npx skills add https://github.com/Yashyasik/zexca-api --skill notebook-guidance-yashyasik
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/Yashyasik/zexca-api/tree/main/.gemini/skills/notebook-guidance
Command: npx skills add https://github.com/Yashyasik/zexca-api --skill notebook-guidance-yashyasik

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 an execution tool is available, or full notebook generation with user-run verification when it is not. - BigQuery Integration via %%bqsql: Mandates BigFrames magics instead of the Python BigQuery client, with required dataframe export and BigFrames-based manipulation and ML. - Notebook Structure & Visualization Rules: Defines a storytelling layout with markdown sections, plotting rules, data cleaning constraints, and a standardized final summary. - Use Case: A user asks to explore user retention trends in a BigQuery table. The Skill guides kernel setup, %%bqsql queries into BigFrames dataframes, step-by-step validated cells, charts for each insight, and a grounded summary of findings. ## 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 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, exploration, or requested visualizations, or when you need stateful iterative querying. Skip it for single-number facts, status checks, or schema-only 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 should I do when a notebook cell fails with 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.