anti-join

Keep the rows of x that have no match in y, adding no columns.

NoteExperimental

This function is experimental; its interface may change without notice.

Since 0.6.0.

The complement of semi-join: the rows of x whose key is absent from y.

Usage

anti-join(
  x,
  y,
  by: none,
)

Parameters

Parameter Default Description
x Dataset to filter (row-store or column-store).
y Dataset whose keys exclude rows of x (row-store or column-store).
by none Key columns: none for the common columns, a name, or an array.

Returns

The rows of x with no match in y.

See also

semi-join.

Back to top