§
    
�’j­Ë ã                  ó°  — d Z ddlmZ ddlmZmZ ddlZddlmZ ddl	Z	ddl
mZmZmZmZ ddlZddlZddlZddlmZmZmZmZ ddlmZ dd	lmZmZmZm Z m!Z!m"Z"m#Z#m$Z$ dd
l%m&Z& ddl'm(Z(m)Z) ddl*m+Z+ ddl,m-Z- ddl.m/Z/ ddl0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;m<Z<m=Z= ddl>m?Z?m@Z@ ddlAmBZBmCZC ddlDmEZEmFZF ddlGmHZHmIZImJZJmKZKmLZL ddlMmNc mOZP ddlQmRZRmSZSmTZT ddlUmVZV ddlWmNc mXZY ddlZm[Z[m\Z\ ddl]m^Z^ ddl_m`Z`maZa erddlGmbZb ddlcmdZd ddlQmeZe ddlfmgZg ejh        eji        ejj        eji        ejk        ejl        ejm        ejn        ejo        ejp        ejq        ejr        ejs        ejt        eju        ejv        ejw        ejx        ejy        ejx        ejz        ej{        ej|        ej}        ej~        ej        ej€        ej�        ej‚        ejƒ        iZ„ej…        ejk        ur= ej†        ej…        ¦  «        j‡        dk    rejl        e„ej…        <   neji        e„ej…        <   ejˆ        ejs        ur= ej†        ejˆ        ¦  «        j‡        dk    rejt        e„ejˆ        <   nejr        e„ejˆ        <   ej‰        eTeJeCfZŠ e)d¦  «        ddddd d d d!ej‹        d dfd‚d9„¦   «         ZŒ	 	 	 	 	 	 	 	 	 dƒd„d:„Z�d…d;„ZŽ e)d¦  «        	 	 	 	 	 	 	 	 d†d‡d@„¦   «         Z� e)d¦  «        	 	 	 	 	 	 	 	 	 	 	 	 dˆd‰dH„¦   «         Z� G dI„ dJ¦  «        Z‘	 	 dŠd‹dO„Z’	 	 dŠdŒdR„Z“d�dZ„Z” G d[„ d\e‘¦  «        Z•dŽd]„Z– G d^„ d_e•¦  «        Z—d�db„Z˜d�dc„Z™d‘dg„Zš	 d’d“dk„Z›	 	 d”d•do„Zœd–dq„Z�d—dt„Zžd˜d{„ZŸd™d|„Z d™d}„Z¡dšd„Z¢d›d�„Z£dS )œz
SQL-style merge routines
é    )Úannotations)ÚHashableÚSequenceN)Úpartial)ÚTYPE_CHECKINGÚLiteralÚcastÚfinal)Ú	TimedeltaÚ	hashtableÚjoinÚlib)Úis_range_indexer)ÚAnyArrayLikeÚ	ArrayLikeÚ
IndexLabelÚJoinHowÚMergeHowÚShapeÚSuffixesÚnpt)Ú
MergeError)Úcache_readonlyÚ
set_module)Úfind_stack_level)ÚExtensionDtype)Úfind_common_type)Úensure_int64Úensure_objectÚis_boolÚis_bool_dtypeÚis_float_dtypeÚ
is_integerÚis_integer_dtypeÚis_list_likeÚ	is_numberÚis_numeric_dtypeÚis_object_dtypeÚis_string_dtypeÚneeds_i8_conversion)ÚCategoricalDtypeÚDatetimeTZDtype)ÚABCDataFrameÚ	ABCSeries)ÚisnaÚna_value_for_dtype)Ú
ArrowDtypeÚCategoricalÚIndexÚ
MultiIndexÚSeries)ÚArrowExtensionArrayÚBaseMaskedArrayÚExtensionArray)ÚStringDtype)Úensure_wrapped_if_datetimelikeÚextract_array)Údefault_index)Úget_group_indexÚis_int64_overflow_possible)Ú	DataFrame)Úgroupby)ÚDatetimeArray)Ú
FrozenListé   ÚpandasÚinnerF©Ú_xÚ_yÚleftúDataFrame | SeriesÚrightÚhowr   Úonú IndexLabel | AnyArrayLike | NoneÚleft_onÚright_onÚ
left_indexÚboolÚright_indexÚsortÚsuffixesr   Úcopyúbool | lib.NoDefaultÚ	indicatorú
str | boolÚvalidateú
str | NoneÚreturnr?   c                ó  — t          | ¦  «        }|                      |
¦  «         t          |¦  «        }|dk    rt          |||||||||	||¬¦  «        S t          ||||||||||	||¬¦  «        }|                     ¦   «         S )a•  
    Merge DataFrame or named Series objects with a database-style join.

    A named Series object is treated as a DataFrame with a single named column.

    The join is done on columns or indexes. If joining columns on
    columns, the DataFrame indexes *will be ignored*. Otherwise if joining indexes
    on indexes or indexes on a column or columns, the index will be passed on.
    When performing a cross merge, no column specifications to merge on are
    allowed.

    .. warning::

        If both key columns contain rows where the key is a null value, those
        rows will be matched against each other. This is different from usual SQL
        join behaviour and can lead to unexpected results.

    Parameters
    ----------
    left : DataFrame or named Series
        First pandas object to merge.
    right : DataFrame or named Series
        Second pandas object to merge.
    how : {'left', 'right', 'outer', 'inner', 'cross', 'left_anti', 'right_anti},
        default 'inner'
        Type of merge to be performed.

        * left: use only keys from left frame, similar to a SQL left outer join;
          preserve key order.
        * right: use only keys from right frame, similar to a SQL right outer join;
          preserve key order.
        * outer: use union of keys from both frames, similar to a SQL full outer
          join; sort keys lexicographically.
        * inner: use intersection of keys from both frames, similar to a SQL inner
          join; preserve the order of the left keys.
        * cross: creates the cartesian product from both frames, preserves the order
          of the left keys.
        * left_anti: use only keys from left frame that are not in right frame, similar
          to SQL left anti join; preserve key order.
        * right_anti: use only keys from right frame that are not in left frame, similar
          to SQL right anti join; preserve key order.
    on : Hashable or a sequence of the previous
        Column or index level names to join on. These must be found in both
        DataFrames. If `on` is None and not merging on indexes then this defaults
        to the intersection of the columns in both DataFrames.
    left_on : Hashable or a sequence of the previous, or array-like
        Column or index level names to join on in the left DataFrame. Can also
        be an array or list of arrays of the length of the left DataFrame.
        These arrays are treated as if they are columns.
    right_on : Hashable or a sequence of the previous, or array-like
        Column or index level names to join on in the right DataFrame. Can also
        be an array or list of arrays of the length of the right DataFrame.
        These arrays are treated as if they are columns.
    left_index : bool, default False
        Use the index from the left DataFrame as the join key(s). If it is a
        MultiIndex, the number of keys in the other DataFrame (either the index
        or a number of columns) must match the number of levels.
    right_index : bool, default False
        Use the index from the right DataFrame as the join key. Same caveats as
        left_index.
    sort : bool, default False
        Sort the join keys lexicographically in the result DataFrame. If False,
        the order of the join keys depends on the join type (how keyword).
    suffixes : list-like, default is ("_x", "_y")
        A length-2 sequence where each element is optionally a string
        indicating the suffix to add to overlapping column names in
        `left` and `right` respectively. Pass a value of `None` instead
        of a string to indicate that the column name from `left` or
        `right` should be left as-is, with no suffix. At least one of the
        values must not be None.
    copy : bool, default False
        This keyword is now ignored; changing its value will have no
        impact on the method.

        .. deprecated:: 3.0.0

            This keyword is ignored and will be removed in pandas 4.0. Since
            pandas 3.0, this method always returns a new object using a lazy
            copy mechanism that defers copies until necessary
            (Copy-on-Write). See the `user guide on Copy-on-Write
            <https://pandas.pydata.org/docs/dev/user_guide/copy_on_write.html>`__
            for more details.

    indicator : bool or str, default False
        If True, adds a column to the output DataFrame called "_merge" with
        information on the source of each row. The column can be given a different
        name by providing a string argument. The column will have a Categorical
        type with the value of "left_only" for observations whose merge key only
        appears in the left DataFrame, "right_only" for observations
        whose merge key only appears in the right DataFrame, and "both"
        if the observation's merge key is found in both DataFrames.

    validate : str, optional
        If specified, checks if merge is of specified type.

        * "one_to_one" or "1:1": check if merge keys are unique in both
          left and right datasets.
        * "one_to_many" or "1:m": check if merge keys are unique in left
          dataset.
        * "many_to_one" or "m:1": check if merge keys are unique in right
          dataset.
        * "many_to_many" or "m:m": allowed, but does not result in checks.

    Returns
    -------
    DataFrame
        A DataFrame of the two merged objects.

    See Also
    --------
    merge_ordered : Merge with optional filling/interpolation.
    merge_asof : Merge on nearest keys.
    DataFrame.join : Similar method using indices.

    Examples
    --------
    >>> df1 = pd.DataFrame(
    ...     {"lkey": ["foo", "bar", "baz", "foo"], "value": [1, 2, 3, 5]}
    ... )
    >>> df2 = pd.DataFrame(
    ...     {"rkey": ["foo", "bar", "baz", "foo"], "value": [5, 6, 7, 8]}
    ... )
    >>> df1
        lkey value
    0   foo      1
    1   bar      2
    2   baz      3
    3   foo      5
    >>> df2
        rkey value
    0   foo      5
    1   bar      6
    2   baz      7
    3   foo      8

    Merge df1 and df2 on the lkey and rkey columns. The value columns have
    the default suffixes, _x and _y, appended.

    >>> df1.merge(df2, left_on="lkey", right_on="rkey")
      lkey  value_x rkey  value_y
    0  foo        1  foo        5
    1  foo        1  foo        8
    2  bar        2  bar        6
    3  baz        3  baz        7
    4  foo        5  foo        5
    5  foo        5  foo        8

    Merge DataFrames df1 and df2 with specified left and right suffixes
    appended to any overlapping columns.

    >>> df1.merge(df2, left_on="lkey", right_on="rkey", suffixes=("_left", "_right"))
      lkey  value_left rkey  value_right
    0  foo           1  foo            5
    1  foo           1  foo            8
    2  bar           2  bar            6
    3  baz           3  baz            7
    4  foo           5  foo            5
    5  foo           5  foo            8

    Merge DataFrames df1 and df2, but raise an exception if the DataFrames have
    any overlapping columns.

    >>> df1.merge(df2, left_on="lkey", right_on="rkey", suffixes=(False, False))
    Traceback (most recent call last):
    ...
    ValueError: columns overlap but no suffix specified:
        Index(['value'], dtype='str')

    >>> df1 = pd.DataFrame({"a": ["foo", "bar"], "b": [1, 2]})
    >>> df2 = pd.DataFrame({"a": ["foo", "baz"], "c": [3, 4]})
    >>> df1
          a  b
    0   foo  1
    1   bar  2
    >>> df2
          a  c
    0   foo  3
    1   baz  4

    >>> df1.merge(df2, how="inner", on="a")
          a  b  c
    0   foo  1  3

    >>> df1.merge(df2, how="left", on="a")
          a  b  c
    0   foo  1  3.0
    1   bar  2  NaN

    >>> df1 = pd.DataFrame({"left": ["foo", "bar"]})
    >>> df2 = pd.DataFrame({"right": [7, 8]})
    >>> df1
        left
    0   foo
    1   bar
    >>> df2
        right
    0   7
    1   8

    >>> df1.merge(df2, how="cross")
       left  right
    0   foo      7
    1   foo      8
    2   bar      7
    3   bar      8
    Úcross)	rM   rO   rP   rQ   rS   rT   rU   rX   rZ   ©
rL   rM   rO   rP   rQ   rS   rT   rU   rX   rZ   )Ú_validate_operandÚ_check_copy_deprecationÚ_cross_mergeÚ_MergeOperationÚ
get_result)rI   rK   rL   rM   rO   rP   rQ   rS   rT   rU   rV   rX   rZ   Úleft_dfÚright_dfÚops                   úGC:\Projects\DSCons\.venv\Lib\site-packages\pandas\core\reshape\merge.pyÚmergeri   ‘   s¾   € õ|   Ñ%Ô%€GØ× Ò  Ñ&Ô&Ð&Ý  Ñ'Ô'€HØ
ˆg‚~€~ÝØØØØØØ!Ø#ØØØØð
ñ 
ô 
ð 	
õ ØØØØØØØ!Ø#ØØØØð
ñ 
ô 
ˆð �}Š}‰ŒÐó    c                óæ   — |s|s|€|€|�t          d¦  «        ‚dt          j        ¦   «         › �} | j        di |di¤Ž}  |j        di |di¤Ž}|gx}}t	          | |d||||||||	|
¬¦  «        }||= |S )z,
    See merge.__doc__ with how='cross'
    NzMCan not pass on, right_on, left_on or set right_index=True or left_index=TrueÚ_cross_é   rE   r_   © )r   ÚuuidÚuuid4Úassignri   )rI   rK   rM   rO   rP   rQ   rS   rT   rU   rX   rZ   Ú	cross_colÚress                rh   rb   rb   ’  sÛ   € ð$ 	ð

àð

ð ÐØÐØˆ>åðñ
ô 
ð 	
ð
 )�$œ*™,œ,Ð(Ð(€IØˆ4Œ;Ð(Ð(˜) Q˜Ð(Ð(€DØˆEŒLÐ*Ð*˜I q˜>Ð*Ð*€Eà#˜Ð$€Gˆhå
ØØØØØØØØØØØØðñ ô €Cð 	ˆIˆØ€Jrj   c                óH  ‡‡— g }t          | t          t          f¦  «        s| g} |                     | d¬¦  «        }d}t	          ˆfd„| D ¦   «         ¦  «        r‰                     | d¬¦  «        }|j                             |j        ¦  «        D ]Ý\  }}|€‰}	n­	 ‰                     |j	        |         ¦  «        }	n‹# t          $ r~ |j                             ¦   «         Š‰ˆfd„‰j        D ¦   «         z   }
|                     |
¬¦  «        }t          t          |¦  «        ¦  «        |_        |                     |¦  «         Y Œ³w xY w |||	¦  «        }||| <   |                     |¦  «         ŒÞddlm}  ||d	¬
¦  «        }|                     |d         j        ¬¦  «        }||fS )zÒ
    groupby & merge; we are always performing a left-by type operation

    Parameters
    ----------
    by: field to group
    left: DataFrame
    right: DataFrame
    merge_pieces: function for merging
    F©rT   Nc              3  ó*   •K  — | ]}|‰j         v V — Œd S ©N©Úcolumns)Ú.0ÚitemrK   s     €rh   ú	<genexpr>z%_groupby_and_merge.<locals>.<genexpr>Ý  s*   øè è € Ð
