def test_outer_join_4():
t1 = Table({'a': [1, 2, 5, 8, 9, 13, 19], 'b': [1, 1, 1, 1, 1, 1, 1]})
t2 = Table({'a': [3, 6, 12], 'b': [2, 2, 2]})
t3 = full_outer_join(t1, t2, 'a')
assert np.all(t3.a.values == np.array([1, 2, 3, 5, 6, 8, 9, 12, 13, 19]))
assert np.all(t3.b.values == np.array([1, 1, 2, 1, 2, 1, 1, 2, 1, 1]))
def test_outer_join_1():
t1 = Table()
t1.add_column('a', [1, 2, 3, 4, 5, 6])
t1.add_column('b', [1, 2, 3])
t2 = Table()
t2.add_column('a', [2, 3, 4])
t2.add_column('b', [1, 1, 1])
t2.add_column('c', [5, 6, 7])
t3 = full_outer_join(t1, t2, 'a')
assert np.all(t3.a.values == np.array([1, 2, 3, 4, 5, 6]))
assert np.all(t3.b.values == np.array([1, 2, 3, 1]))
assert np.all(t3.c.values == np.array([5, 6, 7]))
def test_outer_join_datetime():
t1 = Table({
'a': pd.date_range('2000-01-01', periods=20),
'b': np.arange(20)
})
t2 = Table({
'a': pd.date_range('2000-01-01', periods=10),
'b': np.arange(10)
})
t2.add_column('c', [])
t3 = full_outer_join(t1, t2, 'a')
assert np.all(t3.b.values == np.arange(20))
def test_outer_join_3():
t1 = Table({
'A': np.random.rand(100),
'B': np.random.rand(100),
'C': np.random.rand(100),
'D': np.random.rand(100),
'E': np.random.rand(100),
'F': np.random.rand(100),
'G': np.random.rand(100),
'idx': np.arange(100)
})
t2 = Table({
'A': np.random.rand(100),
'G': np.random.rand(100),
'idx': np.arange(100, 200)
})
t3 = full_outer_join(t1, t2, 'idx', check_sorted=False)
assert np.all(t3.G.values == np.hstack([t1.G.values, t2.G.values]))
def test_outer_join_2():
t1 = Table({
'A': ['A0', 'A1', 'A2', 'A3'],
'B': ['B0', 'B1', 'B2', 'B3'],
'C': ['C0', 'C1', 'C2', 'C3'],
'D': ['D0', 'D1', 'D2', 'D3'],
'idx': [1, 2, 3, 4]
})
t2 = Table({
'A': ['A4', 'A5', 'A6', 'A7'],
'B': ['B4', 'B5', 'B6', 'B7'],
'C': ['C4', 'C5', 'C6', 'C7'],
'D': ['D4', 'D5', 'D6', 'D7'],
'idx': [5, 6, 7, 8]
})
t3 = full_outer_join(t1, t2, 'idx')
assert np.all(t3.A.values == np.array(
['A0', 'A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7']))