Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- def missing_event(n):
- WCA_EVENTS = set("222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram skewb sq1".split())
- with open('WCA_export_Competitions.tsv','rb') as tsvin:
- tsvin = csv.reader(tsvin, delimiter='\t')
- event_list = []
- count = []
- c = True
- C = 0
- for line in tsvin:
- if c: # skip header
- c = False
- continue
- events = set(line[10].split())
- missing_events = WCA_EVENTS - events
- if len(missing_events) == n:
- C += 1
- for x in missing_events:
- if x not in event_list:
- event_list.append(x)
- count.append(0)
- i = event_list.index(x)
- count[i] += 1
- print "Number of comps missing", n, "events:", C
- for x, y in sorted(zip(count, event_list))[::-1]:
- print str(x).zfill(3), y
- missing_event(1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement