sacsv: Swiss Army csv

This Python package provides an assortment of command-line tools to manipulate csv-formatted data. The tools are:

• csv2jsonl: converts csv input into jsonlines
• csvaddrandom: adds a column with a random number
• csvadduniqueid: adds a column with a unique record identifier
• csvaggregate: applies an arbitrary Python function to every value of a column, possibly within groups
• csvappend: appends two or more csv files
• csvdropdups: drops duplicate records
• csvfindsortkey: attempts to find the column that the input is sorted by
• csvkeepmax: keeps the record that has the maximum value in a column
• csvleftjoin: merges two csv files
• csvop: applies an arbitrary Python function to every record and saves the return value in a new column
• csvparallel: parallelizes arbitrary commands that read a csv input and write a csv output
• csvrename: changes the name of a column
• csvreorder: changes the order of columns
• csvsed: applies a substitution rule, using regular expressions, to every value of a column
• csvsort: sorts the input
• csvtranspose: transposes the input
• fw2csv: converts fixed-width input, potentially with multi-line records, into csv
• longcsv2wide: converts the input from long to wide form
• widecsv2long: converts the input from wide to long form

Each tool's help message contains brief examples that demonstrate usage. For example, csvop:

Installation

To install this package using uv, type

uv tool install sacsv

or using pip,

pip install git+https://github.com/gn0/sacsv

or, alternatively,

git clone https://github.com/gn0/sacsv
pip install ./sacsv

Author

Gabor Nyeki. Contact information is on http://www.gabornyeki.com/.

License

This package is licensed under the Creative Commons Attribution 4.0 International License: http://creativecommons.org/licenses/by/4.0/.

The picture at the top of this README is based on Andrew Toskin's 2014 photo which is distributed under CC BY-SA 4.0.