如果将第一列相同的行对应第二列放到一起，并用，分隔

chenjiali1

XP_002960178    GO:0055114
XP_002960178    GO:0003824
XP_002960417    GO:0034968
XP_002960417    GO:0018024

想合成这样的
XP_002960178    GO:0055114,GO:0003824
XP_002960417    GO:0034968,GO:0018024

请问如何实现，谢谢大家！

jzsjm1002

1. awk 'NR%2{nr=$0;next}{print nr","$2}' file

复制代码

chengchow

1. [root@k8s_m_110 tmp]# awk '{a[$1]=a[$1]","$2}END{for(i in a){sub(",","",a[i]);print i,a[i]}}' aa.log
   

复制代码

baby_神

1. awk '{a[$1]=a[$1]?a[$1]","$2:$2}END{for(i in a)print i,a[i]}' test

复制代码