a
    ï½„gò¦ ã                   @   sÎ  d dl m Z  d dlZd dlmZ d dlZd dlZd dlZd dlmZm	Z	 d dl
m  mZ d dlmZ d dlZd dlmZmZmZmZ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" d dl#m$  m%Z& ej' (d¡Z)d	d
„ Z*dd„ Z+ej' ,dg d¢¡dd„ ƒZ-dd„ Z.dd„ Z/dd„ Z0dd„ Z1ej' ,dddg¡dd„ ƒZ2dd„ Z3d d!„ Z4d"d#„ Z5ej' ,dg d$¢¡d%d&„ ƒZ6d'd(„ Z7d)d*„ Z8d+d,„ Z9d-d.„ Z:d/d0„ Z;d1d2„ Z<d3d4„ Z=d5d6„ Z>d7d8„ Z?ej' ,d9d:d;„ d<d;„ g¡d=d>„ ƒZ@d?d@„ ZAdAdB„ ZBdCdD„ ZCdEdF„ ZDdGdH„ ZEdIdJ„ ZFdKdL„ ZGdMdN„ ZHdOdP„ ZIdQdR„ ZJdSdT„ ZKdUdV„ ZLdWdX„ ZMej' ,dYdZd[g¡d\d]„ ƒZNej' ,dYg d^¢¡ej' ,d_ddg¡d`da„ ƒƒZOdbdc„ ZPddde„ ZQdfdg„ ZRdhdi„ ZSdjdk„ ZTdldm„ ZUdndo„ ZVdpdq„ ZWdrds„ ZXdtdu„ ZYdvdw„ ZZdxdy„ Z[dzd{„ Z\d|d}„ Z]d~d„ Z^d€d�„ Z_d‚dƒ„ Z`d„d…„ Zad†d‡„ Zbdˆd‰„ ZcdŠd‹„ ZddŒd�„ ZedŽd�„ Zfd�d‘„ Zgd’d“„ Zhd”d•„ Zid–d—„ Zjd˜d™„ Zkdšd›„ Zldœd�„ ZmdždŸ„ Znd d¡„ Zod¢d£„ Zpd¤d¥„ Zqd¦d§„ Zrd¨d©„ Zsdªd«„ Ztd¬d­„ Zud®d¯„ Zvej' ,d°d±d±d²gg¡d³d´„ ƒZwdµd¶„ Zxd·d¸„ Zyd¹dº„ Zzd»d¼„ Z{d½d¾„ Z|d¿dÀ„ Z}dÁdÂ„ Z~dÃdÄ„ Zej' ,dÅdÆdÇdÈdÆdÇgdÆdÈgg¡ej' ,dÉdÊdËdÊdËgg¡dÌdÍ„ ƒƒZ€dÎdÏ„ Z�ej' ,dÐdÑdÑgg¡ej' ,dÒd±gd±d²gg¡ej'j,dÓdgd gdÔgdÕged gƒed ƒged dÖdÖd×dØ�ej‚dÙdÚdÛdÜ�ejƒd gdÝdÞ�ejƒd gdßdÞ�ejƒdgdàdÞ�gg dá¢dâ�ej' ,dãg dä¢¡ej' ,d9g då¢¡dædç„ ƒƒƒƒƒZ„dèdé„ Z…dêdë„ Z†dìdí„ Z‡dîdï„ Zˆdðdñ„ Z‰dòdó„ ZŠdôdõ„ Z‹död÷„ ZŒej' ,dødùdùgg¡dúdû„ ƒZ�ej' ,düdýdþddedÿƒe�d ƒddgif�ddþedÿƒe�d ƒe�dƒe�dƒe�dƒe�dƒgif�ddþedÿƒe�d ƒedÿƒe�d ƒe�dƒe�dƒgifg¡�d�d„ ƒZŽ�d�d„ Z��d	�d
„ Z��d�d„ Z‘�d�d„ Z’�d�d„ Z“ej' ,�dg �d¢¡�d�d„ ƒZ”�d�d„ Z•ej' ,�de�ddÕfeddfe�ddfe�ddfe�ddfe�ddfe�ddÕfeddfe�ddfe�ddfe�ddfe�ddfg¡�d�d„ ƒZ–�d�d „ Z—ej' ,�d!g �d"¢¡�d#�d$„ ƒZ˜ej' ,�d%dej™de š�d&¡�d'�g¡�d(�d)„ ƒZ›�d*�d+„ Zœej' ,�d,�d-�d.�d/gf�d0�d1�d2gfg¡�d3�d4„ ƒZ��d5�d6„ Zž�d7�d8„ ZŸ�d9�d:„ Z �d;�d<„ Z¡�d=�d>„ Z¢ej' ,d_ddg¡�d?�d@„ ƒZ£�dA�dB„ Z¤�dC�dD„ Z¥�dE�dF„ Z¦�dG�dH„ Z§�dI�dJ„ Z¨�dK�dL„ Z©ej' ,deªej™�dMe š�d&¡�d'�g¡�dN�dO„ ƒZ«�dP�dQ„ Z¬�dR�dS„ Z­ej' ,�dTddÕdÕgg¡�dU�dV„ ƒZ®�dW�dX„ Z¯ej' ,�dYd gdf�dZd gdf�d[g¡�d\�d]„ ƒZ°ej' ,�d!g �d^¢¡�d_�d`„ ƒZ±ej' ,�da�db�dcg¡�dd�de„ ƒZ²ej' ,�df�dg�dhg¡�di�dj„ ƒZ³ej' ,�dk�dldej´fg¡�dm�dn„ ƒZµej' ,�dog �dp¢g �dq¢g �dr¢fg �ds¢g �dt¢g �du¢fg¡�dv�dw„ ƒZ¶ej' ,�dxg �dy¢¡�dz�d{„ ƒZ·ej' (�d|¡ej' ,dãg �d}¢¡�d~�d„ ƒƒZ¸�d€�d�„ Z¹�d‚�dƒ„ Zºej' ,d_ddg¡�d„�d…„ ƒZ»�d†�d‡„ Z¼ej' ,�dˆdÖdÕg¡�d‰�dŠ„ ƒZ½ej' ,dãg �d‹¢¡�dŒ�d�„ ƒZ¾�dŽ�d�„ Z¿�d��d‘„ ZÀ�d’�d“„ ZÁej' ,�d”ddg¡ej' ,�d•�d–�d—dÕgdÖeÂf�d—dÕg�d˜df�d™�dd gdÖeÂf�dd g�d˜dfg¡�dš�d›„ ƒƒZÃ�dœ�d�„ ZÄ�dž�dŸ„ ZÅ�d �d¡„ ZÆej' ,�d”ddg¡�d¢�d£„ ƒZÇdS (¤  é    )ÚdatetimeN)ÚDecimal)ÚPerformanceWarningÚSpecificationError)Úis_string_dtype)ÚCategoricalÚ	DataFrameÚGrouperÚIndexÚIntervalÚ
MultiIndexÚ
RangeIndexÚSeriesÚ	TimedeltaÚ	TimestampÚ
date_rangeÚto_datetime)ÚBooleanArrayz)ignore:Mean of empty slice:RuntimeWarningc                  C   s$   t tddd�ƒ} d}| |ks J ‚d S )NÚAÚB)ÚkeyÚlevelz<Grouper(key='A', level='B', axis=0, sort=False, dropna=True))Úreprr	   )ÚresultÚexpected© r   úd/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/pandas/tests/groupby/test_groupby.pyÚ	test_repr'   s    r   c           
      C   sØ   t jddd�}t|ƒ}|d d d…  d9  < | d¡ ¡ }|tdƒ |d< |tdd	d
� |d< t j|jd< | t	t
dƒƒd ¡}| ¡ }tdƒ}tdƒ}t|d ||||gt d¡d�}t|||dœƒ}	t ||	¡ d S )Nz1 Dayé'  ©Úperiodsé   é   r   r   r   ÚUTC©ÚtzÚCéÿÿÿÿiÐ  z2887 days 11:21:02.326710176z2886 days 00:42:34.664668096©Úindex©r   r   r&   )ÚpdZtimedelta_ranger   Úto_frameÚcopyr   ÚNaTÚilocÚgroupbyÚlistÚrangeÚstdr   ÚnpÚaranger   ÚtmÚassert_frame_equal)
Zwarn_copy_on_writeZtdiÚserÚdfÚgbr   Ztd1Ztd4Zexp_serr   r   r   r   Útest_groupby_std_datetimelike.   s     r;   Údtype)Úint64Úint32Úfloat64Úfloat32c                    s<  t t d¡d t d¡| d�}t d¡}tj d¡ |¡ | |¡}|jdd„ dd�}|D ]\}}t|ƒdksZJ ‚qZd	}t	j
t|d
�� | tj¡}W d   ƒ n1 s¨0    Y  |d dksÂJ ‚d	}t	j
t|d
�� | tj¡}W d   ƒ n1 sö0    Y  t	 ||¡ t	 || ¡ ¡ | ¡ }	d}t	j
t|d
�� | tj¡}W d   ƒ n1 �sZ0    Y  t	 |	|¡ | dd„ ¡}| dd„ ¡}
|
d dk�sžJ ‚t	 |
|¡ | |¡}d	}t	j
t|d
�� | tj¡}	W d   ƒ n1 �sê0    Y  t	j|	|dd� d}t	j
t|d
��" | tjtjg¡}W d   ƒ n1 �s@0    Y  d}tjt|d
��$ | tjtjdœ¡ W d   ƒ n1 �sˆ0    Y  ddddœ‰ d}t	j
t|d
��" | ‡ fdd„¡}W d   ƒ n1 �sÚ0    Y  |d dk�söJ ‚d}tjt|d
�� | dd„ ¡ W d   ƒ n1 �s.0    Y  d S )Né	   é   ©r)   r<   r"   c                 S   s   | d S ©NrB   r   ©Úxr   r   r   Ú<lambda>Q   ó    z)test_basic_aggregations.<locals>.<lambda>F©Ú
group_keyszusing SeriesGroupBy.mean©Úmatché   zusing SeriesGroupBy.sumc                 S   s   | |   ¡  S ©N©ÚsumrE   r   r   r   rG   f   rH   c                 S   s   | |   ¡  S rN   rO   rE   r   r   r   rG   g   rH   é   é   ©Zcheck_index_typezusing SeriesGroupBy.[mean|std]únested renamer is not supported)ÚoneÚtwoé
   é   é   ©r   rM   r"   z„Pinning the groupby key to each group in SeriesGroupBy.agg is deprecated, and cases that relied on it will raise in a future versionc                    s   ˆ | j  |  ¡  S rN   )ÚnameÚmeanrE   ©Zgroup_constantsr   r   rG   �   rH   é   zMust produce aggregated valuec                 S   s   | d S ©Nr"   r   rE   r   r   r   rG   ˆ   rH   )r   r4   r5   ÚrandomÚdefault_rngÚshuffleÚreindexr0   Úlenr6   Úassert_produces_warningÚFutureWarningÚ	aggregater\   ÚaggÚassert_series_equalrP   ÚapplyÚ	transformr3   ÚpytestÚraisesr   Ú	Exception)r<   Údatar)   ÚgroupedÚkÚvÚmsgÚaggedr   r   ÚtransformedZvalue_groupedr   r]   r   Útest_basic_aggregationsI   sZ    

**,
,24ÿ2rv   c                 C   sj   | j jd }|  |¡}| ¡ }|  | d¡¡ ¡ }|j jtjksDJ ‚|j jtjksVJ ‚t	j
||dd� d S )Nr   ÚOFrS   )r)   Úcodesr0   rP   Úastyper<   r4   Úint8r=   r6   r7   )Ú multiindex_dataframe_random_datar   rp   r   r   r   r   r   Útest_groupby_nonobject_dtype‹   s    
r|   c                  C   s¶   t g d¢g d¢tj d¡ d¡tjtj d¡ d¡dd�dœƒ} tt| ƒƒ| d< d	d
„ }d}tj	t
|d��  |  d¡ |¡}W d   ƒ n1 s�0    Y  |j}| j}t ||¡ d S )N©ÚfooÚbarr~   r   r~   r   r~   r~   )rU   rU   rV   ÚthreerV   rV   rU   r€   r"   é   r@   ©r<   ©r   r   r&   ÚDÚvaluec                 S   s   | j | d  ¡  S )Nr…   )ÚlocÚidxmax©Úgroupr   r   r   Ú	max_value¢   s    z5test_groupby_nonobject_dtype_mixed.<locals>.max_valueú7DataFrameGroupBy.apply operated on the grouping columnsrK   r   )r   r4   r`   ra   Ústandard_normalÚarrayr2   rd   r6   re   ÚDeprecationWarningr0   rj   Údtypesri   )r9   rŠ   rs   Zappliedr   r   r   r   r   Ú"test_groupby_nonobject_dtype_mixed–   s    üÿ.r�   c            
      C   s~  t g d¢tt d¡dd�tddd�dœƒ} dd	„ }|  d
¡ ¡ dg }d}tjt	|d��& |  d
¡ 
|¡dg }W d   ƒ n1 s„0    Y  t ||¡ dd„ }d}tjt	|d��& |  d
¡ 
|¡dg }W d   ƒ n1 sà0    Y  | ¡ }tj|jd< t ||¡ dd„ }d}tjt	|d��& |  d
¡ 
|¡dg }W d   ƒ n1 �sR0    Y  | ¡ }tj|jd< t ||¡ dd„ }d}tjt	|d��& |  d
¡ 
|¡dg }W d   ƒ n1 �sÄ0    Y  |  d
¡ ¡ dg }tj|jd< t ||¡ dd„ }	d}tjt	|d��  |  d
¡ 
|	¡}W d   ƒ n1 �s<0    Y  |  d
¡ ¡ d  ¡ }tj|jd< d |_t ||¡ d S )N)ÚTigerr‘   r‘   ÚLambr’   ÚPonyr“   rQ   r=   r‚   Z20130101r   r*   c                 S   s
   | j d S ©Nr   )r/   ©Úgrpr   r   r   Úf_0¸   s    z*test_inconsistent_return_type.<locals>.f_0r   r   r‹   rK   c                 S   s   | j dkrd S | jd S )Nr‘   r   ©r[   r/   r•   r   r   r   Úf_1Á   s    
z*test_inconsistent_return_type.<locals>.f_1r‘   c                 S   s   | j dkrd S | jd S ©Nr“   r   r˜   r•   r   r   r   Úf_2Í   s    
z*test_inconsistent_return_type.<locals>.f_2r“   c                 S   s   | j dkrd S | jd S rš   r˜   r•   r   r   r   Úf_3Ú   s    
z*test_inconsistent_return_type.<locals>.f_3r&   c                 S   s   | j dkrd S | jd jd S )Nr“   r   r&   )r[   r/   r†   r•   r   r   r   Úf_4ç   s    
z*test_inconsistent_return_type.<locals>.f_4)r   r   r4   r5   r   r0   Úfirstr6   re   rŽ   rj   r7   r-   Únanr†   r+   r.   r[   ri   )
r9   r—   r   rs   r   r™   Úer›   rœ   r�   r   r   r   Útest_inconsistent_return_type­   sR    
ýÿ44660r¡   c              	   C   sà  ddd„}dd„ }|   dd„ ¡}|jtjddd�}|jtjddd�}|jtjddd�}| d	¡}| |¡}	t ||¡ t ||¡ t ||	¡ |j|dd
�}|j|dd
�}|j|dd
�}t ||¡ t ||¡ t ||	¡ dD �]ø}
|j dd„ |
d�}|
�rd nt	}d}tj
||d��" |jtjddd�}W d   ƒ n1 �sB0    Y  tj
||d�� | tjd	¡}W d   ƒ n1 �s€0    Y  tj
||d�� | d	¡}W d   ƒ n1 �sº0    Y  tj||dd� t ||¡ | tjdd	g¡}tj
||d�� | dd	g¡}W d   ƒ n1 �s&0    Y  tj||dd� tj
||d�� |j|dd
�}W d   ƒ n1 �st0    Y  tj
||d��  |jtjd	d
�}W d   ƒ n1 �s´0    Y  t ||¡ tj||dd� qàd S )Nr   c                 S   s   t j| ||d�S )N©Úaxis©r4   Ú
percentile)rF   Úqr£   r   r   r   Úfö   s    z test_pass_args_kwargs.<locals>.fc                 S   s   t j| ddd�S )NéP   r   r¢   r¤   rE   r   r   r   rG   ù   rH   z'test_pass_args_kwargs.<locals>.<lambda>c                 S   s   | j S rN   ©ÚmonthrE   r   r   r   rG   ü   rH   r¨   r¢   çš™™™™™é?©r¦   )TFc                 S   s   | j S rN   r©   rE   r   r   r   rG     rH   ©Úas_indexú*A grouping .* was excluded from the resultrK   F©Zcheck_namesgš™™™™™Ù?)Nr   )r0   rh   r4   r¥   rj   rk   Úquantiler6   ri   rf   re   r   r7   )ÚtsÚtsframer§   ÚgZ
ts_groupedZ
agg_resultZapply_resultZtrans_resultZagg_expectedZtrans_expectedr®   Ú
df_groupedÚwarnrs   r   Zexpected_seqr   r   r   Útest_pass_args_kwargsõ   sN    



