a
    ï½„gá�  ã                   @   sæ  d dl Z d dlZd dlmZ d dlZd dlZd dlm	Z	 d dl
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 d dlmZ d dlmZ ej dd	d
g¡ej dg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢ejejejgg¡dd„ ƒƒZdd„ Z ej dd	d
g¡dd„ ƒZ!ej dd	d
g¡ej dg d¢g d¢ej"ej"ej"gd ej"d gd!ej"d!gd!ej"d gg¡d"d#„ ƒƒZ#ej d$d%d&ej$d!ge%d'�ej$ej"gd(d'�fd)d%ej$ej"gd(d'�ej$d!ge%d'�fd)d)ej$ej"gd(d'�ej$ej"gd(d'�fd&d(ej$ej"gd(d'�ej$ej"gd(d'�fg¡d*d+„ ƒZ&ej dd	d
g¡ej d,g d-¢¡d.d/„ ƒƒZ'ej d0d	ej"ejgd fd	ej"d1ejgd!fd
ej"ej(gd!fd
ej"d ej(gd fg¡d2d3„ ƒZ)ej dd	d
g¡d4d5„ ƒZ*ej dd	d
g¡d6d7„ ƒZ+ej d8d9d:g¡d;d<„ ƒZ,ej d8d9d:g¡d=d>„ ƒZ-ej d?d9d d@gd1dAgd1d@gdBœfd:d1dAgd d@gd dAgdBœfg¡ej dCd!d g¡dDdE„ ƒƒZ.ej dedFƒedGƒfdHg¡ej dIg dJ¢¡dKdL„ ƒƒZ/ej d8dMdNg¡dOdP„ ƒZ0dQdR„ Z1dSdT„ Z2dUdV„ Z3dWdX„ Z4dYdZ„ Z5d[d\„ Z6d]d^„ Z7d_d`„ Z8dadb„ Z9dcdd„ Z:ej dedfdgg¡dhdi„ ƒZ;ej dedfdgg¡djdk„ ƒZ<dldm„ Z=ej dedfdgg¡e>dnœdodp„ƒZ?ej d,g dq¢¡drds„ ƒZ@dtdu„ ZAej deg dv¢¡dwdx„ ƒZBej dedfdgg¡dydz„ ƒZCd{d|„ ZDejjEej d}d d!g¡ej d~d d!g¡ej dd!d g¡ej d€d!d g¡ej d�d‚gd‚dƒgg¡d„d…„ ƒƒƒƒƒƒZFd†d‡„ ZGdˆd‰„ ZHdŠd‹„ ZIdŒd�„ ZJej dŽg d�¢ed�ƒej(ed�ƒgd!ed1gejKd‘gd’d“�dd”�fg d�¢e Ld•d1d1¡ej(e Ld•d1d1¡gd!ed1gejKd‘gd’d“�dd”�fg d–¢e Ld•d1d1¡ej(e Ld•d1d1¡ej(e Ld•d1d1¡gd ed@d@gejKd‘d—gd’d“�dd”�fg d˜¢e Ld•d1d1¡ej(e Ld•d1d1¡ej(e Ld•d1d1¡gd ed@d1gejKd‘d—gd’d“�dd”�fg¡d™dš„ ƒZMd›dœ„ ZNd�dž„ ZOdŸd „ ZPd¡d¢„ ZQej d£d d¤g¡d¥d¦„ ƒZRd§d¨„ ZSd©dª„ ZTej d,g d«¢¡ej d¬dMd­d1d1d®œd@dAd®œgifdNd­d1d@d®œd@d¯d®œgifdfd­d1d1d®œd@dAd®œgifdgd­d1d@d®œd@d¯d®œgifd°d1d@d®œd@d@d®œgd±d²œfg¡d³d´„ ƒƒZUdµd¶„ ZVej d·d¸ejWfd¹ejXfdºejYfd»ejZfd¼ej[fd½ej\fdfej]fdgej^fdMd¾d¿„ fdNdÀd¿„ fd°ej_fej`dÁeVe adÂ¡dÃ�g¡dÄdÅ„ ƒZbej dÆg dÇ¢d1ej"d@d1ej"d@d1ej"d@g	d®œg dÈ¢g dÉ¢d®œg¡ej dÊg dË¢¡dÌdÍ„ ƒƒZcej dÎg dÏ¢¡ej dÐd d1g¡ej dÑd!d g¡ej d}d!d g¡dÒdÓ„ ƒƒƒƒZddÔdÕ„ ZedS )Öé    N)Úascii_lowercase)ÚiNaT)Úpandas_dtype)Úna_value_for_dtype)Ú	DataFrameÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚisna)Ú_test_decoratorsÚagg_funcÚanyÚallÚvals)ÚfooÚbarÚbaz)r   Ú r   )r   r   r   ©é   é   é   )r   r   r   ©r   r   r   )ç      ð?ç       @ç      @)r   ç        r   )r   r   r   )TTT)TFF)FFFc                 C   s–   t dgd dgd  |d dœƒ}tt|ƒ|ƒ}| rLtt|ƒƒrL|dkrLd}t |gd dgtjddgd	d
�d�}t| d	¡|ƒ| d�}t 	||¡ d S )NÚar   Úbr   )ÚkeyÚvalr   Fr!   r    ©Úname©ÚcolumnsÚindex©Úskipna)
r   ÚgetattrÚbuiltinsr   r   ÚpdÚIndexÚgroupbyÚtmÚassert_frame_equal)r(   r   r   ÚdfÚexpÚexpectedÚresult© r4   úg/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/pandas/tests/groupby/test_reductions.pyÚtest_groupby_bool_aggs   s    "ÿr6   c                  C   sr   t g d¢dtjdgdtjdggg d¢d�} t ddgd	dggd
dgddgd�}d|j_|  d¡ ¡ }t ||¡ d S )N)r   r   r   r   r   r   r   ©ÚAÚBÚC©r%   TFr9   r:   r$   r8   )	r   ÚnpÚnanr&   r#   r-   r   r.   r/   ©r0   r2   r3   r4   r4   r5   Útest_any>   s    þÿr?   Úbool_agg_funcc                 C   sP   t ddggddgd�}| dg¡}t|| ƒƒ }| t dg¡¡}t ||¡ d S )NTr   r;   r   )r   r-   r)   Zset_axisr<   Úarrayr.   r/   )r@   r0   Zgrp_byr3   r2   r4   r4   r5   Ú test_bool_aggs_dup_column_labelsK   s
    rB   ÚdataFTc                 C   sZ   t |dd�}t|| ƒ|d�}t |t dg¡dd�}| g d¢¡j| |d�}t ||¡ d S )NÚboolean©Údtyper'   r   ©r&   rF   r   )r   r)   r<   rA   r-   Úaggr.   Úassert_series_equal)r@   r(   rC   ÚserZexpected_datar2   r3   r4   r4   r5   Útest_masked_kleene_logicV   s
    rK   zdtype1,dtype2,exp_col1,exp_col2ÚfloatÚFloat64rE   rD   ÚInt64c                 C   sn   dt jg}ttj|| d�tj||d�dœƒ}| ddg¡jddd�}t||dœt  dg¡d�}t ||¡ d S )	Nr   rE   )Úcol1Úcol2r   r   Fr'   ©r&   )	r<   r=   r   r+   rA   r-   rH   r.   r/   )Zdtype1Zdtype2Zexp_col1Zexp_col2rC   r0   r3   r2   r4   r4   r5   Útest_masked_mixed_typeso   s    
