3
®yb‚ô  ã               @   s.  d dl m Z  d dlmZ d dlmZ d dlZd dlZd dlm	Z	 d dl
Zd dl
mZmZmZmZmZmZmZ d dljZd dlmZ d dljjZdd	„ Zejjd
ddddgƒdd„ ƒZdd„ Z dd„ Z!dd„ Z"dd„ Z#dd„ Z$dd„ Z%ejjd
ddddddgƒ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/d0„ Z.ejjd1d2d3„ d4d3„ gƒd5d6„ ƒZ/d7d8„ Z0d9d:„ Z1d;d<„ Z2d=d>„ Z3d?d@„ Z4dAdB„ Z5dCdD„ Z6dEdF„ Z7dGdH„ Z8dIdJ„ Z9dKdL„ Z:dMdN„ Z;dOdP„ Z<dQdR„ Z=dSdT„ Z>dUdV„ Z?dWdX„ Z@dYdZ„ ZAd[d\„ ZBd]d^„ ZCd_d`„ ZDdadb„ ZEdcdd„ ZFdedf„ ZGdgdh„ ZHdidj„ ZIdkdl„ ZJdmdn„ ZKdodp„ ZLdqdr„ ZMejjNdsƒdtdu„ ƒZOdvdw„ ZPdxdy„ ZQdzd{„ ZRd|d}„ ZSd~d„ ZTd€d�„ ZUd‚dƒ„ ZVd„d…„ ZWd†d‡„ ZXdˆd‰„ ZYdŠd‹„ ZZdŒd�„ Z[dŽd�„ Z\d�d‘„ Z]d’d“„ Z^ejjd”d•d•d–ggƒd—d˜„ ƒZ_d™dš„ Z`d›dœ„ Zad�dž„ ZbdŸd „ Zcd¡d¢„ Zdd£d¤„ Zed¥d¦„ Zfd§d¨„ Zgejjd©dªd«d¬dªd«gdªd¬ggƒejjd­d®d¯d®d¯ggƒd°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É„ ZtejjdÊdËdËggƒdÌdÍ„ ƒZuej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Ø„ ƒZvdÙdÚ„ ZwdÛdÜ„ ZxdÝdÞ„ Zyejjdßdàdágƒdâdã„ ƒZzejjdäejdådågƒejj{døƒgƒejjNdæƒdçdè„ ƒƒZ|dédê„ Z}dëdì„ Z~ejjdídùdúgƒdòdó„ ƒZdôdõ„ Z€dS )ûé    )Údatetime)ÚDecimal)ÚStringION)ÚPerformanceWarning)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚread_csv)ÚSpecificationErrorc              C   s&   t tjddd�ƒ} d}| |ks"t‚d S )NÚAÚB)ÚkeyÚlevelz/Grouper(key='A', level='B', axis=0, sort=False))ÚreprÚpdÚGrouperÚAssertionError)ÚresultÚexpected© r   úE/tmp/pip-install-4cy230dp/pandas/pandas/tests/groupby/test_groupby.pyÚ	test_repr   s    r   ÚdtypeÚint64Zint32Úfloat64Zfloat32c                sÄ  t tjdƒd tjdƒ| d�}tjdƒ}tjj|ƒ |j|ƒ}|jdd„ ƒ}x |D ]\}}t|ƒdksRt‚qRW |j	tj
ƒ}|d dksŠt‚tj||jtj
ƒƒ tj||j
ƒ ƒ tj|jtjƒ|jƒ ƒ |jdd„ ƒ}|jdd„ ƒ}|d	 d
ksòt‚tj||ƒ |j|ƒ}	tj|	j	tj
ƒ|dd� |j	tj
tjgƒ}d}
tjt|
d�� |j	tj
tjdœƒ W d Q R X ddddœ‰ |j‡ fdd„ƒ}|d dk�s”t‚d}
tjt|
d�� |j	dd„ ƒ W d Q R X d S )Né	   é   )Úindexr   c             S   s   | d S )Nr   r   )Úxr   r   r   Ú<lambda>!   s    ztest_basic.<locals>.<lambda>é   c             S   s   | | j ƒ  S )N)Úsum)r!   r   r   r   r"   -   s    c             S   s   | | j ƒ  S )N)r$   )r!   r   r   r   r"   .   s    é   é   F)Zcheck_index_typeznested renamer is not supported)Úmatch)ÚoneÚtwoé
   é   é   )r   r#   é   c                s   ˆ | j  | jƒ  S )N)ÚnameÚmean)r!   )Úgroup_constantsr   r   r"   ?   s    é   zMust produce aggregated valuec             S   s   | d S )Nr-   r   )r!   r   r   r   r"   F   s    )r	   ÚnpÚarangeÚrandomÚshuffleÚreindexÚgroupbyÚlenr   Ú	aggregater/   ÚtmÚassert_series_equalÚaggr$   ÚapplyÚ	transformÚstdÚpytestÚraisesr   Ú	Exception)r   Údatar    ÚgroupedÚkÚvÚaggedr   ÚtransformedZvalue_groupedÚmsgr   )r0   r   Ú
test_basic   s:    


rJ   c       	      C   sÂ   | j jd }| j|ƒ}|jƒ }| j|jdƒƒjƒ }tj||ƒ |jƒ }tt	|ƒƒ|d< dd„ }|jdƒj
|ƒ}|j}ttjdƒgd tjd	ƒgd  tjd
ƒg dddddgd�}tj||ƒ d S )Nr   ÚOÚvaluec             S   s   | j | d jƒ  S )NrL   )ÚlocÚidxmax)Úgroupr   r   r   Ú	max_valueU   s    z/test_groupby_nonobject_dtype.<locals>.max_valuer   Úobjectr-   r   r   r   ÚCÚD)r    )r    Úcodesr7   r$   Úastyper:   Úassert_frame_equalÚcopyÚranger8   r=   Zdtypesr	   r2   r   r;   )	ÚmframeZdf_mixed_floatsr   rD   r   r   ÚdfrP   Zappliedr   r   r   Útest_groupby_nonobject_dtypeI   s    
*r[   c              C   s(  t dddœdddœdddœdddœgƒ} dd	„ }tjtƒ� | jd
dd�j|ƒ}W d Q R X t|tƒsht‚t dddœdddœdddœdddœgƒ}dd	„ }tjtƒ� |jd
dd�j|ƒ}W d Q R X t|tƒsÐt‚t ddgddggddgd�}tjtƒ� |jddd�j	ƒ }W d Q R X t|t ƒ�s$t‚d S )Nr#   r+   )Úval1Úval2é   r-   é   r&   c             S   s   | d | d j ƒ  S )Nr]   )r/   )Údatafr   r   r   Úfuncm   s    z&test_groupby_return_type.<locals>.funcr\   T)Zsqueezec             S   s   | d | d j ƒ  S )Nr]   )r/   )r`   r   r   r   ra   }   s    ÚXÚY)ÚcolumnsF)
r   r:   Úassert_produces_warningÚFutureWarningr7   r=   Ú
isinstancer	   r   Úcount)Údf1ra   r   Údf2rZ   r   r   r   Útest_groupby_return_typea   s,    rk   c           	   C   sŠ  t tdddddddgttjdƒdd�tddd�d	�ƒ} d
d„ }| jdƒjƒ dg }| jdƒj|ƒdg }t	j
||ƒ dd„ }| jdƒj|ƒdg }|jƒ }tj|jd< t	j
||ƒ dd„ }| jdƒj|ƒdg }|jƒ }tj|jd< t	j
||ƒ dd„ }| jdƒj|ƒdg }| jdƒjƒ dg }tj|jd< t	j
||ƒ dd„ }| jdƒj|ƒ}| jdƒjƒ d jƒ }tj|jd< d |_t	j||ƒ d S )NÚTigerZLambÚPonyr%   r   )r   Z20130101)Úperiods)r   r   rR   c             S   s
   | j d S )Nr   )Úiloc)Úgrpr   r   r   Úf–   s    z(test_inconsistent_return_type.<locals>.fr   r   c             S   s   | j dkrd S | jd S )Nrl   r   )r.   ro   )rp   r   r   r   rq   �   s    
c             S   s   | j dkrd S | jd S )Nrm   r   )r.   ro   )rp   r   r   r   rq   §   s    
c             S   s   | j dkrd S | jd S )Nrm   r   )r.   ro   )rp   r   r   r   rq   ²   s    
rR   c             S   s   | j dkrd S | jd jd S )Nrm   r   rR   )r.   ro   rM   )rp   r   r   r   rq   ½   s    
)r   Údictr	   r2   r3   r   r7   Úfirstr=   r:   rV   rW   ÚnanrM   r   ÚNaTr.   r;   )rZ   rq   r   r   Úer   r   r   Útest_inconsistent_return_type‹   s<    rw   c             C   sn  ddd„}dd„ }| j dd„ ƒ}|jtjddd�}|jtjddd�}|jtjddd�}|jd	ƒ}|j|ƒ}	tj||ƒ tj||ƒ tj||	ƒ |j|dd
�}|j|dd
�}|j|dd
�}tj||ƒ tj||ƒ tj||	ƒ |j dd„ ƒ}
|
jtjddd�}|
jt	jd	ƒ}|
jd	ƒ}tj
||dd� tj
||ƒ |
j|dd
�}|
jt	jd	d
�}tj
||ƒ tj
||dd� d S )Nr   c             S   s   t j| ||d�S )N)Úaxis)r2   Ú
percentile)r!   Úqrx   r   r   r   rq   Ê   s    z test_pass_args_kwargs.<locals>.fc             S   s   t j| ddd�S )NéP   r   )rx   )r2   ry   )r!   r   r   r   r"   Í   s    z'test_pass_args_kwargs.<locals>.<lambda>c             S   s   | j S )N)Úmonth)r!   r   r   r   r"   Ð   s    r{   )rx   gš™™™™™é?)rz   c             S   s   | j S )N)r|   )r!   r   r   r   r"   ä   s    F)Úcheck_names)Nr   )r7   r<   r2   ry   r=   r>   Zquantiler:   r;   r   rV   )ÚtsÚtsframerq   ÚgZ
ts_groupedZ
agg_resultZapply_resultZtrans_resultZagg_expectedZtrans_expectedÚ
df_groupedr   r   r   r   Útest_pass_args_kwargsÉ   s6    



