def run(): cl_qualifiers_raw = read_input("cl_qualifiers") el_qualifiers_raw = read_input("el_qualifiers") cl_qualifiers, el_qualifiers = [], [] for season in range(SEASON_START, SEASON_END): cl_single_season = cl_qualifiers_raw[cl_qualifiers_raw["Year"] == season].copy() el_single_season = el_qualifiers_raw[el_qualifiers_raw["Year"] == season].copy() cl_qualifiers.append( calculate_record( fill_results(prepare_for_record(cl_single_season)), season)) el_qualifiers.append( calculate_record( fill_results(prepare_for_record(el_single_season)), season)) cl_qualifiers_record = pd.concat(cl_qualifiers) el_qualifiers_record = pd.concat(el_qualifiers) rename_qualifiers_cols(cl_qualifiers_record, "CLQ") rename_qualifiers_cols(el_qualifiers_record, "ELQ") save_output_to_csv(cl_qualifiers_record, "cl_qualifiers_aggregated") save_output_to_csv(el_qualifiers_record, "el_qualifiers_aggregated")
def run(self): cl_qualifiers = cleanup_dataframe( self.qualifiers_results(self.URL_CL_QUALIFIERS)) el_qualifiers = cleanup_dataframe( self.qualifiers_results(self.URL_EL_QUALIFIERS)) cl_qualifiers = self.get_first_game_result(cl_qualifiers) el_qualifiers = self.get_first_game_result(el_qualifiers) save_output_to_csv(output=cl_qualifiers, filename="cl_qualifiers") save_output_to_csv(output=el_qualifiers, filename="el_qualifiers")
def run(): teams_general = read_input("teams_general") teams_detailed = read_input("teams_detailed") teams = pd.merge(teams_general, teams_detailed, left_index=True, right_index=True) change_transfers_to_numerical(teams) change_age_to_numerical(teams) teams = convert_units(teams) save_output_to_csv(teams, "teams")
def collect_european_cups_record(self): european_cup, empty = [], [] clubs_ids = self.collect_uefa_clubs_ids() for club_id in clubs_ids["UefaId"]: try: european_cup.append( results_table(self._URL_UEFA_CUPS_RESULT, club_id)) except: empty.append(club_id) missing_uefa_ids = clubs_ids[clubs_ids['Team'].isin( empty)].reset_index(drop=True) save_output_to_csv(missing_uefa_ids, "missing_uefa_ids") european_cup = pd.concat(european_cup) european_cup = european_cup.merge(clubs_ids, how="left", left_on="UefaId", right_on="UefaId") return european_cup
def run(): teams_full_record = cleanup_dataframe(read_input("teams_full_record")) my_uefa = read_input("uefa_ranking") weight = calculate_weight(teams_full_record, my_uefa) teams_full_record = teams_full_record.merge(weight, how="left", left_on=["Country", "Year"], right_on=["Country", "Year"]) calculate_score_for_single_cup(teams_full_record, "EL") calculate_score_for_single_cup(teams_full_record, "CL") calculate_score_for_single_cup(teams_full_record, "ELQ") calculate_score_for_single_cup(teams_full_record, "CLQ") calculate_score_for_single_cup(teams_full_record, "DL") teams_full_record.replace(np.nan, 0, inplace=True) calculate_score(teams_full_record) save_output_to_csv(teams_full_record, "teams_score")
def run(): teams_dl_uefa_record = read_input("teams_dl_uefa_record") cl_qualifiers = read_input("cl_qualifiers_aggregated") el_qualifiers = read_input("el_qualifiers_aggregated") teams_dl_uefa_record["TransfermarktId"] = teams_dl_uefa_record[ "Link"].str.split(expand=True, pat='/')[4].astype(int) teams_dl_uefa_qualifiers_record = pd.merge( teams_dl_uefa_record, cl_qualifiers, how="left", left_on=["TransfermarktId", "Year"], right_on=["TransfermarktId", "Year"]).merge(el_qualifiers, how="left", left_on=["TransfermarktId", "Year"], right_on=["TransfermarktId", "Year"]) teams_dl_uefa_qualifiers_record.replace(np.nan, 0, inplace=True) save_output_to_csv(teams_dl_uefa_qualifiers_record, "teams_dl_uefa_qualifiers_record")
def run(): transfermarkt = read_input("teams") soccerway = read_input("season_results") uefa = read_input("european_cups_record") transfermarkt_soccerway = merge_transfermarkt_soccerway( transfermarkt, soccerway) _, teams_complete = keep_complete(transfermarkt_soccerway) uefa_results_manually, uefa_match = match_teams(teams_complete, uefa, 0.5) uefa_match.update(manual_map_uefa) teams_complete['Team'] = teams_complete['Team'].map(uefa_match) uefa_ids = uefa[['Team', 'Country', 'UefaId']].drop_duplicates() teams_with_uefa_id = pd.merge(teams_complete, uefa_ids[["UefaId", "Team"]], how="left", left_on=["Team"], right_on=["Team"]) el_results = uefa[uefa['Competition'] == 'UEFA Europa League'] el_results = rename_qualifiers_cols(el_results, "AllEL") cl_results = uefa[uefa['Competition'] == 'UEFA Champions League'] cl_results = rename_qualifiers_cols(cl_results, "AllCL") teams_dl_uefa_record = pd.merge(teams_with_uefa_id, cl_results, how='left', left_on=['UefaId', 'Year'], right_on=['UefaId', 'Year']).merge( el_results, how='left', left_on=['UefaId', 'Year'], right_on=['UefaId', 'Year']) save_output_to_csv(teams_dl_uefa_record, "teams_dl_uefa_record")
def run(): teams_dl_uefa_qualifiers_record = read_input( "teams_dl_uefa_qualifiers_record") calculate_playoff_record(teams_dl_uefa_qualifiers_record, "CL") calculate_playoff_record(teams_dl_uefa_qualifiers_record, "EL") calculate_matches_played(teams_dl_uefa_qualifiers_record, "CL") calculate_matches_played(teams_dl_uefa_qualifiers_record, "EL") calculate_matches_played(teams_dl_uefa_qualifiers_record, "CLQ") calculate_matches_played(teams_dl_uefa_qualifiers_record, "ELQ") # correct mistaken results - Celitc, Legia season CL qualifiers 2015 teams_dl_uefa_qualifiers_record.loc[695:695, 'WinsCL'] = 0.0 teams_dl_uefa_qualifiers_record.loc[695:695, 'LossesCL'] = 0.0 teams_dl_uefa_qualifiers_record.loc[635:635, 'WinsCL'] = 0.0 teams_dl_uefa_qualifiers_record.loc[635:635, 'LossesCL'] = 0.0 cols_output = [ 'Country', 'Year', 'Team', 'Link', 'Value', 'Difference', 'Age', 'AbroadPlayers', 'StadiumCapacity', 'StadiumName', 'SquadSize', 'TopArrival', 'TopDeparture', 'IncomeValue', 'ExpenditureValues', 'OverallBalance', 'MatchesPlayedDL', 'WinsDL', 'DrawsDL', 'LossesDL', 'GoalsScored', 'GoalsAgainst', 'GoalsBalance', 'Points', 'Round', 'UefaId', 'TransfermarktId', 'CompetitionAllCL', 'StageAllCL', 'WinsAllCL', 'DrawsAllCL', 'LossesAllCL', 'MatchesPlayedAllCL', 'WinsCLQ', 'DrawsCLQ', 'LossesCLQ', 'MatchesPlayedCLQ', 'WinsCL', 'DrawsCL', 'LossesCL', 'MatchesPlayedCL', 'CompetitionAllEL', 'StageAllEL', 'WinsAllEL', 'DrawsAllEL', 'LossesAllEL', 'MatchesPlayedAllEL', 'WinsELQ', 'DrawsELQ', 'LossesELQ', 'MatchesPlayedELQ', 'WinsEL', 'DrawsEL', 'LossesEL', 'MatchesPlayedEL' ] save_output_to_csv(teams_dl_uefa_qualifiers_record[cols_output], "teams_full_record")
def run(self): season_results = self.collect_leagues_results() save_output_to_csv(output=season_results, filename="season_results")
def run(self): teams = self.keep_top_tier_teams( teams_per_season_league=self.collect_teams(), minimum_number_of_seasons=self.MINIMUM_SEASON) self.get_id_from_link(teams) save_output_to_csv(output=teams, filename="teams_general")
def run(self): teams = self.detailed_info_teams() save_output_to_csv(output=teams, filename="teams_detailed")
def run(self): similar_leagues_top_tier_links = self.similar_leagues_top_tier_links() save_output_to_csv(output=similar_leagues_top_tier_links, filename="similar_leagues_top_tier_links")
def run(self): uefa_ranking_similar_leagues, similar_leagues = self.run_uefa_coeff() save_output_to_csv(output=uefa_ranking_similar_leagues, filename="uefa_ranking") save_list_to_csv(output=similar_leagues, filename="similar_leagues")
def run(self): european_cups_record = self.format_european_cups_record( self.collect_european_cups_record()) save_output_to_csv(output=european_cups_record, filename="european_cups_record")