python写的简单分组统计脚本

125 阅读 0 评论 83 点赞

我是靠谱客的博主呆萌树叶，这篇文章主要介绍python写的简单分组统计脚本，现在分享给大家，希望可以做个参考。

访问日志内容：
'asdfasd'|2222|'asdfasdf'|{'phone':'13511020335','name':'lsq','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13511020335','name':'lsq','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13810210010','name':'llj','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'18900102987','name':'ljk','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13810210010','name':'llj','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13511020335','name':'lsq','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13511020335','name':'lsq','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'13511020335','name':'lsq','address':'asdfasdfasdfasf'}
'asdfasd'|2222|'asdfasdf'|{'phone':'18900102987','name':'ljk','address':'asdfasdfasdfasf'}

统计需求:按电话和用户名来统计访问次数

可以用三种方法:

### 1. collections Counter
from collections import Counter
l = []
for s in open('a.txt'):
    d = eval(s.split('|')[-1].strip())
    l.append(d['phone']+ '||' + d['name'])

Counter(l)

Counter({'13511020335||lsq': 5, '18900102987||ljk': 2, '13810210010||llj': 2})

### 2.list.count
l = []
for s in open('a.txt'):
    d = eval(s.split('|')[-1].strip())
    l.append(d['phone']+ '||' + d['name'])
a = {}
for i in l:
    if l.count(i)>=1:
        a[i] = l.count(i)
print a

>>> print a
{'18900102987||ljk': 2, '13810210010||llj': 2, '13511020335||lsq': 5}

### 3.dict in
dr = {}
for s in open('a.txt'):
    d = eval(s.split('|')[-1].strip())
    k_dr = d['phone']+ "||" + d['name']
    if k_dr in dr:
        dr[k_dr] = dr[k_dr] + 1
    else:
        dr[k_dr] = 1

>>> print dr
{'18900102987||ljk': 2, '13810210010||llj': 2, '13511020335||lsq': 5}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-2062806/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-2062806/