擅长:python、mysql、java
<p>我的答案与@Raymond Hettinger的答案非常相似(他在发布答案时击败了我),但我还修改了regex并进行了其他一些修改:</p>
<pre><code>from collections import Counter
import csv
import operator
import re
import sys
counter = Counter()
with open("occurrences.csv", 'rb') as csvfile:
data = [row for row in csv.reader(csvfile, delimiter=",")]
for id, path, title, date, author, platform, type, port in data:
m = re.search(r'^(.*?)\s*\-.*', title)
title = m.group(1) if m else title
counter.update([title])
for title, count in sorted(counter.items()):
print('{} - {}'.format(title, count))
</code></pre>