練習(xí)題（排序合并）

huangyu_945

學(xué)習(xí)學(xué)習(xí)�。。。。。。。。。�

felixchen_sh

看看思路。復(fù)雜的shell還是搞不定

yaoliwei

不太對

1. 
   
2. bash-3.2$ awk 'function printarr(fruit,array){printf fruit":\t";tn=asorti(array);for (i=0;i<tn;i++)printf array[i]" ";print}/pear/{p[$2]}/apple/{a[$2]}END{printarr("apple",a);printarr("pear",p)}' file1
   
3. apple:   cat106 cat107 cat108 cat109 cat12 cat123
   
4. pear:    dog101 dog103 dog104 dog105 dog11 mouse106 mouse107 mouse108 mouse109 mouse123
   
5. bash-3.2$
   

復(fù)制代碼

sky_eminem

研究答案。。。。。。。。。。。。。。。。。。。

moperyblue

回復(fù) 1# yestreenstars
python 版：

1. #!/usr/bin/env python
   
2. #encoding:utf-8
   
3. 
   
4. import itertools
   
5. import operator
   
6. 
   
7. def getDataFromFile(filepath):
   
8.     with open(filepath) as f:
   
9.         for line in f:
   
10.             col = line.strip().split()
    
11.             yield (col[0],col[1])
    
12. 
    
13. 
    
14. def getRanges(li):
    
15.     if type(li[0]) == str:
    
16.         li = map(int,li)
    
17.     pos = [j -i for i,j in enumerate(li)]
    
18.     t = 0
    
19.     for k,gr in itertools.groupby(pos):
    
20.         l = len(list(gr))
    
21.         st_pos = li[t]
    
22.         t += l
    
23.         yield range(st_pos,st_pos + l)
    
24. 
    
25. 
    
26. def getValueList(li):
    
27.     ret = []
    
28. 
    
29.     for k,gr in itertools.groupby(sorted(li),operator.itemgetter(0)):
    
30.         g = list(gr)
    
31.         values = [x[1] for x in g]
    
32.         for x in getRanges(values):
    
33.             if len(x)>1:
    
34.                 ret.append(k+str(x[0])+"-"+str(x[-1]))
    
35.             else:
    
36.                 ret.append(k+str(x[0]))
    
37. 
    
38.     return ret
    
39. 
    
40. 
    
41. 
    
42. def getGroupbyWorld(li):
    
43.     import re
    
44.     for x in li:
    
45.         yield re.findall(r'(\D+)(\d+)',x)[0]
    
46. 
    
47. 
    
48. 
    
49. if __name__ == '__main__':
    
50.     data = [x for x in getDataFromFile('1.txt')]
    
51.     data.sort(key=operator.itemgetter(0))
    
52. 
    
53.     import re
    
54. 
    
55.     for k,gr in itertools.groupby(data,key=operator.itemgetter(0)):
    
56.         g = list(gr)
    
57.         values = [x[1] for x in g]
    
58.         li = list(getGroupbyWorld(values))
    
59.         print k+': '+','.join(sorted(getValueList(li),key=lambda x:int(re.match(r'\D+(\d+)',x).group(1))))

復(fù)制代碼

jason680

awk only

$ awk 'function p(v){if(s=="-")printf("%s%s",s,D2 D3);printf("%s",v);D1=d[1];D2=d[2];D3=d[3]}{match($2,/([^0-9]+)([0-9]+)/,d);a[sprintf("%-15s%-15s%9d",$1,d[1],d[2])]=$0}END{t=asorti(a,b);for(n=1;n<=t;n++){split(b[n],d," +");if(d[1]!=D1){p(N d[1]": "d[2]d[3]);N="\n";s=",";continue};if(d[2]!=D2){p(","d[2]d[3]);continue};if(d[3]==D3+1){s="-";D3=d[3]}else{p(","d[2]d[3]);s=","}}}END{p("\n")}' FILE
apple: cat12,cat106-cat109,cat123,cat125
pear: dog11,dog101,dog103-dog105,mouse106-mouse109,mouse123,mouse125

聆雨淋夜

看一下答案。

ztyhua

看一下看一下

xuzhou2015

lxzkenney (UID: 23464606)  在嗎?

能詳細說一下你的 代碼的意思嗎?

------------------------------
sort demo.txt \
|sed -r ':1
N
s/^(\S+)\s+(.+)\n\1\s+(.+)$/\1\t\2,\3/
t1
P
D'

-------------------------------

我沒看明白啊?

-----------------說明-----------
我的意思是:
$ cat demo1|sort
apple   cat106
apple   cat107
apple   cat108
apple   cat109
apple   cat12
apple   cat123
apple   cat125
pear    dog101
pear    dog103
pear    dog104
pear    dog105
pear    dog11
pear    mouse106
pear    mouse107
pear    mouse108
pear    mouse109
pear    mouse123
pear    mouse125

是 怎么變成 下面的樣子的???
apple   cat106,cat107,cat108,cat109,cat12,cat123,cat125
pear    dog101,dog103,dog104,dog105,dog11,mouse106,mouse107,mouse108,mouse109,mouse123,mouse125


==============可能這不是 本題目的答案, 但是現(xiàn)實生活中, 經(jīng)常遇到要 分組的情況啊================