r‚   c              C   sÜ   t jƒ } | jdd„ dd„ dd„ gƒ}t|ƒt| ƒks8t‚| jdd„ dd„ gƒ}tdd„ | jD ƒƒ}t|ƒ|ksrt‚tjtt	j
gd	 d
dd	gd�ƒ} t| jdƒƒdks¨t‚t| jdƒƒd	ks¾t‚t| jddgƒƒd	ksØt‚d S )Nc             S   s   | j S )N)Úyear)r!   r   r   r   r"   ó   s    ztest_len.<locals>.<lambda>c             S   s   | j S )N)r|   )r!   r   r   r   r"   ó   s    c             S   s   | j S )N)Úday)r!   r   r   r   r"   ó   s    c             S   s   | j S )N)rƒ   )r!   r   r   r   r"   ö   s    c             S   s   | j S )N)r|   )r!   r   r   r   r"   ö   s    c             S   s   h | ]}|j |jf’qS r   )rƒ   r|   )Ú.0r!   r   r   r   ú	<setcomp>÷   s    ztest_len.<locals>.<setcomp>r   r#   r-   )ÚaÚbr‡   r   rˆ   )r:   ÚmakeTimeDataFramer7   r8   r   r    r   r   rr   r2   rt   )rZ   rD   r   r   r   r   Útest_lenñ   s     rŠ   c              C   sN   t dd„ ttddƒƒd D ƒƒ} tjjdƒd }t |ƒ}| j|ƒ}|jƒ  d S )Nc             S   s   g | ]}d | ‘qS )g      ð?r   )r…   r!   r   r   r   ú
<listcomp>  s    z)test_basic_regression.<locals>.<listcomp>r#   r*   iL  g      $@)r	   ÚlistrX   r2   r4   r7   r/   )r   rC   Ú	groupingsrD   r   r   r   Útest_basic_regression  s
     
rŽ   Zint16Zint8c             C   sÖ   t tjdƒƒ}ttjdƒ|| d�}ttjdddtjtjddtjdg
|d�}|j|ƒ}|jtƒ}tddgddgd�}t	j
||dd	� d
d„ }|j|ƒ}tddgddgd�}t	j
||dd	� t|jjtj| ƒjƒsÒt‚d S )Nr*   )r   ÚfooÚbar)r    é   r-   F)Zcheck_dtypec             S   s   t t| ƒƒS )N)Úfloatr8   )r!   r   r   r   rq   !  s    ztest_with_na_groups.<locals>.f)r   r2   r3   r	   Úonesrt   r7   r<   r8   r:   r;   Ú
issubclassr   Útyper   )r   r    ÚvaluesÚlabelsrD   rG   r   rq   r   r   r   Útest_with_na_groups  s    


r˜   c              C   s8  dd„ } dd„ }dd„ }t ddddgtd	ƒtd
dƒdœƒ}t ddddgtd	ƒtd
dƒdœƒ}|jdƒj| ƒ}|jdƒj| ƒ}tj||ƒ d}tjt|d�� |jdƒj|ƒ W d Q R X tjt|d�� |jdƒj|ƒ W d Q R X tjt|d�� |jdƒj|ƒ W d Q R X tjt|d�� |jdƒj|ƒ W d Q R X 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 |jddgƒ}|S d S )Nr-   r#   rˆ   Úc)ÚlevelsrT   Únamesr‡   )rd   r    )rˆ   Úemptyr   r   Ú	set_index)r!   ÚyÚ
multiindexÚresr   r   r   Úf1/  s    z,test_indices_concatenation_order.<locals>.f1c             S   s8   | | j d dk d }|jr"tƒ S |jddgƒ}|S d S )Nr-   r#   rˆ   r™   )rˆ   rœ   r   r�   )r!   rž   r   r   r   Úf29  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-   r#   r�   r�   )rš   rT   r›   r‡   rˆ   )rd   r    )rˆ   rœ   r   r   )r!   rž   rŸ   r    r   r   r   Úf3A  s    z,test_indices_concatenation_order.<locals>.f3r#   r-   r‘   é   r   )r‡   rˆ   r™   r   r‡   z@Cannot concat indices that do not have the same number of levels)r'   )	r   rX   r7   r=   r:   rV   r@   rA   r   )r¡   r¢   r£   rZ   rj   Úresult1Úresult2rI   r   r   r   Ú test_indices_concatenation_order+  s"    
""r§   c          
   C   sœ   | j dd„ ƒ}|jƒ }|jdd„ ƒ}tj||ƒ |jƒ }dd„ |D ƒ}t|ƒj}tj||ƒ |j	}|jdd„ ƒ}d}t
jt|d�� t|d	ƒ W d Q R X d S )
Nc             S   s   | j ƒ S )N)Úweekday)r!   r   r   r   r"   d  s    z#test_attr_wrapper.<locals>.<lambda>c             S   s   t j| dd�S )Nr#   )Zddof)r2   r?   )r!   r   r   r   r"   g  s    c             S   s   i | ]\}}|j ƒ |“qS r   )Údescribe)r…   r.   Zgpr   r   r   ú
<dictcomp>l  s    z%test_attr_wrapper.<locals>.<dictcomp>c             S   s   | j S )N)r   )r!   r   r   r   r"   r  s    z-'SeriesGroupBy' object has no attribute 'foo')r'   r�   )r7   r?   r<   r:   r;   r©   r   ÚTrV   r   r@   rA   ÚAttributeErrorÚgetattr)r~   rD   r   r   rI   r   r   r   Útest_attr_wrapperc  s    
r®   c             C   s‚  | j dd„ ƒ}|jtjƒ}t|ƒdks*t‚t|jƒdks<t‚| jƒ }dd„ |jD ƒ|d< |j dƒjtjƒ}t	j
||dd	� | jd
ƒj dd„ ƒ}|jdd„ ƒ}t|ƒd
ks¬t‚t|jƒdks¾t‚|jdd„ ƒ}x>|D ]6\}}|jƒ }x$|jD ]}	t	j|j|	ƒ|dd	� qêW qÒW x*|D ]"\}
}|jd jƒ |
k�st‚�qW |j}|j}x8|jƒ D ],\}}| jj|| ƒ}||kjƒ �sNt‚�qNW d S )Nc             S   s   | j ƒ S )N)r¨   )r!   r   r   r   r"   {  s    z$test_frame_groupby.<locals>.<lambda>r¤   r‘   c             S   s   g | ]}|j ƒ ‘qS r   )r¨   )r…   r!   r   r   r   r‹   „  s    z&test_frame_groupby.<locals>.<listcomp>r¨   F)r}   r,   c             S   s   | j ƒ S )N)r¨   )r!   r   r   r   r"   ‰  s    c             S   s   | | j ƒ  S )N)r/   )r!   r   r   r   r"   Š  s    c             S   s   | j ƒ S )N)r/   )r!   r   r   r   r"   �  s    r   )r7   r9   r2   r/   r8   r   rd   rW   r    r:   rV   Úheadr>   r;   Úxsr¨   ÚgroupsÚindicesÚitemsÚtakeÚall)r   rD   Ú
aggregatedZtscopyZstraggedrH   r.   rO   r/   Úidxr¨   r±   r²   rE   rF   Z	samethingr   r   r   Útest_frame_groupbyz  s0    r¸   c             C   s¨   dddddœ}| j |dd�}|jtjƒ}t|ƒt| ƒks<t‚t|jƒdksNt‚dd„ }| jj |dd�}tj	|j
|ƒj|j
|ƒƒ x"|D ]\}}t|jƒdks†t‚q†W d S )Nr   r#   )r   r   rR   rS   )rx   r-   c             S   s   | | j ƒ  S )N)r/   )r!   r   r   r   r"   ¬  s    z,test_frame_groupby_columns.<locals>.<lambda>)r7   r9   r2   r/   r8   r   rd   r«   r:   rV   r>   )r   ÚmappingrD   r¶   ÚtfZgroupedTrE   rF   r   r   r   Útest_frame_groupby_columns¢  s    r»   c             C   s   | j dƒ}|jƒ }|jjdks"t‚| j ddd�jƒ }|jjdksDt‚|jtjƒ}|jjdks`t‚|jtjtjdœƒ}|jjdks„t‚|d jƒ }|jjdks t‚|d jtjƒ}|jjdksÀt‚|d jtjtjgƒ}|jjdksæt‚d}tj	t
|d�� |d jtjtjdœƒ W d Q R X d S )	Nr   F)Úas_index)rR   rS   rR   znested renamer is not supported)r'   )r�   r�   )r7   r/   r    r.   r   r<   r2   r?   r@   rA   r   )rZ   rD   r   rI   r   r   r   Útest_frame_set_name_singleµ  s$    
r½   c             C   sä   | d }| d }| j |j|jgƒ}|jƒ }| j ddgƒjƒ }tj|jd d …ddgf |jd d …ddgf dd� ttjj	dƒtjj	dƒtj
dddd	d	d	gƒtj
d
d
d
dddgƒdœddddddgd�} | j ddgƒ}|jtjƒ d S )Nr   r   rR   rS   F)r}   é   rˆ   r‡   Ú1Ú2)Úv1Úv2Úk1Úk2r(   r)   ÚthreeZfourZfiveÚsix)r    rÃ   rÄ   )r7   Úgetr/   r:   rV   rM   r   r2   r4   ÚrandnÚarrayr<   r$   )rZ   Zcol1Zcol2rD   rG   r   r   r   r   Útest_multi_funcÐ  s    0

