Changes

• csvtk v0.38.0
  • csvtk:
    • correct help text, documentation examples, and spelling.
    • added a new flag --quote-all to quote all output fields, even when not necessary. #297
  • new commands:
    • csvtk csv2html: convert CSV/TSV to a standalone responsive HTML table. #132
    • csvtk long2matrix: convert the long format to a matrix. #91
    • csvtk matrix2long: convert a matrix to the long format.
    • csvtk paste: paste CSV/TSV files by columns. #139
  • csvtk filter/filter2/mutate2/mutate3/sort/summary/round:
    • fix wrongly converting . to the number zero. #359
  • csvtk cut:
    • support -Z/--show-row-number. #360
    • if there's only one input file, it will be directly outputted.
  • csvtk corr:
    • write correlations to stdout or -o by default; with --pass, keep forwarding input to output and writing correlations to stderr. #370
  • csvtk sort:
    • support sorting by Unicode text length with -k field:l and reverse order with -k field:lr. #357
  • csvtk concat:
    • add --original-file to append each row's input filename. #369
  • csvtk unfold:
    • support unfolding multiple fields in parallel. #363
  • csvtk fold:
    • support folding multiple value fields in parallel. #320 #363
  • csvtk mutate2:
    • fix the function len for Unicode strings. #368
  • csvtk join/freq/inter/uniq/summary/fold/spread/replace:
    • fix rare collisions between multi-column keys, when a field contains _shenwei356_.
  • csvtk join:
    • fix -n for empty fields in multi-column keys and retain unmatched rows in left and outer joins.
    • retain columns from header-only input files in outer joins. #266
  • csvtk uniq:
    • add -d/--repeated to print one record per repeated key and -u/--unique to print records whose keys occur exactly once. #133
    • use --delimiter instead of -d to set the input delimiter for this command.
  • csvtk freq:
    • make -i ignore case.
  • csvtk summary:
    • add -n/--names to rename summary columns. #273
    • preserve input row positions for argmin and argmax when used with quantiles.
  • csvtk split:
    • add -n/--nlines to split input into chunks containing up to N records, and -c/--nchunks to distribute records among N chunks in a round-robin manner. An input header row is repeated in every chunk. #122
    • encode key values in output filenames to prevent collisions and invalid paths.
  • csvtk splitxlsx:
    • generate distinct, valid sheet names for keys that produce the same name.

Notes

• please open an issue to request binaries for other platforms.
• run csvtk version to check update !!!
• run csvtk genautocomplete to update shell autocompletion script !!!

Changes

• csvtk v0.37.0
  • csvtk:
    • add support of reading and writing LZ4 compression format. #353
  • csvtk cut:
    • allow setting -f/--fields multiple times, useful for selecting a long column list.
  • csvtk csv2jon:
    • fix -b/--blanks and -n/--parse-num. #352
    • add a new flag -K/--skip-key to skip putting KEY in the data when using -k KEY. #351
  • csvtk pretty:
    • add a new style regular.
    • adjust styles 3line and round.

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changelog

