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.