rÊ   c             C   sR   | j ddgƒd }|jtjtjgƒ}t|jtjƒ|jtjƒdœƒ}tj||ƒ d S )Nr   r   rR   )r/   r?   )r7   r<   r2   r/   r?   r   r:   rV   )rZ   rD   rG   r   r   r   r   Ú!test_multi_key_multiple_functionsì  s    rË   c              C   sþ   t dddddddddddgdddddddddddgdddddddddddgtjjdƒtjjdƒtjjdƒdœƒ} | jd	d
gƒ}tjtjg}|j|ƒ}tj	|d j|ƒ|d j|ƒ|d j|ƒgdddgdd�}t
|jtƒsÞt‚t
|jtƒsît‚tj||ƒ d S )Nr�   r�   r(   r)   ZdullZshinyé   )r   r   rR   rS   ÚEÚFr   r   rS   rÍ   rÎ   r#   )Úkeysrx   )r   r2   r4   rÈ   r7   r/   r?   r<   r   Úconcatrg   r    r   r   r:   rV   )rC   rD   ÚfuncsrG   r   r   r   r   Ú"test_frame_multi_key_function_listô  s^    


&rÒ   Úopc             C   s   | j ƒ S )N)r$   )r!   r   r   r   r"   1  s    r"   c             C   s   | j ƒ S )N)r/   )r!   r   r   r   r"   1  s    c             C   s.  | }|j ddgƒ}||ƒ}g }g }x\|j dƒD ]N\}}xD|j dƒD ]6\}	}
|j||	fƒ |j||
jd d …ddgf ƒƒ qBW q.W tj|ddgd�}tj|dd�j}||_x@dD ]8}||| ƒ}|| }|| }t	j
||ƒ t	j
||ƒ q®W |d j |d |d gƒjƒ }|j ddgƒjƒ d }t	j
||ƒ d S )	Nr   r   rR   rS   )r›   r#   )rx   )rR   rS   )r7   ÚappendrM   r   Úfrom_tuplesr   rÐ   r«   r    r:   r;   r/   )rZ   rÓ   rC   rD   r¥   rÏ   r–   Zn1Zgp1Zn2Zgp2Úmir   ÚcolZ
result_colZpivotedÚexpr   r   r   r   Útest_groupby_multiple_columns1  s*    (
rÙ   c              C   sª   t jddgddgddggddgd�} | jdd	d
�d jdƒ}t jddgdd�}tj||ƒ | jdd	d
�d jdd„ ƒ}t jdddgdt jj	dddgƒd�}tj||ƒ d S )Nr#   r-   r‘   r¤   r¾   r   r   )rd   F)r¼   )r.   c             S   s   | j ƒ S )N)Úcumsum)r!   r   r   r   r"   Y  s    z-test_as_index_select_column.<locals>.<lambda>r   )r.   r    )r   r   )r   r#   )r#   r-   )
r   r   r7   Ú	get_groupr	   r:   r;   r=   r   rÕ   )rZ   r   r   r   r   r   Útest_as_index_select_columnR  s    $ rÜ   c              C   sP   t dddgd�} | jddd�d jƒ }t|ƒt ks6t‚|jƒ i i dœksLt‚d S )Nr   r   rR   )rd   F)Úbyr¼   )r   r   )r   r7   r$   r•   r   Zto_dict)rZ   Úleftr   r   r   Ú0test_groupby_as_index_select_column_sum_empty_df`  s    rß   c             C   s  | j ddd�}|jtjƒ}|jƒ }tj||ƒ |jtjtjdœƒ}|jƒ }|jƒ d |d< tj||ƒ | j ddd�}d}tjt	|d�� |d	 jd
tjiƒ W d Q R X | j ddgdd�}|jtjƒ}|jƒ }tj||ƒ |jtjtjdœƒ}|jƒ }|jƒ d |d< tj||ƒ |d	 jƒ }t
|ƒjd	d
id�}|d	 jd
tjiƒ}tj||ƒ t
tjjdddƒdddgd�} ttjjdddƒdd�}	| j |	ƒ}
|
jdƒ tj|
jtƒ| j |	ƒjtƒƒ xXdD ]P}| j |	dd�}
t|
|ƒƒ }| j |	jdd�}
t|
|ƒƒ jdd�}tj||ƒ �q¾W d S ) Nr   F)r¼   )rR   rS   rS   Tznested renamer is not supported)r'   rR   ÚQr   )rd   r   éd   é2   r   ZjimZjoeZjolier¤   r*   )r.   r/   Úmaxrh   rN   rÚ   rµ   )Zdrop)râ   r   )r/   rã   rh   rN   rÚ   rµ   )r7   r<   r2   r/   r:   rV   r$   r@   rA   r   r   Úrenamer4   Úrandintr	   Únthr=   r­   r–   Úreset_index)rZ   rD   r   r   r¦   Ú	expected2rI   Z	expected3Zresult3r~   ZgrÚattrrÞ   Úrightr   r   r   Útest_groupby_as_index_aggh  sF    


rë   c             C   sä   | dkrt jdƒ | dkr$t jdƒ ttjjdddd
�ddgd�}t|jdƒ| ƒƒ }| dkrf|jdƒ}|j	ƒ }|jddd�}t|| ƒƒ }t
j||ƒ |j| ƒ}t
j||ƒ t|d | ƒƒ }t
j||ƒ |d j| ƒ}t
j||ƒ d S )NÚcorrwithzTest not applicableræ   Úngroupz,Skip until behavior is determined (GH #5755)r   r¤   rá   r-   )Úsizer‡   rˆ   )rd   rî   F)r¼   )rì   )ræ   rí   )rá   r-   )r@   Úskipr   r2   r4   rå   r­   r7   rä   rç   r:   rV   r<   )Zreduction_funcrZ   r   r€   r   r   r   r   Útest_ops_not_as_index   s$    



rð   c             C   s:  | j ddd�}| j ddgdd�}|d jtjƒ}|jtjƒjd d …ddgf }t|tƒs\t‚tj	||ƒ |d jtjƒ}|jtjƒjd d …dddgf }t|tƒs¦t‚tj	||ƒ |d jƒ }|jƒ jd d …ddgf }t|tƒsæt‚tj	||ƒ |d jƒ }|jƒ jd d …dddgf }t|tƒ�s*t‚tj	||ƒ d S )Nr   F)r¼   r   rR   )
r7   r<   r2   r$   rM   rg   r   r   r:   rV   )rZ   rD   Zgrouped2r   r   r¦   rè   r   r   r   Ú!test_as_index_series_return_frame¿  s$     rñ   c          	   C   s>   | j ddd�}d}tjt|d�� |d jdƒ W d Q R X d S )Nr   F)r¼   zColumn\(s\) C already selected)r'   rR   rS   )r7   r@   rA   Ú
IndexErrorÚ__getitem__)rZ   rD   rI   r   r   r   Ú(test_as_index_series_column_slice_raisesØ  s    rô   c             C   sÖ   | }|j ddd�}|jƒ }|j dgƒjƒ }|jdd|jƒ tjt|ƒƒ|_tj||ƒ |j ddgdd�}|jƒ }|j ddgƒjƒ }t	t
|jjŽ ƒ}|jdd|d ƒ |jdd|d ƒ tjt|ƒƒ|_tj||ƒ d S )Nr   F)r¼   r   r   r#   )r7   r/   Úinsertr    r2   r3   r8   r:   rV   rŒ   Úzipr–   )rZ   rC   rD   r   r   Zarraysr   r   r   Útest_groupby_as_index_cythoná  s    r÷   c             C   sN   | j ddgdd�}|d jtƒ}|jtƒjd d …dddgf }tj||ƒ d S )Nr   r   F)r¼   rR   )r7   r<   r8   rM   r:   rV   )rZ   rD   r   r   r   r   r   Ú#test_groupby_as_index_series_scalarø  s    rø   c             C   sf   d}t jt|d�� |jdd„ dd� W d Q R X d}t jt|d�� | jdd„ dd	d
� W d Q R X d S )Nz(as_index=False only valid with DataFrame)r'   c             S   s   | j ƒ S )N)r¨   )r!   r   r   r   r"     s    z.test_groupby_as_index_corner.<locals>.<lambda>F)r¼   z$as_index=False only valid for axis=0c             S   s   | j ƒ S )N)Úlower)r!   r   r   r   r"   	  s    r#   )r¼   rx   )r@   rA   Ú	TypeErrorr7   Ú
ValueError)rZ   r~   rI   r   r   r   Útest_groupby_as_index_corner  s    rü   c             C   s²   t jƒ } | jdd„ dd„ dd„ gƒ}|jƒ }t j| j|jƒ | jjdd„ dd„ dd„ gdd	�}|jd
d„ ƒ}t j|j	| j
ƒ t j| jj|jƒ |jdd„ ƒ}t j| jj|jƒ d S )Nc             S   s   | j S )N)rƒ   )r!   r   r   r   r"     s    z+test_groupby_multiple_key.<locals>.<lambda>c             S   s   | j S )N)r|   )r!   r   r   r   r"     s    c             S   s   | j S )N)r„   )r!   r   r   r   r"     s    c             S   s   | j S )N)rƒ   )r!   r   r   r   r"     s    c             S   s   | j S )N)r|   )r!   r   r   r   r"     s    c             S   s   | j S )N)r„   )r!   r   r   r   r"     s    r#   )rx   c             S   s   | j ƒ S )N)r$   )r!   r   r   r   r"     s    c             S   s   | j ƒ S )N)r$   )r!   r   r   r   r"     s    )r:   r‰   r7   r$   Zassert_almost_equalr–   r«   r<   Úassert_index_equalr    rd   )rZ   rD   rG   r   r   r   Útest_groupby_multiple_key  s    rþ   c             C   sP   | j ƒ } tj| d< | jddgƒjƒ }| jddgƒjƒ }tj|d< tj||ƒ d S )NÚbadr   r   )rW   r2   rt   r7   r/   r:   rV   )rZ   rG   r   r   r   r   Útest_groupby_multi_corner  s    

r   c          
   C   sö   | j dƒ}|jƒ }| jd d …dddgf j dƒjƒ }tj||ƒ |jtjƒ}|jƒ }tj||ƒ | jd d …dddgf } tjƒ | d< | j dƒ}|jtj	ƒ}|j	ƒ }tj||ƒ | j dddddœdd�}d	}t
jt|d
�� |jdd„ ƒ W d Q R X d S )Nr   rR   rS   rÍ   r   r#   )r   rR   rS   rÍ   )rx   z4reduction operation 'sum' not allowed for this dtype)r'   c             S   s   | j ddd�S )Nr   F)Znumeric_only)r$   )r!   r   r   r   r"   @  s    z$test_omit_nuisance.<locals>.<lambda>)r7   r/   rM   r:   rV   r<   r2   r   Únowr$   r@   rA   rú   )rZ   rD   r   r   rG   rØ   rI   r   r   r   Útest_omit_nuisance*  s"    
"
r  c             C   s2   | j ddgƒ}|jtjƒ}|jƒ }tj||ƒ d S )Nr   r   )r7   r<   r2   r/   r:   rV   )Zthree_grouprD   rG   rØ   r   r   r   Ú"test_omit_nuisance_python_multipleC  s    r  c          	   C   sÔ   t tjddddddgƒtjddddddgƒddgd tjjdƒtjjdƒd	œƒ}|jd
dgƒ}|jtjƒ}|jƒ }tj	||ƒ | dd… jdd�}|j
dd„ ƒ}|d j
tjƒ}tj|d |ƒ |jjdksÐt‚d S )Nrˆ   r‡   r¿   rÀ   r�   r�   r   r¾   )rÃ   rÄ   Zk3rÁ   rÂ   rÃ   rÄ   r¤   r   )r   c             S   s   | j ƒ S )N)r/   )r!   r   r   r   r"   ]  s    z*test_empty_groups_corner.<locals>.<lambda>r   rs   )r   r2   rÉ   r4   rÈ   r7   r<   r/   r:   rV   r=   r;   r    r.   r   )rY   rZ   rD   r   r   rG   Zagged_Ar   r   r   Útest_empty_groups_cornerK  s    

r  c           
   C   s:   t dgƒ} d}tjt|d�� | jdd„ ƒ W d Q R X d S )Nr   z5unsupported operand type\(s\) for \+: 'int' and 'str')r'   c             S   s   | d S )Nr�   r   )r!   r   r   r   r"   g  s    z$test_nonsense_func.<locals>.<lambda>)r   r@   rA   rú   r7   )rZ   rI   r   r   r   Útest_nonsense_funcc  s    
r  c             C   sˆ   | j }d|d< tjdddgƒtjdddgƒg}|j|ƒjtjƒ}t|jtƒsPt	‚dd„ }|j|ƒj
|ƒ}t|jƒd t|jƒks„t	‚d S )	NZpeekabooÚbazr)   r   r#   c             S   s   | j dkrt‚n| jƒ S d S )Nr�   r(   )r�   r(   )r.   rú   r$   )Úserr   r   r   Úaggfunr  s    
z5test_wrap_aggregated_output_multindex.<locals>.aggfun)r  r)   )r«   r2   rÉ   r7   r<   r/   rg   rd   r   r   r9   r8   )rY   rZ   rÏ   rG   r  Zagged2r   r   r   Ú%test_wrap_aggregated_output_multindexj  s     r	  c             C   sh   | j dd�jƒ }|jjdks t‚| j dd�jƒ }|jjdks@t‚| d j dd�jƒ }|jjdksdt‚d S )Nr   )r   rs   r#   Úsecondr   )r7   rh   r    r.   r   )rY   r   r   r   r   Útest_groupby_level_apply|  s    r  c                sÆ   | j ƒ }dddddœ‰ ddddœ‰| jˆ dd�jƒ }| jˆdd�jƒ }tj‡ fdd„|d D ƒƒ}tj‡fd	d„|d
 D ƒƒ}| j|ƒjƒ }| j|ƒjƒ }d\|j_|j_tj||ƒ tj||ƒ d S )Nr   r#   )r�   r�   r  Úqux)r(   r)   rÅ   )r   c                s   g | ]}ˆ j |ƒ‘qS r   )rÇ   )r…   r!   )Úmapper0r   r   r‹   �  s    z-test_groupby_level_mapper.<locals>.<listcomp>rs   c                s   g | ]}ˆ j |ƒ‘qS r   )rÇ   )r…   r!   )Úmapper1r   r   r‹   ‘  s    r
  )rs   r
  )	rç   r7   r$   r2   rÉ   r    r.   r:   rV   )rY   Z	deleveledZresult0r¥   Zmapped_level0Zmapped_level1Z	expected0Z	expected1r   )r  r  r   Útest_groupby_level_mapper‡  s    r  c           -   C   sÌ  t ddddddddgtddddddddgd	d
�ƒ} t ddddddgttddƒd	d
�ƒ}| jdd�jƒ }tj||ƒ | jdgd�jƒ }tj||ƒ | jdd�jƒ }tj||ƒ | jdgd�jƒ }tj||ƒ d}tjt	|d�� | jdd� W d Q R X tjt	|d�� | jdd� W d Q R X d}tjt	|d�� | jg d� W d Q R X d}tjt	|d�� | jddgd� W d Q R X tjt	|d�� | jddgd� W d Q R X d}tjt	|d�� | jdgd� W d Q R X d S )Nr#   r-   r   r*   r‘   r¤   r+   r¾   r�   )r.   rÌ   é   r%   r   )r   z2level > 0 or level < -1 only valid with MultiIndex)r'   zNo group keys passed!z*multiple levels only valid with MultiIndexéÿÿÿÿr  éþÿÿÿ)
r	   r   rX   r7   r$   r:   r;   r@   rA   rû   )Úsr   r   rI   r   r   r   Útest_groupby_level_nonmultiš  s4    2$r  c              C   s^   t tjdƒd	 ddddgd�} t dƒ}| jdd�jƒ }tj||ƒ | jdd�}tj||ƒ d S )Nr‘   r#   y               @r   )rC   r    r¤   y              $@)r   y      ð?       @ù      ð?       @ù      @      $@)r  r  )r	   r2   r3   r7   r$   r:   r;   )r‡   r   r   r   r   r   Útest_groupby_complexº  s    r  c           
   C   sŽ   t dddddddgtddd	d
dddgƒd�} t ddddddgtddd
dddgƒd�}| j|ƒ}|jƒ }| j|j| jƒjƒjƒ }tj||ƒ d S )Ng      @g      "@g      @g      Y@g     €K@gÍÌÌÌÌÌ@r‡   rˆ   r™   Údrv   rq   r€   )r    g      ð?g      @Úhg      "Àg      À)	r	   r   r7   r/   r6   r    rÇ   r:   r;   )Ús1Ús2rD   rG   rØ   r   r   r   Ú'test_groupby_series_indexed_differentlyÆ  s    &
r  c              C   sj  t tddddddddgddddddddggŽ ƒ} tj| ƒ}tjddddgƒ}ttjjddƒ||d�}|jdd�j	ƒ }t
j|j|ƒ |jddd�j	ƒ }t
j|j|jƒ |jdd�jtj	ƒ}t
j|j|ƒ |jdd�jdd„ ƒ}t
j|j|ƒ |jddd�jdd„ ƒ}t
j|jtdd	gƒƒ t
j|j|jƒ |jdƒ\}}d|d< |jdd�j	ƒ }t
j|j|jd d… ƒ d S )Nr�   r  r�   r  r(   r)   r   Úcatr   Údogé   r‘   )r    rd   r   )r   r#   )r   rx   c             S   s   | j ƒ S )N)r/   )r!   r   r   r   r"   í  s    z0test_groupby_with_hier_columns.<locals>.<lambda>c             S   s
   | j dƒS )Nr#   )r/   )r!   r   r   r   r"   ð  s    )r   r  )r   r  )r   r  )r   r  )r   r�   r  )rŒ   rö   r   rÕ   r   r2   r4   rÈ   r7   r/   r:   rý   rd   r    r<   r=   r   Z	sortlevel)Ztuplesr    rd   rZ   r   Zsorted_columnsÚ_r   r   r   Útest_groupby_with_hier_columnsÕ  s.    
r!  c             C   s:   | j | d jƒ}|jƒ }| j dƒjƒ }tj||dd� d S )Nr   F)r}   )r7   r–   r$   r:   rV   )rZ   rD   r   r   r   r   r   Útest_grouping_ndarrayû  s
    r"  c              C   sJ   d} t t| ƒdd�} | jddddgƒ}|jtjƒ}|jƒ }tj||ƒ d S )Nz�index,foo,bar,baz,spam,data
0,foo1,bar1,baz1,spam2,20
1,foo1,bar2,baz1,spam3,30
2,foo2,bar2,baz1,spam2,40
3,foo1,bar1,baz2,spam1,50
4,foo3,bar1,baz2,spam1,60r   )Z	index_colr�   r�   r  Zspam)r   r   r7   r<   r2   r/   r:   rV   )rC   rD   r   r   r   r   r   Útest_groupby_wrong_multi_labels  s    r#  c             C   s¨   | j | d ƒjƒ }| j | d dd�jƒ }|jjdks8t‚d|ksDt‚| j | d | d gƒjƒ }| j | d | d gdd�jƒ }|jjdksŒt‚d|ks˜t‚d|ks¤t‚d S )Nr   F)r¼   r   )r   r   )r7   r/   r    r.   r   r›   )rZ   r   r¦   r   r   r   Útest_groupby_series_with_name  s    r$  c             C   sR   | j dƒd }|jƒ jdks t‚|jƒ jdks2t‚dd„ }|j|ƒjdksNt‚d S )Nr   rR   c             S   s   t j| ƒd S )Nr-   )r2   r$   )r!   r   r   r   r"   )  s    z.test_seriesgroupby_name_attr.<locals>.<lambda>)r7   rh   r.   r   r/   r<   )rZ   r   ZtestFuncr   r   r   Útest_seriesgroupby_name_attr#  s
    r%  c           
   C   sx   t ddddddddgddddddddgtjjdƒd tjdƒdœƒ} | jdgƒjjƒ }| jj| jƒjƒ }t	j
||ƒ d S )	Nr�   r�   r(   r)   r  g      ð?)r   r   rR   rS   r   )r   r2   r4   rÈ   r3   r7   r   rh   r   r:   r;   )rZ   r   r   r   r   r   Útest_consistency_name-  s    r&  c             C   sx   ddd„}dd„ }| j dƒj|ƒ}|jjd ks2t‚| j dƒj|dƒ}|jjdksTt‚| j dƒj|ƒ}|jjd kstt‚d S )Nc             S   s   t ddddœ|d�S )Nr#   r-   r   )rh   r/   Ú	omissions)r.   )r	   )rZ   r.   r   r   r   Ú	summarize@  s    z0test_groupby_name_propagation.<locals>.summarizec             S   s   t ddddœ| jd d d�S )Nr#   r-   r   )rh   r/   r'  r   r   )r.   )r	   ro   )rZ   r   r   r   Úsummarize_random_nameC  s    z<test_groupby_name_propagation.<locals>.summarize_random_namer   Úmetrics)N)r7   r=   rd   r.   r   )rZ   r(  r)  r*  r   r   r   Útest_groupby_name_propagation>  s    
r+  c              C   sJ   t dd„ tdƒD ƒƒ} | jdƒ}|jƒ }| j| d ƒjƒ }tj||ƒ d S )Nc             S   s   g | ]}t jd ƒ‘qS )r*   )r2   r3   )r…   r!   r   r   r   r‹   R  s    z2test_groupby_nonstring_columns.<locals>.<listcomp>r*   r   )r   rX   r7   r/   r:   rV   )rZ   rD   r   r   r   r   r   Útest_groupby_nonstring_columnsQ  s
    
r,  c              C   st   t dddggdddgd�} t ddggddgtdgdd�d�}| jdƒjƒ }tj||ƒ | jdƒjƒ }tj||ƒ d S )	Nr   r#   r-   r   r   )rd   )r.   )rd   r    )r   r   r7   rs   r:   rV   r$   )rZ   r   r   r   r   r   Útest_groupby_mixed_type_columnsY  s    "r-  zignore:Mean of:RuntimeWarningc              C   s`   t jdƒ} | jt jƒ t| d d …df ƒ}t jtdƒdƒ}|j|ƒjtj	ƒ}|j
ƒ jƒ s\t‚d S )Nrá   r   r*   )rá   rá   )r2   rœ   Úfillrt   r	   ZtilerX   r7   r<   ZmedianZisnarµ   r   )ZarrÚobjZindsr   r   r   r   Ú(test_cython_grouper_series_bug_noncontigf  s    
r0  c              C   s^   t tjddƒƒ} ttjjdƒ| d d d… d�}tjjdddƒ}|j|ƒ}dd	„ }|j	|ƒ d S )
Nr*   rá   râ   r-   )r    r   r¤   c             S   s   t ttt| jƒƒƒS )N)r8   ÚsetÚmapÚidr    )r!   r   r   r   r"   {  s    z5test_series_grouper_noncontig_index.<locals>.<lambda>)
r   r:   Zrands_arrayr	   r2   r4   rÈ   rå   r7   r<   )r    r–   r—   rD   rq   r   r   r   Ú#test_series_grouper_noncontig_indexq  s    
r4  c              C   sš   t tdƒƒ} tjdddddgdd�}d	d
„ }dd„ }| j|ƒ}|j|ƒ}|jtjksXt‚t	|d t
ƒsjt‚|j|ƒ}|jtjks„t‚t	|d t
ƒs–t‚d S )Nr¤   r‡   rˆ   r™   r  rv   rK   )r   c             S   s   t t| jƒ ƒƒS )N)r   Ústrr/   )r!   r   r   r   Úconvert_fast„  s    z>test_convert_objects_leave_decimal_alone.<locals>.convert_fastc             S   s$   t | jjƒdkst‚tt| jƒ ƒƒS )Nr   )r8   r–   Úbaser   r   r5  r/   )r!   r   r   r   Úconvert_force_pure‡  s    zDtest_convert_objects_leave_decimal_alone.<locals>.convert_force_purer   )r	   rX   r2   rÉ   r7   r<   r   Zobject_r   rg   r   )r  r—   r6  r8  rD   r   r   r   r   Ú(test_convert_objects_leave_decimal_alone  s    


r9  c              C   st   t g tjddd�dœƒ} | d jtjks,t‚| jdƒjƒ }tg dtjd�}t dt	g |dd�iƒ}t
j||d	d
� d S )Nr   r   )r   )r!   rX   r!   )r.   r   rX   )r    r   T)Z	by_blocks)r   r2   r3   r   r   r   r7   rs   r   r	   r:   rV   )rZ   r   Z	exp_indexr   r   r   r   Ú"test_groupby_dtype_inference_empty—  s    r:  c             C   sÂ   | j t| d ƒƒjƒ }| j | d ƒjƒ }tj||dd� tjtdd��  | j t| d d d… ƒƒ W d Q R X tddgdd	gt	j
jd
ƒdœƒ} | j ddgƒjƒ }| j | d | d gƒjƒ dg }d S )Nr   F)r}   z^'foo'$)r'   r#   r   r   r‘   r-   )r�   r�   Úvalr�   r�   r;  r  )r7   rŒ   r/   r:   rV   r@   rA   ÚKeyErrorr   r2   r4   rÈ   )rZ   r   r   r   r   r   Ú"test_groupby_list_infer_array_like¢  s    $ r=  c              C   sv   d} t jt jdƒd| d�}t jddgddggd	d
g|d�}|jt jd| d�d	gƒjƒ }|j|jd	gƒ}t	j
||ƒ d S )Nr  z2015-09-29T11:34:44-0700r-   )Ústartrn   Úfreqr   r*   r   é   Zmetricr–   )rd   r    r   )r   r?  )r   r   r
   r   r7   r   r/   r�   r    r:   rV   )r?  r    rZ   r   r   r   r   r   Ú$test_groupby_keys_same_size_as_index±  s     rA  c              C   sˆ   d} t jtjjddƒtdƒd�}tjt| d�� |j	dƒ W d Q R X t jtjjddƒtdƒd�}tjt| d�� |j	dƒ W d Q R X d S )	Nz^'Z'$r#   r‘   ÚABCD)rd   )r'   ÚZr-   )
