Problem Statement: In Python for this program, you are to implement a 2 stage program(2 files) that preprocesses historical futbal match data to predict future quarterfinal matchups. In order to complete this program you need to first write a program that can take historical futbol matches and process them in to a format we can use for the second part (See preprocessing). Once the data has been processed in to a usable format you will need to write a program that predicts the results of a quarterfinal matchupfsee results). Input You will be given a file of historic futbol matches (matches.csv) that has 476 matches between 10 teams. The columns are home team, away team, home goals, away goals. You can assume that the 10 team names do not change for your code. The team names are ['Everton', 'Stoke', "Arsenal', 'Swansea', 'Man United', 'Liverpool', 'Southampton', Man City', 'West Brom', 'Chelsea']. Preprocessing: In order to predict the quarterfinal matchups you first need to convert the game data to a format w use. You will need to build a list for each team being tracked of the format: Team Name, index win, index lose, index draw, name, name name Where Team Name' is the name of the team you are tracking in that row. 'index win'(int) is the starting index of teams they beat, 'index lose'(int) is starting index of teams they lost to, and 'index draw(int) is the starting index of teams they tied. The remainder of the list is an unsorted sequence of names(that may repeat) for wins, loses, and draws based on the 3 indices. This data will then need to be written to a file. See 'preprocessed.csv' for example output. Problem Statement: In Python for this program, you are to implement a 2 stage program(2 files) that preprocesses historical futbal match data to predict future quarterfinal matchups. In order to complete this program you need to first write a program that can take historical futbol matches and process them in to a format we can use for the second part (See preprocessing). Once the data has been processed in to a usable format you will need to write a program that predicts the results of a quarterfinal matchupfsee results). Input You will be given a file of historic futbol matches (matches.csv) that has 476 matches between 10 teams. The columns are home team, away team, home goals, away goals. You can assume that the 10 team names do not change for your code. The team names are ['Everton', 'Stoke', "Arsenal', 'Swansea', 'Man United', 'Liverpool', 'Southampton', Man City', 'West Brom', 'Chelsea']. Preprocessing: In order to predict the quarterfinal matchups you first need to convert the game data to a format w use. You will need to build a list for each team being tracked of the format: Team Name, index win, index lose, index draw, name, name name Where Team Name' is the name of the team you are tracking in that row. 'index win'(int) is the starting index of teams they beat, 'index lose'(int) is starting index of teams they lost to, and 'index draw(int) is the starting index of teams they tied. The remainder of the list is an unsorted sequence of names(that may repeat) for wins, loses, and draws based on the 3 indices. This data will then need to be written to a file. See 'preprocessed.csv' for example output