movprod

Moving product

Syntax

M = movprod(A,k)

M = movprod(A,[kb kf])

M = movprod(___,dim)

M = movprod(___,nanflag)

M = movprod(___,Name,Value)

Description

M = movprod(A,k) returns an array of local k-point products, where each product is calculated over a sliding window of length k across neighboring elements of A. M is the same size as A.

When k is odd, the window is centered about the element in the current position. When k is even, the window is centered about the current and previous elements. The window size is automatically truncated at the endpoints when there are not enough elements to fill the window. When the window is truncated, the product is taken over only the elements that fill the window.

• If A is a vector, then movprod operates along the length of the vector A.

• If A is a multidimensional array, then movprod operates along the first dimension of A whose size does not equal 1.

M = movprod(A,[kb kf]) computes the product with a window of length kb+kf+1 that includes the element in the current position, kb elements backward, and kf elements forward.

M = movprod(___,dim) specifies the dimension of A to operate along for any of the previous syntaxes. For example, if A is a matrix, then movprod(A,k,2) operates across the columns of A, computing the k-element sliding product for each row.

M = movprod(___,nanflag) specifies whether to include or omit NaN values in A. For example, movprod(A,k,"omitnan") ignores NaN values when computing each product. By default, movprod includes NaN values.

M = movprod(___,Name,Value) specifies additional parameters for the moving product using one or more name-value pair arguments. For example, if x is a vector of time values, then movprod(A,k,"SamplePoints",x) computes the moving product relative to the times in x.

Examples

Centered Moving Product of Vector

Compute the three-point centered moving product of a row vector. When there are fewer than three elements in the window at the endpoints, take the product over the elements that are available.

A = [1 2 4 -1 -2 -3 -1 3 2 1];
M = movprod(A,3)

M = 1×10

     2     8    -8     8    -6    -6     9    -6     6     2

Trailing Moving Product of Vector

Compute the three-point trailing moving product of a row vector. When there are fewer than three elements in the window at the endpoints, take the product over the elements that are available.

A = [1 2 1 -1 -2 -3 -1 3 4 1];
M = movprod(A,[2 0])

M = 1×10

     1     2     2    -2     2    -6    -6     9   -12    12

Moving Product of Matrix

Compute the 3-point centered moving product for each row of a matrix. The dimension argument is 2, which slides the window across the columns of A. The window starts on the first row, slides horizontally to the end of the row, then moves to the second row, and so on.

A = [1 2 1; -1 -2 -3; -1 3 4]

A = 3×3

     1     2     1
    -1    -2    -3
    -1     3     4

M = movprod(A,3,2)

M = 3×3

     2     2     2
     2    -6     6
    -3   -12    12

Moving Product Excluding Missing Values

Create a row vector containing NaN values.

A = [4 8 NaN -1 -2 -3 NaN 3 4 5];

Compute the three-point centered moving product of the vector, excluding NaN values. For windows that contain any NaN value, movprod computes with the non-NaN elements.

M = movprod(A,3,"omitnan")

M = 1×10

    32    32    -8     2    -6     6    -9    12    60    20

Sample Points for Moving Product

Compute a 3-hour centered moving product of the data in A according to the time vector t.

A = [4 8 6 -1 -2 -3];
k = hours(3);
t = datetime(2016,1,1,0,0,0) + hours(0:5)

t = 1x6 datetime
   01-Jan-2016 00:00:00   01-Jan-2016 01:00:00   01-Jan-2016 02:00:00   01-Jan-2016 03:00:00   01-Jan-2016 04:00:00   01-Jan-2016 05:00:00

M = movprod(A,k,"SamplePoints",t)

M = 1×6

    32   192   -48    12    -6     6

Return Only Full-Window Products

Compute the three-point centered moving product of a row vector, but discard any calculation that uses fewer than three points from the output. In other words, return only the products computed from a full three-element window, discarding endpoint calculations.

A = [1 2 1 -1 -2 -3 -1 3 4 1];
M = movprod(A,3,"Endpoints","discard")

M = 1×8

     2    -2     2    -6    -6     9   -12    12

Input Arguments

A — Input array

vector | matrix | multidimensional array

Input array, specified as a vector, matrix, or multidimensional array.

Data Types: single | double | int8 | int16 | int32 | int64 | uint8 | uint16 | uint32 | uint64 | logical

k — Window length

numeric or duration scalar

Window length, specified as a numeric or duration scalar. When k is a positive integer scalar, the centered product includes the element in the current position plus surrounding neighbors.

For example, movprod(A,3) computes an array of local three-point products.

[kb kf] — Directional window length

numeric or duration row vector containing two elements