r   r   r2   r4   rÈ   rŒ   r@   rA   r<  r7   )rI   ri   rj   r   r   r   Útest_groupby_one_row¾  s    rD  c              C   sž  t jtjjdƒtjt jdƒtjt jdƒtjt jdƒtjt jdƒgtjdtjdtjdtjdgdœƒ} | jdƒ}t jdd	gƒt jd
dgƒg}t	|j
jƒ ƒ}t|ƒdks¦t‚x(t||ƒD ]\}}tj|j
| |ƒ q²W tj|jjd j| ƒ |jdksôt‚tdƒtjdd	gtjd�tdƒtjd
dgtjd�i}x&|jD ]}tj|j| || ƒ �q0W tj|jtdƒƒ| jdd	g ƒ tj|jtdƒƒ| jd
dg ƒ tjtdd�� |jt jƒ W d Q R X ttjtjtjgt jt jt jgdœƒ}|d j dk�sðt‚|d j dk�st‚x”dD ]Œ}|j|ƒ}|j
i k�s(t‚|jdk�s8t‚|ji k�sHt‚tjtdd�� |jtjƒ W d Q R X tjtdd�� |jt jƒ W d Q R X �q
W d S )Nr  z
2013-01-01z
2013-02-01r‡   rˆ   )r–   Údtr5  rE  r#   r%   r   r¤   r-   r   z2013-01-01 00:00:00)r   z2013-02-01 00:00:00z^NaT$)r'   )rt   Únatrt   r   rF  zdatetime64[ns]z^nan$)rt   rF  )!r   r   r2   r4   rÈ   rt   r
   r7   r   Úsortedr±   rÏ   r8   r   rö   r:   rý   rV   Úgrouperr�   r/  ZngroupsrÉ   Zintpr²   Úassert_numpy_array_equalrÛ   ro   r@   rA   r<  ru   r   )rZ   rD   r   rÏ   rE   rv   Znan_dfr   r   r   r   Útest_groupby_nat_excludeÉ  sP    

