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