ÿrR   rF   )rN   rM   rD   c                 C   sh   |t jdg|d�}d}|s(| dkr(t j}||gt dg¡dd�}| ddg¡j| |d�}t ||¡ d S )Nr   rE   Tr   rD   rG   r'   )r+   ÚNAr<   rA   r-   rH   r.   Úassert_equal)r@   rF   r(   Úframe_or_seriesÚobjÚexpected_resr2   r3   r4   r4   r5   Útest_masked_bool_aggs_skipna˜   s    rX   zbool_agg_func,data,expected_resr   c                 C   sN   ||t d�}| dgt|ƒ ¡ | ¡}||gt dg¡dd�}t ||¡ d S )NrE   r   ÚboolrG   )Úobjectr-   ÚlenrH   r<   rA   r.   rT   )r@   rC   rW   rU   rV   r3   r2   r4   r4   r5   Útest_object_type_missing_vals¦   s    r\   c                 C   sX   t tjgtd�}tjtdd��& | dg¡j| dd� W d   ƒ n1 sJ0    Y  d S )NrE   z boolean value of NA is ambiguous©Úmatchr   Fr'   )	r   r+   rS   rZ   ÚpytestÚraisesÚ	TypeErrorr-   rH   )r@   rJ   r4   r4   r5   Ú'test_object_NA_raises_with_skipna_false·   s    rb   c                 C   sj   | t u rddginddi}| f i |¤dti¤Ž}t| |j¡|ƒƒ }| f i |¤dti¤Ž}t ||¡ d S )Nr%   r   r#   rF   )r   rZ   r)   r-   r&   rY   r.   rT   )rU   r@   ÚkwargsrV   r3   r2   r4   r4   r5   Ú
test_empty¿   s
    rd   ÚhowZidxminÚidxmaxc           	      C   s¤   |t u s|tu rd S d|v r"tjntj}||ƒj}||ƒj}tg d¢||||gdœ|d�}| d¡}t	|| ƒƒ }tdddgit
jdd	gd|d
�d�}t ||¡ d S )NÚint)r   r   r   r   ©r   r   rE   r   r   r   r   r   ©r#   rF   rQ   )rg   rL   r<   ZiinfoÚfinfoÚminÚmaxr   r-   r)   r+   r,   r.   r/   )	re   Zany_real_numpy_dtypeÚinfoÚ	min_valueÚ	max_valuer0   Úgbr3   r2   r4   r4   r5   Útest_idxmin_idxmax_extremesÉ   s    

