csv-workbench

Analyze CSV data to compute numeric summaries with Python's standard library.

Updated Dec 6, 2016
One-click install
npx skills add https://github.com/majunbao/learn --skill csv-workbench-majunbao
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: csv-workbench
Source: https://github.com/majunbao/learn/tree/main/openai-agents-python_tags/openai-agents-python-0.14.6/examples/tools/skills/csv-workbench
Command: npx skills add https://github.com/majunbao/learn --skill csv-workbench-majunbao

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze CSV files in /mnt/data and return concise numeric summaries.

Core Features & Use Cases

  • Inspect the CSV schema first to understand columns and data types.
  • Compute aggregates and summaries (counts, sums, means, mins, maxs) with a lightweight Python script.
  • Return concise results with concrete numbers and units when applicable.

Quick Start

Ask it to analyze your CSV in /mnt/data and return a concise numeric summary of key columns.

Frequently Asked Questions about csv-workbench

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I get a quick numeric summary of a CSV file?

Summarizing CSV data involves computing aggregates like counts, sums, means, mins, and maxes. This Skill reads tabular data directly, handles missing or malformed values with explicit assumptions, and outputs concise numeric results.

How do I compute aggregates for tabular data with missing values?

When analyzing CSV data with missing values, the tool applies explicit assumptions to handle malformed entries. It computes statistics like mean and sum using Python's standard csv and statistics libraries, returning clean numeric summaries.

Can I use Python to analyze small to medium CSV datasets for routine audits?

Analyzing small to medium CSV datasets for routine audits is supported natively. Using Python's standard library, it computes numeric summaries for finance, operations, and analytics tasks, returning concise results for quick checks.

What is the best way to inspect a CSV schema before computing statistics?

Inspecting a CSV schema before computing statistics involves reading the header row to understand columns and data types. This schema inspection precedes the aggregation step to ensure accurate numeric summaries.

Does lightweight CSV analysis work without installing external dependencies?

Lightweight CSV analysis works without external dependencies by leveraging Python's standard csv and statistics modules. It computes aggregates directly on local files, requiring zero setup or third-party library installations.

What are the limitations of using standard library modules for tabular data analysis?

Using standard library modules for tabular data analysis limits you to small to medium datasets and requires explicit assumptions for malformed values. It is optimized for quick numeric checks and routine audits, not large-scale data processing.