본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

csv-pipeline

gitgoodordietrying 제작

Data & Analytics
3.4kclawskills.sh가 보고한 다운로드 수
1스타
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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

설명

이 스킬이 하는 일

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.

사용 시점

  • 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

예시 워크플로

입력

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

에이전트
  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

출력

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

설치

clawhub install gitgoodordietrying/csv-pipeline

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크