"
  $

rJ  c              C   s’   t tdƒd�} ddg| d< ddg| d< ddg| d	< d
dg| d< | jdgƒjƒ }tjddgddggtjd�}tj|j	t
dd	gƒƒ tj|j|ƒ d S )Nr-   )r    Zg1Zg2rO   r   Úzerosr#   r“   Úl1Úl2Úlabel)r   )r   rX   r7   r/   r2   rÉ   r   r:   rý   rd   r   rI  r–   )r  ÚtmpZ
res_valuesr   r   r   Útest_groupby_2d_malformed  s    rP  c              C   sŒ   t jt jdƒt jdƒt jdƒfƒ} t jdƒ}t|| || t jjdƒdœƒ}|jddddgƒjƒ }|jddddgƒjƒ }t|ƒt|ƒksˆt	‚d S )	Ni'  iˆ  i¨a  )r   r   rR   rS   rÍ   r   r   rR   rS   )
r2   Zconcatenater3   r   r4   rÈ   r7   r$   r8   r   )r   r   rZ   rÞ   rê   r   r   r   Útest_int32_overflow  s    "
rQ  c              C   s”  t dddgdddgdddgtjjdƒdœƒ} d	d
„ | dddg jD ƒ}tj|ƒ}| jdddgdd�jƒ }t	j
|jj|dddg ƒ dd
„ | dddg jD ƒ}tj|ƒ}| jdddgdd�jƒ }t	j
|jj|ƒ dd
„ | dddg jD ƒ}tj|ƒ}| jdddgdd�jƒ }t	j
|jj|dddg ƒ t ddddddgddddddgtjjdƒdœƒ} | jddgƒd }|jƒ }dd„ fdd„}|| |ddgdƒ d S )Nr�   r�   r  r   r-   r#   r   )r‡   rˆ   r™   r  c             S   s   g | ]}t |ƒ‘qS r   )Útuple)r…   Úrowr   r   r   r‹   (  s    z+test_groupby_sort_multi.<locals>.<listcomp>r‡   rˆ   r™   T)Úsortc             S   s   g | ]}t |ƒ‘qS r   )rR  )r…   rS  r   r   r   r‹   -  s    c             S   s   g | ]}t |ƒ‘qS r   )rR  )r…   r!   r   r   r   r‹   2  s    r¾   )r‡   rˆ   r  r  c             S   s   | j ƒ S )N)r$   )r!   r   r   r   r"   =  s    z)test_groupby_sort_multi.<locals>.<lambda>c       	      S   sZ   dd„ | | j D ƒ}tj|ƒ}|| j|ƒ| ƒ}x$|jƒ D ]\}}|| |ks:t‚q:W d S )Nc             S   s   g | ]}t |ƒ‘qS r   )rR  )r…   rS  r   r   r   r‹   >  s    zCtest_groupby_sort_multi.<locals>._check_groupby.<locals>.<listcomp>)r–   ÚcomÚasarray_tuplesafer7   r³   r   )	rZ   r   rÏ   Úfieldrq   Útupsr   rE   rF   r   r   r   Ú_check_groupby=  s
    
