Annotate CSV rows

Description

Annotate rows in a CSV file by adding a new column which reflects information from another file. This is similar to joining tables.

Input files

• at least 1 input file (.csv)
• exactly 1 annotation file (.csv)

Output files

• Annotated CSV file (annotated.csv)

Context

Parameters

Key column (input file)

Default: empty

Key column (annotation file)

Default: empty

Annotation column (annotation file)

Default: empty

New column name (input file)

Default: empty

Lookup value tweaks

Strip whitespace

Default: true

Be case-sensitive

Default: true

Source code

annotate-csv.rb, annotate-csv.yaml (GitHub)