示例#1
0
        /// <summary>
        /// Suplementary method to assemble statistics CSV table.
        /// </summary>
        /// <param name="dataTable"></param>
        /// <param name="headers"></param>
        /// <param name="title"></param>
        public void appendStatistics(string[,] dataTable, string[] headers, string title)
        {
            // Get the bounds.
            int num_cols = dataTable.GetUpperBound(1) + 1;

            // Adding headers
            sb.Append(title);
            // Add the other fields in this row separated by commas.
            for (int col = 0; col < num_cols; col++)
            {
                sb.Append("," + headers[col]);
            }
            sb.AppendLine();

            // Adding body

            // Add MIN
            sb.Append("Min");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     min = currentColumnStatistics.getMin().ToString();
                sb.Append("," + min);
            }
            sb.AppendLine();

            // Add MAX
            sb.Append("Max");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     max = currentColumnStatistics.getMax().ToString();
                sb.Append("," + max);
            }
            sb.AppendLine();

            // Add Mean
            sb.Append("Mean");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     mean = currentColumnStatistics.getMean().ToString();
                sb.Append("," + mean);
            }
            sb.AppendLine();

            // Add HMean
            sb.Append("Hmean");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     hmean = currentColumnStatistics.getHmean().ToString();
                sb.Append("," + hmean);
            }
            sb.AppendLine();

            // Add GMean
            sb.Append("Gmean");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     gmean = currentColumnStatistics.getGmean().ToString();
                sb.Append("," + gmean);
            }
            sb.AppendLine();

            // Add Median
            sb.Append("Median");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     median = currentColumnStatistics.getMedian().ToString();
                sb.Append("," + median);
            }
            sb.AppendLine();

            // Add P10
            sb.Append("P10");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     p10 = currentColumnStatistics.getP10().ToString();
                sb.Append("," + p10);
            }
            sb.AppendLine();

            // Add P50
            sb.Append("P50");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     p50 = currentColumnStatistics.getP50().ToString();
                sb.Append("," + p50);
            }
            sb.AppendLine();

            // Add P90
            sb.Append("P90");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     p90 = currentColumnStatistics.getP90().ToString();
                sb.Append("," + p90);
            }
            sb.AppendLine();

            // Add Missing
            sb.Append("Missing");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     missing = currentColumnStatistics.getMissing().ToString();
                sb.Append("," + missing);
            }
            sb.AppendLine();

            // Add TotalSamples
            sb.Append("Total Samples");
            for (int col = 0; col < num_cols; col++)
            {
                string[]   dataColumn              = ucLoadFile.Instance.getDataColumn(col, dataTable);
                string     variableName            = headers[col];
                Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
                string     total = currentColumnStatistics.getTotalSamples().ToString();
                sb.Append("," + total);
            }
            sb.AppendLine();
        }