þ
ÿrq   c                 C   s  t  |¡j}t  |¡j}ttt jtddƒdd�dd�tt j|t j||t j|t jt jt jg
|d�dœƒ}| 	d¡}| rxd nt
}d	|› d
�}tj||d��  t||ƒ| d�}	W d   ƒ n1 s¼0    Y  | rÜddddt jg}
nt j}
td|
itjtddƒddd�d�}t |	|¡ d S )Nr   é   r   )ZrepeatsZintprE   rh   r   z!The behavior of DataFrameGroupBy.z with all-NA valuesr]   r'   r   é   r   ri   rQ   )r<   rj   rk   rl   r   r   ÚrepeatÚranger=   r-   ÚFutureWarningr.   Úassert_produces_warningr)   r+   r,   r/   )r(   re   Zfloat_numpy_dtypern   ro   r0   rp   ÚwarnÚmsgr3   Úvaluesr2   r4   r4   r5   Ú"test_idxmin_idxmax_extremes_skipnaÞ   s@    öóþÿ
.ÿr{   zfunc, valuesr   r   )Úc_intÚc_floatÚc_dateÚnumeric_onlyc                 C   s*  t g d¢g d¢g d¢g d¢dœƒ}t |d ¡|d< |d j d¡|d< |d |d jd	  |d
< |d j d¡|d< |d  d¡|d< |d  d¡|d< t| 	d¡| ƒ|d�}t |tj
ddgdd�d�}|rÞ|jdgd�}n$|d |d< |d |d
< |d |d< |d |d< |d |d< t ||¡ d S )N©r8   r8   r9   r9   ©r   r   r   rs   )g®Gáz@g=
×£p=@gR¸…ëQ @gÍÌÌÌÌÌð?)Z2019Z2018Z2016Z2017)r#   r|   r}   r~   r~   z
US/PacificZ	c_date_tzr   Zc_timedeltaÚWZc_periodr|   rN   Z	c_Integerr}   rM   Z
c_Floatingr#   ©r   r8   r9   r"   rQ   r;   )r   r+   Úto_datetimeÚdtZtz_localizeÚilocZ	to_periodÚastyper)   r-   r,   Údropr.   r/   )Úfuncrz   r   r0   r3   r2   r4   r4   r5   Ú$test_idxmin_idxmax_returns_int_types  s.    
üÿrŠ   z2011-01-15 12:50:28.502376z2011-01-20 12:50:28.593448)l    m;-L¼l    m;-L¼Úmethod)Úcountrk   rl   ÚfirstÚlastc                 C   s˜   t ddg|dœƒ}| d¡}t|| ƒƒ }| dkr6d}n4| dkrH|d }n"| dkrZ|d }nt|d	 | ƒƒ }t d	|gitjdgdd
�d�}t ||¡ d S )Nr   rh   r   rŒ   r   r�   r   rŽ   r   r"   rQ   )r   r-   r)   r+   r,   r.   r/   )r‹   rC   r0   Úgroupedr3   Zexpected_valuer2   r4   r4   r5   Ú2test_groupby_non_arithmetic_agg_int_like_precision/  s    


r�   r�   rŽ   c              	   C   s¸   t t| ƒƒ}tg d¢|d|dtjtjg|d|dtjtjgdœ| d�}|jd|d�}t||ƒ}||d�}g d	¢g d
¢g d¢g d¢dœ||f }	|j|	  d¡}
|r¨|
 	¡ }
t
 ||
¡ d S )N)r   r   r   r   r   r   r   ç      @©r   r   ÚcrE   r   )Úsortr'   )r   r   rs   )r   r   rs   )r   r   é   )r   r   r•   ))r�   T)r�   F)rŽ   T)rŽ   F)r   r   r   r<   r=   r-   r)   r†   Ú	set_indexÚ
sort_indexr.   r/   )Zany_real_nullable_dtyper”   r(   re   Zna_valuer0   rp   r‹   r3   Zilocsr2   r4   r4   r5   Útest_first_last_skipnaM  s,    ýú

üûr˜   c               	   C   s@  t tj d¡ d¡g d¢d�} g d¢| d< |  d¡}d}tjt|d�� |j	d	d
�}W d   ƒ n1 sh0    Y  | j
d d …d	d …f j	d	d
�}|j d	¡}t || | d¡¡ tddd�| d< |  d¡}d}tjt|d��L tjt|d�� |j	d	d
� W d   ƒ n1 �s0    Y  W d   ƒ n1 �s20    Y  d S )Nr   )é
   rs   )r8   r9   r:   ÚDr;   )
