Advertisement
campos20

Most common missing events in comp missing n events WCA

Jul 13th, 2018
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. import csv
  2.  
  3. def missing_event(n):
  4.  
  5. WCA_EVENTS = set("222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram skewb sq1".split())
  6.  
  7. with open('WCA_export_Competitions.tsv','rb') as tsvin:
  8. tsvin = csv.reader(tsvin, delimiter='\t')
  9.  
  10. event_list = []
  11. count = []
  12.  
  13. c = True
  14. C = 0
  15.  
  16. for line in tsvin:
  17.  
  18. if c: # skip header
  19. c = False
  20. continue
  21.  
  22. events = set(line[10].split())
  23. missing_events = WCA_EVENTS - events
  24.  
  25. if len(missing_events) == n:
  26. C += 1
  27. for x in missing_events:
  28. if x not in event_list:
  29. event_list.append(x)
  30. count.append(0)
  31.  
  32. i = event_list.index(x)
  33. count[i] += 1
  34.  
  35. print "Number of comps missing", n, "events:", C
  36. for x, y in sorted(zip(count, event_list))[::-1]:
  37. print str(x).zfill(3), y
  38.  
  39. missing_event(1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement