In [1]:
import pandas as pd, numpy as np, json
import members_loader, matches_loader, clubs_loader, point_utils
from matches_loader import *
In [2]:
column_keys={'match_type':2,'aka':{'name':5,'hansoku':6,'point1':7,'point2':8,'point3':9},
'shiro':{'name':15,'hansoku':14,'point1':11,'point2':12,'point3':13},'outcome':10,
'shinpan':{'fukushin1':16,'shushin':17,'fukushin2':18}}
column_keys_ns={'match_type':2,'aka':{'name':5,'hansoku':6,'point1':7,'point2':8,'point3':9},
'shiro':{'name':15,'hansoku':14,'point1':11,'point2':12,'point3':13},'outcome':10}
column_keys_012_653_789={'match_type':0,'aka':{'name':1,'point1':2},
'shiro':{'name':6,'point1':5},'outcome':3,
'shinpan':{'fukushin1':7,'shushin':8,'fukushin2':9}}
column_keys_012_543={'match_type':0,'aka':{'name':1,'point1':2},
'shiro':{'name':5,'point1':4},'outcome':3}
column_keys_013_654={'match_type':0,'aka':{'name':1,'point1':3},
'shiro':{'name':6,'point1':5},'outcome':4}
column_keys_2012_543={'match_type':20,'aka':{'name':1,'point1':2},
'shiro':{'name':5,'point1':4},'outcome':3}
column_keys_1512_543={'match_type':15,'aka':{'name':1,'point1':2},
'shiro':{'name':5,'point1':4},'outcome':3}
column_keys_612_543={'match_type':6,'aka':{'name':1,'point1':2},
'shiro':{'name':5,'point1':4},'outcome':3}
column_keys_312_543={'match_type':3,'aka':{'name':1,'point1':2},
'shiro':{'name':5,'point1':4},'outcome':3}
sheetname='List of matches'
In [3]:
year=2009
competition='CR'
matches=matches_loader.get_matches(year,competition)
[ 0 3 4 7 8 11 12 15 16 19 20 23 24 27 28 31 32 35 36 39 40 43 44 47
48 51 52 55 56 59 60 63]
[ 1 6 9 14 17 22 25 30 33 38 41 46 49 54 57 62]
[ 3 12 19 28 35 44 51 60]
[ 7 24 39 56]
[15 48]
In [10]:
year=2010
competition='CN'
path='../data/raw/'+str(year)+'/'+str(competition)+'/'
filename=path+'2010.11.27-28 - CN - Bucuresti.xlsx'
matches=[]
sheetname=['IM_manual']
matches=get_matches_from_tournament(filename,sheetname)
[ 0 3 4 7 8 11 12 15 16 19 20 23 24 27 28 31 32 35
36 39 40 43 44 47 48 51 52 55 56 59 60 63 64 67 68 71
72 75 76 79 80 83 84 87 88 91 92 95 96 99 100 103 104 107
108 111 112 115 116 119 120 123 124 127]
[ 1 6 9 14 17 22 25 30 33 38 41 46 49 54 57 62 65 70
73 78 81 86 89 94 97 102 105 110 113 118 121 126]
[ 3 12 19 28 35 44 51 60 67 76 83 92 99 108 115 124]
[ 7 24 39 56 71 88 103 120]
[ 15 48 79 112]
[31 96]
In [13]:
matches
Out[13]:
[{'match_type': 'IM_manual$',
'aka': {'name': 'Hentea Adrian', 'point1': 'MM'},
'shiro': {'name': 'Drăghici Dan', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Crăciun Dragoş', 'point1': ''},
'shiro': {'name': 'Stupu Alexandru', 'point1': 'M'}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': 2},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Stanciu Florentin', 'point1': 'O'},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Józsa Levente', 'point1': 'O'},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Botean Adrian', 'point1': 'O'}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Duţescu Mihai', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Turdean Sergiu', 'point1': ''},
'shiro': {'name': 'Mahika Sorin', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Solacolu Gheorghe', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Gârbea Daniel', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Brîcov Andrei', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Hostina Emil', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Illyés Attila', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Preda Alexandru', 'point1': 8},
'shiro': {'name': 'Crăciunel Valentin', 'point1': 'M'}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Hentea Adrian', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Stupu Alexandru', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Stanciu Florentin', 'point1': ''},
'shiro': {'name': 'Józsa Levente', 'point1': 'MM'}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Botean Adrian', 'point1': ''},
'shiro': {'name': 'Duţescu Mihai', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Turdean Sergiu', 'point1': ''},
'shiro': {'name': 'Solacolu Gheorghe', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Brîcov Andrei', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Illyés Attila', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Preda Alexandru', 'point1': 'O'}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Hentea Adrian', 'point1': ''},
'shiro': {'name': 'Stupu Alexandru', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Józsa Levente', 'point1': ''},
'shiro': {'name': 'Botean Adrian', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Turdean Sergiu', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Preda Alexandru', 'point1': 'M'}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Hentea Adrian', 'point1': ''},
'shiro': {'name': 'Józsa Levente', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Turdean Sergiu', 'point1': ''},
'shiro': {'name': 'Preda Alexandru', 'point1': ''}},
{'match_type': 'IM_manual$',
'aka': {'name': 'Hentea Adrian', 'point1': ''},
'shiro': {'name': 'Turdean Sergiu', 'point1': ''}}]
In [76]:
matches=[]
sheetnames=[['IM'],['IM']]
stages=['pool','pool']
skiprows=[6,6]
shifts=[-1,5]
cks=[column_keys_312_543,column_keys_312_543]
for i in range(len(sheetnames)):
sheetname=sheetnames[i]
skiprow=skiprows[i]
stage=stages[i]
shift=shifts[i]
ck=cks[i]
matches=matches+get_matches_from_list(filename,sheetname,ck,skiprow,shift=shift,stage=stage)
In [77]:
matches
Out[77]:
[{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'MM'},
'shiro': {'name': 'Andronache Marius', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'KM'},
'shiro': {'name': 'Bogdan Vasilică', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Andronache Marius', 'point1': 'MM'},
'shiro': {'name': 'Bogdan Vasilică', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc I.:', 'point1': 'Ghergheli Lucian'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc II.:', 'point1': 'Andronache Marius'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Pool C', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Nistorel Remus', 'point1': 'M'},
'shiro': {'name': 'Fecioru Miruna', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Nistorel Remus', 'point1': 'MM'},
'shiro': {'name': 'Duţu Cristian', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Fecioru Miruna', 'point1': 'MM'},
'shiro': {'name': 'Duţu Cristian', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc I.:', 'point1': 'Nistorel Remus'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc II.:', 'point1': 'Fecioru Miruna'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Pool E', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Iurea Gheorghe', 'point1': nan},
'shiro': {'name': 'Gârbea Ion', 'point1': 'KM'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Iurea Gheorghe', 'point1': nan},
'shiro': {'name': 'Drăgan Mitruţ', 'point1': 'MK'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Gârbea Ion', 'point1': 'K'},
'shiro': {'name': 'Drăgan Mitruţ', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc I.:', 'point1': 'Gârbea Ion'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc II.:', 'point1': 'Drăgan Mitruţ'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Pool G', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Bejgu Nicolae', 'point1': nan},
'shiro': {'name': 'Căruntu Bogdan', 'point1': '∆'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Bejgu Nicolae', 'point1': nan},
'shiro': {'name': 'Székely Paul', 'point1': 'MM'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Căruntu Bogdan', 'point1': nan},
'shiro': {'name': 'Székely Paul', 'point1': 'M'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc I.:', 'point1': 'Székely Paul'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc II.:', 'point1': 'Bejgu Nicolae'},
'shiro': {'name': 'Bejgu (D) - Căruntu', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Pool I', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Brîcov Andrei', 'point1': nan},
'shiro': {'name': 'Duţescu Mihai', 'point1': 'M'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Brîcov Andrei', 'point1': nan},
'shiro': {'name': 'Morar Dumitru', 'point1': 'MM'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Duţescu Mihai', 'point1': nan},
'shiro': {'name': 'Morar Dumitru', 'point1': 'KM'},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc I.:', 'point1': 'Morar Dumitru'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Loc II.:', 'point1': 'Duţescu Mihai'},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Pool K', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%nan',
'aka': {'name': 'Iliescu Dragoş', 'point1': 'M'},
'shiro': {'name': 'Zahan Sorin', 'point1': nan},
'outcome': nan},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Iliescu Dragoş', 'point1': nan},
'shiro': {'name': 'Drăghici Dan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Zahan Sorin', 'point1': nan},
'shiro': {'name': 'Drăghici Dan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Iliescu Dragoş'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Zahan Sorin'},
'shiro': {'name': 'Zahan (DM) - Drăghici (M)', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool M', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Luca Mihai', 'point1': 'DM'},
'shiro': {'name': 'Sántha Szabolcs', 'point1': 'M'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Luca Mihai', 'point1': 'IM'},
'shiro': {'name': 'Péter Árpád', 'point1': '∆∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Sántha Szabolcs', 'point1': 'MM'},
'shiro': {'name': 'Péter Árpád', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Luca Mihai'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Sántha Szabolcs'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Ozon Cristian', 'point1': nan},
'shiro': {'name': 'Ovcinicov Sasha', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Ozon Cristian', 'point1': 'MM'},
'shiro': {'name': 'Cazangiu Ştefan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Ovcinicov Sasha', 'point1': 'KM'},
'shiro': {'name': 'Cazangiu Ştefan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Ozon Cristian'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Ovcinicov Sasha'},
'shiro': {'name': 'Ozon (MK) - Ovcinicov', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool D', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Gâscă Claudiu', 'point1': 'MM'},
'shiro': {'name': 'Nacu Tiberiu', 'point1': 'K∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Gâscă Claudiu', 'point1': 'MM∆∆'},
'shiro': {'name': 'Văsi Claudiu', 'point1': 'I'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Nacu Tiberiu', 'point1': 'KM∆'},
'shiro': {'name': 'Văsi Claudiu', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Gâscă Claudiu'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Nacu Tiberiu'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool F', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Bejenaru Gabriel', 'point1': nan},
'shiro': {'name': 'Vasilache Răzvan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Bejenaru Gabriel', 'point1': nan},
'shiro': {'name': 'Cercel Adrian', 'point1': 'M'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Vasilache Răzvan', 'point1': '∆'},
'shiro': {'name': 'Cercel Adrian', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Cercel Adrian'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Bejenaru Gabriel'},
'shiro': {'name': 'Vasilache (∆∆) - Bejenaru (MI)', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool H', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Cismaş Octavian', 'point1': 'MD'},
'shiro': {'name': 'Gumenîi Serghei', 'point1': '∆D'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Cismaş Octavian', 'point1': 'M∆M'},
'shiro': {'name': 'Puşcaşu Dumitru', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Gumenîi Serghei', 'point1': 'M'},
'shiro': {'name': 'Puşcaşu Dumitru', 'point1': '∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Cismaş Octavian'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Gumenîi Serghei'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool J', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pindelea Grigore', 'point1': nan},
'shiro': {'name': 'Georgescu Silviu', 'point1': 'KD'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pindelea Grigore', 'point1': nan},
'shiro': {'name': 'Ianăş Florin', 'point1': 'KM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Georgescu Silviu', 'point1': nan},
'shiro': {'name': 'Ianăş Florin', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Georgescu Silviu'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Ianăş Florin'},
'shiro': {'name': 'Ianăș (I) - Georgescu (∆M∆M)', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Pool L', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Oţelea Cătălin', 'point1': nan},
'shiro': {'name': 'Crăciunel Ioan', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Oţelea Cătălin', 'point1': nan},
'shiro': {'name': 'Gheorghiță Andrei', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Crăciunel Ioan', 'point1': 'MK'},
'shiro': {'name': 'Gheorghiță Andrei', 'point1': 'M∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc I.:', 'point1': 'Crăciunel Ioan'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': 'Loc II.:', 'point1': 'Gheorghiță Andrei'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$pool%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'}]
In [73]:
sheetname='IM'
shift=5
skiprow=6
stage='finals'
matches=get_matches_from_list(filename,sheetname,column_keys_312_543,skiprow,
shift=shift,stage=stage)
In [74]:
matches
Out[74]:
[{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Ozon Cristian', 'point1': nan},
'shiro': {'name': 'Ovcinicov Sasha', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Ozon Cristian', 'point1': 'MM'},
'shiro': {'name': 'Cazangiu Ştefan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Ovcinicov Sasha', 'point1': 'KM'},
'shiro': {'name': 'Cazangiu Ştefan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Ozon Cristian'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Ovcinicov Sasha'},
'shiro': {'name': 'Ozon (MK) - Ovcinicov', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pool D', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Gâscă Claudiu', 'point1': 'MM'},
'shiro': {'name': 'Nacu Tiberiu', 'point1': 'K∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Gâscă Claudiu', 'point1': 'MM∆∆'},
'shiro': {'name': 'Văsi Claudiu', 'point1': 'I'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Nacu Tiberiu', 'point1': 'KM∆'},
'shiro': {'name': 'Văsi Claudiu', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Gâscă Claudiu'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Nacu Tiberiu'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pool F', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Bejenaru Gabriel', 'point1': nan},
'shiro': {'name': 'Vasilache Răzvan', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Bejenaru Gabriel', 'point1': nan},
'shiro': {'name': 'Cercel Adrian', 'point1': 'M'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Vasilache Răzvan', 'point1': '∆'},
'shiro': {'name': 'Cercel Adrian', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Cercel Adrian'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Bejenaru Gabriel'},
'shiro': {'name': 'Vasilache (∆∆) - Bejenaru (MI)', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pool H', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Cismaş Octavian', 'point1': 'MD'},
'shiro': {'name': 'Gumenîi Serghei', 'point1': '∆D'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Cismaş Octavian', 'point1': 'M∆M'},
'shiro': {'name': 'Puşcaşu Dumitru', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Gumenîi Serghei', 'point1': 'M'},
'shiro': {'name': 'Puşcaşu Dumitru', 'point1': '∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Cismaş Octavian'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Gumenîi Serghei'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pool J', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pindelea Grigore', 'point1': nan},
'shiro': {'name': 'Georgescu Silviu', 'point1': 'KD'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pindelea Grigore', 'point1': nan},
'shiro': {'name': 'Ianăş Florin', 'point1': 'KM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Georgescu Silviu', 'point1': nan},
'shiro': {'name': 'Ianăş Florin', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Georgescu Silviu'},
'shiro': {'name': 'Meci de departajare:', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Ianăş Florin'},
'shiro': {'name': 'Ianăș (I) - Georgescu (∆M∆M)', 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Pool L', 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Oţelea Cătălin', 'point1': nan},
'shiro': {'name': 'Crăciunel Ioan', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Oţelea Cătălin', 'point1': nan},
'shiro': {'name': 'Gheorghiță Andrei', 'point1': 'MM'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Crăciunel Ioan', 'point1': 'MK'},
'shiro': {'name': 'Gheorghiță Andrei', 'point1': 'M∆'},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc I.:', 'point1': 'Crăciunel Ioan'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': 'Loc II.:', 'point1': 'Gheorghiță Andrei'},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'},
{'match_type': '../data/raw/1999/CR/Results_CR1999.xlsx#IM$finals%×',
'aka': {'name': nan, 'point1': nan},
'shiro': {'name': nan, 'point1': nan},
'outcome': '×'}]
In [49]:
sheetname='IF'
shift=1
point_shift=1
skiprow=18
stage='finals'
nrows=8
matches=get_matches_from_table(filename,sheetname,skiprow,nrows=nrows,
shift=shift,point_shift=point_shift,stage=stage)
In [59]:
sheetname='IC'
shift=0
point_shift=1
skiprow=6
stage='finals'
nrows=8
matches=get_matches_from_table(filename,sheetname,skiprow,nrows=nrows,
shift=shift,point_shift=point_shift,stage=stage)
In [60]:
matches
Out[60]:
[{'match_type': 'IC$finals',
'aka': {'name': 'Mihai Ioana', 'point1': nan, 'point2': nan},
'shiro': {'name': 'Bercuban Arpad', 'point1': nan, 'point2': nan}},
{'match_type': 'IC$finals',
'aka': {'name': 'Mihai Ioana', 'point1': nan, 'point2': nan},
'shiro': {'name': 'Rădulescu Adrian', 'point1': 'M', 'point2': nan}},
{'match_type': 'IC$finals',
'aka': {'name': 'Mihai Ioana', 'point1': 'I', 'point2': nan},
'shiro': {'name': 'Popescu Andrei', 'point1': 'M', 'point2': '∆∆∆'}},
{'match_type': 'IC$finals',
'aka': {'name': 'Bercuban Arpad', 'point1': nan, 'point2': nan},
'shiro': {'name': 'Rădulescu Adrian', 'point1': 'MM', 'point2': nan}},
{'match_type': 'IC$finals',
'aka': {'name': 'Bercuban Arpad', 'point1': nan, 'point2': '∆'},
'shiro': {'name': 'Popescu Andrei', 'point1': 'M', 'point2': '∆'}},
{'match_type': 'IC$finals',
'aka': {'name': 'Rădulescu Adrian', 'point1': 'I', 'point2': nan},
'shiro': {'name': 'Popescu Andrei', 'point1': nan, 'point2': '∆∆'}}]
In [173]:
matches=[]
names=df[::2][0].values
n=len(df.columns)-2
for stg in range(1,n):
indices=np.array([i for i in range(2**n)][::2**stg])+2**(stg-1)-1
if stg>0:
indices+=[i%2 for i in range(len(indices))]
print(indices)
#if stg==1:
if True:
winners=[]
for j in range(len(names)//2):
aka=df.loc[indices[j*2]][stg]
shiro=df.loc[indices[j*2+1]][stg]
if str(aka)=='nan': aka=''
if str(shiro)=='nan': shiro=''
match={'aka':{'name':names[j*2],
'point1':aka},
'shiro':{'name':names[j*2+1],
'point1':shiro}}
if point_utils.points_cleaner(match['aka']['point1'])[2]<point_utils.points_cleaner(match['shiro']['point1'])[2]:
winners.append(match['shiro']['name'])
else:
winners.append(match['aka']['name'])
matches.append(match)
names=winners
[ 0 3 4 7 8 11 12 15 16 19 20 23 24 27 28 31 32 35 36 39 40 43 44 47
48 51 52 55 56 59 60 63]
[ 1 6 9 14 17 22 25 30 33 38 41 46 49 54 57 62]
[ 3 12 19 28 35 44 51 60]
[ 7 24 39 56]
[15 48]
In [174]:
matches
Out[174]:
[{'aka': {'name': nan, 'point1': ''}, 'shiro': {'name': nan, 'point1': ''}},
{'aka': {'name': nan, 'point1': ''}, 'shiro': {'name': nan, 'point1': ''}},
{'aka': {'name': 'Hajdú Csaba', 'point1': ''},
'shiro': {'name': 'Veronescu Horia', 'point1': ''}},
{'aka': {'name': 'Căruntu Bogdan', 'point1': 'M'},
'shiro': {'name': 'Ghergheli Lucian', 'point1': 'KM'}},
{'aka': {'name': 'Furtună George', 'point1': '?'},
'shiro': {'name': 'Vitali Oncea', 'point1': ''}},
{'aka': {'name': 'Győrfi György', 'point1': ''},
'shiro': {'name': 'Cismas Octavian', 'point1': 'MM'}},
{'aka': {'name': 'Gârbea Ion', 'point1': '?'},
'shiro': {'name': 'Gheorghiţă Andrei', 'point1': ''}},
{'aka': {'name': 'Drăghici Dan', 'point1': 'MM'},
'shiro': {'name': 'Bejgu Nicolae', 'point1': ''}},
{'aka': {'name': 'Nistorel Remus', 'point1': '?'},
'shiro': {'name': 'Bejenariu Gabriel', 'point1': ''}},
{'aka': {'name': 'Oleg Banaga', 'point1': ''},
'shiro': {'name': 'Morar Dumitru', 'point1': 'MM'}},
{'aka': {'name': 'Andronache Marius', 'point1': ''},
'shiro': {'name': 'Amuraţiu Ştefăniţă', 'point1': '?'}},
{'aka': {'name': 'Zahan Sorin', 'point1': 'DK'},
'shiro': {'name': 'Buzás Csaba', 'point1': ''}},
{'aka': {'name': 'Popescu Roland', 'point1': '?'},
'shiro': {'name': 'Morar Florin', 'point1': ''}},
{'aka': {'name': 'Iliescu Dragoş', 'point1': 'MK'},
'shiro': {'name': 'Moraru Cristinel', 'point1': ''}},
{'aka': {'name': 'Székely Pál', 'point1': ''},
'shiro': {'name': 'Sántha Szabolcs', 'point1': '?'}},
{'aka': {'name': nan, 'point1': ''}, 'shiro': {'name': nan, 'point1': '?'}},
{'aka': {'name': nan, 'point1': ''}, 'shiro': {'name': nan, 'point1': ''}},
{'aka': {'name': 'Hajdú Csaba', 'point1': ''},
'shiro': {'name': 'Ghergheli Lucian', 'point1': 'M'}},
{'aka': {'name': 'Furtună George', 'point1': 'M'},
'shiro': {'name': 'Cismas Octavian', 'point1': ''}},
{'aka': {'name': 'Gârbea Ion', 'point1': 'M'},
'shiro': {'name': 'Drăghici Dan', 'point1': ''}},
{'aka': {'name': 'Nistorel Remus', 'point1': 'MM'},
'shiro': {'name': 'Morar Dumitru', 'point1': ''}},
{'aka': {'name': 'Amuraţiu Ştefăniţă', 'point1': 'I'},
'shiro': {'name': 'Zahan Sorin', 'point1': '∆∆'}},
{'aka': {'name': 'Popescu Roland', 'point1': ''},
'shiro': {'name': 'Iliescu Dragoş', 'point1': 'MM'}},
{'aka': {'name': 'Sántha Szabolcs', 'point1': ''},
'shiro': {'name': nan, 'point1': ''}},
{'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Ghergheli Lucian', 'point1': ''}},
{'aka': {'name': 'Furtună George', 'point1': ''},
'shiro': {'name': 'Gârbea Ion', 'point1': 'M'}},
{'aka': {'name': 'Nistorel Remus', 'point1': '?'},
'shiro': {'name': 'Amuraţiu Ştefăniţă', 'point1': ''}},
{'aka': {'name': 'Iliescu Dragoş', 'point1': '∆M'},
'shiro': {'name': 'Sántha Szabolcs', 'point1': '∆'}},
{'aka': {'name': nan, 'point1': ''},
'shiro': {'name': 'Gârbea Ion', 'point1': 'K'}},
{'aka': {'name': 'Nistorel Remus', 'point1': 'M'},
'shiro': {'name': 'Iliescu Dragoş', 'point1': 'MK'}},
{'aka': {'name': 'Gârbea Ion', 'point1': ''},
'shiro': {'name': 'Iliescu Dragoş', 'point1': '∆M'}}]
In [150]:
In [131]:
len((df.index))//2-1
Out[131]:
31
In [88]:
matches
Out[88]:
[]
In [ ]:
In [ ]:
In [17]:
df=pd.read_excel(filename,sheet_name=sheetname,header=None,skiprows=skiprow)
In [18]:
df
Out[18]:
OrderedDict([('IF',
0 1 2 3 4 5 6 7 8 9 ... 15 \
0 1.0 Alina State NaN NaN NaN MM NaN M NaN KK ... MM
1 NaN NaN NaN NaN NaN V NaN V NaN V ... V
2 2.0 Oprisan Adina NaN NaN NaN NaN NaN NaN NaN NaN ... MM
3 NaN NaN NaN I NaN NaN NaN I NaN I ... V
4 3.0 Marinescu Cristina NaN NaN NaN MM NaN NaN NaN M ... MM
5 NaN NaN NaN I NaN V NaN NaN NaN V ... V
6 4.0 Nicola Delia NaN NaN NaN NaN NaN NaN NaN NaN ... MM
7 NaN NaN NaN I NaN I NaN I NaN NaN ... V
8 5.0 Hajdu Rita NaN NaN NaN NaN NaN NaN NaN NaN ... NaN
9 NaN NaN NaN I NaN I ∆ I NaN I ... I
10 6.0 Ferencz Tunde NaN NaN NaN D NaN MM NaN D ... M
11 NaN NaN NaN I NaN V NaN V NaN V ... I
12 7.0 Fecioru Mica NaN NaN NaN NaN NaN NaN NaN NaN ... NaN
13 NaN NaN NaN I NaN I NaN I NaN I ... NaN
14 8.0 Grapa Danilea NaN NaN NaN MM NaN KM NaN M ... NaN
15 NaN NaN NaN I NaN V NaN V NaN V ... I
16 17 18 19 20 21 22 23 24
0 NaN MM 7.0 NaN 12.0 NaN 1.0 NaN NaN
1 NaN V NaN NaN NaN NaN NaN NaN NaN
2 NaN NaN 2.0 NaN 3.0 NaN 6.0 NaN NaN
3 NaN I NaN NaN NaN NaN NaN NaN NaN
4 NaN NaN 4.0 NaN 7.0 NaN 3.0 NaN NaN
5 NaN I NaN NaN NaN NaN NaN NaN NaN
6 NaN NaN 2.0 NaN 4.0 NaN 5.0 NaN NaN
7 NaN I NaN NaN NaN NaN NaN NaN NaN
8 NaN NaN 0.0 NaN 0.0 NaN 7.0 NaN NaN
9 NaN I NaN NaN NaN NaN NaN NaN NaN
10 NaN NaN 4.0 NaN 7.0 NaN 3.0 NaN 4?
11 NaN I NaN NaN NaN NaN NaN NaN NaN
12 NaN NaN 0.0 NaN 1.0 NaN 7.0 NaN NaN
13 NaN I NaN NaN NaN NaN NaN NaN NaN
14 NaN NaN 5.0 NaN 8.0 NaN 2.0 NaN NaN
15 NaN NaN NaN NaN NaN NaN NaN NaN NaN
[16 rows x 25 columns])])
In [9]:
matches=[]
sheetname='IM'
matches=matches+matches_loader.get_matches_from_list(filename,sheetname,column_keys_012_543,7,shift=0,stage='pool')
In [16]:
matches=[]
sheetname='ES'
matches=matches+matches_loader.get_matches_from_list(filename,sheetname,column_keys_312_543,20,shift=-1,stage='pool')
In [22]:
matches=[]
sheetname='ES'
matches=matches+matches_loader.get_matches_from_list(filename,sheetname,column_keys_312_543,20,shift=6,stage='pool')
In [23]:
matches[2]
Out[23]:
{'match_type': '../data/raw/1993/CR/1993.07.24 - Cupa Romaniei_print.xlsx#ES$pool%×',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'M'},
'shiro': {'name': 'Crăciunel Valentin', 'point1': 'MM'},
'outcome': '×'}
In [54]:
year=1993
path='../data/raw/'+str(year)+'/'+str(competition)+'/'
filename=path+'1993.07.24 - Cupa Romaniei_print.xlsx'
matches=[]
shift=6
drops=[]
sheetname='IM'
stage='finals'
rowheight=3
nrows=6
point_shift=0
if rowheight>1:
nrows=nrows*rowheight
df=pd.read_excel(filename,sheet_name=sheetname,header=None,skiprows=7)
df=df[df.columns[shift:]].drop(drops,axis=1).dropna(how='all',axis=1)
df=df.reset_index(drop=True)
df.columns=range(len(df.columns))
if nrows>0:
df=df.loc[:nrows-1]
if rowheight>1:
df=df[::rowheight].reset_index(drop=True)
for i in range(len(df.index)):
for j in range(1,len(df.index)+1):
if i<(j-1):
match={'match_type':sheetname+'$'+stage,'aka':{'name':df.loc[i][0],
'point1':df.loc[i][j+point_shift]},
'shiro':{'name':df.loc[(j-1)][0],
'point1':df.loc[(j-1)][i+point_shift+1]}}
matches.append(match)
In [55]:
matches
Out[55]:
[{'match_type': 'IM$finals',
'aka': {'name': 'Sandu Matei', 'point1': '×'},
'shiro': {'name': 'Ghergheli Lucian', 'point1': 'DM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Sandu Matei', 'point1': 'D×'},
'shiro': {'name': 'Cismas Octavian', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Sandu Matei', 'point1': '×'},
'shiro': {'name': 'Gârbea Ion', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Sandu Matei', 'point1': '×'},
'shiro': {'name': 'Crăciunel Ioan', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Sandu Matei', 'point1': '×'},
'shiro': {'name': 'Crăciunel Cătălin', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Ghergheli Lucian', 'point1': '×'},
'shiro': {'name': 'Cismas Octavian', 'point1': 'M'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'DM'},
'shiro': {'name': 'Gârbea Ion', 'point1': '×'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'M×'},
'shiro': {'name': 'Crăciunel Ioan', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Ghergheli Lucian', 'point1': 'D×'},
'shiro': {'name': 'Crăciunel Cătălin', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Cismas Octavian', 'point1': '×'},
'shiro': {'name': 'Gârbea Ion', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Cismas Octavian', 'point1': 'M×'},
'shiro': {'name': 'Crăciunel Ioan', 'point1': 'MM'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Cismas Octavian', 'point1': 'DM'},
'shiro': {'name': 'Crăciunel Cătălin', 'point1': '×'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Gârbea Ion', 'point1': 'MM'},
'shiro': {'name': 'Crăciunel Ioan', 'point1': '×'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Gârbea Ion', 'point1': 'D'},
'shiro': {'name': 'Crăciunel Cătălin', 'point1': 'M'}},
{'match_type': 'IM$finals',
'aka': {'name': 'Crăciunel Ioan', 'point1': 'DD'},
'shiro': {'name': 'Crăciunel Cătălin', 'point1': '×'}}]
In [16]:
year=2009
competition='CR'
path='../data/raw/'+str(year)+'/'+str(competition)+'/'
filename=path+'2009.04.04 - CR - Budeasa - print.xlsx'
stage=''
matches=[]
#part 1
#part 2
sheetnames=[['IJ'],['IF']]
skiprows=[12,13]
shifts=[1,1]
point_shifts=[0,0]
nrowss=[5,6]
for i in range(len(sheetnames)):
sheetname=sheetnames[i]
skiprow=skiprows[i]
shift=shifts[i]
point_shift=point_shifts[i]
nrows=nrowss[i]
matches=matches+get_matches_from_table_oneliner(filename,sheetname,skiprow,
point_shift=point_shift,shift=shift,nrows=nrows,stage=stage)
In [17]:
matches
Out[17]:
[{'match_type': 'IJ$',
'aka': {'name': 'Chirea Valentin', 'point1': 'DD'},
'shiro': {'name': 'Nagy Vlad', 'point1': nan}},
{'match_type': 'IJ$',
'aka': {'name': 'Chirea Valentin', 'point1': 'M'},
'shiro': {'name': 'Chirea Alin', 'point1': 'MM'}},
{'match_type': 'IJ$',
'aka': {'name': 'Chirea Valentin', 'point1': 'D'},
'shiro': {'name': 'Benedek László', 'point1': nan}},
{'match_type': 'IJ$',
'aka': {'name': 'Chirea Valentin', 'point1': 2},
'shiro': {'name': 'Illyés Attlia', 'point1': 'M'}},
{'match_type': 'IJ$',
'aka': {'name': 'Nagy Vlad', 'point1': nan},
'shiro': {'name': 'Chirea Alin', 'point1': 'MM'}},
{'match_type': 'IJ$',
'aka': {'name': 'Nagy Vlad', 'point1': nan},
'shiro': {'name': 'Benedek László', 'point1': nan}},
{'match_type': 'IJ$',
'aka': {'name': 'Nagy Vlad', 'point1': 0},
'shiro': {'name': 'Illyés Attlia', 'point1': 'MK'}},
{'match_type': 'IJ$',
'aka': {'name': 'Chirea Alin', 'point1': 'MM'},
'shiro': {'name': 'Benedek László', 'point1': nan}},
{'match_type': 'IJ$',
'aka': {'name': 'Chirea Alin', 'point1': 4},
'shiro': {'name': 'Illyés Attlia', 'point1': 'KK'}},
{'match_type': 'IJ$',
'aka': {'name': 'Benedek László', 'point1': 0},
'shiro': {'name': 'Illyés Attlia', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Spiru Camelia', 'point1': 'MK'},
'shiro': {'name': 'Grapă Daniela', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Spiru Camelia', 'point1': 'KM'},
'shiro': {'name': 'Neagu Florenta', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Spiru Camelia', 'point1': nan},
'shiro': {'name': 'Călina Cristina', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Spiru Camelia', 'point1': 'KK'},
'shiro': {'name': 'Moise Maria', 'point1': 'M'}},
{'match_type': 'IF$',
'aka': {'name': 'Spiru Camelia', 'point1': 4},
'shiro': {'name': 'Mehelean Ligia', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Grapă Daniela', 'point1': 'MM'},
'shiro': {'name': 'Neagu Florenta', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Grapă Daniela', 'point1': 'K'},
'shiro': {'name': 'Călina Cristina', 'point1': 'M'}},
{'match_type': 'IF$',
'aka': {'name': 'Grapă Daniela', 'point1': 'MM'},
'shiro': {'name': 'Moise Maria', 'point1': 'KD'}},
{'match_type': 'IF$',
'aka': {'name': 'Grapă Daniela', 'point1': 3},
'shiro': {'name': 'Mehelean Ligia', 'point1': 'M'}},
{'match_type': 'IF$',
'aka': {'name': 'Neagu Florenta', 'point1': nan},
'shiro': {'name': 'Călina Cristina', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Neagu Florenta', 'point1': 'MM'},
'shiro': {'name': 'Moise Maria', 'point1': 'MK'}},
{'match_type': 'IF$',
'aka': {'name': 'Neagu Florenta', 'point1': 1},
'shiro': {'name': 'Mehelean Ligia', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Călina Cristina', 'point1': nan},
'shiro': {'name': 'Moise Maria', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Călina Cristina', 'point1': 1},
'shiro': {'name': 'Mehelean Ligia', 'point1': nan}},
{'match_type': 'IF$',
'aka': {'name': 'Moise Maria', 'point1': 4},
'shiro': {'name': 'Mehelean Ligia', 'point1': nan}}]
Content source: try-something-new-everyday/blog
Similar notebooks: