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);
}
