v0.27.0

Changes

• csvtk v0.27.0
  • csvtk:
    • code refactoring and simplifying code, with 16% less code.
    • most commands support open column range syntax, e.g., csvtk grep -f 2-. #120
    • only selected column names are not allowed to be duplicated in the input data: box, corr, filter, filter2, fold, freq, gather, historysort, inter, join, line, mutate, mutate2, rename, replace, sep, split, summary, unfold, uniq, watch. Other commands do not have the restriction. #235
    • add a new global flag -Z/--show-row-number, supported commands: cut, csv2tab, csv2xlsx, tab2csv, pretty.
    • the colum name of row number changes from "n" to "row": csv2xlsx, csv2tab, cut, filter, filter2, grep, pretty, sample, tab2csv.
  • new command:
    • csvtk spread: spread a key-value pair across multiple columns, like tidyr::spread/pivot_wider.
      #91, #236, #239
  • csvtk mutate/mutate2:
    • new flags --at, --before, --after for specifying the position of the new column. #193
  • csvtk cut:
    • fix unselect range error. #234
    • fix -i/--ignore-case.
  • csvtk pretty:
    • allow align-center and align-right for specific columns. #240
  • csvtk round:
    • fix bug of failing to round scientific notation with value small than one, e.g., 7.1E-1.
  • csvtk summary:
    • fix duplicated columns.
    • fix result error when multiple stats applied to the same column.
  • csvtk corr/watch:
    • rewrite and fix bug, support choosing fields with column names.