xsv

What problem does it solve?

This Skill eliminates the frustration of slow, memory-intensive CSV processing with traditional tools. It provides a Rust-powered, command-line toolkit for lightning-fast data manipulation, enabling you to handle large datasets efficiently and automate complex transformations.

Core Features & Use Cases

• High-Performance Filtering & Selection: Quickly select columns, filter rows by regex, and slice data ranges, even on multi-gigabyte files, with optional indexing for extreme speed.
• Data Analysis & Statistics: Compute comprehensive statistics (mean, min, max, stddev, median, mode) and generate frequency tables for deep insights into your data.
• Joining & Transformation: Combine multiple CSV files with various join types, concatenate data, sort records, and reformat output to different delimiters.
• Use Case: Take a multi-gigabyte sales_data.csv file, extract only the 'CustomerID', 'Product', and 'Revenue' columns, filter for sales over $1000, and then calculate the total revenue per product, all in seconds.

Quick Start

From the 'data.csv' file, view the column headers, then count the total number of records.