コード例 #1
0
        public static void writeToExcel <T>(NNsTestResults <T> testResults, string rootPath)
        {
            createRootResultsDirectoryIfNotExists(rootPath);

            List <int>       correctAnswersAmount = testResults.correctAnswersAmount;
            List <T>         correctAnswers       = testResults.correctAnswers;
            List <List <T> > answers = testResults.answers;

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
            using ExcelPackage package  = new ExcelPackage(new FileInfo($"{rootPath}/test_results.xlsx"));
            ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Results");

            worksheet.Cells[1, 1].Value                  = "EXP";
            worksheet.Cells[1, 1].Style.Font.Bold        = true;
            worksheet.Cells[2, 1].Value                  = correctAnswers.Count;
            worksheet.Column(1).Style.Border.Right.Style = ExcelBorderStyle.Thin;

            for (int i = 0; i < correctAnswers.Count; i++)
            {
                worksheet.Cells[i + 4, 1].Value = correctAnswers[i];
            }

            for (int nnIndex = 0; nnIndex < answers.Count; nnIndex++)
            {
                int currentColumn = nnIndex + 2;

                worksheet.Cells[1, currentColumn].Value           = "NN " + (nnIndex + 1);
                worksheet.Cells[1, currentColumn].Style.Font.Bold = true;

                worksheet.Cells[2, currentColumn].Value = correctAnswersAmount[nnIndex];
                worksheet.Cells[3, currentColumn].Value = correctAnswersAmount[nnIndex] * 1d / answers[nnIndex].Count;

                for (int answerIndex = 0; answerIndex < answers[nnIndex].Count; answerIndex++)
                {
                    worksheet.Cells[4 + answerIndex, currentColumn].Value = answers[nnIndex][answerIndex];
                    if (!answers[nnIndex][answerIndex].Equals(correctAnswers[answerIndex]))
                    {
                        worksheet.Cells[4 + answerIndex, currentColumn].Style.Font.Color.SetColor(Color.Red);
                    }
                }

                worksheet.Column(currentColumn).Style.Border.Right.Style = ExcelBorderStyle.Thin;
            }

            package.Save();
        }
コード例 #2
0
        public static void run()
        {
            Console.Write("Hello. Enter experiments title: ");
            string experimentTitle = Console.ReadLine();

            Console.Write("Enter experiments description: ");
            string experimentDescription = Console.ReadLine();

            string        rootPath = $"C://nnlib/experiments/{experimentTitle}";
            ExperimentLog log      = new ExperimentLog(experimentTitle, experimentDescription, parallelNns);

            Console.Write("Initialisation of NNs...");
            List <NeuralNetwork> nns = setupNNs(log);

            Console.WriteLine(" Done.");

            Console.WriteLine("Training started!");
            Console.Write("In progress");
            train(nns, trainSize, log);
            Console.WriteLine(" Done.");

            Console.WriteLine("Testing started!");
            Console.Write("In progress");
            NNsTestResults <int> testResults = test(nns, testSize, log);

            Console.WriteLine(" Done.");

            Console.Write("Saving log... ");
            Utils.endLogAndWriteToFile(log, rootPath);
            Console.WriteLine(" Done.");

            Console.Write("Writing results to excel... ");
            Utils.writeToExcel(testResults, rootPath);
            Console.WriteLine(" Done.");

            Console.Write("Writing NNs configurations to files... ");
            Utils.writeNNsToFiles(nns, rootPath);
            Console.WriteLine(" Done.");

            Console.WriteLine("Process is completed and result is saved in excel file.");
            Console.ReadKey();
        }
コード例 #3
0
        public static void run()
        {
            Console.Write("Hello. Enter experiments title: ");
            string experimentTitle = Console.ReadLine();

            Console.Write("Enter experiments description: ");
            string experimentDescription = Console.ReadLine();

            string        rootPath = $"./experiments/{experimentTitle}";
            ExperimentLog log      = new ExperimentLog(experimentTitle, experimentDescription, 1);

            Console.Write("Enter config files name: ./experiments/loads/");
            string loadName = Console.ReadLine();

            Console.Write("Deserialization of NN...");
            NeuralNetwork nn = deserialize($"./experiments/loads/{loadName}", log);

            Console.WriteLine(" Done.");

            Console.WriteLine("Testing started!");
            Console.Write("In progress");
            NNsTestResults <int> testResults = Mnist.test(new List <NeuralNetwork> {
                nn
            }, testSize, log);

            Console.WriteLine(" Done.");

            Console.Write("Saving log... ");
            Utils.endLogAndWriteToFile(log, rootPath);
            Console.WriteLine(" Done.");

            Console.Write("Writing data to excel... ");
            Utils.writeToExcel(testResults, rootPath);
            Console.WriteLine(" Done.");

            Console.WriteLine("Process is completed and result is saved in excel file.");
            Console.ReadKey();
        }