shenwei356/csvtk v0.2.9

csvtk v0.2.9

on GitHub

• add more flags to subcommand pretty
• fix bug of csvtk cut -n
• add subcommand filter

filter

Usage

filter data by values of selected fields with math expression

Usage:
  csvtk filter [flags]

Flags:
      --any             print record if any of the field satisfy the condition
  -f, --filter string   filter condition. e.g. -f "age>12" or -f "1,3<=2" or -F -f "c*!=0" --or
  -F, --fuzzy-fields    using fuzzy fileds, e.g. *name or id123*

Examples

1. single field

   $ cat 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"
   
   $ cat names.csv | csvtk filter -f "id>0" | csvtk pretty
   id   first_name   last_name   username
   11   Rob          Pike        rob
   2    Ken          Thompson    ken
   4    Robert       Griesemer   gri
   1    Robert       Thompson    abc
   

2. multiple fields

   $ cat digitals.tsv
   4       5       6
   1       2       3
   7       8       0
   8       1,000   4
   
   $ cat digitals.tsv | csvtk -t -H filter -f "1-3>0"
   4       5       6
   1       2       3
   8       1,000   4
   

   using --any to print record if any of the field satisfy the condition

   $  cat digitals.tsv | csvtk -t -H filter -f "1-3>0" --any
   4       5       6
   1       2       3
   7       8       0
   8       1,000   4
   

3. fuzzy fields

   $  cat names.csv | csvtk filter -F -f "i*!=0"
   id,first_name,last_name,username
   11,Rob,Pike,rob
   2,Ken,Thompson,ken
   4,Robert,Griesemer,gri
   1,Robert,Thompson,abc