z/test_groupby_sort_multi.<locals>._check_groupby)r   r2   r4   rÈ   r–   rU  rV  r7   r$   r:   rI  r    )rZ   rX  r   rD   rY  r   r   r   Útest_groupby_sort_multi  s.    


.rZ  c              C   sH   t ddddddgdddgd dœƒ} | jdƒjd	d
„ ƒ}tj|| ƒ d S )Nr‡   rˆ   r�   r�   r  r-   )r   r.   r   c             S   s   | S )Nr   )r!   r   r   r   r"   L  s    z/test_dont_clobber_name_column.<locals>.<lambda>)r   r7   r=   r:   rV   )rZ   r   r   r   r   Útest_dont_clobber_name_columnG  s    "r[  c              C   s˜   t jƒ } | jdd„ dd�}|jdd„ ƒ}dd„ |D ƒ}tj|ƒ}t j||ƒ | d jd	d„ dd�}|jd
d„ ƒ}dd„ |D ƒ}tj|ƒ}t j||ƒ d S )Nc             S   s   | j S )N)r|   )r!   r   r   r   r"   T  s    z&test_skip_group_keys.<locals>.<lambda>F)Ú
group_keysc             S   s   | j dd�d d… S )Nr   )rÝ   r   )Úsort_values)r!   r   r   r   r"   U  s    c             S   s$   g | ]\}}|j d d�dd… ‘qS )r   )rÝ   Nr   )r]  )r…   r   rO   r   r   r   r‹   W  s    z(test_skip_group_keys.<locals>.<listcomp>r   c             S   s   | j S )N)r|   )r!   r   r   r   r"   \  s    c             S   s   | j ƒ d d… S )Nr   )r]  )r!   r   r   r   r"   ]  s    c             S   s    g | ]\}}|j ƒ d d… ‘qS )Nr   )r]  )r…   r   rO   r   r   r   r‹   _  s    )r:   r‰   r7   r=   r   rÐ   rV   r;   )ZtsfrD   r   Úpiecesr   r   r   r   Útest_skip_group_keysP  s    