0Ð
0 Tˆ4�5”=Ð Ð
0Ð
0Ð
0Ð
0Ð
0Ð
0rj   c                ó6   •— g | ]}|t          ‰¦  «        v¯|‘ŒS rn   )Úset)rz   ÚrÚlcolss     €rh   ú
<listcomp>z&_groupby_and_merge.<locals>.<listcomp>é  s)   ø€ ÐPÐPÐP a¸AÅSÈÁZÄZÐ<OÐ<O Ð<OÐ<OÐ<Orj   rx   r   ©ÚconcatT)Úignore_index)Ú
isinstanceÚlistÚtupler@   ÚallÚ_grouperÚget_iteratorÚ_selected_objÚtakeÚindicesÚKeyErrorry   ÚtolistÚreindexÚrangeÚlenÚindexÚappendÚpandas.core.reshape.concatrƒ   )ÚbyrI   rK   Úmerge_piecesÚpiecesÚlbyÚrbyÚkeyÚlhsÚrhsÚcolsÚmergedrƒ   Úresultr€   s     `           @rh   Ú_groupby_and_merger¡   Ç  sÜ  øø€ ð €FÝ�b�4¥˜-Ñ(Ô(ð ØˆTˆà
�,Š,�r ˆ,Ñ
&Ô
&€CØCG€Cõ Ð
0Ð
0Ð
0Ð
0¨RÐ
0Ñ
0Ô
0Ñ0Ô0ð ,Ø�mŠm˜B UˆmÑ+Ô+ˆà”L×-Ò-¨cÔ.?Ñ@Ô@ð ð ‰ˆˆSØˆ;ØˆCˆCð	Ø—j’j ¤¨SÔ!1Ñ2Ô2��øÝð ð ð àœ×*Ò*Ñ,Ô,�ØÐPÐPÐPÐP¨5¬=ÐPÑPÔPÑP�ØŸš¨T˜Ñ2Ô2�Ý$¥S¨¡[¤[Ñ1Ô1�”Ø—’˜fÑ%Ô%Ð%Ø�ðøøøð �˜c 3Ñ'Ô'ˆð ˆˆr‰
à�Š�fÑÔÐÐð 2Ð1Ð1Ð1Ð1Ð1àˆV�F¨Ð.Ñ.Ô.€FØ�^Š^ F¨1¤IÔ$5ˆ^Ñ6Ô6€FØ�3ˆ;Ðs   Â B:Â:BEÅEÚouterúIndexLabel | NoneÚfill_methodr   c
                ód  ‡‡‡‡‡‡	‡— dˆˆ	ˆˆˆˆfd„Š|�|�t          d¦  «        ‚|�}t          |t          ¦  «        r|g}t          |¦  «                             | j        ¦  «        }
t          |
¦  «        dk    rt          |
› d�¦  «        ‚t          || |ˆfd„¦  «        \  }}n‹|�}t          |t          ¦  «        r|g}t          |¦  «                             |j        ¦  «        }
t          |
¦  «        dk    rt          |
› d	�¦  «        ‚t          ||| ˆfd
„¦  «        \  }}n ‰| |¦  «        }|S )aÂ  
    Perform a merge for ordered data with optional filling/interpolation.

    Designed for ordered data like time series data. Optionally
    perform group-wise merge (see examples).

    Parameters
    ----------
    left : DataFrame or named Series
        First pandas object to merge.
    right : DataFrame or named Series
        Second pandas object to merge.
    on : Hashable or a sequence of the previous
        Field names to join on. Must be found in both DataFrames.
    left_on : Hashable or a sequence of the previous, or array-like
        Field names to join on in left DataFrame. Can be a vector or list of
        vectors of the length of the DataFrame to use a particular vector as
        the join key instead of columns.
    right_on : Hashable or a sequence of the previous, or array-like
        Field names to join on in right DataFrame or vector/list of vectors per
        left_on docs.
    left_by : column name or list of column names
        Group left DataFrame by group columns and merge piece by piece with
        right DataFrame. Must be None if either left or right are a Series.
    right_by : column name or list of column names
        Group right DataFrame by group columns and merge piece by piece with
        left DataFrame. Must be None if either left or right are a Series.
    fill_method : {'ffill', None}, default None
        Interpolation method for data.
    suffixes : list-like, default is ("_x", "_y")
        A length-2 sequence where each element is optionally a string
        indicating the suffix to add to overlapping column names in
        `left` and `right` respectively. Pass a value of `None` instead
        of a string to indicate that the column name from `left` or
        `right` should be left as-is, with no suffix. At least one of the
        values must not be None.

    how : {'left', 'right', 'outer', 'inner'}, default 'outer'
        * left: use only keys from left frame (SQL: left outer join)
        * right: use only keys from right frame (SQL: right outer join)
        * outer: use union of keys from both frames (SQL: full outer join)
        * inner: use intersection of keys from both frames (SQL: inner join).

    Returns
    -------
    DataFrame
        The merged DataFrame output type will be the same as
        'left', if it is a subclass of DataFrame.

    See Also
    --------
    merge : Merge with a database-style join.
    merge_asof : Merge on nearest keys.

    Examples
    --------
    >>> from pandas import merge_ordered
    >>> df1 = pd.DataFrame(
    ...     {
    ...         "key": ["a", "c", "e", "a", "c", "e"],
    ...         "lvalue": [1, 2, 3, 1, 2, 3],
    ...         "group": ["a", "a", "a", "b", "b", "b"],
    ...     }
    ... )
    >>> df1
      key  lvalue group
    0   a       1     a
    1   c       2     a
    2   e       3     a
    3   a       1     b
    4   c       2     b
    5   e       3     b

    >>> df2 = pd.DataFrame({"key": ["b", "c", "d"], "rvalue": [1, 2, 3]})
    >>> df2
      key  rvalue
    0   b       1
    1   c       2
    2   d       3

    >>> merge_ordered(df1, df2, fill_method="ffill", left_by="group")
      key  lvalue group  rvalue
    0   a       1     a     NaN
    1   b       1     a     1.0
    2   c       2     a     2.0
    3   d       2     a     3.0
    4   e       3     a     3.0
    5   a       1     b     NaN
    6   b       1     b     1.0
    7   c       2     b     2.0
    8   d       2     b     3.0
    9   e       3     b     3.0
    r\   r?   c           
     óZ   •— t          | |‰‰‰‰‰‰¬¦  «        }|                     ¦   «         S )N)rM   rO   rP   rU   r¤   rL   )Ú_OrderedMergerd   )	ÚxÚyrg   r¤   rL   rO   rM   rP   rU   s	      €€€€€€rh   Ú_mergerzmerge_ordered.<locals>._mergerk  s?   ø€ åØØØØØØØ#Øð	
ñ 	
ô 	
ˆð �}Š}‰ŒÐrj   Nz*Can only group either left or right framesr   z not found in left columnsc                ó   •—  ‰| |¦  «        S rw   rn   ©r¨   r©   rª   s     €rh   ú<lambda>zmerge_ordered.<locals>.<lambda>�  s   ø€ È'È'ÐRSÐUVÉ-Ì-€ rj   z not found in right columnsc                ó   •—  ‰|| ¦  «        S rw   rn   r¬   s     €rh   r­   zmerge_ordered.<locals>.<lambda>‰  s   ø€ °°¸¸1±´€ rj   ©r\   r?   )	Ú
ValueErrorr…   Ústrr~   Ú
differencery   r’   rŽ   r¡   )rI   rK   rM   rO   rP   Úleft_byÚright_byr¤   rU   rL   Úcheckr    Ú_rª   s     ```  ```   @rh   Úmerge_orderedr·      s€  øøøøøøø€ ðVð ð ð ð ð ð ð ð ð ð ð Ð˜xÐ3ÝÐEÑFÔFÐFØÐÝ�g�sÑ#Ô#ð 	 Ø�iˆGÝ�G‘”×'Ò'¨¬Ñ5Ô5ˆÝˆu‰:Œ:˜Š?ˆ?Ý˜eÐ?Ð?Ð?Ñ@Ô@Ð@Ý& w°°eÐ=WÐ=WÐ=WÐ=WÑXÔX‰	ˆ��Ø	Ð	Ý�h¥Ñ$Ô$ð 	"Ø �zˆHÝ�H‘”×(Ò(¨¬Ñ7Ô7ˆÝˆu‰:Œ:˜Š?ˆ?Ý˜eÐ@Ð@Ð@ÑAÔAÐAÝ&Ø�e˜TÐ#=Ð#=Ð#=Ð#=ñ
ô 
‰	ˆ��ð �˜˜uÑ%Ô%ˆØ€Mrj   TÚbackwardÚ	toleranceúint | datetime.timedelta | NoneÚallow_exact_matchesÚ	directionr±   c                óf   — t          | |||||||||	|
d|||¬¦  «        }|                     ¦   «         S )a¬$  
    Perform a merge by key distance.

    This is similar to a left-join except that we match on nearest
    key rather than equal keys. Both DataFrames must be first sorted by
    the merge key in ascending order before calling this function.
    Sorting by any additional 'by' grouping columns is not required.

    For each row in the left DataFrame:

      - A "backward" search selects the last row in the right DataFrame whose
        'on' key is less than or equal to the left's key.

      - A "forward" search selects the first row in the right DataFrame whose
        'on' key is greater than or equal to the left's key.

      - A "nearest" search selects the row in the right DataFrame whose 'on'
        key is closest in absolute distance to the left's key.

    Optionally match on equivalent keys with 'by' before searching with 'on'.

    Parameters
    ----------
    left : DataFrame or named Series
        First pandas object to merge.
    right : DataFrame or named Series
        Second pandas object to merge.
    on : label
        Field name to join on. Must be found in both DataFrames.
        The data MUST be in ascending order. Furthermore this must be
        a numeric column, such as datetimelike, integer, or float. ``on``
        or ``left_on`` / ``right_on`` must be given.
    left_on : label
        Field name to join on in left DataFrame. If specified, sort the left
        DataFrame by this column in ascending order before merging.
    right_on : label
        Field name to join on in right DataFrame. If specified, sort the right
        DataFrame by this column in ascending order before merging.
    left_index : bool
        Use the index of the left DataFrame as the join key.
    right_index : bool
        Use the index of the right DataFrame as the join key.
    by : column name or list of column names
        Match on these columns before performing merge operation. It is not required
        to sort by these columns.
    left_by : column name
        Field names to match on in the left DataFrame.
    right_by : column name
        Field names to match on in the right DataFrame.
    suffixes : 2-length sequence (tuple, list, ...)
        Suffix to apply to overlapping column names in the left and right
        side, respectively.
    tolerance : int or timedelta, optional, default None
        Select asof tolerance within this range; must be compatible
        with the merge index.
    allow_exact_matches : bool, default True

        - If True, allow matching with the same 'on' value
          (i.e. less-than-or-equal-to / greater-than-or-equal-to)
        - If False, don't match the same 'on' value
          (i.e., strictly less-than / strictly greater-than).

    direction : 'backward' (default), 'forward', or 'nearest'
        Whether to search for prior, subsequent, or closest matches.

    Returns
    -------
    DataFrame
        A DataFrame of the two merged objects, containing all rows from the
        left DataFrame and the nearest matches from the right DataFrame.

    See Also
    --------
    merge : Merge with a database-style join.
    merge_ordered : Merge with optional filling/interpolation.

    Examples
    --------
    >>> left = pd.DataFrame({"a": [1, 5, 10], "left_val": ["a", "b", "c"]})
    >>> left
        a left_val
    0   1        a
    1   5        b
    2  10        c

    >>> right = pd.DataFrame({"a": [1, 2, 3, 6, 7], "right_val": [1, 2, 3, 6, 7]})
    >>> right
       a  right_val
    0  1          1
    1  2          2
    2  3          3
    3  6          6
    4  7          7

    >>> pd.merge_asof(left, right, on="a")
        a left_val  right_val
    0   1        a          1
    1   5        b          3
    2  10        c          7

    >>> pd.merge_asof(left, right, on="a", allow_exact_matches=False)
        a left_val  right_val
    0   1        a        NaN
    1   5        b        3.0
    2  10        c        7.0

    >>> pd.merge_asof(left, right, on="a", direction="forward")
        a left_val  right_val
    0   1        a        1.0
    1   5        b        6.0
    2  10        c        NaN

    >>> pd.merge_asof(left, right, on="a", direction="nearest")
        a left_val  right_val
    0   1        a          1
    1   5        b          6
    2  10        c          7

    We can use indexed DataFrames as well.

    >>> left = pd.DataFrame({"left_val": ["a", "b", "c"]}, index=[1, 5, 10])
    >>> left
       left_val
    1         a
    5         b
    10        c

    >>> right = pd.DataFrame({"right_val": [1, 2, 3, 6, 7]}, index=[1, 2, 3, 6, 7])
    >>> right
       right_val
    1          1
    2          2
    3          3
    6          6
    7          7

    >>> pd.merge_asof(left, right, left_index=True, right_index=True)
       left_val  right_val
    1         a          1
    5         b          3
    10        c          7

    Here is a real-world times-series example

    >>> quotes = pd.DataFrame(
    ...     {
    ...         "time": [
    ...             pd.Timestamp("2016-05-25 13:30:00.023"),
    ...             pd.Timestamp("2016-05-25 13:30:00.023"),
    ...             pd.Timestamp("2016-05-25 13:30:00.030"),
    ...             pd.Timestamp("2016-05-25 13:30:00.041"),
    ...             pd.Timestamp("2016-05-25 13:30:00.048"),
    ...             pd.Timestamp("2016-05-25 13:30:00.049"),
    ...             pd.Timestamp("2016-05-25 13:30:00.072"),
    ...             pd.Timestamp("2016-05-25 13:30:00.075"),
    ...         ],
    ...         "ticker": [
    ...             "GOOG",
    ...             "MSFT",
    ...             "MSFT",
    ...             "MSFT",
    ...             "GOOG",
    ...             "AAPL",
    ...             "GOOG",
    ...             "MSFT",
    ...         ],
    ...         "bid": [720.50, 51.95, 51.97, 51.99, 720.50, 97.99, 720.50, 52.01],
    ...         "ask": [720.93, 51.96, 51.98, 52.00, 720.93, 98.01, 720.88, 52.03],
    ...     }
    ... )
    >>> quotes
                         time ticker     bid     ask
    0 2016-05-25 13:30:00.023   GOOG  720.50  720.93
    1 2016-05-25 13:30:00.023   MSFT   51.95   51.96
    2 2016-05-25 13:30:00.030   MSFT   51.97   51.98
    3 2016-05-25 13:30:00.041   MSFT   51.99   52.00
    4 2016-05-25 13:30:00.048   GOOG  720.50  720.93
    5 2016-05-25 13:30:00.049   AAPL   97.99   98.01
    6 2016-05-25 13:30:00.072   GOOG  720.50  720.88
    7 2016-05-25 13:30:00.075   MSFT   52.01   52.03

    >>> trades = pd.DataFrame(
    ...     {
    ...         "time": [
    ...             pd.Timestamp("2016-05-25 13:30:00.023"),
    ...             pd.Timestamp("2016-05-25 13:30:00.038"),
    ...             pd.Timestamp("2016-05-25 13:30:00.048"),
    ...             pd.Timestamp("2016-05-25 13:30:00.048"),
    ...             pd.Timestamp("2016-05-25 13:30:00.048"),
    ...         ],
    ...         "ticker": ["MSFT", "MSFT", "GOOG", "GOOG", "AAPL"],
    ...         "price": [51.95, 51.95, 720.77, 720.92, 98.0],
    ...         "quantity": [75, 155, 100, 100, 100],
    ...     }
    ... )
    >>> trades
                         time ticker   price  quantity
    0 2016-05-25 13:30:00.023   MSFT   51.95        75
    1 2016-05-25 13:30:00.038   MSFT   51.95       155
    2 2016-05-25 13:30:00.048   GOOG  720.77       100
    3 2016-05-25 13:30:00.048   GOOG  720.92       100
    4 2016-05-25 13:30:00.048   AAPL   98.00       100

    By default we are taking the asof of the quotes

    >>> pd.merge_asof(trades, quotes, on="time", by="ticker")
                         time ticker   price  quantity     bid     ask
    0 2016-05-25 13:30:00.023   MSFT   51.95        75   51.95   51.96
    1 2016-05-25 13:30:00.038   MSFT   51.95       155   51.97   51.98
    2 2016-05-25 13:30:00.048   GOOG  720.77       100  720.50  720.93
    3 2016-05-25 13:30:00.048   GOOG  720.92       100  720.50  720.93
    4 2016-05-25 13:30:00.048   AAPL   98.00       100     NaN     NaN

    We only asof within 2ms between the quote time and the trade time

    >>> pd.merge_asof(
    ...     trades, quotes, on="time", by="ticker", tolerance=pd.Timedelta("2ms")
    ... )
                         time ticker   price  quantity     bid     ask
    0 2016-05-25 13:30:00.023   MSFT   51.95        75   51.95   51.96
    1 2016-05-25 13:30:00.038   MSFT   51.95       155     NaN     NaN
    2 2016-05-25 13:30:00.048   GOOG  720.77       100  720.50  720.93
    3 2016-05-25 13:30:00.048   GOOG  720.92       100  720.50  720.93
    4 2016-05-25 13:30:00.048   AAPL   98.00       100     NaN     NaN

    We only asof within 10ms between the quote time and the trade time
    and we exclude exact matches on time. However *prior* data will
    propagate forward

    >>> pd.merge_asof(
    ...     trades,
    ...     quotes,
    ...     on="time",
    ...     by="ticker",
    ...     tolerance=pd.Timedelta("10ms"),
    ...     allow_exact_matches=False,
    ... )
                         time ticker   price  quantity     bid     ask
    0 2016-05-25 13:30:00.023   MSFT   51.95        75     NaN     NaN
    1 2016-05-25 13:30:00.038   MSFT   51.95       155   51.97   51.98
    2 2016-05-25 13:30:00.048   GOOG  720.77       100     NaN     NaN
    3 2016-05-25 13:30:00.048   GOOG  720.92       100     NaN     NaN
    4 2016-05-25 13:30:00.048   AAPL   98.00       100     NaN     NaN
    Úasof)rM   rO   rP   rQ   rS   r–   r³   r´   rU   rL   r¹   r»   r¼   )Ú
_AsOfMergerd   )rI   rK   rM   rO   rP   rQ   rS   r–   r³   r´   rU   r¹   r»   r¼   rg   s                  rh   Ú
merge_asofrÀ   �  sV   € õJ 
ØØØØØØØØØØØØØØ/Øð
ñ 
ô 
€Bð" �=Š=‰?Œ?Ðrj   c                  ó*  — e Zd ZU dZdZded<   ded<   ded<   ded	<   d
ed<   d
ed<   d
ed<   ded<   ded<   ded<   ded<   ded<   ded<   	 	 	 	 	 	 	 	 	 	 dIdJd%„ZedKd'„¦   «         ZdLd(„Z	dMd)„Z
edNd0„¦   «         ZdOd1„ZeedPd2„¦   «         ¦   «         ZedQd4„¦   «         ZedRd6„¦   «         ZedSd7„¦   «         ZedTd8„¦   «         ZdUd:„ZedVd<„¦   «         Ze	 dWdXdA„¦   «         ZedYdB„¦   «         ZedZdD„¦   «         Zed[dE„¦   «         ZdF„ Zed\dH„¦   «         ZdS )]rc   z�
    Perform a database (SQL) merge operation between two DataFrame or Series
    objects using either columns as keys or their row indexes
    ri   úJoinHow | Literal['asof']rL   r£   rM   z!Sequence[Hashable | AnyArrayLike]rO   rP   rR   rQ   rS   rT   r   rU   rY   rX   r[   rZ   zlist[Hashable]Ú
join_namesúlist[ArrayLike]Úright_join_keysÚleft_join_keysrE   NFTrF   rI   rJ   rK   ú4JoinHow | Literal['left_anti', 'right_anti', 'asof']rN   r\   ÚNonec                óp  — t          |¦  «        }t          |¦  «        }|x| _        | _        |x| _        | _        |                      |¦  «        \  | _        | _        t          j	        |¦  «        | _
        |
| _        |	p|dk    | _        || _        || _        || _        t!          |¦  «        st#          dt%          |¦  «        › �¦  «        ‚t!          |¦  «        st#          dt%          |¦  «        › �¦  «        ‚|j        j        |j        j        k    r,d|j        j        › d|j        j        › d�}t+          |¦  «        ‚|                      ||¦  «        \  | _        | _        |                      ¦   «         \  | _        | _        | _        }}|r| j                             |¦  «        | _        |r| j                             |¦  «        | _        |                      | j        | j        ¦  «         |                      | j        ¦  «         |                       ¦   «          |�|  !                    |¦  «         d S d S )Nr¢   z/left_index parameter must be of type bool, not z0right_index parameter must be of type bool, not z0Not allowed to merge between different levels. (z levels on the left, z on the right))"r`   rI   Ú	orig_leftrK   Ú
orig_rightÚ_validate_howrL   Ú	anti_joinÚcomÚmaybe_make_listrM   rU   rT   rQ   rS   rX   r    r°   Útypery   Únlevelsr   Ú_validate_left_right_onrO   rP   Ú_get_merge_keysrÆ   rÅ   rÃ   Ú_drop_labels_or_levelsÚ_maybe_require_matching_dtypesÚ_validate_toleranceÚ_maybe_coerce_merge_keysÚ_validate_validate_kwd)ÚselfrI   rK   rL   rM   rO   rP   rQ   rS   rT   rU   rX   rZ   Ú_leftÚ_rightÚmsgÚ	left_dropÚ
right_drops                     rh   Ú__init__z_MergeOperation.__init__Á  sW  € õ " $Ñ'Ô'ˆÝ" 5Ñ)Ô)ˆØ%*Ð*ˆŒ	�D”NØ'-Ð-ˆŒ
�T”_Ø#'×#5Ò#5°cÑ#:Ô#:Ñ ˆŒ�$”.åÔ% bÑ)Ô)ˆŒà ˆŒØÐ*˜C 7šNˆŒ	à$ˆŒØ&ˆÔà"ˆŒå�zÑ"Ô"ð 	ÝØTÅ$ÀzÑBRÔBRÐTÐTñô ð õ �{Ñ#Ô#ð 	ÝØVÅ4ÈÑCTÔCTÐVÐVñô ð ð
 Œ=Ô  F¤NÔ$:Ò:Ð:ð:Ø”MÔ)ð:ð :à”>Ô)ð:ð :ð :ð õ
 ˜S‘/”/Ð!à&*×&BÒ&BÀ7ÈHÑ&UÔ&UÑ#ˆŒ�d”mð × Ò Ñ"Ô"ñ	
ØÔØÔ ØŒOØØð ð 	DØœ	×8Ò8¸ÑCÔCˆDŒIàð 	GØœ×:Ò:¸:ÑFÔFˆDŒJà×+Ò+¨DÔ,?ÀÔAUÑVÔVÐVØ× Ò  Ô!4Ñ5Ô5Ð5ð 	×%Ò%Ñ'Ô'Ð'ð
 ÐØ×'Ò'¨Ñ1Ô1Ð1Ð1Ð1ð  Ðrj   ú&tuple[JoinHow | Literal['asof'], bool]c                óÌ   — h d£}||vrt          d|› d�¦  «        ‚d}|dv r|                     d¦  «        d         }d}t          t          t          d	         z  |¦  «        }||fS )
zx
        Validate the 'how' parameter and return the actual join type and whether
        this is an anti join.
        >   r¾   rI   r^   rE   r¢   rK   Ú	left_antiÚ
