static void Main(string[] args) { #region Combine path string folder = ".\\..\\..\\..\\Data"; string fileName = "example.xlsx"; string path = Path.Combine(folder, fileName); #endregion IKMeansBuilder kMeansBuilder = new KMeansBuilder(); IKMeans kMeans; kMeans = kMeansBuilder .Init(new KMeansInitialization()) .SetNumberOfClusters(2) .Build(); IDataView data = DataReaderExcel.ReadDataFromExcel( path: path, hasHeader: true, worksheet: 3, startColumn: 2); var clustered = kMeans.FitPredict(data); IQualityMeasurement qualityMeasurementAlgorithm = new IndexC(); var res = qualityMeasurementAlgorithm.EvaluateQuality(clustered, new EuclideanDistance()); Console.WriteLine(res); Console.Read(); }
public void parseFileTest() { DataReaderExcel target = new DataReaderExcel(); target.setFilePath(this.testDataSource); bool expected = true; bool actual; actual = target.parseFile("Sheet1"); // Check that it parsed correctly Assert.AreEqual <bool>(expected, actual); // Check parsed DataTable results = target.getDataSet(); Assert.IsNotNull(results); // Check column names Assert.AreEqual <String>(results.Columns[0].ColumnName, "FIRST_NAME"); Assert.AreEqual <String>(results.Columns[1].ColumnName, "LAST_NAME"); // Check strings Assert.AreEqual <String>((String)results.Rows[0][0], "Reed"); Assert.AreEqual <String>((String)results.Rows[0][1], "Richards"); Assert.AreEqual <String>((String)results.Rows[7][0], "Thor"); // Check Empty String Assert.AreEqual <String>((String)results.Rows[7][1], ""); }
public async Task <IDataView> GetDataViewFromFile(IFormFile file) // check extension { var filePath = Path.GetTempFileName(); IDataView data = null; if (file != null) { using (var stream = new FileStream(filePath, FileMode.Create)) { await file.CopyToAsync(stream); data = DataReaderExcel.ReadDataFromExcel(stream, true, 3, 2); } } return(data); }
public void formatDataTest() { // Parse Test Document DataReaderExcel target = new DataReaderExcel(); target.setFilePath(this.testDataSource); target.parseFile("Sheet1"); DataTable results = target.getDataSet(); // Check date format Object obj = results.Rows[4][10]; DateTime date = new DateTime(2012, 5, 29); Assert.AreEqual <String>((String)results.Rows[4][10], date.ToShortDateString()); date = new DateTime(2012, 7, 4); Assert.AreEqual <String>((String)results.Rows[4][10], date.ToShortDateString()); }