Directional window length, specified as a numeric or duration row vector containing two elements. When kb and kf are positive integer scalars, the calculation is over kb+kf+1 elements. The calculation includes the element in the current position, kb elements before the current position, and kf elements after the current position.

For example, movprod(A,[2 1]) computes an array of local four-point products.

dim — Dimension to operate along

positive integer scalar

Dimension to operate along, specified as a positive integer scalar. If you do not specify the dimension, then the default is the first array dimension whose size does not equal 1.

Consider an m-by-n input matrix, A:

• movprod(A,k,1) computes the k-element sliding product for each column of A and returns an m-by-n matrix.

  

• movprod(A,k,2) computes the k-element sliding product for each row of A and returns an m-by-n matrix.

  

nanflag — Missing value condition

"includemissing" (default) | "includenan" | "omitmissing" | "omitnan"

Missing value condition, specified as one of these values:

• "includemissing" or "includenan" — Include NaN values in A when computing each product. If any element in the window is NaN, then the corresponding element in M is NaN. "includemissing" and "includenan" have the same behavior.

• "omitmissing" or "omitnan" — Ignore NaN values in A, and compute each product over fewer points. If all elements in the window are NaN, then the corresponding element in M is 1. "omitmissing" and "omitnan" have the same behavior.

Name-Value Arguments

Specify optional pairs of arguments as Name1=Value1,...,NameN=ValueN, where Name is the argument name and Value is the corresponding value. Name-value arguments must appear after other arguments, but the order of the pairs does not matter.

Before R2021a, use commas to separate each name and value, and enclose Name in quotes.

Example: M = movprod(A,k,"Endpoints","fill")

Endpoints — Method to treat windows near endpoints

"shrink" (default) | "discard" | "fill" | numeric or logical scalar

Method to treat windows near endpoints, specified as one of these options:

Value	Description
"shrink"	Shrink the window size near the endpoints of the input to include only existing elements.
"discard"	Do not output any product values when the window does not completely overlap with existing elements.
"fill"	Replace nonexisting elements with NaN.
numeric or logical scalar	Replace nonexisting elements with the specified numeric or logical value.

SamplePoints — Sample points for computing products

vector

Sample points for computing products, specified as a vector. The sample points represent the locations of the data in A. Sample points do not need to be uniformly sampled. By default, the sample points vector is [1 2 3 ... ].

Moving windows are defined relative to the sample points, which must be sorted and contain unique elements. For example, if t is a vector of times corresponding to the input data, then movprod(rand(1,10),3,"SamplePoints",t) has a window that represents the time interval between t(i)-1.5 and t(i)+1.5.

When the sample points vector has data type datetime or duration, then the moving window length must have type duration.

If the sample points are nonuniformly spaced and Endpoints is specified, then its value must be "shrink".

Extended Capabilities

Tall Arrays

Calculate with arrays that have more rows than fit in memory.

This function supports tall arrays with the limitations:

• The SamplePoints name-value argument is not supported.

For more information, see Tall Arrays.

C/C++ Code Generation
Generate C and C++ code using MATLAB® Coder™.

Thread-Based Environment

Run code in the background using MATLAB® backgroundPool or accelerate code with Parallel Computing Toolbox™ ThreadPool.

This function fully supports thread-based environments. For more information, see Run MATLAB Functions in Thread-Based Environment.

GPU Arrays

Accelerate code by running on a graphics processing unit (GPU) using Parallel Computing Toolbox™.

The movprod function supports GPU array input with these usage notes and limitations:

• The SamplePoints name-value argument is not supported.

For more information, see Run MATLAB Functions on a GPU (Parallel Computing Toolbox).

Distributed Arrays

Partition large arrays across the combined memory of your cluster using Parallel Computing Toolbox™.

This function fully supports distributed arrays. For more information, see Run MATLAB Functions with Distributed Arrays (Parallel Computing Toolbox).

Version History

Introduced in R2017a

R2023a: Specify missing value condition

Include or omit missing values in the input array when computing each product by using the "includemissing" or "omitmissing" options. These options have the same behavior as the "includenan" and "omitnan" options, respectively.

R2023a: Improved performance when computing over matrix with sample points

The movprod function shows improved performance when computing over a matrix when there are sample points.

For example, this code computes the moving product of a 300-by-300 matrix with corresponding sample points. The code is about 2.8x faster than in the previous release.

function timingMovprod
A = randn(300);
t = sort(rand(300,1));
tic
for k = 1:2000
    movprod(A,0.1,"SamplePoints",t);
end
toc
end

The approximate execution times are:

R2022b: 0.92 s

R2023a: 0.33

The code was timed on a Windows^® 10, Intel^® Xeon^® CPU E5-1650 v4 @ 3.60 GHz test system by calling the timingMovprod function.