2.*..0r·   r®   TFc                 C   sÆ   g d¢| _ | jdd„ |d�}|r$d nt}d}tj||d��" |jtjddd	�}W d   ƒ n1 sb0    Y  | | jj	d
k  
d¡| | jj	dk  
d¡dœ}t|ƒj}|s¶ttdƒƒ|_t ||¡ d S )N)r   r   r   r&   c                 S   s   | j S rN   r©   rE   r   r   r   rG   .  rH   z9test_pass_args_kwargs_duplicate_columns.<locals>.<lambda>r­   r¯   rK   r¨   r   r¢   rM   r«   r"   ©rM   r"   )Úcolumnsr0   rf   r6   re   rh   r4   r¥   r)   rª   r±   r   ÚTr
   r2   r7   )r³   r®   r:   r¶   rs   ÚresZex_datar   r   r   r   Ú'test_pass_args_kwargs_duplicate_columns*  s    
0þ
r¼   c                  C   s    t tj d¡ d¡ttdƒtd�tdddd�d	�} |  	d
d„ dd„ dd„ g¡}t
|ƒt
| ƒksbJ ‚|  	dd„ dd„ g¡}t
dd„ | jD ƒƒ}t
|ƒ|ksœJ ‚d S )Nr"   ©rW   é   ÚABCDr‚   ú
2000-01-01rW   r   ©r    Úfreq©r¹   r)   c                 S   s   | j S rN   ©ÚyearrE   r   r   r   rG   G  rH   ztest_len.<locals>.<lambda>c                 S   s   | j S rN   r©   rE   r   r   r   rG   G  rH   c                 S   s   | j S rN   ©ÚdayrE   r   r   r   rG   G  rH   c                 S   s   | j S rN   rÄ   rE   r   r   r   rG   J  rH   c                 S   s   | j S rN   r©   rE   r   r   r   rG   J  rH   c                 S   s   h | ]}|j |jf’qS r   )rÅ   rª   ©Ú.0rF   r   r   r   Ú	<setcomp>K  rH   ztest_len.<locals>.<setcomp>)r   r4   r`   ra   rŒ   r
   r1   Úobjectr   r0   rd   r)   )r9   rp   r   r   r   r   Útest_lenA  s    ýrÌ   c                  C   sd   t tjgd g d¢dœƒ} t|  d¡ƒdks0J ‚t|  d¡ƒdksFJ ‚t|  ddg¡ƒdks`J ‚d S )NrB   ©rM   r"   rB   ©ÚaÚbrÏ   r   rÐ   )r   r4   rŸ   rd   r0   ©r9   r   r   r   Útest_len_nan_groupO  s    rÒ   c                  C   sT   t dd„ ttddƒƒd D ƒƒ} tj d¡ d¡d }t |ƒ}|  |¡}| ¡  d S )Nc                 S   s   g | ]}d | ‘qS )ç      ð?r   rÈ   r   r   r   Ú
<listcomp>Y  rH   z)test_basic_regression.<locals>.<listcomp>rM   rW   r"   iL  g      $@)r   r1   r2   r4   r`   ra   r0   r\   )r   ro   Ú	groupingsrp   r   r   r   Útest_basic_regressionW  s
     
rÖ   )r?   r@   r=   r>   Zint16rz   c                 C   s¸   t t d¡ƒ}tt d¡|| d�}ttjdddtjtjddtjdg
|d�}| |¡}| t¡}tddgddgd�}t	j
||dd	� d
d„ }| |¡}tddgddgd�}t	 
||¡ d S )NrW   r‚   r~   r   r(   r¾   r"   F©Zcheck_dtypec                 S   s   t t| ƒƒS rN   )Úfloatrd   rE   r   r   r   r§   w  s    ztest_with_na_groups.<locals>.fç      @ç       @)r
   r4   r5   r   ÚonesrŸ   r0   rh   rd   r6   ri   )r<   r)   ÚvaluesÚlabelsrp   rt   r   r§   r   r   r   Útest_with_na_groupsb  s    þ


rÞ   c            	   	   C   s  dd„ } dd„ }dd„ }t g d¢tdƒtd	d
ƒdœƒ}t g d¢tdƒtd	d
ƒdœƒ}d}d}tjt|d��  | d¡ | ¡}W d   ƒ n1 s�0    Y  tjt|d��  | d¡ | ¡}W d   ƒ n1 sÎ0    Y  t ||¡ d}tj	t
|d��  | d¡ |¡ W d   ƒ n1 �s0    Y  tj	t
|d��  | d¡ |¡ W d   ƒ n1 �s^0    Y  tj	t
|d��  | d¡ |¡ W d   ƒ n1 �sž0    Y  tj	t
|d��P tjt|d��  | d¡ |¡ W d   ƒ n1 �sî0    Y  W d   ƒ n1 �s0    Y  d S )Nc                 S   sb   | | j d dk d }|jrLtg gd g gd ddgd�}tdg|d�}|S | ddg¡}|S d S )Nr"   rM   rÐ   Úc©Zlevelsrx   ÚnamesrÏ   rÃ   )rÐ   Úemptyr   r   Ú	set_index©rF   ÚyÚ
multiindexr»   r   r   r   Úf1ƒ  s    z,test_indices_concatenation_order.<locals>.f1c                 S   s8   | | j d dk d }|jr"tƒ S | ddg¡}|S d S )Nr"   rM   rÐ   rß   )rÐ   râ   r   rã   )rF   rå   r   r   r   Úf2�  s
    z,test_indices_concatenation_order.<locals>.f2c                 S   sV   | | j d dk d }|jrNtg gd g gd ddgd�}tddg|d�}|S |S d S )	Nr"   rM   r~   r   rà   rÏ   rÐ   rÃ   )rÐ   râ   r   r   rä   r   r   r   Úf3•  s    ÿz,test_indices_concatenation_order.<locals>.f3)rM   r"   r"   r"   r¾   r!   rA   ©rÏ   rÐ   rß   )rB   r"   r"   r"   zDThe behavior of array concatenation with empty entries is deprecatedr‹   rK   rÏ   z@Cannot concat indices that do not have the same number of levels)r   r2   r6   re   rŽ   r0   rj   r7   rl   rm   ÚAssertionErrorrf   )	rç   rè   ré   r9   Údf2Údepr_msgrs   Úresult1Úresult2r   r   r   Ú test_indices_concatenation_order€  s,    
..000rð   c                 C   s¼   |   dd„ ¡}| ¡ }| dd„ ¡}t ||¡ | ¡ }dd„ |D ƒ}t|ƒj}t ||¡ |j	}| dd„ ¡}t ||¡ d}t
jt|d�� t|d	ƒ W d   ƒ n1 s®0    Y  d S )
Nc                 S   s   |   ¡ S rN   ©ÚweekdayrE   r   r   r   rG   ¾  rH   z#test_attr_wrapper.<locals>.<lambda>c                 S   s   t j| dd�S )NrM   )Zddof)r4   r3   rE   r   r   r   rG   Á  rH   c                 S   s   i | ]\}}||  ¡ “qS r   )Údescribe)rÉ   r[   Úgpr   r   r   Ú
<dictcomp>Æ  rH   z%test_attr_wrapper.<locals>.<dictcomp>c                 S   s   | j S rN   r‚   rE   r   r   r   rG   Ì  rH   z-'SeriesGroupBy' object has no attribute 'foo'rK   r~   )r0   r3   rh   r6   ri   ró   r   rº   r7   r<   rl   rm   ÚAttributeErrorÚgetattr)r²   rp   r   r   rs   r   r   r   Útest_attr_wrapper½  s    
rø   c                 C   sn  |   dd„ ¡}| d¡}t|ƒdks(J ‚t|jƒdks:J ‚|  ¡ }dd„ |jD ƒ|d< |  d¡ d¡}tj||d	d
� |  d¡  dd„ ¡}| 	dd„ ¡}t|ƒdks¨J ‚t|jƒdksºJ ‚| 	dd„ ¡}|D ]2\}}| 
¡ }|jD ]}	tj| |	¡|d	d
� qâqÌ|D ]"\}
}|jd  ¡ |
k�sJ ‚�q|j}|j}| ¡ D ],\}}| j || ¡}||k ¡ �s<J ‚�q<d S )Nc                 S   s   |   ¡ S rN   rñ   rE   r   r   r   rG   Ö  rH   z$test_frame_groupby.<locals>.<lambda>r\   r!   r¾   c                 S   s   g | ]}|  ¡ ‘qS r   rñ   rÈ   r   r   r   rÔ   ß  rH   z&test_frame_groupby.<locals>.<listcomp>rò   Fr°   rY   c                 S   s   |   ¡ S rN   rñ   rE   r   r   r   rG   ä  rH   c                 S   s   | |   ¡  S rN   ©r\   rE   r   r   r   rG   å  rH   c                 S   s   |   ¡ S rN   rù   rE   r   r   r   rG   ê  rH   r   )r0   rg   rd   r¹   r-   r)   r6   r7   Úheadrk   r\   ri   Zxsrò   ÚgroupsÚindicesÚitemsÚtakeÚall)r³   rp   Ú
aggregatedZtscopyZstraggedru   r[   r‰   r\   Úidxrò   rû   rü   rq   rr   Z	samethingr   r   r   Útest_frame_groupbyÕ  s0    

r  c           	      C   s  dddddœ}d}t jt|d�� | j|dd�}W d   ƒ n1 sD0    Y  | d¡}t|ƒt| ƒkslJ ‚t|jƒdks~J ‚d	d
„ }d}t jt|d��  | jj|dd�}W d   ƒ n1 s¾0    Y  t  | 	|¡j| 	|¡¡ |D ]\}}t|jƒdksæJ ‚qæd S )Nr   rM   rƒ   ú+DataFrame.groupby with axis=1 is deprecatedrK   r¢   r\   r"   c                 S   s   | |   ¡  S rN   rù   rE   r   r   r   rG   	  rH   z,test_frame_groupby_columns.<locals>.<lambda>ú5The 'axis' keyword in DataFrame.groupby is deprecated)
r6   re   rf   r0   rg   rd   r¹   rº   r7   rk   )	r³   Úmappingrs   rp   r   ÚtfZgroupedTrq   rr   r   r   r   Útest_frame_groupby_columnsý  s    ,
.r  c                 C   s6  |   d¡}|jdd�}|jjdks&J ‚| j ddd�jdd�}|jjdksLJ ‚|ddg  d¡}|jjdksnJ ‚| dd	d
œ¡}|jjdksŽJ ‚|d  ¡ }|jjdksªJ ‚|d  d¡}|jjdksÈJ ‚|d  dd	g¡}|jjdksêJ ‚d}tjt|d��$ |d  dd	dœ¡ W d   ƒ n1 �s(0    Y  d S )Nr   T©Únumeric_onlyFr­   r&   r„   r\   r3   ©r&   r„   rT   rK   ©r~   r   )r0   r\   r)   r[   rh   rl   rm   r   )r9   rp   r   rs   r   r   r   Útest_frame_set_name_single  s$    
r  c                 C   sÚ   | d }| d }|   |j|jg¡}|jdd�}|   ddg¡ ¡ }tj|jd d …ddgf |jd d …ddgf dd� ttj 	d	¡ 
d
¡tj 	d	¡ 
d
¡t g d¢¡t g d¢¡dœg d¢d�} |   ddg¡}| d¡ d S )Nr   r   Tr  r&   r„   Fr°   r"   é   ©rÐ   rÐ   rÐ   rÏ   rÏ   rÏ   ©Ú1r  r  Ú2r  r  )Úv1Úv2Úk1Úk2)rU   rV   r€   ÚfourÚfiveÚsixr(   r  r  rP   )r0   Úgetr\   r6   r7   r†   r   r4   r`   ra   rŒ   r�   rh   )r9   Úcol1Úcol2rp   rt   r   r   r   r   Útest_multi_func/  s$    *ÿüù
r  c                 C   sJ   |   ddg¡d }| ddg¡}t| d¡| d¡dœƒ}t ||¡ d S )Nr   r   r&   r\   r3   )r\   r3   )r0   rh   r   r6   r7   )r9   rp   rt   r   r   r   r   Ú!test_multi_key_multiple_functionsK  s    r  c                  C   sÎ   t g d¢g d¢tj d¡ d¡tj d¡ d¡tj d¡ d¡dœƒ} |  ddg¡}dd	g}| |¡}tj|d
  |¡|d  |¡|d  |¡gg d¢dd�}t	|j
