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

collapse all

Input arrays, specified as `dataset` objects.

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.

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

collapse all

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`.

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`.

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