public void CleanColumn(string columnName)
{
if (!Columns.Contains(columnName))
{
return;
}
Logger.LogMessage($"\nCreate temporary data list");
List <string> tempList = GetRows(columnName);
Logger.LogMessage($"Create DataCleaner, ready to clean {tempList.Count} rows");
DataCleaner dataCleaner = new DataCleaner(tempList, columnName);
var cleanedData = dataCleaner.Clean();
for (int i = 0; i < cleanedData.Count; i++)
{
try
{
DrugDataTable.Rows[i][columnName] = cleanedData[i];
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
Logger.LogMessage($"Data has been updated in Dataset successfully\n");
}
private void TrimDataset()
{
Columns.ForEach(column =>
{
var cleaner = new DataCleaner(GetRows(column), column);
var trimmedData = cleaner.TrimColumn();
for (int i = 0; i < trimmedData.Count; i++)
{
try
{
DrugDataTable.Rows[i][column] = trimmedData[i];
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
});
}