tƒs®J ‚t	|j
tƒs¾J ‚t ||¡ d S )N©r~   r~   r~   r~   r   r   r   r   r~   r~   r~   ©rU   rU   rU   rV   rU   rU   rU   rV   rV   rV   rU   r"   é   )r   r   r„   ÚEÚFr   r   r\   r3   r„   r!  r"  )r„   r!  r"  rM   )Úkeysr£   )r   r4   r`   ra   rŒ   r0   rh   r+   ÚconcatÚ
isinstancer)   r   r6   r7   )ro   rp   Úfuncsrt   r   r   r   r   Ú"test_frame_multi_key_function_listS  s&    ãÿ"
&ýr'  c               	   C   s¨   t g d¢g d¢g d¢tj d¡ d¡tj d¡ d¡tj d¡ d¡dœƒ} |  ddg¡}d	d
g}t d¡}tj	t
|d�� | |¡ W d   ƒ n1 sš0    Y  d S )Nr  r  )Údullr(  Úshinyr(  r(  r)  r)  r(  r)  r)  r)  r"   r   )r   r   r&   r„   r!  r"  r   r   r\   r3   ú&agg function failed [how->mean,dtype->rK   )r   r4   r`   ra   rŒ   r0   ÚreÚescaperl   rm   Ú	TypeErrorrh   )ro   rp   r&  rs   r   r   r   Ú2test_frame_multi_key_function_list_partial_failureƒ  s    Öÿ/
r.  Úopc                 C   s   |   ¡ S rN   rO   rE   r   r   r   rG   º  rH   rG   c                 C   s   |   ¡ S rN   rù   rE   r   r   r   rG   º  rH   c              	   C   s"  | }|  ddg¡}||ƒ}g }g }|  d¡D ]J\}}|  d¡D ]6\}	}
| ||	f¡ | ||
jd d …ddgf ƒ¡ q>q,tj|ddgd�}tj|dd�j}||_dD ]8}||| ƒ}|| }|| }t	 
||¡ t	 
||¡ q¤|d   |d |d g¡ ¡ }|  ddg¡ ¡ d }t	 
||¡ d S )	Nr   r   r&   r„   ©rá   rM   r¢   r
  )r0   Úappendr†   r   Úfrom_tuplesr+   r$  rº   r)   r6   ri   r\   )r9   r/  ro   rp   rî   r#  rÜ   Zn1Zgp1Zn2Zgp2Úmir   ÚcolZ
result_colZpivotedÚexpr   r   r   r   Útest_groupby_multiple_columnsº  s*    $r6  c                  C   s    t ddgddgddggddgd�} | jdd	d
�d  d¡}tddgdd�}t ||¡ | jdd	dd�d  dd„ ¡}tg d¢dt g d¢¡d�}t ||¡ d S )NrM   r"   r¾   r!   r  r   r   ©r¹   Fr­   ©r[   T)r®   rJ   c                 S   s   |   ¡ S rN   )ÚcumsumrE   r   r   r   rG   ã  rH   z-test_as_index_select_column.<locals>.<lambda>)r"   r  r  ))r   r   )r   rM   r¸   ©r[   r)   )	r   r0   Ú	get_groupr   r6   ri   rj   r   r2  ©r9   r   r   r   r   r   Útest_as_index_select_columnÛ  s    "ÿÿr=  c                  C   s„   d} t g d¢g d¢dœƒ}|j| d¡j d¡ }tjt| d��0 | d¡jd|d�}t 	||¡ W d   ƒ n1 sv0    Y  d S )	Nzobj is deprecated©rM   rM   r"   ©rB   r¾   r!   rÎ   rÐ   r¾   rK   )Úobj)
r   r/   r0   rü   r  r6   re   rf   r;  r7   )rí   r9   r   r   r   r   r   Ú!test_obj_arg_get_group_deprecatedë  s    rA  c                  C   sd   t tg d¢dd�d�} | jddd�d jdd	�}t | jd d
… tdƒd�}d g|j_t ||¡ d S )Nr*   Úalphar8  r7  r   F)Úbyr®   r   r  r"   r   rÃ   )	r   r
   r0   rP   r¹   r2   rá   r6   r7   )r9   Úleftr   r   r   r   Ú0test_groupby_as_index_select_column_sum_empty_dfõ  s
    
rE  c                 C   sÔ  | j ddd�}|ddg  d¡}|jdd�}t ||¡ | dd	d
œ¡}|jdd�}| ¡ d |d< t ||¡ | j ddd�}d}tjt|d��" |d  dd	i¡ W d   ƒ n1 s¸0    Y  | j ddgdd�}| d¡}| ¡ }t ||¡ | dd	d
œ¡}| ¡ }| ¡ d |d< t ||¡ |d  ¡ }t	|ƒj
ddid�}d}tjt|d��" |d  dd	i¡}W d   ƒ n1 �s‚0    Y  t ||¡ t	tj d¡ ddd¡g d¢d�} ttj d¡ ddd¡dd�}	|   |	¡}
|
 d¡ d}tjt|dd�� |
 t¡}W d   ƒ n1 �s"0    Y  tjt|dd��  |   |	¡ t¡}W d   ƒ n1 �sd0    Y  t ||¡ dD ]P}| j |	dd�}
t|
|ƒƒ }| j |	jdd�}
t|
|ƒƒ jdd�}t ||¡ �q~d S )Nr   Fr­   r&   r„   r\   Tr  rP   r
  rT   rK   ÚQr   r7  z7Passing a dictionary to SeriesGroupBy.agg is deprecatedr"   r   éd   )é2   rB   )ÚjimZjoeZjolier!   rW   rH  rI  r8  z:The behavior of DataFrame.sum with axis=None is deprecated)rL   Zcheck_stacklevel)r\   ÚmaxÚcountr‡   r9  rÿ   ©Údrop)r0   rh   r\   r6   r7   rP   rl   rm   r   r   Úrenamere   rf   r4   r`   ra   Úintegersr   Únthrj   r÷   rÜ   Úreset_index)r9   rp   r   r   rï   Ú	expected2rs   Z	expected3Zresult3r²   Úgrr»   ZaltÚattrrD  Úrightr   r   r   Útest_groupby_as_index_agg   sZ    0
2þ

*0rV  c                 C   sþ   | dv rt  d| › �¡ ttj d¡jdddd�dd	gd
�}t| d¡| ƒƒ }| dkr`| 	d¡}| 
¡ }| dkrˆ|d  |d j¡|d< |jddd�}t|| ƒƒ }t ||¡ | | ¡}t ||¡ t|d	 | ƒƒ }t ||¡ |d	  | ¡}t ||¡ d S )N)ZcorrwithrP  Úngroupz!GH 5755: Test not applicable for r"   r   r!   )rG  r"   )ÚsizerÏ   rÐ   r7  rX  Fr­   )rl   Úskipr   r4   r`   ra   rO  r÷   r0   rN  rQ  ry   r<   r6   r7   rh   )Zreduction_funcr9   r   r´   r   r   r   r   Útest_ops_not_as_indexC  s(    ÿ

rZ  c                 C   s.  | j ddd�}| j ddgdd�}|d  d¡}| d¡jd d …ddgf }t|tƒsXJ ‚t ||¡ |d  d¡}| d¡jd d …g d¢f }t|tƒsœJ ‚t ||¡ |d  ¡ }| ¡ jd d …ddgf }t|tƒsÜJ ‚t ||¡ |d  ¡ }| ¡ jd d …g d¢f }t|tƒ�sJ ‚t ||¡ d S )Nr   Fr­   r   r&   rP   r*   )r0   rh   r†   r%  r   r6   r7   rP   )r9   rp   Zgrouped2r   r   rï   rR  r   r   r   Ú!test_as_index_series_return_framee  s$    r[  c                 C   sR   | j ddd�}d}tjt|d�� |d  d¡ W d   ƒ n1 sD0    Y  d S )Nr   Fr­   zColumn\(s\) C already selectedrK   r&   r„   )r0   rl   rm   Ú
IndexErrorÚ__getitem__)r9   rp   rs   r   r   r   Ú(test_as_index_series_column_slice_raises~  s    r^  c                 C   sÚ   | }|j ddd�}|jdd�}|  dg¡jdd�}| dd|j¡ tt|ƒƒ|_t ||¡ |j ddgdd�}| ¡ }|  ddg¡ ¡ }tt	|jj
Ž ƒ}| dd|d ¡ | dd|d ¡ tt|ƒƒ|_t ||¡ d S )	Nr   Fr­   Tr  r   r   rM   )r0   r\   Úinsertr)   r   rd   r6   r7   r1   ÚziprÜ   )r9   ro   rp   r   r   Zarraysr   r   r   Útest_groupby_as_index_cython‡  s    ra  c                 C   sL   | j ddgdd�}|d  t¡}| t¡jd d …g d¢f }t ||¡ d S )Nr   r   Fr­   r&   r*   )r0   rh   rd   r†   r6   r7   ©r9   rp   r   r   r   r   r   Ú#test_groupby_as_index_series_scalarž  s    rc  c              	   C   sÀ   d}t jt|d��" |jdd„ dd� W d   ƒ n1 s:0    Y  d}d}t jt|d��R tjt|d��$ | jd	d„ dd
d� W d   ƒ n1 s”0    Y  W d   ƒ n1 s²0    Y  d S )Nz(as_index=False only valid with DataFramerK   c                 S   s   |   ¡ S rN   rñ   rE   r   r   r   rG   «  rH   z.test_groupby_as_index_corner.<locals>.<lambda>Fr­   z$as_index=False only valid for axis=0r  c                 S   s   |   ¡ S rN   )ÚlowerrE   r   r   r   rG   ±  rH   rM   )r®   r£   )rl   rm   r-  r0   Ú
ValueErrorr6   re   rf   )r9   r²   rs   rí   r   r   r   Útest_groupby_as_index_corner¨  s    0rf  c                  C   s  t tj d¡ d¡ttdƒtd�tdddd�d	�} |  	d
d„ dd„ dd„ g¡}| 
¡ }t | j|j¡ d}tjt|d��2 | jj	dd„ dd„ dd„ gdd�}W d   ƒ n1 s°0    Y  | dd„ ¡}t |j| j¡ t | jj|j¡ | dd„ ¡}t | jj|j¡ d S )Nr"   r½   r¿   r‚   rÀ   rW   r   rÁ   rÃ   c                 S   s   | j S rN   rÄ   rE   r   r   r   rG   º  rH   z+test_groupby_multiple_key.<locals>.<lambda>c                 S   s   | j S rN   r©   rE   r   r   r   rG   º  rH   c                 S   s   | j S rN   rÆ   rE   r   r   r   rG   º  rH   r  rK   c                 S   s   | j S rN   rÄ   rE   r   r   r   rG   Á  rH   c                 S   s   | j S rN   r©   rE   r   r   r   rG   Á  rH   c                 S   s   | j S rN   rÆ   rE   r   r   r   rG   Á  rH   rM   r¢   c                 S   s   |   ¡ S rN   rO   rE   r   r   r   rG   Ä  rH   c                 S   s   |   ¡ S rN   rO   rE   r   r   r   rG   È  rH   )r   r4   r`   ra   rŒ   r
   r1   rË   r   r0   rP   r6   Zassert_almost_equalrÜ   re   rf   rº   rh   Úassert_index_equalr)   r¹   )r9   rp   rt   rí   r   r   r   Útest_groupby_multiple_key´  s$    ýÿ$rh  c                 C   sP   |   ¡ } tj| d< |  ddg¡ ¡ }|  ddg¡ ¡ }tj|d< t ||¡ d S )NÚbadr   r   )r-   r4   rŸ   r0   r\   r6   r7   )r9   rt   r   r   r   r   Útest_groupby_multi_cornerÌ  s    

rj  c                 C   s´  |   d¡}t d¡}tjt|d�� | d¡ W d   ƒ n1 sB0    Y  tjt|d�� | ¡  W d   ƒ n1 sx0    Y  | jd d …g d¢f } t	 
¡ | d< |   d¡}d}tjt|d�� | d¡ W d   ƒ n1 sà0    Y  tjt|d�� | ¡  W d   ƒ n1 �s0    Y  d	}tjt|d��( | j d
d
dddœdd�}W d   ƒ n1 �sd0    Y  d}tjt|d�� | dd„ ¡ W d   ƒ n1 �s¦0    Y  d S )Nr   r*  rK   r\   ©r   r&   r„   r!  z/datetime64 type does not support sum operationsrP   r  r   rM   )r   r&   r„   r!  r¢   z does not support reduction 'sum'c                 S   s   | j ddd�S )Nr   Fr  rO   rE   r   r   r   rG   ï  rH   z)test_raises_on_nuisance.<locals>.<lambda>)r0   r+  r,  rl   rm   r-  rh   r\   r†   r   ÚnowrP   r6   re   rf   )r9   rp   rs   rí   r   r   r   Útest_raises_on_nuisanceØ  s(    

(&
((8rm  Úagg_functionrJ  Úminc                 C   sv   |   d¡}t||ƒƒ }| ¡ }t| j| d dkdf |ƒƒ |jd< t| j| d dkdf |ƒƒ |jd< t ||¡ d S )Nr   r   r   )r   r   r~   )r~   r   )r0   r÷   r-   r†   r6   r7   )r9   rn  rp   r   r   r   r   r   Útest_keep_nuisance_aggò  s    
$$rp  )rP   r\   Úprodr3   ÚvarÚsemÚmedianr	  c           
      C   sä   |   d¡}d}||v r‚|s‚|dv r,t}d}nt}t d|› d�¡}tj||d��  t||ƒ|d� W d   ƒ qà1 sv0    Y  n^t||ƒ|d�}|s¨|d	kr¨g d
¢}ng d¢}t| jd d …|f   d¡|ƒ|d�}	t	 
||	¡ d S )Nr   )rr  r3   rs  r\   rq  rt  )r3   rs  z(could not convert string to float: 'one'zagg function failed [how->z,dtype->rK   r  rP   rƒ   rk  )r0   re  r-  r+  r,  rl   rm   r÷   r†   r6   r7   )
r9   rn  r	  rp   Zno_drop_nuisanceÚklassrs   r   r¹   r   r   r   r   Útest_omit_nuisance_agg   s$    
0
ÿrv  c                 C   sD   |   d¡}tjtdd�� | ¡  W d   ƒ n1 s60    Y  d S )Nr   zcould not convertrK   )r0   rl   rm   re  Úskew)r9   rp   r   r   r   Ú$test_raise_on_nuisance_python_single"  s    
rx  c                 C   sŠ   |   ddg¡}t d¡}tjt|d�� | d¡ W d   ƒ n1 sF0    Y  tjt|d�� | ¡  W d   ƒ n1 s|0    Y  d S )Nr   r   r*  rK   r\   )r0   r+  r,  rl   rm   r-  rh   r\   )Zthree_grouprp   rs   r   r   r   Ú&test_raise_on_nuisance_python_multiple)  s    
(ry  c                 C   sØ   t t g d¢¡t g d¢¡ddgd tj d¡ d¡tj d¡ d¡dœƒ}| d	d
g¡}|ddg  d¡}|jdd�}t	 
||¡ | dd… jdd�}| dd„ ¡}|d  d¡}t	 |d |¡ |jjdksÔJ ‚d S )Nr  r  r~   r   rB   r"   r  )r  r  Zk3r  r  r  r  r  r  r\   Tr  r!   r   ©r   c                 S   s   |   ¡ S rN   rù   rE   r   r   r   rG   D  rH   z*test_empty_groups_corner.<locals>.<lambda>r   rž   )r   r4   r�   r`   ra   rŒ   r0   rh   r\   r6   r7   rj   ri   r)   r[   )r{   r9   rp   r   r   rt   Zagged_Ar   r   r   Útest_empty_groups_corner2  s"    
ûÿ
r{  c                  C   sN   t dgƒ} d}tjt|d�� |  dd„ ¡ W d   ƒ n1 s@0    Y  d S )Nr   z5unsupported operand type\(s\) for \+: 'int' and 'str'rK   c                 S   s   | d S )Nr~   r   rE   r   r   r   rG   N  rH   z$test_nonsense_func.<locals>.<lambda>)r   rl   rm   r-  r0   )r9   rs   r   r   r   Útest_nonsense_funcJ  s    
r|  c                 C   sä   | j }d|d< t g d¢¡t g d¢¡g}t d¡}tjt|d��  | |¡ 	d¡ W d   ƒ n1 sh0    Y  |j
dd� |¡ 	d¡}t|jtƒsšJ ‚dd	„ }tjtd
d��  | |¡ |¡ W d   ƒ n1 sÖ0    Y  d S )NZpeekaboo)ÚbazrV   ©r   r   rM   r*  rK   r\   r7  c                 S   s   | j dkrtdƒ‚|  ¡ S )N)r~   rU   úTest error message)r[   r-  rP   )r8   r   r   r   Úaggfun\  s    
z5test_wrap_aggregated_output_multindex.<locals>.aggfunr  )rº   r4   r�   r+  r,  rl   rm   r-  r0   rh   rM  r%  r¹   r   rg   )r{   r9   r#  rs   rt   r€  r   r   r   Ú%test_wrap_aggregated_output_multindexQ  s    
.r�  c                 C   sh   | j dd� ¡ }|jjdks J ‚| j dd� ¡ }|jjdks@J ‚| d j dd� ¡ }|jjdksdJ ‚d S )Nr   rz  rž   rM   Úsecondr   )r0   rK  r)   r[   )r{   r   r   r   r   Útest_groupby_level_applye  s    rƒ  c                    sÒ   |   ¡ }dddddœ‰ ddddœ‰| jˆ dd� ¡ }| jˆdd� ¡ }tj‡ fdd„|d D ƒtjd	�}tj‡fd
d„|d D ƒtjd	�}|  |¡ ¡ }|  |¡ ¡ }d\|j_|j_t 	||¡ t 	||¡ d S )Nr   rM   )r~   r   r}  Úqux)rU   rV   r€   rz  c                    s   g | ]}ˆ   |¡‘qS r   ©r  rÈ   )Úmapper0r   r   rÔ   y  rH   z-test_groupby_level_mapper.<locals>.<listcomp>rž   r‚   c                    s   g | ]}ˆ   |¡‘qS r   r…  rÈ   )Úmapper1r   r   rÔ   |  rH   r‚  )rž   r‚  )
rQ  r0   rP   r4   r�   r=   r)   r[   r6   r7   )r{   Z	deleveledZresult0rî   Zmapped_level0Zmapped_level1Z	expected0Z	expected1r   )r†  r‡  r   Útest_groupby_level_mappero  s     ÿÿrˆ  c                  C   s.  t g d¢tg d¢dd�ƒ} t g d¢ttddƒdd�ƒ}| jdd	� ¡ }t ||¡ | jdgd	� ¡ }t ||¡ | jd
d	� ¡ }t ||¡ | jd
gd	� ¡ }t ||¡ d}tjt	|d�� | jdd	� W d   ƒ n1 sÞ0    Y  tjt	|d�� | jdd	� W d   ƒ n1 �s0    Y  d}tjt	|d�� | jg d	� W d   ƒ n1 �sZ0    Y  d}tjt	|d��  | jddgd	� W d   ƒ n1 �sž0    Y  tjt	|d��  | jddgd	� W d   ƒ n1 �sÞ0    Y  d}tjt	|d�� | jdgd	� W d   ƒ n1 �s 0    Y  d S )N)rM   r"   rB   rW   r¾   r!   rX   r  )rM   r"   rB   rM   r¾   r!   r"   r  r~   r8  )r   é   rB   r¾   r!   r  rM   rQ   r   rz  r'   z2level > 0 or level < -1 only valid with MultiIndexrK   éþÿÿÿzNo group keys passed!z*multiple levels only valid with MultiIndex)
r   r
   r2   r0   rP   r6   ri   rl   rm   re  )Úsr   r   rs   r   r   r   Útest_groupby_level_nonmulti†  s4    *,,00rŒ  c                  C   sB   t t d¡d g d¢d�} t dƒ}| jdd� ¡ }t ||¡ d S )Nr¾   ù      ð?       @)r   r   rM   rM   ©ro   r)   )r�  y      @      $@r   rz  )r   r4   r5   r0   rP   r6   ri   )rÏ   r   r   r   r   r   Útest_groupby_complex¦  s    r�  c                  C   sf   t dddœdddœdddœgƒ} |  d¡ ¡ }t dgdggtddgdd	�td
