xsv
Xsv is a powerful and versatile command-line tool that is used for working with structured data like CSV, TSV, and more. It is designed to perform data manipulation, analysis, and exploration tasks efficiently. With xsv, you can perform a wide range of operations on CSV files, such as selecting, filtering, sorting, joining, and transforming data. It supports advanced features like column extraction, CSV statistics, data sampling, and searching. Xsv is written in Rust, which makes it extremely fast and efficient, even when dealing with large datasets. It has a simple and intuitive syntax, making it easy to use for both beginners and advanced users. Due to its command-line nature, it is highly scriptable and can be seamlessly integrated into automated data workflows. The tool provides extensive documentation and examples, making it easy to learn and effectively utilize its features. Xsv is cross-platform and can be installed on major operating systems like Windows, macOS, and Linux. Overall, xsv is a valuable tool for anyone working with structured data, offering powerful functionalities to manipulate, analyze, and explore CSV and other tabular file formats.
List of commands for xsv:
-
xsv:tldr:0e4cc xsv: Count the number of entries.$ xsv count ${filename-csv}try on your machineexplain this command
-
xsv:tldr:5778b xsv: Show 10 random entries.$ xsv sample ${10} ${filename-csv}try on your machineexplain this command
-
xsv:tldr:624bf xsv: Select a few columns.$ xsv select ${column_a,column_b} ${filename-csv}try on your machineexplain this command
-
xsv:tldr:b3428 xsv: Inspect the headers of a file.$ xsv headers ${filename-csv}try on your machineexplain this command
-
xsv:tldr:d005c xsv: Join a column from one file to another.$ xsv join --no-case ${column_a} ${filename-a-csv} ${column_b} ${filename-b-csv} | xsv tabletry on your machineexplain this command
-
xsv:tldr:d78ef xsv: Get an overview of the shape of entries.$ xsv stats ${filename-csv} | xsv tabletry on your machineexplain this command