#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; 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("3975A950-D715-48C8-91FB-C982DA6887CA")] [ViewableCommandInfoAttribute("Interpolate Missing Values", 1, ColumnGroupState.Sorted | ColumnGroupState.DoubleColumnSelected, "Time Series", Position = 2)] public class InterpolateMissingValues : FillMissingValueCommandBase { private DateTimeColumn columnToSample; [StorableConstructor] protected InterpolateMissingValues(StorableConstructorFlag _) : base(_) { } public InterpolateMissingValues(DataSet dataSet, string columnGroupName, int[] affectedColumns) : base(dataSet, columnGroupName, affectedColumns) { } public override string Description { get { return "Interpolate Missing Values"; } } public override void Execute() { base.Execute(); if (!(ColumnGroup.GetColumn(ColumnGroup.SortedColumnIndexes.ElementAt(0)) is DateTimeColumn) || ColumnGroup.SortedColumnIndexes.Count != 1) throw new CommandExecutionException("ColumnGroup must be sorted after a datetime column.", this); columnToSample = (DateTimeColumn)ColumnGroup.Columns.ElementAt(ColumnGroup.SortedColumnIndexes.ElementAt(0)); if (columnToSample.SortOrder != SortOrder.Ascending) throw new CommandExecutionException("ColumnGroup must be sorted ascending by the datetime column.", this); if (columnToSample.ContainsNullValues) throw new CommandExecutionException("The datetime column must not contain null values.", this); oldSortOrder = ColumnGroup.SortOrdersForColumns.ToList(); oldSortedColumnIndexes = new List(ColumnGroup.SortedColumnIndexes); DoubleColumn column; int startIndex = -1; int endIndex = -1; foreach (int col in AffectedColumns) { if (ColumnGroup.GetColumn(col) is DoubleColumn && ColumnGroup.GetColumn(col).ContainsNullValues) { column = (DoubleColumn)ColumnGroup.Columns.ElementAt(col); nullValues.Add(col, new List()); startIndex = FindNextNotNullValueIndex(column, startIndex); endIndex = FindNextNotNullValueIndex(column, startIndex); while (endIndex != -1) { if (endIndex - startIndex != 1) { nullValues[col].AddRange(Enumerable.Range(startIndex + 1, endIndex - startIndex - 1)); InterpolateValues(column, startIndex, endIndex); } startIndex = endIndex; endIndex = FindNextNotNullValueIndex(column, endIndex); } startIndex = -1; } } ColumnGroup.FireChanged(); columnToSample = null; this.ColumnGroup = null; } private int FindNextNotNullValueIndex(DoubleColumn column, int startIndex) { int endIndex = -1; for (int i = startIndex + 1; i < column.TotalValuesCount && endIndex == -1; i++) if (column.GetValue(i) != null) endIndex = i; return endIndex; } private void InterpolateValues(DoubleColumn column, int startIndex, int endIndex) { double startValue = (double)column.GetValue(startIndex); double endValue = (double)column.GetValue(endIndex); DateTime start = (DateTime)columnToSample.GetValue(startIndex); DateTime end = (DateTime)columnToSample.GetValue(endIndex); for (int i = startIndex + 1; i < endIndex; i++) { if (column.GetValue(i) != null) throw new CommandExecutionException("Tried to manipulate non null value.", this); column.ChangeValue(i, ((double)(((DateTime)columnToSample.GetValue(i) - start).TotalSeconds / (end - start).TotalSeconds)) * (endValue - startValue) + startValue); } } } }