Annotate CSV rows
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)