Csvtk Versions Save

A cross-platform, efficient and practical CSV/TSV toolkit in Golang

v0.22.0

3 years ago

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.

v0.21.0

3 years ago

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

v0.20.0

4 years ago

Changes

csvtk v0.20.0
- new command csvtk comb: compute combinations of items at every row.
- new command csvtk sep: separate column into multiple columns. #96
- csvtk:
  - list lines' number of illegal (-I) and empty (-E) rows. #97
  - new flag --infile-list for giving file of input files list (one file per line), if given, they are appended to files from cli arguments
- csvtk join:
  - reenable flag -i/--ignore-case. #99
  - outer join is supported. #23
  - new flag -L/--left-join: left join, equals to -k/--keep-unmatched, exclusive with --outer-join
  - new flag -O/--outer-join: outer join, exclusive with --left-join
  - rename flag --fill to --na.
- csvtk filter2: fix bug when column names start with digits, e.g., 1000g2015aug. Thank @VorontsovIE (#44)
- csvtk concat: allow one input file. #98
- csvtk mutate: new flag -R/--remove for removing input column.

v0.19.1

4 years ago

Changes

csvtk v0.19.1
- csvtk:
  - fix checking file existence.
  - show friendly error message when giving empty field like csvtk cut -f a, b.
- csvtk summary: fix err of q1 and q3. #90
- csvtk version: making checking update optional.

v0.19.0

4 years ago

Changes

csvtk v0.19.0
- new commands by @bsipos:
  - watch: online monitoring and histogram of selected field.
  - corr: calculate Pearson correlation between numeric columns.
  - cat: stream file and report progress.
- csvtk split: fix bug of repeatedly output header line when number of output files exceed value of --buf-groups. #83
- csvtk plot hist: new option --percentiles to add percentiles to histogram x label. #88

v0.18.2

4 years ago

Changes

csvtk v0.18.2
- csvtk replace/rename2/splitxlsx: fix flag conflicts with global flag -I since v0.18.0.
- csvtk replace/rename2: removing shorthand flag -I for --key-capt-idx.
- csvtk splitxlsx: changing shorthand flag of --sheet-index from -I to -N.

v0.18.1

5 years ago

Changes

csvtk v0.18.1
- csvtk sort: fix mutiple-key-sort containing natural order sorting. #79
- csvtk xlsx2csv: reacts to global flags -t, -T, -D and -E. #78

v0.18.0

5 years ago

Changes

csvtk v0.18.0
- csvtk: add new flag --ignore-illegal-row to skip illegal rows. #72
- csvtk summary: add more textual/numeric operations. #64
- csvtk sort: fix bug for sorting by columns with empty values. #70
- csvtk grep: add new flag --delete-matched to delete a pattern right after being matched, this keeps the firstly matched data and speedups when using regular expressions. #77

v0.17.0

5 years ago

Changes

csvtk v0.17.0
- new command: csvtk add-header and csvtk del-header for adding/deleting column names. #62

v0.16.0

5 years ago

Changes

csvtk v0.16.0
- new command: csvtk csv2json: convert CSV to JSON format.
- remove comand: csvtk stats2.
- new command csvtk summary: summary statistics of selected digital fields (groupby group fields), usage and examples. #59
- csvtk replace: add flag --nr-width: minimum width for {nr} in flag -r/--replacement. e.g., formating "1" to "001" by --nr-width 3 (default 1)
- csvtk rename2/replace: add flag -A, --kv-file-all-left-columns-as-value, for treating all columns except 1th one as value for kv-file with more than 2 columns. #56