• csvtk v0.36.0
  • new command csvtk shuf: shuffle rows. #151
  • csvtk plot line/hist/bar/box
    • forgot to scale the font size of legend keys.
  • csvtk pretty
    • fix formatting unicode text.

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.35.0
  • csvtk:
    • do not support i386 architecture anymore.
  • csvtk sort:
    • sort on all columns by default, with a similar way with GNU sort (but the results might be different). #337
    • support field ranges, e.g., -k 1-3:N.
    • fix sort inconsistency for rows with the same key(s). #337
  • csvtk mutate2/filter2:
    • use a new fork of expression evaluation package. #172
  • csvtk filter2:
    • fix the panic when using -Z. #332
  • csvtk plot bar:
    • fix labels orders #335, #339.
  • csvtk summary:
    • support field range, e.g., -f 2-5:sum #143

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.34.0
  • new command csvtk plot bar. Contributed by @lovromazgon #323
  • csvtk:
    • fix panic when the first field is empty, e.g., -f ,2,3.
  • csvtk cut:
    • fix -b. #156
    • fix -i. #317
  • csvtk plot box:
    • fix --horiz does not swap axes labels. #314
  • csvtk plot line:
    • add a new flag --data-field-x-nominal to plot line with sortable nominal X axis values, such as date.
      #308 by @lovromazgon
  • csvtk plot:
    • add two new flags --hide-x-labs and --hide-y-labs, for hiding X/Y axis, ticks, and tick labels. #326
  • csvtk fix:
    • add a new flag --na to set content to fill. #316
  • csvtk replace:
    • add new replacements symbol/placeholder for group-specific numbering: {gnr}, {enr}, {rnr}. #322
  • csvtk sort:
    • add support for sorting by date/time. #278

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.33.0
  • new command csvtk comma: make numbers more readable by adding commas. #300
  • csvtk:
    • add a global flag -V/--version. #304
  • csvtk plot box/hist/line:
    • adds --x-scale-ln and --y-scale-ln for natural log scaling of the X & Y axes. #302#302) by @xxxserxxx
  • csvtk fold:
    • allow folding fields with no separater. #299 by @fgvieira
  • csvtk summary:
    • numbers in scientific notation are output as is.

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.32.0
  • csvtk filter2/mutate2/mutate3:
    • fix a bug of mismatch between column names and values which was brought in v0.31.1. #295
    • add some unit tests.
  • csvtk pretty:
    • -w/--min-width and -W/--max-width accept multiple values for setting column-specific thresholds.
    • add a new format style round for round corners.

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.31.1
  • csvtk filter2/mutate2/mutate3:
    • fix the slow speed, I was stupid before. #269
  • csvtk csv2json:
    • further fix values with double quotes and new line symbols. #291

Notes

• run csvtk version to check update !!!
• run csvtk genautocomplete to update Bash completion !!!

Changes

• csvtk v0.31.0
  • csvtk sort/join:
    • faster speed and lower memory.
  • csvtk sort:
    • do not panic for empty input. #287
  • csvtk summary:
    • fix the order of columns. #282
  • csvtk rename2:
    • fix -n/--start-num. #286
    • add flag --nr-width.
  • csvtk replace:
    • fix implementing {nr}. #286
  • csvtk csv2json:
    • fix values with double quotes and new line symbols.
  • csvtk split:
    • support customize output file prefix and subdirectory from prefix of keys. #288
  • csvtk spread:
    • add a new alias "scatter" to "spread". #265
  • csvtk grep:
    • do not show progress.
  • csvtk fix-quotes:
    • new flag -b, --buffer-size.
  • csvtk plot:
    • new flag --scale for scaling the image width/height, tick, axes, line/point and font sizes proportionally, adviced by @tseemann.
  • csvtk plot line:
    • only add legend for more than one group. #279
    • sort points by X for plotting lines. #280
  • csvtk hist:
    • new flags: --line-width.
  • csvtk box:
    • plots of different groups have different colors now.
    • new flags: --line-width, --point-size, and color-index.

Changes

• csvtk v0.30.0
  • csvtk:
    • grouping subcommands in help message.
    • add a new global flag --quiet. #261
    • add a new global flag -U, --delete-header for disable outputing the header row. Supported commands: concat, csv2tab/tab2csv, csv2xlsx/xlsx2csv, cut, filter, filter2, freq, fold/unfold, gather, fmtdate, grep, head, join, mutate, mutate2, replace, round, sample. #258
    • support more commands with -Z/--show-row-number: head.
  • csvtk dim:
    • fix duplicated rows for multiple input files, this bug was introduced in v0.27.0.
  • csvtk concat:
    • fix panic when no data found. #259
  • csvtk spread:
    • fix flag checking of -k and -v.
  • csvtk sort:
    • fix ordering when given multiple custom levels.
  • csvtk filter/filter2:
    • fix printing row number with -Z.
  • csvtk xls2csv:
    • output raw data. #262
  • csvtk pretty:
    • change the default value of -n/--buf-rows from 128 to 1024, and 0 for loading all data.
  • csvtk join:
    • new flag -s/--suffix for adding suffixes to colnames from each file. #263