public ucStatistics(int columnIndex, string[,] dataArray, string title)
{
InitializeComponent();
string[] dataColumn = ucLoadFile.Instance.getDataColumn(columnIndex, dataArray);
string variableName = ucLoadFile.Instance.getCurrentColumnNames()[columnIndex];
Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
labelVariableName.Text = currentColumnStatistics.getVariableName();
labelTitle.Text = title;
labelMinValue.Text = currentColumnStatistics.getMin().ToString();
labelMaxValue.Text = currentColumnStatistics.getMax().ToString();
labelMeanValue.Text = currentColumnStatistics.getMean().ToString();
labelHMeanValue.Text = currentColumnStatistics.getHmean().ToString();
labelGMeanValue.Text = currentColumnStatistics.getGmean().ToString();
labelMeadianValue.Text = currentColumnStatistics.getMedian().ToString();
labelMissingValue.Text = currentColumnStatistics.getMissing().ToString();
labelP10Value.Text = currentColumnStatistics.getP10().ToString();
labelP50Value.Text = currentColumnStatistics.getP50().ToString();
labelP90Value.Text = currentColumnStatistics.getP90().ToString();
labelTotalSamplesValue.Text = currentColumnStatistics.getTotalSamples().ToString();
}
/// <summary>
/// Method displays statistics when variable is selected.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cbSelectVariable_SelectedIndexChanged(object sender, EventArgs e)
{
variableName = cbSelectVariable.SelectedItem.ToString();
int variableIndex = cbSelectVariable.SelectedIndex;
dataColumn = getDataColumn(variableIndex, currentDataArray);
Statistics currentColumnStatistics = new Statistics(variableName, dataColumn);
labelMinValue.Text = currentColumnStatistics.getMin().ToString();
labelMaxValue.Text = currentColumnStatistics.getMax().ToString();
labelMeanValue.Text = currentColumnStatistics.getMean().ToString();
labelHMeanValue.Text = currentColumnStatistics.getHmean().ToString();
labelGMeanValue.Text = currentColumnStatistics.getGmean().ToString();
labelMedianValue.Text = currentColumnStatistics.getMedian().ToString();
labelMissingValue.Text = currentColumnStatistics.getMissing().ToString();
labelP10Value.Text = currentColumnStatistics.getP10().ToString();
labelP50Value.Text = currentColumnStatistics.getP50().ToString();
labelP90Value.Text = currentColumnStatistics.getP90().ToString();
labelTotalSamplesValue.Text = currentColumnStatistics.getTotalSamples().ToString();
populateSelectNOfGroupsBox();
}
/// <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();
}
