Changeset 14545 for branches/DataPreprocessing Enhancements/HeuristicLab.DataPreprocessing.Views/3.4/StatisticsView.cs

Timestamp:

01/05/17 15:12:27 (7 years ago)

Author:

pfleck

Message:

#2709

• Uses StringMatrix for statistics instead of winforms datagrid.
• Precheck input/target variables only for statistics.

File:

• branches/DataPreprocessing Enhancements/HeuristicLab.DataPreprocessing.Views/3.4/StatisticsView.cs (modified) (7 diffs)

branches/DataPreprocessing Enhancements/HeuristicLab.DataPreprocessing.Views/3.4/StatisticsView.cs

@@ -24 +24 @@
 using System.Windows.Forms;
 using HeuristicLab.Core.Views;
+using HeuristicLab.Data;
 using HeuristicLab.MainForm;
 
@@ -32 +33 @@
   public partial class StatisticsView : ItemView {
 
-    private List<List<string>> columnsRowsMatrix;
-    private readonly int COLUMNS = 12;
+    private StringMatrix statisticsMatrix;
+
+    private static readonly string[] RowNames = new[] {
+      "Type",
+      "Missing Values",
+      "Min",
+      "Max",
+      "Median",
+      "Average",
+      "std. Deviation",
+      "Variance",
+      "25th Percentile",
+      "75th Percentile",
+      "Most Common Value",
+      "Num. diff. Values"
+    };
 
     public new StatisticsContent Content {
@@ -52 +67 @@
         txtNominalColumns.Text = "";
         txtMissingValuesTotal.Text = "";
-        dataGridView.Columns.Clear();
+        stringMatrixView.Content = null;
+        statisticsMatrix = null;
       } else {
         UpdateData();
@@ -58 +74 @@
     }
 
-    /// <summary>
-    /// Adds eventhandlers to the current instance.
-    /// </summary>
     protected override void RegisterContentEvents() {
+      base.RegisterContentEvents();
       Content.Changed += Content_Changed;
     }
 
-
-    /// <summary>
-    /// Removes the eventhandlers from the current instance.
-    /// </summary>
     protected override void DeregisterContentEvents() {
       Content.Changed -= Content_Changed;
+      base.DeregisterContentEvents();
     }
 
@@ -76 +87 @@
       var logic = Content.StatisticsLogic;
       var rowCount = logic.GetRowCount();
-      txtRows.Text = rowCount.ToString();
-      txtColumns.Text = logic.GetColumnCount().ToString();
+      txtRows.Text = logic.GetColumnCount().ToString();
+      txtColumns.Text = rowCount.ToString();
       txtNumericColumns.Text = logic.GetNumericColumnCount().ToString();
       txtNominalColumns.Text = logic.GetNominalColumnCount().ToString();
       txtMissingValuesTotal.Text = logic.GetMissingValueCount().ToString();
 
-      columnsRowsMatrix = new List<List<string>>();
-      DataGridViewColumn[] columns = new DataGridViewColumn[COLUMNS];
-      for (int i = 0; i < COLUMNS; ++i) {
-        var column = new DataGridViewTextBoxColumn();
-        column.SortMode = DataGridViewColumnSortMode.Automatic;
-        column.FillWeight = 1;
-        columns[i] = column;
-      }
-
-      columns[0].HeaderCell.Value = "Type";
-      columns[1].HeaderCell.Value = "Missing Values";
-      columns[2].HeaderCell.Value = "Min";
-      columns[3].HeaderCell.Value = "Max";
-      columns[4].HeaderCell.Value = "Median";
-      columns[5].HeaderCell.Value = "Average";
-      columns[6].HeaderCell.Value = "std. Deviation";
-      columns[7].HeaderCell.Value = "Variance";
-      columns[8].HeaderCell.Value = "25th Percentile";
-      columns[9].HeaderCell.Value = "75th Percentile";
-      columns[10].HeaderCell.Value = "Most Common Value";
-      columns[11].HeaderCell.Value = "Num. diff. Values";
+      statisticsMatrix = new StringMatrix(RowNames.Length, Content.PreprocessingData.Columns) {
+        RowNames = StatisticsView.RowNames,
+        ColumnNames = Content.PreprocessingData.VariableNames
+      };
 
       if (rowCount > 0) {
         for (int i = 0; i < logic.GetColumnCount(); ++i) {
-          columnsRowsMatrix.Add(GetList(i));
+          var data = GetList(i);
+          for (int j = 0; j < data.Count; j++) {
+            statisticsMatrix[j, i] = data[j];
+          }
         }
       }
-
-      dataGridView.Columns.Clear();
-      dataGridView.Columns.AddRange(columns);
-      dataGridView.RowCount = columnsRowsMatrix.Count;
-
-      for (int i = 0; i < columnsRowsMatrix.Count; ++i) {
-        dataGridView.Rows[i].HeaderCell.Value = logic.GetVariableName(i);
-      }
-
-      dataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
-      dataGridView.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToDisplayedHeaders);
-      dataGridView.AllowUserToResizeColumns = true;
+      stringMatrixView.Content = statisticsMatrix;
+
+      foreach (DataGridViewColumn column in stringMatrixView.DataGridView.Columns) {
+        var variable = column.HeaderText;
+        bool isInputTarget = Content.PreprocessingData.InputVariables.Contains(variable)
+                             || Content.PreprocessingData.TargetVariable == variable;
+        column.Visible = isInputTarget;
+      }
+      stringMatrixView.DataGridView.AutoResizeColumns();
+
+      //foreach (DataGridViewRow row in stringMatrixView.DataGridView.Rows) {
+      //  var variable = (string)row.HeaderCell.Value;
+      //  bool isInputTarget = Content.PreprocessingData.InputVariables.Contains(variable)
+      //                       || Content.PreprocessingData.TargetVariable == variable;
+      //  row.Visible = isInputTarget;
+      //}
     }
 
