تخطَّ إلى المحتوى
TakoAPI
العودة إلى المهارات

csv-pipeline

بواسطة gitgoodordietrying

Data & Analytics
3.4kالتنزيلات وفق ما يذكره clawskills.sh
1النجوم
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

شغّل أمر واجهة سطر الأوامر، أو الصق النص في Claude Code أو Cursor أو Codex أو أي وكيل برمجة تستخدمه.

الروابط