ibis.expr.api.TableExpr.anti_join

TableExpr.anti_join(other, predicates=())

Perform a relational join between two tables. Does not resolve resulting table schema.

Parameters
  • left (TableExpr) –

  • right (TableExpr) –

  • predicates (join expression(s)) –

  • how (string, default 'inner') –

    • ‘inner’: inner join

    • ’left’: left join

    • ’outer’: full outer join

    • ’right’: right outer join

    • ’semi’ or ‘left_semi’: left semi join

    • ’anti’: anti join

Returns

joined – Note that the schema is not materialized yet

Return type

TableExpr