{"title":"Moving Average","nodeType":"Manipulator","id":"*i6a4eZBqe7EBhz9G","factoryName":"org.knime.timeseries.node.movavg.MovingAverageNodeFactory","factoryId":"org.knime.timeseries.node.movavg.MovingAverageNodeFactory","path":["Other Data Types","Time Series","Smoothing"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node calculates the moving average of a column. The moving average values are displayed in a new column appended at the end of the table or (if selected) replaces the original columns. For all window based methods (Backward/Center/Forward simple/Gaussian, Harmonic Mean) the cells that do not have a complete window (final at the beginning and the end of the table) are filled with Missing Values.</p>\n        ","shortDescription":"Adds a column with moving average values.","keywords":[],"deprecated":false,"streamable":false,"tags":["Other Data Types","Time Series","Smoothing"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6REIyM0U4OEY4RkEwMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6REIyM0U4OEU4RkEwMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpERTIxNzg2MjQ1QzYxMUU1QUM2QkE3NzQyQjhFM0EyRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpFMkREOENDRTQ1QzYxMUU1QUM2QkE3NzQyQjhFM0EyRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Ph8iL7MAAAC2SURBVHjaYvz//z8DMngeEHiGAT8wkdywHs5hYqAQUGwACzmaGBkZES4AcZAxsUBKTJoZiNmZ0AWJ1KwHpM4D8UNGJEF9ILXj2aunEkA2Vo1AOZC6AiCzE4jZgXgRI1CAA8hoAOISIGYGKUKPWmS/Qw3/BMTZQLVLQF44C8TlQPwGiMOJ8MExINYHaYY5fT0QzwBiQaiC/7gASA49nLAF+39CsYiSDrAk5bOE/DC4kvLAGwAQYAAkG0o6AFZoZwAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input column","description":"Table containing time series."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Moving average values","description":"Table with column holding moving average values."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Type of Moving Average","description":"<p>Select the moving average method defining how values in the window are weighted (backward, centered, forward, Gaussian, cumulative, exponential variants, harmonic mean, etc.).</p>\n<p>For the <i>Gaussian weighted</i> moving average the individual values are weighted based on the position in the window: <code>std_dev &#61; (k - 1) / 4</code> and <code>gauss(i,mean,std_dev) &#61; Math.exp((-0.5) * (i - mean) * (i - mean) / std_dev^2)</code></p>\n<p>For the <i>exponential</i> moving average the individual values are weighted as <code>alpha &#61; 2/(k&#43;1)</code> .</p>\n<ul><li><b>Backward simple</b> : <code>Backward_simple_n &#61; 1/k * sum{v_n-(k-1) ... v_n}</code></li><li><b>Center simple</b> : <code>Center_simple_n &#61; 1/k * sum{v_n-(n-1)/2 ... v_n ... v_n&#43;(n-1)/2}</code></li><li><b>Forward simple</b> : <code>Forward_simple_n &#61; 1/k * sum{v_n ... v_n&#43;k-1}</code></li><li><b>Backward Gaussian</b> : <code>Backward_gaussian_n &#61; sum{i &#61; 0 ... k-1} gauss(i,k-1,std_dev)*v_n-i</code></li><li><b>Center Gaussian</b> : <code>Center_gaussian_n &#61; sum{i &#61; 0 ... k-1} gauss(i,(k-1)/2,std_dev)*v_n&#43;(i-(k-1)/2)</code></li><li><b>Forward Gaussian</b> : <code>Forward_gaussian_n &#61; sum{i &#61; 0 ... k-1} gauss(i,0,std_dev)*v_n&#43;i</code></li><li><b>Harmonic Mean Center</b> : The harmonic mean can only be used for strictly positive values. <code>Center_harmonic_n &#61; n/{sum{i &#61; 0 ... k-1} 1/v_n&#43;(i-(k-1)/2)</code></li><li><b>Cumulative simple</b> : <code>Cumulative_n&#61; 1/n * sum{v_0 ... v_n-1}</code></li><li><b>Simple exponential</b> : <code>Simple_exponential_0 &#61; v_0</code> <code>EMA(v,n) &#61; Simple_exponential_n &#61; alpha*v_n &#43; (1-alpha)*Simple_exponential_n-1</code></li><li><b>Double exponential</b> : <code>Double_exponential_n &#61; 2 * EMA(v,n) - EMA(EMA(v,n),n)</code></li><li><b>Triple exponential</b> : <code>Triple_exponential_n &#61; 3 * EMA(v,n) - 3 * EMA(EMA(v,n),n) &#43; EMA(EMA(EMA(v,n),n),n)</code></li><li><b>Old exponential</b> : <code>Exponential_n &#61; alpha*v_n &#43; (1-alpha) * Backward_simple_n-1</code></li></ul>","optional":false},{"name":"Window length","description":"Number of consecutive rows used to compute each moving average. Must be an odd number for centered methods.","optional":false},{"name":"Remove original columns","description":"If checked, the selected input columns are replaced by their moving average. If unchecked, new columns named MA(&lt;column&gt;) are appended.","optional":false},{"name":"Column selection","description":"Select the numeric (double compatible) columns for which to compute moving averages. Move columns of interest to the &#34;Includes&#34; list.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202604300921","bundleName":"KNIME Time Series Nodes","bundleSymbolicName":"org.knime.timeseries","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.timeseries","featureName":"KNIME Timeseries nodes","featureVersion":"5.12.0.v202604300921","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*VOAVcUWXbgClAcQM"},"frequentSuccessors":[{"id":"*sJQ73svNoG0qOOOP","factoryName":"org.knime.base.node.viz.plotter.line.LinePlotterNodeFactory","probability":0.09818181818181818},{"id":"*HjhjPWnI5BHBrI1H","factoryName":"org.knime.js.base.node.viz.plotter.line.LinePlotNodeFactory","probability":0.08727272727272728},{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.07636363636363637},{"id":"*JKPnK49gCJ_6tVwe","factoryName":"org.knime.timeseries.node.movagg.MovingAggregationNodeFactory","probability":0.05454545454545454},{"id":"*9iAY3thoKzyWdyEf","factoryName":"org.knime.ext.jfc.node.linechart.JfcLineChartColoredNodeFactory","probability":0.04363636363636364},{"id":"*i6a4eZBqe7EBhz9G","factoryName":"org.knime.timeseries.node.movavg.MovingAverageNodeFactory","probability":0.04},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.04},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.03636363636363636},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.025454545454545455},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.02181818181818182}]}