3
Êb_6ï  ã               @   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Ü„ ZxejjdÝdÞdßgƒdàdá„ ƒZyejjdâejdãdãgƒejjzdìƒgƒdädå„ ƒZ{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   úC/tmp/pip-build-jkwsxyiy/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	„ }| jd
dd�j|ƒ}t|tƒsRt‚t dddœdddœdddœdddœgƒ}dd	„ }|jd
dd�j|ƒ}t|tƒs¤t‚t ddgddggddgd�}|jddd�jƒ }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   r7   r=   Ú
isinstancer	   r   Úcount)Údf1ra   r   Údf2rZ   r   r   r   Útest_groupby_return_typea   s&    ri   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 )Nrj   r   )r.   rm   )rn   r   r   r   ro   š   s    
c             S   s   | j dkrd S | jd S )Nrk   r   )r.   rm   )rn   r   r   r   ro   ¤   s    
c             S   s   | j dkrd S | jd S )Nrk   r   )r.   rm   )rn   r   r   r   ro   ¯   s    
rR   c             S   s   | j dkrd S | jd jd S )Nrk   r   rR   )r.   rm   rM   )rn   r   r   r   ro   º   s    
)r   Údictr	   r2   r3   r   r7   Úfirstr=   r:   rV   rW   ÚnanrM   r   ÚNaTr.   r;   )rZ   ro   r   r   Úer   r   r   Útest_inconsistent_return_typeˆ   s<    ru   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!   Úqrv   r   r   r   ro   Ç   s    z test_pass_args_kwargs.<locals>.fc             S   s   t j| ddd�S )NéP   r   )rv   )r2   rw   )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    ry   )rv   gš™™™™™é?)rx   c             S   s   | j S )N)rz   )r!   r   r   r   r"   á   s    F)Úcheck_names)Nr   )r7   r<   r2   rw   r=   r>   Zquantiler:   r;   r   rV   )ÚtsÚtsframero   Ú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)rz   )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)rz   )r!   r   r   r   r"   ó   s    c             S   s   h | ]}|j |jf’qS r   )r�   rz   )Ú.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   rp   r2   rr   )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   ro     s    ztest_with_na_groups.<locals>.f)r   r2   r3   r	   Úonesrr   r7   r<   r8   r:   r;   Ú
issubclassr   Útyper   )r   r    ÚvaluesÚlabelsrD   rG   r   ro   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   Úf26  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   Úf3>  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   rh   Ú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"   a  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"   d  s    c             S   s   i | ]\}}|j ƒ |“qS r   )Údescribe)rƒ   r.   Zgpr   r   r   ú
<dictcomp>i  s    z%test_attr_wrapper.<locals>.<dictcomp>c             S   s   | j S )N)r   )r!   r   r   r   r"   o  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_wrapper`  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"   x  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_groupbyw  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   )rv   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#   )Úkeysrv   )r   r2   r4   rÆ   r7   r/   r?   r<   r   Úconcatre   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"   .  s    r"   c             C   s   | j ƒ S )N)r/   )r!   r   r   r   r"   .  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#   )rv   )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_columns.  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"   V  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_columnO  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/   Úmaxrf   rN   rØ   r³   )Zdrop)rÝ   r   )r/   rÞ   rf   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ÚattrÚleftÚrightr   r   r   Útest_groupby_as_index_agg]  sF    


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   re   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º   rv   )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)rz   )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)rz   )r!   r   r   r   r"   é  s    c             S   s   | j S )N)r‚   )r!   r   r   r   r"   é  s    r#   )rv   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   rr   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Ë   )rv   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_multiple  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"   3  s    z*test_empty_groups_corner.<locals>.<lambda>r   rq   )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_corner!  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"   =  s    z$test_nonsense_func.<locals>.<lambda>)r   r@   rA   rñ   r7   )rZ   rI   r   r   r   Útest_nonsense_func9  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   ÚaggfunH  s    
z5test_wrap_aggregated_output_multindex.<locals>.aggfun)rý   r)   )r©   r2   rÇ   r7   r<   r/   re   rd   r   r   r9   r8   )rY   rZ   rÍ   rG   rÿ   Zagged2r   r   r   Ú%test_wrap_aggregated_output_multindex@  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   rq   r#   Úsecondr   )r7   rf   r    r.   r   )rY   r   r   r   r   Útest_groupby_level_applyR  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‰   f  s    z-test_groupby_level_mapper.<locals>.<listcomp>rq   c                s   g | ]}ˆ j |ƒ‘qS r   )rÅ   )rƒ   r!   )Úmapper1r   r   r‰   g  s    r  )rq   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_nonmultip  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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
d„ tddƒD ƒtjjddd�dœƒ} dd„ }dd„ }| jdƒj|ƒ}| jdƒj|ƒ}tj||ƒ d S )Nr…   é   r†   r¼   r—   r-   Údrt   ro   c             S   s   g | ]}d |› �‘qS )r~   r   )rƒ   r!   r   r   r   r‰   ª  s    z&test_mutate_groups.<locals>.<listcomp>r#   é   rÜ   é   )Úsize)Úcat1Úcat2Zcat3Úvalc             S   s,   | j ƒ } | jjdd�| d< | jdƒd jƒ S )NÚmin)ÚmethodÚrankr  )rW   r  r  r7   r  )r!   r   r   r   Úf_copy¯  s    z"test_mutate_groups.<locals>.f_copyc             S   s$   | j jdd�| d< | jdƒd jƒ S )Nr  )r  r  r  )r  r  r7   r  )r!   r   r   r   Ú	f_no_copy´  s    z%test_mutate_groups.<locals>.f_no_copyr  )	r   rX   r2   r4   rà   r7   r=   r:   r;   )rZ   r  r  Z
grpby_copyZgrpby_no_copyr   r   r   Útest_mutate_groupsœ  s    Dr  c           
   C   sd   t dddddddddg	tdƒdœƒ} | jddd�jd	d
