News for hackers. Stuff that matters.
Re:The Grug Brained Developer (2022) by pbohun on Wednesday June 18, 2025 @09:57AM (#44309942)
Was it joining on some columns or just concatenating the files?

I'm going to laugh pretty hard if it could just be done with: cat file1.csv file2.csv > combined.csv

Re:The Grug Brained Developer (2022) by Xenoamorphous on Wednesday June 18, 2025 @10:55AM (#44310462)
You need to account for the headers, which many (most?) csv files I've encountered have.

So I guess something like this to skip the headers in the second file (this also assumes that headers don't have line breaks):

  cp file1.csv combined.csv && tail -n+2 file2.csv >> combined.csv
Re:The Grug Brained Developer (2022) by xnx on Friday June 27, 2025 @11:36AM (#44397619)
There are also a lot of command line options for joining by column like csvkit