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/SmileAfterBurn/pani-dumka-ai --skill notebook-guidance-smileafterburn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: notebook-guidance
Source: https://github.com/SmileAfterBurn/pani-dumka-ai/tree/main/.gemini/skills/notebook-guidance
Command: npx skills add https://github.com/SmileAfterBurn/pani-dumka-ai --skill notebook-guidance-smileafterburn

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 without clear guidance notebooks end up with failed cells, wrong libraries, or inefficient BigQuery access patterns. This Skill enforces a structured, validated notebook workflow for data analysis on Google Cloud. ## Core Features & Use Cases - Conditional Execution Flow: Adapts behavior based on tool availability, using an incremental generate-execute-validate loop when cell execution is possible, or generating a complete notebook for user execution otherwise. - BigQuery Integration via BigFrames: Enforces use of %%bqsql magics instead of the Python BigQuery client, with mandatory dataframe export and BigFrames-based manipulation and ML. - Notebook Structure & Visualization Rules: Defines a story-like 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 querying with %%bqsql, validating each cell's output, plotting trends with distinct colors, and ending with a grounded summary of key 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 magic from the bigframes library instead of the Python BigQuery client or pandas.read_gbq. Load it with %load_ext bigframes, then write %%bqsql followed by a dataframe name to export results for use in later Python cells.

How to create a data analysis notebook with visualizations?▼

Structure the notebook like a story: a title markdown cell, section headers, data acquisition cells, optional verification cells, and visualization cells. End with a summary markdown cell containing Q&A, key findings, and next steps grounded in verified numbers.

Should I use pandas or BigFrames for BigQuery data analysis?▼

Use BigFrames for data exploration, manipulation, and machine learning on BigQuery data, since it keeps computation in the cloud. Avoid pandas, Scikit-learn, and .to_pandas() except when a visualization library requires it, and then only on reduced data.

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.

When should I not use a Jupyter notebook for a data task?▼

Skip notebooks for simple fact or status requests, like counting rows or checking when a table was updated, and for schema-only previews. Notebooks are best for multi-step analysis, trends, and visualization-driven insights.