csvkit v1.0.2 Release Notes

Release Date: 2017-04-28 // about 5 years ago
  • ๐Ÿ‘Œ Improvements:

    • โž• Add a :code:--version flag.
    • โž• Add a :code:--skip-lines option to skip initial lines (e.g. comments, copyright notices, empty rows).
    • โž• Add a :code:--locale option to set the locale of any formatted numbers.
    • โž• Add a :code:--date-format option to set a strptime date format string.
    • โž• Add a :code:--datetime-format option to set a strptime datetime format string.
    • ๐Ÿ‘‰ Make :code:--blanks a common argument across all tools.
    • :code:-I is the short option for :code:--no-inference.
    • ๐Ÿ‘ :doc:/scripts/csvclean, :doc:/scripts/csvformat, :doc:/scripts/csvjson, :doc:/scripts/csvpy support :code:--no-header-row.
    • :doc:/scripts/csvclean is faster and no longer requires exponential time in the worst case.
    • ๐Ÿ‘ :doc:/scripts/csvformat supports :code:--linenumbers and --zero (no-op).
    • ๐Ÿ‘ :doc:/scripts/csvjoin supports :code:--snifflimit and :code:--no-inference.
    • ๐Ÿ‘ :doc:/scripts/csvpy supports :code:--linenumbers (no-op) and :code:--zero (no-op).
    • :doc:/scripts/csvsql adds a :code:--prefix option to add expressions like OR IGNORE or OR REPLACE following the INSERT keyword.
    • :doc:/scripts/csvsql adds a :code:--overwrite flag to drop any existing table with the same name before creating.
    • :doc:/scripts/csvsql accepts a file name for the :code:--query option.
    • ๐Ÿ‘ :doc:/scripts/csvsql supports :code:--linenumbers (no-op).
    • :doc:/scripts/csvsql adds a :code:--create-if-not-exists flag to not abort if the table already exists.
    • :doc:/scripts/csvstat adds a :code:--freq-count option to set the maximum number of frequent values to display.
    • ๐Ÿ‘ :doc:/scripts/csvstat supports :code:--linenumbers (no-op).
    • ๐Ÿ–จ :doc:/scripts/in2csv adds a :code:--names flag to print Excel sheet names.
    • :doc:/scripts/in2csv adds a :code:--write-sheets option to write the named Excel sheets to files.
    • :doc:/scripts/sql2csv adds an :code:--encoding option to specify the encoding of the input query file.

    ๐Ÿ›  Fixes:

    • :doc:/scripts/csvgrep no longer ignores common arguments if :code:--linenumbers is set.
    • ๐Ÿ‘ :doc:/scripts/csvjson supports Decimal.
    • ๐Ÿ‘ :doc:/scripts/csvpy again supports IPython.
    • โช :doc:/scripts/csvsql restores support for :code:--no-constraints and :code:--db-schema.
    • :doc:/scripts/csvstat will no longer crash when :code:--freq is set.
    • โช :doc:/scripts/in2csv restores support for :code:--no-inference for Excel files.
    • โช :doc:/scripts/in2csv restores support for converting Excel files from standard input.
    • :doc:/scripts/in2csv accepts utf-8 arguments to the :code:--sheet option in Python 2.