Tools to manipulate CSV files
csvflatten.py --key Key < test/3.csv
Combine rows by grouping columns following a specified rule
csvgroup.py --delimiter ' ' --op Count=max
Update values of specified columns.
python csvmap.py --map colname,oldvalue,newvalue [colname,oldvalue,newvalue...] < old.csv > new.csv
Merge CSV files with different column names
By default any column name that does not appear in all CSV files is dropped from the final output.
python csvmerge.py file1.csv [file2.csv...]
python csvmerge.py test/1.csv test/2.csv > 3.csv
Join tables based on a column name
python csvjoin.py --keys col1 col2 --files file1 file2.csv > file3.csv