r   r   r   r   r   r   r   r   r   rs   r8   z1DataFrameGroupBy.idxmax with axis=1 is deprecatedr]   r   ©Úaxisz
2016-01-01r™   ©ÚperiodsÚEz>'>' not supported between instances of 'Timestamp' and 'float')r   r<   ÚrandomÚdefault_rngÚstandard_normalr-   r.   rw   rv   rf   r†   r&   Zget_level_valuesrI   Z	droplevelr
   r_   r`   ra   )r0   rp   Zwarn_msgÚresZaltZindexerÚgb2ry   r4   r4   r5   Útest_idxmin_idxmax_axis1i  s"    ÿ
*
r¥   c                  C   s8   t g d¢g d¢dœƒ} |  d¡d  ¡ d dks4J ‚d S )N)r8   r8   r8   r8   r8   )ij  i�  io  i`  l    @Ü~ÿÿ )ÚuserÚconnectionsr¦   r§   r8   l    ,fÌL™ )r   r-   Úmean)r0   r4   r4   r5   Útest_groupby_mean_no_overflowƒ  s    þÿr©   c                  C   sh   t t tdƒ¡ddgd dœƒ} |  d¡d  ¡ }tt ddg¡dtjddgdd	�d
�}t 	||¡ d S )Nr™   r8   r9   r•   )ÚtimeÚcatr«   rª   rs   r"   ©r#   r&   )
r   r+   Zto_timedeltaru   r-   r¨   r   r,   r.   rI   ©r0   r3   r2   r4   r4   r5   Útest_mean_on_timedeltaŽ  s     ÿr®   c                  C   s0  t j d¡ d¡} t j| d d d…< t| ƒ}t j d¡jdddd� t¡}t j|d d d…< | 	|¡ 
¡ }d}tjt|d��" | 	|¡ t j¡}W d   ƒ n1 s 0    Y  t ||¡ tt j d¡ d	¡ƒ}d}tjt|d��" | 	|¡ t j
¡}W d   ƒ n1 �s0    Y  | 	|¡ 
¡ }t ||¡ d S )
Nr   éè  r   é2   ©Úsizeé   zusing DataFrameGroupBy.medianr]   )r¯   r•   )r<   r    r¡   r¢   r=   r   Úintegersr‡   rL   r-   Úmedianr.   rw   rv   rH   Z	nanmedianr/   )Úarrr0   Úlabelsr3   ry   r1   ÚrsZxpr4   r4   r5   Útest_cython_median˜  s     02r¹   c                 C   sp   t tj d¡ ddd¡ƒ}tdddƒ}t |d |¡}|j|| d� 	¡ }|j|| d� 
dd	„ ¡}t ||¡ d S )
Nr   r   é,   éô  é7   r•   ©Úobservedc                 S   s   |   ¡ S )N)rµ   ©Úxr4   r4   r5   Ú<lambda>µ  ó    z(test_median_empty_bins.<locals>.<lambda>)r   r<   r    r¡   r´   ru   r+   Úcutr-   rµ   rH   r.   r/   )r¾   r0   ZgrpsZbinsr3   r2   r4   r4   r5   Útest_median_empty_bins®  s    rÄ   c                  C   s’   t g d¢g d¢ddg dœƒ} |  d¡ ¡ }d|v s8J ‚|  d¡jdd	�}d|v sVJ ‚|  d¡ ¡ }d|v spJ ‚|  d¡jdd	�}d|v sŽJ ‚d S )
N)é   rÅ   é   rÆ   r�   rs   Zmama)ÚnnÚiiÚssrÇ   rÉ   Frƒ   )r   r-   rl   rk   )Zaar3   r4   r4   r5   Útest_max_min_non_numeric¹  s    rÊ   c                 C   sÊ   t g d¢g d¢g d¢dœƒ}| ¡  | s<t|jjƒdks<J ‚| d¡}|dg  ¡ }tjg d¢dd	�}t dg d
¢i|d�}t	 
||¡ |dg  ¡ }tjg d¢dd	�}t dg d¢i|d�}t	 
||¡ d S )N)r   r   r   r   r   )r   r   r   r   F)r   r   r“   ÚdÚer7   r   r8   r:   r   r"   )r   rË   rÌ   rQ   )r   r“   rÌ   )r   Z_consolidate_inplacer[   Z_mgrÚblocksr-   rl   r+   r,   r.   r/   rk   )Zusing_array_managerr0   rp   r3   Úeir2   r4   r4   r5   Ú$test_max_min_object_multiple_columnsÊ  s$    ýÿ
rÏ   c                  C   s¦   t jtg d¢ƒdd�jj} ttjdtjgg d¢| dœƒ}|jddd	�d
  	¡ d
 }t jtddgd
d�dd�jj}t
 ||¡ | d¡d
  	¡ }d|j_t
 ||¡ d S )N)ú