@@ -134 +135 @@
       } else {
         list = new List<string>();
-        for (int j = 0; j < COLUMNS; ++j) {
+        for (int j = 0; j < RowNames.Length; ++j) {
           list.Add("unknown column type");
         }
@@ -195 +196 @@
     }
 
-    private void dataGridView_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e) {
-      if (Content != null && e.RowIndex < columnsRowsMatrix.Count && e.ColumnIndex < columnsRowsMatrix[0].Count) {
-        e.Value = columnsRowsMatrix[e.RowIndex][e.ColumnIndex];
-      }
-    }
-
     private void Content_Changed(object sender, DataPreprocessingChangedEventArgs e) {
-      switch (e.Type) {
-        case DataPreprocessingChangedEventType.DeleteColumn:
-          columnsRowsMatrix.RemoveAt(e.Column);
-          break;
-        case DataPreprocessingChangedEventType.AddColumn:
-          columnsRowsMatrix.Insert(e.Row, GetList(e.Column));
-          dataGridView.RowCount++;
-          break;
-        case DataPreprocessingChangedEventType.ChangeItem:
-          columnsRowsMatrix[e.Column] = GetList(e.Column);
-          break;
-        case DataPreprocessingChangedEventType.DeleteRow:
-        case DataPreprocessingChangedEventType.AddRow:
-        default:
-          for (int i = 0; i < columnsRowsMatrix.Count; ++i) {
-            columnsRowsMatrix[i] = GetList(e.Column);
-          }
-          break;
-      }
-      dataGridView.Refresh();
+      UpdateData();
+      //switch (e.Type) {
+      //  case DataPreprocessingChangedEventType.DeleteColumn:
+      //    statisticsMatrix.RemoveAt(e.Column);
+      //    break;
+      //  case DataPreprocessingChangedEventType.AddColumn:
+      //    statisticsMatrix.Insert(e.Row, GetList(e.Column));
+      //    stringMatrixView.Content.Rows++;
+      //    break;
+      //  case DataPreprocessingChangedEventType.ChangeItem:
+      //    statisticsMatrix[e.Column] = GetList(e.Column);
+      //    break;
+      //  case DataPreprocessingChangedEventType.DeleteRow:
+      //  case DataPreprocessingChangedEventType.AddRow:
+      //  default:
+      //    for (int i = 0; i < statisticsMatrix.Count; ++i) {
+      //      statisticsMatrix[i] = GetList(e.Column);
+      //    }
+      //    break;
+      //}
     }
   }