right_antiú'zZ' is not a valid Merge type: left, right, inner, outer, left_anti, right_anti, cross, asofF>   râ   rã   r¶   r   Tr¾   )r°   Úsplitr	   r   r   )rÙ   rL   Ú
merge_typerÍ   s       rh   rÌ   z_MergeOperation._validate_how  sš   € ð	
ð 	
ð 	
ˆ
ð �jÐ Ð ÝðQ�Cð Qð Qð Qñô ð ð ˆ	ØÐ-Ð-Ð-Ø—)’)˜C‘.”. Ô#ˆCØˆIÝ•7�W Vœ_Ñ,¨cÑ2Ô2ˆØ�Iˆ~Ðrj   c                ó   — d S rw   rn   )rÙ   rÆ   rÅ   s      rh   rÕ   z._MergeOperation._maybe_require_matching_dtypes.  s	   € ð 	ˆrj   c                ó   — d S rw   rn   )rÙ   rÆ   s     rh   rÖ   z#_MergeOperation._validate_tolerance4  s   € àˆrj   Ú
join_indexr3   Úleft_indexerúnpt.NDArray[np.intp] | NoneÚright_indexerr?   c                ój  — | j         dd…         }| j        dd…         }t          | j         j        | j        j        | j        ¦  «        \  }}|�Yt          |t          |¦  «        ¦  «        s<|j                             ||dddd¬¦  «        }| 	                    ||j
        ¬¦  «        }||_        |�Yt          |t          |¦  «        ¦  «        s<|j                             ||dddd¬¦  «        }	| 	                    |	|	j
        ¬¦  «        }||_        ddlm}
 ||_        ||_         |
||gd¬¦  «        }|S )	z?
        reindex along index and concat along columns.
        Nrm   T)ÚaxisÚ
only_sliceÚ
allow_dupsÚuse_na_proxy)Úaxesr   r‚   )rî   )rI   rK   Ú_items_overlap_with_suffixÚ
_info_axisrU   r   r’   Ú_mgrÚreindex_indexerÚ_constructor_from_mgrrò   r“   rD   rƒ   ry   )rÙ   ré   rê   rì   rI   rK   ÚllabelsÚrlabelsÚlmgrÚrmgrrƒ   r    s               rh   Ú_reindex_and_concatz#_MergeOperation._reindex_and_concat8  sk  € ð Œy˜˜˜Œ|ˆØ”
˜1˜1˜1”ˆå5ØŒIÔ  $¤*Ô"7¸¼ñ
ô 
Ñˆ�ð Ð#Õ,<¸\Í3ÈtÉ9Ì9Ñ,UÔ,UÐ#ð ”9×,Ò,ØØØØØØ!ð -ñ ô ˆDð ×-Ò-¨d¸¼Ð-ÑCÔCˆDØˆŒ
àÐ$Õ-=Ø�3˜u™:œ:ñ.
ô .
Ð$ð ”:×-Ò-ØØØØØØ!ð .ñ ô ˆDð ×/Ò/°¸4¼9Ð/ÑEÔEˆEØ ˆŒà!Ð!Ð!Ð!Ð!Ð!àˆŒØˆŒØ�˜˜u˜¨AÐ.Ñ.Ô.ˆØˆrj   c                óÜ  — | j         r-|                      | j        | j        ¦  «        \  | _        | _        |                      ¦   «         \  }}}|                      |||¦  «        }| j         r|                      |¦  «        }|                      |||¦  «         |                      |¦  «         | 	                    t          j        | j        | j        g| j        | j        ¬¦  «        d¬¦  «        S )z$
        Execute the merge.
        )Ú
input_objsrI   rK   ri   )Úmethod)rX   Ú_indicator_pre_mergerI   rK   Ú_get_join_inforü   Ú_indicator_post_mergeÚ_maybe_add_join_keysÚ_maybe_restore_index_levelsÚ__finalize__ÚtypesÚSimpleNamespace)rÙ   ré   rê   rì   r    s        rh   rd   z_MergeOperation.get_resultn  sô   € ð Œ>ð 	UØ$(×$=Ò$=¸d¼iÈÌÑ$TÔ$TÑ!ˆDŒI�t”zà26×2EÒ2EÑ2GÔ2GÑ/ˆ
�L -à×)Ò)¨*°lÀMÑRÔRˆàŒ>ð 	8Ø×/Ò/°Ñ7Ô7ˆFà×!Ò! &¨,¸ÑFÔFÐFà×(Ò(¨Ñ0Ô0Ð0à×"Ò"ÝÔ!Ø œI t¤zÐ2¸¼È$Ì*ðñ ô ð ð	 #ñ 
ô 
ð 	
rj   c                ó¬   — t          | j        t          ¦  «        r| j        S t          | j        t          ¦  «        r| j        rdnd S t	          d¦  «        ‚)NÚ_mergez<indicator option can only accept boolean or string arguments)r…   rX   r±   rR   r°   ©rÙ   s    rh   Ú_indicator_namez_MergeOperation._indicator_name‡  sZ   € õ �d”n¥cÑ*Ô*ð 	Ø”>Ð!Ý˜œ­Ñ-Ô-ð 	Ø#œ~Ð7�8�8°4Ð7åØNñô ð rj   útuple[DataFrame, DataFrame]c                ó’  — |j                              |j         ¦  «        }dD ]}||v rt          d|› �¦  «        ‚Œ| j        |v rt          d¦  «        ‚|                     d¬¦  «        }|                     d¬¦  «        }d|d<   |d                              d¦  «        |d<   d	|d
<   |d
                              d¦  «        |d
<   ||fS )a  
        Add one indicator column to each of the left and right inputs.

        These columns are used to produce another column in the output of the
        merge, indicating for each row of the output whether it was produced
        using the left, right or both inputs.
        )Ú_left_indicatorÚ_right_indicatorzECannot use `indicator=True` option when data contains a column named z:Cannot use name of an existing column for indicator columnF©Údeeprm   r  Úint8é   r  )ry   Úunionr°   r  rV   Úastype)rÙ   rI   rK   ry   Úis        rh   r   z$_MergeOperation._indicator_pre_merge“  s  € ð ”,×$Ò$ U¤]Ñ3Ô3ˆà8ð 	ð 	ˆAØ�Gˆ|ˆ|Ý ð8Ø45ð8ð 8ñô ð ð ð
 Ô 7Ð*Ð*ÝØLñô ð ð �yŠy˜eˆyÑ$Ô$ˆØ—
’
 �
Ñ&Ô&ˆà"#ˆÐÑØ"&Ð'8Ô"9×"@Ò"@ÀÑ"HÔ"HˆÐÑà$%ˆÐ Ñ!Ø$)Ð*<Ô$=×$DÒ$DÀVÑ$LÔ$LˆÐ Ñ!à�Uˆ{Ðrj   r    c                ób  — |d                               d¦  «        |d<   |d                               d¦  «        |d<   t          |d         |d         z   g d¢¬¦  «        || j        <   || j                 j                             g d¢¦  «        || j        <   |                     ddgd¬¦  «        }|S )	z¾
        Add an indicator column to the merge result.

        This column indicates for each row of the output whether it was produced using
        the left, right or both inputs.
        r  r   r  )rm   r  é   )Ú
categories)Ú	left_onlyÚ
right_onlyÚbothrm   )Úlabelsrî   )Úfillnar2   r  ÚcatÚrename_categoriesÚdrop)rÙ   r    s     rh   r  z%_MergeOperation._indicator_post_merge¶  sÒ   € ð %+Ð+<Ô$=×$DÒ$DÀQÑ$GÔ$GˆÐ Ñ!Ø%+Ð,>Ô%?×%FÒ%FÀqÑ%IÔ%IˆÐ!Ñ"å'2ØÐ%Ô&¨Ð0BÔ)CÑCØ �y�yð(
ñ (
ô (
ˆˆtÔ#Ñ$ð (.ØÔ ô(
ä
×ÒÐ CÐ CÐ CÑDÔDð 	ˆtÔ#Ñ$ð —’Ð%6Ð8JÐ$KÐRS�ÑTÔTˆØˆrj   c                óL  — g }t          | j        | j        | j        d¬¦  «        D ]c\  }}}| j                             |¦  «        rC| j                             |¦  «        r)||k    r#||j        j        vr| 	                    |¦  «         Œd|r| 
                    |d¬¦  «         dS dS )a  
        Restore index levels specified as `on` parameters

        Here we check for cases where `self.left_on` and `self.right_on` pairs
        each reference an index level in their respective DataFrames. The
        joined columns corresponding to these pairs are then restored to the
        index of `result`.

        **Note:** This method has side effects. It modifies `result` in-place

        Parameters
        ----------
        result: DataFrame
            merge result

        Returns
        -------
        None
        T©Ústrict©ÚinplaceN)ÚziprÃ   rO   rP   rÊ   Ú_is_level_referencerË   r“   Únamesr”   Ú	set_index)rÙ   r    Únames_to_restoreÚnameÚleft_keyÚ	right_keys         rh   r  z+_MergeOperation._maybe_restore_index_levelsÌ  sÛ   € ð* ÐÝ),ØŒO˜Tœ\¨4¬=Àð*
ñ *
ô *
ð 	.ð 	.Ñ%ˆD�(˜Ið ”×2Ò2°8Ñ<Ô<ð	.ð ”O×7Ò7Øñô ð.ð  	Ò)Ð)Ø ¤Ô 2Ð2Ð2à ×'Ò'¨Ñ-Ô-Ð-øàð 	=Ø×ÒÐ-°tÐÑ<Ô<Ð<Ð<Ð<ð	=ð 	=rj   c                óÆ  ‡‡‡— d }d }t          d„ | j        D ¦   «         ¦  «        sJ ‚t          | j        | j        | j        d¬¦  «        }t          |¦  «        D �]†\  }\  Š}}	t          ||	¦  «        sŒd\  }
}‰‰v rØ|€|�Ó‰| j        v ra|€|€dn|dk     	                    ¦   «         }|r@| j
        |         }‰‰         j        | j        ‰         j        k    r| j        ‰         j        }