2019-05-09rÐ   rÐ   z%Y-%m-%d)ÚformatÚ1)r   r   r   r’   r   F©Úas_indexr“   rÐ   r"   )r+   r„   r   r…   Údater   r<   r=   r-   rk   r.   rI   r&   r#   )Údatesr0   r3   r2   r4   r4   r5   Útest_min_date_with_nansé  s    ÿ
ÿ
r×   c                  C   s´   t dtgƒ} tjddgtjd�}|  |¡}|jdd�}t dditjd�}tj||dd� |j	dd�}t dtitjd�}tj||dd� |j	dd�}t dtj
iƒ}tj||dd� d S )Nr   rE   r   ©Ú	min_countT©Zcheck_exactr   )r   r   r<   rA   Úint64r-   rl   r.   rI   rk   r=   )rJ   r    rp   r3   r2   r4   r4   r5   Útest_max_inatû  s    
rÜ   c                  C   sh   t dtdtd gƒ} |  g d¢¡}|jdd�}t tjtjtd dœƒ}|j t¡|_t	j
||dd� d S )Nr   r   )r   r   r   r   rØ   r   TrÚ   )r   r   r-   rk   r<   r=   r&   r‡   rg   r.   rI   )rJ   rp   r3   r2   r4   r4   r5   Útest_max_inat_not_all_na  s    rÝ   r‰   rk   rl   c                 C   sl   ddg}t jdddd�}t||dœƒ}t| d¡d | ƒƒ }t jddgdd	�}t||dd
�}t ||¡ d S )Nr   r   Ú2020ÚY©rž   Úfreqrh   r   r   r"   ©r&   r#   )	r+   Úperiod_ranger   r)   r-   r,   r   r.   rI   ©r‰   Úgroupsrž   r0   r3   Úidxr2   r4   r4   r5   Ú$test_groupby_aggregate_period_column  s    rç   c                 C   sj   ddg}t jdddd�}t||dœƒ}t| d¡| ƒƒ }t jddgdd�}td	|i|d
�}t ||¡ d S )Nr   r   rÞ   rß   rà   rh   r   r"   r   rQ   )r+   rã   r   r)   r-   r,   r.   r/   rä   r4   r4   r5   Ú#test_groupby_aggregate_period_frame+  s    rè   c                  C   sÔ   t g d¢tdƒtjgd dœƒ t¡} |  d¡ ¡ }t ddgdd	gtjtjgdœƒ d¡ t¡}t	 
||¡ t g d¢tdƒtdƒdœƒ t¡} |  d¡ ¡ }t ddgdd	gd
dgdœƒ d¡ t¡}t	 
||¡ d S )Nr€   Úabcdrs   )r    rO   rP   r    r8   r9   r   r“   r   r   )r   Úlistr<   r=   r‡   rZ   r-   rk   r–   r.   r/   ru   r­   r4   r4   r5   Ú#test_aggregate_numeric_object_dtype9  s8    ÿþÿýüÿÿþÿþÿrë   )r‰   c                 C   sz   t dgdd�j ¡ }tdg|dœƒ}| d¡ d| i¡}tddgitjdgdd�d	�}|d  |j	¡|d< t
 ||¡ d S )
Nr   ÚcategoryrE   iÍ  ©r8   r9   r8   r9   r"   rQ   )r   r«   Z
as_orderedr   r-   rH   r+   r,   r‡   rF   r.   r/   )r‰   Zdsr0   r3   r2   r4   r4   r5   Ú%test_aggregate_categorical_lost_indexW  s    rî   )rN   ZInt32rM   ZFloat32rD   c                 C   s„  | dkrd}n| dkrd}nd}t ddg||d gdœƒ}|d	  | ¡|d	< | d
¡}| ¡ }|jd d…  d
¡}t ||¡ | ¡ }|jdd …  d
¡}t ||¡ |jdd�}t d	t	j
gi|j| d�}	t ||	¡ |jdd�}
t |
|	¡ t g d¢|t	j
|d gdœƒ}|d	  | ¡|d	< | d
¡}| ¡ }t ||¡ | ¡ }t ||¡ |jdd�}t ||	¡ |jdd�}t ||	¡ d S )NrN   l   ².¿Dÿ²3 rD   r   r‘   r   r   )ÚidÚtsrð   rï   r   rØ   rG   )r   r   r   éd   )r   r‡   r-   rk   r†   r–   r.   r/   rl   r+   rS   r&   )rF   rð   r0   rp   r3   r2   Zres_maxZexpected_maxÚresult2Z	expected2Zres_max2Zdf2r¤   Zresult3Zres_max3Zresult4Zres_max4r4   r4   r5   Útest_groupby_min_max_nullablee  s<    

ró   c                  C   s²   t jdgd ddgd�} t| t  tjdtjd�¡dœƒ}|jddd	�}| ¡ }t j	ddg| j
dd
�}tdt jdt jgdd�i|d�}t ||¡ | ¡ }d|jd< t ||¡ d S )Nr   r™   r   )Ú
categoriesrE   rí   r8   Fr½   ©rF   r#   r9   ZUInt64rQ   é	   )r   r   )r+   ÚCategoricalr   rA   r<   ZarangeÚuint64r-   rk   ÚCategoricalIndexrF   rS   r.   r/   rl   r†   )r«   r0   rp   r£   ræ   r2   r4   r4   r5   Ú(test_min_max_nullable_uint64_empty_group•  s      
rú   )r�   rŽ   rk   rl   c                 C   s˜   t tjdgtdƒdd�tjdgddgdd�ddœƒ}t|jd	d
d�| ƒƒ }tjddgd	dd�}t tjdd gddgdd�dd gdœ|d�}t ||¡ d S )Nr8   ZABT)rô   Úorderedr   r   gš™™™™™¹?)rO   rP   ÚvaluerO   Fr½   r9   )rC   r#   rû   )rP   rü   rQ   )	r   r+   r÷   rê   r)   r-   rù   r.   r/   )r‰   r0   r3   ræ   r2   r4   r4   r5   Ú test_groupby_min_max_categorical¦  s    ýÿþûrý   c                 C   sn   t  d¡ d}tdgdddœ|d�jd d… }t| d¡| ƒƒ }tddg|tjg |dd	�d
�}t 	||¡ d S )NZpyarrowzstring[pyarrow_numpy]r   r’   rE   r   r   r“   rõ   )r%   rF   r&   )
r_   Zimportorskipr   r†   r)   r-   r+   r,   r.   r/   )r‰   rF   r0   r3   r2   r4   r4   r5   Útest_min_empty_string_dtype½  s    
 ÿrþ   c                  C   sx   t g d¢g d¢ttjtjdgƒg d¢dœƒ} |  d¡}|dg  ¡ }|d  ¡  ¡ }t ||¡ |d  	¡  
