1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
=========
Reference
=========
csvkit is composed of command-line tools that can be divided into three major categories: Input, Processing, and Output. Documentation and examples for each tool are described on the following pages.
Input
=====
.. toctree::
:maxdepth: 1
scripts/in2csv
scripts/sql2csv
Processing
==========
.. toctree::
:maxdepth: 1
scripts/csvclean
scripts/csvcut
scripts/csvgrep
scripts/csvjoin
scripts/csvsort
scripts/csvstack
.. seealso::
To deduplicate and merge CSV files, consider `csvdedupe <https://pypi.org/project/csvdedupe/>`_.
To change field values (i.e. to run ``sed`` or ``awk``-like commands on CSV files), consider `qsv <https://github.com/jqnatividad/qsv>`_'s ``replace`` command or `miller <https://miller.readthedocs.io/en/latest/>`_ (``mlr put``).
To transpose CSVs, consider `qsv <https://github.com/jqnatividad/qsv>`_'s ``flatten`` command or `miller <https://miller.readthedocs.io/en/latest/>`_'s `XTAB <https://miller.readthedocs.io/en/latest/file-formats/#xtab-vertical-tabular>`_ support (``mlr --oxtab``).
Output and Analysis
===================
.. toctree::
:maxdepth: 1
scripts/csvformat
scripts/csvjson
scripts/csvlook
scripts/csvpy
scripts/csvsql
scripts/csvstat
* To draw plots, consider `jp <https://github.com/sgreben/jp>`_.
* To diff CSVs, consider `daff <https://github.com/paulfitz/daff>`_.
* To explore CSVs interactively, consider `VisiData <https://visidata.org>`_.
Alternatives to :doc:`/scripts/csvsql` are `q <https://github.com/harelba/q>`_ and `textql <https://github.com/dinedal/textql>`_.
Common arguments
================
.. toctree::
:maxdepth: 2
common_arguments
|
