csv-processor

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'.