¡ rtJ ‚d S )N)z-04-23z-05-06z-05-07)z2013-04-23 00:00:00z2013-05-06 00:00:00z2013-05-07 00:00:00ZOE)zlog080001.logzlog.logZxlsx)z
Unnamed: 0ÚDateZappÚFilerÿ   r   )r   r   r<   r=   r-   rl   Zto_framer.   r/   r   r   )r0   rp   ÚrrÌ   r4   r4   r5   Útest_max_nan_bugÊ  s    øÿ
r  r”   ÚdropnarÔ   Úwith_nanÚkeysÚjoeÚjimc                 C   sf  d}d}t ddd�}ttj d¡ ttƒ|¡tj d¡ ||¡tj d¡ d||¡dœƒ}|rÐ| 	dt
i¡}d |jd	d d
…df< d |jdd d…df< d |jdd d…df< d |jdd d…df< d |jdd d…df< | ¡ }	|j||| d�}
|
d j|d�}|j||| d�}
|
d jtj|d�}|�s.|jdd�}|�rFtj||dd� ntj||dd� t ||	¡ d S )Nrñ   r™   z
2015-08-23r�   r   r   )r  r  Újulier  r   r³   r  r   é%   r  é   é   é   rö   )rÔ   r”   ©r  T)rˆ   F)Zcheck_names)r
   r   r<   r    r¡   Úchoicerê   r   r´   r‡   rL   ÚlocÚcopyr-   ÚnuniqueÚapplyr   Úreset_indexr.   rI   r/   )r”   r  rÔ   r  r  ÚnÚmÚdaysr0   Zoriginal_dfÚgrÚleftÚrightr4   r4   r5   Útest_series_groupby_nuniqueÞ  s6    ýÿr  c                  C   s  t tdƒtdƒtdƒdœƒ} t tdƒg d¢g d¢dœƒ}| jdd	d
� ¡ }t ||¡ tdƒ|_d|j_|jdd�}|  d¡ ¡ }t ||¡ |  	dd i¡ d¡jd	d�}t ||¡ t dgd dgd dœtdƒd�}d|j_|  	dd i¡ d¡ ¡ }t ||¡ d S )NZabbaccZabxaccZabbacxr7   Úabc)r   r   r   )r   r   r   r8   FrÓ   r;   rÀ   r  r   r   )r9   r:   rQ   )
r   rê   r-   r  r.   r/   r&   r#   rˆ   Úreplacer>   r4   r4   r5   Útest_nunique  s    
"r  c                  C   sz   t g d¢g d¢g d¢g d¢g d¢gg d¢d�} |  dd	g¡d
  ¡ }t | j| jg¡}tdgd d
|d�}t 	||¡ d S )N)rñ   r   ZAlice)éÈ   r   ZBob)i,  r   ZCharlie)ipþÿÿrs   ZDan)r»   r•   ZEdith)Úamountrï   r#   r;   rï   r  r#   r   r•   r¬   )
r   r-   r  r   Zfrom_arraysrï   r  r   r.   rI   )rC   r3   r&   r2   r4   r4   r5   Útest_nunique_with_object  s    ûør   c                  C   s8   t dtd�} | jdd� ¡ }t ddd�}t ||¡ d S )Nr#   ri   r   ©ÚlevelrÛ   )r   rZ   r-   r  r.   rI   )rC   r3   r2   r4   r4   r5   Útest_nunique_with_empty_series2  s    r#  c                  C   sr   t tdƒtdƒtdƒgg d¢dœƒ d¡} |  tjdd�¡d	  ¡ }|  tjdd�¡d	  tj¡}t	 
||¡ d S )
Nz2016-06-28 09:35:35z2016-06-28 16:09:30z2016-06-28 16:46:28)rÒ   Ú2Ú3)rª   rC   rª   Úh)rá   rC   )r   r	   r–   r-   r+   ZGrouperr  r  r   r.   rI   ©Útestr3   r2   r4   r4   r5   Útest_nunique_with_timegrouper:  s    ýúÿ	÷
r)  zkey, data, dropna, expected)rÀ   rÀ   rÀ   z
2019-01-01rÀ   r    r"   râ   iã  )rÀ   rÀ   rÀ   Úyr*  r*  )rÀ   rÀ   rÀ   rÀ   r*  c                 C   s6   t | |dœƒ}| dg¡d j|d�}t ||¡ d S )N)r    rC   r    rC   r  )r   r-   r  r.   rI   )r    rC   r  r2   r0   r3   r4   r4   r5   Útest_nunique_with_NaTK  s    +r+  c                  C   sX   t g d¢tjdgdd�d�} |  g d¢¡ ¡ }t dgt dg¡| jd	�}t 	||¡ d S )
N)r   r   r   r8   Zlevel_0r"   r;   r   r   r   )r&   r%   )
r   r+   r,   r-   r  r<   rA   r%   r.   r/   r'  r4   r4   r5   Ú)test_nunique_preserves_column_level_names{  s    r,  c                  C   sL   t tddƒdgd�} |  g d¢¡d  d¡}tg d¢dd�}t ||¡ d S )	Nz
2008-12-31z
2009-01-02rÕ   r;   )r   r   r   r  )r   r   r   r"   )r   r
   r-   Z	transformr   r.   rI   r­   r4   r4   r5   Ú$test_nunique_transform_with_datetimeƒ  s    r-  c                 C   sn   t dgƒ d¡}|d d… }|j|| d�}| ¡ }| rNt g |d d… dd�}nt dg|dd�}t ||¡ d S )Nr   rì   r   r½   rÛ   rG   )r   r‡   r-   r  r.   rI   )r¾   r«   rJ   rp   r3   r2   r4   r4   r5   Útest_empty_categorical‹  s    r.  c                  C   sÀ   t ddtjdgƒ} |  g d¢¡}d}tjt|d�� | tj	¡}W d   ƒ n1 sT0    Y  d}tjt|d�� | 
