merging similar columns in a single line file - Shell Programming and Scripting

ghostdog74 · #3 (**permalink**) 05-28-2009

you should put in some effort next time by showing what you have done

If you have Python

Code:

#!/usr/bin/env python
d={}
for line in open("file"):
    line=line.strip().split()
    d.setdefault(line[-1],[])
    d[line[-1]].append(line[0])
for i,j in d.iteritems():
    print i, '\t'.join(j)

output

Code:

YYYYYYYYY       a6      a62
ZZZZZ   a30     a13     a43     a23
XXXXXXX         a1      a2      a71