A cross-platform, efficient and practical CSV/TSV toolkit in Golang
csvtk
:
--quiet
. #261
-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
-Z/--show-row-number
: head.csvtk dim
:
csvtk concat
:
csvtk spread
:
-k
and -v
.csvtk sort
:
csvtk filter/filter2
:
-Z
.csvtk xls2csv
:
csvtk pretty
:
-n/--buf-rows
from 128 to 1024, and 0 for loading all data.csvtk join
:
-s/--suffix
for adding suffixes to colnames from each file. #263
OS | Arch | File, 中国镜像 | Download Count |
---|---|---|---|
Linux | 32-bit | csvtk_linux_386.tar.gz, 中国镜像 |
|
Linux | 64-bit | csvtk_linux_amd64.tar.gz, 中国镜像 |
|
Linux | 64-bit | csvtk_linux_arm64.tar.gz, 中国镜像 |
|
macOS | 64-bit | csvtk_darwin_amd64.tar.gz, 中国镜像 |
|
macOS | arm64 | csvtk_darwin_arm64.tar.gz, 中国镜像 |
|
Windows | 32-bit | csvtk_windows_386.exe.tar.gz, 中国镜像 |
|
Windows | 64-bit | csvtk_windows_amd64.exe.tar.gz, 中国镜像 |
Notes
csvtk version
to check update !!!csvtk genautocomplete
to update Bash completion !!!fix-quotes
: fix malformed CSV/TSV caused by double-quotes. #260
del-quotes
: remove extra double-quotes added by fix-quotes
.csvtk del-header
:
csvtk concat
:
csvtk sort
:
csvtk filter2
:
csvtk plot
:
--tick-label-size
.csvtk pretty
:
csvtk
:
-X
for the flag --infile-list
. #249
csvtk pretty
:
-m/--align-center
and -r/--align-right
. #244
csvtk spread
:
csvtk join
:
-P/--prefix-duplicates
: add filenames as colname prefixes only for duplicated colnames. #246
csvtk mutate2
:
csvtk xlsx2csv
:
open /tmp/excelize-: no such file or directory
error for big .xlsx
files. #251
csvtk comb
:
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
:
csvtk splitxlsx
:
invalid worksheet index
. #1617
csvtk
:
csvtk grep -f 2-
. #120
-Z/--show-row-number
, supported commands: cut, csv2tab, csv2xlsx, tab2csv, pretty.csvtk mutate/mutate2
:
--at
, --before
, --after
for specifying the position of the new column. #193
csvtk cut
:
-i/--ignore-case
.csvtk pretty
:
csvtk round
:
7.1E-1
.csvtk summary
:
csvtk corr/watch
:
csvtk
:
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
: report empty files.csvtk join
: fix loading file with no records.csvtk filter2/muate2
:
${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 mutate2/summary
:
mutate2
: remove the option -L/--digits
.-w/--decimal-width
to limit floats to N decimal points.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
:
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 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