tj	¡}W d   ƒ n1 s’0    Y  | 	¡ }t ||¡ t ||¡ d S )Nr   r   r   )r   r   r   r   zusing SeriesGroupBy.sumr]   zusing np.sum)r   r<   r=   r-   r.   rw   rv   rH   r*   Úsumr  rI   )Úsr�   ry   r3   rò   r2   r4   r4   r5   Útest_intercept_builtin_sum˜  s    **r1  rÙ   r™   c                 C   sÐ   d}d}t j}tj|||||||gdd�}tg d¢|dœƒ}| d¡j| d�}| d	kr�td
tjg d¢dd�itjg d¢dd�d�}t 	||¡ n<td
tjtj
gd dd�itjg d¢dd�d�}t 	||¡ d S )NTFrD   rE   )r   r   r   r   r   r   r   rí   r8   rØ   r   r9   )r   r   r   rN   r   r"   rQ   r   )r<   r=   r+   rA   r   r-   r/  r,   r.   r/   rS   )rÙ   r   r   ÚnaZdfgr0   r3   r2   r4   r4   r5   Ú!test_groupby_sum_mincount_boolean©  s"    þþr3  c                  C   s²   t g d¢g d¢g d¢dœdd�} |  d¡}tjg d¢ddd�}|d jdd	�}ttjgd
 d|dd�}t ||¡ |jdd	�}t tjgd
 tjgd
 dœd|d�}t 	||¡ d S )N)r   r   r   r’   rN   rE   r   ri   r   r   rØ   r   )rF   r&   r#   )r   r“   )rF   r&   )
r   r-   r+   r,   r/  r   rS   r.   rI   r/   )r0   r�   ræ   r3   r2   r4   r4   r5   Ú0test_groupby_sum_below_mincount_nullable_integerÀ  s     
$r4  c                  C   sÎ   t g d¢t d¡t d¡t d¡tjgdœƒ} tjdd�}|  d¡}| ¡ }t d	||gitjd
dgdd�d�}t ||¡ |d	  ¡ }t 	||d	 ¡ |d	 jdd�}t
|tjgdd	|jd�}t 	||¡ d S )N)r   r   r   r   Z1dZ2dZ3drh   r   )r  r   r   r   r   r"   rQ   rØ   zm8[ns])rF   r#   r&   )r   r+   Z	TimedeltaÚNaTr-   r/  r,   r.   r/   rI   r   r&   )r0   Ztd3rp   r£   r2   r4   r4   r5   Ú#test_groupby_sum_timedelta_with_natÏ  s    þÿ
"r6  )Zint8Zint16Zint32rÛ   Zfloat32Zfloat64rø   zmethod,datar0   rh   rs   rŒ   rÛ   )r0   Úout_typec           	      C   s¸   t dddœdddœdddœdddœgƒ}|j | ¡|d< d|vrHg |d< d|v rZ|d }n| }|d	 }t |ƒ}|j |¡|d< |jd
dd� | d
¡}t||ƒ|d Ž }t ||¡ d S )Nr   rh   r   r   rs   r   Úargsr7  r0   r   T)Zinplace)r   r   r‡   r–   r-   r)   r.   r/   )	rF   r‹   rC   r0   r7  r1   Zdf_outZgrpdÚtr4   r4   r5   Ú%test_groupby_non_arithmetic_agg_typesç  s     "ÿ

