练习题（排序合并）

huangyu_945

学习学习！！！！！！！！！！

felixchen_sh

看看思路。复杂的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$
   

复制代码

sky_eminem

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

moperyblue

回复 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))))

复制代码

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


==============可能这不是 本题目的答案, 但是现实生活中, 经常遇到要 分组的情况啊================