„ ƒ}| jddd�jdd
„ ƒ}tj||ƒ d S )Nr#   r-   r   r   )r   rL   r   T)Ú
group_keysc             S   s   | d d … j S )N)r   )r!   r   r   r   r"   Ä  s    z/test_no_mutate_but_looks_like.<locals>.<lambda>c             S   s   | j S )N)r   )r!   r   r   r   r"   Å  s    )r   rX   r7   r=   r:   r;   )rZ   r£   r¤   r   r   r   Útest_no_mutate_but_looks_like½  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—   r  rt   ro   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   Údogr  r�   )r    rd   r   )r   r#   )r   rv   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   rf   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   rf   r   r:   r;   )rZ   r   r   r   r   r   Útest_consistency_name0  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   )rf   r/   Ú	omissions)r.   )r	   )rZ   r.   r   r   r   Ú	summarizeC  s    z0test_groupby_name_propagation.<locals>.summarizec             S   s   t ddddœ| jd d d�S )Nr#   r-   r   )rf   r/   r,  r   r   )r.   )r	   rm   )rZ   r   r   r   Úsummarize_random_nameF  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_propagationA  s    
r0  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‰   U  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_columnsT  s
    
r1  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   rq   r:   rV   r$   )rZ   r   r   r   r   r   Útest_groupby_mixed_type_columns\  s    "r2  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š   Úfillrr   r	   ZtilerX   r7   r<   ZmedianZisnar³   r   )ZarrÚobjZindsr   r   r   r   Ú(test_cython_grouper_series_bug_noncontigi  s    
r5  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   ro   r   r   r   Ú#test_series_grouper_noncontig_indext  s    
r9  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  rt   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   r:  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   re   r   )r
  r•   r;  r=  rD   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,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   rq   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Ž   r  r�   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    $ rA  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-   )Ústartrl   Úfreqr   r*   r   r  Zmetricr”   )rd   r    r   )r   rC  )r   r   r
   r   r7   r   r/   r›   r    r:   rV   )rC  r    rZ   r   r   r   r   r   Ú$test_groupby_keys_same_size_as_index´  s     rD  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   rg   rh   r   r   r   Útest_groupby_one_rowÁ  s    rG  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”   Údtr:  rH  r#   r%   r   r¢   r-   r   z2013-01-01 00:00:00)r   z2013-02-01 00:00:00z^NaT$)r'   )rr   Únatrr   r   rI  zdatetime64[ns]z^nan$)rr   rI  )!r   r   r2   r4   rÆ   rr   r
   r7   r   Úsortedr¯   rÍ   r8   r   rí   r:   rô   rV   Úgrouperr‹   r4  ZngroupsrÇ   r   r°   Úassert_numpy_array_equalrÙ   rm   r@   rA   r@  rs   r   )rZ   rD   r   rÍ   rE   rt   Znan_dfr   r   r   r   Útest_groupby_nat_excludeÌ  sP    

