Skip to content

cli.rst

Latest commit

 

History

History
62 lines (43 loc) · 1.69 KB

cli.rst

File metadata and controls

62 lines (43 loc) · 1.69 KB
Raw

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.
  • To diff CSVs, consider daff.
  • To explore CSVs interactively, consider VisiData.

Alternatives to :doc:`/scripts/csvsql` are q and textql.

Common arguments

.. toctree::
    :maxdepth: 2

    common_arguments