Changeset 10905 for branches/DataPreprocessing/HeuristicLab.DataPreprocessing.Views/3.3/ManipulationView.cs

Timestamp:

05/28/14 14:37:39 (10 years ago)

Author:

rstoll

Message:

• Manipulation View

missing values per column
validating per column
success message for missing values was missing

File:

• branches/DataPreprocessing/HeuristicLab.DataPreprocessing.Views/3.3/ManipulationView.cs (modified) (7 diffs)

branches/DataPreprocessing/HeuristicLab.DataPreprocessing.Views/3.3/ManipulationView.cs

@@ -21 +21 @@
 
 using System;
+using System.Collections.Generic;
 using System.Drawing;
 using System.Windows.Forms;
@@ -60 +61 @@
         ()=>Content.ManipulationLogic.ShuffleWithRanges()
       };
+
+    }
+
+    protected override void OnContentChanged() {
+      base.OnContentChanged();
+      if (Content != null) {
+        cmbVariableNames.Items.Clear();
+        foreach (var name in Content.DataGridLogic.ColumnNames) {
+          cmbVariableNames.Items.Add(name);
+        }
+        cmbVariableNames.SelectedIndex = 0;
+      }
     }
 
@@ -85 +98 @@
 
     private void replaceMissingValues() {
-      var cells = Content.SearchLogic.GetMissingValueIndices();
-      switch (cmbReplaceWith.SelectedIndex) { 
+      var allIndices = Content.SearchLogic.GetMissingValueIndices();
+      var columnIndex = cmbVariableNames.SelectedIndex;
+      var columnIndices = new Dictionary<int, IList<int>>{
+          {columnIndex,   allIndices[columnIndex]}
+      };
+
+      switch (cmbReplaceWith.SelectedIndex) {
         case 0: //Value
-          Content.ManipulationLogic.ReplaceIndicesByValue(cells, txtReplaceValue.Text);
+          Content.ManipulationLogic.ReplaceIndicesByValue(columnIndices, txtReplaceValue.Text);
           break;
         case 1: //Average
-          Content.ManipulationLogic.ReplaceIndicesByAverageValue(cells);
+          Content.ManipulationLogic.ReplaceIndicesByAverageValue(columnIndices);
           break;
         case 2: //Median
-          Content.ManipulationLogic.ReplaceIndicesByMedianValue(cells);
+          Content.ManipulationLogic.ReplaceIndicesByMedianValue(columnIndices);
           break;
         case 3: //Most Common
-          Content.ManipulationLogic.ReplaceIndicesByMostCommonValue(cells);
+          Content.ManipulationLogic.ReplaceIndicesByMostCommonValue(columnIndices);
           break;
         case 4: //Random
-          Content.ManipulationLogic.ReplaceIndicesByRandomValue(cells);
+          Content.ManipulationLogic.ReplaceIndicesByRandomValue(columnIndices);
           break;
       }
@@ -152 +170 @@
     private void validateReplaceWith() {
       btnApply.Enabled = false;
-      string replaceValue = cmbReplaceWith.SelectedText;
+      string replaceWith = (string)cmbReplaceWith.SelectedItem;
+      int columnIndex = cmbVariableNames.SelectedIndex;
+
       if (cmbReplaceWith.SelectedIndex == 0) {
-        btnApply.Enabled = !string.IsNullOrEmpty(txtReplaceValue.Text);
-        replaceValue = @"\"+ txtReplaceValue.Text + @"\";
+        string errorMessage;
+        string replaceValue = txtReplaceValue.Text;
+        if (string.IsNullOrEmpty(replaceValue)) {
+          lblPreviewReplaceMissingValues.Text = "Preview not possible yet - please input the text which will be used as replacement.";
+        } else if (!Content.DataGridLogic.Validate(txtReplaceValue.Text, out errorMessage, columnIndex)) {
+          lblPreviewReplaceMissingValues.Text = "Preview not possible yet - " + errorMessage;
+        } else {
+          btnApply.Enabled = true;
+        }
+        replaceWith = "\"" + replaceValue + "\"";
       } else {
         btnApply.Enabled = true;
       }
       if (btnApply.Enabled) {
-        int count = Content.SearchLogic.GetMissingValueIndices().Count;
-        lblPreviewReplaceMissingValues.Text = count + " cell" + (count > 1 || count == 0 ? "s" : "") 
-          + " were detected with missing values which would be replaced with " + replaceValue;
+        var allIndices = Content.SearchLogic.GetMissingValueIndices();
+        int count = allIndices[columnIndex].Count;
+        lblPreviewReplaceMissingValues.Text = count + " cell" + (count > 1 || count == 0 ? "s" : "")
+          + " were detected with missing values which would be replaced with " + replaceWith;
         if (count > 0) {
           lblPreviewReplaceMissingValues.Text += Environment.NewLine + Environment.NewLine + "Please press the button \"Apply Manipulation\" if you wish to perform the replacement.";
@@ -168 +197 @@
           btnApply.Enabled = false;
         }
-      } else {
-        lblPreviewReplaceMissingValues.Text = "Preview not possible yet - please input the text which will be used as replacement.";
       }
     }
@@ -203 +230 @@
           break;
         case 3:
+          lblPreviewReplaceMissingValues.Text = "missing values successfully replaced.";
+          btnApply.Enabled = false;
+          break;
+        case 4:
           lblPreviewShuffle.Text = "dataset shuffled successfully.";
           btnApply.Enabled = false;
@@ -232 +263 @@
 
     void Content_Changed(object sender, DataPreprocessingChangedEventArgs e) {
-      switch(lstMethods.SelectedIndex){
+      switch (lstMethods.SelectedIndex) {
         case 0:
           validateDeleteColumnsInfo();