public static void PrintTestFile(int daysToGet, int competitionId) { StatisticLine.initDict(); var matchesToWrite = new List <string>(); var linesToWrite = new List <string>(); linesToWrite.Add(StatisticLine.PrintCsvTestAttrs()); var matches = PremierLeagueMainProject.GetNextMatches(daysToGet); foreach (var match in matches) { var matchLine = match.HomeTeam + " VS. " + match.AwayTeam; Console.WriteLine(match.HomeTeam + " VS. " + match.AwayTeam); matchesToWrite.Add(match.HomeTeam + " VS. " + match.AwayTeam); var sl = new StatisticLine(); sl.init(match.HomeTeam, match.AwayTeam, match.Date, competitionId); sl.BuildTestLine(); var line = matchLine + "," + sl.Print(); if (line != null) { linesToWrite.Add(line); } } File.WriteAllLines(@"C:\Users\user\Desktop\DataProjects\PredictionsModel\test.csv", linesToWrite); //File.WriteAllLines(@"C:\Users\user\Desktop\DataProjects\testlines.csv", matchesToWrite); }
public static void PrintTrainingFile() { StatisticLine.initDict(); var competitions = new List <int> { 2, 3, 4, 8, 9, 10, 11 }; var linesToWrite = new List <string>(); linesToWrite.Add(StatisticLine.PrintCsvTrainAttrs()); int cnt = 0; using (var db = new sakilaEntities4()) { foreach (var competition in competitions) { Console.WriteLine(competition); var matches = db.competitionmatch.Where(x => x.CompetitionID == competition).ToList(); foreach (var match in matches) { var sl = new StatisticLine(); sl.init(match.HomeTeamID, match.AwayTeamID, match.MatchDate, match.CompetitionID); sl.BuildTrainingLine(); var line = sl.Print(); if (line != null) { linesToWrite.Add(line); cnt = cnt + 1; Console.WriteLine(cnt); } } } } //File.WriteAllLines(@"C:\Users\user\Desktop\DataProjects\training.arff", linesToWrite); File.WriteAllLines(@"C:\Users\user\Desktop\DataProjects\PredictionsModel\train.csv", linesToWrite); }