#region License Information
/* HeuristicLab
* Copyright (C) 2002-2013 Heuristic and Evolutionary Algorithms Laboratory (HEAL)
*
* This file is part of HeuristicLab.
*
* HeuristicLab is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* HeuristicLab is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with HeuristicLab. If not, see .
*/
#endregion
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
using HeuristicLab.DataImporter.Data;
using HeuristicLab.DataImporter.Data.CommandBase;
using HeuristicLab.DataImporter.Data.Model;
using HeuristicLab.Persistence.Default.CompositeSerializers.Storable;
namespace HeuristicLab.DataImporter.Command {
[StorableClass]
[ViewableCommandInfoAttribute("Mean", 1, ColumnGroupState.DoubleColumnSelected | ColumnGroupState.AnySelectedColumnContainsNull,
"Handle Missing Values", Position = 0)]
public class FillMissingValuesWithMeanCommand : FillMissingValueCommandBase {
[StorableConstructor]
protected FillMissingValuesWithMeanCommand(bool deserializing) : base(deserializing) { }
public FillMissingValuesWithMeanCommand(DataSet dataSet, string columnGroupName, int[] affectedColumns) :
base(dataSet, columnGroupName, affectedColumns) {
}
public override void Execute() {
base.Execute();
DoubleColumn column;
double? mean;
oldSortOrder = ColumnGroup.SortOrdersForColumns.ToList();
oldSortedColumnIndexes = new List(ColumnGroup.SortedColumnIndexes);
foreach (int col in AffectedColumns) {
if (ColumnGroup.GetColumn(col) is DoubleColumn && ColumnGroup.GetColumn(col).ContainsNullValues) {
column = (DoubleColumn)ColumnGroup.Columns.ElementAt(col);
if (column.SortOrder != SortOrder.None)
ColumnGroup.ResetSorting();
nullValues.Add(col, new List());
mean = column.Mean;
for (int j = 0; j < column.TotalValuesCount; j++) {
if (column.GetValue(j) == null) {
column.ChangeValue(j, mean);
this.nullValues[col].Add(j);
}
}
}
}
ColumnGroup.FireChanged();
ColumnGroup = null;
}
public override string Description {
get { return "Fill missing values with mean"; }
}
}
}