gƒd�}t ||¡ d S )Nr"   r�  rÎ   rM   ù      ð?      ð?rÐ   rÓ   ç      ø?r8  rÏ   ©r)   r¹   )r   r0   r\   r
   r6   r7   r<  r   r   r   Útest_groupby_complex_mean¯  s    ýÿ
ýr“  c                 C   s²   t dddœdddœdddœgƒ}| r(dnt}t tjg d¢tjd�tg d	¢d
d�tdg|d�d�}|jd
dd� ¡ }t 	||¡ tg d¢d
d�|_
|jd
dd� ¡ }t 	||¡ d S )NrM   r�  rÎ   r�  r¾   ústring[pyarrow_numpy])rM   rM   rM   r‚   )r�  r�  ù      ð?        rÐ   r8  rÏ   r’  F©Úsort)r•  r�  r�  T)r   rË   r4   r�   r=   r
   r0   rK  r6   r7   r)   )Úusing_infer_stringr9   r<   r   r   r   r   r   Útest_groupby_complex_numbersÁ  s"    ýÿýr™  c                  C   sj   t g d¢tg d¢ƒd�} t g d¢tg d¢ƒd�}|  |¡}| ¡ }|  | | j¡j¡ ¡ }t ||¡ d S )N)ç      @g      "ÀrÙ   g      Y@g      Àg     €K@gÍÌÌÌÌÌ@)rÏ   rÐ   rß   Údr    r§   r´   r(   )rÓ   rÓ   rÙ   rš  rš  g      @)rÏ   rÐ   r›  r§   r´   Úh)	r   r
   r0   r\   rc   r)   r  r6   ri   )Ús1Ús2rp   rt   r5  r   r   r   Ú'test_groupby_series_indexed_differentlyÙ  s    
þÿ
rŸ  c            	      C   s¾  t tg d¢g d¢gŽ ƒ} t | ¡}t g d¢¡}ttj d¡ d¡||d�}|j	dd� 
¡ }t |j|¡ d	}tjt|d
�� |j	ddd�}W d   ƒ n1 s 0    Y  | 
¡ }t |j|j¡ |j	dd� d¡}t |j|¡ |j	dd� dd„ ¡}t |j|¡ tjt|d
�� |j	ddd�}W d   ƒ n1 �s:0    Y  | dd„ ¡}t |jtddgƒ¡ t |j|j¡ | d¡\}}d|d< |j	dd�j
dd�}t |j|jd d… ¡ d S )N)r   r   r}  r}  r~   r~   r„  r„  )rU   rV   rU   rV   rU   rV   rU   rV   ))r   Úcat)r   Údog)r   r   )r   r¡  r"   )r�   r¾   r’  r   rz  r  rK   rM   )r   r£   r\   c                 S   s   |   ¡ S rN   rù   rE   r   r   r   rG     rH   z0test_groupby_with_hier_columns.<locals>.<lambda>c                 S   s
   |   d¡S )NrM   rù   rE   r   r   r   rG   
  rH   r   r   r   )r   r~   Tr  r'   )r1   r`  r   r2  r   r4   r`   ra   rŒ   r0   r\   r6   rg  r¹   re   rf   r)   rh   rj   r
   Z	sortlevel)	Ztuplesr)   r¹   r9   r   rí   r:   Zsorted_columnsÚ_r   r   r   Útest_groupby_with_hier_columnsè  sD    þÿÿ
ÿÿ,.r£  c                 C   s@   |   | d j¡}| ¡ }|   | d  d ¡¡ ¡ }t ||¡ d S )Nr   )r0   rÜ   rP   rN  r6   r7   rb  r   r   r   Útest_grouping_ndarray  s    r¤  c                  C   sl   t g d¢dd�} tg d¢g d¢g d¢g d¢g d¢d	œ| d
�}| g d¢¡}| d¡}| ¡ }t ||¡ d S )N©r   rM   r"   rB   r¾   r)   r8  )Úfoo1r¦  Zfoo2r¦  Zfoo3)Úbar1Úbar2r¨  r§  r§  )Úbaz1r©  r©  Úbaz2rª  )Úspam2Zspam3r«  Úspam1r¬  )rX   rY   é(   rH  é<   )r~   r   r}  Úspamro   r(   )r~   r   r}  r¯  r\   )r
   r   r0   rh   r\   r6   r7   )r)   ro   rp   r   r   r   r   r   Útest_groupby_wrong_multi_labels  s    ûø
r°  c                 C   s°   |   | d ¡jdd�}| j | d dd�jdd�}|jjdks@J ‚d|v sLJ ‚|   | d | d g¡ ¡ }| j | d | d gdd� ¡ }|jjdks”J ‚d|v s J ‚d|v s¬J ‚d S )Nr   Tr  Fr­   r   ©r   r   )r0   r\   r)   r[   rá   )r9   r   rï   r   r   r   Útest_groupby_series_with_name0  s    r²  c                 C   sR   |   d¡d }| ¡ jdks J ‚| ¡ jdks2J ‚dd„ }| |¡jdksNJ ‚d S )Nr   r&   c                 S   s   t  | ¡d S r_   )r4   rP   rE   r   r   r   rG   C  rH   z.test_seriesgroupby_name_attr.<locals>.<lambda>)r0   rK  r[   r\   rh   )r9   r   ZtestFuncr   r   r   Útest_seriesgroupby_name_attr=  s
    r³  c                  C   sf   t g d¢g d¢tj d¡ d¡d t d¡dœƒ} |  dg¡j ¡ }| j | j	¡ ¡ }t
 ||¡ d S )Nr}   )rU   rU   rV   rV   rV   rV   rU   rV   r"   r�   rÓ   rƒ   r   )r   r4   r`   ra   rŒ   r5   r0   r   rK  r   r6   ri   ©r9   r   r   r   r   r   Útest_consistency_nameG  s    üÿ	rµ  c                 C   s  d	dd„}dd„ }d}t jt|d��  |  d¡ |¡}W d   ƒ n1 sJ0    Y  |jjd u sdJ ‚t jt|d��" |  d¡ |d¡}W d   ƒ n1 sš0    Y  |jjdks´J ‚t jt|d��  |  d¡ |¡}W d   ƒ n1 sè0    Y  |jjd u �sJ ‚d S )
Nc                 S   s   t ddddœ|d�S )NrM   r"   rB   ©rK  r\   Z	omissionsr8  )r   )r9   r[   r   r   r   Ú	summarizeZ  s    z0test_groupby_name_propagation.<locals>.summarizec                 S   s   t ddddœ| jd d d�S )NrM   r"   rB   r¶  r   r   r8  )r   r/   rÑ   r   r   r   Úsummarize_random_name]  s    z<test_groupby_name_propagation.<locals>.summarize_random_namer‹   rK   r   Úmetrics)N)r6   re   rŽ   r0   rj   r¹   r[   )r9   r·  r¸  rs   r¹  r   r   r   Útest_groupby_name_propagationX  s    
.0.rº  c                  C   sJ   t dd„ tdƒD ƒƒ} |  d¡}| ¡ }|  | d ¡ ¡ }t ||¡ d S )Nc                 S   s   g | ]}t  d ¡‘qS )rW   )r4   r5   rÈ   r   r   r   rÔ   p  rH   z2test_groupby_nonstring_columns.<locals>.<listcomp>rW   r   )r   r2   r0   r\   r6   r7   rb  r   r   r   Útest_groupby_nonstring_columnso  s
    
r»  c                  C   sp   t g d¢gg d¢d�} t ddggddgtdgdd	�d
�}|  d¡ ¡ }t ||¡ |  d¡ ¡ }t ||¡ d S )NrZ   )r   r   r   r7  rM   r"   r   r   r   r8  rÃ   )r   r
   r0   rž   r6   r7   rP   r´  r   r   r   Útest_groupby_mixed_type_columnsw  s    "r¼  c                  C   s`   t  d¡} |  t j¡ t| d d …df ƒ}t  tdƒd¡}| |¡ tj	¡}| 
¡  ¡ s\J ‚d S )N)rG  rG  r   rW   )r4   râ   ÚfillrŸ   r   Ztiler2   r0   rh   rt  Zisnarÿ   )Úarrr@  Zindsr   r   r   r   Ú(test_cython_grouper_series_bug_noncontigƒ  s    
r¿  c                  C   sh   t dgd ƒ} ttj d¡ d¡| d d d… d�}tj d¡ ddd¡}| |¡}dd	„ }| |¡ d S )
NZ
aaaaaaaaaarG  r"   rH  r(   r   r!   c                 S   s   t ttt| jƒƒƒS rN   )rd   ÚsetÚmapÚidr)   rE   r   r   r   rG   —  rH   z5test_series_grouper_noncontig_index.<locals>.<lambda>)	r
   r   r4   r`   ra   rŒ   rO  r0   rh   )r)   rÜ   rÝ   rp   r§   r   r   r   Ú#test_series_grouper_noncontig_index�  s    $
rÃ  c                  C   s˜   t tdƒƒ} tjg d¢dd�}dd„ }dd„ }|  |¡}| |¡}|jtjksRJ ‚t|j	d	 t
ƒsfJ ‚| |¡}|jtjks€J ‚t|j	d	 t
ƒs”J ‚d S )
Nr!   )rÏ   rÐ   rß   r›  r    rw   r‚   c                 S   s   t t|  ¡ ƒƒS rN   )r   Ústrr\   rE   r   r   r   Úconvert_fastŸ  s    z>test_convert_objects_leave_decimal_alone.<locals>.convert_fastc                 S   s$   t | jjƒdksJ ‚tt|  ¡ ƒƒS r”   )rd   rÜ   Úbaser   rÄ  r\   rE   r   r   r   Úconvert_force_pure¢  s    zDtest_convert_objects_leave_decimal_alone.<locals>.convert_force_purer   )r   r2   r4   r�   r0   rh   r<   Zobject_r%  r/   r   )r‹  rÝ   rÅ  rÇ  rp   r   r   r   r   Ú(test_convert_objects_leave_decimal_alone›  s    


rÈ  c                  C   st   t g tjddd�dœƒ} | d jtjks,J ‚|  d¡ ¡ }tg dtjd�}t dtg |dd�iƒ}t	j
||d	d
� d S )Nr   r=   r‚   )rF   r2   rF   ©r[   r<   r2   rC   T)Z	by_blocks)r   r4   r5   r<   r?   r0   rž   r
   r   r6   r7   )r9   r   Z	exp_indexr   r   r   r   Ú"test_groupby_dtype_inference_empty²  s    rÊ  c                  C   sb   t dgdgdgdœƒ} |  ddg¡d  ¡ }tdgtjdgdggddgd�dd�}t ||¡ d S )	NrM   l    4;PUÑ  )rž   r‚  r…   rž   r‚  r…   r0  r8  )r   r0   rJ  r   r   Úfrom_productr6   ri   r<  r   r   r   Ú$test_groupby_unit64_float_conversion½  s    ýrÌ  c                 C   sä   |   t| d ƒ¡jdd�}|   | d ¡jdd�}tj||dd� tjtdd��* |   t| d d d… ƒ¡ W d   ƒ n1 s~0    Y  td	d
gddgt	j
 d¡ d¡dœƒ} |   ddg¡ ¡ }|   | d | d g¡ ¡ dg }d S )Nr   Tr  Fr°   z^'foo'$rK   r'   r   rM   rB   r¾   r"   )r~   r   Úvalr~   r   rÍ  )r0   r1   r\   r6   r7   rl   rm   ÚKeyErrorr   r4   r`   ra   rŒ   r<  r   r   r   Ú"test_groupby_list_infer_array_likeÉ  s    8ýÿrÏ  c                  C   st   d} t tdƒd| d�}tddgddggd	d
g|d�}| td| d�d	g¡ ¡ }| |jd	g¡ t	¡}t
 ||¡ d S )Nr‹  z2015-09-29T11:34:44-0700r"   )Ústartr    rÂ   r   rW   r   é   ZmetricrÜ   rÃ   r   )r   rÂ   )r   r   r   r0   r	   r\   rã   r)   ry   rØ   r6   r7   )rÂ   r)   r9   r   r   r   r   r   Ú$test_groupby_keys_same_size_as_indexÞ  s    
ÿrÒ  c                  C   s´   d} t tj d¡ d¡tdƒd�}tjt| d�� | 	d¡ W d   ƒ n1 sP0    Y  t tj d¡ d¡tdƒd�}tjt| d�� | 	d¡ W d   ƒ n1 s¦0    Y  d S )	Nz^'Z'$r"   )rM   r¾   r¿   r7  rK   ÚZ)r"   r¾   )
r   r4   r`   ra   rŒ   r1   rl   rm   rÎ  r0   )rs   Zdf1rì   r   r   r   Útest_groupby_one_rowë  s    ÿ(ÿrÔ  c                  C   sÌ  t tj d¡ d¡tjtdƒtjtdƒtjtdƒtjtdƒgtjdtjdtjdtjdgdœƒ} |  d¡}td	d
gƒtddgƒg}t	|j
 ¡ ƒ}t|ƒdksžJ ‚t||ƒD ]\}}t |j
| |¡ q¨t |jjd j| ¡ |jdksèJ ‚tdƒtjd	d
gtjd�tdƒtjddgtjd�i}|jD ]}t |j| || ¡ �q"t | tdƒ¡| jd	d
g ¡ t | tdƒ¡| jddg ¡ tjtdd�� | tj¡ W d   ƒ n1 �s²0    Y  t tjtjtjgtjtjtjgdœƒ}|d j dk�söJ ‚|d j dk�s
J ‚dD ]¸}| |¡}|j
i k�s,J ‚|jdk�s<J ‚|ji k�sLJ ‚tjtdd�� | tj¡ W d   ƒ n1 �s~0    Y  tjtdd�� | tj¡ W d   ƒ n1 �sº0    Y  �qd S )Nr"   r�   z
2013-01-01z
2013-02-01rÏ   rÐ   )rÜ   ÚdtrÄ  rÕ  rM   rQ   rB   r!   r   z2013-01-01 00:00:00r‚   z2013-02-01 00:00:00z^NaT$rK   )rŸ   ÚnatrŸ   r?   rÖ  zdatetime64[ns]z^nan$)!r   r4   r`   ra   rŒ   rŸ   r   r0   r
   Úsortedrû   r#  rd   r`  r6   rg  r7   Ú_grouperrÕ   r@  Zngroupsr�   Zintprü   Úassert_numpy_array_equalr;  r/   rl   rm   rÎ  r+   r.   r<   )r9   rp   r   r#  rq   r    Znan_dfr   r   r   r   Útest_groupby_nat_excludeú  sZ    ø