n„‰| j        v r`|€|€dn|dk     	                    ¦   «         }|r@| j        |         }
‰‰         j        | j        ‰         j        k    r| j        ‰         j        }n| j        |         }
| j
        |         }|
€|��k|
€‰‰         j        }nA|€|
}n<t          |
d¬¦  «        }
t          |
j        ¦  «        }t!          j        |
||¬¦  «        }|€‰‰         j        }nA|€|}n<t          |d¬¦  «        }t          |j        ¦  «        }t!          j        |||¬¦  «        }|�7|dk                          ¦   «         rt%          ||j        d¬	¦  «        Š|j        }n¼|�7|dk                          ¦   «         rt%          ||j        d¬	¦  «        Š|j        }nƒt%          ||j        d¬	¦  «        Š|�|dk    }‰                     | |¦  «        Št)          |j        |j        g¦  «        }|j        j        d
k    r"|j        j        d
k    r|j        dk    r‰j        }‰                     ‰¦  «        r"‰                     ‰|‰j        ¬¦  «        ‰‰<   �Œé‰                     ‰¦  «        rlt5          ‰j        t6          ¦  «        r:‰‰_        ˆˆˆfd„‰j        j        D ¦   «         }‰                     |d¬¦  «         �ŒRt%          ‰‰¬¦  «        ‰_        �Œj‰                     |‰pd|› �‰¦  «         �Œˆd S )Nc              3  ó@   K  — | ]}t          |t          ¦  «        V — Œd S rw   )r…   Ú_known©rz   r¨   s     rh   r|   z7_MergeOperation._maybe_add_join_keys.<locals>.<genexpr>  s,   è è € ÐFÐF¨Q•:˜a¥Ñ(Ô(ÐFÐFÐFÐFÐFÐFrj   Tr#  ©NNFéÿÿÿÿ©Úextract_numpy©Ú
fill_value©ÚdtyperV   ÚMÚO)r:  r“   c                óT   •— g | ]$}|‰k    r‰j                              |¦  «        n‰‘Œ%S rn   )r“   Úget_level_values)rz   Ú
level_nameÚkey_colr,  r    s     €€€rh   r�   z8_MergeOperation._maybe_add_join_keys.<locals>.<listcomp>`  sN   ø€ ð $ð $ð $ð !+ð $.°Ò#5Ð#5ð !'¤× =Ò =¸jÑ IÔ IÐ Ià%,ð	$ð $ð $rj   r%  ©r,  Úkey_) rˆ   rÆ   r'  rÃ   rO   rP   Ú	enumerateÚ_should_fillrI   ÚanyrÅ   r:  Ú_valuesrK   r;   r0   ÚalgosÚtake_ndr3   Úwherer   ÚkindÚ_is_label_referenceÚ_constructor_slicedr“   r(  r…   r4   r,  r)  r*  Úinsert)rÙ   r    rê   rì   Úleft_has_missingÚright_has_missingÚkeysr  ÚlnameÚrnameÚ	take_leftÚ
take_rightÚlvalsÚlfillÚrvalsÚtakerÚrfillÚresult_dtypeÚ	mask_leftÚidx_listr@  r,  s    `                  @@rh   r  z$_MergeOperation._maybe_add_join_keysø  s—  øøø€ ð  ÐØ ÐåÐFÐF°$Ô2EÐFÑFÔFÑFÔFÐFÐFÐFå�4”? D¤L°$´-ÈÐMÑMÔMˆÝ'0°¡¤ð h	Bñ h	BÑ#ˆAÑ#��e˜UÝ  uÑ-Ô-ð Øà$.Ñ!ˆI�zà�vˆ~ˆ~ØÐ+¨}Ð/HØ˜tœyÐ(Ð(Ø+Ð3ð $0Ð#7ð !& à&2°bÒ&8×%=Ò%=Ñ%?Ô%?ð -ð ,ð DØ)-Ô)=¸aÔ)@˜Jà% dœ|Ô1°T´Y¸t´_Ô5JÒJÐJØ,0¬I°d¬OÔ,C 	øà ¤Ð+Ð+Ø,Ð4ð $1Ð#8ð !& à&3°rÒ&9×%>Ò%>Ñ%@Ô%@ð .ð -ð FØ(,Ô(;¸AÔ(>˜Ià% dœ|Ô1°T´ZÀÔ5EÔ5KÒKÐKØ-1¬Z¸Ô-=Ô-E 
øð !Ô/°Ô2�	Ø!Ô1°!Ô4�
àÐ$¨
Ñ(>ØÐ$Ø" 4œLÔ0�E�EØ!Ð)Ø%�E�Eõ !.¨iÀtÐ LÑ LÔ L�IÝ.¨y¬Ñ?Ô?�EÝ!œM¨)°\ÈeÐTÑTÔT�EàÐ%Ø" 4œLÔ0�E�EØ"Ð*Ø&�E�Eõ *¨*ÀDÐIÑIÔI�EÝ.¨u¬{Ñ;Ô;�EÝ!œM¨%°È5ÐQÑQÔQ�Eð  Ð+°ÀÒ1C×0HÒ0HÑ0JÔ0JÐ+Ý# E°´À5ÐIÑIÔI�GØ#(¤;�L�LØ"Ð.°MÀRÒ4G×3LÒ3LÑ3NÔ3NÐ.Ý# E°´À5ÐIÑIÔI�GØ#(¤;�L�Lå# E°´À5ÐIÑIÔI�GØ#Ð/Ø$0°BÒ$6˜	Ø")§-¢-°°
¸EÑ"BÔ"B˜Ý#3°U´[À%Ä+Ð4NÑ#OÔ#O�LàœÔ(¨CÒ/Ð/Ø!œKÔ,°Ò3Ð3Ø(Ô-°Ò4Ð4ð (/¤}˜à×-Ò-¨dÑ3Ô3ð BØ#)×#=Ò#=Ø |¸6¼<ð $>ñ $ô $�F˜4‘L‘Lð ×/Ò/°Ñ5Ô5ð BÝ! &¤,µ
Ñ;Ô;ð AØ'+˜œð$ð $ð $ð $ð $ð $ð /5¬lÔ.@ð$ñ $ô $˜ð ×(Ò(¨¸4Ð(Ñ@Ô@Ð@Ñ@å',¨W¸4Ð'@Ñ'@Ô'@˜œ™à—M’M ! TÐ%7¨Z°A¨Z¨Z¸ÑAÔAÐAùðQh	Bð h	Brj   ú?tuple[npt.NDArray[np.intp] | None, npt.NDArray[np.intp] | None]c                ój   — | j         dk    sJ ‚t          | j        | j        | j        | j         ¬¦  «        S )úreturn the join indexersr¾   ©rT   rL   )rL   Úget_join_indexersrÆ   rÅ   rT   r
  s    rh   Ú_get_join_indexersz"_MergeOperation._get_join_indexerso  sA   € ð
 Œx˜6Ò!Ð!Ð!Ð!Ý ØÔ Ô!5¸D¼IÈ4Ì8ð
ñ 
ô 
ð 	
rj   úFtuple[Index, npt.NDArray[np.intp] | None, npt.NDArray[np.intp] | None]c                óF  — | j         j        }| j        j        }| j        r;| j        r4| j        dk    r)|                     || j        d| j        ¬¦  «        \  }}}�n¡| j        r.| j        dk    r#t          ||| j	        | j        ¬¦  «        \  }}}�nl| j        r.| j        dk    r#t          ||| j
        | j        ¬¦  «        \  }}}�n7|                      ¦   «         \  }}| j        r_t          | j         ¦  «        dk    r|                      |||d¬¦  «        }nç|€|                     ¦   «         }nÐ|                     |¦  «        }nº| j        r„| j        dk    r|                      |||d¬¦  «        }nŽt          | j        ¦  «        dk    r|                      |||d¬¦  «        }n\|€|                     ¦   «         }nE|                     |¦  «        }n/|€t          |¦  «        nt          |¦  «        }t!          |¦  «        }| j        r|                      |||¦  «        \  }}}|||fS )	Nr¾   T©rL   Úreturn_indexersrT   rI   ru   rK   r   ©rL   )rI   r“   rK   rQ   rS   rL   r   rT   Ú_left_join_on_indexrÆ   rÅ   rb  r’   Ú_create_join_indexrV   rŒ   r<   rÍ   Ú_handle_anti_join)rÙ   Úleft_axÚright_axré   rê   rì   Úns          rh   r  z_MergeOperation._get_join_infoy  s€  € ð ”)”/ˆØ”:Ô#ˆàŒ?ð 4	.˜tÔ/ð 4	.°D´HÀÒ4FÐ4FØ6=·l²lØ˜dœh¸À4Ä9ð 7Cñ 7ô 7Ñ3ˆJ˜ m¡mð Ôð /	. $¤(¨fÒ"4Ð"4Ý6IØ˜ 4Ô#6¸T¼Yð7ñ 7ô 7Ñ3ˆJ˜ m¡mð Œ_ð *	. ¤¨WÒ!4Ð!4Ý6IØ˜' 4Ô#7¸d¼ið7ñ 7ô 7Ñ3ˆJ˜ |¡|ð -1×,CÒ,CÑ,EÔ,EÑ)ˆ\˜=àÔð #.Ý�t”y‘>”> AÒ%Ð%Ø!%×!8Ò!8ØØ Ø$Ø#ð	 "9ñ "ô "�J�Jð #Ð*Ø!)§¢¡¤�J�Jà!)§¢¨}Ñ!=Ô!=�J�JØ”ð .Ø”8˜vÒ%Ð%à!%×!8Ò!8ØØ Ø$Ø"ð	 "9ñ "ô "�J�Jõ ˜œ‘_”_ qÒ(Ð(Ø!%×!8Ò!8Ø ØØ%Ø"ð	 "9ñ "ô "�J�Jð "Ð)Ø!(§¢¡¤�J�Jà!(§¢¨lÑ!;Ô!;�J�Jà$0Ð$8•C˜‘L”L�L½cÀ,Ñ>OÔ>O�Ý*¨1Ñ-Ô-�
àŒ>ð 	Ø6:×6LÒ6LØ˜L¨-ñ7ô 7Ñ3ˆJ˜ mð ˜<¨Ð6Ð6rj   r“   Úother_indexÚindexerr   c                ó€  — | j         |dfv r‰t          |t          ¦  «        st|dk    }t          j        |¦  «        rZt          |j        d¬¦  «        }|j        st          |g¦  «        }nt          |g|j        ¬¦  «        }| 	                    |¦  «        }|€| 
                    ¦   «         S |                     |¦  «        S )aÝ  
        Create a join index by rearranging one index to match another

        Parameters
        ----------
        index : Index
            index being rearranged
        other_index : Index
            used to supply values not found in index
        indexer : np.ndarray[np.intp] or None
            how to rearrange index
        how : str
            Replacement is only necessary if indexer based on other_index.

        Returns
        -------
        Index
        r¢   r4  F)Úcompat©r:  )rL   r…   r4   ÚnprE  r0   r:  Ú_can_hold_nar3   r”   rV   rŒ   )rÙ   r“   rn  ro  rL   Úmaskr8  Ú	new_indexs           rh   ri  z"_MergeOperation._create_join_index½  s¼   € ð4 Œ8˜˜W�~Ð%Ð%­j¸ÅjÑ.QÔ.QÐ%ð ˜b’=ˆDÝŒv�d‰|Œ|ð 0Ý/°´ÀEÐJÑJÔJ�
ØÔ)ð GÝ % z lÑ 3Ô 3�I�Iå % z l¸%¼+Ð FÑ FÔ F�IØŸš YÑ/Ô/�Øˆ?Ø—:’:‘<”<ÐØ�zŠz˜'Ñ"Ô"Ð"rj   c                ó"  — |€&t          j        t          | j        ¦  «        ¦  «        }|€&t          j        t          | j        ¦  «        ¦  «        }| j        dv sJ ‚| j        dk    r|dk    }n|dk    }||         }||         }||         }|||fS )a¯  
        Handle anti join by returning the correct join index and indexers

        Parameters
        ----------
        join_index : Index
            join index
        left_indexer : np.ndarray[np.intp] or None
            left indexer
        right_indexer : np.ndarray[np.intp] or None
            right indexer

        Returns
        -------
        Index, np.ndarray[np.intp] or None, np.ndarray[np.intp] or None
        N>   rI   rK   rI   r4  )rs  Úaranger’   rI   rK   rL   )rÙ   ré   rê   rì   Úfilts        rh   rj  z!_MergeOperation._handle_anti_joiné  s¢   € ð0 ÐÝœ9¥S¨¬¡^¤^Ñ4Ô4ˆLØÐ ÝœI¥c¨$¬*¡o¤oÑ6Ô6ˆMàŒxÐ,Ð,Ð,Ð,Ð,ØŒ8�vÒÐà  BÒ&ˆDˆDð   2Ò%ˆDØ Ô%ˆ
Ø# DÔ)ˆØ% dÔ+ˆà˜<¨Ð6Ð6rj   úWtuple[list[ArrayLike], list[ArrayLike], list[Hashable], list[Hashable], list[Hashable]]c                óà
  ‡‡— g }g }g }g }g }| j         | j        cŠŠˆfd„}ˆfd„}t          | j        ¦  «        �r¹t          | j        ¦  «        �r¤t          | j        | j        d¬¦  «        D �]„\  }}	t          |d¬¦  «        }t          |	d¬¦  «        }	 ||¦  «        �r
t          t          |¦  «        }| 	                    |¦  «          ||	¦  «        r@t          t          |	¦  «        }	| 	                    |	¦  «         | 	                    d¦  «         Œ©t          t          |	¦  «        }	|	�>| 	                    ‰                     |	¦  «        ¦  «         | 	                    |	¦  «         Œþ| 	                    ‰j        j        ¦  «         | 	                    ‰j        j        ¦  «         �Œ> ||	¦  «        s}t          t          |	¦  «        }	|	�)| 	                    ‰                     |	¦  «        ¦  «         n| 	                    ‰j        j        ¦  «         |�||	k    r| 	                    |	¦  «         n*t          t          |	¦  «        }	| 	                    |	¦  «         |�Tt          t          |¦  «        }| 	                    ‰                     |¦  «        ¦  «         | 	                    |¦  «         �ŒF| 	                    ‰j        j        ¦  «         | 	                    ‰j        j        ¦  «         �Œ†�nut          | j        ¦  «        �r'| j        D ]°}
 ||
¦  «        rQt          |
d¬¦  «        }
t          t          |
¦  «        }
| 	                    |
¦  «         | 	                    d¦  «         Œ^t          t          |
¦  «        }
| 	                    ‰                     |
¦  «        ¦  «         | 	                    |
¦  «         Œ±t          | j        j        t           ¦  «        r<d„ t          | j        j        j        | j        j        j        d¬¦  «        D ¦   «         }�nM| j        j        j        g}�n9t          | j        ¦  «        �r$| j        D ]°}
t          |
d¬¦  «        }
 ||
¦  «        r@t          t          |
¦  «        }
| 	                    |
¦  «         | 	                    d¦  «         Œ^t          t          |
¦  «        }
| 	                    ‰                     |
¦  «        ¦  «         | 	                    |
¦  «         Œ±t          | j         j        t           ¦  «        r;d„ t          | j         j        j        | j         j        j        d¬¦  «        D ¦   «         }n| j         j        j        g}|||||fS )	zj
        Returns
        -------
        left_keys, right_keys, join_names, left_drop, right_drop
        c                ón   •— t          | t          ¦  «        ot          | ¦  «        t          ‰¦  «        k    S rw   ©r…   r1  r’   )r¨   rI   s    €rh   r­   z1_MergeOperation._get_merge_keys.<locals>.<lambda>*  s'   ø€ �J q­&Ñ1Ô1ÐIµc¸!±f´fÅÀDÁ	Ä	Ò6I€ rj   c                ón   •— t          | t          ¦  «        ot          | ¦  «        t          ‰¦  «        k    S rw   r}  )r¨   rK   s    €rh   r­   z1_MergeOperation._get_merge_keys.<locals>.<lambda>+  s'   ø€ �J q­&Ñ1Ô1ÐJµc¸!±f´fÅÀEÁ
Ä
Ò6J€ rj   Tr#  r5  Nc                óH   — g | ]\  }}|j                              |¦  «        ‘Œ S rn   ©rF  rŒ   ©rz   ÚlevÚ	lev_codess      rh   r�   z3_MergeOperation._get_merge_keys.<locals>.<listcomp>u  s<   € ð ð ð á&˜˜Yð ”K×$Ò$ YÑ/Ô/ðð ð rj   c                óH   — g | ]\  }}|j                              |¦  «        ‘Œ S rn   r€  r�  s      rh   r�   z3_MergeOperation._get_merge_keys.<locals>.<listcomp>‹  s<   € ð ð ð á&˜˜Yð ”K×$Ò$ YÑ/Ô/ðð ð rj   )rI   rK   Ú_anyrO   rP   r'  r;   r	   r   r”   r   Ú_get_label_or_level_valuesr“   rF  r,  r…   r4   ÚlevelsÚcodes)rÙ   Ú	left_keysÚ
right_keysrÃ   rÞ   rÝ   Úis_lkeyÚis_rkeyÚlkÚrkÚkrI   rK   s              @@rh   rÓ   z_MergeOperation._get_merge_keys  sx  øø€ ð &(ˆ	Ø&(ˆ
Ø%'ˆ
Ø%'ˆ
Ø$&ˆ	à”i ¤ˆˆˆeàIÐIÐIÐIˆØJÐJÐJÐJˆõ �”ÑÔñ Z	6¥$ t¤}Ñ"5Ô"5ñ Z	6Ý˜dœl¨D¬MÀ$ÐGÑGÔGð -;ñ -;‘��BÝ" 2°TÐ:Ñ:Ô:�Ý" 2°TÐ:Ñ:Ô:�Ø�7˜2‘;”;ñ *;Ý�i¨Ñ,Ô,�BØ×$Ò$ RÑ(Ô(Ð(Ø�w˜r‘{”{ð @Ý!¥)¨RÑ0Ô0˜Ø"×)Ò)¨"Ñ-Ô-Ð-Ø"×)Ò)¨$Ñ/Ô/Ð/Ð/õ "¥(¨BÑ/Ô/˜Ø˜>Ø&×-Ò-¨e×.NÒ.NÈrÑ.RÔ.RÑSÔSÐSØ&×-Ò-¨bÑ1Ô1Ð1Ð1ð '×-Ò-¨e¬kÔ.AÑBÔBÐBØ&×-Ò-¨e¬kÔ.>Ñ?Ô?Ð?Ñ?à"˜7 2™;œ;ð .õ "¥(¨BÑ/Ô/˜Ø˜>Ø&×-Ò-¨e×.NÒ.NÈrÑ.RÔ.RÑSÔSÐSÐSð '×-Ò-¨e¬kÔ.AÑBÔBÐBØ˜>¨b°Bªh¨hØ&×-Ò-¨bÑ1Ô1Ð1øå!¥)¨RÑ0Ô0˜Ø"×)Ò)¨"Ñ-Ô-Ð-Ø�~õ "¥(¨BÑ/Ô/˜Ø!×(Ò(¨×)HÒ)HÈÑ)LÔ)LÑMÔMÐMØ"×)Ò)¨"Ñ-Ô-Ð-Ñ-ð "×(Ò(¨¬Ô);Ñ<Ô<Ð<Ø"×)Ò)¨$¬*¬/Ñ:Ô:Ð:Ñ:ñ[-;õ\ �$”,ÑÔñ +	6Ø”\ð )ð )�Ø�7˜1‘:”:ð 
)Ý% a°tÐ<Ñ<Ô<�AÝ�Y¨Ñ*Ô*�AØ×$Ò$ QÑ'Ô'Ð'Ø×%Ò% dÑ+Ô+Ð+Ð+õ �X qÑ)Ô)�AØ×$Ò$ T×%DÒ%DÀQÑ%GÔ%GÑHÔHÐHØ×%Ò% aÑ(Ô(Ð(Ð(Ý˜$œ*Ô*­JÑ7Ô7ð 8ðð å*-Øœ
Ô(Ô/°´Ô1AÔ1GÐPTð+ñ +ô +ðñ ô �
‘
ð #œjÔ.Ô6Ð7�
‘
Ý�$”-Ñ Ô ñ 	6Ø”]ð )ð )�Ý! !°4Ð8Ñ8Ô8�Ø�7˜1‘:”:ð 	)Ý�Y¨Ñ*Ô*�AØ×%Ò% aÑ(Ô(Ð(Ø×%Ò% dÑ+Ô+Ð+Ð+õ �X qÑ)Ô)�AØ×%Ò% e×&FÒ&FÀqÑ&IÔ&IÑJÔJÐJØ×%Ò% aÑ(Ô(Ð(Ð(Ý˜$œ)œ/­:Ñ6Ô6ð 6ðð å*-Øœ	œÔ.°´	´Ô0EÈdð+ñ +ô +ðñ ô �	�	ð "œYœ_Ô4Ð5�	à˜* j°)¸ZÐGÐGrj   c                ó¤  — t          | j        | j        | j        d¬¦  «        D �]+\  }}}t	          |¦  «        rt	          |¦  «        rt	          |¦  «        st	          |¦  «        rŒDt          |d¬¦  «        }t          |d¬¦  «        }t          |j        t          ¦  «        }t          |j        t          ¦  «        }t          |j        ¦  «        pt          |j        ¦  «        }t          |j        ¦  «        pt          |j        ¦  «        }|rD|rBt          t          |¦  «        }t          t          |¦  «        }|                     |¦  «        r�Œ/n|s|rn|j        |j        k    r�ŒGd|j        › d|j        › d|› d�}t          |j        ¦  «        �r2t          |j        ¦  «        �r|j        j        |j        j        k    r�Œ£t          |j        t           ¦  «        r�t          |j        t           ¦  «        sst#          |j        |j        g¦  «        }	t          |	t           ¦  «        r-|	                     ¦   «         }
|
                     ||	d¬	¦  «        }n¢|                     |	¦  «        }nŒt          |j        t           ¦  «        rrt#          |j        |j        g¦  «        }	t          |	t           ¦  «        r-|	                     ¦   «         }
|
                     ||	d¬	¦  «        }n|                     |	¦  «        }t+          |j        ¦  «        rºt-          |j        ¦  «        r¦t/          j        d
¬¦  «        5  |                     |j        ¦  «        }d d d ¦  «         n# 1 swxY w Y   t/          j        |¦  «         }||k    }||                              ¦   «         s(t7          j        dt:          t=          ¦   «         ¬¦  «         �Œ¤t-          |j        ¦  «        rºt+          |j        ¦  «        r¦t/          j        d
¬¦  «        5  |                     |j        ¦  «        }d d d ¦  «         n# 1 swxY w Y   t/          j        |¦  «         }||k    }||                              ¦   «         s(t7          j        dt:          t=          ¦   «         ¬¦  «         �Œrt?          j         |d¬¦  «        t?          j         |d¬¦  «        k    r�Œ¢�n‹|rtC          |j        ¦  «        stC          |j        ¦  «        r|r�n]|rt          |j        ¦  «        st          |j        ¦  «        ra|r_t?          j         |d¬¦  «        }t?          j         |d¬¦  «        }g d¢}g d¢}||v r||v r�nó||v r||vs||v r||vrtE          |¦  «        ‚�nÒtG          |j        ¦  «        r#tG          |j        ¦  «        stE          |¦  «        ‚tG          |j        ¦  «        s#tG          |j        ¦  «        rtE          |¦  «        ‚t          |j        tH          ¦  «        r)t          |j        tH          ¦  «        stE          |¦  «        ‚t          |j        tH          ¦  «        s)t          |j        tH          ¦  «        rtE          |¦  «        ‚t          |j        tH          ¦  «        rt          |j        tH          ¦  «        s |j        j        dk    r|j        j        dk    r�Œ§|j        j        dk    r|j        j        dk    rtE          |¦  «        ‚|j        j        dk    r|j        j        dk    rtE          |¦  «        ‚t          |j        ¦  «        rt          |j        ¦  «        r�Œ/|| j%        j&        v rp|rt          t          |¦  «        j'        j        ntP          }| j%         )                    d¬¦  «        | _%        | j%        |                              |¦  «        | j%        |<   || j*        j&        v rp|rt          t          |¦  «        j'        j        ntP          }| j*         )                    d¬¦  «        | _*        | j*        |                              |¦  «        | j*        |<   �Œ-d S )NTr#  r5  zYou are trying to merge on ú and z columns for key 'z2'. If you wish to proceed you should use pd.concatFr9  Úignore)ÚinvalidzjYou are merging on int and float columns where the float values are not equal to their int representation.)Ú
stacklevel)Úskipna)Úintegerzmixed-integerÚbooleanÚempty)ÚstringÚunicodeÚmixedÚbytesr˜  r;  Úmr  )+r'  rÆ   rÅ   rÃ   r’   r;   r…   r:  r+   r(   r)   r	   r2   Ú#_categories_match_up_to_permutationr'   rJ  r   r   Úconstruct_array_typeÚ_from_sequencer  r$   r"   rs  ÚerrstateÚisnanrˆ   ÚwarningsÚwarnÚUserWarningr   r   Úinfer_dtyper!   r°   r*   r,   rI   ry   r  ÚobjectrV   rK   )rÙ   r�  rŽ  r,  Ú	lk_is_catÚ	rk_is_catÚlk_is_object_or_stringÚrk_is_object_or_stringrÜ   ÚctÚcom_clsÚcastedru  ÚmatchÚinferred_leftÚinferred_rightÚ
bool_typesÚstring_typesÚtyps                      rh   r×   z(_MergeOperation._maybe_coerce_merge_keys–  sØ  € õ  ØÔ Ô!5°t´Ètð
ñ 
ô 
ð y	@ñ y	@‰LˆB��Dõ �B‘”ð ¥ B¡¤ð µ°R±´ð ½SÀ¹W¼Wð Øå˜r°Ð6Ñ6Ô6ˆBÝ˜r°Ð6Ñ6Ô6ˆBå" 2¤8Õ-=Ñ>Ô>ˆIÝ" 2¤8Õ-=Ñ>Ô>ˆIÝ%4°R´XÑ%>Ô%>ð &Å/Ø”ñCô CÐ"õ &5°R´XÑ%>Ô%>ð &Å/Ø”ñCô CÐ"ð ð 
˜Yð 
Ý�+ rÑ*Ô*�Ý�+ rÑ*Ô*�Ø×9Ò9¸"Ñ=Ô=ð Ùðð ð ˜ið Øà”˜RœXÒ%Ð%ÙðU¨b¬hð Uð U¸R¼Xð Uð UØ ðUð Uð Uð õ   ¤Ñ)Ô)ñ @Õ.>¸r¼xÑ.HÔ.Hñ @Ø”8”= B¤H¤MÒ1Ð1Ùå˜bœh­Ñ7Ô7ð +Å
Ø”H�nñAô Að +õ *¨2¬8°R´XÐ*>Ñ?Ô?�BÝ! "¥nÑ5Ô5ð +Ø"$×"9Ò"9Ñ";Ô";˜Ø$×3Ò3°B¸bÀuÐ3ÑMÔM˜˜àŸYšY r™]œ]˜˜Ý ¤­.Ñ9Ô9ð +Ý)¨2¬8°R´XÐ*>Ñ?Ô?�BÝ! "¥nÑ5Ô5ð +Ø"$×"9Ò"9Ñ";Ô";˜Ø$×3Ò3°B¸bÀuÐ3ÑMÔM˜˜àŸYšY r™]œ]˜õ $ B¤HÑ-Ô-ð µ.ÀÄÑ2JÔ2Jð åœ¨XÐ6Ñ6Ô6ð 5ð 5ð "$§¢¨2¬8Ñ!4Ô!4˜ð	5ð 5ð 5ñ 5ô 5ð 5ð 5ð 5ð 5ð 5ð 5øøøð 5ð 5ð 5ð 5õ œH R™LœL˜=�DØ &šL�Eð ! œ;Ÿ?š?Ñ,Ô,ð Ý œðIõ (Ý'7Ñ'9Ô'9ðñ ô ð ñ å! "¤(Ñ+Ô+ð Õ0@ÀÄÑ0JÔ0Jð åœ¨XÐ6Ñ6Ô6ð 5ð 5ð "$§¢¨2¬8Ñ!4Ô!4˜ð	5ð 5ð 5ñ 5ô 5ð 5ð 5ð 5ð 5ð 5ð 5øøøð 5ð 5ð 5ð 5õ œH R™LœL˜=�DØ &šL�Eð ! œ;Ÿ?š?Ñ,Ô,ð Ý œðIõ (Ý'7Ñ'9Ô'9ðñ ô ð ñ õ ”? 2¨eÐ4Ñ4Ô4½¼Ø˜uð9ñ 9ô 9ò ð ñ ñð )ð 4­]¸2¼8Ñ-DÔ-Dð 4Ý˜bœhÑ'Ô'ð4Ø,Bð4ñ ð )ð .Õ-=¸b¼hÑ-GÔ-Gð .Ý  ¤Ñ*Ô*ð.Ø/Eð.õ !$¤°¸5Ð AÑ AÔ A�Ý!$¤°¸EÐ!BÑ!BÔ!B�ØMÐMÐM�
ØOÐOÐO�ð ! JÐ.Ð.°>ÀZÐ3OÐ3OÙð " \Ð1Ð1°nÈLÐ6XÐ6Xà" lÐ2Ð2°}ÈLÐ7XÐ7Xå$ S™/œ/Ð)ùõ % R¤XÑ.Ô.ð Õ7JÈ2Ì8Ñ7TÔ7Tð Ý  ‘o”oÐ%Ý(¨¬Ñ2Ô2ð Õ7JÈ2Ì8Ñ7TÔ7Tð Ý  ‘o”oÐ%Ý˜BœH¥oÑ6Ô6ð ½zØ”�/ñ@ô @ð õ ! ‘o”oÐ%Ý ¤­/Ñ:Ô:ð ½zØ”�/ñ@ô @ð õ ! ‘o”oÐ%å˜2œ8¥_Ñ5Ô5ðå˜rœx­Ñ9Ô9ðð ”(”- 3Ò&Ð&¨2¬8¬=¸CÒ+?Ð+?áà”” #Ò%Ð%¨"¬(¬-¸3Ò*>Ð*>Ý  ‘o”oÐ%Ø”” #Ò%Ð%¨"¬(¬-¸3Ò*>Ð*>Ý  ‘o”oÐ%å  ¤Ñ*Ô*ð ­¸r¼xÑ/HÔ/Hð Ùð �t”yÔ(Ð(Ð(Ø@IÐU•d�;¨Ñ+Ô+Ô6Ô<Ð<Ív�Ø œIŸNšN°˜NÑ6Ô6�”	Ø"&¤)¨D¤/×"8Ò"8¸Ñ"=Ô"=�”	˜$‘Ø�t”zÔ)Ð)Ð)Ø@IÐU•d�;¨Ñ+Ô+Ô6Ô<Ð<Ív�Ø!œZŸ_š_°%˜_Ñ8Ô8�”
Ø#'¤:¨dÔ#3×#:Ò#:¸3Ñ#?Ô#?�”
˜4Ñ ùðsy	@ð y	@s$   Ì6MÍM!	Í$M!	ÐP+Ð+P/	Ð2P/	c           
     ód  — t          j        |¦  «        }t          j        |¦  «        }| j        €ú|€ø|€ö| j        r| j        rd\  }}�n6| j        rt          d¦  «        ‚| j        rt          d¦  «        ‚| j        j        }| j        j        }| 	                    |¦  «        }t          |¦  «        dk    r%t          d|› d|› d| j        › d| j        › �¦  «        ‚|                     |d	¬
¦  «        j        r|                     |d	¬
¦  «        j        st          d|›�¦  «        ‚|x}}�nU| j        �;|€|�t          d¦  «        ‚| j        s| j        rt          d¦  «        ‚| j        x}}�n|�”| j        rt          d¦  «        ‚| j        s|€t          d¦  «        ‚| j        r|�t          d¦  «        ‚t          |¦  «        }| j        r7t          |¦  «        | j        j        j        k    rt          d¦  «        ‚d g|z  }n}|�{| j        rt          d¦  «        ‚| j        s|€t          d¦  «        ‚t          |¦  «        }| j        r7t          |¦  «        | j        j        j        k    rt          d¦  «        ‚d g|z  }t          |¦  «        t          |¦  «        k    rt          d¦  «        ‚||fS )N)rn   rn   z&Must pass right_on or right_index=Truez$Must pass left_on or left_index=Truer   z>No common columns to perform merge on. Merge options: left_on=z, right_on=z, left_index=z, right_index=rE   rg  zData columns not unique: zSCan only pass argument "on" OR "left_on" and "right_on", not a combination of both.zYCan only pass argument "on" OR "left_index" and "right_index", not a combination of both.z:Can only pass argument "left_on" OR "left_index" not both.z&Must pass "right_on" OR "right_index".z<Can only pass argument "right_on" OR "right_index" not both.zDlen(left_on) must equal the number of levels in the index of "right"z$Must pass "left_on" OR "left_index".zDlen(right_on) must equal the number of levels in the index of "left"z%len(right_on) must equal len(left_on))rÎ   rÏ   rM   rQ   rS   r   rI   ry   rK   Úintersectionr’   r   Ú	is_uniquer“   rÑ   r°   )rÙ   rO   rP   Ú	left_colsÚ
right_colsÚcommon_colsrm  s          rh   rÒ   z'_MergeOperation._validate_left_right_onY  si  € ÝÔ% gÑ.Ô.ˆÝÔ& xÑ0Ô0ˆð Œ7ˆ?˜w˜°8Ð3CØŒð 1 4Ô#3ð 1Ø$*Ñ!�˜™Ø”ð 1Ý Ð!IÑJÔJÐJØÔ!ð 1Ý Ð!GÑHÔHÐHð !œIÔ-�	Ø!œZÔ/�
Ø'×4Ò4°ZÑ@Ô@�Ý�{Ñ#Ô# qÒ(Ð(Ý$ð:Ø29ð:ð :à$,ð:ð :ð '+¤oð:ð :ð (,Ô'7ð	:ð :ñô ð ð "Ÿš {¸˜Ñ@Ô@ÔJðRà%Ÿ?š?¨;¸G˜?ÑDÔDÔNðRõ %Ð%PÀÐ%PÐ%PÑQÔQÐQØ%0Ð0�˜(™(ØŒWÐ ØÐ" hÐ&:Ý ðAñô ð ð Œð  $Ô"2ð Ý ðDñô ð ð "&¤Ð(ˆG�h‘hØÐ ØŒð Ý ØPñô ð ð Ô#ð K¨Ð(8Ý Ð!IÑJÔJÐJØÔð  HÐ$8Ý ØRñô ð õ �G‘”ˆAØÔð &Ý�w‘<”< 4¤:Ô#3Ô#;Ò;Ð;Ý$ð<ñô ð ð !˜6 A™:�øØÐ!ØÔð Ý ØRñô ð ð ”?ð I w Ý Ð!GÑHÔHÐHÝ�H‘”ˆAØŒð %Ý�x‘=”= D¤I¤OÔ$;Ò;Ð;Ý$ð;ñô ð ð  ˜& 1™*�Ýˆx‰=Œ=�C ™LœLÒ(Ð(ÝÐDÑEÔEÐEà˜Ð Ð rj   r±   c                ó®  ‡ — ‰ j         r‰ j        j        }|j        }n t	          j        ‰ j        ¦  «        }|j        }‰ j        r‰ j        j        }‰ j        j        j        }n t	          j        ‰ j	        ¦  «        }|j        }dˆ fd„}dˆ fd„}|dv rf|s(|s&t          d ||¦  «        ›  ||¦  «        › �¦  «        ‚|st          d	 ||¦  «        › �¦  «        ‚|st          d
 ||¦  «        › �¦  «        ‚d S |dv r|st          d ||¦  «        › �¦  «        ‚d S |dv r|st          d ||¦  «        › �¦  «        ‚d S |dv rd S t          d|› d�¦  «        ‚)Nr¨   r3   r\   r±   c                óØ   •— ‰j         s‰j        nt          j        }| |                      ¦   «                  d d…                              |¬¦  «                             d¬¦  «        }d|› d�S )Né   rA  F©r“   z
Duplicates in left:
 ú ...)rQ   rO   r   Ú
no_defaultÚ
duplicatedÚto_frameÚ	to_string©r¨   r,  rÜ   rÙ   s      €rh   Úleft_error_msgz>_MergeOperation._validate_validate_kwd.<locals>.left_error_msg¼  se   ø€ Ø'+¤ÐJ�4”<�<½C¼NˆDØ�A—L’L‘N”NÔ# B Q BÔ'×0Ò0°dÐ0Ñ;Ô;×EÒEÈEÐEÑRÔRˆCØ7¨cÐ7Ð7Ð7Ð7rj   c                óØ   •— ‰j         s‰j        nt          j        }| |                      ¦   «                  d d…                              |¬¦  «                             d¬¦  «        }d|› d�S )Nr½  rA  Fr¾  z
Duplicates in right:
 r¿  )rS   rP   r   rÀ  rÁ  rÂ  rÃ  rÄ  s      €rh   Úright_error_msgz?_MergeOperation._validate_validate_kwd.<locals>.right_error_msgÁ  sf   ø€ Ø(,Ô(8ÐL�4”=�=½c¼nˆDØ�A—L’L‘N”NÔ# B Q BÔ'×0Ò0°dÐ0Ñ;Ô;×EÒEÈEÐEÑRÔRˆCØ8¨sÐ8Ð8Ð8Ð8rj   )Ú
one_to_onez1:1zRMerge keys are not unique in either left or right dataset; not a one-to-one merge.zAMerge keys are not unique in left dataset; not a one-to-one mergezBMerge keys are not unique in right dataset; not a one-to-one merge)Úone_to_manyz1:mzBMerge keys are not unique in left dataset; not a one-to-many merge)Úmany_to_onezm:1zDMerge keys are not unique in right dataset; not a many-to-one merge
)Úmany_to_manyzm:mú"z�" is not a valid argument. Valid arguments are:
- "1:1"
- "1:m"
- "m:1"
- "m:m"
- "one_to_one"
- "one_to_many"
- "many_to_one"
- "many_to_many")r¨   r3   r\   r±   )rQ   rÊ   r“   r·  r4   Úfrom_arraysrÆ   rS   rË   rÅ   r   r°   )rÙ   rZ   Úleft_join_indexÚleft_uniqueÚright_join_indexÚright_uniquerÅ  rÇ  s   `       rh   rØ   z&_MergeOperation._validate_validate_kwd«  sp  ø€ ð Œ?ð 	4Ø"œnÔ2ˆOØ)Ô3ˆKˆKå(Ô4°TÔ5HÑIÔIˆOØ)Ô3ˆKàÔð 	6Ø#œÔ4ÐØœ?Ô0Ô:ˆLˆLå)Ô5°dÔ6JÑKÔKÐØ+Ô5ˆLð	8ð 	8ð 	8ð 	8ð 	8ð 	8ð
	9ð 	9ð 	9ð 	9ð 	9ð 	9ð Ð,Ð,Ð,Øð  |ð Ý ð;à%�~ oÑ6Ô6ð;ð '�Ð'7Ñ8Ô8ð;ð ;ñô ð ð ð Ý ð9Ø%�~ oÑ6Ô6ð9ð 9ñô ð ð  ð Ý ð;Ø&�Ð'7Ñ8Ô8ð;ð ;ñô ð ðð ð Ð/Ð/Ð/Øð Ý ð9Ø%�~ oÑ6Ô6ð9ð 9ñô ð ðð ð Ð/Ð/Ð/Øð Ý ð;à&�Ð'7Ñ8Ô8ð;ð ;ñô ð ðð ð Ð0Ð0Ð0ØˆDõ ð	#�Hð 	#ð 	#ð 	#ñô ð rj   )
