public async Task Initialize() { Sheet sheet; if (Settings.Instance.RecentFile != null) { try { sheet = await CsvLoader.LoadLocal(Settings.Instance.RecentFile); } catch { sheet = await CsvLoader.Load("student-mat.csv"); } } else { sheet = await CsvLoader.Load("student-mat.csv"); } await Logger.Instance.Initialize(); Logger.Instance.Log("Logging has been started."); Initialize(sheet); }
public void LoadTest() { ILogger <CsvLoader> logger = new NullLogger <CsvLoader>(); CsvLoader rssStoreCsv = new CsvLoader(logger); var ret = rssStoreCsv.Load <RssSource, RssSourceMap>(); ret.Should().NotBeNull(); }
static void Main(string[] args) { var csvFilePath = Path.Combine(Environment.CurrentDirectory, "test.csv"); var products = CsvLoader.Load <Product>(csvFilePath); foreach (var product in products) { Console.WriteLine(product.ToString()); } Console.ReadKey(); }
static void Import() { var productCsvFile = Path.Combine(Environment.CurrentDirectory, "product.csv"); using (var storeCtx = new StoreContext()) { var products = CsvLoader.Load <Product>(productCsvFile); storeCtx.Database.ExecuteSqlCommand("DELETE [Products]"); storeCtx.Products.AddRange(products); storeCtx.SaveChanges(); } }
public void Given_WrongFilePath_ExceptionMessage_Should_ReflectFilePath() { string invalidFilePath = "\\not-exist-file-path\not-exist.csv"; try { CsvLoader.Load <Player>(invalidFilePath); } catch (FileNotFoundException ex) { Assert.AreEqual(ex.Message, $"File not found: {invalidFilePath}"); } }
[Test] public void Test_loading_file_without_a_preprocessor() { var c = new CsvLoader <C1>(); var csvcontent = "prop1,prop2\n0,1\n2,3"; var file = "Test_loading_file_without_a_preprocessor.csv"; File.WriteAllText(file, csvcontent); var rows = c.Load(file).ToArray(); Assert.AreEqual(2, rows.Length); Assert.AreEqual(0, rows[0].prop1); Assert.AreEqual(1, rows[0].prop2); Assert.AreEqual(2, rows[1].prop1); Assert.AreEqual(3, rows[1].prop2); }
static void Main(string[] args) { var traininDataset = CsvLoader.Load(@"C:\1tra.csv", out InstanceModel trModel); var testingDataset = CsvLoader.Load(@"C:\1tst.csv", out InstanceModel tsModel); BaggingRandomMiner classifier = new BaggingRandomMiner(); classifier.Train(trModel, traininDataset); foreach (var obj in testingDataset) { Console.WriteLine(classifier.Classify(obj)[0]); } Console.ReadLine(); }
[Test] public void Test_loading_file_with_a_preprocessor() { var c = new CsvLoader <C1>(); var csvcontent = "prop1,prop2\n0,1\n2,3"; var file = "Test_loading_file_with_a_preprocessor.csv"; File.WriteAllText(file, csvcontent); var rows = c.Load(file, l => { var tokens = l.Split(','); Assert.AreEqual(2, tokens.Length); return(String.Join(",", tokens.Select(t => "1" + t))); }).ToArray(); Assert.AreEqual(2, rows.Length); Assert.AreEqual(10, rows[0].prop1); Assert.AreEqual(11, rows[0].prop2); Assert.AreEqual(12, rows[1].prop1); Assert.AreEqual(13, rows[1].prop2); }
static void Main(string[] args) { var dataset = CsvLoader.Load(@"dataset.csv", out InstanceModel model).ToList(); var instanceIndex = new Dictionary <Instance, int>(); for (int i = 0; i < dataset.Count; i++) { instanceIndex.Add(dataset[i], i); } var clusteringAlgorithm = new eUD35() { ClusterCount = 3 }; var clusters = clusteringAlgorithm.FindClusters(model, dataset, out List <IEmergingPattern> patterns).ToList(); var clusterPerInstanceIdx = new Dictionary <int, string>(); for (int i = 0; i < clusters.Count; i++) { foreach (var instance in clusters[i]) { clusterPerInstanceIdx.Add(instanceIndex[instance], $"cluster{i}"); } } Console.WriteLine("***************** Cluster per instance *****************"); for (int i = 0; i < dataset.Count; i++) { Console.WriteLine(clusterPerInstanceIdx[i]); } Console.WriteLine("\n***************** Patterns *****************"); foreach (var p in patterns) { Console.WriteLine(p); } Console.ReadLine(); }
public void Given_WrongFilePath_Should_ThrowFileNotFoundException() { CsvLoader.Load <Player>("\\not-exist-file-path\not-exist.csv"); }