Bỏ qua tới nội dung
TakoAPI
Quay lại kỹ năng

csv-pipeline

bởi gitgoodordietrying

Data & Analytics
3.4kLượt tải do clawskills.sh công bố
1Sao
0Lượt xem
0 lượt thíchĐăng nhập để thích kỹ năng này
—Chưa có đánh giá
Đánh giá của bạn

Tóm tắt

Process, transform, analyze, and report on CSV and JSON.

Mô tả

Kỹ năng này làm gì

Process and transform tabular data in CSV, TSV, or JSON formats using Python 3 and standard shell tools. Supports filtering, joining, aggregating, deduplicating, format conversion, and Markdown report generation. No external libraries required.

Covers the full ETL cycle, including streaming large files, without requiring pandas, a database, or any package installs beyond Python 3.

Khi nào nên dùng

  • Filtering sales records by amount threshold
  • Joining customer and order datasets on a shared ID column
  • Converting JSON API exports to CSV for use in spreadsheets
  • Deduplicating an email list before a campaign send
  • Generating grouped summary reports from transaction logs

Quy trình ví dụ

ĐẦU VÀO

User asks: I have orders.csv and customers.csv, join them on customer_id and summarize revenue by category

AGENT
  1. 1

    Read both CSV files into lists of dicts using read_csv()

  2. 2

    Left join orders to customers on the customer_id column

  3. 3

    Aggregate the joined rows by category, summing the revenue field

  4. 4

    Write the aggregated results to summary.csv

  5. 5

    Generate a Markdown report table with count, sum, avg, min, and max per category

ĐẦU RA

summary.csv with per-category revenue totals and report.md with a formatted breakdown table

Cài đặt

clawhub install gitgoodordietrying/csv-pipeline

Chạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.

Liên kết