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

Installation

To install this package using pip, type

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

or, alternatively,

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

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

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