csv-pipeline

Process and transform CSV, TSV, JSON, and JSON Lines files into cleaned, analyzed, and reportable datasets.

195|12|Updated Jul 19, 2026
One-click install
npx skills add https://github.com/ZJU-REAL/HugAgentOS --skill csv-pipeline-zju-real
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: csv-pipeline
Source: https://github.com/ZJU-REAL/HugAgentOS/tree/main/src/backend/skill_bundles/marketplace/csv-pipeline
Command: npx skills add https://github.com/ZJU-REAL/HugAgentOS --skill csv-pipeline-zju-real

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the manual effort involved in cleaning, transforming, analyzing, and reporting on CSV, TSV, JSON, and JSON Lines data.

Core Features & Use Cases

  • Data Transformation: Filter, sort, deduplicate, validate, and clean tabular records.
  • Analysis and Integration: Join datasets, group rows, calculate aggregates, and generate Markdown summary reports.
  • Format Conversion: Convert between CSV, TSV, JSON, and JSON Lines formats using Python's standard library.
  • Use Case: Process order and customer files by validating records, joining them on customer IDs, summarizing revenue by category, and exporting the results for review.

Quick Start

Use the csv-pipeline skill to clean the attached sales CSV, remove duplicates, summarize revenue by category, and save the results as a Markdown report.

Frequently Asked Questions about csv-pipeline

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

FAQPage Schema
How do I clean and transform messy CSV data without external dependencies?

You can clean and transform messy CSV data by applying filtering, sorting, deduplication, and validation using Python 3 and standard command-line tools without requiring external dependencies.

Can I convert JSON Lines files to CSV format using Python's standard library?

Yes, you can convert between JSON Lines and CSV formats using Python's standard library. The process handles format conversion for tabular records without needing additional packages installed.

How do I join and aggregate large TSV datasets with streaming support?

Join and aggregate large TSV datasets using streaming support to process massive files. The operation joins records on shared identifiers, groups rows, and calculates aggregates efficiently.

What is the best way to generate summary reports from tabular data?

Generate summary reports from tabular data by grouping rows, calculating aggregates, and exporting the results as a Markdown report. This summarizes metrics like revenue by category for review.

Does csv-pipeline work with JSON files for data validation and deduplication?

Yes, csv-pipeline works with JSON and JSON Lines files for data validation and deduplication. It processes tabular records to filter, clean, and remove duplicates across these formats.

Why does processing large CSV files require streaming support?

Processing large CSV files requires streaming support to avoid memory exhaustion. Streaming reads and transforms records sequentially, enabling filtering and aggregation on datasets too large for memory.