回复 3# chenjiali1
$ cat FILE
ENSMUSG00000178331 ENSMUST00000178331 3 3235526,3237285,3237591, 3235929,3237412,3237660,
ENSMUSG00000178332 ENSMUST00000178331 3 3235526,3237285,3237591, 3235929,3237412,3237668,
ENSMUSG00000178331 ENSMUST00000178335 5 1,2,3,4,5, 6,7,8,9,10,
ENSMUSG00000178331 ENSMUST00000178335 5 11,12,13,14,15, 11,12,13,14,15
$ awk 'function sum(x,y,c,s){split(x,t,",");for(c in t)if(t[c]!="")s+=t[c]+y;return(s)}{d=sum($5,1)-sum($4);if(a[$2]==""||a[$2]<d){a[$2]=d;p[$2]=$0}}END{for(n in a)print p[n]"\t"a[n]}' FILE
ENSMUSG00000178332 ENSMUST00000178331 3 3235526,3237285,3237591, 3235929,3237412,3237668, 610
ENSMUSG00000178331 ENSMUST00000178335 5 1,2,3,4,5, 6,7,8,9,10, 30
|