public static DataTable ReadFromCSV(string fullFilePath) { DataTable table = new DataTable(); using (CSVReader reader = new CSVReader(fullFilePath)) { // Create columns. ColumnName[] columns = new ColumnName[reader.TitlePositions.Count]; int columnIndex = 0; foreach (KeyValuePair<string, int> titleInfo in reader.TitlePositions.OrderBy(p => p.Value)) { columns[columnIndex++] = table.AddColumn(titleInfo.Key); } // Iterate through each row in the CSV file and add the data to the table. for (int rowIndex = 0; rowIndex < reader.Length(); rowIndex++) { // Create a new row. Row row = table.AppendRow(); for(columnIndex = 0; columnIndex < columns.Length; columnIndex++) { ColumnName columnName = columns[columnIndex]; row[columnName] = reader.GetValue(rowIndex, columnName.Name); } } } return table; }
public ColumnName(DataTable table, string name) { _Table = table; _Name = name; }
/// <summary> /// Generate CSV data (Probably not the most efficient way, e.g. How big can this become). /// </summary> /// <param name="reader"></param> private void WriteStatisticsToFile(CSVMetricReader reader) { var statisticsFilePath = $"{Configuration.RunId}-Statistics.csv"; var statisticsTable = new DataTable(); var col0_testName = statisticsTable.AddColumn("Test Name"); var col1_metric = statisticsTable.AddColumn("Metric"); var col2_iterations = statisticsTable.AddColumn("Iterations"); var col3_average = statisticsTable.AddColumn("Average"); var col4_stdevs = statisticsTable.AddColumn("Sample standard deviation"); var col5_min = statisticsTable.AddColumn("Minimum"); var col6_max = statisticsTable.AddColumn("Maximum"); foreach (var testCaseName in reader.TestCases) { List<Dictionary<string, double>> iterations = reader.GetValues(testCaseName); var measurements = new Dictionary<string, List<double>>(); foreach (var dict in iterations) { foreach (var pair in dict) { if (!measurements.ContainsKey(pair.Key)) measurements[pair.Key] = new List<double>(); measurements[pair.Key].Add(pair.Value); } } foreach (var measurement in measurements) { var metric = measurement.Key; var count = measurement.Value.Count; var avg = measurement.Value.Average(); var stdev_s = Math.Sqrt(measurement.Value.Sum(x => Math.Pow(x - avg, 2)) / (measurement.Value.Count - 1)); var max = measurement.Value.Max(); var min = measurement.Value.Min(); var r = statisticsTable.AppendRow(); r[col0_testName] = testCaseName; r[col1_metric] = metric; r[col2_iterations] = count.ToString(); r[col3_average] = avg.ToString(); r[col4_stdevs] = stdev_s.ToString(); r[col5_min] = min.ToString(); r[col6_max] = max.ToString(); } } statisticsTable.WriteToCSV(statisticsFilePath); Console.WriteLine($"\nStatistics written to \"{statisticsFilePath}\"\n"); }
public Row(DataTable table) { _Table = table; }