Results for “pivot-tables”

Use for writing, reviewing, debugging, or testing publication-quality display tables in Python with Great Tables, including GT construction, stub and row groups, headers and spanners, labels, numeric/date formatting, targeted styles, footnotes/source notes, HTML/LaTeX/image export, and render verification. Do not use for dataframe computation, interactive data grids, charts, or plain console tables.

Use this skill when the user uploads Excel (.xlsx/.xls) or CSV files and wants to perform data analysis, generate statistics, create summaries, pivot tables, SQL queries, or any form of structured data exploration. Supports multi-sheet Excel workbooks, aggregation, filtering, joins, and exporting results to CSV/JSON/Markdown.

Called by /plot to upgrade regression and summary tables to top-journal standards.

Design and format publication-quality tables: column order, row grouping, notes, precision, reproducibility.

Detect when backtest iteration has stalled and generate structurally different strategy pivot proposals to break out of local optima.

Provision Bigtable instances, design performant schemas, and query data using gcloud, cbt, or client libraries.

Design or revise a company's commercial policy governing discounts, approver thresholds, exception flows, and deal frameworks using data-backed matrices and linting tools.

Use this skill for tables, grids, filters, sorting, density, keyboard navigation, responsive behavior. Trigger when the task involves web design work related to Data Table Grid UX, implementation, audits, debugging, strategy, or validation.

Reference guide to 9 prioritization frameworks with formulas, when-to-use guidance, and templates — RICE, ICE, Kano, MoSCoW, Opportunity Score, and more.

Turn a pile of accounts into a stack-ranked priority list with a reason on every row. A layered score (gates first, then an evidence-weighted base rank over the signals you actually have, then bounded boosts for product usage and buyer intent) that stays fair across channels and never scores a blank field as a zero. Built for B2B GTM teams, customizable to your signals and your ICP. Trigger on "score these accounts", "rank by fit", "composite ICP score", "stack-rank my list", "who should I work first", "prioritize these leads", or any multi-signal account qualification.

End-to-end data pipeline for empirical research: fetch economic data from APIs (FRED, World Bank, IMF, BLS, OECD, Yahoo Finance), clean and transform raw data, construct strategy-specific variables, and validate panel structure. Use when asked to fetch data, download data, clean data, merge datasets, prepare analysis-ready data.

Generates award-level UI with GSAP motion, bento grids, and Python-driven randomization for layout variety.

Retrieve fundraising data from Pilt, including investor matches, campaign statistics, outreach events, and deck analysis, using a personal API key.

Write, debug, and test NumPyro probabilistic programs on JAX with correct shapes, PRNG keys, and inference choice.

Expert product strategy advisor for Senior PMs. Use this skill — proactively and without waiting to be asked — whenever defining a product vision, setting quarterly OKRs, building a roadmap, choosing between competing bets, entering a new product area, or when stakeholders disagree on direction. Also triggers for: "what should we prioritize", "we need a north star", "how do we choose between X and Y", "roadmap conflict", "what are our bets this quarter", "strategy alignment", "choosing what NOT to build", "three bets with trade-offs", "stakeholder misalignment on direction", "product direction for next quarter", "OKR planning". Produces a decision-focused strategy doc: North Star metric, Opportunity Tree, three bets with explicit trade-offs (including do nothing), and a recommended bet with its key assumption.

Inspect, profile, clean, reconcile, analyze, visualize, and verify spreadsheet data while preserving formulas, formatting, types, and source files. Use when working with .xlsx, .xlsm, .xls, .ods, .csv, or .tsv files; answering questions from a workbook; auditing formulas or data quality; comparing sheets or versions; producing pivots, charts, forecasts, or summary workbooks; repairing malformed tables; or validating that spreadsheet edits and calculations are accurate.

Pricing models, tier packaging, and willingness-to-pay research. Use when the user requests 'pricing tiers', 'freemium', 'value metric', 'pricing page', 'willing to pay', or 'van Westendorp'.

Construye pipelines ETL/ELT con Pandas: extracción, transformación y carga de datos con logging, manejo de errores, idempotencia y opciones de orquestación.

Explains term sheet key terms, SAFE/convertible note structures, cap table dilution calculations, and negotiation red flags for startup fundraising.

Convert plans/specs into independently-grabbable vertical slice issues (HITL or AFK classification)

Turn meetings into decisions, owners, open questions, and follow-ups.

Create strategic HTML presentations with Chart.js, design tokens, responsive layouts, copywriting formulas, and contextual slide strategies.

Manage Binding entities — scoped, temporal, many-to-many relationships between v2 entity surfaces. Use when a relationship needs scope, time, or its own attributes — e.g. 'Alice is the tech lead for project X from Jan to June' or 'the security gate applies to this release WorkItem only on the main branch'.

Simulates Bill Gates' cognitive framework, strategic thinking, and decision-making processes for analysis and problem-solving.

Create performance improvement plan templates. TRIGGERS - Use when user needs help with pip-template related tasks.

Break a plan, spec, or PRD into independently-grabbable issues on the project issue tracker using tracer-bullet vertical slices.

Use when designing or rewriting a high-converting SaaS pricing page (structure, plan design, copywriting, SEO/AEO, FAQs, layout patterns, experiments). Includes checklists, templates, and common pitfalls.

Retrieves fundraising data from Pilt, including investor matches, campaign stats, outreach events, and deck analysis, via a single API endpoint.

Provides MariaDB-specific syntax, atomicity, privilege requirements, and restrictions for RENAME TABLE statements, including multi-table swaps, temporary tables, and cross-database moves.

Autopsy a stuck project, extract salvageable artifacts, and route to a fresh start via $bootstrap-repo reset or new-repo bootstrap

Breaks a product requirements document into independently-grabbable GitHub issues using vertical slices, with user approval before creation.

Manage Kafka consumer groups on Redpanda with rpk group: list, describe, seek, delete groups, and delete offsets.

Builds statistical plots with the seaborn Python library and pandas DataFrame integration, on attractive matplotlib-based defaults. Use for quick exploration of distributions, relationships, and categorical comparisons — box plots, violin plots, swarm/strip plots, KDE/histograms, pair plots, joint plots, regression plots, correlation heatmaps, and faceted small multiples (relplot/displot/catplot/lmplot). For interactive/hover/zoom charts defer to alterlab-plotly; for exact journal/manuscript styling (column widths, point fonts, CMYK, vector export) defer to alterlab-scientific-viz; for low-level custom matplotlib figures defer to alterlab-matplotlib (seaborn integrates with it for fine-tuning). Part of the AlterLab Academic Skills suite.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features