Changeset 10191

Timestamp:

12/04/13 15:22:40 (10 years ago)

Author:

rstoll

Message:

• GetRowMissingValueCount implemented
• IsMissingValue for cell implemented

Location:

branches/DataPreprocessing/HeuristicLab.DataPreprocessing/3.3

Files:

• Implementations/PreprocessingData.cs (modified) (2 diffs)
• Implementations/StatisticInfo.cs (modified) (1 diff)
• Interfaces/IPreprocessingData.cs (modified) (1 diff)
• Interfaces/IStatisticInfo.cs (modified) (1 diff)

branches/DataPreprocessing/HeuristicLab.DataPreprocessing/3.3/Implementations/PreprocessingData.cs

@@ -157 +157 @@
     }
 
+    public bool IsMissingValue(string variableName, int rowIndex) {
+      if (IsType<double>(variableName)) {
+        return double.IsNaN(GetCell<double>(variableName, rowIndex));
+      } else if (IsType<string>(variableName)) {
+        return string.IsNullOrEmpty(GetCell<string>(variableName, rowIndex));
+      } else if (IsType<DateTime>(variableName)) {
+        return GetCell<DateTime>(variableName, rowIndex).Equals(DateTime.MinValue);
+      } else {
+        throw new ArgumentException("cell in column with variableName: " + variableName + " and row index " + rowIndex + " contains a non supported type.");
+      }
+    }
+
     public IEnumerable<int> GetMissingValueIndices(string variableName) {
       if (IsType<double>(variableName)) {
@@ -165 +177 @@
         return GetValues<DateTime>(variableName).Select((s, i) => new { i, s }).Where(t => t.s.Equals(DateTime.MinValue)).Select(t => t.i);
       } else {
-        throw new ArgumentException("column with index: " + variableName + " contains a non supported type.");
+        throw new ArgumentException("column with variableName: " + variableName + " contains a non supported type.");
       }
     }

branches/DataPreprocessing/HeuristicLab.DataPreprocessing/3.3/Implementations/StatisticInfo.cs

@@ -91 +91 @@
       return preprocessingData.GetValues<T>(variableName).GroupBy(x => x).Count();
     }
+
+    public int GetRowMissingValueCount(int rowIndex) {
+      int count = 0;
+      foreach (var variableName in preprocessingData.VariableNames) {
+        if (preprocessingData.IsMissingValue(variableName, rowIndex)) {
+          ++count;
+        }
+      }
+      return count;
+    }
   }
 }

branches/DataPreprocessing/HeuristicLab.DataPreprocessing/3.3/Interfaces/IPreprocessingData.cs

@@ -59 +59 @@
     /// <returns></returns>
     IEnumerable<int> GetMissingValueIndices(string variableName);
+
+    bool IsMissingValue(string variableName, int rowIndex);
   }
 }

branches/DataPreprocessing/HeuristicLab.DataPreprocessing/3.3/Interfaces/IStatisticInfo.cs

@@ -10 +10 @@
     int GetMissingValueCount();
     int GetMissingValueCount(string variableName);
+    int GetRowMissingValueCount(int rowIndex);
     T GetMin<T>(string variableName) where T : IComparable<T>;
     T GetMax<T>(string variableName) where T : IComparable<T>;