CSV/TSV processing
Click component name to see manual page
Component | Bundle | Description |
---|---|---|
CSV2Excel | tools | Export a CSV file to Excel |
CSVCleaner | tools | Convert between CSV formats |
CSVFilter | tools | Filter rows and columns; rename columns |
CSVJoin | tools | Join CSV files using a key column |
CSVListJoin | tools | Append CSV files without using keys |
CSVSort | tools | Sort CSV file |
CSVSplit | tools | Partition a CSV file into a CSV array |
CSVTransformer | tools | Transform CSV file using an R expression |
Excel2CSV | tools | Import a CSV file from Excel |
PythonEvaluate | tools | Process CSV file using streaming |
ScalaEvaluate | tools | Process CSV file using streaming (high performance) |
TableQuery | tools | Invoke SQL query on CSV files |
Overview
Anduril has extensive facilities for working with tabulated files. The tools bundle specifies a CSV file with a certain format: fields are delimited by tabs, the first row contains column names, and values are optionally quoted with "
.
Import/export
CSVCleaner can be used to import/export files in different CSV/TSV dialects. CSV2Excel and Excel2CSV provide two-way conversion with Microsoft Excel.
Filtering and transforming
There are multiple components for processing CSV files: some with a limited purpose but simple interface, and some with flexible options but more complex interface. Most flexibility is provided using external scripts.
Simple components: CSVFilter, CSVJoin, CSVListJoin, CSVSort, CSVSplit
Flexible components: CSVTransformer, PythonEvaluate, ScalaEvaluate, TableQuery