Odd WCA stats/ Stats request Thread

Sebastien · Jun 2, 2015

Antonie faz fan said:
most common duo on a podium.

Pretty cool request, I decided to code this:

[table="width: 1000, class: grid, align: left"]
[tr][td]#[/td][td]Person 1[/td][td]Person 2[/td][td]Amount of shared Podiums[/td][/tr]
[tr][td]1.[/td][td]Erik Akkersdijk[/td][td]Mats Valk[/td][td]147[/td][/tr]
[tr][td]2.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]143[/td][/tr]
[tr][td]3.[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]139[/td][/tr]
[tr][td]4.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]106[/td][/tr]
[tr][td]5.[/td][td]Robert Yau[/td][td]Daniel Sheppard[/td][td]102[/td][/tr]
[tr][td]6.[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]99[/td][/tr]
[tr][td]7.[/td][td]Christopher Olson[/td][td]John Brechon[/td][td]82[/td][/tr]
[tr][td]8.[/td][td]Rowe Hessler[/td][td]Dan Cohen[/td][td]80[/td][/tr]
[tr][td]9.[/td][td]Erik Akkersdijk[/td][td]Maarten Smit[/td][td]78[/td][/tr]
[tr][td]10.[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]76[/td][/tr]
[tr][td]11.[/td][td]Erik Akkersdijk[/td][td]Sébastien Auroux[/td][td]72[/td][/tr]
[tr][td]12.[/td][td]Henrik Buus Aagaard[/td][td]Oscar Roth Andersen[/td][td]69[/td][/tr]
[tr][td]13.[/td][td]Breandan Vallance[/td][td]Robert Yau[/td][td]66[/td][/tr]
[tr][td]14.[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]64[/td][/tr]
[tr][td]15.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Jurgens Filiaggi[/td][td]60[/td][/tr]
[tr][td]16.[/td][td]Michał Halczuk[/td][td]Przemysław Kaleta[/td][td]58[/td][/tr]
[tr][td]17.[/td][td]Gunnar Krig[/td][td]Simon Westlund[/td][td]57[/td][/tr]
[tr][td]18.[/td][td]Erik Akkersdijk[/td][td]Bence Barát[/td][td]56[/td][/tr]
[tr][td]19.[/td][td]Ernesto Gutiérrez Cuba[/td][td]Eduardo Gutiérrez Cuba[/td][td]55[/td][/tr]
[tr][td]20.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]54[/td][/tr]
[tr][td]21.[/td][td]Pedro Santos Guimarães[/td][td]Gabriel Dechichi Barbar[/td][td]53[/td][/tr]
[tr][td]22.[/td][td]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/td][td]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/td][td]51[/td][/tr]
[tr][td]23.[/td][td]Yu Nakajima (中島悠)[/td][td]Syuhei Omura (大村周平)[/td][td]50[/td][/tr]
[tr][td]24.[/td][td]Milán Baticz[/td][td]Erik Akkersdijk[/td][td]49[/td][/tr]
[tr][td]24.[/td][td]Yu Nakajima (中島悠)[/td][td]Yu Sajima (佐島優)[/td][td]49[/td][/tr]
[tr][td]26.[/td][td]Bob Burton[/td][td]Tim Reynolds[/td][td]48[/td][/tr]
[tr][td]26.[/td][td]Dan Cohen[/td][td]Patrick Jameson[/td][td]48[/td][/tr]
[tr][td]26.[/td][td]Mats Valk[/td][td]Maarten Smit[/td][td]48[/td][/tr]
[tr][td]26.[/td][td]Bence Barát[/td][td]Michael Röhrer[/td][td]48[/td][/tr]
[tr][td]30.[/td][td]Sébastien Auroux[/td][td]Laura Ohrndorf[/td][td]47[/td][/tr]
[tr][td]30.[/td][td]Massimiliano Iovane[/td][td]Paolo Moriello[/td][td]47[/td][/tr]
[tr][td]30.[/td][td]Carlos Méndez García-Barroso[/td][td]Jorge Castillo Matas[/td][td]47[/td][/tr]
[tr][td]33.[/td][td]Kirt Protacio[/td][td]Jayden McNeill[/td][td]44[/td][/tr]
[tr][td]33.[/td][td]Akash Rupela[/td][td]Shubham Kumar[/td][td]44[/td][/tr]
[tr][td]35.[/td][td]Tim Reynolds[/td][td]Dan Cohen[/td][td]43[/td][/tr]
[tr][td]35.[/td][td]Olivér Perge[/td][td]Bence Barát[/td][td]43[/td][/tr]
[tr][td]35.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Carlos Miguel Parra Gonzalez[/td][td]43[/td][/tr]
[tr][td]38.[/td][td]Milán Baticz[/td][td]Dániel Varga[/td][td]42[/td][/tr]
[tr][td]38.[/td][td]Philippe Virouleau[/td][td]Antoine Piau[/td][td]42[/td][/tr]
[tr][td]38.[/td][td]Vincent Hartanto Utomo[/td][td]Stephen Adhisaputra[/td][td]42[/td][/tr]
[tr][td]41.[/td][td]Pedro Santos Guimarães[/td][td]Rafael Werneck Cinoto[/td][td]41[/td][/tr]
[tr][td]41.[/td][td]José Leonardo Chaparro Prieto[/td][td]David Remolina Amórtegui[/td][td]41[/td][/tr]
[tr][td]43.[/td][td]Hao-Zheng Lin (林浩正)[/td][td]Yi-Fan Wu (吳亦凡)[/td][td]40[/td][/tr]
[tr][td]43.[/td][td]Bence Barát[/td][td]Matic Omulec[/td][td]40[/td][/tr]
[tr][td]43.[/td][td]Gaurav Taneja[/td][td]Akash Rupela[/td][td]40[/td][/tr]
[tr][td]46.[/td][td]Ron van Bruchem[/td][td]Lars Vandenbergh[/td][td]39[/td][/tr]
[tr][td]46.[/td][td]Piotr Kózka[/td][td]Tomasz Żołnowski[/td][td]39[/td][/tr]
[tr][td]46.[/td][td]Henrik Buus Aagaard[/td][td]Holger Stadel Borum[/td][td]39[/td][/tr]
[tr][td]46.[/td][td]Kanneti Sae Han (คันธ์เนตี แซ่ห่าน)[/td][td]Philippe Virouleau[/td][td]39[/td][/tr]
[tr][td]46.[/td][td]Jorge Castillo Matas[/td][td]Rafael Rodriguez Santana[/td][td]39[/td][/tr]
[tr][td]51.[/td][td]Kåre Krig[/td][td]Gunnar Krig[/td][td]38[/td][/tr]
[tr][td]51.[/td][td]Paolo Moriello[/td][td]Giovanni Contardi[/td][td]38[/td][/tr]
[tr][td]51.[/td][td]Evan Liu[/td][td]Corey Sakowski[/td][td]38[/td][/tr]
[tr][td]54.[/td][td]Gunnar Krig[/td][td]Erik Akkersdijk[/td][td]37[/td][/tr]
[tr][td]54.[/td][td]Dániel Varga[/td][td]Hunor Bózsing[/td][td]37[/td][/tr]
[tr][td]54.[/td][td]Alexander Olleta del Molino[/td][td]Daniel Gracia Ortiz[/td][td]37[/td][/tr]
[tr][td]57.[/td][td]Gunnar Krig[/td][td]Henrik Buus Aagaard[/td][td]36[/td][/tr]
[tr][td]57.[/td][td]Henrik Buus Aagaard[/td][td]Karina Grandjean Beck[/td][td]36[/td][/tr]
[tr][td]57.[/td][td]Michał Pleskowicz[/td][td]Marcin Zalewski[/td][td]36[/td][/tr]
[tr][td]60.[/td][td]Lars Vandenbergh[/td][td]Erik Akkersdijk[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Mike Hughey[/td][td]Chester Lian[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Michał Halczuk[/td][td]Kamil Zieliński[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Lorenzo Vigani Poli[/td][td]Paolo Moriello[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Oscar Roth Andersen[/td][td]Karina Grandjean Beck[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Marcin Zalewski[/td][td]Przemysław Kaleta[/td][td]35[/td][/tr]
[tr][td]60.[/td][td]Marcin Kowalczyk[/td][td]Grzegorz Jałocha[/td][td]35[/td][/tr]
[tr][td]67.[/td][td]Takayuki Ookusa (大艸尊之)[/td][td]Yu Nakajima (中島悠)[/td][td]34[/td][/tr]
[tr][td]67.[/td][td]Erik Akkersdijk[/td][td]Henrik Buus Aagaard[/td][td]34[/td][/tr]
[tr][td]67.[/td][td]Erik Akkersdijk[/td][td]Rama Temmink[/td][td]34[/td][/tr]
[tr][td]67.[/td][td]Stefano Bevacqua[/td][td]Paolo Moriello[/td][td]34[/td][/tr]
[tr][td]71.[/td][td]Bernett Orlando[/td][td]Karthik Puthraya[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Edward Lin[/td][td]Mitchell Lane[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Hippolyte Moreau[/td][td]Antoine Piau[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Feliks Zemdegs[/td][td]Tim Major[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Carlos Méndez García-Barroso[/td][td]Pablo Aguilar Dominguez[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Wojciech Knott[/td][td]Przemysław Kaleta[/td][td]33[/td][/tr]
[tr][td]71.[/td][td]Ihor Bilchenko (Ігор Більченко)[/td][td]Artem Melikian (Артем Мелікян)[/td][td]33[/td][/tr]
[tr][td]78.[/td][td]Henrik Buus Aagaard[/td][td]Lars Vennike Nielsson[/td][td]32[/td][/tr]
[tr][td]78.[/td][td]Timothy Sun[/td][td]Yunqi Ouyang (欧阳韵奇)[/td][td]32[/td][/tr]
[tr][td]78.[/td][td]Tim Major[/td][td]Jayden McNeill[/td][td]32[/td][/tr]
[tr][td]78.[/td][td]José Leonardo Chaparro Prieto[/td][td]Daniel Cano Salgado[/td][td]32[/td][/tr]
[tr][td]78.[/td][td]Jakub Kipa[/td][td]Przemysław Kaleta[/td][td]32[/td][/tr]
[tr][td]83.[/td][td]Tomasz Żołnowski[/td][td]Adam Polkowski[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Henrik Buus Aagaard[/td][td]Frank Severinsen[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Rowe Hessler[/td][td]Kevin Costello III[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Michał Halczuk[/td][td]Cezary Rokita[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Michael Young[/td][td]Edward Liu[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Haowei Fan (樊浩玮)[/td][td]Mulun Yin (阴目仑)[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Max Granlund[/td][td]Niko Paavilainen[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Gaurav Taneja[/td][td]Vinit Nalhe[/td][td]31[/td][/tr]
[tr][td]83.[/td][td]Ivan Torgashov[/td][td]Ivan Zabrodin[/td][td]31[/td][/tr]
[tr][td]92.[/td][td]Ron van Bruchem[/td][td]Erik Akkersdijk[/td][td]30[/td][/tr]
[tr][td]92.[/td][td]Yumu Tabuchi (田渕雄夢)[/td][td]Syuhei Omura (大村周平)[/td][td]30[/td][/tr]
[tr][td]92.[/td][td]François Courtès[/td][td]Sébastien Auroux[/td][td]30[/td][/tr]
[tr][td]92.[/td][td]Anatoly Kim[/td][td]Ivan Zabrodin[/td][td]30[/td][/tr]
[tr][td]92.[/td][td]Kevin Costello III[/td][td]Tim Wong[/td][td]30[/td][/tr]
[tr][td]97.[/td][td]Piotr Kózka[/td][td]Adam Polkowski[/td][td]29[/td][/tr]
[tr][td]97.[/td][td]István Kocza[/td][td]Bence Barát[/td][td]29[/td][/tr]
[tr][td]97.[/td][td]Mitsuki Gunji (郡司光貴)[/td][td]Yu Nakajima (中島悠)[/td][td]29[/td][/tr]
[tr][td]97.[/td][td]Erik Akkersdijk[/td][td]Arnaud van Galen[/td][td]29[/td][/tr]
[/table]

Code:

from __future__ import division
import zipfile, csv
import itertools

source = 'WCA_export009_20150601.tsv.zip'

people = []
podiums = {}
names = {}
podiums_person = {}

with zipfile.ZipFile(source) as zf:
	with zf.open('WCA_export_Results.tsv') as pf:
		for row in csv.DictReader(pf, delimiter='\t'):
			if not row['competitionId'] in podiums:
				podiums[row['competitionId']] = {}
			if not row['eventId'] in podiums[row['competitionId']]:
				podiums[row['competitionId']][row['eventId']] = []
			if row['pos'] in ['1','2','3'] and row['roundId'] in ['c','f'] and row['best'] not in ['-2','-1','0']:
				podiums[row['competitionId']][row['eventId']].append(row['personId'])
				if not row['personId'] in people:
					people.append(row['personId'])
					podiums_person[row['personId']] = []
				podiums_person[row['personId']].append([row['competitionId'],row['eventId']])
	with zf.open('WCA_export_Persons.tsv') as pf:
		for row in csv.DictReader(pf, delimiter='\t'):
			if row['subid'] == '1':
				names[row['id']] = row['name']
				
scores = []
			
for i in range(0,len(people)):
	print "Searching for podium person " + str(i+1) + " out of " + str(len(people)) + ": " + people[i]
	for j in range(i+1,len(people)):
		counter = 0
		for p in podiums_person[people[i]]:
			if people[j] in podiums[p[0]][p[1]]:
				counter += 1
		if counter > 0:
			scores.append([people[i],people[j],counter])
						
scores.sort(key=lambda s: s[2], reverse=True)				
		
out = ''
out += '[spoiler="Top 100 of best podium buddies"][table="width: 1200, class: grid, align: left"]\n'
out += '[tr][td][b]#[/b][/td][td][b]Person 1[/b][/td][td][b]Person 2[/b][/td][td][b]Amount of shared Podiums[/b][/td][/tr]\n'
pos = "1."
for i in range(0,100):
	if i > 0 and scores[i][2] < scores[i-1][2]:
		pos = str(i+1) + "."
	cells = (pos, names[scores[i][0]], names[scores[i][1]], scores[i][2])
	out += '[tr]' + ''.join('[td]{}[/td]'.format(x) for x in cells) + '[/tr]\n'
out += '[/table][/spoiler]'
fout = open('Results/Result_buddies.dat', "w")
fout.write(out)

Faz said:
Me and Jay?

Not a bad guess, but you only make the 4th place. My first thought was Jan Bentlage and myself, but that guess wasn't better.

mycube said:
Well it also could be the Weyer-Twins I think

Good to know that i shouldn't bet too much on your thoughts.

Pedro · Jun 2, 2015

Haha, I'm in the list twice. I used to be on the top-10 for medals, but it's been a while...

Kit Clement · Jun 2, 2015

Interesting to see Bence has the #2 and #3 spot, but the two people he shares them with aren't even a pairing on the top 100.

TheDubDubJr · Jun 2, 2015

What about the Top Podium Trios?

kinch2002 · Jun 2, 2015

Pretty cool that Robert and I are up there, considering we are almost exact opposites in terms of which events we're good at.

Myachii · Jun 2, 2015

Biggest difference between fastest and second fastest solve in a 3x3 Average? (not deliberate)

Highest standard deviation for a 3x3 Average? (also not deliberate)

Biggest improvement in 3x3 Average from on competition to the next (both comps within the same year)?

TDM · Jun 2, 2015

Myachii said:
Biggest improvement in 3x3 Average from on competition to the next (both comps within the same year)?

What if they're in e.g. December and January? That wouldn't get counted, so maybe have the comps within one year of each other.

Sebastien · Jun 3, 2015

TheDubDubJr said:
What about the Top Podium Trios?

[table="width: 1000, class: grid, align: left"]
[tr][td]#[/td][td]Person 1[/td][td]Person 2[/td][td]Person 3[/td][td]Amount of shared Podiums[/td][/tr]
[tr][td]1.[/td][td]Erik Akkersdijk[/td][td]Mats Valk[/td][td]Maarten Smit[/td][td]31[/td][/tr]
[tr][td]2.[/td][td]Bence Barát[/td][td]Michael Röhrer[/td][td]Hunor Bózsing[/td][td]22[/td][/tr]
[tr][td]3.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Carlos Miguel Parra Gonzalez[/td][td]Jurgens Filiaggi[/td][td]18[/td][/tr]
[tr][td]3.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]18[/td][/tr]
[tr][td]5.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Kirt Protacio[/td][td]17[/td][/tr]
[tr][td]5.[/td][td]Feliks Zemdegs[/td][td]Cameron Stollery[/td][td]Jayden McNeill[/td][td]17[/td][/tr]
[tr][td]7.[/td][td]Robert Yau[/td][td]Chris Wall[/td][td]Daniel Sheppard[/td][td]16[/td][/tr]
[tr][td]8.[/td][td]Breandan Vallance[/td][td]Robert Yau[/td][td]Daniel Sheppard[/td][td]15[/td][/tr]
[tr][td]8.[/td][td]Ibrahim Vajgel-Shedid[/td][td]Kristopher De Asis[/td][td]Kevin Hays[/td][td]15[/td][/tr]
[tr][td]10.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Tim Major[/td][td]14[/td][/tr]
[tr][td]10.[/td][td]Pedro Santos Guimarães[/td][td]Gabriel Dechichi Barbar[/td][td]Carlos Alberto de Alcântara Jr[/td][td]14[/td][/tr]
[tr][td]10.[/td][td]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/td][td]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/td][td]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/td][td]14[/td][/tr]
[tr][td]13.[/td][td]Massimiliano Iovane[/td][td]Paolo Moriello[/td][td]Stefano Bevacqua[/td][td]13[/td][/tr]
[tr][td]13.[/td][td]Ayush Kumar[/td][td]Gaurav Taneja[/td][td]Akash Rupela[/td][td]13[/td][/tr]
[tr][td]15.[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]Hunor Bózsing[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Erik Akkersdijk[/td][td]Rama Temmink[/td][td]Mats Valk[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Yu Nakajima (中島悠)[/td][td]Syuhei Omura (大村周平)[/td][td]Yu Sajima (佐島優)[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Anton Rostovikov[/td][td]Oleg Gritsenko[/td][td]Dmitry Karyakin[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Haowei Fan (樊浩玮)[/td][td]Mulun Yin (阴目仑)[/td][td]Yan Jin (金岩)[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]Matic Omulec[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Piotr Kózka[/td][td]Adam Polkowski[/td][td]Tomasz Żołnowski[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Jurgens Filiaggi[/td][td]Jacob Sanchez[/td][td]12[/td][/tr]
[tr][td]24.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Nick Pappas[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Henrik Buus Aagaard[/td][td]Oscar Roth Andersen[/td][td]Frank Severinsen[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Henrik Buus Aagaard[/td][td]Holger Stadel Borum[/td][td]Oscar Roth Andersen[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Anatoly Kim[/td][td]Ivan Zabrodin[/td][td]Pavel Yushkevich[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]Laura Ohrndorf[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Max Granlund[/td][td]Niko Paavilainen[/td][td]Elmo Tiitola[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Milán Baticz[/td][td]Erik Akkersdijk[/td][td]Bence Barát[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]José Leonardo Chaparro Prieto[/td][td]David Remolina Amórtegui[/td][td]Daniel Cano Salgado[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Yumu Tabuchi (田渕雄夢)[/td][td]Yu Nakajima (中島悠)[/td][td]Syuhei Omura (大村周平)[/td][td]11[/td][/tr]
[tr][td]24.[/td][td]Massimiliano Iovane[/td][td]Giovanni Contardi[/td][td]Paolo Moriello[/td][td]11[/td][/tr]
[tr][td]34.[/td][td]Christopher Olson[/td][td]SeungBeom Cho (조승범)[/td][td]John Brechon[/td][td]10[/td][/tr]
[tr][td]34.[/td][td]Michał Halczuk[/td][td]Wojciech Knott[/td][td]Przemysław Kaleta[/td][td]10[/td][/tr]
[tr][td]34.[/td][td]Henrik Buus Aagaard[/td][td]Oscar Roth Andersen[/td][td]Karina Grandjean Beck[/td][td]10[/td][/tr]
[tr][td]34.[/td][td]Thompson Clarke[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]10[/td][/tr]
[tr][td]38.[/td][td]Niko Ronkainen[/td][td]Niko Paavilainen[/td][td]Max Granlund[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Gints Aleksandrs Dreimanis[/td][td]Vladislavs Baranovs[/td][td]Tomas Jankauskas[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Boriss Benzerruki[/td][td]Ivans Gorbunovs[/td][td]Vladislavs Baranovs[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Emily Wang[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Christopher Olson[/td][td]John Brechon[/td][td]Walker Welch[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Carlos Méndez García-Barroso[/td][td]Dario Roa Sánchez[/td][td]Pablo Aguilar Dominguez[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Adrián Ramírez[/td][td]Jefferson Ramírez[/td][td]Pablo Say[/td][td]9[/td][/tr]
[tr][td]38.[/td][td]Rowe Hessler[/td][td]Dan Cohen[/td][td]Erik Johnson[/td][td]9[/td][/tr]
[tr][td]46.[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]Andreas Pohl[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Waris Ali[/td][td]Christopher Olson[/td][td]John Brechon[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Ivan Vynnyk (Іван Винник)[/td][td]Ihor Bilchenko (Ігор Більченко)[/td][td]Yulian Kaplyuk (Юліан Каплюк)[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/td][td]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/td][td]Gomain Ngernseng (โกเมน เงินเส็ง)[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Robert Yau[/td][td]Callum Hales-Jepp[/td][td]Daniel Sheppard[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Chia-Wei Lu (呂家維)[/td][td]Edward Lin[/td][td]Mitchell Lane[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Erik Akkersdijk[/td][td]Sébastien Auroux[/td][td]Henrik Buus Aagaard[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Harris Chan[/td][td]Jai Gambhir[/td][td]Eric Limeback[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Luke Bruce[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Marcin Zalewski[/td][td]Marcin Kowalczyk[/td][td]Grzegorz Jałocha[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Erik Akkersdijk[/td][td]Mats Valk[/td][td]Guus de Wit[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]José Leonardo Chaparro Prieto[/td][td]Jhon Edinson Arias Parra[/td][td]Juan Camilo Vargas[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Robert Yau[/td][td]Simon Crawford[/td][td]Daniel Sheppard[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Takayuki Ookusa (大艸尊之)[/td][td]Syuhei Omura (大村周平)[/td][td]Yu Nakajima (中島悠)[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]François Courtès[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Pedro Santos Guimarães[/td][td]Willian Fidêncio[/td][td]Rafael Werneck Cinoto[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Paulo Salgado Alvarez[/td][td]Rodrigo Gómez Araya[/td][td]Gonzalo Serrano[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Gunnar Krig[/td][td]Erik Akkersdijk[/td][td]Henrik Buus Aagaard[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Michał Pleskowicz[/td][td]Marcin Zalewski[/td][td]Przemysław Kaleta[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Olivér Perge[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Carlos Méndez García-Barroso[/td][td]Alberto Pérez de Rada Fiol[/td][td]Pablo Aguilar Dominguez[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Leyan Lo[/td][td]Tyson Mao (毛台勝)[/td][td]Shelley Chang[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Rowe Hessler[/td][td]Dan Cohen[/td][td]Patrick Jameson[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Vincent Hartanto Utomo[/td][td]Renhard Julindra[/td][td]Stephen Adhisaputra[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Michał Halczuk[/td][td]Cezary Rokita[/td][td]Przemysław Kaleta[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Tomas Kristiansson[/td][td]Stefan Lidström[/td][td]Simon Westlund[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Robert Yau[/td][td]Ciarán Beahan[/td][td]Sameer Mahmood[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Bence Barát[/td][td]Jure Gregorc[/td][td]Hunor Bózsing[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]José Leonardo Chaparro Prieto[/td][td]David Remolina Amórtegui[/td][td]Felipe Rueda Hernández[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Ernesto Gutiérrez Cuba[/td][td]Eduardo Gutiérrez Cuba[/td][td]Christian Saenz Valdivia[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Rafael Werneck Cinoto[/td][td]Gilson Sousa da Silva[/td][td]Gabriel Pereira Campanha[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]David Remolina Amórtegui[/td][td]Jhon Edinson Arias Parra[/td][td]Felipe Rueda Hernández[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]Jonathan Esparaz[/td][td]8[/td][/tr]
[tr][td]46.[/td][td]Dmitry Zvyagintsev[/td][td]Vladislav Shavelskiy[/td][td]Ivan Torgashov[/td][td]8[/td][/tr]
[tr][td]80.[/td][td]Erik Akkersdijk[/td][td]Maarten Smit[/td][td]Bence Barát[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Gaurav Taneja[/td][td]Vinit Nalhe[/td][td]Anant Pingle[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Olivér Perge[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Michał Halczuk[/td][td]Jakub Wolniewicz[/td][td]Piotr Michał Padlewski[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Patrick Kelly[/td][td]Jackson Warley[/td][td]AJ Blair[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Balázs Bernát[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Hao-Zheng Lin (林浩正)[/td][td]Jr-Wei Jang (張智瑋)[/td][td]Yi-Fan Wu (吳亦凡)[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Henrik Buus Aagaard[/td][td]Lars Vennike Nielsson[/td][td]Oscar Roth Andersen[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Alex Chen[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Breandan Vallance[/td][td]Robert Yau[/td][td]Sameer Mahmood[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Carlos Méndez García-Barroso[/td][td]Jorge Castillo Matas[/td][td]Rafael Rodriguez Santana[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Bernett Orlando[/td][td]Karthik Puthraya[/td][td]Pradeep Dhananjay[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Dan Dzoan[/td][td]Edward Liu[/td][td]Michael Young[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Dhanayush Raninga[/td][td]Dharmesh Shahu[/td][td]Gaurav Taneja[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Feliks Zemdegs[/td][td]Giovanni Contardi[/td][td]Jayden McNeill[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Alexander Olleta del Molino[/td][td]Daniel Gracia Ortiz[/td][td]Eki González García[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Breandan Vallance[/td][td]Cornelius Dieckmann[/td][td]Robert Yau[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Jakub Kipa[/td][td]Przemysław Kaleta[/td][td]Wojciech Knott[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]Matěj Mužátko[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Brock Hamann[/td][td]7[/td][/tr]
[/table]

I also had to improve the code, as the straight forward extension would have taken hours.

Now both scripts run in a second.

Code:

from __future__ import division
import zipfile, csv
import itertools

source = 'WCA_export009_20150601.tsv.zip'

people = []
podiums = {}
names = {}
podiums_person = {}

with zipfile.ZipFile(source) as zf:
	with zf.open('WCA_export_Results.tsv') as pf:
		for row in csv.DictReader(pf, delimiter='\t'):
			if not row['competitionId'] in podiums:
				podiums[row['competitionId']] = {}
			if not row['eventId'] in podiums[row['competitionId']]:
				podiums[row['competitionId']][row['eventId']] = []
			if row['pos'] in ['1','2','3'] and row['roundId'] in ['c','f'] and row['best'] not in ['-2','-1','0']:
				podiums[row['competitionId']][row['eventId']].append(row['personId'])
				if not row['personId'] in people:
					people.append(row['personId'])
					podiums_person[row['personId']] = []
				podiums_person[row['personId']].append([row['competitionId'],row['eventId']])
	with zf.open('WCA_export_Persons.tsv') as pf:
		for row in csv.DictReader(pf, delimiter='\t'):
			if row['subid'] == '1':
				names[row['id']] = row['name']
				
sdict = {}
			
for i in range(0,len(people)):
	print "Searching for podium person " + str(i+1) + " out of " + str(len(people)) + ": " + people[i]
	for p in podiums_person[people[i]]:
		for j in podiums[p[0]][p[1]]:
			for k in podiums[p[0]][p[1]]:
				if (people[i],k,j) not in sdict and (j,people[i],k) not in sdict and (j,k,people[i]) not in sdict and (k,people[i],j) not in sdict and (k,j,people[i]) not in sdict:
					if not (people[i],j,k) in sdict:
						sdict[(people[i],j,k)] = 0
					if people[i]<>j and people[i]<>k and j<>k:
						sdict[(people[i],j,k)] += 1
	
scores = [[s[0],s[1],s[2],sdict[s]] for s in sdict]						
scores.sort(key=lambda s: s[3], reverse=True)

henrysavich · Jun 3, 2015

What person. (Who has had multiple WR's ) has gone the longest period of time without having a WR between two periods of time they did have a WR.

Isaac Lai · Jun 3, 2015

henrysavich said:
What person. (Who has had multiple WR's ) has gone the longest period of time without having a WR between two periods of time they did have a WR.

Michal Halczuk?

Sebastien · Jun 3, 2015

Isaac Lai said:
Michal Halczuk?

I guess that's true, almost 3 years and 3 months. I also found Gunnar Krig with a time of 3 years (Sep' 2006 until Sep' 2009).

Robert-Y · Jun 3, 2015

Sebastien: There appears to be something wrong in the first column? The rankings don't seem correct. Also, I've thought of an extension but I don't know if it would yield interesting results: Same thing, except all 3 of the competitors must represent different countries to each other.

Genius4Jesus · Jun 3, 2015

Antoine, Louis and myself are in the top 100 as a trio mostly because of this competition: https://www.worldcubeassociation.org/results/c.php?i=MontrealFall2014

Antonie faz fan · Jun 3, 2015

Sebastien said:
[table="width: 1200, class: grid, align: left"]
[tr][td]#[/td][td]Person 1[/td][td]Person 2[/td][td]Person 3[/td][td]Amount of shared Podiums[/td][/tr]
[tr][td]1.[/td][td]Erik Akkersdijk[/td][td]Mats Valk[/td][td]Maarten Smit[/td][td]31[/td][/tr]
[tr][td]1.[/td][td]Bence Barát[/td][td]Michael Röhrer[/td][td]Hunor Bózsing[/td][td]22[/td][/tr]
[tr][td]1.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Carlos Miguel Parra Gonzalez[/td][td]Jurgens Filiaggi[/td][td]18[/td][/tr]
[tr][td]4.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]18[/td][/tr]
[tr][td]4.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Kirt Protacio[/td][td]17[/td][/tr]
[tr][td]4.[/td][td]Feliks Zemdegs[/td][td]Cameron Stollery[/td][td]Jayden McNeill[/td][td]17[/td][/tr]
[tr][td]7.[/td][td]Robert Yau[/td][td]Chris Wall[/td][td]Daniel Sheppard[/td][td]16[/td][/tr]
[tr][td]7.[/td][td]Breandan Vallance[/td][td]Robert Yau[/td][td]Daniel Sheppard[/td][td]15[/td][/tr]
[tr][td]9.[/td][td]Ibrahim Vajgel-Shedid[/td][td]Kristopher De Asis[/td][td]Kevin Hays[/td][td]15[/td][/tr]
[tr][td]9.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Tim Major[/td][td]14[/td][/tr]
[tr][td]11.[/td][td]Pedro Santos Guimarães[/td][td]Gabriel Dechichi Barbar[/td][td]Carlos Alberto de Alcântara Jr[/td][td]14[/td][/tr]
[tr][td]11.[/td][td]Piti Pichedpan (ปิติ พิเชษฐพันธ์)[/td][td]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/td][td]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/td][td]14[/td][/tr]
[tr][td]13.[/td][td]Massimiliano Iovane[/td][td]Paolo Moriello[/td][td]Stefano Bevacqua[/td][td]13[/td][/tr]
[tr][td]13.[/td][td]Ayush Kumar[/td][td]Gaurav Taneja[/td][td]Akash Rupela[/td][td]13[/td][/tr]
[tr][td]15.[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]Hunor Bózsing[/td][td]12[/td][/tr]
[tr][td]15.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]12[/td][/tr]
[tr][td]17.[/td][td]Erik Akkersdijk[/td][td]Rama Temmink[/td][td]Mats Valk[/td][td]12[/td][/tr]
[tr][td]17.[/td][td]Yu Nakajima (中島悠)[/td][td]Syuhei Omura (大村周平)[/td][td]Yu Sajima (佐島優)[/td][td]12[/td][/tr]
[tr][td]17.[/td][td]Anton Rostovikov[/td][td]Oleg Gritsenko[/td][td]Dmitry Karyakin[/td][td]12[/td][/tr]
[tr][td]20.[/td][td]Haowei Fan (樊浩玮)[/td][td]Mulun Yin (阴目仑)[/td][td]Yan Jin (金岩)[/td][td]12[/td][/tr]
[tr][td]20.[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]Matic Omulec[/td][td]12[/td][/tr]
[tr][td]22.[/td][td]Piotr Kózka[/td][td]Adam Polkowski[/td][td]Tomasz Żołnowski[/td][td]12[/td][/tr]
[tr][td]22.[/td][td]Oscar Alberto Ceballos Contreras[/td][td]Jurgens Filiaggi[/td][td]Jacob Sanchez[/td][td]12[/td][/tr]
[tr][td]24.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Nick Pappas[/td][td]11[/td][/tr]
[tr][td]25.[/td][td]Henrik Buus Aagaard[/td][td]Oscar Roth Andersen[/td][td]Frank Severinsen[/td][td]11[/td][/tr]
[tr][td]26.[/td][td]Henrik Buus Aagaard[/td][td]Holger Stadel Borum[/td][td]Oscar Roth Andersen[/td][td]11[/td][/tr]
[tr][td]26.[/td][td]Anatoly Kim[/td][td]Ivan Zabrodin[/td][td]Pavel Yushkevich[/td][td]11[/td][/tr]
[tr][td]28.[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]Laura Ohrndorf[/td][td]11[/td][/tr]
[tr][td]28.[/td][td]Max Granlund[/td][td]Niko Paavilainen[/td][td]Elmo Tiitola[/td][td]11[/td][/tr]
[tr][td]30.[/td][td]Milán Baticz[/td][td]Erik Akkersdijk[/td][td]Bence Barát[/td][td]11[/td][/tr]
[tr][td]30.[/td][td]José Leonardo Chaparro Prieto[/td][td]David Remolina Amórtegui[/td][td]Daniel Cano Salgado[/td][td]11[/td][/tr]
[tr][td]32.[/td][td]Yumu Tabuchi (田渕雄夢)[/td][td]Yu Nakajima (中島悠)[/td][td]Syuhei Omura (大村周平)[/td][td]11[/td][/tr]
[tr][td]32.[/td][td]Massimiliano Iovane[/td][td]Giovanni Contardi[/td][td]Paolo Moriello[/td][td]11[/td][/tr]
[tr][td]32.[/td][td]Christopher Olson[/td][td]SeungBeom Cho (조승범)[/td][td]John Brechon[/td][td]10[/td][/tr]
[tr][td]32.[/td][td]Michał Halczuk[/td][td]Wojciech Knott[/td][td]Przemysław Kaleta[/td][td]10[/td][/tr]
[tr][td]36.[/td][td]Henrik Buus Aagaard[/td][td]Oscar Roth Andersen[/td][td]Karina Grandjean Beck[/td][td]10[/td][/tr]
[tr][td]36.[/td][td]Thompson Clarke[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]10[/td][/tr]
[tr][td]36.[/td][td]Niko Ronkainen[/td][td]Niko Paavilainen[/td][td]Max Granlund[/td][td]9[/td][/tr]
[tr][td]36.[/td][td]Gints Aleksandrs Dreimanis[/td][td]Vladislavs Baranovs[/td][td]Tomas Jankauskas[/td][td]9[/td][/tr]
[tr][td]40.[/td][td]Boriss Benzerruki[/td][td]Ivans Gorbunovs[/td][td]Vladislavs Baranovs[/td][td]9[/td][/tr]
[tr][td]41.[/td][td]Emily Wang[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]9[/td][/tr]
[tr][td]41.[/td][td]Christopher Olson[/td][td]John Brechon[/td][td]Walker Welch[/td][td]9[/td][/tr]
[tr][td]43.[/td][td]Carlos Méndez García-Barroso[/td][td]Dario Roa Sánchez[/td][td]Pablo Aguilar Dominguez[/td][td]9[/td][/tr]
[tr][td]43.[/td][td]Adrián Ramírez[/td][td]Jefferson Ramírez[/td][td]Pablo Say[/td][td]9[/td][/tr]
[tr][td]45.[/td][td]Rowe Hessler[/td][td]Dan Cohen[/td][td]Erik Johnson[/td][td]9[/td][/tr]
[tr][td]45.[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]Andreas Pohl[/td][td]8[/td][/tr]
[tr][td]47.[/td][td]Waris Ali[/td][td]Christopher Olson[/td][td]John Brechon[/td][td]8[/td][/tr]
[tr][td]47.[/td][td]Ivan Vynnyk (Іван Винник)[/td][td]Ihor Bilchenko (Ігор Більченко)[/td][td]Yulian Kaplyuk (Юліан Каплюк)[/td][td]8[/td][/tr]
[tr][td]49.[/td][td]Nipat Charoenpholphant (นิพัฒน์ เจริญพลพันธุ์)[/td][td]Asia Konvittayayotin (เอเชีย กรวิทยโยธิน)[/td][td]Gomain Ngernseng (โกเมน เงินเส็ง)[/td][td]8[/td][/tr]
[tr][td]49.[/td][td]Robert Yau[/td][td]Callum Hales-Jepp[/td][td]Daniel Sheppard[/td][td]8[/td][/tr]
[tr][td]49.[/td][td]Chia-Wei Lu (呂家維)[/td][td]Edward Lin[/td][td]Mitchell Lane[/td][td]8[/td][/tr]
[tr][td]52.[/td][td]Erik Akkersdijk[/td][td]Sébastien Auroux[/td][td]Henrik Buus Aagaard[/td][td]8[/td][/tr]
[tr][td]52.[/td][td]Harris Chan[/td][td]Jai Gambhir[/td][td]Eric Limeback[/td][td]8[/td][/tr]
[tr][td]52.[/td][td]Dene Beardsley[/td][td]Feliks Zemdegs[/td][td]Luke Bruce[/td][td]8[/td][/tr]
[tr][td]52.[/td][td]Marcin Zalewski[/td][td]Marcin Kowalczyk[/td][td]Grzegorz Jałocha[/td][td]8[/td][/tr]
[tr][td]56.[/td][td]Erik Akkersdijk[/td][td]Mats Valk[/td][td]Guus de Wit[/td][td]8[/td][/tr]
[tr][td]56.[/td][td]José Leonardo Chaparro Prieto[/td][td]Jhon Edinson Arias Parra[/td][td]Juan Camilo Vargas[/td][td]8[/td][/tr]
[tr][td]58.[/td][td]Robert Yau[/td][td]Simon Crawford[/td][td]Daniel Sheppard[/td][td]8[/td][/tr]
[tr][td]59.[/td][td]Takayuki Ookusa (大艸尊之)[/td][td]Syuhei Omura (大村周平)[/td][td]Yu Nakajima (中島悠)[/td][td]8[/td][/tr]
[tr][td]59.[/td][td]François Courtès[/td][td]Sébastien Auroux[/td][td]Jan Bentlage[/td][td]8[/td][/tr]
[tr][td]61.[/td][td]Pedro Santos Guimarães[/td][td]Willian Fidêncio[/td][td]Rafael Werneck Cinoto[/td][td]8[/td][/tr]
[tr][td]61.[/td][td]Paulo Salgado Alvarez[/td][td]Rodrigo Gómez Araya[/td][td]Gonzalo Serrano[/td][td]8[/td][/tr]
[tr][td]63.[/td][td]Gunnar Krig[/td][td]Erik Akkersdijk[/td][td]Henrik Buus Aagaard[/td][td]8[/td][/tr]
[tr][td]63.[/td][td]Michał Pleskowicz[/td][td]Marcin Zalewski[/td][td]Przemysław Kaleta[/td][td]8[/td][/tr]
[tr][td]65.[/td][td]Olivér Perge[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]8[/td][/tr]
[tr][td]65.[/td][td]Carlos Méndez García-Barroso[/td][td]Alberto Pérez de Rada Fiol[/td][td]Pablo Aguilar Dominguez[/td][td]8[/td][/tr]
[tr][td]67.[/td][td]Leyan Lo[/td][td]Tyson Mao (毛台勝)[/td][td]Shelley Chang[/td][td]8[/td][/tr]
[tr][td]67.[/td][td]Rowe Hessler[/td][td]Dan Cohen[/td][td]Patrick Jameson[/td][td]8[/td][/tr]
[tr][td]67.[/td][td]Vincent Hartanto Utomo[/td][td]Renhard Julindra[/td][td]Stephen Adhisaputra[/td][td]8[/td][/tr]
[tr][td]67.[/td][td]Michał Halczuk[/td][td]Cezary Rokita[/td][td]Przemysław Kaleta[/td][td]8[/td][/tr]
[tr][td]71.[/td][td]Tomas Kristiansson[/td][td]Stefan Lidström[/td][td]Simon Westlund[/td][td]8[/td][/tr]
[tr][td]71.[/td][td]Robert Yau[/td][td]Ciarán Beahan[/td][td]Sameer Mahmood[/td][td]8[/td][/tr]
[tr][td]73.[/td][td]Bence Barát[/td][td]Jure Gregorc[/td][td]Hunor Bózsing[/td][td]8[/td][/tr]
[tr][td]73.[/td][td]José Leonardo Chaparro Prieto[/td][td]David Remolina Amórtegui[/td][td]Felipe Rueda Hernández[/td][td]8[/td][/tr]
[tr][td]73.[/td][td]Ernesto Gutiérrez Cuba[/td][td]Eduardo Gutiérrez Cuba[/td][td]Christian Saenz Valdivia[/td][td]8[/td][/tr]
[tr][td]76.[/td][td]Rafael Werneck Cinoto[/td][td]Gilson Sousa da Silva[/td][td]Gabriel Pereira Campanha[/td][td]8[/td][/tr]
[tr][td]76.[/td][td]David Remolina Amórtegui[/td][td]Jhon Edinson Arias Parra[/td][td]Felipe Rueda Hernández[/td][td]8[/td][/tr]
[tr][td]76.[/td][td]Louis Cormier[/td][td]Antoine Cantin[/td][td]Jonathan Esparaz[/td][td]8[/td][/tr]
[tr][td]79.[/td][td]Dmitry Zvyagintsev[/td][td]Vladislav Shavelskiy[/td][td]Ivan Torgashov[/td][td]8[/td][/tr]
[tr][td]80.[/td][td]Erik Akkersdijk[/td][td]Maarten Smit[/td][td]Bence Barát[/td][td]7[/td][/tr]
[tr][td]80.[/td][td]Gaurav Taneja[/td][td]Vinit Nalhe[/td][td]Anant Pingle[/td][td]7[/td][/tr]
[tr][td]82.[/td][td]Olivér Perge[/td][td]Bence Barát[/td][td]Dániel Varga[/td][td]7[/td][/tr]
[tr][td]83.[/td][td]Michał Halczuk[/td][td]Jakub Wolniewicz[/td][td]Piotr Michał Padlewski[/td][td]7[/td][/tr]
[tr][td]83.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]7[/td][/tr]
[tr][td]85.[/td][td]Patrick Kelly[/td][td]Jackson Warley[/td][td]AJ Blair[/td][td]7[/td][/tr]
[tr][td]86.[/td][td]Milán Baticz[/td][td]Bence Barát[/td][td]Balázs Bernát[/td][td]7[/td][/tr]
[tr][td]86.[/td][td]Hao-Zheng Lin (林浩正)[/td][td]Jr-Wei Jang (張智瑋)[/td][td]Yi-Fan Wu (吳亦凡)[/td][td]7[/td][/tr]
[tr][td]88.[/td][td]Henrik Buus Aagaard[/td][td]Lars Vennike Nielsson[/td][td]Oscar Roth Andersen[/td][td]7[/td][/tr]
[tr][td]88.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Alex Chen[/td][td]7[/td][/tr]
[tr][td]88.[/td][td]Breandan Vallance[/td][td]Robert Yau[/td][td]Sameer Mahmood[/td][td]7[/td][/tr]
[tr][td]91.[/td][td]Carlos Méndez García-Barroso[/td][td]Jorge Castillo Matas[/td][td]Rafael Rodriguez Santana[/td][td]7[/td][/tr]
[tr][td]92.[/td][td]Bernett Orlando[/td][td]Karthik Puthraya[/td][td]Pradeep Dhananjay[/td][td]7[/td][/tr]
[tr][td]92.[/td][td]Dan Dzoan[/td][td]Edward Liu[/td][td]Michael Young[/td][td]7[/td][/tr]
[tr][td]92.[/td][td]Dhanayush Raninga[/td][td]Dharmesh Shahu[/td][td]Gaurav Taneja[/td][td]7[/td][/tr]
[tr][td]92.[/td][td]Feliks Zemdegs[/td][td]Giovanni Contardi[/td][td]Jayden McNeill[/td][td]7[/td][/tr]
[tr][td]92.[/td][td]Alexander Olleta del Molino[/td][td]Daniel Gracia Ortiz[/td][td]Eki González García[/td][td]7[/td][/tr]
[tr][td]97.[/td][td]Breandan Vallance[/td][td]Cornelius Dieckmann[/td][td]Robert Yau[/td][td]7[/td][/tr]
[tr][td]97.[/td][td]Jakub Kipa[/td][td]Przemysław Kaleta[/td][td]Wojciech Knott[/td][td]7[/td][/tr]
[tr][td]97.[/td][td]Bence Barát[/td][td]Hunor Bózsing[/td][td]Matěj Mužátko[/td][td]7[/td][/tr]
[tr][td]100.[/td][td]Feliks Zemdegs[/td][td]Jayden McNeill[/td][td]Brock Hamann[/td][td]7[/td][/tr]
[/table]

I also had to improve the code, as the straight forward extension would have taken hours. Now both scripts run in a second.

Code:

from __future__ import division import zipfile, csv import itertools source = 'WCA_export009_20150601.tsv.zip' people = [] podiums = {} names = {} podiums_person = {} with zipfile.ZipFile(source) as zf: with zf.open('WCA_export_Results.tsv') as pf: for row in csv.DictReader(pf, delimiter='\t'): if not row['competitionId'] in podiums: podiums[row['competitionId']] = {} if not row['eventId'] in podiums[row['competitionId']]: podiums[row['competitionId']][row['eventId']] = [] if row['pos'] in ['1','2','3'] and row['roundId'] in ['c','f'] and row['best'] not in ['-2','-1','0']: podiums[row['competitionId']][row['eventId']].append(row['personId']) if not row['personId'] in people: people.append(row['personId']) podiums_person[row['personId']] = [] podiums_person[row['personId']].append([row['competitionId'],row['eventId']]) with zf.open('WCA_export_Persons.tsv') as pf: for row in csv.DictReader(pf, delimiter='\t'): if row['subid'] == '1': names[row['id']] = row['name'] sdict = {} for i in range(0,len(people)): print "Searching for podium person " + str(i+1) + " out of " + str(len(people)) + ": " + people[i] for p in podiums_person[people[i]]: for j in podiums[p[0]][p[1]]: for k in podiums[p[0]][p[1]]: if (people[i],k,j) not in sdict and (j,people[i],k) not in sdict and (j,k,people[i]) not in sdict and (k,people[i],j) not in sdict and (k,j,people[i]) not in sdict: if not (people[i],j,k) in sdict: sdict[(people[i],j,k)] = 0 if people[i]<>j and people[i]<>k and j<>k: sdict[(people[i],j,k)] += 1 scores = [[s[0],s[1],s[2],sdict[s]] for s in sdict] scores.sort(key=lambda s: s[3], reverse=True)

for some reason expected me to be in there along with Mats Valk and Reinier Schippers, whatever.
also i am not sure if this has been asked but closest podium ever?

Sebastien · Jun 3, 2015

Robert-Y said:
Sebastien: There appears to be something wrong in the first column? The rankings don't seem correct. Also, I've thought of an extension but I don't know if it would yield interesting results: Same thing, except all 3 of the competitors must represent different countries to each other.

True. The code was still looking at the 3rd row to determine the correct position, I forgot to change this from the "podium buddies" code. I fixed it now.

qqwref · Jun 5, 2015

There are three Jonathans with a 3x3x3 average under 11 seconds, and their averages are all within 0.01 of each other.

Genius4Jesus · Jun 5, 2015

qqwref said:
There are three Jonathans with a 3x3x3 average under 11 seconds, and their averages are all within 0.01 of each other.

I'm one of them. Also, we are all sub-9.5.

qqwref · Jun 6, 2015

Genius4Jesus said:
I'm one of them. Also, we are all sub-9.5.

Yeah, I noticed because of your sig

joshsailscga · Jun 6, 2015

Myachii said:
Biggest difference between fastest and second fastest solve in a 3x3 Average? (not deliberate)

Check out this guy's single from River Hill 2015: https://www.worldcubeassociation.org/results/p.php?i=2015KENN01

CyanSandwich · Jun 6, 2015

Myachii said:
Biggest difference between fastest and second fastest solve in a 3x3 Average? (not deliberate)

Highest standard deviation for a 3x3 Average? (also not deliberate)

Biggest improvement in 3x3 Average from on competition to the next (both comps within the same year)?

1) Checked manually - 3:26.44 difference https://www.worldcubeassociation.org/results/p.php?i=2014WILL07 (not sure about percentage)

The others would be interesting to see.

Edit: I only checked the rankings (i.e just people's PBs), so I might be wrong.

Odd WCA stats/ Stats request Thread

Premium Member

Veteran

Premium Member

Cupcake

Premium Member

Veteran

Legend

Premium Member

Veteran

Veteran

Premium Member

Legend

Veteran

Veteran

Premium Member

Legend

Veteran

Legend

Veteran

Veteran

Similar threads