ôÿ
þ
  , ÿ
,rÚ  c                  C   sD   t tjtjgtjtjgddgdœƒ} |  ddg¡j}|i ks@J ‚d S )NrM   r"   rê   rÏ   rÐ   )r   r4   rŸ   r0   rü   ©r9   r   r   r   r   Ú#test_groupby_two_group_keys_all_nan9  s    $rÜ  c                  C   s�   t tdƒd�} ddg| d< ddg| d< ddg| d	< d
dg| d< |  dg¡jdd�}t ddgddgg¡}t |jt	dd	gƒ¡ t 
|j|¡ d S )Nr"   r(   Úg1Úg2r‰   r   ZzerosrM   rÛ   Úl1Úl2ÚlabelTr  ç        rÓ   )r   r2   r0   r\   r4   r�   r6   rg  r¹   r
   rÙ  rÜ   )r›  ÚtmpZ
res_valuesr   r   r   Útest_groupby_2d_malformed@  s    rä  c                  C   sŠ   t  t  d¡t  d¡t  d¡f¡} t  d¡}t|| || t j d¡ d¡dœƒ}| g d¢¡ ¡ }| g d¢¡ ¡ }t	|ƒt	|ƒks†J ‚d S )Nr   iˆ  i¨a  r"   )r   r   r&   r„   r!  rƒ   )r„   r&   r   r   )
r4   Zconcatenater5   r   r`   ra   rŒ   r0   rP   rd   )r   r   r9   rD  rU  r   r   r   Útest_int32_overflowL  s    "
ûÿ
rå  c                  C   sz  t g d¢g d¢g d¢tj d¡ d¡dœƒ} dd„ | g d	¢ jD ƒ}t |¡}| jg d	¢d
d� 	¡ }t
 |jj|g d¢ ¡ dd„ | g d¢ jD ƒ}t |¡}| jg d¢d
d� 	¡ }t
 |jj|¡ dd„ | g d¢ jD ƒ}t |¡}| jg d¢d
d� 	¡ }t
 |jj|g d¢ ¡ t g d¢g d¢tj d¡ d¡dœƒ} |  ddg¡d }| 	¡ }dd„ fdd„}|| |ddgdƒ d S )N©r~   r   r}  )rB   r"   rM   rZ   r"   rB   ©rÏ   rÐ   rß   r›  c                 S   s   g | ]}t |ƒ‘qS r   ©Útuple©rÉ   Úrowr   r   r   rÔ   h  rH   z+test_groupby_sort_multi.<locals>.<listcomp>rê   Tr–  )rM   r"   r   c                 S   s   g | ]}t |ƒ‘qS r   rè  rê  r   r   r   rÔ   m  rH   )rß   rÏ   rÐ   c                 S   s   g | ]}t |ƒ‘qS r   rè  rÈ   r   r   r   rÔ   r  rH   )rÐ   rß   rÏ   )r"   rM   r   ©r   rM   r"   r   rM   r"   )r   r   r   rM   rM   rM   r  )rÏ   rÐ   r›  rÏ   rÐ   r›  c                 S   s   |   ¡ S rN   rO   rE   r   r   r   rG   �  rH   z)test_groupby_sort_multi.<locals>.<lambda>c           	      S   sV   dd„ | | j D ƒ}t |¡}||  |¡| ƒ}| ¡ D ]\}}|| |ks8J ‚q8d S )Nc                 S   s   g | ]}t |ƒ‘qS r   rè  rê  r   r   r   rÔ   ‚  rH   zCtest_groupby_sort_multi.<locals>._check_groupby.<locals>.<listcomp>)rÜ   ÚcomÚasarray_tuplesafer0   rý   )	r9   r   r#  Úfieldr§   Útupsr   rq   rr   r   r   r   Ú_check_groupby�  s
    
z/test_groupby_sort_multi.<locals>._check_groupby)r   r4   r`   ra   rŒ   rÜ   rí  rî  r0   rP   r6   rÙ  r)   )r9   rð  r   rp   rñ  r   r   r   Útest_groupby_sort_multi^  s:    üÿ	


ýÿrò  c                  C   st   t g d¢g d¢d dœƒ} d}tjt|d��( | jddd	� d
d„ ¡}W d   ƒ n1 sZ0    Y  t || ¡ d S )N)rÏ   rÏ   rÏ   rÐ   rÐ   rÐ   ræ  r"   )r   r[   r‹   rK   r   FrI   c                 S   s   | S rN   r   rE   r   r   r   rG   ’  rH   z/test_dont_clobber_name_column.<locals>.<lambda>)r   r6   re   rŽ   r0   rj   r7   )r9   rs   r   r   r   r   Útest_dont_clobber_name_column‹  s    ÿ6ró  c                  C   sÂ   t tj d¡ d¡ttdƒtd�tdddd�d	�} | j	d
d„ dd�}| 
dd„ ¡}dd„ |D ƒ}t |¡}t ||¡ | d j	dd„ dd�}| 
dd„ ¡}dd„ |D ƒ}t |¡}t ||¡ d S )Nr"   r½   r¿   r‚   rÀ   rW   r   rÁ   rÃ   c                 S   s   | j S rN   r©   rE   r   r   r   rG   �  rH   z&test_skip_group_keys.<locals>.<lambda>FrI   c                 S   s   | j dd�d d… S )Nr   ©rC  rB   ©Úsort_valuesrE   r   r   r   rG   ž  rH   c                 S   s$   g | ]\}}|j d d�dd… ‘qS )r   rô  NrB   rõ  ©rÉ   r   r‰   r   r   r   rÔ      rH   z(test_skip_group_keys.<locals>.<listcomp>r   c                 S   s   | j S rN   r©   rE   r   r   r   rG   ¥  rH   c                 S   s   |   ¡ d d… S rD   rõ  rE   r   r   r   rG   ¦  rH   c                 S   s    g | ]\}}|  ¡ d d… ‘qS rD   rõ  r÷  r   r   r   rÔ   ¨  rH   )r   r4   r`   ra   rŒ   r
   r1   rË   r   r0   rj   r+   r$  r6   r7   ri   )Ztsfrp   r   Úpiecesr   r   r   r   Útest_skip_group_keys–  s    ý

rù  c                 C   s8   | d   ¡ }d |_| | d ¡ d¡}|jd u s4J ‚d S )Nr&   r   rP   )r-   r[   r0   rh   )Zfloat_framer‹  r   r   r   r   Útest_no_nonsense_name®  s    rú  c                  C   s\   t t d¡ dd¡ƒ} d| d< g d¢| d< |  d¡}| ddd	œ¡}|d jtjksXJ ‚d S )
NrA   rB   r   Útest)gÍÌÌÌÌÌô?r‘  gš™™™™™ù?ÚflrP   rX  )rü  r"   )r   r4   r5   Úreshaper0   rh   r<   r?   )rF   rp   r   r   r   r   Útest_multifunc_sum_bug·  s    
rþ  c                 C   sV   dd„ }dd„ }|   d¡d  |¡}|   d¡d  |¡}t|tƒsFJ ‚t ||¡ d S )Nc                 S   s   |   ¡ |  ¡ dœS ©N©rJ  ro  r   rˆ   r   r   r   r§   Ã  s    z(test_handle_dict_return_value.<locals>.fc                 S   s   t |  ¡ |  ¡ dœƒS rÿ  )r   rJ  ro  rˆ   r   r   r   r´   Æ  s    z(test_handle_dict_return_value.<locals>.gr   r&   )r0   rj   r%  r   r6   ri   )r9   r§   r´   r   r   r   r   r   Útest_handle_dict_return_valueÂ  s    r  Úgrouperr   r   c                    sÐ   dd„ }‡‡fdd„‰ ‡ fdd„}| j ˆdd�}d	}tjt|d
�� | |¡ W d   ƒ n1 sb0    Y  | ˆ ¡ | ˆ ˆ dœ¡ | |¡ |d  |¡ |d  ˆ ¡ |d  ˆ |g¡ |d  |¡ d S )Nc                 S   s   | j d usJ ‚| S rN   r8  rˆ   r   r   r   r§   Ò  s    ztest_set_group_name.<locals>.fc                    sh   | j d usJ ‚ˆr\ˆ dkr\t| jƒr\tjtdd�� |  ¡  W d   ƒ qd1 sP0    Y  n|  ¡ S d S )Nr   zdoes not supportrK   )r[   r   r<   rl   rm   r-  rP   rˆ   )r  r˜  r   r   ÚfreduceÖ  s
    (z$test_set_group_name.<locals>.freducec                    s   ˆ | ƒS rN   r   rE   )r  r   r   ÚfreducexÞ  s    z%test_set_group_name.<locals>.freducexFrI   r‹   rK   r
  r&   )r0   r6   re   rŽ   rj   rg   rk   )r9   r  r˜  r§   r  rp   rs   r   )r  r  r˜  r   Útest_set_group_nameÐ  s    (

r  c                     sˆ   t g d¢t d¡dœƒ} g ‰ ‡ fdd„}d}tjt|d��& | jdd	d	d
� |¡ W d   ƒ n1 sf0    Y  g d¢}ˆ |ks„J ‚d S )N)r   r   rM   rM   r"   r"   r  rÎ   c                    s   ˆ   | j¡ |  ¡ S rN   )r1  r[   r-   rˆ   r0  r   r   r§   ÷  s    z6test_group_name_available_in_inference_pass.<locals>.fr‹   rK   rÏ   F)r—  rJ   rZ   )r   r4   r5   r6   re   rŽ   r0   rj   )r9   r§   rs   Zexpected_namesr   r0  r   Ú+test_group_name_available_in_inference_passñ  s    4r  c                 C   sV   |   | d j¡ ¡ }|jjd u s$J ‚|   | d j| d jg¡ ¡ }|jjdksRJ ‚d S )Nr   r   )NN)r0   rÜ   rP   r)   r[   rá   rÛ  r   r   r   Útest_no_dummy_key_names  s    r  c                  C   sÀ   t ddgddggg d¢g d¢gddgd�} tg d¢| d	�}t ddgddggg d
¢g d¢gddgd�} tg d¢| d	�}|jddgdd� ¡ }t ||¡ |jddgdd� ¡ }t || ¡ ¡ d S )NrM   r"   )r   r   r   r   rM   rM   )rM   rM   r   r   r   r   rÏ   rÐ   rà   )r   rM   r"   rB   r¾   r!   r(   r~  )rM   r   r   ©r   r"   r¾   F©r   r—  T)r   r   r0   rž   r6   ri   Ú
sort_index)r)   ZmseriesZmseries_resultr   r   r   r   Ú#test_groupby_sort_multiindex_series  s    ý"ÿr  c                  C   s‚   d} t dd| d�}tt | ¡t | ¡dœ|d�}ddd	„}| d
d„ ¡}| d|tjƒi¡}| d|tjdƒi¡}t ||¡ d S )Néè  z2012/1/1Z5min)rÐ  rÂ   r    )ÚhighÚlowr(   Fc                    s   ‡ ‡fdd„}|S )z>
        Run an aggregate func on the subset of data.
        c                    sD   | j | j dd„ ¡  ¡ }ˆ r,| | jd   t|ƒdkr<d S ˆ|ƒS )Nc                 S   s
   | j dk S )Nr   )ÚhourrE   r   r   r   rG   ,  rH   zYtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._func.<locals>.<lambda>r   )r†   r)   rÁ  Údropnard   )ro   r›  ©ÚfixÚfuncr   r   Ú_func+  s    zGtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._funcr   )r  r  r  r   r  r   Ú
agg_before&  s    z8test_groupby_reindex_inside_function.<locals>.agg_beforec                 S   s   t | j| j| jƒS rN   )r   rÅ   rª   rÇ   rE   r   r   r   rG   5  rH   z6test_groupby_reindex_inside_function.<locals>.<lambda>r  T)F)	r   r   r4   r5   r0   rh   rJ  r6   r7   )r    Úindr9   r  rp   Zclosure_badZclosure_goodr   r   r   Ú$test_groupby_reindex_inside_function!  s    
r  c                  C   sˆ   t g d¢g d¢g d¢dœƒ} |  ddg¡} | jddgdd�}| d	¡}tjg d
¢ddgd�}t dgdgdgg|dgd�}t ||¡ d S )N)rÏ   rÏ   rÏ   rÐ   )rß   rß   r›  rß   )rM   rM   rM   r!   )Úgroup1Úgroup2r…   r  r  Tr	  rP   ))rÏ   rß   )rÏ   r›  ©rÐ   rß   r0  r"   rM   r!   r…   r’  )r   rã   r0   rh   r   r2  r6   r7   )r9   rµ   r»   r  r5  r   r   r   Ú$test_groupby_multiindex_missing_pair<  s    ýÿ
ÿr  c                  C   s‚  t jg d¢ddgd�} tg d¢g| d�}|j ¡ s6J ‚tg d¢g d¢g d	¢gd
�}|jdddgdd�}| ¡ }|j ¡ r|J ‚| d¡ ¡ }t	 
t¡� | d¡ ¡ }W d   ƒ n1 s¸0    Y  t	 ||¡ tg d¢g d¢g d¢dœƒ ddg¡}|j ¡ �rJ ‚ddddgfD ]j}dD ]^}|j||dd� tj¡}|}t	 ||¡ | ¡ j||dd� tj¡}| ¡ }t	 ||¡ �q�qd S )N))rÏ   Ú )Úb1Úc1)Úb2Úc2rÐ   rß   r0  ©rM   rB   r¾   r7  rç  )rM   r  r  rB   )rM   r  r   r¾   )r¹   ro   rÏ   r›  )r)   r¹   rÜ   )rÏ   rÏ   rÐ   rÏ   ©rM   rM   r"   r"   ©rM   r"   rB   r¾   ©rF   rå   ÚzrF   rå   r   rM   )FTF)r   r—  rJ   )r   r2  r   r¹   Z_is_lexsortedÚpivot_tablerQ  r0   r\   r6   re   r   r7   rã   r)   rj   Zdrop_duplicatesr
  )Zlexsorted_miZlexsorted_dfZnot_lexsorted_dfr   r   r9   r   r—  r   r   r   Ú%test_groupby_multiindex_not_lexsortedQ  sL    ÿÿ
