def test_anti_join_arg_sql_on(backend, df1, df2):
cond = lambda lhs, rhs: lhs.ii > rhs.ii
# collect sql result
out = anti_join(df1, df2, sql_on=cond) >> collect()
# for target, do full cartesian product, then filter based on cond
target = data_frame(ii=[1], x=["a"])
assert_frame_sort_equal(out, target)
def test_basic_anti_join(backend, df1, df2):
assert_frame_sort_equal(
anti_join(df1, df2, on={
"ii": "ii",
"x": "y"
}) >> collect(), DF1.iloc[2:, ])
def test_basic_anti_join_on_str(backend, df1, df2):
assert_frame_sort_equal(
anti_join(df1, df2, on="ii") >> collect(), DF1.iloc[2:, ])