rE   NNNFFTrF   FN)rI   rJ   rK   rJ   rL   rÇ   rM   rN   rO   rN   rP   rN   rQ   rR   rS   rR   rT   rR   rU   r   rX   rY   rZ   r[   r\   rÈ   )rL   rÇ   r\   rà   ©rÆ   rÄ   rÅ   rÄ   r\   rÈ   ©rÆ   rÄ   r\   rÈ   )ré   r3   rê   rë   rì   rë   r\   r?   r¯   )r\   r[   )rI   r?   rK   r?   r\   r  )r    r?   r\   r?   )r    r?   r\   rÈ   )r    r?   rê   rë   rì   rë   r\   rÈ   )r\   r]  )r\   rc  )rI   )
r“   r3   rn  r3   ro  rë   rL   r   r\   r3   )ré   r3   rê   rë   rì   rë   r\   rc  )r\   rz  )r\   rÈ   )rZ   r±   r\   rÈ   )Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú_merge_typeÚ__annotations__rß   r
   rÌ   rÕ   rÖ   rü   rd   r   r  r   r  r  r  rb  r  ri  rj  rÓ   r×   rÒ   rØ   rn   rj   rh   rc   rc   ª  sE  € € € € € € ðð ð
 €KØ"Ð"Ð"Ñ"ØÐÐÑð /Ð.Ð.Ñ.Ø/Ð/Ð/Ñ/ØÐÐÑØÐÐÑØ€J€J�JØÐÐÑØÐÐÑØÐÐÑØÐÐÑØ$Ð$Ð$Ñ$Ø#Ð#Ð#Ñ#ð ELØ/3Ø48Ø59Ø Ø!ØØ)Ø %Ø#ðL2ð L2ð L2ð L2ð L2ð\ ðð ð ñ „Uðð<ð ð ð ðð ð ð ð ð3ð 3ð 3ñ „Uð3ðj
ð 
ð 
ð 
ð2 Øðð ð ñ „^ñ „Uðð ð ð  ð  ñ „Uð ðD ðð ð ñ „Uðð* ð)=ð )=ð )=ñ „Uð)=ðV ðtBð tBð tBñ „UðtBðl
ð 
ð 
ð 
ð ðA7ð A7ð A7ñ „UðA7ðF ð ð)#ð )#ð )#ð )#ñ „Uð)#ðV ð'7ð '7ð '7ñ „Uð'7ðR ð@Hð @Hð @Hñ „Uð@HðD ð@@ð @@ð @@ñ „Uð@@ðDP!ð P!ð P!ðd ðLð Lð Lñ „UðLð Lð Lrj   rc   r‰  rÄ   rŠ  r]  c                ó  ‡ ‡‡— t          ‰ ¦  «        t          ‰¦  «        k    s
J d¦   «         ‚t          ‰ d         ¦  «        }t          ‰d         ¦  «        }|dk    r)|dv rt          ¦   «         S ‰s|dv rt          |d¦  «        S n.|dk    r(|dv rt          ¦   «         S ‰s|dv rt          |d¦  «        S t          ‰ ¦  «        d	k    riˆ ˆˆfd
„t          t          ‰ ¦  «        ¦  «        D ¦   «         }t	          |ddiŽ}d„ |D ¦   «         \  }}	}
t          ||	t          |
¦  «        ‰¦  «        \  }}n‰ d         }‰d         }t          |d¬¦  «        }t          |d¬¦  «        }|j        r3|j        r,|j	        s|j	        r| 
                    ||d‰¬¦  «        \  }}}nt          |j        |j        ‰|¦  «        \  }}|�t          |t          |¦  «        ¦  «        rd}|�t          |t          |¦  «        ¦  «        rd}||fS )aŸ  

    Parameters
    ----------
    left_keys : list[ndarray, ExtensionArray, Index, Series]
    right_keys : list[ndarray, ExtensionArray, Index, Series]
    sort : bool, default False
    how : {'inner', 'outer', 'left', 'right'}, default 'inner'

    Returns
    -------
    np.ndarray[np.intp] or None
        Indexer into the left_keys.
    np.ndarray[np.intp] or None
        Indexer into the right_keys.
    z0left_keys and right_keys must be the same lengthr   )rI   rE   )rK   r¢   T)rK   rE   )rI   r¢   Frm   c              3  óT   •K  — | ]"}t          ‰|         ‰|         ‰¬ ¦  «        V — Œ#dS ©ru   N©Ú_factorize_keys)rz   rm  r‰  rŠ  rT   s     €€€rh   r|   z$get_join_indexers.<locals>.<genexpr>'  sN   øè è € ð 
ð 
àõ ˜I aœL¨*°Q¬-¸dÐCÑCÔCð
ð 
ð 
ð 
ð 
ð 
rj   r$  c              3  ó4   K  — | ]}t          |¦  «        V — Œd S rw   ©r†   r2  s     rh   r|   z$get_join_indexers.<locals>.<genexpr>,  ó(   è è € Ð5Ð5¨�T !™WœWÐ5Ð5Ð5Ð5Ð5Ð5rj   ©rV   re  N)r’   Ú_get_empty_indexerÚ _get_no_sort_one_missing_indexerr‘   r'  Ú_get_join_keysr‡   r3   Úis_monotonic_increasingr·  r   Úget_join_indexers_non_uniquerF  r   )r‰  rŠ  rT   rL   Úleft_nÚright_nÚmappedÚzippedÚllabÚrlabÚshapeÚlkeyÚrkeyrI   rK   r¶   ÚlidxÚridxs   ```               rh   ra  ra  û  sw  øøø€ õ, ˆy‰>Œ>�S ™_œ_Ò,Ð,Ð,Ø:ñ -Ô,Ð,õ
 �˜1”ÑÔ€FÝ�*˜Q”-Ñ Ô €GØ�‚{€{ØÐ#Ð#Ð#Ý%Ñ'Ô'Ð'Øð 	C˜#Ð!3Ð3Ð3Ý3°G¸TÑBÔBÐBøØ	�AŠˆØÐ$Ð$Ð$Ý%Ñ'Ô'Ð'Øð 	C˜#Ð!2Ð2Ð2Ý3°F¸EÑBÔBÐBõ ˆ9�~„~˜ÒÐð
ð 
ð 
ð 
ð 
ð 
å�3˜y™>œ>Ñ*Ô*ð
ñ 
ô 
ˆõ �fÐ* TÐ*Ð*ˆØ5Ð5¨fÐ5Ñ5Ô5Ñˆˆd�Eõ $ D¨$µ°e±´¸dÑCÔC‰
ˆˆdˆdà˜Œ|ˆØ˜!Œ}ˆå�˜EÐ"Ñ"Ô"€DÝ�$˜UÐ#Ñ#Ô#€Eð 	Ô$ð	
àÔ)ð	
ð Œ^ð	
ð  %œð	
ð
 Ÿ	š	 %¨SÀ$ÈT˜	ÑRÔR‰ˆˆ4��å1ØŒL˜%œ-¨¨sñ
