intersect

(Not Recommended) Set intersection for dataset array observations

The dataset data type is not recommended. To work with heterogeneous data, use the MATLAB^® table data type instead. See MATLAB table documentation for more information.

Syntax

C = intersect(A,B)

C = intersect(A,B,vars)

C = intersect(A,B,vars,setOrder)

[C,iA,iB] = intersect(___)

Description

C = intersect(A,B) for dataset arrays A and B returns the common set of observations from the two arrays, with repetitions removed. The observations in the dataset array C are in sorted order.

C = intersect(A,B,vars) returns the set of common observations from the two arrays, considering only the variables specified in vars, with repetitions removed. The observations in the dataset array C are sorted by those variables.

The values for variables not specified in vars for each observation in C are taken from the corresponding observations in A. If there are multiple observations in A that correspond to an observation in C, then those values are taken from the first occurrence.

C = intersect(A,B,vars,setOrder) returns the observations in C in the order specified by setOrder.

[C,iA,iB] = intersect(___) also returns index vectors iA and iB such that C = A(iA,:) and C = B(iB,:). If there are repeated observations in A or B, then intersect returns the index of the first occurrence. You can use any of the previous input arguments.

Input Arguments

A,B — Input arrays

dataset objects

Input arrays, specified as dataset objects.

vars — Variable names

string array | cell array of character vectors | vector of integers containing variable column numbers

Variable names, specified as a string array, cell array of character vectors, or vector of integers containing variable column numbers. vars indicates the variables in A and B that intersect considers.

Specify vars as [] to use its default value of all variables.

setOrder — Flag indicating sorting order for observations in the resulting array

'sorted' (default) | 'stable'

Flag indicating sorting order for observations in the resulting array C, specified as 'sorted' or 'stable'.

'sorted'	Observations in C are in sorted order (default).
'stable'	Observations in C are in the same order that they appear in A.

Output Arguments

C — Common set of observations

dataset object

Common set of observations in A and B, with repetitions removed, returned as a dataset object. C is in sorted order (by default), or the order specified by setOrder.

iA — Index vector indicating observations in A that are common to B

vector of integers

Index vector indicating observations in A that are common to B, returned as a vector of integers. The vector iA contains the index to the first occurrence of any repeated observations in A.

iB — Index vector indicating observations in B that are common to A

vector of integers

Index vector indicating observations in B that are common to A, returned as a vector of integers. The vector iB contains the index to the first occurrence of any repeated observations in B.

Version History

Introduced in R2012b