def test_inner_str_join(self):
tbl = Tabl({"a": list(map(str, range(4))), "b": ['a', 'b'] * 2})
tbl_b = Tabl({"a": list(map(str, range(4))), "c": ['d', 'e'] * 2})
tbl_j = tbl.join(tbl_b, "a", jointype="inner")
assert "c_r" in tbl_j.columns
assert tbl_j[0] == ('0', 'a', 'd')
assert len(tbl_j) == 4
assert np.all(tbl[0] == ('0', 'a'))
def test_inner_int_join(self):
tbl = Tabl({"a": list(range(4)), "b": ['a', 'b'] * 2})
tbl_b = Tabl({"a": list(range(2, 6)), "c": ['d', 'e'] * 2})
tbl_j = tbl.join(tbl_b, "a")
assert "c_r" in tbl_j.columns
assert tbl_j[0] == (2, 'a', 'd')
assert len(tbl_j) == 2
assert np.all(tbl[0] == (0, 'a'))
def test_outer_join(self):
tbl = Tabl({"a": list(range(4)), "b": ['a', 'b'] * 2})
tbl_b = Tabl({
"a": list(range(2, 6)),
"c": [1, 2] * 2,
"d": [1.1, 2.2] * 2
})
tbl_j = tbl.join(tbl_b, "a", jointype='outer')
naneq(tbl_j[tbl_j['a_l'] == 0, 'c_r'], Tabl.join_fill_value['integer'])
naneq(tbl_j[tbl_j['a_l'] == 0, 'd_r'], Tabl.join_fill_value['float'])
naneq(tbl_j[tbl_j['a_r'] == 4, 'b_l'], Tabl.join_fill_value['string'])
assert "c_r" in tbl_j.columns
assert len(tbl_j) == 6