csv-pipeline

Filter, join, aggregate, deduplicate, and convert CSV, TSV, and JSON data.

1|1|Updated Feb 3, 2026
One-click install
npx skills add https://github.com/gitgoodordietrying/moltbook-app --skill csv-pipeline
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: csv-pipeline
Source: https://github.com/gitgoodordietrying/moltbook-app/tree/main/skills/csv-pipeline
Command: npx skills add https://github.com/gitgoodordietrying/moltbook-app --skill csv-pipeline

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual data wrangling of CSV, TSV, and JSON datasets is error-prone, tedious, and hampers timely insights. This Skill automates common preprocessing tasks to produce clean, analyzable data with minimal effort.

Core Features & Use Cases

  • Filter rows, join datasets, and compute aggregates using standard CLI tools and Python.
  • Convert between CSV, TSV, and JSON/JSON Lines formats for interoperability.
  • Deduplicate, sort, validate, and generate summary reports to support ETL and data analysis workflows.
  • Real-world use case: clean a sales log by keeping valid records, compute total revenue by category, and export a ready-to-analyze dataset.

Quick Start

Filter data.csv to keep rows where amount > 100 and export the result as filtered.csv.

Frequently Asked Questions about csv-pipeline

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

FAQPage Schema
How do I automate filtering and joining CSV data for analysis?

To automate filtering and joining CSV data, you can use this Skill to process tabular datasets by applying row filters and joining records across files. It leverages Python 3 and standard CLI tools like awk to transform raw logs into clean, analyzable outputs.

Can I convert between JSON and CSV formats in a data pipeline?

Yes, you can convert between JSON and CSV formats within a data pipeline. This Skill handles interoperability between CSV, TSV, and JSON/JSON Lines formats, allowing you to transform structured data into your required tabular or JSON output for downstream analysis.

What is the best way to deduplicate and aggregate TSV records?

The best way to deduplicate and aggregate TSV records is using an automated data pipeline tool. This Skill computes aggregates and removes duplicate rows from TSV files using Python 3 and CLI tools, producing summarized and validated datasets for reporting.

Do I need Python 3 to run CSV data transformations, or are CLI tools enough?

You need both Python 3 and common CLI tools like awk to run these CSV data transformations. The Skill requires a Linux, macOS, or Windows environment equipped with these dependencies to execute filtering, joining, and aggregating operations on tabular data.

How do I generate summary reports from raw CSV logs?

To generate summary reports from raw CSV logs, this Skill filters valid records, computes aggregates such as total revenue by category, and exports a ready-to-analyze dataset. It automates the ETL workflow to produce clean data and summary outputs.

Are there limitations when processing large JSON Lines files with standard CLI tools?

When processing large JSON Lines files, performance depends on the memory and processing capacity of your local environment running Python 3 and CLI tools. The Skill is designed for typical data workflows, so extremely large datasets may encounter system resource constraints during transformation.