#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; using HEAL.Attic; namespace HeuristicLab.DataImporter.Command { [StorableType("87E0EA6E-EC45-492B-8F4B-B15B25A467E9")] [ViewableCommandInfoAttribute("Mean", 1, ColumnGroupState.DoubleColumnSelected | ColumnGroupState.AnySelectedColumnContainsNull, "Handle Missing Values", Position = 0)] public class FillMissingValuesWithMeanCommand : FillMissingValueCommandBase { [StorableConstructor] protected FillMissingValuesWithMeanCommand(StorableConstructorFlag _) : base(_) { } 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"; } } } }