ô 
‰
ˆˆdð ÐÕ,¨Tµ3°t±9´9Ñ=Ô=ÐØˆØÐÕ,¨Tµ3°u±:´:Ñ>Ô>ÐØˆØ�ˆ:Ðrj   r   ú1tuple[npt.NDArray[np.intp], npt.NDArray[np.intp]]c                óV  — t          | |||¬¦  «        \  }}}|dk    r||fS |dk    rt          j        ||||¬¦  «        \  }}nc|dk    rt          j        ||||¬¦  «        \  }}nA|dk    rt          j        ||||¬¦  «        \  }}n|dk    rt          j        |||¦  «        \  }}||fS )aW  
    Get join indexers for left and right.

    Parameters
    ----------
    left : ArrayLike
    right : ArrayLike
    sort : bool, default False
    how : {'inner', 'outer', 'left', 'right'}, default 'inner'

    Returns
    -------
    np.ndarray[np.intp]
        Indexer into left.
    np.ndarray[np.intp]
        Indexer into right.
    r`  r4  rI   ru   rK   rE   r¢   )rÞ  ÚlibjoinÚleft_outer_joinÚ
inner_joinÚfull_outer_join)	rI   rK   rT   rL   rï  rð  Úcountrñ  rò  s	            rh   rç  rç  I  s×   € õ. (¨¨e¸$ÀCÐHÑHÔHÑ€Dˆ$�Ø�‚{€{à�TˆzÐØ
ˆf‚}€}ÝÔ,¨T°4¸ÀTÐJÑJÔJ‰
ˆˆdˆdØ	�ŠˆÝÔ,¨T°4¸ÀTÐJÑJÔJ‰
ˆˆdˆdØ	�ŠˆÝÔ'¨¨d°EÀÐEÑEÔE‰
ˆˆdˆdØ	�ŠˆÝÔ,¨T°4¸Ñ?Ô?‰
ˆˆdØ�ˆ:Ðrj   r4   ré   r3   Úlindexerúnpt.NDArray[np.intp]Úrindexerú)tuple[FrozenList, FrozenList, FrozenList]c                óF  — d	d„} ||¦  «        }|j         }|j        }|j        }	|D ]v}
|
| j        v r| }|}n|}|}|j                             |
¦  «        }|j         |         }|j        |         }|€|}nt	          j        ||d¬¦  «        }||gz   }||gz   }|	|
gz   }	Œw|||	fS )
aø  
    *this is an internal non-public method*

    Returns the levels, labels and names of a multi-index to multi-index join.
    Depending on the type of join, this method restores the appropriate
    dropped levels of the joined multi-index.
    The method relies on lindexer, rindexer which hold the index positions of
    left and right, where a join was feasible

    Parameters
    ----------
    left : MultiIndex
        left index
    right : MultiIndex
        right index
    dropped_level_names : str array
        list of non-common level names
    join_index : Index
        the index of the join between the
        common levels of left and right
    lindexer : np.ndarray[np.intp]
        left indexer
    rindexer : np.ndarray[np.intp]
        right indexer

    Returns
    -------
    levels : list of Index
        levels of combined multiindexes
    labels : np.ndarray[np.intp]
        labels of combined multiindexes
    names : List[Hashable]
        names of combined multiindex levels

    r“   r3   r\   r4   c                ót   — t          | t          ¦  «        r| S t          j        | j        g| j        g¬¦  «        S )N)r)  )r…   r4   rÍ  rF  r,  r¾  s    rh   Ú_convert_to_multiindexz@restore_dropped_levels_multijoin.<locals>._convert_to_multiindex›  s8   € Ý�e�ZÑ(Ô(ð 	OØˆLåÔ)¨5¬=¨/À%Ä*ÀÐNÑNÔNÐNrj   Nr4  r7  )r“   r3   r\   r4   )r‡  rˆ  r)  r“   rG  rH  )rI   rK   Údropped_level_namesré   rú  rü  r   Újoin_levelsÚ
join_codesrÃ   Údropped_level_nameÚidxro  Úname_idxÚrestore_levelsrˆ  Úrestore_codess                    rh   Ú restore_dropped_levels_multijoinr	  o  s  € ðXOð Oð Oð Oð (Ð'¨
Ñ3Ô3€JàÔ#€KØÔ!€JØÔ!€Jð 2ð 7ð 7ÐØ ¤Ð+Ð+ØˆCØˆGˆGàˆCØˆGð ”9—?’?Ð#5Ñ6Ô6ˆàœ HÔ-ˆð ”	˜(Ô#ˆØˆ?Ø!ˆMˆMå!œM¨%°ÀRÐHÑHÔHˆMð " ^Ð$4Ñ4ˆØ = /Ñ1ˆ
ØÐ#5Ð"6Ñ6ˆ
ˆ
à˜
 JÐ.Ð.rj   c                  ó4   — e Zd ZdZ	 	 	 	 	 	 	 	 ddd„Zdd„ZdS )r§   Úordered_mergeNFrF   r¢   rI   rJ   rK   rM   r£   rO   rP   rQ   rR   rS   rU   r   r¤   r[   rL   rÂ   r\   rÈ   c                ó^   — |	| _         t                               | ||||||||
|d¬¦  «         d S )NT)rM   rO   rQ   rS   rP   rL   rU   rT   )r¤   rc   rß   )rÙ   rI   rK   rM   rO   rP   rQ   rS   rU   r¤   rL   s              rh   rß   z_OrderedMerge.__init__Ë  sT   € ð 'ˆÔÝ× Ò ØØØØØØ!Ø#ØØØØð 	!ñ 	
ô 	
ð 	
ð 	
ð 	
rj   r?   c                óD  — |                       ¦   «         \  }}}| j        dk    r3|€d }nt          j        |¦  «        }|€d }n0t          j        |¦  «        }n| j        €|}|}nt	          d¦  «        ‚|                      |||¦  «        }|                      |||¦  «         |S )NÚffillz#fill_method must be 'ffill' or None)r  r¤   rõ  Úffill_indexerr°   rü   r  )rÙ   ré   rê   rì   Úleft_join_indexerÚright_join_indexerr    s          rh   rd   z_OrderedMerge.get_resultç  sÑ   € Ø26×2EÒ2EÑ2GÔ2GÑ/ˆ
�L -ð
 Ô˜wÒ&Ð&ØÐ#Ø$(Ð!Ð!å$+Ô$9¸,Ñ$GÔ$GÐ!ØÐ$Ø%)Ð"Ð"å%,Ô%:¸=Ñ%IÔ%IÐ"Ð"ØÔÐ%Ø ,ÐØ!.ÐÐåÐBÑCÔCÐCà×)Ò)ØÐ)Ð+=ñ
ô 
ˆð 	×!Ò! &¨,¸ÑFÔFÐFàˆrj   )NNNFFrF   Nr¢   )rI   rJ   rK   rJ   rM   r£   rO   r£   rP   r£   rQ   rR   rS   rR   rU   r   r¤   r[   rL   rÂ   r\   rÈ   r¯   )rÔ  rÕ  rÖ  rØ  rß   rd   rn   rj   rh   r§   r§   È  s`   € € € € € Ø!€Kð !%Ø%)Ø&*Ø Ø!Ø)Ø"&Ø)0ð
ð 
ð 
ð 
ð 
ð8ð ð ð ð ð rj   r§   c                ó:   — d| › d�}t          t          |d ¦  «        S )NÚ
asof_join_Ú
_on_X_by_Y)Úgetattrrõ  )r¼   r,  s     rh   Ú_asof_by_functionr  	  s$   € Ø-˜	Ð-Ð-Ð-€DÝ•7˜D $Ñ'Ô'Ð'rj   c                  óf   ‡ — e Zd ZdZ	 	 	 	 	 	 	 	 	 	 	 	 	 d)d*d„Zˆ fd„Zd+d „Zd,d!„Zd-d&„Zd.d(„Z	ˆ xZ
S )/r¿   Ú
asof_mergeNFrF   r¾   Tr¸   rI   rJ   rK   rM   r£   rO   rP   rQ   rR   rS   rU   r   rL   úLiteral['asof']r»   r¼   r±   r\   rÈ   c                ó>  — || _         |	| _        |
| _        || _        || _        || _        | j        dvrt          d| j        › �¦  «        ‚t          | j        ¦  «        sd| j        › �}t          |¦  «        ‚t           	                    | |||||||||d ¬¦  «         d S )N)r¸   ÚforwardÚnearestzdirection invalid: z,allow_exact_matches must be boolean, passed )rM   rO   rP   rQ   rS   rL   rU   r¤   )
r–   r³   r´   r¹   r»   r¼   r   r    r§   rß   )rÙ   rI   rK   rM   rO   rP   rQ   rS   r–   r³   r´   rU   rL   r¹   r»   r¼   rÜ   s                    rh   rß   z_AsOfMerge.__init__	  sÝ   € ð$ ˆŒØˆŒØ ˆŒØ"ˆŒØ#6ˆÔ Ø"ˆŒð Œ>Ð!CÐCÐCÝÐC°4´>ÐCÐCÑDÔDÐDõ �tÔ/Ñ0Ô0ð 	"ð5ØÔ2ð5ð 5ð õ ˜S‘/”/Ð!å×ÒØØØØØØØ!Ø#ØØØð 	ñ 	
ô 	
ð 	
ð 	
ð 	
rj   c                óÜ  •— t          ¦   «                              ||¦  «        \  }}t          |¦  «        dk    r| j        st	          d¦  «        ‚t          |¦  «        dk    r| j        st	          d¦  «        ‚| j        r.t          | j        j        t          ¦  «        rt	          d¦  «        ‚| j        r.t          | j
        j        t          ¦  «        rt	          d¦  «        ‚| j        �0| j        €| j        �t	          d¦  «        ‚| j        x| _        | _        | j        €| j        �t	          d¦  «        ‚| j        �| j        €t	          d¦  «        ‚| j        sr|d	         }t          |t          ¦  «        r|j        }n^|| j        j        v r| j                             |¦  «        j        n| j        j                             |¦  «        }n| j        j        j        }| j        sr|d	         }t          |t          ¦  «        r|j        }n^|| j
        j        v r| j
                             |¦  «        j        n| j
        j                             |¦  «        }n| j
        j        j        }t'          |¦  «        s-t'          |¦  «        st)          |¦  «        st)          |¦  «        rt	          d
|›d|›d�¦  «        ‚| j        �©t+          | j        ¦  «        s| j        g| _        t+          | j        ¦  «        s| j        g| _        t          | j        ¦  «        t          | j        ¦  «        k    rt	          d¦  «        ‚| j        t-          |¦  «        z   }| j        t-          |¦  «        z   }||fS )Nrm   zcan only asof on a key for leftz can only asof on a key for rightzleft can only have one indexzright can only have one indexz(Can only pass by OR left_by and right_byzmissing left_byzmissing right_byr   zIncompatible merge dtype, r‘  z$, both sides must have numeric dtypez,left_by and right_by must be the same length)ÚsuperrÒ   r’   rQ   r   rS   r…   rI   r“   r4   rK   r–   r³   r´   r1  r:  ry   r†  r>  r(   r)   r%   r†   )rÙ   rO   rP   Ú	left_on_0Úlo_dtypeÚ
right_on_0Úro_dtypeÚ	__class__s          €rh   rÒ   z"_AsOfMerge._validate_left_right_on?	  sx  ø€ Ý!™GœG×;Ò;¸GÀXÑNÔNÑˆ�õ ˆw‰<Œ<˜1ÒÐ T¤_ÐÝÐ>Ñ?Ô?Ð?åˆx‰=Œ=˜AÒÐ dÔ&6ÐÝÐ?Ñ@Ô@Ð@àŒ?ð 	=�z¨$¬)¬/½:ÑFÔFð 	=ÝÐ;Ñ<Ô<Ð<àÔð 	>¥
¨4¬:Ô+;½ZÑ HÔ Hð 	>ÝÐ<Ñ=Ô=Ð=ð Œ7ÐØŒ|Ð'¨4¬=Ð+DÝ Ð!KÑLÔLÐLØ+/¬7Ð2ˆDŒL˜4œ=ØŒ<Ð D¤MÐ$=ÝÐ.Ñ/Ô/Ð/ØŒ<Ð#¨¬Ð(=ÝÐ/Ñ0Ô0Ð0ð Œð 	-Ø œ
ˆIÝ˜)¥VÑ,Ô,ð Ø$œ?��ð ! D¤IÔ$5Ð5Ð5ð ”I×8Ò8¸ÑCÔCÔIÐIàœœ×9Ò9¸)ÑDÔDð �ð ”y”Ô,ˆHàÔð 	.Ø! !œˆJÝ˜*¥fÑ-Ô-ð Ø%Ô+��ð " T¤ZÔ%7Ð7Ð7ð ”J×9Ò9¸*ÑEÔEÔKÐKàœÔ)×:Ò:¸:ÑFÔFð �ð ”zÔ'Ô-ˆHõ ˜HÑ%Ô%ð		å˜xÑ(Ô(ð		õ ˜xÑ(Ô(ð		õ ˜xÑ(Ô(ð			õ ðD¨Xð Dð DØðDð Dð Dñô ð ð Œ<Ð#Ý ¤Ñ-Ô-ð .Ø $¤˜~�”Ý ¤Ñ.Ô.ð 0Ø!%¤ �”å�4”<Ñ Ô ¥C¨¬Ñ$6Ô$6Ò6Ð6Ý Ð!OÑPÔPÐPà”l¥T¨'¡]¤]Ñ2ˆGØ”}¥t¨H¡~¤~Ñ5ˆHà˜Ð Ð rj   rÆ   rÄ   rÅ   c                ó  — dd„}t          t          ||d	¬
¦  «        ¦  «        D ]\  }\  }} ||||¦  «         Œ| j        r| j        j        j        }n|d         }| j        r| j        j        j        }n|d         } |||d¦  «         d S )NrI   r   rK   r  Úintr\   rÈ   c                ó  — | j         |j         k    rpt          | j         t          ¦  «        r1t          |j         t          ¦  «        rd|› d| j         ›d|j         ›d�}nd|› d| j         ›d|j         ›d�}t          |¦  «        ‚d S )Nzincompatible merge keys [z] r‘  z), both sides category, but not equal onesz, must be the same type)r:  r…   r+   r   )rI   rK   r  rÜ   s       rh   Ú_check_dtype_matchzE_AsOfMerge._maybe_require_matching_dtypes.<locals>._check_dtype_match”	  sÙ   € ØŒz˜Uœ[Ò(Ð(Ý˜dœjÕ*:Ñ;Ô;ð Å
Ø”KÕ!1ñAô Að ðT°Að Tð T¸¼ð Tð TØ œ;ðTð Tð Tð �CðB°Að Bð B¸¼ð Bð BØ œ;ðBð Bð Bð õ ! ‘o”oÐ%ð+ )Ð(rj   Tr#  r4  r   )rI   r   rK   r   r  r%  r\   rÈ   )rC  r'  rQ   rI   r“   rF  rS   rK   )	rÙ   rÆ   rÅ   r'  r  r�  rŽ  ÚltÚrts	            rh   rÕ   z)_AsOfMerge._maybe_require_matching_dtypes�	  sÀ   € ð
	&ð 	&ð 	&ð 	&õ2 %¥S¨¸ÐQUÐ%VÑ%VÔ%VÑWÔWð 	*ð 	*‰KˆA‰x��BØÐ˜r 2 qÑ)Ô)Ð)Ð)àŒ?ð 	$Ø””Ô(ˆBˆBà Ô#ˆBàÔð 	%Ø”Ô!Ô)ˆBˆBà  Ô$ˆBàÐ˜2˜r 1Ñ%Ô%Ð%Ð%Ð%rj   c                ó  — | j         ��v| j        r| j        j        j        }n|d         }d| j         › d|j        ›�}t          |j        ¦  «        s#t          |t          ¦  «        re|j        j	        dv rWt          | j         t          j        ¦  «        st          |¦  «        ‚| j         t          d¦  «        k     rt          d¦  «        ‚d S t          |j        ¦  «        r?t          | j         ¦  «        st          |¦  «        ‚| j         dk     rt          d¦  «        ‚d S t!          |j        ¦  «        r?t#          | j         ¦  «        st          |¦  «        ‚| j         dk     rt          d¦  «        ‚d S t          d¦  «        ‚d S )Nr4  zincompatible tolerance z, must be compat with type ÚmMr   ztolerance must be positivez'key must be integer, timestamp or float)r¹   rQ   rI   r“   rF  r:  r*   r…   r6   rJ  ÚdatetimeÚ	timedeltar   r   r$   r#   r"   r&   )rÙ   rÆ   r(  rÜ   s       rh   rÖ   z_AsOfMerge._validate_tolerance¼	  s   € àŒ>Ñ%ØŒð (Ø”Y”_Ô,��à# BÔ'�ð*¨$¬.ð *ð *ØœXð*ð *ð õ
 # 2¤8Ñ,Ô,ð LÝ˜2Õ2Ñ3Ô3ðLØ8:¼¼ÈÐ8MÐ8Må! $¤.µ(Ô2DÑEÔEð *Ý$ S™/œ/Ð)Ø”>¥I¨a¡L¤LÒ0Ð0Ý$Ð%AÑBÔBÐBð 1Ð0õ " "¤(Ñ+Ô+ð LÝ! $¤.Ñ1Ô1ð *Ý$ S™/œ/Ð)Ø”> AÒ%Ð%Ý$Ð%AÑBÔBÐBð &Ð%õ   ¤Ñ)Ô)ð LÝ  ¤Ñ0Ô0ð *Ý$ S™/œ/Ð)à”> AÒ%Ð%Ý$Ð%AÑBÔBÐBð &Ð%õ !Ð!JÑKÔKÐKðC &Ð%rj   Úvaluesr   Úsideú
np.ndarrayc                óð  — t          |d¬¦  «        j        sFt          |¦  «                             ¦   «         rt	          d|› d�¦  «        ‚t	          |› d�¦  «        ‚t          |t          ¦  «        r|                     ¦   «         }t          |j	        ¦  «        r| 
                    d¦  «        }nFt          |t          ¦  «        r|j        }n)t          |t          ¦  «        r|                     ¦   «         }|S )NFrâ  z"Merge keys contain null values on z sidez keys must be sortedÚi8)r3   ræ  r/   rE  r°   r…   r6   Ú_maybe_convert_datelike_arrayr*   r:  Úviewr7   Ú_datar8   Úto_numpy)rÙ   r.  r/  s      rh   Ú_convert_values_for_libjoinz&_AsOfMerge._convert_values_for_libjoiná	  sô   € õ �V %Ð(Ñ(Ô(Ô@ð 	<Ý�F‰|Œ|×ÒÑ!Ô!ð SÝ Ð!QÀdÐ!QÐ!QÐ!QÑRÔRÐRÝ Ð:Ð:Ð:Ñ;Ô;Ð;å�fÕ1Ñ2Ô2ð 	<Ø×9Ò9Ñ;Ô;ˆFå˜vœ|Ñ,Ô,ð 	'Ø—[’[ Ñ&Ô&ˆFˆFå˜¥Ñ0Ô0ð 	'à”\ˆFˆFÝ˜¥Ñ/Ô/ð 	'Ø—_’_Ñ&Ô&ˆFð
 ˆrj   ró  c           	     óZ  ‡‡— | j         r| j        j        j        n| j        d         }| j        r| j        j        j        n| j        d         }|j        |j        k    sJ ‚| j	        }|�«t          |j        ¦  «        s#t          |t          ¦  «        r‚|j        j        dv rtt          |¦  «        }|j        j        dv rPt          |t          ¦  «        r|j        j        j        }nt#          |¦  «        j        }|                     |¦  «        }|j        }|                      |d¦  «        }|                      |d¦  «        }| j        ��<| j         r| j        r| j        Š| j        Šn| j        dd…         Š| j        dd…         Šˆˆfd„t-          t/          ‰¦  «        ¦  «        D ¦   «         }t/          ‰¦  «        dk    r|d         d         }|d         d         }nad	„ |D ¦   «         }t1          d
