skills.rest
AIDotNet
AIDotNetOFFICIAL
Explore all skills by this author →
WebsiteGitHub

csv-processor

Processes CSV files by filtering, sorting, converting, and aggregating data.

84|15|Updated Dec 31, 2025
Search Tags:#data analysis#data transformation#data processing#pandas#csv#file conversion
One-click install
npx skills add https://github.com/AIDotNet/MoYuCode --skill csv-processor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: csv-processor
Source: https://github.com/AIDotNet/MoYuCode/tree/main/skills/tools/csv-processor
Command: npx skills add https://github.com/AIDotNet/MoYuCode --skill csv-processor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the tedious and error-prone tasks associated with manipulating CSV files, allowing users to quickly clean, transform, and analyze their data.

Core Features & Use Cases

  • Read & Display: Load and view CSV data, with options to select specific columns or limit the number of rows.
  • Filter & Sort: Easily filter rows based on column values and sort data by specified columns, supporting both ascending and descending order, as well as numeric sorting.
  • Convert Formats: Transform CSV data into other common formats like JSON, JSONL, TSV, and Markdown tables.
  • Aggregate Data: Group data by a specified column and perform aggregations such as sum, average, minimum, and maximum on other columns.
  • Use Case: You have a large CSV file of customer orders and need to find all orders from a specific region, sort them by order date, and then calculate the total sales amount for each product category.

Quick Start

Use the csv-processor skill to filter the file 'orders.csv' for rows where the 'region' column is 'North' and save the result to 'north_orders.csv'.

Frequently Asked Questions about csv-processor

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

FAQPage Schema
How do I filter and sort CSV data using Python?▼

To filter and sort CSV data, you can use Python scripts to read the file, filter rows based on specific column values, and sort the remaining data by specified columns in either ascending or descending order.

What is the best way to convert a CSV file to JSON or Markdown?▼

The best way to convert a CSV file is by using data processing scripts that read the tabular data and transform it into structured JSON, JSONL, TSV, or Markdown table formats for easier integration and display.

How do I calculate sum and average for grouped CSV columns?▼

To calculate sum and average for grouped CSV columns, you can aggregate data by grouping rows based on a specified column and applying sum, average, minimum, or maximum calculations to the other columns.

Does pandas work with large CSV files for data transformation?▼

Yes, pandas works with large CSV files for data transformation by loading the data into scripts, allowing you to select specific columns, limit the number of rows displayed, and perform efficient aggregations.

Can I extract specific columns and limit rows when processing a CSV file?▼

Yes, you can extract specific columns and limit rows when processing a CSV file by configuring the data loading script to select only the required fields and cap the output to a defined number of records.

Related Skills

Explore More Data & Analytics Skills→
alexhegitalexhegit
4

pandas-skill

Clean, analyze, and transform tabular datasets using pandas DataFrame operations.

Community
Intermediate
Wesley1600Wesley1600

data-analysis

Analyze CSV, JSON, and Parquet datasets with exploratory analysis and visualizations.

Community
Advanced
jkitchinjkitchin
34

python-plotting

Select and apply Matplotlib, Seaborn, or Plotly for Python visualizations.

Community
Intermediate
bogwarebogware
3

query-writing

Convert natural-language questions into executable SQL SELECT statements.

Official
Intermediate