r_  c             C   s:   | d j ƒ }d |_|j| d ƒjtjƒ}|jd ks6t‚d S )NrR   r   )rW   r.   r7   r<   r2   r$   r   )Zfloat_framer  r   r   r   r   Útest_no_nonsense_namee  s    r`  c              C   s^   t tjdƒjddƒƒ} d| d< dddg| d< | jdƒ}|jd	d
dœƒ}|d jtjksZt‚d S )Nr   r   r   ÚtestgÍÌÌÌÌÌô?g      ø?gš™™™™™ù?Úflr$   rî   )rb  r-   )	r   r2   r3   Úreshaper7   r<   r   r   r   )r!   rD   r   r   r   r   Útest_multifunc_sum_bugn  s    
rd  c             C   sV   dd„ }dd„ }| j dƒd j|ƒ}| j dƒd j|ƒ}t|tƒsFt‚tj||ƒ d S )Nc             S   s   | j ƒ | jƒ dœS )N)rã   Úmin)rã   re  )rO   r   r   r   rq   z  s    z(test_handle_dict_return_value.<locals>.fc             S   s   t | jƒ | jƒ dœƒS )N)rã   re  )r	   rã   re  )rO   r   r   r   r€   }  s    z(test_handle_dict_return_value.<locals>.gr   rR   )r7   r=   rg   r	   r   r:   r;   )rZ   rq   r€   r   r   r   r   r   Útest_handle_dict_return_valuey  s    rf  rH  r   r   c                s”   dd„ }dd„ ‰ ‡ fdd„}| j |ƒ}|j|ƒ |jˆ ƒ |jˆ ˆ dœƒ |j|ƒ |d j|ƒ |d jˆ ƒ |d jˆ |gƒ |d j|ƒ d S )	Nc             S   s   | j d k	st‚| S )N)r.   r   )rO   r   r   r   rq   ‰  s    ztest_set_group_name.<locals>.fc             S   s   | j d k	st‚| jƒ S )N)r.   r   r$   )rO   r   r   r   Úfreduce�  s    z$test_set_group_name.<locals>.freducec                s   ˆ | ƒS )Nr   )r!   )rg  r   r   r�   ‘  s    z test_set_group_name.<locals>.foo)rR   rS   rR   )r7   r=   r9   r>   )rZ   rH  rq   r�   rD   r   )rg  r   Útest_set_group_name‡  s    



rh  c                 sb   t jddddddgtjdƒdœƒ} g ‰ ‡ fdd„}| jdd	d	d
�j|ƒ dddg}ˆ |ks^t‚d S )Nr   r#   r-   r¾   )r‡   rˆ   c                s   ˆ j | jƒ | jƒ S )N)rÔ   r.   rW   )rO   )r›   r   r   rq   ¨  s    z6test_group_name_available_in_inference_pass.<locals>.fr‡   F)rT  r\  )r   r   r2   r3   r7   r=   r   )rZ   rq   Zexpected_namesr   )r›   r   Ú+test_group_name_available_in_inference_pass¢  s    "
ri  c             C   sV   | j | d jƒjƒ }|jjd ks$t‚| j | d j| d jgƒjƒ }|jjdksRt‚d S )Nr   r   )NN)r7   r–   r$   r    r.   r   r›   )rZ   r   r   r   r   Útest_no_dummy_key_names²  s    rj  c           	   C   sÞ   t ddgddggddddddgddddddggddgd�} tdddddd	g| d
�}t ddgddggdddgdddggddgd�} tdddg| d
�}|jddgdd�jƒ }tj||ƒ |jddgdd�jƒ }tj||jƒ ƒ d S )Nr#   r-   r   r‡   rˆ   )rš   rT   r›   r   r‘   r¤   )r    F)r   rT  T)r   r	   r7   rs   r:   r;   Ú
sort_index)r    ZmseriesZmseries_resultr   r   r   r   Ú#test_groupby_sort_multiindex_series»  s    ,rl  c              C   sŽ   d} t dd| d�}ttj| ƒtj| ƒdœ|d�}ddd	„}d
d„ }|jdd„ ƒ}|jd|dtjƒiƒ}|jd|dtjdƒiƒ}tj||ƒ d S )Niè  z2012/1/1Z5min)r>  r?  rn   )ÚhighÚlow)r    Fc                s   ‡ ‡fdd„}|S )z>
        Run an aggregate func on the subset of data.
        c                sD   | j | jjdd„ ƒ jƒ }ˆ r,| | jd   t|ƒdkr<d S ˆ|ƒS )Nc             S   s
   | j dk S )NrÌ   )Úhour)r!   r   r   r   r"   Ü  s    zYtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._func.<locals>.<lambda>r   )rM   r    r2  Údropnar8   )rC   r  )Úfixra   r   r   Ú_funcÛ  s    zGtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._funcr   )ro  ra   rq  rr  r   )rq  ra   r   Ú
agg_beforeÖ  s    z8test_groupby_reindex_inside_function.<locals>.agg_beforec             S   s   | j dd„ ƒjƒ }tj|ƒS )Nc             S   s
   | j dk S )NrÌ   )ro  )r!   r   r   r   r"   æ  s    zEtest_groupby_reindex_inside_function.<locals>.afunc.<locals>.<lambda>)Úselectrp  r2   rã   )rC   r  r   r   r   Úafuncå  s    z3test_groupby_reindex_inside_function.<locals>.afuncc             S   s   t | j| j| jƒS )N)r   rƒ   r|   r„   )r!   r   r   r   r"   é  s    z6test_groupby_reindex_inside_function.<locals>.<lambda>rm  rÌ   T)F)	r   r   r2   r3   r7   r<   rã   r:   rV   )rn   ÚindrZ   rs  ru  rD   Zclosure_badZclosure_goodr   r   r   Ú$test_groupby_reindex_inside_functionÐ  s    
rw  c              C   s–   t ddddgddddgddddgdœƒ} | jdd	gƒ} | jdd	gd
d�}|jdƒ}tjdddgdd	gd�}t dgdgdgg|dgd�}tj||ƒ d S )Nr‡   rˆ   r™   r  r#   r¤   )Úgroup1Úgroup2rL   rx  ry  T)r   rT  r$   )r›   r-   rL   )r    rd   )r‡   r™   )r‡   r  )rˆ   r™   )r   r�   r7   r<   r   rÕ   r:   rV   )rZ   r�   r    r·   rØ   r   r   r   Ú$test_groupby_multiindex_missing_pairð  s    


rz  c              C   sž  t jdddgddgd	�} td
ddgg| d�}|jjƒ s:t‚tddddgd
dddgd
dddggd�}|jdddgdd�}|jƒ }|jjƒ  sŽt‚tj	||ƒ |j
dƒjƒ }tjtƒ� |j
dƒjƒ }W d Q R X tj	||ƒ tddddgd
d
ddgd
dddgdœƒjddgƒ}|jjƒ  �st‚x|dd
dd
ggD ]j}xbdD ]Z}|j
||d�jtjƒ}|}tj	||ƒ |jƒ j
||d�jtjƒ}|jƒ }tj	||ƒ �q6W �q,W d S )Nr‡   Ú Úb1Úc1Úb2Úc2rˆ   r™   )r›   r#   r   r‘   )rd   r  )rd   rC   )r    rd   r–   r-   )r!   rž   Úzr!   rž   r   FT)r   rT  )r‡   r{  )r|  r}  )r~  r  )FT)r   rÕ   r   rd   Zis_lexsortedr   Úpivot_tablerç   r:   rV   r7   r/   re   r   r�   r    r=   Zdrop_duplicatesrk  )Zlexsorted_miZlexsorted_dfZnot_lexsorted_dfr   r   rZ   r   rT  r   r   r   Ú%test_groupby_multiindex_not_lexsorted  s:    &&


r‚  c              C   s  t tdƒdddddgd�} | jtdƒƒ}|jdd„ ƒ}| jdd	d
g }tj||ƒ | d }|jtdƒƒ}|jdd„ ƒ}|jdd	d
gƒ}tj||ƒ | j	j
tƒ| _	| jtdƒƒ}|jdd„ ƒ}| jdd	d
g }tj||ƒ | d }|jtdƒƒ}|jdd„ ƒ}|jdd	d
gƒ}tj||ƒ d S )NZABCDEr-   r   r#   )r    Zababbc             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   <  s    z4test_index_label_overlaps_location.<locals>.<lambda>r   r‘   c             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   B  s    c             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   I  s    c             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   O  s    )r   rŒ   r7   Úfilterro   r:   rV   r´   r;   r    rU   r’   )rZ   r€   Úactualr   r  r   r   r   Ú"test_index_label_overlaps_location7  s(    r…  c              C   s‚   d} t j| ƒ}t|d d| d| dœƒ}t|d d d| d| dœƒ}|jdƒ}|jdƒ}|jdƒ}|jdƒ}tj||ƒ d S )	Nr¾   r-   g       @g      @)r‡   rˆ   r™   g      ð?r‡   r/   )r2   r3   r   r7   r>   r:   rV   )Únr!   rZ   rj   Úgbr   Zgb2r   r   r   r   Ú"test_transform_doesnt_clobber_intsT  s    
 



rˆ  Úsort_columnÚintsÚfloatsÚstringsÚgroup_columnÚ
int_groupsÚstring_groupsc                s”   t ddddddddgddddddddgddd	d
ddddgdddddddd
gddddddddgdœƒ}|jˆ d�}|j|ƒ}‡ fdd„}|j|ƒ d S )Nr   r#   r   r€  r‡   r€   r  r%   r‘   r¤   r-   r   gffffff@g333333@gÍÌÌÌÌÌ@g333333@gš™™™™™@gš™™™™™ñ?r  rv   ÚwordZword2Z42Z47)rŽ  r�  rŠ  r‹  rŒ  )rÝ   c                s   t j| | jˆ d�ƒ d S )N)rÝ   )r:   rV   r]  )r!   )r‰  r   r   Ú	test_sort}  s    z.test_groupby_preserves_sort.<locals>.test_sortg333333À)r   r]  r7   r=   )r‰  r�  rZ   r€   r‘  r   )r‰  r   Útest_groupby_preserves_sortc  s    
r’  c                 st   d‰ t dd„ tˆ ƒD ƒtdddgd d�} | jddgƒ}t ‡ fdd„tˆ ƒD ƒtdgd d�}|jd
ƒ}tj||ƒ d S )Ni°  c             S   s,   g | ]$}|d  |d r|d nt j|f‘qS )r&   r   )r2   rt   )r…   Úir   r   r   r‹   Œ  s    z2test_group_shift_with_null_key.<locals>.<listcomp>r   r   rC  )r   rd   r    c                s.   g | ]&}|d  r$|ˆ d k r$|d nt j‘qS )r   r&   )r2   rt   )r…   r“  )Ún_rowsr   r   r‹   ”  s    r#   r  )r   rX   r’   r7   Úshiftr:   rV   )rZ   r€   r   r   r   )r”  r   Útest_group_shift_with_null_keyƒ  s    
r–  c                 s~   d‰ t dd„ tˆ ƒD ƒtdddgd d�} | jddgƒ}t ‡ fdd„tˆ ƒD ƒtdgd d�}|jdd
d�dg }tj||ƒ d S )Né   c             S   s   g | ]}|d  |d |f‘qS )r&   r   r   )r…   r“  r   r   r   r‹   ¢  s    z4test_group_shift_with_fill_value.<locals>.<listcomp>r   r   rC  )r   rd   r    c                s$   g | ]}|ˆ d  k r|d  nd‘qS )r&   r   r   )r…   r“  )r”  r   r   r‹   ª  s    r#   r   )Z
fill_valuer  )r   rX   r’   r7   r•  r:   rV   )rZ   r€   r   r   r   )r”  r   Ú test_group_shift_with_fill_valuež  s    r˜  c              C   sT   t jjƒ } tddg| dœƒ}|jdƒjdƒjd }td| i|jd�}t	j
||ƒ d S )Nr#   )r‡   Údater‡   r   r™  )r.   )r   r
   Úutcnowr   r7   r•  ro   r	   r.   r:   r;   )Znow_dtrZ   r   r   r   r   r   Útest_group_shift_lose_timezone´  s
    
r›  c              C   s‚   t jt jtjƒ ddd�jƒ tddƒdœƒ} | jdƒjj	| d< | jdƒjj
| d< tjtd	d
�� | jƒ jddddd� W d Q R X d S )Nr+   ÚM)rn   r?  r   )Ú	eventDateZthenamer�  rƒ   r|   z	'badname')r'   Zbadnamerh   )r    rd   r–   Zaggfunc)r   r   r   r   ÚtodayÚtolistrX   r�   r    rƒ   r|   r@   rA   r<  rç   r�  )rZ   r   r   r   Ú!test_pivot_table_values_key_error½  s    r   c              C   sH   t dddgd�} | jdƒjƒ }t ddgtjd�}d|j_tj||ƒ d S )Nr   r   rR   )rd   )rd   r   )	r   r7   r$   r2   r   r    r.   r:   rV   )rZ   r   r   r   r   r   Útest_empty_dataframe_groupbyÏ  s
    r¡  c              C   s¨   t jdddddgdddddgdddddgdddddgiƒ} tjtdd�� | dddg jdƒ W d Q R X | jdƒd jƒ }t jdgdt jdgdd	�d
�}t	j
||ƒ d S )Nr‡   rˆ   r#   r-   r™   z
('a', 'b'))r'   r‘   )r.   )r.   r    )r‡   rˆ   )r‡   rˆ   )r‡   rˆ   )r‡   rˆ   )r   r   r@   rA   r<  r7   r$   r	   r   r:   r;   )rZ   r   r   r   r   r   Útest_tuple_as_groupingÚ  s    r¢  c           
   C   sT   t jdtdƒt jjddgddggƒd�} tjtdd�� | jd
ƒj	ƒ  W d Q R X d S )Nr#   r   r-   r‘   )r    rd   z
^\(7, 8\)$)r'   r%   r  )r%   r  )
r   r   rX   r   Úfrom_productr@   rA   r<  r7   r/   )rZ   r   r   r   Útest_tuple_correct_keyerrorí  s    $r¤  c           
   C   sŽ   t jdgdggdgt jdddd�d�} t jdddddgdddddggt jjdƒt jdddd�d�}| jt jdd�ƒjdd	gƒ}tj	||ƒ d S )Nr#   r�   z
2018-01-01r-   rS   )rn   r?  )rd   r    r$   ÚohlcÚopenrm  rn  Úclose)r?  ©r�   r$   r�   ©r�   r¥  r¦  ©r�   r¥  rm  ©r�   r¥  rn  ©r�   r¥  r§  )r¨  r©  rª  r«  r¬  )
r   r   r   r   rÕ   r7   r   r<   r:   rV   )rZ   r   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j| dd gd�}t jddd	d
g|d�}|jdd�jƒ }t jdd	gddgd�}tj	||ƒ d S )Nr‡   iÜ  r#   r-   rˆ   r   r™  )r›   g      @r‘   )r    )r   g      @)
r   ru   r   r   rÕ   r	   r7   r/   r:   r;   )r–   rÖ   r  r   r   r   r   r   Útest_groupby_multiindex_nat  s    r®  c           	   C   sP   t tdƒtdƒƒ} t| ddgd�}d}tjt|d�� |jg gƒ W d Q R X d S )Nr*   Zapplerˆ   )rd   z$Grouper and axis must be same length)r'   )rö   rX   r   r@   rA   rû   r7   )r–   rZ   rI   r   r   r   Útest_groupby_empty_list_raises!  s
    r¯  c              C   s˜   ddgddgddgg} dddg}t jj| |d�}t jd	d
g|d�}|jddgƒjƒ }dgdgg} ddg}t jj| |d�}t jdg|d�}tj||ƒ d S )Nr!   r‡   rˆ   rE   rs   r
  Zthird)r›   r#   r-   )rC   r    r   )r    )r   r   Zfrom_arraysr	   r7   r$   r:   r;   )Zindex_arrayZindex_namesÚrir  r   Úeir   r   r   r   Ú8test_groupby_multiindex_series_keys_len_equal_group_axis*  s    
r²  c              C   s°   t jjddgddggddgd�} t jdd	dd	gdd	d
dgdœ| d�}|jt jdd�dgƒ}|jddgƒ}|j|jksxt‚|jdt jdd�gƒ}|jddgƒ}|j|jks¬t‚d S )Nr   r   rR   rS   ÚalphaÚbeta)r›   r#   r-   r   r‘   )r�   r�   )r    )r   )r   r   r£  r   r7   r   r±   r   )rÖ   rZ   r   r   r   r   r   Ú"test_groupby_groups_in_BaseGrouper:  s     $rµ  Ú
group_namer!   c             C   sê   t jtjdƒjddƒdddgddddgd�}d	|j_d
|j_|j| dd�j	ƒ }|j
j| ƒj	ƒ j
}tj||ƒ dddgddgg}t jj|d
dgd�}t jtjdƒjddƒdddg|d�}|j| dd�j	ƒ }|j
j| ƒj	ƒ j
}tj||ƒ d S )Nr&   r   r‘   r   r#   r*   r+   )r    rd   rž   r!   )rx   r�   r  r�   r(   r)   Úx1)Ú	iterablesr›   é   r¾   )r   r   r2   r3   rc  r    r.   rd   r7   r$   r«   r:   rV   r   r£  )r¶  rZ   Úresultsr   r¸  rÖ   r   r   r   Útest_groupby_axis_1H  s    ($r»  zop, expectedr•  Útimez2019-01-01 12:00:00z2019-01-01 12:30:00Zbfillz2019-01-01 14:00:00z2019-01-01 14:30:00Zffillc                sŒ   | ‰ ddddddgt dƒt dƒd d t dƒt dƒgdœ}t|ƒj‡ fdd	„d
�}|jdƒ}t||ƒƒ }t|ƒj‡ fdd	„d
�}tj||ƒ d S )Nr   r   z2019-01-01 12:00:00z2019-01-01 12:30:00z2019-01-01 14:00:00z2019-01-01 14:30:00)r3  r¼  c                s   | j jjˆ ƒS )N)r¼  rE  Útz_localize)r!   )Útzr   r   r"   ˜  s    z+test_shift_bfill_ffill_tz.<locals>.<lambda>)r¼  r3  c                s   | j jjˆ ƒS )N)r¼  rE  r½  )r!   )r¾  r   r   r"   œ  s    )r
   r   Zassignr7   r­   r:   rV   )Ztz_naive_fixturerÓ   r   rC   rZ   rD   r   r   )r¾  r   Útest_shift_bfill_ffill_tz^  s    .
r¿  c           	   C   sD   t jddgddgdœƒ} tjtdd�� | jdƒjƒ  W d Q R X d S )Nr#   r-   )r‡   rˆ   zMust specify a fill)r'   rˆ   )r   r   r@   rA   rû   r7   Úfillna)rZ   r   r   r   Útest_ffill_missing_arguments   s    rÁ  c              C   sH   t jd gddœƒ} | jdƒd jdƒ}t jtjgdd�}tj||ƒ d S )Nr#   )r€   r!   r€   r!   r$   )r.   )	r   r   r7   r>   r	   r2   rt   r:   r;   )rZ   r„  r   r   r   r   Útest_groupby_only_none_group§  s    rÂ  c              C   s\   t jddddgddddgd�} | jd	d
�}|jƒ }t jdddgdddgd�}tj||ƒ d S )Nr-   r¤   r¾   r  g       @g      @g      @)r    r   )r   g      @)r   r	   r7   r/   r:   r;   )r  r‡  r   r   r   r   r   Útest_groupby_duplicate_index±  s
    rÃ  Úbool_agg_funcÚanyrµ   c             C   sD   t jddggddgd�}|jdgƒ}t|| ƒƒ }|}tj||ƒ d S )NTr‡   )rd   r   )r   r   r7   r­   r:   rV   )rÄ  rZ   Úgrp_byr   r   r   r   r   Ú test_bool_aggs_dup_column_labels»  s
    rÇ  r·   r‡   z)ignore:tshift is deprecated:FutureWarningc             C   s°   | dkrt jdƒ tjddgg|d�}|jdgƒ}g }| dkrJ|jdƒ n8| d
kr^|j|ƒ n$| dkr‚tjdƒg|_|jddgƒ t	|| ƒ|Ž }|j
dksžt‚tj|j|ƒ d S )Nrî   rí   ÚcumcountzNot applicabler#   )rd   r   rÀ  ræ   rì   Ztshiftrž  rS   r-   >   rí   rÈ  rî   >   ræ   rÀ  )r#   r-   )r@   rï   r   r   r7   rÔ   r
   r    Úextendr­   Úshaper   r:   rý   rd   )Zgroupby_funcr·   rZ   rÆ  Úargsr   r   r   r   Útest_dup_labels_output_shapeÆ  s    
rÌ  c             C   sz   t jdddgdddgdddgiƒ}|j| ƒ}|s6|j}|j|dd	�jƒ }t jddgddgd
œƒ}|sj|j}tj||ƒ d S )Nr   r   r#   r-   rR   r   rS   r   )rx   r   )r   rS   )r   r   )r   rR   )rS   r   )r   r   Z_get_axis_numberr«   r7   Znuniquer:   rV   )rx   rZ   Zaxis_numberr   r   r   r   r   Útest_groupby_crash_on_nuniqueà  s    "
rÍ  c              C   s<   t jtjddƒjddƒƒ} | jdgd�jƒ }tj|| ƒ d S )Nr   r   r   )r   )	r   r   r2   r3   rc  r7   r/   r:   rV   )r   r   r   r   r   Útest_groupby_list_levelñ  s    rÎ  zmax_seq_items, expectedr¤   ú({0: [0], 1: [1], 2: [2], 3: [3], 4: [4]}r‘   ú%{0: [0], 1: [1], 2: [2], 3: [3], ...}c          
   C   sz   t jtjjddƒƒ}|j|d< t jd| ƒ�F |jdƒjj	ƒ }||ksHt
‚|jtj|jƒƒjj	ƒ }||kslt
‚W d Q R X d S )Nr¤   r#   r‡   zdisplay.max_seq_items)r   r   r2   r4   rÈ   r    Zoption_contextr7   r±   Ú__repr__r   rÉ   r‡   )Zmax_seq_itemsr   rZ   r   r   r   r   Útest_groups_repr_truncatesø  s    	
rÒ  c              C   sd   t ddddgddddgd
d�} d| j_| jdd	�jƒ }t ddgddgdd�}d|j_tj||ƒ d S )Nr#   r-   r   r‘   r‡   )r    r.   rˆ   r   )r   )r‡   r‡   )rˆ   rˆ   )r‡   r‡   )rˆ   rˆ   )r	   r    r.   r7   Úlastr:   r;   )r  r   r   r   r   r   Ú#test_groupby_series_with_tuple_name  s    rÔ  ©r‡   r‡   ©r‡   r‡   )rÕ  rÖ  )r¤   rÏ  )r‘   rÐ  )�r   Údecimalr   Úior   Znumpyr2   r@   Zpandas.errorsr   Zpandasr   r   r   r   r	   r
   r   r   Zpandas._testingZ_testingr:   Zpandas.core.baser   Zpandas.core.commonÚcoreÚcommonrU  r   ÚmarkZparametrizerJ   r[   rk   rw   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-  Úfilterwarningsr0  r4  r9  r:  r=  rA  rD  rJ  rP  rQ  rZ  r[  r_  r`  rd  rf  rh  ri  rj  rl  rw  rz  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   Ú<module>   s  $
1*>(8(="!8	

 &

?
)			 2			

