怎么统计某列行数？

ora_admin

我有如下文件，格式如下：
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz,NVIDIA GeForce 9500 GT @ 494.48798
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798

我怎么统计以逗号分隔的共有相同的第一列共有多少行和相同的第二列列共有多少行？
比如上面的结果应为：
cpu类型
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+：4
NVIDIA GeForce 9500 GT @ 494.48798：6
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz:2

[ 本帖最后由 ora_admin 于 2009-1-20 16:45 编辑 ]

HH106

原帖由 ora_admin 于 2009-1-20 16:41 发表
我有如下文件，格式如下：
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798

AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798

我怎么统计以逗号分隔的第二列和第三列共有多少行？

不好意思，我怎么没看到以逗号分隔的第三列？

ywlscpl

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

复制代码

cooljean2008

如果要统计所有行（包含只出现过一次的行），就用
awk -F "," '{a[$1]++;b[$2]++}END{for (i in a) print i":"a[i];for (j in b) print j":"b[j]}' file
如果要统计包含重复的列有多少行，就用
awk -F "," '{a[$1]++;b[$2]++}END{for (i in a)if(a[i]>1)print i":"a[i];for (j in b)if(b[i]>1)print j":"b[j]}' file

moartel

活学活用
awk -F "," '{++S[$1];++S[$2]} END {for(a in S) print a, S[a]}' urfile

cooljean2008

原帖由 moartel 于 2009-1-20 21:41 发表
活学活用
awk -F "," '{++S[$1];++S[$2]} END {for(a in S) print a, S[a]}' urfile

如果$1==$2，就不行了

biglazybug

awk -F ',' '{a[$1]++;b[$2]++} END {for(i in a){print i,a} for(j in b) {print j,b[j]}}'

moartel

原帖由 cooljean2008 于 2009-1-21 00:53 发表


如果$1==$2，就不行了

[root@ns ~]# awk -F "," '{++S[$1];++S[$2]} END {for(a in S) print a, S[a]}' 1
NVIDIA GeForce 9500 GT @ 494.48798 8
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz 2
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+ 4
[root@ns ~]# cat 1
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz,NVIDIA GeForce 9500 GT @ 494.48798
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+,NVIDIA GeForce 9500 GT @ 494.48798
NVIDIA GeForce 9500 GT @ 494.48798,NVIDIA GeForce 9500 GT @ 494.48798
[root@ns ~]#

cooljean2008

原帖由 moartel 于 2009-1-21 09:20 发表


[root@ns ~]# awk -F "," '{++S[$1];++S[$2]} END {for(a in S) print a, S[a]}' 1
NVIDIA GeForce 9500 GT @ 494.48798 8
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz 2
AMD Athlon(tm) 64 X2 Du ...

那请问，第一列NVIDIA GeForce 9500 GT 重复几次，第二列NVIDIA GeForce 9500 GT 又重复几次

moartel

[quote]原帖由 [i]cooljean2008[/i] 于 2009-1-21 09:37 发表 [url=http://bbs.chinaunix.net/redirect.php?goto=findpost&pid=9976427&ptid=1357547][img]http://bbs.chinaunix.net/images/common/back.gif[/img][/url]


那请问，第一列NVIDIA GeForce 9500 GT 重复几次，第二列NVIDIA GeForce 9500 GT 又重复几次 [/quote]

明白了
awk -F "," '{++S[$1];++N[$2]} END {for (a in S) print a, S[a];for(b in N) print b, N[b] }' urfile

[[i] 本帖最后由 moartel 于 2009-1-21 09:56 编辑 [/i]]