汇总计算第二列

oldknew

假设一文本为一考生一学期参加的所有考试的成绩：
[aii@localhost gjy]$ cat test.txt
chinese:85
chinese:92
chinese:79
chinese:86
chinese:81
chinese:76
chinese:84
chinese:84
chinese:88
chinese:78
math:75
math:84
math:83
math:79
math:85
math:90
math:94
math:84
math:69
math:80
english:92
english:76
english:83
english:81
english:87
english:83
english:82
english:79
english:79
physics:68
physics:75
physics:69
physics:90
physics:83
physics:83
physics:82
physics:79
physics:69
physics:85
chemistry:80
chemistry:76
chemistry:77
chemistry:83
chemistry:83
chemistry:82
chemistry:90
chemistry:87
chemistry:88
chemistry:90
politics:93
politics:89
politics:90
politics:92
politics:99
politics:92
politics:89
politics:90
politics:91
politics:91
怎样写脚本或命令行算出该考生各门科目在这个学期的总成绩？
返回：
[aii@localhost gjy]$ cat test.txt
chinese:833
math:823
english:825
physics:783
chemistry:836
politics:916




english:83

haooooaaa

1. awk -F: '{a[$1]+=$2}END{for(i in a)print i":"a[i]}' file

复制代码

oldknew

非常感谢。

zy86416779

回复 1# oldknew
提供一种方法

1. [root@study study]# cat file1
   
2. chinese:85
   
3. chinese:92
   
4. chinese:79
   
5. chinese:86
   
6. chinese:81
   
7. chinese:76
   
8. chinese:84
   
9. chinese:84
   
10. chinese:88
    
11. chinese:78
    
12. math:75
    
13. math:84
    
14. math:83
    
15. math:79
    
16. math:85
    
17. math:90
    
18. math:94
    
19. math:84
    
20. math:69
    
21. math:80
    
22. english:92
    
23. english:76
    
24. english:83
    
25. english:81
    
26. english:87
    
27. english:83
    
28. english:82
    
29. english:79
    
30. english:79
    
31. physics:68
    
32. physics:75
    
33. physics:69
    
34. physics:90
    
35. physics:83
    
36. physics:83
    
37. physics:82
    
38. physics:79
    
39. physics:69
    
40. physics:85
    
41. chemistry:80
    
42. chemistry:76
    
43. chemistry:77
    
44. chemistry:83
    
45. chemistry:83
    
46. chemistry:82
    
47. chemistry:90
    
48. chemistry:87
    
49. chemistry:88
    
50. chemistry:90
    
51. politics:93
    
52. politics:89
    
53. politics:90
    
54. politics:92
    
55. politics:99
    
56. politics:92
    
57. politics:89
    
58. politics:90
    
59. politics:91
    
60. politics:91
    
61. [root@study study]# cat file1 | awk -F: '{print $1}' | uniq > file2
    
62. [root@study study]# cat file2
    
63. chinese
    
64. math
    
65. english
    
66. physics
    
67. chemistry
    
68. politics
    
69. [root@study study]#
    
70. [root@study study]#
    
71. [root@study study]# sh  script1.sh     
    
72. 833
    
73. 823
    
74. 742
    
75. 783
    
76. 836
    
77. 916
    
78. [root@study study]# cat script1.sh
    
79. #!/bin/sh
    
80. for i in `cat file2`
    
81. do
    
82.   awk -F: '(var==$1){total+=$2;}END{print total}' var=$i file1
    
83. done

复制代码

moperyblue

1. awk -F: '$1!=pre{
   
2.     n+=1
   
3. }
   
4. {
   
5.     a[n][$1]+=$2
   
6. }
   
7. {
   
8.     pre=$1
   
9. }
   
10. END{
    
11.     for(i=1;i<=n;i++){
    
12.         for(j in a[i]){
    
13.             print j":"a[i][j]
    
14.         }
    
15.     }
    
16. }' file #gawk 4.0+

复制代码

mswsg

1. with open('1.txt', 'r') as f:
   
2.     alist = []
   
3.     d = {}
   
4.     lines = f.readlines()
   
5.     for line in lines:
   
6.         line = line.strip().split(':')
   
7.         alist.append(line)
   
8. 
   
9.     for i in alist:
   
10.         try:
    
11.             d[i[0]] += int(i[1])
    
12.         except KeyError:
    
13.             d[i[0]] = int(i[1])
    
14.     for course, score in d.items():
    
15.         print course, score

复制代码

mswsg

english 的和求错了？
chinese 833
english 742
politics 916
chemistry 836
physics 783
math 823
回复 1# oldknew


   

tolilong

awk -F":" '{a[$1]+=$2}END{for(i in a){print i":"a[i]}}'  filename

jcdiy0601

awk 'BEGIN{FS=OFS=":"}{a[$1]+=$2}END{for(i in a)print i,a[i]}' file
english:742
physics:783
chinese:833
politics:916
chemistry:836
math:823