[6134] | 1 | #region License Information
|
---|
| 2 | /* HeuristicLab
|
---|
[7267] | 3 | * Copyright (C) 2002-2012 Heuristic and Evolutionary Algorithms Laboratory (HEAL)
|
---|
[6134] | 4 | *
|
---|
| 5 | * This file is part of HeuristicLab.
|
---|
| 6 | *
|
---|
| 7 | * HeuristicLab is free software: you can redistribute it and/or modify
|
---|
| 8 | * it under the terms of the GNU General Public License as published by
|
---|
| 9 | * the Free Software Foundation, either version 3 of the License, or
|
---|
| 10 | * (at your option) any later version.
|
---|
| 11 | *
|
---|
| 12 | * HeuristicLab is distributed in the hope that it will be useful,
|
---|
| 13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
---|
| 14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
---|
| 15 | * GNU General Public License for more details.
|
---|
| 16 | *
|
---|
| 17 | * You should have received a copy of the GNU General Public License
|
---|
| 18 | * along with HeuristicLab. If not, see <http://www.gnu.org/licenses/>.
|
---|
| 19 | */
|
---|
| 20 | #endregion
|
---|
| 21 |
|
---|
| 22 | using System;
|
---|
[6133] | 23 | using System.Collections.Generic;
|
---|
| 24 | using System.Linq;
|
---|
| 25 | using System.Text;
|
---|
| 26 | using System.Windows.Forms;
|
---|
| 27 | using HeuristicLab.DataImporter.Data;
|
---|
| 28 | using HeuristicLab.DataImporter.Data.CommandBase;
|
---|
| 29 | using HeuristicLab.DataImporter.Data.Model;
|
---|
| 30 | using HeuristicLab.Persistence.Default.CompositeSerializers.Storable;
|
---|
| 31 |
|
---|
| 32 | namespace HeuristicLab.DataImporter.Command {
|
---|
| 33 | [StorableClass]
|
---|
| 34 | [ViewableCommandInfoAttribute("Mean", 1, ColumnGroupState.DoubleColumnSelected | ColumnGroupState.AnySelectedColumnContainsNull,
|
---|
| 35 | "Handle Missing Values", Position = 0)]
|
---|
| 36 | public class FillMissingValuesWithMeanCommand : FillMissingValueCommandBase {
|
---|
| 37 | private FillMissingValuesWithMeanCommand()
|
---|
| 38 | : base(null, string.Empty, null) {
|
---|
| 39 | }
|
---|
| 40 |
|
---|
| 41 | public FillMissingValuesWithMeanCommand(DataSet dataSet, string columnGroupName, int[] affectedColumns) :
|
---|
| 42 | base(dataSet, columnGroupName, affectedColumns) {
|
---|
| 43 | }
|
---|
| 44 |
|
---|
| 45 | public override void Execute() {
|
---|
| 46 | base.Execute();
|
---|
| 47 | DoubleColumn column;
|
---|
| 48 | double? mean;
|
---|
| 49 | oldSortOrder = ColumnGroup.SortOrdersForColumns.ToList();
|
---|
| 50 | oldSortedColumnIndexes = new List<int>(ColumnGroup.SortedColumnIndexes);
|
---|
| 51 | foreach (int col in AffectedColumns) {
|
---|
| 52 | if (ColumnGroup.GetColumn(col) is DoubleColumn && ColumnGroup.GetColumn(col).ContainsNullValues) {
|
---|
| 53 | column = (DoubleColumn)ColumnGroup.Columns.ElementAt(col);
|
---|
| 54 | if (column.SortOrder != SortOrder.None)
|
---|
| 55 | ColumnGroup.ResetSorting();
|
---|
| 56 | nullValues.Add(col, new List<int>());
|
---|
| 57 | mean = column.Mean;
|
---|
| 58 | for (int j = 0; j < column.TotalValuesCount; j++) {
|
---|
| 59 | if (column.GetValue(j) == null) {
|
---|
| 60 | column.ChangeValue(j, mean);
|
---|
| 61 | this.nullValues[col].Add(j);
|
---|
| 62 | }
|
---|
| 63 | }
|
---|
| 64 | }
|
---|
| 65 | }
|
---|
| 66 | ColumnGroup.FireChanged();
|
---|
| 67 | ColumnGroup = null;
|
---|
| 68 | }
|
---|
| 69 |
|
---|
| 70 | public override string Description {
|
---|
| 71 | get { return "Fill missing values with mean"; }
|
---|
| 72 | }
|
---|
| 73 | }
|
---|
| 74 | }
|
---|