Module ImportFrom alias ImportFrom alias FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad body Expr Str If CompareIs NameLoad NameLoad body Assign NameStore NameLoad Assign NameStore ListLoad Assign NameStore Call NameLoad NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad If NameLoad body Assign NameStore ListComp Call NameLoad NameLoad comprehension NameStore AttributeLoad NameLoad attr orelse If NameLoad body Assign NameStore ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore NameLoad Assign NameStore Call NameLoad ListComp Call AttributeLoad NameLoad attr comprehension NameStore NameLoad orelse Assign NameStore Call AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad attr Assign NameStore Call NameLoad NameLoad Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad If NameLoad body Assign NameStore ListComp Call NameLoad NameLoad comprehension NameStore AttributeLoad NameLoad attr orelse If NameLoad body Assign NameStore ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore NameLoad Assign NameStore Call NameLoad ListComp Call AttributeLoad NameLoad attr comprehension NameStore NameLoad Assign NameStore ListComp Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad comprehension NameStore NameLoad orelse Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore ListLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad Assign NameStore Call NameLoad AttributeLoad NameLoad attr Assign NameStore Call NameLoad AttributeLoad NameLoad attr For TupleStore NameStore NameStore Call NameLoad AttributeLoad NameLoad attr body Assign NameStore AttributeLoad NameLoad attr If BoolOpAnd CompareIs NameLoad NameLoad CompareIn NameLoad NameLoad body Continue If BoolOpAnd CompareIsNot NameLoad NameLoad CompareNotIn NameLoad NameLoad body Continue If CompareIn NameLoad AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr BinOpMod Str NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr If CompareIsNot NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr ListComp NameLoad comprehension NameStore AttributeLoad NameLoad attr CompareIn NameLoad NameLoad Assign NameStore Dict For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareNotIn NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad ListLoad Expr Call AttributeLoad SubscriptLoad NameLoad Index NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Assign NameStore ListLoad If CompareIsNot AttributeLoad NameLoad attr NameLoad body Assign NameStore ListLoad orelse Assign NameStore NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad If BoolOpAnd NameLoad CompareIs NameLoad NameLoad body Raise Call NameLoad BinOpMod Str NameLoad If NameLoad body For NameStore NameLoad body Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpAnd CompareIs NameLoad NameLoad CompareIn NameLoad NameLoad body Continue Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad If CompareIsNot AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad orelse If UnaryOpNot NameLoad body Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad For TupleStore NameStore NameStore Call NameLoad AttributeLoad NameLoad attr body If BoolOpAnd CompareIs NameLoad NameLoad CompareIn NameLoad NameLoad body Continue Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad If CompareIsNot AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Return Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad keyword NameLoad decorator_list AttributeLoad NameLoad attr
N/A agate.rows Row agate utils join N/A N/A self right_table left_key right_key inner require_match columns N/A None False False None N/A N/A 
    Create a new table by joining two table's on common values.

    This method performs the equivalent of SQL's "left outer join", combining
    columns from this table and from :code:`right_table` anywhere that the
    :code:`left_key` and :code:`right_key` are equivalent.

    Where there is no match for :code:`left_key` the left columns will
    be included with the right columns set to :code:`None` unless
    the :code:`inner` argument is specified.

    If :code:`left_key` and :code:`right_key` are column names, only
    the left columns will be included in the output table.

    Column names from the right table which also exist in this table will
    be suffixed "2" in the new table.

    :param right_table:
        The "right" table to join to.
    :param left_key:
        Either the name of a column from the this table to join on, a
        sequence of such column names, or a :class:`function` that takes a
        row and returns a value to join on.
    :param right_key:
        Either the name of a column from :code:table` to join on, a
        sequence of such column names, or a :class:`function` that takes a
        row and returns a value to join on. If :code:`None` then
        :code:`left_key` will be used for both.
    :param inner:
        Perform a SQL-style "inner join" instead of a left outer join. Rows
        which have no match for :code:`left_key` will not be included in
        the output table.
    :param require_match:
        If true, an exception will be raised if there is a left_key with no
        matching right_key.
    :param columns:
        A sequence of column names from :code:`right_table` to include in
        the final output table. Defaults to all columns not in
        :code:`right_key`.
    :returns:
        A new :class:`.Table`.
     N/A N/A right_key None N/A N/A right_key left_key N/A right_key_indices N/A N/A left_key_is_func N/A hasattr left_key __call__ N/A left_key_is_sequence N/A N/A utils issequence left_key N/A left_key_is_func N/A N/A left_data N/A N/A left_key row N/A row N/A self _rows N/A N/A left_key_is_sequence N/A N/A left_columns N/A N/A N/A self _columns N/A key N/A key left_key N/A left_data N/A zip N/A N/A N/A column values N/A column left_columns N/A N/A left_data N/A N/A N/A N/A self _columns N/A left_key values N/A right_key_is_func N/A hasattr right_key __call__ N/A right_key_is_sequence N/A N/A utils issequence right_key N/A right_key_is_func N/A N/A right_data N/A N/A right_key row N/A row N/A right_table _rows N/A N/A right_key_is_sequence N/A N/A right_columns N/A N/A N/A right_table _columns N/A key N/A key right_key N/A right_data N/A zip N/A N/A N/A column values N/A column right_columns N/A right_key_indices N/A N/A N/A N/A N/A right_table _columns _keys index key N/A key right_key N/A N/A right_column N/A N/A right_table _columns N/A right_key N/A right_data N/A N/A right_column values N/A right_key_indices N/A N/A N/A N/A N/A right_table _columns _keys index right_key N/A column_names N/A list N/A self _column_names N/A column_types N/A list N/A self _column_types N/A N/A i column N/A enumerate N/A right_table _columns N/A N/A name N/A column name N/A N/A N/A columns None N/A i right_key_indices N/A N/A N/A N/A N/A columns None N/A name columns N/A N/A N/A N/A name N/A self column_names N/A N/A N/A N/A column_names append N/A %s2 name N/A N/A N/A N/A column_names append name N/A N/A N/A column_types append N/A column data_type N/A N/A columns None N/A N/A right_table N/A N/A right_table select N/A n N/A n N/A right_table _column_names N/A n columns N/A right_hash N/A N/A N/A i value N/A enumerate right_data N/A N/A N/A value right_hash N/A N/A N/A right_hash N/A value N/A N/A N/A N/A N/A right_hash N/A value append N/A N/A right_table _rows N/A i N/A rows N/A N/A N/A N/A self _row_names None N/A N/A row_names N/A N/A N/A row_names None N/A N/A left_index left_value N/A enumerate left_data N/A N/A matching_rows N/A N/A right_hash get left_value None N/A N/A require_match N/A matching_rows None N/A N/A N/A ValueError N/A Left key "%s" does not have a matching right key. left_value N/A matching_rows N/A N/A right_row matching_rows N/A N/A new_row N/A list N/A N/A self _rows N/A left_index N/A N/A k v N/A enumerate right_row N/A N/A N/A N/A columns None N/A k right_key_indices N/A N/A N/A N/A N/A new_row append v N/A N/A N/A rows append N/A Row new_row column_names N/A N/A N/A self _row_names None N/A N/A N/A N/A row_names append N/A N/A self _row_names N/A left_index N/A N/A N/A inner N/A N/A new_row N/A list N/A N/A self _rows N/A left_index N/A N/A k v N/A enumerate N/A right_table _column_names N/A N/A N/A N/A columns None N/A k right_key_indices N/A N/A N/A N/A N/A new_row append None N/A N/A N/A rows append N/A Row new_row column_names N/A N/A N/A self _row_names None N/A N/A N/A N/A row_names append N/A N/A self _row_names N/A left_index N/A N/A N/A self _fork rows column_names column_types row_names row_names N/A N/A utils allow_tableset_proxy