1 | #region License Information
|
---|
2 | /* HeuristicLab
|
---|
3 | * Copyright (C) 2002-2012 Heuristic and Evolutionary Algorithms Laboratory (HEAL)
|
---|
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;
|
---|
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("Previous Value", 1, ColumnGroupState.AnySelectedColumnContainsNull, "Handle Missing Values", Position = 3)]
|
---|
35 | public class FillMissingValuesWithPreviousValuesCommand : FillMissingValueCommandBase {
|
---|
36 | private FillMissingValuesWithPreviousValuesCommand()
|
---|
37 | : base(null, string.Empty, null) {
|
---|
38 | }
|
---|
39 |
|
---|
40 | public FillMissingValuesWithPreviousValuesCommand(DataSet dataSet, string columnGroupName, int[] affectedColumns) :
|
---|
41 | base(dataSet, columnGroupName, affectedColumns) {
|
---|
42 | }
|
---|
43 |
|
---|
44 | public override void Execute() {
|
---|
45 | base.Execute();
|
---|
46 | IComparable val = null;
|
---|
47 | ColumnBase column;
|
---|
48 | oldSortOrder = ColumnGroup.SortOrdersForColumns.ToList();
|
---|
49 | oldSortedColumnIndexes = new List<int>(ColumnGroup.SortedColumnIndexes);
|
---|
50 | foreach (int col in AffectedColumns) {
|
---|
51 | column = ColumnGroup.GetColumn(col);
|
---|
52 | if (column.ContainsNullValues) {
|
---|
53 | if (column.SortOrder != SortOrder.None)
|
---|
54 | ColumnGroup.ResetSorting();
|
---|
55 | nullValues.Add(col, new List<int>());
|
---|
56 | val = null;
|
---|
57 | for (int j = 0; j < column.TotalValuesCount; j++) {
|
---|
58 | if (column.GetValue(j) != null)
|
---|
59 | val = column.GetValue(j);
|
---|
60 | else {
|
---|
61 | column.ChangeValue(j, val);
|
---|
62 | this.nullValues[col].Add(j);
|
---|
63 | }
|
---|
64 | }
|
---|
65 | }
|
---|
66 | }
|
---|
67 | ColumnGroup.FireChanged();
|
---|
68 | ColumnGroup = null;
|
---|
69 | }
|
---|
70 |
|
---|
71 | public override string Description {
|
---|
72 | get { return "Fill missing values with previous value"; }
|
---|
73 | }
|
---|
74 | }
|
---|
75 | }
|
---|