pandas.Index.join#

finalIndex.join(other,*,how='left',level=None,return_indexers=False,sort=False)[source]#

Compute join_index and indexers to conform data structures to the new index.

Parameters:

otherIndex

how{‘left’, ‘right’, ‘inner’, ‘outer’}

levelint or level name, default None

return_indexersbool, default False

sortbool, default False

Sort the join keys lexicographically in the result Index. If False,the order of the join keys depends on the join type (how keyword).

Returns:

join_index, (left_indexer, right_indexer)

Examples

>>>idx1=pd.Index([1,2,3])>>>idx2=pd.Index([4,5,6])>>>idx1.join(idx2,how='outer')Index([1, 2, 3, 4, 5, 6], dtype='int64')