A fast CSV command line toolkit written in Rust for indexing, slicing, and joining.
xsv is a fast and efficient command line tool for working with CSV files, offering over 20 specialized commands for indexing, slicing, analyzing, splitting and joining CSV data. Note that xsv is now unmaintained, with the maintainer recommending qsv or xan as alternatives. However, it remains a powerful tool that emphasizes simplicity, performance, and composability in CSV operations.
The tool excels at handling large datasets through its indexing system, which enables constant-time operations on CSV files and dramatically speeds up tasks like slicing and statistics generation. Commands include basic operations like counting rows and selecting columns, as well as advanced features like frequency analysis, joins, sampling, and statistical summaries. Performance is a key focus - for example, statistics that might take 2 minutes in other CSV tools complete in just 8 seconds with xsv.
xsv is designed for data analysts, researchers, and developers who regularly work with CSV files and need fast, reliable command-line tools for data processing. Its composable design allows users to chain commands together efficiently, making it suitable for both simple one-off tasks and complex data processing pipelines. The tool supports features like elastic tabstops for aligned output, regex searching, and various join operations.
# via Cargo
cargo install xsv