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