csvtk v0.28.0

Changes

• csvtk v0.28.0
  • csvtk:
    • add the shortcut -X for the flag --infile-list. #249
  • csvtk pretty:
    • support field ranges for -m/--align-center and -r/--align-right. #244
  • csvtk spread:
    • support values sharing the same keys. #248
  • csvtk join:
    • a new flag -P/--prefix-duplicates: add filenames as colname prefixes only for duplicated colnames. #246
  • csvtk mutate2:
    • fix changing the order of the header row, the code was accidentally missing during code refactoring in v0.27.0. #252
  • csvtk xlsx2csv:
    • fix open /tmp/excelize-: no such file or directory error for big .xlsx files. #251
  • csvtk comb:
    • fix the empty result bug for alphabet sizes greater than 64.

csvtk v0.27.2

Changes

• csvtk v0.27.2

  • csvtk pretty:

    • fix the bug of empty first row with -H/--no-header-row, introduced in v0.27.0.

    • new style 3line for three-line table.

      $ csvtk pretty names.csv -S 3line
       ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
        id   first_name   last_name   username
       ----------------------------------------
        11   Rob          Pike        rob
        2    Ken          Thompson    ken
        4    Robert       Griesemer   gri
        1    Robert       Thompson    abc
        NA   Robert       Abel        123
       ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
      

  • csvtk csv2xlsx:

    • binaries compiled with go1.21 would result in a broken xlsx file. #243

  • csvtk splitxlsx:

    • fix the error of invalid worksheet index. #1617

csvtk v0.27.1

Changes

• csvtk v0.27.1
  • csvtk filter2/mutate2:
    • fix the bug of selecting with field numbers. #242

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.

csvtk v0.26.0

Changes

• csvtk v0.26.0
  • csvtk:
    • near all commands skip empty files now. #204
    • the global flag --infile-list accepts stdin "-". #210
  • new command csvtk fix: fix CSV/TSV with different numbers of columns in rows. #226
  • csvtk pretty: rewrite to support wrapping cells. #206 #209 #228
  • csvtk cut/fmtdate/freq/grep/rename/rename2/replace/round: allow duplicated column names.
  • csvtk csv2xlsx: optionally stores numbers as float. #217
  • csvtk xlsx2csv: fix bug where xlsx2csv treats small number (padj < 1e-25) as 0. It's solved by updating the excelize package. #261
  • csvtk join: a new flag for adding filename as column name prefix. by @tetedange13 #202
  • csvtk mutate2: fix wrongly treating strings like E10 as numbers in scientific notation. #219
  • csvtk sep: fix the logic. #218
  • csvtk space2tab: fix "bufio.Scanner: token too long". #231

csvtk v0.25.0

Changes

• csvtk v0.25.0
  • csvtk: report empty files.
  • csvtk join: fix loading file with no records.
  • csvtk filter2/muate2:
    • support variable format of ${var} with special charactors including commas, spaces, and parentheses, e.g., ${a,b}, ${a b}, or ${a (b)}. #186
  • csvtk sort: fix checking non-existed fileds.
  • csvtk plot box/hist/line: new flag --skip-na for skipping missing data. #188
  • csvtk csv2xlsx: stores number as float. #192
  • csvtk summary: new functions argmin and argmax. #181

csvtk v0.24.0

Changes

• csvtk v0.24.0
  • Incompatible changes:
    • csvtk mutate2/summary:
      • mutate2: remove the option -L/--digits.
      • use the same option -w/--decimal-width to limit floats to N decimal points.
  • new command csvtk fmtdate: format date of selected fields. #159
  • csvtk grep: fix bug for searching with -r -p ..
  • csvtk csv2rst: fix bug for data containing unicode. #137
  • csvtk filter2: fix bug for date expression. #146
  • csvtk mutate2/filter2:
    • change the way of rexpression evaluation.
    • add custom functions: len(). #153
    • fix bug when using two or more columns with common prefixes in column names. #173
    • fix value with single or double quotes. #174
  • csvtk cut: new flags -m/--allow-missing-col and -b/--blank-missing-col. #156
  • csvtk pretty: still add header row for empty column.
  • csvtk csv2md: better format.
  • csvtk join: new flag -n/--ignore-null. #163

csvtk v0.23.0

Changes

• csvtk v0.23.0
  • new comand: csvtk csv2rst for converting CSV to reStructuredText format. #137
  • csvtk pretty: add header separator line. #123
  • csvtk mutate2/summary: fix message and doc. Thanks @VladimirAlexiev #127
  • csvtk mutate2: fix null coalescence: ??. #129
  • csvtk genautocomplete: supports bash|zsh|fish|powershell. #126
  • csvtk cat: fix progress bar. #130
  • csvtk grep: new flag immediate-output.
  • csvtk csv2xlsx: fix bug for table with > 26 columns. 138

csvtk v0.22.0

Changes

• csvtk v0.22.0
  • csvtk:
    • global flag -t does not overide -D anymore. #114
    • If the executable/symlink name is tsvtk the -t/--tabs option for tab input is set. Thanks @bsipos. #117
  • new command: csvtk csv2xlsx for converting CSV/TSV file(s) to a single .xlsx file.
  • new command: csvtk unfold for unfolding multiple values in cells of a field. #103
  • rename csvtk collapse to csvtk fold, for folding multiple values of a field into cells of groups.
  • csvtk cut: support range format 2- to choose 2nd column to the end. #106
  • csvtk round: fix bug of failing to round scientific notation with value small than one, e.g., 7.1E-1.

csvtk v0.21.0

Changes

• csvtk v0.21.0
  • new command: csvtk nrow/ncol for printing number of rows or columns.
  • new command: round to round float to n decimal places. #112
  • csvtk headers: file name and column index is optional outputted with new flag -v/--verbose.
  • csvtk dim: new flags --tabluar, --cols, --rows, -n/--no-files.
  • csvtk dim/ncol/nrow: can handle empty files now. #108
  • csvtk csv2json #104:
    • new flag -b/--blank: do not convert "", "na", "n/a", "none", "null", "." to null
    • new flag -n/--parse-num: parse numeric values for nth column(s), multiple values are supported and "a"/"all" for all columns.
  • csvtk xlsx2csv: fix output for ragged table. #110
  • csvtk join: fix bug for joining >2 files.
  • csvtk uniq: new flag -n/--keep-n for keeping first N records of every key.
  • csvtk cut: support repeatedly selecting columns. #106