„ |D ¦   «         ¦  «        }	t3          ||	dd¬¦  «        }
t/          ‰d         ¦  «        }|
d|…         }|
|d…         }t5          |¦  «        }t5          |¦  «        }t7          | j        ¦  «        } |||||| j        |¦  «        S t7          | j        ¦  «        } |||dd| j        |d¦  «        S )r_  r4  Nr+  rI   rK   r   c                óL   •— g | ] }t          ‰|         ‰|         d ¬¦  «        ‘Œ!S )Fru   rÝ  )rz   rm  rÆ   rÅ   s     €€rh   r�   z1_AsOfMerge._get_join_indexers.<locals>.<listcomp>-
  sM   ø€ ð ð ð ð õ  Ø" 1Ô%Ø# AÔ&Øðñ ô ðð ð rj   rm   c                óF   — g | ]}t          j        |d d…         ¦  «        ‘ŒS )Nr  )rs  Úconcatenate©rz   r�  s     rh   r�   z1_AsOfMerge._get_join_indexers.<locals>.<listcomp>:
  s*   € Ð>Ð>Ð>°!�œ q¨¨!¨¤uÑ-Ô-Ð>Ð>Ð>rj   c              3  ó&   K  — | ]}|d          V — ŒdS )r  Nrn   r<  s     rh   r|   z0_AsOfMerge._get_join_indexers.<locals>.<genexpr>;
  s&   è è € Ð3Ð3 q˜a œdÐ3Ð3Ð3Ð3Ð3Ð3rj   F)rî  rT   Úxnull)rQ   rI   r“   rF  rÆ   rS   rK   rÅ   r:  r¹   r*   r…   r6   rJ  r   Úpyarrow_dtypeÚunitr:   Úas_unitÚ_valuer7  r³   r‘   r’   r‡   r=   r   r  r¼   r»   )rÙ   Úleft_valuesÚright_valuesr¹   r@  rê  Úleft_by_valuesÚright_by_valuesÚarrsrî  Úgroup_indexÚleft_lenÚfuncrÆ   rÅ   s                @@rh   rb  z_AsOfMerge._get_join_indexersû	  s  øø€ ð
 (,¤ÐSˆDŒIŒOÔ#Ð#¸DÔ<OÐPRÔ<Sð 	ð )-Ô(8ÐVˆDŒJÔÔ$Ð$¸dÔ>RÐSUÔ>Vð 	ð
 Ô  LÔ$6Ò6Ð6Ð6Ð6à”Nˆ	ØÐ õ # ;Ô#4Ñ5Ô5ð -Ý˜;Õ(;Ñ<Ô<ð-àÔ%Ô*¨dÐ2Ð2å% iÑ0Ô0�	ð Ô$Ô)¨TÐ1Ð1õ " +Õ/BÑCÔCð PØ*Ô0Ô>ÔC˜˜å=¸kÑJÔJÔO˜Ø )× 1Ò 1°$Ñ 7Ô 7�Ià%Ô,�	ð ×6Ò6°{ÀFÑKÔKˆØ×7Ò7¸ÀgÑNÔNˆð Œ<Ñ#àŒð = 4Ô#3ð =Ø!%Ô!4�Ø"&Ô"6��à!%Ô!4°Q°r°TÔ!:�Ø"&Ô"6°q¸°tÔ"<�ðð ð ð ð õ �s >Ñ2Ô2Ñ3Ô3ðñ ô ˆFõ �>Ñ"Ô" aÒ'Ð'Ø!'¨¤¨1¤�Ø"(¨¤)¨A¤,��à>Ð>°vÐ>Ñ>Ô>�ÝÐ3Ð3¨FÐ3Ñ3Ô3Ñ3Ô3�Ý-Ø ¨E¸ðñ ô �õ ˜~¨aÔ0Ñ1Ô1�Ø!,¨Y¨h¨YÔ!7�Ø"-¨h¨i¨iÔ"8�å)¨.Ñ9Ô9ˆNÝ*¨?Ñ;Ô;ˆOõ % T¤^Ñ4Ô4ˆDØ�4ØØØØØÔ(Øñô ð õ % T¤^Ñ4Ô4ˆDØ�4ØØØØØÔ(ØØñô ð rj   )NNNFFNNNrF   r¾   NTr¸   )rI   rJ   rK   rJ   rM   r£   rO   r£   rP   r£   rQ   rR   rS   rR   rU   r   rL   r  r»   rR   r¼   r±   r\   rÈ   rÒ  rÓ  )r.  r   r/  r±   r\   r0  ©r\   ró  )rÔ  rÕ  rÖ  rØ  rß   rÒ   rÕ   rÖ   r7  rb  Ú__classcell__)r#  s   @rh   r¿   r¿   		  sä   ø€ € € € € Ø€Kð !%Ø%)Ø&*Ø Ø!ØØØØ)Ø%ØØ$(Ø#ð!1
ð 1
ð 1
ð 1
ð 1
ðfN!ð N!ð N!ð N!ð N!ð`+&ð +&ð +&ð +&ðZ#Lð #Lð #Lð #LðJð ð ð ð4`ð `ð `ð `ð `ð `ð `ð `rj   r¿   Ú	join_keysr“   c                ó¦  ‡ ‡‡— ˆˆ ˆfd„t          ‰j        ¦  «        D ¦   «         }t          |ddiŽ}d„ |D ¦   «         \  }}}‰r.t          t	          t
          j        |‰j        ¦  «        ¦  «        }n%d„ }t          t	          |‰j        ¦  «        ¦  «        }t          ‰ ¦  «        D ]†\  }	}
‰j        |	         dk    }| 	                    ¦   «         r\|
||	         ||	         dz
  k             }|j
        dk    s|d         |d         k    s||	xx         dz  cc<   ||	         dz
  ||	         |<   Œ‡t          ||t          |¦  «        ‰¦  «        \  }}||fS )	Nc              3  óh   •K  — | ],}t          ‰j        |         j        ‰|         ‰¬ ¦  «        V — Œ-dS rÜ  )rÞ  r‡  rF  )rz   rm  r“   rM  rT   s     €€€rh   r|   z*_get_multiindex_indexer.<locals>.<genexpr>b
  sS   øè è € ð ð àõ 	˜œ QœÔ/°¸1´ÀDÐIÑIÔIðð ð ð ð ð rj   r$  Tc              3  ó4   K  — | ]}t          |¦  «        V — Œd S rw   rà  r2  s     rh   r|   z*_get_multiindex_indexer.<locals>.<genexpr>g
  rá  rj   c                ó0   — |                       dd¬¦  «        S )Nr2  F)Úsubok)r  )Úas    rh   r­   z)_get_multiindex_indexer.<locals>.<lambda>k
  s   € ˜1Ÿ8š8 D°˜8Ñ6Ô6€ rj   r4  rm   r   )r‘   rÑ   r'  r†   Úmaprs  rŒ   rˆ  rC  rE  Úsizerå  r‡   )rM  r“   rT   rê  rë  ÚrcodesÚlcodesrî  Úi8copyr  Újoin_keyru  rS  rï  rð  s   ```            rh   Ú_get_multiindex_indexerrZ  ^
  s€  øøø€ ðð ð ð ð ð å�u”}Ñ%Ô%ðñ ô €Fõ �&Ð& Ð&Ð&€FØ5Ð5¨fÐ5Ñ5Ô5Ñ€FˆF�EØð 0Ý•c�"œ' 6¨5¬;Ñ7Ô7Ñ8Ô8ˆˆà6Ð6ˆÝ•c˜& %¤+Ñ.Ô.Ñ/Ô/ˆõ ! Ñ+Ô+ð 	+ð 	+‰ˆˆ8ØŒ{˜1Œ~ Ò#ˆØ�8Š8‰:Œ:ð 	+ð ˜ œ e¨A¤h°¡lÒ2Ô3ˆAØŒv˜Š{ˆ{ ! A¤$¨!¨A¬$¢, ,Ø�a��”˜A‘��‘à# Aœh¨™lˆF�1ŒI�d‰Oøõ   ¨µ°e±´¸dÑCÔC�J€Dˆ$Ø�ˆ:Ðrj   c                 ó‚   — t          j        g t           j        ¬¦  «        t          j        g t           j        ¬¦  «        fS )zReturn empty join indexers.rr  )rs  ÚarrayÚintprn   rj   rh   rã  rã  
  s6   € õ 	Œ��2œ7Ð#Ñ#Ô#Ý
Œ��2œ7Ð#Ñ#Ô#ðð rj   rm  r%  Úleft_missingc                ó˜   — t          j        | t           j        ¬¦  «        }t          j        | dt           j        ¬¦  «        }|r||fS ||fS )aÏ  
    Return join indexers where all of one side is selected without sorting
    and none of the other side is selected.

    Parameters
    ----------
    n : int
        Length of indexers to create.
    left_missing : bool
        If True, the left indexer will contain only -1's.
        If False, the right indexer will contain only -1's.

    Returns
    -------
    np.ndarray[np.intp]
        Left indexer
    np.ndarray[np.intp]
        Right indexer
    rr  r4  )rî  r8  r:  )rs  rx  r]  Úfull)rm  r^  r  Úidx_missings       rh   rä  rä  ‡
  sP   € õ, Œ)�A�RœWÐ
%Ñ
%Ô
%€CÝ”' ¨b½¼Ð@Ñ@Ô@€KØð  Ø˜CÐÐØ�ÐÐrj   rk  rl  ú?tuple[Index, npt.NDArray[np.intp] | None, npt.NDArray[np.intp]]c                óZ  — t          |t          ¦  «        rt          |||¬¦  «        \  }}n|d         }|j        }t	          |||¬¦  «        \  }}}t          j        ||||¬¦  «        \  }	}
|s t          | ¦  «        t          |	¦  «        k    r|                      |	¦  «        }||	|
fS | d |
fS )Nru   r   )	r…   r4   rZ  rF  rÞ  rõ  rö  r’   rŒ   )rk  rl  rM  rT   rï  rð  r-  r.  rù  rê   rì   ré   s               rh   rh  rh  ¤
  sÔ   € õ �(�JÑ'Ô'ð 	 Ý,¨Y¸ÀtÐLÑLÔL‰
ˆˆdˆdð
 ˜Œ|ˆð Ôˆå!0°°tÀ$Ð!GÑ!GÔ!GÑ€Hˆi˜Ý")Ô"9Ø�)˜U¨ð#ñ #ô #Ñ€L�-ð ð 7�s�7‰|Œ|�s <Ñ0Ô0Ò0Ð0à—\’\ ,Ñ/Ô/ˆ
Ø˜<¨Ð6Ð6ð �D˜-Ð'Ð'rj   r�  rŽ  ú6tuple[npt.NDArray[np.intp], npt.NDArray[np.intp], int]c                óŠ  — t          | j        t          ¦  «        rt          |j        t          ¦  «        s4t          j        | j        d¦  «        rlt          j        |j        d¦  «        rRt          d| ¦  «                             |¦  «        \  } }t          d| ¦  «        j        } t          d|¦  «        j        }�n€t          | j        t          ¦  «        r—t          |j        t          ¦  «        r}| j        |j        k    rmt          | t          ¦  «        sJ ‚t          |t          ¦  «        sJ ‚|  
                    |¦  «        }t          | j        ¦  «        } t          |j        ¦  «        }�nÏt          | t          ¦  «        �r¹| j        |j        k    �r¨t          | j        t          ¦  «        s,t          | j        t          ¦  «        �rç| j        j        dk    �rÖddl}ddlm} t)          | ¦  «        }| j        } |j        }|                     | j        |j        z   ¦  «                             ¦   «                              ¦   «         } ||j        t7          |¦  «                 d¦  «                             ¦   «                              t<          j        d¬	¦  «         ||j        t7          |d¦  «                 d¦  «                             ¦   «                              t<          j        d¬	¦  «        t)          |j         ¦  «        }
}	}|r/|j                              d¬
¦  «        }tC          |||	¦  «        \  }}	|j"        dk    ri|dk    }| #                    ¦   «         }|	dk    }| #                    ¦   «         }|rt=          j$        |||
¦  «         |rt=          j$        |	||
¦  «         |
dz  }
||	|
fS t          | tJ          ¦  «        swt          | j        t          ¦  «        r/tM          | j        j'        ¦  «        sDtQ          | j        ¦  «        r|r.|  )                    ¦   «         \  } }| )                    ¦   «         \  }}tU          | j        ¦  «        rP| j        |j        k    r@t=          j+        | t<          j,        ¬¦  «        } t=          j+        |t<          j,        ¬¦  «        }t[          | |¦  «        \  }} } |t]          t)          | ¦  «        t)          |¦  «        ¦  «        t          |tJ          t^          f¦  «        ¬¦  «        }t          | tJ          ¦  «        r4t          |tJ          ¦  «        sJ ‚| j0        | j1        }}|j0        |j1        }}n t          | t^          ¦  «        r‚t          |t^          ¦  «        sJ ‚|                      d| j        j'        ¬¦  «        }|                     d| j        j'        ¬¦  «        }|  2                    ¦   «         | 2                    ¦   «         }}n	| |}}d\  }}|dk    o| o| j        j3        dv }|rr| 4                    ||¬¦  «        }	| 5                    ¦   «         t)          |	¦  «        k    r| 6                    ||¦  «        \  }}||dfS | 4                    ||¬¦  «        }n.| 4                    ||¬¦  «        }| 4                    ||¬¦  «        }	|j        t=          j        t<          j        ¦  «        k    sJ |j        ¦   «         ‚|	j        t=          j        t<          j        ¦  «        k    sJ |	j        ¦   «         ‚| 5                    ¦   «         }
|r-|j7         8                    ¦   «         }tC          |||	¦  «        \  }}	|dk    }| #                    ¦   «         }|	dk    }| #                    ¦   «         }|s|r5|rt=          j$        |||
¦  «         |rt=          j$        |	||
¦  «         |
dz  }
||	|
fS )aŒ  
    Encode left and right keys as enumerated types.

    This is used to get the join indexers to be used when merging DataFrames.

    Parameters
    ----------
    lk : ndarray, ExtensionArray
        Left key.
    rk : ndarray, ExtensionArray
        Right key.
    sort : bool, defaults to True
        If True, the encoding is done such that the unique elements in the
        keys are sorted.
    how: str, optional
        Used to determine if we can use hash-join. If not given, then just factorize
        keys.

    Returns
    -------
    np.ndarray[np.intp]
        Left (resp. right if called with `key='right'`) labels, as enumerated type.
    np.ndarray[np.intp]
        Right (resp. left if called with `key='right'`) labels, as enumerated type.
    int
        Number of unique elements in union of left and right labels. -1 if we used
        a hash-join.

    See Also
    --------
    merge : Merge DataFrame or named Series objects
        with a database-style join.
    algorithms.factorize : Encode the object as an enumerated type
        or categorical variable.

    Examples
    --------
    >>> lk = np.array(["a", "c", "b"])
    >>> rk = np.array(["a", "c"])

    Here, the unique values are `'a', 'b', 'c'`. With the default
    `sort=True`, the encoding will be `{0: 'a', 1: 'b', 2: 'c'}`:

    >>> pd.core.reshape.merge._factorize_keys(lk, rk)
    (array([0, 2, 1]), array([0, 2]), 3)

    With the `sort=False`, the encoding will correspond to the order
    in which the unique elements first appear: `{0: 'a', 1: 'c', 2: 'b'}`:

    >>> pd.core.reshape.merge._factorize_keys(lk, rk, sort=False)
    (array([0, 1, 2]), array([0, 1]), 3)
    r;  rA   Úpyarrowr   N)Ú_safe_fill_nullr4  Frâ  )Úzero_copy_onlyrm   rr  )Ú	uses_mask)Úna_valuer:  r3  rE   Úiufb)ru  )9r…   r:  r,   r   Úis_np_dtyper	   Ú_ensure_matching_resosÚ_ndarrayr+   r2   Ú_encode_with_my_categoriesr   rˆ  r8   r1   r9   Ústoragerf  Úpandas.compat.pyarrowrg  r’   Ú	_pa_arrayÚchunked_arrayÚchunksÚcombine_chunksÚdictionary_encoder�   Úslicer6  r  rs  r]  Ú
dictionaryÚ_sort_labelsÚ
null_countrE  Úputmaskr7   r'   Únumpy_dtyper)   Ú_values_for_factorizer*   ÚasarrayÚint64Ú#_convert_arrays_and_get_rizer_klassÚmaxr6   r5  Ú_maskr/   rJ  Ú	factorizeÚ	get_countÚhash_inner_joinÚuniquesÚto_array)r�  rŽ  rT   rL   Úparg  Úlen_lkÚdcrì  rí  rù  r†  ÚlmaskÚlanyÚrmaskÚranyr¶   ÚklassÚrizerÚlk_dataÚlk_maskÚrk_dataÚrk_maskÚhash_join_availablerò  rñ  s                             rh   rÞ  rÞ  À
  s2  € õz 	�2”8�_Ñ-Ô-ðN/Ý2<¸R¼XÅÑ2WÔ2WðN/å
