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