Do not mix use field (column) numbers and names. Usage summary statistics of selected numeric or text fields (groupby group fields)ġ. No header row $ cat testdata/digitals.tsv $ csvtk nrow testdata/names.csv testdata/phones.csv -n tabular output in machine-friendly tabular format Use "csvtk -help" for more information about a command.Įxamples $ csvtk headers testdata/.csv t, -tabs specifies that the input CSV file is delimited with tabs. T, -out-tabs specifies that the output is delimited with tabs. o, -out-file string out file ("-" for stdout, suffix.
D, -out-delimiter string delimiting character of the output CSV file, e.g., -D $'\t' for tab (default ",") j, -num-cpus int number of CPUs to use (default value depends on your computer) (default 16)
H, -no-header-row specifies that the input CSV file does not have header row l, -lazy-quotes if given, a quote may appear in an unquoted field and a non-doubled quote may appear in a quoted field infile-list string file of input files list (one file per line), if given, they are appended to files from cli arguments I, -ignore-illegal-row ignore illegal rows d, -delimiter string delimiting character of the input CSV file (default ",") if your header row starts with '#', please assign "-C" another rare symbol, e.g. C, -comment-char string lines starting with commment-character will be ignored. c, -chunk-size int chunk size of CSV reader (default 50)
Thermal expansion aquatic entangler update#
Version print version information and check for update Unfold unfold multiple values in cells of a field Summary summary statistics of selected numeric or text fields (groupby group fields)
Splitxlsx split XLSX sheet into multiple sheets according to column values Split split CSV/TSV into multiple files according to column values Space2tab convert space delimited format to CSV Sep separate column into multiple columns Replace replace data of selected fields by regular expression Rename2 rename column names by regular expression Rename rename column names with new names Pretty convert CSV to readable aligned table Mutate2 create new column from selected fields by awk-like arithmetic/string expressions Mutate create new column from selected fields by regular expression Join join files by selected fields (inner, left and outer join) Grep grep data by selected fields with patterns/regular expressions Genautocomplete generate shell autocompletion script (bash|zsh|fish|powershell) Gather gather columns into key-value pairs You can also create a soft link named "tsvtk" for "csvtk",Ĭat stream file to stdout and report progress on stderrĬomb compute combinations of items at every rowĬorr calculate Pearson correlation between two columnsĬsv2rst convert CSV to reStructuredText formatĬsv2xlsx convert CSV/TSV files to XLSX fileįilter filter rows by values of selected fields with arithmetic expressionįilter2 filter rows by awk-like arithmetic/string expressionsįold fold multiple values of a field into cells of groups Do not mix use field (column) numbers and names.Įnvironment variables for frequently used global flags: If double quotes exist in fields, use flag "-l".ħ. By default, csvtk handles CSV files, use flag "-t" for tab-delimited files.Ħ. By default, lines starting with "#" will be ignored, if the header rowĥ. By default, csvtk thinks your files have header row, if not, switch flag "-H" on.Ĥ. The CSV parser requires all the lines have same number of fields/columns.Ģ. Usage csvtk - a cross-platform, efficient and practical CSV/TSV toolkitġ.
0 kommentar(er)