ÿ,ÿþÿÿþÿr'  c                  C   s  t tdƒg d¢d�} |  tdƒ¡}| dd„ ¡}| jg d¢ }t ||¡ | d }| tdƒ¡}| d	d„ ¡}| g d¢¡}t ||¡ | j	 
t¡| _	|  tdƒ¡}| d
d„ ¡}| jg d¢ }t ||¡ | d }| tdƒ¡}| dd„ ¡}| g d¢¡}t ||¡ d S )NZABCDE)r"   r   r"   rM   rM   r(   Zababbc                 S   s   t | ƒdkS r_   ©rd   rE   r   r   r   rG   ‡  rH   z4test_index_label_overlaps_location.<locals>.<lambda>r!  r   c                 S   s   t | ƒdkS r_   r(  rE   r   r   r   rG   �  rH   c                 S   s   t | ƒdkS r_   r(  rE   r   r   r   rG   ”  rH   c                 S   s   t | ƒdkS r_   r(  rE   r   r   r   rG   š  rH   )r   r1   r0   Úfilterr/   r6   r7   rþ   ri   r)   ry   rØ   )r9   r´   Úactualr   r8   r   r   r   Ú"test_index_label_overlaps_location‚  s(    r+  c                  C   s‚   d} t  | ¡}t|d d| d| dœƒ}t|d d d| d| dœƒ}| d¡}| d¡}| d¡}| d¡}t ||¡ d S )	Nr  r"   rÚ   ç      @rê   rÓ   rÏ   r\   )r4   r5   r   r0   rk   r6   r7   )ÚnrF   r9   rì   r:   r   Úgb2r   r   r   r   Ú"test_transform_doesnt_clobber_intsŸ  s    
 



r/  Úsort_columnÚintsÚfloatsÚstringsÚgroup_columnÚ
int_groupsÚstring_groupsc                    sŠ   t g d¢g d¢g d¢g d¢g d¢dœƒ}|jˆ d�}| |¡}‡ fdd	„}d
}tjt|d�� | |¡ W d   ƒ n1 s|0    Y  d S )N)rB   rM   r   rM   r   rB   rB   rB   )r%  rÏ   r%  rÏ   rÏ   r´   r´   r´   )r�   rQ   r¾   r!   r"   rA   rM   rM   )gffffff@g333333@gÍÌÌÌÌÌ@g333333Àgš™™™™™@çš™™™™™ñ?r7  r!   )r%  r›  rÏ   r    ÚwordZword2Z42Z47)r5  r6  r1  r2  r3  rô  c                    s   t  | | jˆ d�¡ d S )Nrô  )r6   r7   rö  rE   ©r0  r   r   Ú	test_sortÈ  s    z.test_groupby_preserves_sort.<locals>.test_sortr‹   rK   )r   rö  r0   r6   re   rŽ   rj   )r0  r4  r9   r´   r:  rs   r   r9  r   Útest_groupby_preserves_sort®  s    ûÿ
r;  c                  C   s�   t tt ¡ ddd� ¡ tdƒdœƒ} |  d¡jj| d< |  d¡jj	| d< t
jtdd	��& |  ¡ jddd
dd� W d   ƒ n1 s‚0    Y  d S )NrX   ZMErÁ   )Ú	eventDateZthenamer<  rÅ   rª   z	'badname'rK   ZbadnamerK  )r)   r¹   rÜ   Zaggfunc)r   r   r   ÚtodayÚtolistr2   rã   r)   rÅ   rª   rl   rm   rÎ  rQ  r&  rÑ   r   r   r   Ú!test_pivot_table_values_key_errorÐ  s    þÿÿr?  r¹   r&   r#  rÜ   râ  rÏ   rM   z
US/Easternr$   ú
2016-01-01rB   r„   rÁ   ÚInt64r‚   ÚFloat64Úboolean)ÚboolÚintrØ   rÄ  r   Zdt64Zdt64tzZperiodrA  rB  rC  )ZidsÚmethod)rT  rh   rj   )r‡   Úidxminro  rJ  rP   rq  rw  c                    sÖ  d }t ˆtƒrˆdv rd}t ˆd tƒr4ˆdv r4d}tˆˆˆdœtdƒd�}	tˆd	ƒrj|	jˆjk ¡ sjJ ‚|	j	d d… }	|	j
ˆd
|d
d�|  ‰ ‡ ‡‡fdd„}
‡‡‡fdd„}t |	jj	d tjƒ}|	jj	d jdk}t ˆtƒ}t ˆtƒ�r”ˆj�s”ˆdv �r”ˆdv �rdˆ› d�}t}ndˆ› d�}t}tj||d�� |
ƒ  W d   ƒ n1 �sT0    Y  ˆdv �r�t | tƒ�r�|
dd�}|ƒ }t ||¡ d S ˆdv �rl|�s°|�s°|�rl|�r¼d}n|�rÈd}nd}ˆdk�räd |d g¡}tjt|d�� |
ƒ  W d   ƒ n1 �s0    Y  t | tƒ�s*d S ˆdk�r8d S |
dd�}|	 ˆ¡g  }|�r\|ƒ }t ||¡ d S |
ƒ }|	 ˆ¡|  }ˆd!v �r˜| |	jj¡}|d u�r¬| |¡}tˆƒd"k�rÆˆd |j_t ||¡ d S )#N)rP   rq  rA  r   )rq  rP   r=   r*   ÚABCr7  r<   F)rJ   r  Úobservedc                     s6   ˆdkrt ˆ ˆƒf i | ¤ŽS t ˆ ˆƒˆfi | ¤ŽS d S )NrT  )r÷   )Úkwargs)r:   rF  r/  r   r   Ú
get_result  s    z&test_empty_groupby.<locals>.get_resultc                     sh   t dgˆjd�} tˆ ƒdkr0tj| | gˆ d�}nt| ˆ d d�}ˆrRtg dd�}ng }tg ||d�}|S )Nr   r‚   rM   r0  r8  r”  rÃ   )r   r<   rd   r   rË  r
   r   )Zlevr  r¹   r   )r#  r˜  rÜ   r   r   Ú get_categorical_invalid_expected#  s    z<test_empty_groupby.<locals>.get_categorical_invalid_expectedÚM)ro  rJ  rG  r‡   )ro  rJ  zCannot perform z with non-ordered Categoricalz
Can't get z/ of an empty group due to unobserved categoriesrK   Tr  )rq  rP   rw  z datetime64 type does not supportzPeriod type does not supportzcategory type does not supportrw  ú|z!does not support reduction 'skew')r‡   rG  rM   )r%  r   rD  r   r1   Úhasattrr�   r<   rÿ   r/   r0   r+   ZPeriodDtypeÚkindr   Úorderedr-  re  rl   rm   r6   Úassert_equalÚjoinrã   ry   r)   rd   r[   )r¹   r#  rÜ   rF  r/  Zusing_array_managerr  r˜  Zoverride_dtyper9   rK  rL  Zis_perZis_dt64Zis_catrs   ru  r   r   r   )r:   r#  rF  r/  r˜  rÜ   r   Útest_empty_groupbyâ  s~    '

ÿþý
&


&




rT  c                  C   sž   t tj d¡ d¡ƒ} | d  tj¡| d< g d¢| _| j| d dd�}d}t	j
t|d	�� | d
d„ ¡}W d   ƒ n1 s|0    Y  |j| jk ¡ sšJ ‚d S )Nr"   )r   r¾   rB   ©r   rM   r"   r   rM   FrI   r‹   rK   c                 S   s   | S rN   r   rE   r   r   r   rG   ˆ  rH   z<test_empty_groupby_apply_nonunique_columns.<locals>.<lambda>)r   r4   r`   ra   rŒ   ry   r=   r¹   r0   r6   re   rŽ   rj   r�   rÿ   )r9   r:   rs   r»   r   r   r   Ú*test_empty_groupby_apply_nonunique_columns€  s    
,rV  c                  C   sž   t g d¢g d¢g d¢g d¢dœƒ} tjtdd��" | g d¢  d¡ W d   ƒ n1 sX0    Y  |  d¡d  ¡ }td	gdtd
gdd�d�}t 	||¡ d S )N)rM   rM   rM   rM   )r"   r"   r"   r"   )rÎ   rÏ   rÐ   rß   z
('a', 'b')rK   rê   rÎ   rß   r¾   rM   r8  r:  )
r   rl   rm   rÎ  r0   rP   r   r
   r6   ri   r<  r   r   r   Útest_tuple_as_groupingŒ  s    üÿ	0rW  c                  C   sd   t dtdƒt ddgddgg¡d�} tjtdd�� |  d¡ ¡  W d   ƒ n1 sV0    Y  d S )	NrM   rB   r"   r¾   r’  z
^\(7, 8\)$rK   )rQ   r�   )	r   r2   r   rË  rl   rm   rÎ  r0   r\   rÑ   r   r   r   Útest_tuple_correct_keyerrorŸ  s    $rX  c               	   C   sŠ   t dgdggtdgdd�tddddd	�d
�} t g d¢g d¢gtjdg d¢d�tddddd	�d
�}|  tdd�¡ ddg¡}t 	||¡ d S )NrM   r~   Úmycolsr8  ú
2018-01-01r"   r„   Údti)r    rÂ   r[   rÃ   )rM   rM   rM   rM   rM   ))r~   rP   r~   )r~   ÚohlcÚopen)r~   r\  r  )r~   r\  r  )r~   r\  Úclose)rY  NNr0  )rÂ   rP   r\  )
r   r
   r   r   r2  r0   r	   rh   r6   r7   r´  r   r   r   Útest_groupby_agg_ohlc_non_first¦  s    
ýø
ôr_  c                  C   sŒ   t jdftdddƒdftdddƒdftdddƒdfg} tj| dd gd�}tg d	¢|d
�}|jdd� ¡ }tddgddgd
�}t 	||¡ d S )NrÏ   iÜ  rM   r"   rÐ   rB   Údater0  )rB   r"   ç      @r¾   r(   rz  r,  ra  )
r+   r.   r   r   r2  r   r0   r\   r6   ri   )rÜ   r3  r8   r   r   r   r   r   Útest_groupby_multiindex_natÂ  s    ürb  c                  C   sd   t tdƒtdƒƒ} t| ddgd�}d}tjt|d�� | g g¡ W d   ƒ n1 sV0    Y  d S )NrW   ÚapplerÐ   r7  z$Grouper and axis must be same lengthrK   )r`  r2   r   rl   rm   re  r0   )rÜ   r9   rs   r   r   r   Útest_groupby_empty_list_raisesÒ  s
    rd  c                  C   sŽ   ddgddgddgg} g d¢}t j| |d�}tddg|d	�}| d
dg¡ ¡ }dgdgg} d
dg}t j| |d�}tdg|d�}t ||¡ d S )NrF   rÏ   rÐ   rq   )rž   r‚  Úthirdr0  rM   r"   rŽ  rž   re  rB   r(   )r   Úfrom_arraysr   r0   rP   r6   ri   )Zindex_arrayZindex_namesÚrir‹  r   Úeir   r   r   r   Ú8test_groupby_multiindex_series_keys_len_equal_group_axisÛ  s    ri  c                  C   s    t jddgddggddgd�} tg d¢g d	¢d
œ| d�}| tdd�dg¡}| ddg¡}|j|jksjJ ‚| dtdd�g¡}| ddg¡}|j|jksœJ ‚d S )Nr   r   r&   r„   rB  Úbetar0  )rM   r"   rM   r"   r#  r  r(   rz  )r   rË  r   r0   r	   rû   )r3  r9   r   r   r   r   r   Ú"test_groupby_groups_in_BaseGrouperë  s    rk  Ú
group_namerF   c                 C   sD  t t d¡ dd¡g d¢g d¢d�}d|j_d|j_d	}tjt	|d
�� |j
| dd�}W d   ƒ n1 sj0    Y  | ¡ }|j 
| ¡ ¡ j}t ||¡ g d¢ddgg}tj|ddgd�}t t d¡ dd¡g d¢|d�}tjt	|d
�� |j
| dd�}W d   ƒ n1 �s0    Y  | ¡ }|j 
| ¡ ¡ j}t ||¡ d S )NrR   rB   r¾   ©r   rM   r   )rW   rX   rW   rX   r’  rå   rF   r  rK   rM   r¢   )r   r}  r~   rU   rV   Úx1)Ú	iterablesrá   é   r  )r   r4   r5   rý  r)   r[   r¹   r6   re   rf   r0   rP   rº   r7   r   rË  )rl  r9   rí   r:   Úresultsr   ro  r3  r   r   r   Útest_groupby_axis_1ù  s&    ÿ, .rr  zop, expectedÚshiftÚtimeú2019-01-01 12:00:00ú2019-01-01 12:30:00Úbfillú2019-01-01 14:00:00ú2019-01-01 14:30:00Úffillc                    s„   | ‰ g d¢t dƒt dƒd d t dƒt dƒgdœ}t|ƒj‡ fdd„d	�}| d
¡}t||ƒƒ }t|ƒj‡ fdd„d	�}t ||¡ d S )N)r   r   r   r   r   r   ru  rv  rx  ry  )rÂ  rt  c                    s   | j j ˆ ¡S rN   ©rt  rÕ  Ztz_localizerE   r$   r   r   rG   O	  rH   z+test_shift_bfill_ffill_tz.<locals>.<lambda>)rt  rÂ  c                    s   | j j ˆ ¡S rN   r{  rE   r$   r   r   rG   S	  rH   )r   r   Zassignr0   r÷   r6   r7   )Ztz_naive_fixturer/  r   ro   r9   rp   r   r   r$   r   Útest_shift_bfill_ffill_tz	  s    .úþ
r|  c                  C   sD   t d gddœƒ} |  d¡d  d¡}ttjgdd�}t ||¡ d S )NrM   )r´   rF   r´   rF   rP   r8  )r   r0   rk   r   r4   rŸ   r6   ri   )r9   r*  r   r   r   r   Útest_groupby_only_none_groupW	  s    r}  c                  C   sL   t g d¢g d¢d�} | jdd�}| ¡ }t g d¢g d¢d�}t ||¡ d S )N)r"   r!   r  r�   )rÚ   rÙ   rÙ   rš  r(   r   rz  )r"   g      @r�   )rÚ   rÙ   rš  )r   r0   r\   r6   ri   )r8   r:   r   r   r   r   r   Útest_groupby_duplicate_indexa	  s
    r~  c                 C   s  t dtdƒddggg d¢d�}|d  t¡|d< |d  t¡|d< | d	d
g¡}| dkr^d}nd}| dkrntnd }d}tj||d��4 |jd d…  	d	g¡j
| g|¢R Ž }W d   ƒ n1 s¾0    Y  tj||d��4 | 	d	g¡j
| g|¢R Ž jd d… }W d   ƒ n1 �s0    Y  | dv �r0| t¡}t ||¡ d}tj||d��8 |d jd d…  	d	g¡j
| g|¢R Ž }W d   ƒ n1 �sŽ0    Y  d}tj||d��8 |d  	d	g¡j
| g|¢R Ž jd d… }W d   ƒ n1 �sê0    Y  | dv �r| t¡}t ||¡ d S )NrM   r=  rB   r¾   )Úcol_1Úcol_2Úcol_3Úcol_4©ro   r¹   r�  r‚  r  r€  Úfillna)rz  r   ú%DataFrameGroupBy.fillna is deprecatedrK   r   )Údiffrs  z"SeriesGroupBy.fillna is deprecated)r   r   ry   rE  rã   rf   r6   re   r/   r0   rk   rR  )Ztransformation_funcÚrequestr9   Úargsr¶   Úwarn_msgr   r   r   r   r   Útest_group_on_empty_multiindexk	  s\    þBD

ÿþýýÿ"ÿþþýÿ"

