join

astropy.table.join(left, right, keys=None, join_type='inner', uniq_col_name='{col_name}_{table_name}', table_names=['1', '2'], metadata_conflicts='warn')[source]

Perform a join of the left table with the right table on specified keys.

Parameters
leftTable object or a value that will initialize a Table object

Left side table in the join

rightTable object or a value that will initialize a Table object

Right side table in the join

keysstr or list of str

Name(s) of column(s) used to match rows of left and right tables. Default is to use all columns which are common to both tables.

join_typestr

Join type (‘inner’ | ‘outer’ | ‘left’ | ‘right’), default is ‘inner’

uniq_col_namestr or None

String generate a unique output column name in case of a conflict. The default is ‘{col_name}_{table_name}’.

table_nameslist of str or None

Two-element list of table names used when generating unique output column names. The default is [‘1’, ‘2’].

metadata_conflictsstr
How to proceed with metadata conflicts. This should be one of:
  • 'silent': silently pick the last conflicting meta-data value

  • 'warn': pick the last conflicting meta-data value, but emit a warning (default)

  • 'error': raise an exception.

Returns
joined_tableTable object

New table containing the result of the join operation.