跳到正文
TakoAPI
返回技能列表

csv-pipeline

由 gitgoodordietrying 提供

Data & Analytics
3.4k下载量由 clawskills.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 或你在用的任意编程智能体里。

链接