Command-line tools for working with CSV
csvkit is a suite of command-line tools for converting to and working with CSV. It provides the following commands:
Input:
in2csv
: Convert various formats to CSV.
sql2csv
: Execute SQL commands on a database and return the data as CSV.
Processing:
csvclean
: Remove common syntax errors.
csvcut
: Filter and truncate CSV files.
csvgrep
: Filter tabular data to only those rows where certain columns contain a given value or match a regular expression.
csvjoin
: Merges two or more CSV tables together using a method analogous to SQL JOIN operation.
csvsort
: Sort CSV files.
csvstack
: Stack up the rows from multiple CSV files, optionally adding a grouping value to each row.
Output and analysis:
csvformat
: Convert a CSV file to a custom output format.
csvjson
: Converts a CSV file into JSON or GeoJSON.
csvlook
: Renders a CSV to the command line in a Markdown-compatible, fixed-width format.
csvpy
: Loads a CSV file into a agate.csv.Reader
object and then drops into a Python shell so the user can inspect the data however they see fit.
csvsql
: Generate SQL statements for a CSV file or execute those statements directly on a database.
csvstat
: Prints descriptive statistics for all columns in a CSV file.
System | Target | Derivation | Build status |
---|---|---|---|
x86_64-linux | /gnu/store/4gd75fj93qzdgbk2rhybw08gsfsfgwyv-csvkit-1.1.1.drv | ||
riscv64-linux | /gnu/store/bm3kbbf9gpiws5fzmrpmz0ihq4hibz2g-csvkit-1.1.1.drv | ||
powerpc-linux | /gnu/store/xrs8hjby91p6z2fsq5wb28q0zpzz06vl-csvkit-1.1.1.drv | ||
powerpc64le-linux | /gnu/store/j2zskmymca8y9yh2li8aw0k98ml817v0-csvkit-1.1.1.drv | ||
mips64el-linux | /gnu/store/w43n673ysrl06k4all276slyyzp8j5rk-csvkit-1.1.1.drv | ||
i686-linux | /gnu/store/0kxa3q1xlcnhrh1zg6i2qmf6nicm2kjl-csvkit-1.1.1.drv | ||
i586-gnu | /gnu/store/1nb33f1qaksi7w0d8bafq9ac2z7wa0yj-csvkit-1.1.1.drv | ||
armhf-linux | /gnu/store/fwi77lhn8slk55lcipjl8xy46njhwmnh-csvkit-1.1.1.drv | ||
aarch64-linux | /gnu/store/xbpkm6srzzbplf2c747rrpqyrrblajh4-csvkit-1.1.1.drv |
Linter | Message | Location |
---|---|---|
No lint warnings ✓ |