明智地将多个CSV合并为一个CSV列 [英] Combine multiple CSV into one single CSV column wise

问题描述

我有许多csv文件，其第1列具有相同的信息，但第2列却不同.

I have many csv files with column 1 with the same information but column 2 is different.

例如 CSV1具有以下信息

For ex. CSV1 has the following information

AAA, 11
BBB, 22
CCC, 33

并且CSV2具有以下内容

And CSV2 has the following

AAA, 1111
BBB, 2222
CCC, 3333

我尝试对文件进行CAT，最终得到了由Rows串联的文件.但是我正在新的csv中寻找类似以下输出的内容.我正在寻找一种在Shell中完成此操作的方法.

I tried to CAT the files and I end up getting a file concatenated by Rows. But I am looking for something like the following output in a new csv. I am looking for a way to do it in shell.

Result.csv应该是

Result.csv should be

AAA, 11, 1111
BBB, 22, 2222
CCC, 33, 3333

推荐答案

尝试以下一种方法:

 awk -F, -v OFS="," '{a[$1]=a[$1]?a[$1]FS$2:$2}END{for(x in a)print x,a[x]}' file1 2 3 .... 

这篇关于明智地将多个CSV合并为一个CSV列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！