rŠ  c                 C   s–  t dddd�}tddgddgddgdœƒ}d	|j_||_| | ¡}|sR|j}d
}nd}tjt	|d�� |j
|dd�}W d   ƒ n1 sˆ0    Y  | ¡ }tddgddgdœ|d�}d|j_|sÆ|j}t ||¡ |dk�r(tjt	|d��" |g  j
|dd�}W d   ƒ n1 �s0    Y  |g  }	nVtjt	|d��$ |jg  j
|dd�}W d   ƒ n1 �sb0    Y  |jg   tj¡}	| ¡ }
t |
|	¡ d S )Nr@  r"   r~   )r    r[   rM   rB   r   )r±  )r   r&   )r„   r   )r   r}  r  r  rK   )r£   r   )r   r„   r(   r   )r   r   r¹   rá   r)   Z_get_axis_numberrº   r6   re   rf   r0   Znuniquer[   r7   r†   ry   r4   r?   )r£   r[  r9   Zaxis_numberrs   r:   r   r   r.  r5  r»   r   r   r   Útest_groupby_crash_on_nunique˜	  s4    
,
2
4r‹  c                  C   s>   t t dd¡ dd¡td�} | jdgd� ¡ }t || ¡ d S )Nr   rA   rB   r‚   rz  )	r   r4   r5   rý  rØ   r0   r\   r6   r7   )r   r   r   r   r   Útest_groupby_list_levelÁ	  s    rŒ  zmax_seq_items, expected))r!   z({0: [0], 1: [1], 2: [2], 3: [3], 4: [4]})r¾   z%{0: [0], 1: [1], 2: [2], 3: [3], ...})rM   z{0: [0], ...}c                 C   s�   t tj d¡ d¡ƒ}|j|d< t d| ¡�P | d¡j	 
¡ }||ksJJ ‚| t |j¡¡j	 
¡ }||ksnJ ‚W d   ƒ n1 s‚0    Y  d S )Nr"   )r!   rM   rÏ   zdisplay.max_seq_items)r   r4   r`   ra   rŒ   r)   r+   Úoption_contextr0   rû   Ú__repr__r�   rÏ   )Zmax_seq_itemsr   r9   r   r   r   r   Útest_groups_repr_truncatesÈ	  s    

r�  c                  C   s†   t ddddœddddœgƒ} |  ddg¡} |  ddg¡}|j}dtjd	dgtjd
�i}t|ƒdksfJ ‚d}|| || k ¡ s‚J ‚d S )NrM   r"   éc   rê   éX   rÏ   rÐ   r¸   r   r‚   )	r   rã   r0   rü   r4   r�   r=   rd   rÿ   )r9   r–   r   r   r   r   r   r   Ú6test_group_on_two_row_multiindex_returns_one_tuple_keyÝ	  s    r’  zklass, attr, valuer   r—  rJ   rI  r  c                 C   sr   t dgdgdgdœƒ}|dkr(| d¡}|jdi ||i¤Ž}| t u rN|dg n|d }t||ƒt||ƒksnJ ‚d S )	NrM   r"   rB   rê   r£   rÏ   rÐ   )rÏ   )r   rã   r0   r÷   )ru  rT  r…   r9   r   r   r   r   r   Ú#test_subsetting_columns_keeps_attrsë	  s    
r“  c                  C   s    t dgdgdgdœƒ} d}tjt|d��" | jg d¢dd�}W d   ƒ n1 sP0    Y  d	}tjt|d��  |d
dg  ¡  W d   ƒ n1 s’0    Y  d S )NrM   r"   rB   r*   r  rK   r~  r¢   z'Cannot subset columns when using axis=1r   r   )	r   r6   re   rf   r0   rl   rm   re  rP   )r9   rs   r´   rL   r   r   r   Útest_subsetting_columns_axis_1
  s    0r”  r  )rP   Úanyrs  c                 C   sH   t dgdd�}tdgg|d�}| dg¡}t|| ƒƒ j}t ||¡ d S )NrÏ   r  r8  rM   r7  )r
   r   r0   r÷   r¹   r6   rg  )r  r   r9   rµ   r   r   r   r   Ú#test_groupby_column_index_name_lost
  s
    r–  Úinfer_stringÚpyarrow)Zmarksc                 C   sª   | rt  d¡ tg d¢g d¢g d¢dœƒ t¡}g d¢|_t d| ¡�" | g d¢¡ 	¡ }W d   ƒ n1 sn0    Y  tg d	¢gt
 d
g¡g d¢td�}t ||¡ d S )Nr˜  )r§   r    r´   rœ  rç  r#  r*   )r   r   r   zfuture.infer_string)r   r   r   r   )r    rÏ   rM   r   )r)   r¹   r<   )rl   Zimportorskipr   ry   rË   r¹   r+   r�  r0   ro  r4   r�   r6   r7   )r—  r9   r   r   r   r   r   Útest_groupby_duplicate_columns
  s    	
ÿþ
0ÿr™  c                  C   s\   t g d¢g d¢dd�} d| j_| jdd� ¡ }t dd	gd
dgdd�}d|j_t ||¡ d S )Nr#  r"  )rÏ   rÏ   ©r)   r[   )rÐ   rÐ   r   rz  r"   r¾   rM   )r   r)   r[   r0   Úlastr6   ri   )r8   r   r   r   r   r   Ú#test_groupby_series_with_tuple_name3
  s    rœ  zfunc, valuesrP   ç     @X@ç     €X@r\   g     @8@g     €8@c                 C   s`   g d¢}t ddgd ||dœƒ}t| d¡| ƒƒ }t ||dœtddgdd�d	�}t ||¡ d S )
N©ç €à7yÃACr   éa   éb   ç €à7yÃ1Ãr£  r£  r£  rM   r"   r¾   ©r‰   rÏ   rÐ   r‰   rÎ   r8  r(   )r   r÷   r0   r
   r6   r7   )r  rÜ   ro   r9   r   r   r   r   r   Ú)test_groupby_numerical_stability_sum_mean=
  s
    r¥  c                  C   sr   g d¢} t ddgd | | dœƒ}| d¡ ¡ }dgd dd	g d
dg ddg }t ||dœƒ}tj||dd� d S )NrŸ  rM   r"   r¾   r¤  r‰   r   g0€à7yÃACg1€à7yÃACga€à7yÃ1Cgb€à7yÃ1Cr�  rž  rÎ   T)Zcheck_exact)r   r0   r9  r6   r7   )ro   r9   r   Zexp_datar   r   r   r   Ú'test_groupby_numerical_stability_cumsumI
  s     ÿr¦  c                  C   sz   t j d¡ d¡} t| ƒ}tdƒD ]}t j|j||f< q"d|d< | d¡}|j	dd�}|g d¢ j	dd�}t
 ||¡ d S )	Nr"   )r!   r!   r!   rM   r   F©Úskipnar¥  )r4   r`   ra   rŒ   r   r2   rŸ   r/   r0   r9  r6   r7   )r¾  r9   Úir:   r»   r   r   r   r   Ú test_groupby_cumsum_skipna_falseU
  s    
rª  c                  C   sÆ   t ddd�} t| ƒ| d  }tj|d< td|dœƒ}| d¡}|jd	d
d�}td|d |d tj|d |d d giƒ}t ||¡ |jd	d	d�}td|d |d tjtjtjgiƒ}t ||¡ d S )Nr@  r!   r   r   r"   rM   r±  r   FT)r	  r¨  r   r¾   )	r   r   r+   r.   r   r0   r9  r6   r7   )r[  r8   r9   r:   r»   r5  r   r   r   Útest_groupby_cumsum_timedelta64e
  s    

,$r«  c                 C   s4   | }|j dd� ¡ }|  |j¡ ¡ }t ||¡ d S )Nr   rz  )r0   r\   r)   r6   ri   )Z(rand_series_with_duplicate_datetimeindexZdupsr   r   r   r   r   Ú!test_groupby_mean_duplicate_indexw
  s    r¬  c                  C   sT   t g d¢tjtjtjgƒ} |  | j¡ ¡ }t g tg tjd�tjd�}t	 
||¡ d S )NrÍ   r‚   rC   )r   r4   rŸ   r0   r)   rP   r
   r?   r=   r6   ri   ©r‹  r   r   r   r   r   Ú test_groupby_all_nan_groups_drop~
  s    r®  c                 C   s–   t g g d¢d�}|jddg| d�}|j|d�}| r\tg g gg g gddgd�}|sVdgng }ntd	ƒ}|spg d¢nddg}t g ||d
�}t ||¡ d S )Nr*   rƒ  r   r   r­   r  r0  r&   r   rÃ   )r   r0   rP   r   r   r6   r7   )r®   r	  r9   r:   r   r)   r¹   r   r   r   r   Útest_groupby_empty_multi_column†
  s    r¯  c                  C   s€   t ddggddggddggddgggddgd�} t dddgddggitddgd	dd
�d�}| jdgd�}| ¡ }t ||¡ d S )NrM  rM   ÚWrW   rX   ZMWrr   r7  rË   ©r<   r[   r(   rô  )r   r
   r0   rP   r6   r7   ©r9   r   r:   r   r   r   r   Ú*test_groupby_aggregation_non_numeric_dtype–
  s    (ÿÿür³  c                  C   sš   t g d¢dd„ tddƒD ƒdd„ tddƒD ƒdœƒ} t dd„ td	d
ƒD ƒdd„ td	d
ƒD ƒdœtddgddd�d�}| jdgd�}| ¡ }t ||¡ d S )N©rM   r   rM   rM   r   c                 S   s   g | ]}t |d ƒ‘qS ©Údays©r   ©rÉ   r©  r   r   r   rÔ   ­
  rH   zDtest_groupby_aggregation_multi_non_numeric_dtype.<locals>.<listcomp>rM   r  c                 S   s   g | ]}t |d  dƒ‘qS ©rW   r¶  r·  r¸  r   r   r   rÔ   ®
  rH   r$  c                 S   s   g | ]}t |d ƒ‘qS rµ  r·  r¸  r   r   r   rÔ   ´
  rH   rQ   rA   c                 S   s   g | ]}t |d  dƒ‘qS r¹  r·  r¸  r   r   r   rÔ   µ
  rH   ©rå   r%  r   r=   rF   r±  r(   rô  )r   r2   r
   r0   rP   r6   r7   r²  r   r   r   Ú0test_groupby_aggregation_multi_non_numeric_dtype¨
  s    ýÿþûr»  c                  C   sˆ   t g d¢dd„ tddƒD ƒttddƒƒdœƒ} t tddƒtd	dƒgdd	gd
œtddgddd�d�}| jdgd�}| ¡ }t ||¡ d S )Nr´  c                 S   s   g | ]}t |d ƒ‘qS rµ  r·  r¸  r   r   r   rÔ   Ä
  rH   zKtest_groupby_aggregation_numeric_with_non_numeric_dtype.<locals>.<listcomp>rM   r  r$  rQ   r¶  r�   rº  r   r=   rF   r±  r(   rô  )	r   r2   r1   r   r
   r0   rP   r6   r7   r²  r   r   r   Ú7test_groupby_aggregation_numeric_with_non_numeric_dtype¿
  s    ýÿþr¼  c                  C   s„   dddddœdddddœdddddœg} t | ƒ}||d dk }| d¡}| ¡ }t g d	¢gg d
¢tdgdd�d�}t ||¡ d S )NFTg      %@)Ú
filter_colÚgroupby_colÚbool_colÚ	float_colg     €4@g     €>@r½  r¾  )râ  râ  g$+¿ÆH@)r½  r¿  rÀ  r8  rÃ   )r   r0   r3   r
   r6   r7   )Zdictsr9   Z	df_filterÚdfgbr   r   r   r   r   Útest_groupby_filtered_df_stdÓ
  s    ý
ýrÂ  c                  C   sž   t ttdƒƒttg d¢ƒdd�tjg d¢ddgd�d	œƒ} | jd
dgdd�j}d
tdƒft	 
dg¡dtdƒft	 
dg¡dtdƒft	 
dg¡i}||ksšJ ‚d S )NÚabc)rZ  z
2018-02-01z
2018-03-01Úcategoryr‚   )r'   r   rM   r   rM   )Ú
categoriesrê   rÏ   rÐ   F©rI  z2018-01-01 00:00:00z2018-02-01 00:00:00rß   z2018-03-01 00:00:00r"   )r   r   r1   r   r   Z
from_codesr0   rü   r   r4   r�   r<  r   r   r   Ú2test_datetime_categorical_multikey_groupby_indicesç
  s    

þúÿ
ýrÇ  c                  C   s    dgd dgd  } t jt jdddgt jddddg }t| |gƒj}dd	g|_d
}tjt|d��, | d¡d	 j	ddd� 
¡  W d   ƒ n1 s’0    Y  d S )NZAlicer!   ZBobrM   r"   rB   r¾   r[   rÍ  z@^[a-zA-Z._]*\(\) got an unexpected keyword argument 'min_period'rK   )ZwindowZ
min_period)r4   rŸ   r   rº   r¹   rl   rm   r-  r0   ZrollingrP   )Zname_lZval_lZtest_dfZresult_error_msgr   r   r   Ú#test_rolling_wrong_param_min_periodü
  s    "
ÿrÈ  r”  c                 C   sx   t g d¢g d¢tg d¢| d�dœƒ}tjddœ}| dg¡ |¡}t d	d
gd	gddgddgdœƒ d¡}t ||¡ d S )N)ÚThomasrÉ  úThomas John)i°  i  é„  )ÚsadÚhappyrÍ  r‚   )ÚNameÚCreditÚMoodrP   )rÐ  rÏ  rÎ  rÍ  rÌ  iÄ	  rË  rÉ  rÊ  )rÐ  rÏ  rÎ  )r   r   Úmoder0   rh   rã   r6   r7   )r<   r9   Zaggregate_detailsr   Zexpected_resultr   r   r   Ú.test_by_column_values_with_same_starting_value
  s"    	ýÿ
ýÿúrÒ  c                  C   sn   g d¢g d¢g} t dtj| ddgd�d�}|jddgd	� ¡ }t dd
gtjddgddgd�ƒ}t ||¡ d S )N)NrM   r   rM   )r"   rB   r"   rB   rM   rÏ   rÐ   r0  r(   r   rz  r"   )râ  r"   )rÓ   rB   )r   r   rf  r0   rP   r2  r6   ri   )r¾  r8   r   r   r   r   r   Ú#test_groupby_none_in_first_mi_level(  s    ÿrÓ  c                  C   sd   t g d¢g d¢g d¢dœƒ} | jd gd� ¡ }t ddgdd	gd
œtddgd d�d�}t ||¡ d S )Nr"  )rM   rM   r"   rB   )r¾   r!   r  rQ   )NrÐ   rß   rô  r"   r!   rA   é   r  rM   r8  r(   )r   r0   rP   r
   r6   r7   r<  r   r   r   Útest_groupby_none_column_name3  s    &rÕ  Ú	selectionc                 C   sr   t ddgtjdgtjdgdœddgd�}| d u r<| dg¡n| dg¡|  }d	d
„ |D ƒ}ddg}||ksnJ ‚d S )NrM   r"   r!   rê   rF   rå   r(   rÏ   c                 S   s   g | ]\}}|‘qS r   r   ©rÉ   r   r¢  r   r   r   rÔ   @  rH   z5test_single_element_list_grouping.<locals>.<listcomp>©rM   )r"   )r   r4   rŸ   r0   )rÖ  r9   rp   r   r   r   r   r   Ú!test_single_element_list_grouping;  s
    ($rÙ  c                  C   sv   t g d¢g d¢dœƒ} | d  d¡| d< t g d¢g d¢dœƒ}|d  d¡|d< | jddd	�}| ¡ }t ||¡ d S )