Œ/˜"œ( CÑ
(Ô
(ðN/å-0¬_¸R¼XÀsÑ-KÔ-KðN/õ
 �o rÑ*Ô*×AÒAÀ"ÑEÔE‰ˆˆBÝ�/ 2Ñ&Ô&Ô/ˆÝ�/ 2Ñ&Ô&Ô/ˆ‰õ 	�2”8Õ-Ñ.Ô.ðE/å�r”xÕ!1Ñ2Ô2ðE/ð ŒH˜œÒ Ð å˜"�kÑ*Ô*Ð*Ð*Ð*Ý˜"�kÑ*Ô*Ð*Ð*Ð*ð ×*Ò*¨2Ñ.Ô.ˆå˜"œ(Ñ#Ô#ˆÝ˜"œ(Ñ#Ô#ˆ‰å	�B�Ñ	'Ô	'ñ 7/¨B¬H¸¼Ò,@Ñ,@Ý�b”h¥
Ñ+Ô+ð (	%Ý�r”x¥Ñ-Ô-ñ(	%Ø24´(Ô2BÀiÒ2OÑ2Oà Ð Ð Ð à=Ð=Ð=Ð=Ð=Ð=å˜‘W”WˆFØ”ˆBØ”ˆBà× Ò  ¤¨R¬YÑ!6Ñ7Ô7ß’Ñ!Ô!ß"Ò"Ñ$Ô$ð ð  � ¤
­5°©=¬=Ô 9¸2Ñ>Ô>ß’‘”ß’�œ e�Ñ,Ô,Ø� ¤
­5°¸Ñ+>Ô+>Ô ?ÀÑDÔDß’‘”ß’�œ e�Ñ,Ô,Ý�B”MÑ"Ô"ð �$ˆDð ð ?Øœ-×0Ò0ÀÐ0ÑFÔF�Ý)¨'°4¸Ñ>Ô>‘
��dàŒ}˜qÒ Ð Ø š
�Ø—y’y‘{”{�Ø š
�Ø—y’y‘{”{�Øð 3Ý”J˜t U¨EÑ2Ô2Ð2Øð 3Ý”J˜t U¨EÑ2Ô2Ð2Ø˜‘
�Ø˜˜uÐ$Ð$å˜"�oÑ.Ô.ð 	/å�r”x¥Ñ,Ô,ð	/õ ! ¤Ô!5Ñ6Ô6ð		/õ
 $ B¤HÑ-Ô-ð	/ð
 7;ð	/ð ×,Ò,Ñ.Ô.‰EˆB�ð ×,Ò,Ñ.Ô.‰EˆB�å˜2œ8Ñ$Ô$ð ,¨¬°R´XÒ)=Ð)=õ ŒZ˜¥"¤(Ð+Ñ+Ô+ˆÝŒZ˜¥"¤(Ð+Ñ+Ô+ˆå7¸¸BÑ?Ô?�M€Eˆ2ˆràˆEÝ�C�‰GŒG•S˜‘W”WÑÔÝ˜R¥/Õ3FÐ!GÑHÔHðñ ô €Eõ
 �"•oÑ&Ô&ð &Ý˜"�oÑ.Ô.Ð.Ð.Ð.Øœ8 R¤X�ˆØœ8 R¤X�ˆˆÝ	�BÕ+Ñ	,Ô	,ð &Ý˜"Õ1Ñ2Ô2Ð2Ð2Ð2ð —+’+ q°´Ô0D�+ÑEÔEˆØ—+’+ q°´Ô0D�+ÑEÔEˆØŸ7š7™9œ9 b§g¢g¡i¤i�ˆˆð
 ˜r�ˆØ%Ñˆ�à š.ÐQ°¨XÐQ¸"¼(¼-È6Ð:QÐØð 	6Ø�Š˜w¨WˆÑ5Ô5ˆØ�?Š?ÑÔ¥ D¡	¤	Ò)Ð)Ø×.Ò.¨w¸Ñ@Ô@‰JˆD�$Ø˜˜r�>Ð!à—?’? 7°�?Ñ9Ô9ˆDˆDà�Š˜w¨WˆÑ5Ô5ˆØ�Š˜w¨WˆÑ5Ô5ˆàŒ:�œ¥"¤'Ñ*Ô*Ò*Ð*Ð*¨D¬JÑ*Ô*Ð*ØŒ:�œ¥"¤'Ñ*Ô*Ò*Ð*Ð*¨D¬JÑ*Ô*Ð*à�OŠOÑÔ€Eàð 7Ø”-×(Ò(Ñ*Ô*ˆÝ! '¨4°Ñ6Ô6‰
ˆˆdð �BŠJ€EØ�9Š9‰;Œ;€DØ�BŠJ€EØ�9Š9‰;Œ;€Dàð ˆtð Øð 	+ÝŒJ�t˜U EÑ*Ô*Ð*Øð 	+ÝŒJ�t˜U EÑ*Ô*Ð*Ø�‰
ˆà��uÐÐrj   ú:tuple[type[libhashtable.Factorizer], ArrayLike, ArrayLike]c                óœ  — t          | j        ¦  «        �r‰| j        |j        k    rýt          | j        |j        g¦  «        }t          |t          ¦  «        rŸ|                     ¦   «         }t          | t          ¦  «        s|                     | |d¬¦  «        } n|                      |d¬¦  «        } t          |t          ¦  «        s|                     ||d¬¦  «        }nF|                     |d¬¦  «        }n.|                      |d¬¦  «        } |                     |d¬¦  «        }t          | t          ¦  «        rt          | j        j                 }nyt          | j        t          ¦  «        rt          | j        j        j                 }nBt          | j        j                 }n*t          j        }t!          | ¦  «        } t!          |¦  «        }|| |fS )NFr9  râ  )r'   r:  r   r…   r   rŸ  r8   r   r  r7   Ú_factorizersrÐ   r1   r|  ÚlibhashtableÚObjectFactorizerr   )r�  rŽ  r:  Úclsr�  s        rh   r€  r€  ‘  sš  € õ ˜œÑ!Ô!ñ ØŒ8�r”xÒÐÝ$ b¤h°´Ð%9Ñ:Ô:ˆEÝ˜%¥Ñ0Ô0ð 2Ø×0Ò0Ñ2Ô2�Ý! "¥nÑ5Ô5ð 6Ø×+Ò+¨B°eÀ%Ð+ÑHÔH�B�BàŸš 5¨u˜Ñ5Ô5�Bå! "¥nÑ5Ô5ð 6Ø×+Ò+¨B°eÀ%Ð+ÑHÔH�B�BàŸš 5¨u˜Ñ5Ô5�B�Bà—Y’Y˜u¨5�YÑ1Ô1�Ø—Y’Y˜u¨5�YÑ1Ô1�Ý�b�/Ñ*Ô*ð 	0Ý  ¤¤Ô/ˆEˆEÝ˜œ¥*Ñ-Ô-ð 	0Ý  ¤Ô!5Ô!:Ô;ˆEˆEå  ¤¤Ô/ˆEˆEõ Ô-ˆÝ˜2ÑÔˆÝ˜2ÑÔˆØ�"�bˆ=Ðrj   r†  r0  c                ó°   — t          |¦  «        }t          j        ||g¦  «        }t          j        | |d¬¦  «        \  }}|d |…         ||d …         }}||fS )NT)Úuse_na_sentinel)r’   rs  r;  rG  Ú	safe_sort)	r†  rI   rK   Úllengthr  r¶   Ú
new_labelsÚnew_leftÚ	new_rights	            rh   ry  ry  ´  sb   € õ �$‰iŒi€GÝŒ^˜T 5˜MÑ*Ô*€Få”O G¨VÀTÐJÑJÔJ�M€A€zØ$ X g XÔ.°
¸7¸8¸8Ô0Dˆi€Hà�YÐÐrj   rì  ú%list[npt.NDArray[np.int64 | np.intp]]rí  rî  r   ú3tuple[npt.NDArray[np.int64], npt.NDArray[np.int64]]c                óÎ  ‡— t          ˆfd„t          t          ‰¦  «        dd¦  «        D ¦   «         ¦  «        }t          j        ‰d|…         d¬¦  «        }|| d                              ddd¬¦  «        z  }||d                              ddd¬¦  «        z  }t          d|¦  «        D ]V}t          j        d	¬
¦  «        5  |‰|         z  }d d d ¦  «         n# 1 swxY w Y   || |         |z  z  }|||         |z  z  }ŒW|t          ‰¦  «        k    r||fS t          |||¬¦  «        \  }}}	|g| |d …         ¢} |g||d …         ¢}|	g‰|d …         ¢R Št          | |‰|¦  «        S )Nc              3  óJ   •K  — | ]}t          ‰d |…         ¦  «        °|V — Œd S rw   )r>   )rz   r‚  rî  s     €rh   r|   z!_get_join_keys.<locals>.<genexpr>Ç  sM   øè è € ð ð àÝ)¨%°°°¬+Ñ6Ô6ðØðð ð ð ð ð rj   r   r4  rm   r2  rr  F)rR  rV   r’  )Údivideru   )	Únextr‘   r’   rs  Úprodr  r¡  rÞ  rå  )
rì  rí  rî  rT   ÚnlevÚstriderï  rð  r  rù  s
     `       rh   rå  rå  À  sí  ø€ õ ð ð ð ð å�˜U™œ Q¨Ñ+Ô+ðñ ô ñ ô €Dõ ŒW�U˜1˜T˜6”]¨$Ð/Ñ/Ô/€FØ�D˜”G—N’N 4¨u¸5�NÑAÔAÑA€DØ�D˜”G—N’N 4¨u¸5�NÑAÔAÑA€Då�1�d‰^Œ^ð !ð !ˆÝŒ[ Ð)Ñ)Ô)ð 	 ð 	 Ø�u˜Q”xÑˆFð	 ð 	 ð 	 ñ 	 ô 	 ð 	 ð 	 ð 	 ð 	 ð 	 ð 	 øøøð 	 ð 	 ð 	 ð 	 à��Q”˜&Ñ Ñ ˆØ��Q”˜&Ñ Ñ ˆˆà�s�5‰zŒzÒÐØ�TˆzÐõ (¨¨d¸Ð>Ñ>Ô>Ñ€Dˆ$�àÐ�4˜˜˜”;Ð€DØÐ�4˜˜˜”;Ð€DØÐ"�U˜4˜5˜5”\Ð"Ð"€Eå˜$  e¨TÑ2Ô2Ð2s   Ã CÃC	ÃC	c                óf   — t          | t          ¦  «        rt          |t          ¦  «        sdS | |k    S )NT)r…   r±   )rQ  rR  s     rh   rD  rD  å  s4   € Ý�e�SÑ!Ô!ð ­°E½3Ñ)?Ô)?ð ØˆtØ�EŠ>Ðrj   c                ó&   — | d uot          j        | Ž S rw   )rÎ   Úany_not_none)r¨   s    rh   r…  r…  ë  s   € Ø�Dˆ=Ð1�SÔ-¨qÐ1Ð1rj   Úobjc                óî   — t          | t          ¦  «        r| S t          | t          ¦  «        r*| j        €t	          d¦  «        ‚|                      ¦   «         S t          dt          | ¦  «        › d�¦  «        ‚)Nz$Cannot merge a Series without a namez.Can only merge Series or DataFrame objects, a z was passed)r…   r-   r.   r,  r°   rÂ  Ú	TypeErrorrÐ   )r¯  s    rh   r`   r`   ï  sv   € Ý�#•|Ñ$Ô$ð 	
Øˆ
Ý	�C�Ñ	#Ô	#ð 
ØŒ8ÐÝÐCÑDÔDÐDØ�|Š|‰~Œ~ÐåØS½TÀ#¹Y¼YÐSÐSÐSñ
ô 
ð 	
rj   útuple[Index, Index]c                ó¶  ‡— t          |d¬¦  «        rt          |t          ¦  «        r t          dt	          |¦  «        › d�¦  «        ‚|                      |¦  «        Št          ‰¦  «        dk    r| |fS |\  }}|s|st          d‰› �¦  «        ‚dˆfd	„}t          ||¬
¦  «        }t          ||¬
¦  «        }|  	                    |¦  «        }| 	                    |¦  «        }	g }
|j
        sU|
                     ||                     ¦   «         |                      ¦   «          z                                ¦   «         ¦  «         |	j
        sU|
                     |	|	                     ¦   «         |                     ¦   «          z                                ¦   «         ¦  «         |
                     |                     |                     ‰¦  «        ¦  «                             ¦   «         ¦  «         |
                     |	                     |                      ‰¦  «        ¦  «                             ¦   «         ¦  «         |
r t          dt!          |
¦  «        › d�¦  «        ‚||	fS )z¶
    Suffixes type validation.

    If two indices overlap, add suffixes to overlapping entries.

    If corresponding suffix is empty, the entry is simply converted to string.

    F)Ú
allow_setszPassing 'suffixes' as a z:, is not supported. Provide 'suffixes' as a tuple instead.r   z)columns overlap but no suffix specified: Úsuffixr[   c                ó    •— | ‰v r|�| › |› �S | S )a?  
        Rename the left and right indices.

        If there is overlap, and suffix is not None, add
        suffix, otherwise, leave it as-is.

        Parameters
        ----------
        x : original column name
        suffix : str or None

        Returns
        -------
        x : renamed column name
        rn   )r¨   rµ  Ú	to_renames     €rh   Úrenamerz+_items_overlap_with_suffix.<locals>.renamer  s&   ø€ ð  �	ˆ>ˆ>˜fÐ0Ø�>˜�>�>Ð!Øˆrj   )rµ  z1Passing 'suffixes' which cause duplicate columns z is not allowed.)rµ  r[   )r%   r…   Údictr±  rÐ   r¶  r’   r°   r   Ú_transform_indexr·  ÚextendrÁ  r�   r²   r   r~   )rI   rK   rU   ÚlsuffixÚrsuffixr¸  ÚlrenamerÚrrenamerrø   rù   Údupsr·  s              @rh   ró   ró   ü  s}  ø€ õ ˜¨UÐ3Ñ3Ô3ð 
µzÀ(ÍDÑ7QÔ7Qð 
Ýð5¥t¨H¡~¤~ð 5ð 5ð 5ñ
ô 
ð 	
ð
 ×!Ò! %Ñ(Ô(€IÝ
ˆ9�~„~˜ÒÐØ�Uˆ{ÐàÑ€GˆWàð R˜7ð RÝÐPÀYÐPÐPÑQÔQÐQðð ð ð ð ð õ( �w wÐ/Ñ/Ô/€HÝ�w wÐ/Ñ/Ô/€Hà×#Ò# HÑ-Ô-€GØ×$Ò$ XÑ.Ô.€Gà€DØÔð Uð 	�Š�G˜W×/Ò/Ñ1Ô1°t·²Ñ7HÔ7HÐ6HÑIÔJ×QÒQÑSÔSÑTÔTÐTØÔð VØ�Š�G˜W×/Ò/Ñ1Ô1°u×7GÒ7GÑ7IÔ7IÐ6IÑJÔK×RÒRÑTÔTÑUÔUÐUà‡K‚K�×$Ò$ U×%5Ò%5°iÑ%@Ô%@ÑAÔA×HÒHÑJÔJÑKÔKÐKØ‡K‚K�×$Ò$ T§_¢_°YÑ%?Ô%?Ñ@Ô@×GÒGÑIÔIÑJÔJÐJØð 
ÝðÅÀDÁ	Ä	ð ð ð ñ
ô 
ð 	
ð
 �GÐÐrj   )rI   rJ   rK   rJ   rL   r   rM   rN   rO   rN   rP   rN   rQ   rR   rS   rR   rT   rR   rU   r   rV   rW   rX   rY   rZ   r[   r\   r?   )	NNNFFFrF   FN)rI   r?   rK   r?   rM   rN   rO   rN   rP   rN   rQ   rR   rS   rR   rT   rR   rU   r   rX   rY   rZ   r[   r\   r?   )rI   rJ   rK   rJ   )NNNNNNrF   r¢   )rI   rJ   rK   rJ   rM   r£   rO   r£   rP   r£   r¤   r[   rU   r   rL   r   r\   r?   )NNNFFNNNrF   NTr¸   )rI   rJ   rK   rJ   rM   r£   rO   r£   rP   r£   rQ   rR   rS   rR   rU   r   r¹   rº   r»   rR   r¼   r±   r\   r?   )FrE   )
r‰  rÄ   rŠ  rÄ   rT   rR   rL   r   r\   r]  )
rI   r   rK   r   rT   rR   rL   r   r\   ró  )rI   r4   rK   r4   ré   r3   rú  rû  rü  rû  r\   rý  )r¼   r±   )rM  rÄ   r“   r4   rT   rR   r\   ró  rK  )rm  r%  r^  rR   r\   ró  )F)
rk  r3   rl  r3   rM  rÄ   rT   rR   r\   rb  )TN)
r�  r   rŽ  r   rT   rR   rL   r[   r\   rd  )r�  r   rŽ  r   r\   r–  )r†  r0  rI   rû  rK   rû  r\   ró  )
rì  r£  rí  r£  rî  r   rT   rR   r\   r¤  )r\   rR   )r¯  rJ   r\   r?   )rI   r3   rK   r3   rU   r   r\   r²  )¤r×  Ú
__future__r   Úcollections.abcr   r   r,  Ú	functoolsr   r  Útypingr   r   r	   r
   ro   r£  Únumpyrs  Úpandas._libsr   r   r™  r   rõ  r   Úpandas._libs.libr   Úpandas._typingr   r   r   r   r   r   r   r   Úpandas.errorsr   Úpandas.util._decoratorsr   r   Úpandas.util._exceptionsr   Úpandas.core.dtypes.baser   Úpandas.core.dtypes.castr   Úpandas.core.dtypes.commonr   r   r    r!   r"   r#   r$   r%   r&   r'   r(   r)   r*   Úpandas.core.dtypes.dtypesr+   r,   Úpandas.core.dtypes.genericr-   r.   Úpandas.core.dtypes.missingr/   r0   rD   r1   r2   r3   r4   r5   Úpandas.core.algorithmsÚcoreÚ
algorithmsrG  Úpandas.core.arraysr6   r7   r8   Úpandas.core.arrays.string_r9   Úpandas.core.commonÚcommonrÎ   Úpandas.core.constructionr:   r;   Úpandas.core.indexes.apir<   Úpandas.core.sortingr=   r>   r?   Úpandas.corer@   rA   Úpandas.core.indexes.frozenrB   r  ÚInt64FactorizerÚlonglongÚint32ÚInt32FactorizerÚint16ÚInt16Factorizerr  ÚInt8FactorizerÚuint64ÚUInt64FactorizerÚuint32ÚUInt32FactorizerÚuint16ÚUInt16FactorizerÚuint8ÚUInt8FactorizerÚbool_Úfloat64ÚFloat64FactorizerÚfloat32ÚFloat32FactorizerÚ	complex64ÚComplex64FactorizerÚ
complex128ÚComplex128FactorizerÚobject_rš  r˜  Úintcr:  ÚitemsizeÚuintcÚndarrayr1  rÀ  ri   rb   r¡   r·   rÀ   rc   ra  rç  r	  r§   r  r¿   rZ  rã  rä  rh  rÞ  r€  ry  rå  rD  r…  r`   ró   rn   rj   rh   ú<module>rû     sB	  ððð ð #Ð "Ð "Ð "Ð "Ð "ðð ð ð ð ð ð ð ð €€€Ø Ð Ð Ð Ð Ð Ø €€€ðð ð ð ð ð ð ð ð ð ð ð ð €€€Ø €€€à Ð Ð Ð ðð ð ð ð ð ð ð ð ð ð ð ð .Ð -Ð -Ð -Ð -Ð -ð	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð %Ð $Ð $Ð $Ð $Ð $ðð ð ð ð ð ð ð ð 5Ð 4Ð 4Ð 4Ð 4Ð 4à 2Ð 2Ð 2Ð 2Ð 2Ð 2Ø 4Ð 4Ð 4Ð 4Ð 4Ð 4ðð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ðð ð ð ð ð ð ð ðð ð ð ð ð ð ð ðð ð ð ð ð ð ð ð
ð ð ð ð ð ð ð ð ð ð ð ð ð ð 'Ð &Ð &Ð &Ð &Ð &Ð &Ð &Ð &ðð ð ð ð ð ð ð ð ð ð
 3Ð 2Ð 2Ð 2Ð 2Ð 2Ø  Ð  Ð  Ð  Ð  Ð  Ð  Ð  Ð  ðð ð ð ð ð ð ð ð 2Ð 1Ð 1Ð 1Ð 1Ð 1ðð ð ð ð ð ð ð ð
 ð 6Ø Ð Ð Ð Ð Ð Ø#Ð#Ð#Ð#Ð#Ð#Ø0Ð0Ð0Ð0Ð0Ð0Ø5Ð5Ð5Ð5Ð5Ð5ð „HˆlÔ*Ø„K�Ô-Ø„HˆlÔ*Ø„HˆlÔ*Ø„Gˆ\Ô(Ø„Iˆ|Ô,Ø„Iˆ|Ô,Ø„Iˆ|Ô,Ø„HˆlÔ*Ø„HˆlÔ*Ø„J�Ô.Ø„J�Ô.Ø„L�,Ô2Ø„M�<Ô4Ø„J�Ô-ð€ð& „7�"”(ÐÐØ€r„x�”ÑÔÔ! QÒ&Ð&Ø ,Ô <ˆ�R”WÑÐà ,Ô <ˆ�R”WÑà„8�2”9ÐÐØ€r„x�”ÑÔÔ" aÒ'Ð'Ø!-Ô!>ˆ�R”XÑÐà!-Ô!>ˆ�R”XÑð Œ*�n e¨YÐ	7€ð €ˆHÑÔð Ø+/Ø04Ø15ØØØØ%Ø!$¤Ø!Øð}ð }ð }ð }ñ Ôð}ðF ,0Ø04Ø15ØØØØ%Ø!Øð2ð 2ð 2ð 2ð 2ðj6ð 6ð 6ð 6ðr €ˆHÑÔð !Ø!%Ø"&ØØØ"Ø%ØðLð Lð Lð Lñ ÔðLð^ €ˆHÑÔð !Ø!%Ø"&ØØØØØØ%Ø15Ø $ØðUð Uð Uð Uñ ÔðUðrNð Nð Nð Nð Nñ Nô Nð Nðh" Øð	Kð Kð Kð Kð Kðb Øð	#ð #ð #ð #ð #ðLV/ð V/ð V/ð V/ðr9ð 9ð 9ð 9ð 9�Oñ 9ô 9ð 9ðx(ð (ð (ð (ð
Rð Rð Rð Rð R�ñ Rô Rð Rðj
ð ð ð ðBð ð ð ðð ð ð ð< OTð(ð (ð (ð (ð (ð> Øð	Nð Nð Nð Nð Nðb ð  ð  ð  ðF	ð 	ð 	ð 	ð"3ð "3ð "3ð "3ðJð ð ð ð2ð 2ð 2ð 2ð

ð 

ð 

ð 

ðDð Dð Dð Dð Dð Drj   