"
  $

rM  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   rL  r”   )r  ÚtmpZ
res_valuesr   r   r   Útest_groupby_2d_malformed  s    rS  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    "
rT  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   )rU  )rƒ   rV  r   r   r   r‰   0  s    c             S   s   g | ]}t |ƒ‘qS r   )rU  )rƒ   r!   r   r   r   r‰   5  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   )rU  )rƒ   rV  r   r   r   r‰   A  s    zCtest_groupby_sort_multi.<locals>._check_groupby.<locals>.<listcomp>)r”   ÚcomÚasarray_tuplesafer7   r±   r   )	rZ   r   rÍ   Úfieldro   Útupsr   rE   rF   r   r   r   Ú_check_groupby@  s
    
z/test_groupby_sort_multi.<locals>._check_groupby)r   r2   r4   rÆ   r”   rX  rY  r7   r$   r:   rL  r    )rZ   r[  r   rD   r\  r   r   r   Útest_groupby_sort_multi!  s.    


.r]  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"   O  s    z/test_dont_clobber_name_column.<locals>.<lambda>)r   r7   r=   r:   rV   )rZ   r   r   r   r   Útest_dont_clobber_name_columnJ  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)rz   )r!   r   r   r   r"   W  s    z&test_skip_group_keys.<locals>.<lambda>F)r  c             S   s   | j dd�d d… S )Nr   )Úbyr   )Úsort_values)r!   r   r   r   r"   X  s    c             S   s$   g | ]\}}|j d d�dd… ‘qS )r   )r_  Nr   )r`  )rƒ   r   rO   r   r   r   r‰   Z  s    z(test_skip_group_keys.<locals>.<listcomp>r   c             S   s   | j S )N)rz   )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‰   b  s    )r:   r‡   r7   r=   r   rÎ   rV   r;   )ZtsfrD   r   Úpiecesr   r   r   r   Útest_skip_group_keysS  s    

rb  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_nameh  s    rc  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  )re  r-   )	r   r2   r3   Úreshaper7   r<   r   r   r   )r!   rD   r   r   r   r   Útest_multifunc_sum_bugq  s    
rg  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Þ   r  )rÞ   r  )rO   r   r   r   ro   }  s    z(test_handle_dict_return_value.<locals>.fc             S   s   t | jƒ | jƒ dœƒS )N)rÞ   r  )r	   rÞ   r  )rO   r   r   r   r~   €  s    z(test_handle_dict_return_value.<locals>.gr   rR   )r7   r=   re   r	   r   r:   r;   )rZ   ro   r~   r   r   r   r   r   Útest_handle_dict_return_value|  s    rh  rK  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   ro   Œ  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!   )ri  r   r   r�   ”  s    z test_set_group_name.<locals>.foo)rR   rS   rR   )r7   r=   r9   r>   )rZ   rK  ro   r�   rD   r   )ri  r   Útest_set_group_nameŠ  s    



