csvtk v0.2.8

pretty

Usage

convert CSV to readable aligned table

Usage:
  csvtk pretty [flags]

Flags:
  -r, --align-right        align right
  -s, --separator string   fields/columns separator (default "   ")

Examples:

1. default

   $ csvtk pretty names.csv
   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
   

2. align right

   $ csvtk pretty names.csv -r
   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
   

3. custom separator

   $ csvtk pretty names.csv -s " | "
   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 v0.2.7

- fix highlight failing in windows

csvtk v0.2.6

- fix one error message of `grep`
- highlight matched fields in result of `grep`

csvtk v0.2.5

Changes

- fix bug of `stat` that failed to considerate files with header row
- add subcommand `stat2` - summary of selected number fields
- make the output of `stat` prettier

stat2

Usage

summary of selected number fields: num, sum, min, max, mean, stdev

Usage:
  csvtk stat2 [flags]

Flags:
  -f, --fields string   select only these fields. e.g -f 1,2 or -f columnA,columnB
  -F, --fuzzy-fields    using fuzzy fields, e.g. *name or id123*

Examples

1. simplest one

   $ seq 1 5 | csvtk stat2 -H -f 1
   field   num   sum   min   max   mean   stdev
   1         5    15     1     5      3    1.58
   

2. multiple fields

   $ cat digitals.tsv
   4       5       6
   1       2       3
   7       8       0
   8       1,000   4
   
   $ cat digitals.tsv | csvtk stat2 -t -H -f 1-3
   field   num     sum   min     max     mean    stdev
   1         4      20     1       8        5     3.16
   2         4   1,015     2   1,000   253.75   497.51
   3         4      13     0       6     3.25      2.5
   

csvtk v0.2.4

- fix bug of handling comment lines
- add some notes before using csvtk

csvtk v0.2.3

• add flag --colnames to cut
• flag -f (--fields) of join supports single value now

csvtk v0.2.2

• add flag --keep-unmathed to join

csvtk v0.2.1

• fix bug of mutate

csvtk v0.2

It's ready.

csvtk v0.1 (preview version)

csvtk v0.1 (preview version)

Updated with commit 2ca559c