r:  c                  O   s   ddl m} || ddi|¤ŽS )Nr   )ÚsemZddofr   )Zscipy.statsr;  )r8  rc   r;  r4   r4   r5   Ú	scipy_sem  s    r<  z	op,targopr¨   rµ   ÚstdÚvarr/  Úprodc                 C   s
   | j d S )Nr   ©r†   r¿   r4   r4   r5   rÁ      rÂ   rÁ   c                 C   s
   | j d S )Néÿÿÿÿr@  r¿   r4   r4   r5   rÁ   !  rÂ   r;  Zscipy)Zmarksc                 C   s®   t tj d¡ d¡ƒ}tj d¡jdddd� t¡}t| 	|¡| ƒƒ }| dv rRd nt
}d| › �}tj||d��  | 	|¡ |¡}W d   ƒ n1 s”0    Y  t ||¡ d S )	Nr   r¯   r   r°   r±   )r�   rŽ   rŒ   r;  zusing DataFrameGroupBy.r]   )r   r<   r    r¡   r¢   r´   r‡   rL   r)   r-   rv   r.   rw   rH   r/   )ÚopZtargopr0   r·   r3   rx   ry   r2   r4   r4   r5   Útest_ops_general  s    
.rC  rz   )	r   r   r   r   r   r   r   r   r   )r   r   r   r   r   r   )r   r   r   r   r   r   Úfunction)r¨   rµ   r>  c                 C   s¼   |dkrdnd}t j|gd td�}tjg d¢ddd	�}td
|i|d� d¡}t| dd� d¡}t||ƒƒ }t	 
||¡ | |¡}t	 
||¡ | |g¡}t d
|fg¡|_t	 
||¡ d S )Nr>  g      à?g      ø?r   rE   r   r   rN   ri   r   rQ   rM   )r<   rA   rL   r+   r,   r   r‡   r-   r)   r.   r/   rH   r   Úfrom_tuplesr%   )rz   rD  Úoutputr¶   ræ   r2   rå   r3   r4   r4   r5   Ú,test_apply_to_nullable_integer_returns_float2  s    
rG  rB  )
r/  r?  rk   rl   rµ   r¨   Úskewr=  r>  r;  rœ   r(   c           
         s   t dgƒ}ˆ dkr|}d}n
|j}d}tjt|d��  |jdˆ |d�}W d   ƒ n1 sZ0    Y  ˆdkr¸t|ˆƒˆd�}|jdd� ‡ ‡‡fd	d
„¡}	|rª|	jˆ d�}	t 	||	¡ nDt|ˆƒƒ }|jdd� ‡ ‡fdd
„¡}	|rð|	jˆ d�}	t 	||	¡ d S )Nr   zAThe 'axis' keyword in DataFrame.groupby is deprecated and will bez+DataFrame.groupby with axis=1 is deprecatedr]   )r"  rœ   r”   rH  r'   r!  c                    s   t | ˆƒˆ ˆd�S )N)rœ   r(   ©r)   ©r&  ©rœ   rB  r(   r4   r5   rÁ   v  rÂ   z3test_regression_allowlist_methods.<locals>.<lambda>r›   c                    s   t | ˆƒˆ d�S )Nr›   rI  rJ  )rœ   rB  r4   r5   rÁ   }  rÂ   )
r   ÚTr.   rw   rv   r-   r)   r  r—   r/   )
rB  rœ   r(   r”   Z	raw_frameÚframery   r�   r3   r2   r4   rK  r5   Ú!test_regression_allowlist_methodsQ  s*    
.ÿrN  c                  C   s¤   ddgddgddgddgddgddgddgdd	gdd
gddgddgddgddgddgg} t | ddgdd�}| dg¡ ¡  ¡ }t dgdgdœdd�}t ||¡ d S )Nr   rÅ   é)   r³   r	  r
  é   é   r   r   é+   r•   é/   r  éX   r8   r9   rÛ   )r%   rF   l   �N+R@rí   rE   )r   r-   r?  r  r.   r/   )rC   r0   r3   r2   r4   r4   r5   Ú"test_groupby_prod_with_int64_dtypeƒ  s&    òrU  )fr*   Údatetimer…   Ústringr   Únumpyr<   r_   Zpandas._libs.tslibsr   Zpandas.core.dtypes.commonr   Zpandas.core.dtypes.missingr   Zpandasr+   r   r   r   r	   r
   r   Zpandas._testingZ_testingr.   Zpandas.utilr   ÚtdÚmarkZparametrizer=   r6   r?   rB   rS   rK   rA   rY   rR   rX   r5  r\   rb   rd   rq   r{   rŠ   r�   r˜   r¥   r©   r®   r¹   rÄ   rÊ   rÏ   r×   rÜ   rÝ   rç   rè   rë   Ústrrî   ró   rú   rý   rþ   r  Zslowr  r  r   r#  r)  r,   rÕ   r+  r,  r-  r.  r1  r3  r4  r6  r:  r<  r¨   rµ   r=  r>  r/  r?  rk   rl   r²   ÚparamZ
skip_if_norC  rG  rN  rU  r4   r4   r4   r5   Ú<module>   sÞ   óþ




úþüüüüíþ
üþ	


	

(þþ þûþ





/

"üüûöûöçþ)

ÿûþ


ôþ
þûþ
þ 