rj  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   ro   «  s    z6test_group_name_available_in_inference_pass.<locals>.fr…   F)rW  r  )r   r   r2   r3   r7   r=   r   )rZ   ro   Zexpected_namesr   )r™   r   Ú+test_group_name_available_in_inference_pass¥  s    "
rk  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    rl  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   rW  T)r   r	   r7   rq   r:   r;   Ú
sort_index)r    ZmseriesZmseries_resultr   r   r   r   Ú#test_groupby_sort_multiindex_series¾  s    ,rn  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)rB  rC  rl   )ÚhighÚlow)r    Fc                s   ‡ ‡fdd„}|S )zB
            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    r7  Údropnar8   )rC   r  )Úfixra   r   r   Ú_funcÞ  s    zGtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._funcr   )rq  ra   rs  rt  r   )rs  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Ê   )rq  )r!   r   r   r   r"   é  s    zEtest_groupby_reindex_inside_function.<locals>.afunc.<locals>.<lambda>)Úselectrr  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�   rz   r‚   )r!   r   r   r   r"   ì  s    z6test_groupby_reindex_inside_function.<locals>.<lambda>ro  rÊ   T)F)	r   r   r2   r3   r7   r<   rÞ   r:   rV   )rl   ÚindrZ   ru  rw  rD   Zclosure_badZclosure_goodr   r   r   Ú$test_groupby_reindex_inside_functionÓ  s    
ry  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   rz  r{  T)r   rW  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    


r|  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   rW  )r…   r}  )r~  r  )r€  r�  )FT)r   rÓ   r   rd   Zis_lexsortedr   Úpivot_tablerâ   r:   rV   r7   r/   Zassert_produces_warningr   r›   r    r=   Zdrop_duplicatesrm  )Zlexsorted_miZlexsorted_dfZnot_lexsorted_dfr   r   rZ   r   rW  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"   E  s    c             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   L  s    c             S   s   t | ƒdkS )Nr-   )r8   )r!   r   r   r   r"   R  s    )r   rŠ   r7   Úfilterrm   r:   rV   r²   r;   r    rU   r�   )rZ   r~   Úactualr   rþ   r   r   r   Ú"test_index_label_overlaps_location:  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   rh   Úgbr   Zgb2r   r   r   r   Ú"test_transform_doesnt_clobber_intsW  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  rt   Ú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_sortf  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   rr   )rƒ   Úir   r   r   r‰   �  s    z2test_group_shift_with_null_key.<locals>.<listcomp>r   r   rF  )r   rd   r    c                s.   g | ]&}|d  r$|ˆ d k r$|d nt j‘qS )r   r&   )r2   rr   )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   rF  )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—  rm   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)rl   rC  r   )Ú	eventDateZthenamerŸ  r�   rz   z	'badname')r'   Zbadnamerf   )r    rd   r”   Zaggfunc)r   r   r   r   ÚtodayÚtolistrX   r›   r    r�   rz   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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—   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   )rl   rC  )rd   r    r$   ÚohlcÚopenro  rp  Úclose)rC  ©r�   r$   r�   ©r�   r§  r¨  ©r�   r§  ro  ©r�   r§  rp  ©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   rs   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   rq   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!   )rv   rŽ   rý   r�   r(   r)   Úx1)Ú	iterablesr™   é   r¼   )r   r   r2   r3   rf  r    r.   rd   r7   r$   r©   r:   rV   r   r¥  )r¸  rZ   Úresultsr   rº  rÔ   r   r   r   Útest_groupby_axis_1K  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)r8  r¾  c                s   | j jjˆ ƒS )N)r¾  rH  Útz_localize)r!   )Útzr   r   r"   ›  s    z+test_shift_bfill_ffill_tz.<locals>.<lambda>)r¾  r8  c                s   | j jjˆ ƒS )N)r¾  rH  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_tza  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   rr   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…   c             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  ÚngroupÚcumcountzNot applicabler#   )rd   r   Úfillnará   ZcorrwithZtshiftr   rS   r-   >   rÉ  rÈ  r  >   rá   rÊ  )r#   r-   )r@   Úskipr   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   )rv   r   )r   rS   )r   r   )r   rR   )rS   r   )r   r   Z_get_axis_numberr©   r7   Znuniquer:   rV   )rv   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   rf  r7   r/   r:   rV   )r   r   r   r   r   Útest_groupby_list_levelì  s    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ÚcommonrX  r   ÚmarkZparametrizerJ   r[   ri   ru   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+  r0  r1  r2  Úfilterwarningsr5  r9  r>  r?  rA  rD  rG  rM  rS  rT  r]  r^  rb  rc  rg  rh  rj  rk  rl  rn  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   Ú<module>   s  $
1'>(8(="!8	

 !&

?
)			 2			

&