N)rÏ   rÐ   rß   rÏ   )rM   r"   rB   r"   )Ústr_colZnum_colrÚ  Ústringrê   )r‘  rÚ   r,  Fr­   )r   ry   r0   r\   r6   r7   )r9   r   rp   r   r   r   r   Útest_groupby_string_dtypeF  s    úÿ
rÜ  zlevel_arg, multiindex)©r   F)rÝ  Tc                 C   s‚   t ddgddgddgdœdd	gd
�}|r6| ddg¡}d}tjt|d��& dd„ |j| d�D ƒ W d   ƒ n1 st0    Y  d S )NrM   r"   rB   r¾   r!   r  rê   rF   rå   r(   rÏ   rÐ   zÏCreating a Groupby object with a length-1 list-like level parameter will yield indexes as tuples in a future version. To keep indexes as scalars, create Groupby objects with a scalar level parameter instead.rK   c                 S   s   g | ]\}}|‘qS r   r   r×  r   r   r   rÔ   i  rH   zKtest_single_element_listlike_level_grouping_deprecation.<locals>.<listcomp>rz  )r   rã   r6   re   rf   r0   )Z	level_argræ   r9   rí   r   r   r   Ú7test_single_element_listlike_level_grouping_deprecationZ  s    $ÿrÞ  )rP   r9  Úcumprodrq  c                 C   sj   d}t d|gdœƒ}t| d¡| ƒƒ | }t ddgitdgdd�d�}| d	v rZ|jd
d�}t ||¡ d S )Nl   ÌL™33ffrM   rÎ   rÏ   rÐ   r   r8  r(   )r9  rß  TrL  )r   r÷   r0   r
   rQ  r6   r7   )r  rÍ  r9   r   r   r   r   r   Ú#test_groupby_avoid_casting_to_floatl  s    rà  z	func, val)rP   rB   )rq  r"   c                 C   s\   t dddtjgdœ| d�}t| d¡|ƒƒ }t d|gitdgd| d�| d�}t ||¡ d S )	NrM   r"   rÎ   r‚   rÏ   rÐ   rÉ  rC   )r   r+   ÚNAr÷   r0   r
   r6   r7   )Úany_numeric_ea_dtyper  rÍ  r9   r   r   r   r   r   Útest_groupby_sum_support_maskx  s    ýrã  z
val, dtype)éo   rE  )éÞ   Zuintc                 C   sì   t d| | gdœ|› d�d�}| d¡ ¡ }t d| d gitdgd|› d�d�|› d	�d
�}t ||¡ | d¡ ¡ }t d| | d gi|› d	�d�}t ||¡ | d¡ ¡ }t d| |  gitdgd|› d�d�|› d	�d
�}t ||¡ d S )NrM   rÎ   Ú8r‚   rÏ   rÐ   r"   rÉ  Z64rC   )r   r0   rP   r
   r6   r7   r9  rq  )rÍ  r<   r9   r   r   r   r   r   Útest_groupby_overflow…  s$    ýýrç  zskipna, val)TrB   c                 C   sT   t ddtjdgdœ| d�}| d¡j|d�}t ddtj|gi| d�}t ||¡ d S )NrM   r"   rÎ   r‚   rÏ   r§  rÐ   )r   r+   rá  r0   r9  r6   r7   )râ  r¨  rÍ  r9   r   r   r   r   r   Útest_groupby_cumsum_maskž  s    þrè  zval_in, index, val_out)rÓ   rÚ   r,  rÙ   rš  )r~   r~   r   r}  Úblah)r,  rÙ   rš  r,  )rÓ   rÚ   r,  rÙ   rš  g      @)r~   r~   r   r}  ré  ré  )r,  rÙ   g      &@r,  c                 C   st   t | dt|dd�d�}| d¡ ¡ }t |dtg d¢dd�d�}t ||¡ | ¡  d¡ ¡ }| ¡ }t ||¡ d S )NrÜ   ré  r8  )ro   r[   r)   )r   r}  ré  r~   )r   r
   r0   rP   r6   ri   r,   r7   )Zval_inr)   Zval_outZseriesr   r   r   r   r   Ú(test_groupby_index_name_in_index_contentª  s    ýrê  r-  )rM   rW   é    rG  r  c                 C   s`   t ddg|  dœƒ}|d  d¡|d< | d¡ ¡ }t d| gitdgdd�d�}t ||¡ d S )NrM   T)r¾  rD  rD  r¾  r8  r(   )r   Úeqr0   rP   r
   r6   r7   )r-  r9   r   r   r   r   r   Útest_sum_of_booleansÉ  s
    rí  z<ignore:invalid value encountered in remainder:RuntimeWarning)rú   ÚtailrP  rž   r›  c                 C   s¬   t dtjdtjdgtdƒdœƒ}| dkr@t| d¡| ƒdd	�}nt| d¡| ƒƒ }| d
v r~t dg d¢iƒ tg d¢dd�¡}nt g d¢g d¢dœg d¢d�}t 	||¡ d S )NrÏ   rÐ   rß   r!   r±  rP  r   r   )r-  )rž   r›  r   r  rê   r8  r(   )
r   r4   rŸ   r2   r÷   r0   rã   r   r6   r7   )rF  r9   r   r   r   r   r   Útest_groupby_method_drop_naÓ  s     ÿrï  c                  C   st  t jdddd�} ttdƒƒd }|  ¡ }| |¡}tjtdd�� | 	¡  W d   ƒ n1 s^0    Y  tjtdd�� | 
¡  W d   ƒ n1 s”0    Y  tjtd	d�� | ¡  W d   ƒ n1 sÊ0    Y  tjtd
d�� | ¡  W d   ƒ n1 �s0    Y  | ¡ }|dd … }ttdƒtd�|_t ||¡ | ¡ }|d d… }ttdƒtd�|_t ||¡ d S )Nr@  rG  r„   rÁ   rW   z+Period type does not support sum operationsrK   z.Period type does not support cumsum operationsz,Period type does not support prod operationsz/Period type does not support cumprod operationsiöÿÿÿr‚   )r+   Úperiod_ranger1   r2   Z	to_seriesr0   rl   rm   r-  rP   r9  rq  rß  rJ  r
   rE  r)   r6   ri   ro  )ÚpiZgrpsr8   r:   r»   r   r   r   r   Útest_groupby_reduce_periodé  s0    
&ÿ&&ÿ(rò  c                  C   sN   t g d¢gƒ} g d¢| _|  | d ¡}|j}| jg d¢dd�}t ||¡ d S )N)r   rM   r"   rB   rU  rM   )r   r"   rB   r¢   )r   r¹   r0   Z_obj_with_exclusionsrþ   r6   r7   )r9   r:   r   r   r   r   r   Ú*test_obj_with_exclusions_duplicate_columns  s    
ró  c                 C   sš   dddœdddœg}t |ƒ}|jdddd�}| r\|jd	d
�}t ddgdgd�}t ||¡ n:tjtdd�� |j| d
� W d   ƒ n1 sŒ0    Y  d S )Nr~   r   rÎ   ÚcarZdarrÏ   F)r®   r—  Tr  r7  z(could not convert string to float: 'bar'rK   )r   r0   r3   r6   r7   rl   rm   re  )r	  Zdicts_non_numericr9   rÁ  r   Úexpected_dfr   r   r   Ú'test_groupby_numeric_only_std_no_result  s    ÿrö  c                  C   sò   t g d¢g d¢dœƒ} tj| d t ddd¡d�}| j|d	gd
d�d  d¡}ttdddd�tdddd�tdddd�tdddd�gdd�}g d¢}t	j
||gdd	gd�}tt dtjdtjdtjdtjtjdtjtjg¡|dd�}t ||¡ d S )N)çš™™™™™¹?çš™™™™™É?ç333333Ó?çš™™™™™Ù¿ç      à?)rÏ   rÐ   rÏ   rß   rÏ   )rF   ÚwrF   r   rM   r!   r¬   rü  FrÆ  r\   gD‹lçû©Ù¿r÷  rU  )Úclosedrø  rù  rû  T)rQ  rê   r0  rú  rš  )r   r+   Zqcutr4   Zlinspacer0   rh   r   r   r   rË  r   r�   rŸ   r6   ri   )r9   Zqqr   Zcategorical_index_level_1Zindex_level_2r3  r   r   r   r   Ú/test_grouping_with_categorical_interval_columns$  sF    üù	ÿôÿîrþ  Úbug_varc                 C   sV   t d| | | tjgiƒ}| dd„ ¡}|jdd�}t | | | d gdgd�}t ||¡ d S )Nr   c                 S   s   | S rN   r   rE   r   r   r   rG   Q  rH   z;test_groupby_sum_on_nan_should_return_nan.<locals>.<lambda>rM   )Z	min_countr7  )r   r4   rŸ   r0   rP   r6   r7   )rÿ  r9   rÁ  r   rõ  r   r   r   Ú)test_groupby_sum_on_nan_should_return_nanM  s
    r   )rK  ZcorrZcummaxZcumminrß  ró   Zrankr±   r†  rs  rÿ   r•  rG  r‡   rz  rw  Z
pct_changec                 C   sd   t dt| ƒd�}|| _|  dg¡dg }| dg  | d ¡}t||ƒƒ }t||ƒƒ }t ||¡ d S )NÚ2014r   r   r&   )r   rd   r)   r0   r÷   r6   r7   )r9   rF  Úrngr´   Úg_expr»   r5  r   r   r   Ú#test_groupby_selection_with_methodsX  s    r  c                 C   sT  t dt| ƒd�}d| j_|| _|  dg¡dg }| dg  | d ¡}d}tjt|d��( t 	| 
d¡| 
d¡¡ W d   ƒ n1 s„0    Y  d	}tjt|d��  t 	|j|j¡ W d   ƒ n1 sÆ0    Y  t 	| d
d„ ¡| d
d„ ¡¡ t 	| d¡ ¡ | d¡ ¡ ¡ t 	| d¡ ¡ | d¡ ¡ ¡ t 	| dd„ ¡| dd„ ¡¡ d S )Nr  r   r~   r   r&   r…  rK   r   z%DataFrameGroupBy.dtypes is deprecatedc                 S   s   |   ¡ S rN   rO   rE   r   r   r   rG   Ž  rH   z6test_groupby_selection_other_methods.<locals>.<lambda>r„   c                 S   s   t | ƒdkS rD   r(  rE   r   r   r   rG   ”  rH   )r   rd   r¹   r[   r)   r0   r6   re   rf   r7   r„  r�   rj   Zresampler\   r\  r)  )r9   r  r´   r  r‰  rs   r   r   r   Ú$test_groupby_selection_other_methods~  s"    6.   ÿr  c                 C   s€   t g d¢ƒ | ¡}tg d¢g d¢|dœƒ}tddd| d�}t|g d¢g d¢d	œƒ}| td
dd�¡}| ¡  ¡ }t 	||¡ d S )N)z2016-08-31 22:08:12.000z2016-08-31 22:09:12.200z2016-08-31 22:20:12.400)rÓ   rÓ   r,  )ÚquantÚquant2Útime2z2016-08-31 22:08:00rÔ  Z1min)r    rÂ   Úunit)rM   rM   r   r   r   r   r   r   r   r   r   r   rM   )r  r  r  r  )r   rÂ   )
r   Zas_unitr   r   r0   r	   rK  rQ  r6   r7   )r	  Zidx2Z	test_datar  Zexpected_outputr:   r   r   r   r   Útest_groupby_with_Time_Grouper˜  s$    ÿúÿýÿr
  c                  C   sP   t g d¢tddd�dd�} |  | ¡ ¡ }t ddgdd	�}d|j_t ||¡ d S )
Nrm  z
2022-01-01rB   r   Újanrš  r"   rM   r8  )r   r   r0   rK  r)   r[   r6   ri   r­  r   r   r   Ú1test_groupby_series_with_datetimeindex_month_name´  s
    r  Útest_serieszkwarg, value, name, warn)rC  rÏ   rM   NrC  rØ  )r   r   rM   Nc           
      C   sÐ   t dg d¢itg d¢dd�d�}| r,|d }|jf i ||i¤Ž}d}tj||d�� | |¡}W d   ƒ n1 sr0    Y  | r td	d
gtddgdd�dd�}	n t dd	d
gitddgdd�d�}	t ||	¡ d S )NrÐ   r?  r>  rÏ   r8  r(   z&you will need to pass a length-1 tuplerK   rB   r¾   rM   rš  )r   r
   r0   r6   re   r;  r   rR  )
r  Úkwargr…   r[   r¶   r@  r:   rs   r   r   r   r   r   Ú$test_depr_get_group_len_1_list_likes½  s     (  r  c                  C   sJ   t ttjgƒdgdœƒ} | jddgddd� ¡ }tdgƒ}t ||¡ d S )NrM   rÎ   rÏ   rÐ   F)r  rI  r   )	r   r   r4   rŸ   r0   rW  r   r6   ri   r<  r   r   r   Útest_groupby_ngroup_with_nanÙ  s    
r  c                  C   s˜   t g d¢g d¢g d¢g d¢g d¢dœƒ} tjtdd��" | jd	g d
¢d�}W d   ƒ n1 s^0    Y  | d	¡}t g d¢g d¢dœƒ}t ||¡ d S )N)r   rB   r"   rB   )r¾   rM   r  rQ   )rB   r�   r"   rW   )rM   rÔ  r  rÑ  )éüÿÿÿr!   r  iùÿÿÿ)r  r  Zcol3Zcol4Úcol5Ú
deprecatedrK   rM   )rM   r"   rB   r"   rM   )r£   rC  )r  r  )r   r6   re   rf   r0   r;  r7   rb  r   r   r   Útest_get_group_axis_1á  s"    ûÿ	0
þÿr  c                  C   s`   t dddddtjtjgig d¢d�} | jdd	� ¡ }t dg d
¢ig d¢d�}tj||dd� d S )NrÏ   rM   r"   rB   r¾   rì  r(   r   rz  )rM   r"   rB   r¾   r"   rB   Fr×   )r   r4   rŸ   r0   rz  r6   r7   r<  r   r   r   Ú(test_groupby_ffill_with_duplicated_indexø  s    $r  c                 C   sŒ   t tjtƒrJ ‚ttdƒtdƒd d gtdƒtdƒtdƒtdƒgdœƒ}|jddd	�}| r`|d
 }|jj}t	tdƒd gdd�}t
 ||¡ d S )NrM   r"   rB   r¾   r!   )r   r…   r   F)r  r…   r8  )r%  ÚdecimalÚInvalidOperationr-  r   r   r0   rØ  Zresult_indexr
   r6   rg  )r  r9   r:   r   r   r   r   r   Útest_decimal_na_sort  s    þÿr  )Èr   r  r   r+  Únumpyr4   rl   Zpandas.errorsr   r   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsÚtdZpandas.core.dtypes.commonr   Zpandasr+   r   r   r	   r
   r   r   r   r   r   r   r   r   Zpandas._testingZ_testingr6   Zpandas.core.arraysr   Zpandas.core.commonÚcoreÚcommonrí  ÚmarkÚfilterwarningsZ
pytestmarkr   r;   Zparametrizerv   r|   r�   r¡   r·   r¼   rÌ   rÒ   rÖ   rÞ   rð   rø   r  r  r  r  r  r'  r.  r6  r=  rA  rE  rV  rZ  r[  r^  ra  rc  rf  rh  rj  rm  rp  rv  rx  ry  r{  r|  r�  rƒ  rˆ  rŒ  r�  r“  r™  rŸ  r£  r¤  r°  r²  r³  rµ  rº  r»  r¼  r¿  rÃ  rÈ  rÊ  rÌ  rÏ  rÒ  rÔ  rÚ  rÜ  rä  rå  rò  ró  rù  rú  rþ  r  r  r  r  r  r  r  r'  r+  r/  r;  r?  rð  r�   rT  rV  rW  rX  r_  rb  rd  ri  rk  rr  r|  r}  r~  rŠ  r‹  rŒ  r�  r’  r“  r”  r–  ÚparamZ
skip_if_nor™  rœ  r¥  r¦  rª  r«  r¬  r®  r¯  r³  r»  r¼  rÂ  rÇ  rÈ  rË   rÒ  rÓ  rÕ  rÙ  rÜ  rÞ  rà  rã  rç  rá  rè  rê  rí  rï  rò  ró  rö  rþ  r   r  r  r
  r  rf   r  r  r  r  r  r   r   r   r   Ú<module>   sŽ  8
AH5
ÿ
=(07
 
C"	
þ

þ	
 	-

?-	
 	1þÿõñÿ{	
úÿþúÿþúÿþåþ,

-)þ









ôþ	þþ
&ÿ	þþ
ÿýýúþ	ÿ
)
þ	úþ	