3
Êb_ Ç  ã               @   sp
  d dl Z d dlZd dlmZ d dlmZ d dlmZ d dl	Z
d dlZd dlmZ d dlZd dlmZmZmZmZmZmZmZmZmZ d dljZd dljjZd dlm Z! ej"j#dd	d
gƒej"j#dddgƒej"j#ddddgdddgdddgdddgdd d gd d d gdddgdddgdddgdddgdddgdddge
j$e
j$e
j$ggƒdd„ ƒƒƒZ%dd„ Z&dd„ Z'ej"j#d e(e)e*gƒej"j#d!d"d"d#ggƒd$d%„ ƒƒZ+d&d'„ Z,d(d)„ Z-d*d+„ Z.d,d-„ Z/d.d/„ Z0ej"j#d0d1d2d3d4d5d6d7gƒej"j#d8d9d:ddd;œddd;œgifd<d:ddd;œdd=d;œgifd>d:ddd;œddd;œgifd?d:ddd;œdd=d;œgifd@ddd;œdd=d;œgdgdAœfdBddd;œddd;œgd4dCœfgƒdDdE„ ƒƒZ1ej"j#dFedGƒedHƒfdügƒdKdL„ ƒZ2ej"j#dMdNd dgddgddgdOœfdPddgd dgd dgdOœfgƒdQdR„ ƒZ3dSdT„ Z4dUdV„ Z5dWdX„ Z6ej"j#dYdZe
j7fd[e
j8fd\e
j9fd]e
j:fd^e
j*fd_e
j;fd>e
j)fd?e
j(fd9d`da„ fd<dbda„ fdBe
j<fej=dce6e!j>dd�gƒdedf„ ƒZ?dgdh„ Z@didj„ ZAdkdl„ ZBdmdn„ ZCej"j#dodZd]d\dpdqgƒdrds„ ƒZDej"jEedtddu�dvdw„ ƒZFej"j#dxdddyddd d=dydýddgddddgfdd{e
jGdde
jGe
jG dyd|de
jG gddddgfdde
j$dde
j$e
j$dye
jG de
j$gddddgfgƒd}d~„ ƒZHej"j#dxdd€d�dd=dydþdd ddgddddgfe
jGde
jG e
jGddÿe
jG dy�d e
jG e
jG gddddgfdde
j$dde
j$e
j$dye
jG de
j$gddddgfgƒd‚dƒ„ ƒZId„d…„ ZJd†d‡„ ZKdˆd‰„ ZLdŠd‹„ ZMdŒd�„ ZNdŽd�„ ZOd�d‘„ ZPej"j#d’de
jQddzƒ ƒej"j#d“dd”d•gƒej"j#d–ddgƒej"j#d—ddgƒd˜d™„ ƒƒƒƒZRdšd›„ ZSdœd�„ ZTdždŸ„ ZUd d¡„ ZVej"j#d¢d£d£d£ged¤ƒeed¤ƒgdedgejd£gd¥d¦�d§d¨�fd£d£d£gejWd©ddƒeejWd©ddƒgdedgejd£gd¥d¦�d§d¨�fd£d£d£dªdªgejWd©ddƒeejWd©ddƒeejWd©ddƒgdeddgejd£dªgd¥d¦�d§d¨�fd£d£d£d£dªgejWd©ddƒeejWd©ddƒeejWd©ddƒgdeddgejd£dªgd¥d¦�d§d¨�fgƒd«d¬„ ƒZXd­d®„ ZYd¯d°„ ZZd±d²„ Z[d³d´„ Z\dµd¶„ Z]d·d¸„ Z^d¹dº„ Z_d»d¼„ Z`d½d¾„ Zad¿dÀ„ ZbdÁdÂ„ Zcej"j#dÃdÄdÅdÆdÇdÈgƒej"j#dÉdddd=dygdyd=dddgfdddd=gd=dddgfdddd=dygd=dddgfddddÊdËgdËdÊdddgfde
j$de
j$dËgdËe
j$de
j$dgfe
j$dÊe
j$de
j$ge
j$dÊe
j$de
j$gfedejdÌdÍdydÎ�ƒedejdÌdÍdydÎ�ƒdd�d… fe
j$gdy e
j$gdy fgƒej"j#dÏd dÐdÑdÒdgƒdÓdÔ„ ƒƒƒZedÕdÖ„ Zfd×dØ„ ZgdÙdÚ„ ZhdÛdÜ„ Ziej"j#dÝ�d�dgƒej"j#dÞd gd dggƒej"j#dÏdÑdßggƒdàdá„ ƒƒƒZjdâdã„ Zkdädå„ Zldædç„ Zmej"j#dède
j$de
j$gend=ƒddgddgfde
j$ddgend=ƒddgddégfdêdëdëe
j$gend=ƒdêdëgd dìgfd gdígd gdîgfg g e
jog d6dï�e
jog d6dï�fgƒdðdñ„ ƒZpdòdó„ Zqdôdõ„ Zrdöd÷„ Zsej"j#dødddddddddg	dejtddejtddejtdg	d;œddddddgddddddgd;œgƒej"j#dùdZd[d]gƒdúdû„ ƒƒZudS (  é    N)ÚStringIO)Úproduct)Úascii_lowercase)ÚUnsupportedFunctionCall)	Ú	DataFrameÚIndexÚ
MultiIndexÚNaTÚSeriesÚ	TimestampÚ_is_numpy_devÚ
date_rangeÚisna)Ú_test_decoratorsÚagg_funcÚanyÚallÚskipnaTFÚvalsÚfooÚbarÚbazÚ é   é   é   g      ð?g       @g      @g        c             C   s”   t dgd dgd  |d dœƒ}tt| ƒ|ƒ}|rLtt|ƒƒrL| dkrLd}t |gd dgtddgd	d
�d�}t|jd	ƒ| ƒ|d�}tj||ƒ d S )NÚar   Úbr   )ÚkeyÚvalr   Fr   r   )Úname)ÚcolumnsÚindex)r   )	r   ÚgetattrÚbuiltinsr   r   r   ÚgroupbyÚtmÚassert_frame_equal)r   r   r   ÚdfÚexpZexp_dfÚresult© r+   úD/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/groupby/test_function.pyÚtest_groupby_bool_aggs   s    ""r-   c              C   sš   t ddddgddddgddg dœƒ} | jd	ƒjƒ }d
|ks@t‚| jd	ƒjdd�}d
|ks^t‚| jd	ƒjƒ }d
|ksxt‚| jd	ƒjdd�}d
|ks–t‚d S )Né   é   r   r   r   é   Zmama)ÚnnÚiiÚssr1   r3   F)Únumeric_only)r   r%   ÚmaxÚAssertionErrorÚmin)Zaar*   r+   r+   r,   Útest_max_min_non_numeric@   s    &r8   c              C   s`   t ddtjdgƒ} | jddddgƒ}|jtjƒ}|jtjƒ}|jƒ }tj	||ƒ tj	||ƒ d S )Ng      ð?g       @g      @r   r   r   )
r
   ÚnpÚnanr%   Úaggr$   ÚsumÚapplyr&   Úassert_series_equal)ÚsÚgroupedr*   Zresult2Úexpectedr+   r+   r,   Útest_intercept_builtin_sumQ   s    rB   ÚfÚkeysÚjimÚjoec             C   sø   t jtjjdddƒddgd�}tjjdƒ|d< |j}|j| ƒj|ƒ}t	|j
| d	�ƒ}d
|j› d|› d�}|j|dfks~t|ƒ‚tj||j| ƒjtt|ƒƒƒ |tkrØ|j| ƒj|ƒjƒ }|j| ddd� tj||dd� tjt||ƒƒ t||ƒƒ ƒ d S )Nr   é2   éè  r   rE   rF   )r!   Zjolie)Zsubsetzinvalid frame shape: z (expected (z, 3))r   TF)ÚinplaceÚdrop)Zcheck_dtype)rH   r   )Úpdr   r9   ÚrandomÚrandintÚrandnÚ__name__r%   r=   ÚlenZdrop_duplicatesÚshaper6   r&   r'   r#   r<   r;   Úreset_indexÚ	set_indexr>   )rD   rC   r(   Úfnamer*   ZngroupsZ
assert_msgrA   r+   r+   r,   Útest_builtins_apply`   s    rU   c              C   s˜  t jdddgdddgdddgtdƒt jtdƒƒjdƒd	d
dgt jddd�t jdddd�t jdddd�dœ	dddddddddg	d�} tdddgƒ}t jddgddgt jd ƒt jd!ƒgd"dgt j	d#ƒt j	d$ƒgt j	d#dd%�t j	d$dd%�gd&œtddgdd'�ddddddgd(�}xNd7D ]F}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ|ƒ �qW tdddddddgƒ}xJd8D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �qvW tddddddddgƒ}xJd9D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �qÚW tdddddgƒ}xJd:D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �q8W tdddgƒ}xJd;D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �q’W tddddddgƒ}xJd<D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �qòW tddddgƒ}xJd=D ]B}t
| jdƒ|ƒ}|ƒ }tj|j|ƒ |d+d,�}tj|j|ƒ �qNW d S )>Nr   r   r   g      @g      @g      @ÚabcÚcategoryé   é   é	   Z20130101)Úperiodsz
US/Eastern)r[   Útzz1 sr?   )r[   Úfreq)	ÚgroupÚintÚfloatÚstringÚcategory_stringÚcategory_intÚdatetimeÚ
datetimetzÚ	timedeltar^   r_   r`   ra   rb   rc   rd   re   rf   )r!   g      @g      @z1.5sZ3sg      ø?z2013-01-01 12:00:00z2013-01-03 00:00:00)r\   )rc   r`   rf   r_   rd   re   )r    )r"   r!   ÚmeanÚmedianF)r4   r7   r5   ÚfirstÚlastr<   ÚprodÚcumprodÚcumminÚcummaxÚcumsum)rg   rh   )r7   r5   )ri   rj   )r<   )rk   rl   )rm   rn   )ro   )rK   r   Úlistr
   Úastyper   Ztimedelta_ranger   Z	Timedeltar   r#   r%   r&   Zassert_index_equalr!   r'   Zreindex_like)r(   Zexpected_columns_numericrA   ÚattrrC   r*   Úexpected_columnsr+   r+   r,   Útest_arg_passthru{   s¾    















rt   c           
   C   s6  t dddgdtjdgdtjdggddd	gd
�} | jdƒ}| jddd�}t dgtjggdgddgd�}d|j_|jƒ }tj||ƒ t ddgdtjggddgddgd�}|jƒ }tj||ƒ t	j
ddgdd�}t	jdgddddddddggdgd ttdƒƒgd�}t	j ddtjdddddgdtjtjtjtjtjtjtjgg||d�}|jƒ }tj||ƒ t	j| | jdk jƒ jƒ jƒ j| | jdk jƒ jƒ jƒ jgƒ}t	j
ddgƒ|_|jƒ }tj||ƒ t ddgddggdd	gddgd�}d|j_|jƒ }tj||ƒ t dgtjggdgddgd�}d|j_|jƒ }tj||ƒ d S )Nr   r   r   r   r   r   ÚAÚBÚC)r!   F)Úas_indexr   )r!   r"   g        )r    Úcountrg   Ústdr7   z25%z50%z75%r5   rY   )ÚlevelsÚcodesg      ð?g       @)r"   r!   T)r   r9   r:   r%   r"   r    Zmadr&   r'   rK   r   r   rp   ÚrangeÚdescribeÚconcatru   ZunstackÚto_frameÚTr   Úidxmax)r(   ÚgZgnirA   r*   Úexpected_indexZexpected_colr+   r+   r,   Útest_non_cython_api
  sJ    ,
$"  r…   c              C   sä   t ddtjgdtjdgdddggdddgd	�} t dtjgtjdgddggddgd	�}| jdƒjƒ }tj||ƒ | jdd
d�jƒ }tj||ƒ | jdƒjdd�}| jdd�}tj||ƒ | jdƒjdd�}| jdd�}tj||ƒ d S )Nr   r   rZ   r   r0   ru   rv   rw   )r!   F)rx   )Úaxis)r   r9   r:   r%   ro   r&   r'   rl   )r(   rA   r*   r+   r+   r,   Útest_cython_api2I  s    .&r‡   c              C   s¸   t tjjdƒƒ} tj| jd d d…< tjjdddd�jtƒ}tj|d d d…< | j	|ƒj
ƒ }| j	|ƒjtjƒ}tj||ƒ t tjjddƒƒ} | j	|ƒjtj
ƒ}| j	|ƒj
ƒ }tj||ƒ d S )Niè  r   r   rG   )Úsizeé   é   )r   r9   rL   rN   r:   ÚvaluesrM   rq   r`   r%   rh   r;   ÚnanopsZ	nanmedianr&   r'   )r(   Úlabelsr*   r)   ÚrsZxpr+   r+   r,   Útest_cython_median`  s    r�   c             C   sl   t jtjjdddƒƒ}tdddƒ}t j|d |ƒ}|j|| d�jƒ }|j|| d�j	dd„ ƒ}t
j||ƒ d S )	Nr   é,   iô  é7   rŠ   )Úobservedc             S   s   | j ƒ S )N)rh   )Úxr+   r+   r,   Ú<lambda>x  s    z(test_median_empty_bins.<locals>.<lambda>)rK   r   r9   rL   rM   r}   Zcutr%   rh   r;   r&   r'   )r’   r(   ZgrpsZbinsr*   rA   r+   r+   r,   Útest_median_empty_binsq  s    r•   ÚdtypeÚint8Úint16Úint32Úint64Úfloat32Úfloat64Zuint64zmethod,datari   r(   )r   r   rj   r0   r7   r5   Únth)r(   Úargsry   )r(   Úout_typec       	      C   s¼   t jdddœdddœdddœdddœgƒ}|jj| ƒ|d< d|krJg |d< d|kr\|d }n| }|d	 }t j|ƒ}|jj|ƒ|d< |jd
dd� |jd
ƒ}t||ƒ|d Ž }tj||ƒ d S )Nr   )r   r   r   r   r0   r   rž   rŸ   r(   r   T)rI   )	rK   r   r   rq   rS   r%   r#   r&   r'   )	r–   ÚmethodÚdatar(   rŸ   r)   Zdf_outZgrpdÚtr+   r+   r,   Ú%test_groupby_non_arithmetic_agg_types|  s    &


r£   Úiz2011-01-15 12:50:28.502376z2011-01-20 12:50:28.593448ì    m;-L¼ì    m;-L¼c             C   sÂ   t jd| d dœd| d dœgƒ}d| d id| d id| d id| d i| d dgdœddidœ}xX|jƒ D ]L\}}d|kr†g |d< |jd	ƒ}t||ƒ|d Ž }|jd j|d ksnt‚qnW d S )
Nr   r   )r   r   rA   )rA   rž   r   )ri   rj   r7   r5   r�   ry   rž   r   )rK   r   Úitemsr%   r#   Úilocr   r6   )r¤   r(   Zgrp_expr    r¡   r@   Úresr+   r+   r,   Ú2test_groupby_non_arithmetic_agg_int_like_precision¥  s    "




rª   zfunc, valuesZidxmin)Úc_intÚc_floatÚc_dater‚   c             C   s‚   t jddddgddddgddd	d
gddddgdœƒ}t j|d ƒ|d< t|jdƒ| ƒƒ }t j|tddgdd�d�}tj||ƒ d S )Nru   rv   r   r   r   r0   g®Gáz@g=
×£p=@gR¸…ëQ @gÍÌÌÌÌÌð?Z2019Z2018Z2016Z2017)r    r«   r¬   r­   r­   r    )r    )r"   )rK   r   Úto_datetimer#   r%   r   r&   r'   )Úfuncr‹   r(   r*   rA   r+   r+   r,   Ú$test_idxmin_idxmax_returns_int_typesÆ  s    	


r°   c              C   sÎ   t tjjddgtddƒgƒtddgdd�d	�} tjd
tjtjdtjtjdtjtjdtjg| d< tjdtjtjdtjtjdtjtjdtjg| d< | jddd�j	dd�}| j
jdd
d�j	dd�j
}tj||ƒ d S )NZvalue1Zvalue2z
2014-01-01z
2014-01-06Ú1Ú2Úid)r    )r"   r!   r   r.   r   r/   r   é!   r0   r�   r   )Úlevelr†   Zffill)r    )r   rK   r   Úfrom_productr   r   r9   r:   r%   Zfillnar�   r&   r'   )r(   rA   r*   r+   r+   r,   Útest_fill_consistencyà  s>    r·   c              C   sº   t jdgd ddœƒ} | jdƒd jƒ }| jdƒd jdd„ ƒ}d|_tj||ƒ t jdgd	 ddœƒ} | jdƒd jƒ }| d jt	ƒ| d< | jdƒd jd
d„ ƒ}d|_tj||ƒ d S )Nr   é
   r   )r   Úvaluer   r¹   c             S   s   | j ƒ S )N)rl   )r“   r+   r+   r,   r”     s    z&test_groupby_cumprod.<locals>.<lambda>éd   c             S   s   | j ƒ S )N)rl   )r“   r+   r+   r,   r”     s    )
rK   r   r%   rl   r=   r    r&   r>   rq   r`   )r(   ÚactualrA   r+   r+   r,   Útest_groupby_cumprod  s    r¼   c              O   s   ddl m} || ddi|—ŽS )Nr   )ÚsemZddofr   )Zscipy.statsr½   )rž   Úkwargsr½   r+   r+   r,   Ú	scipy_sem   s    r¿   z	op,targoprg   rh   rz   Úvarr<   rk   c             C   s
   | j d S )Nr   )r¨   )r“   r+   r+   r,   r”   1  s    r”   c             C   s
   | j d S )Nr   éÿÿÿÿ)r¨   )r“   r+   r+   r,   r”   2  s    r½   )Zmarksc             C   s`   t tjjdƒƒ}tjjdddd�jtƒ}t|j|ƒ| ƒƒ jtƒ}|j|ƒj	|ƒ}t
j||ƒ d S )Niè  r   rG   )rˆ   )r   r9   rL   rN   rM   rq   r`   r#   r%   r;   r&   r'   )ÚopZtargopr(   r�   r*   rA   r+   r+   r,   Útest_ops_general&  s
    rÃ   c              C   sf   d} t jt| ƒdgd�}|jdƒ}|dg jƒ }|d jƒ jƒ }tj||ƒ |d jƒ j	ƒ  sbt
‚d S )Nz,Date,app,File
-04-23,2013-04-23 00:00:00,,log080001.log
-05-06,2013-05-06 00:00:00,,log.log
-05-07,2013-05-07 00:00:00,OE,xlsxr   )Zparse_datesÚDateZFile)rK   Zread_csvr   r%   r5   r€   r&   r'   r   r   r6   )Úrawr(   ÚgbÚrÚer+   r+   r,   Útest_max_nan_bug@  s    
rÉ   c              C   sì   t ddddddddd	d
g
ƒ} t tdƒƒ}| j|ƒ}|jdƒ}t dddd
dd	gtjtdƒddddddggƒd�}tj||ƒ t ddddddddddg
ƒ} | j|ƒ}t ddddddgtjtdƒdddd	ddggƒd�}tj|jddd�|ƒ d S )Nr   r   rŠ   rX   r   rZ   r   r0   é   r¸   r   r   ÚaaabbbrY   )r"   rj   )ÚkeepÚaaaaaÚbbbbbÚ
aaaaabbbbb)r
   rp   r%   Únlargestr   Úfrom_arraysr&   r>   )r   r   rÆ   rÇ   rÈ   r+   r+   r,   Útest_nlargestN  s    

"
"rÒ   c        	      C   sF  t jjdƒ} tddd�}|ddgg}tj|ddgd	�}t| jd
ƒ|d�}|jdƒj	dƒ}tj
|d |d df|d |d df|d |d df|d |d df|d |d df|d |d df|d |d df|d |d df|d |d df|d |d dfg
dddgd	�}dddddddd#dd$g
}t||d�}tj||d d!d"� d S )%NiÍ[Z20180101r¸   )r[   ZoneZtwori   Úsecond)Únamesé   )r"   r   r   r   r   r0   rŠ   rÊ   rX   rY   rZ   g-rö´@g-µ`¦wý?g@Ñf¡|ë?gé‡p—¿ö?g=±J-î?g©],l;óà?g]£f˜$žê?gM8r‰ ë?gÅ«­4YØ?g¯
F;±é?FT)Zcheck_exactZcheck_less_precisegM8r‰ ë¿g¯
F;±é¿)r9   rL   ÚRandomStater   r   r¶   r
   rN   r%   rÐ   Úfrom_tuplesr&   r>   )	ZnprZdtsÚ	iterablesÚidxr?   r*   Zexp_idxZ
exp_valuesrA   r+   r+   r,   Útest_nlargest_mi_grouperb  s<    rÚ   c              C   sì   t ddddddddd	d
g
ƒ} t tdƒƒ}| j|ƒ}|jdƒ}t dddddd	gtjtdƒdddd	ddggƒd�}tj||ƒ t ddddddddddg
ƒ} | j|ƒ}t ddddddgtjtdƒddddddggƒd�}tj|jddd�|ƒ d S )Nr   r   rŠ   rX   r   rZ   r   r0   rÊ   r¸   r   r   rË   rY   )r"   rj   )rÌ   rÍ   rÎ   rÏ   )r
   rp   r%   Ú	nsmallestr   rÑ   r&   r>   )r   r   rÆ   rÇ   rÈ   r+   r+   r,   Útest_nsmallest�  s    

"
"rÜ   r¯   rl   ro   c             C   s„   t jdddgdddgdœƒ}|jdƒ}d}tjt|d�� t|| ƒdddƒ W d Q R X tjt|d�� t|| ƒdd� W d Q R X d S )	Nr   r   r   )ru   rv   ru   z+numpy operations are not valid with groupby)Úmatch)r   )rK   r   r%   ÚpytestÚraisesr   r#   )r¯   r(   rƒ   Úmsgr+   r+   r,   Útest_numpy_compat£  s    
rá   z1https://github.com/pandas-dev/pandas/issues/31992)ÚreasonÚstrictc           
   C   s   t jt jt jt jg} t jt jƒjt jt jƒjt jt jƒjt jt jƒjg}t jt jƒjt jt jƒjt jt jƒjt jt jƒjg}t	j
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dg}ddddddddg}�xžt| ||ƒD �]Œ\}}}|j|ƒ}	t	j
d|iƒj|ƒ}
|	jdƒjƒ }tj||
ƒ |	jdƒjjdd	„ ƒjƒ }tj||
ƒ ||	jdd
gdf< ||
jddd
dgdf< |	jdƒjƒ }tj||
ƒ |	jdƒjjdd	„ ƒjƒ }
tj||
ƒ t	j
d|iƒj|ƒ}
|	jdƒjƒ }tj||
ƒ |	jdƒjjdd	„ ƒjƒ }tj||
ƒ ||	jdd
gdf< ||
jddd
dgdf< |	jdƒjƒ }tj||
ƒ |	jdƒjjdd	„ ƒjƒ }
tj||
ƒ qäW t j|jdddd
gdf< t	j
dt jdt jdt jdt jdgiƒ}
|jdƒjƒ }tj||
ƒ |jdƒjjdd	„ ƒjƒ }
tj||
ƒ t	j
dt jdt jdt jdt jdgiƒ}
|jdƒjƒ }tj||
ƒ |jdƒjjdd	„ ƒjƒ }
tj||
ƒ t j|d< t	j
dt jgd iƒ}
|jdƒjƒ }tj|
|ƒ |jdƒjjdd	„ ƒjƒ }tj|
|ƒ |jdƒjƒ }tj|
|ƒ |jdƒjjdd	„ ƒjƒ }tj|
|ƒ t	j
tdgt	jdgƒd�ƒ}	t	jt	jdƒdgdd�}
x0dD ](}t|	jdƒd |ƒƒ }tj|
|ƒ �q4W t	j
tdddgdddgd�ƒ}	|	jdƒjjƒ }t	jdddgdd�}
tj||
ƒ t	j
tdddgdddgd�ƒ}	|	jdƒjjƒ }t	jdddgdd�}
tj||
ƒ d S )Nr   r   r   r0   )ru   rv   rv   ru   c             S   s   | j ƒ S )N)rm   )r“   r+   r+   r,   r”   Ò  s    z$test_cummin_cummax.<locals>.<lambda>rÊ   rX   c             S   s   | j ƒ S )N)rm   )r“   r+   r+   r,   r”   Ú  s    c             S   s   | j ƒ S )N)rn   )r“   r+   r+   r,   r”   á  s    c             S   s   | j ƒ S )N)rn   )r“   r+   r+   r,   r”   é  s    r   c             S   s   | j ƒ S )N)rm   )r“   r+   r+   r,   r”   ñ  s    c             S   s   | j ƒ S )N)rn   )r“   r+   r+   r,   r”   ÷  s    rY   c             S   s   | j ƒ S )N)rm   )r“   r+   r+   r,   r”   ÿ  s    c             S   s   | j ƒ S )N)rn   )r“   r+   r+   r,   r”     s    Z2001)r   r   r   )r"   r    rn   rm   r   )r    )rn   rm   )r9   r™   rš   r›   rœ   Ziinfor7   Zfinfor5   rK   r   Úziprq   r%   rm   r&   r'   rv   r=   r€   Úlocrn   r:   Údictr®   r
   r#   r>   r   )Z	num_typesZnum_minsZnum_maxZbase_dfZexpected_minsZexpected_maxsr–   Zmin_valZmax_valr(   rA   r*   r    r+   r+   r,   Útest_cummin_cummax±  sŽ    ,
&&

rç   zin_vals, out_valsrŠ   rÊ   gÍÌÌÌÌÌ @r.   c             C   s¤   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œ}t j|ƒ}|jdƒjj}ttdƒdd�}t j||dd�}tj	||ƒ |jdgƒjj
dd„ ƒ}tj	||ƒ d S )Nr±   r²   Ú3Ú4Ú5Ú6Ú7Ú8Ú9Ú10Ú11r   r   ÚcÚd)ru   rv   rw   rv   Úabcd)r    rw   )r"   r¡   r    c             S   s   | j S )N)Úis_monotonic_increasing)r“   r+   r+   r,   r”   9  s    z.test_is_monotonic_increasing.<locals>.<lambda>)rK   r   r%   rw   rô   r   rp   r
   r&   r>   r=   )Úin_valsÚout_valsÚsource_dictr(   r*   r"   rA   r+   r+   r,   Útest_is_monotonic_increasing  s    
rø   r¸   rZ   rX   c             C   s€   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œ}t j|ƒ}|jdƒjj}ttdƒdd�}t j||dd�}tj	||ƒ d S )Nr±   r²   rè   ré   rê   rë   rì   rí   rî   rï   rð   r   r   rñ   rò   )ru   rv   rw   rv   ró   )r    rw   )r"   r¡   r    )
rK   r   r%   rw   Zis_monotonic_decreasingr   rp   r
   r&   r>   )rõ   rö   r÷   r(   r*   r"   rA   r+   r+   r,   Útest_is_monotonic_decreasing=  s    
rù   c             C   s   | j dd�}|jƒ  d S )Nri   )rµ   )r%   r~   )Zmframer@   r+   r+   r,   Útest_apply_describe_bugb  s    rú   c              C   sr   t jƒ } | jdd„ dd„ gƒ}|jƒ }t j|d |jƒ dd� t j|d |jƒ dd� t j|d |jƒ dd� d S )	Nc             S   s   | j S )N)Úyear)r“   r+   r+   r,   r”   i  s    z/test_series_describe_multikey.<locals>.<lambda>c             S   s   | j S )N)Úmonth)r“   r+   r+   r,   r”   i  s    rg   F)Úcheck_namesrz   r7   )r&   ÚmakeTimeSeriesr%   r~   r>   rg   rz   r7   )Útsr@   r*   r+   r+   r,   Útest_series_describe_multikeyg  s    r   c              C   s@   t jƒ } | jdd„ ƒ}|jdd„ ƒ}|jƒ jƒ }t j||ƒ d S )Nc             S   s   | j S )N)rü   )r“   r+   r+   r,   r”   r  s    z-test_series_describe_single.<locals>.<lambda>c             S   s   | j ƒ S )N)r~   )r“   r+   r+   r,   r”   s  s    )r&   rþ   r%   r=   r~   Ústackr>   )rÿ   r@   r*   rA   r+   r+   r,   Útest_series_describe_singlep  s
    r  c             C   s@   | j d d …dgf j| d ƒ}|jdd„ ƒ}|jjdks<t‚d S )Nrw   ru   c             S   s   | j ƒ S )N)rg   )r“   r+   r+   r,   r”   z  s    z(test_series_index_name.<locals>.<lambda>)rå   r%   r;   r"   r    r6   )r(   r@   r*   r+   r+   r,   Útest_series_index_namex  s    r  c       	      C   s  | j dd„ dd„ gƒ}|jƒ }g }xf| D ]^}|| jƒ }tj|g|jgdgt|jƒ tt|jƒƒgd�}tj|j||j	d�}|j
|ƒ q(W tj|dd�}tj||ƒ | j ddddd	œdd�}|jƒ }| jƒ j}tjddg|j	gddddgtt|j	ƒƒgd�|_	tj||ƒ d S )
Nc             S   s   | j S )N)rû   )r“   r+   r+   r,   r”     s    z.test_frame_describe_multikey.<locals>.<lambda>c             S   s   | j S )N)rü   )r“   r+   r+   r,   r”     s    r   )r{   r|   )r!   r"   r   )r†   )ru   rv   rw   ÚD)r%   r~   rK   r   r!   rP   r}   r   r‹   r"   Úappendr   r&   r'   r�   )	Ztsframer@   r*   Zdesc_groupsÚcolr^   Z	group_colrA   ZgroupedTr+   r+   r,   Útest_frame_describe_multikey~  s&    

"
 r  c              C   s´   t dddddgd dddd	d
gd dddddgd dœƒ} dddgd | d< | jddid�}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 d S )Nr   r   r   r0   rŠ   r¸   rÕ   é   é(   rG   rº   éÈ   i,  i�  iô  )r“   ÚyÚzr   Úkr   )r!   z*Names should be list-like for a MultiIndex)rÝ   )r   r   r   )r   r   r   )r   r   r   )r   ÚrenamerÞ   rß   Ú
ValueErrorr%   r~   )Zdf1Zdf2rà   r+   r+   r,   Útest_frame_describe_tupleindex˜  s    r  c              C   sî   t jdd d�dt jdd d�dt jdd d�di} t jdd d�dt jdd d�dt jdd d�d	i}t j| |d
œƒ}|jdƒjjƒ }||jdk jjƒ jjƒ ||jdk jjƒ jjƒ g}t j|t j	ddgdd�ddddddddgd�}t
j||ƒ d S )Nz2011-01-06 10:59:05)r\   iža  z2011-01-06 12:43:33i›c  z2011-01-06 12:54:09i /hYl    rT i áõ)ÚPRICEÚVOLUMEr  )r    ry   rg   rz   r7   z25%z50%z75%r5   )r"   r!   )rK   r   r   r%   r  r~   r  r‹   Útolistr   r&   r'   )ZpricesZvolumesr(   r*   r¡   rA   r+   r+   r,   Ú$test_frame_describe_unstacked_format«  s    r  ÚnÚmrº   iè  ÚsortÚdropnac                s  d‡ ‡fdd„	}t ddd�}ttjjttƒ| ƒtjj|| ƒtjjd|| ƒdœƒ}||d	gƒ ||d	d
gƒ d |jdd d…d	f< d |jdd d…d
f< d |jdd d…df< d |jdd d…df< d |jdd d…df< ||d	gƒ ||d	d
gƒ ||d	gdd� ||d	d
gdd� d S )NTc                s|   | j ƒ }| j||ˆd�}|d jˆ d�}| j||ˆd�}|d jtjˆ d�}|s\|jdd�}tj||dd� tj| |ƒ d S )N)rx   r  Újulie)r  T)rJ   F)rý   )	Úcopyr%   Únuniquer=   r
   rR   r&   r>   r'   )r(   rD   rx   Zoriginal_dfZgrÚleftÚright)r  r  r+   r,   Úcheck_nuniqueÎ  s    z2test_series_groupby_nunique.<locals>.check_nuniquez
2015-08-23r¸   )r[   r   )rE   rF   r  rE   rF   r   r‰   r   é%   rX   é   r  rY   rZ   F)rx   )T)	r   r   r9   rL   Úchoicerp   r   rM   rå   )r  r  r  r  r  ÚdaysÚframer+   )r  r  r,   Útest_series_groupby_nuniqueÉ  s"    r$  c              C   s
  t tdƒtdƒtdƒdœƒ} t dgd dddgdddgdœƒ}| jdd	d
�jƒ }tj||ƒ tdƒ|_d|j_| jdƒjƒ }tj||ƒ | jdd iƒjdƒjd	d�}tj||ƒ t dgd dgd dgd dœtdƒd�}d|j_| jdd iƒjdƒjƒ }tj||ƒ d S )NZabbaccZabxaccZabbacx)ru   rv   rw   r   r   r   ru   F)rx   rV   r“   )r  )r"   )	r   rp   r%   r  r&   r'   r"   r    Úreplace)r(   rA   r*   r+   r+   r,   Útest_nuniqueô  s    "
*r&  c              C   sŠ   t jdddgdddgddd	gdddgdddggdddgd�} | jddgƒd jƒ }tj| j| jgƒ}t jdgd d|d�}t	j
||ƒ d S )Nrº   r   ZAlicer
  r   ZBobi,  r   ZCharliei�  r0   ZDaniô  rŠ   ZEdithÚamountr³   r    )r!   )r    r"   ipþÿÿ)rK   r   r%   r  r   rÑ   r³   r'  r
   r&   r>   )r¡   r*   r"   rA   r+   r+   r,   Útest_nunique_with_object  s    
r(  c              C   s<   t jdtd�} | jdd�jƒ }t jddd�}tj||ƒ d S )Nr    )r    r–   r   )rµ   rš   )rK   r
   Úobjectr%   r  r&   r>   )r¡   r*   rA   r+   r+   r,   Útest_nunique_with_empty_series  s    r*  c              C   sx   t jtdƒtdƒtdƒgdddgdœƒjdƒ} | jt jd	d
�ƒd jƒ }| jt jd	d
�ƒd jt jjƒ}t	j
||ƒ d S )Nz2016-06-28 09:35:35z2016-06-28 16:09:30z2016-06-28 16:46:28r±   r²   rè   )Útimer¡   r+  Úh)r]   r¡   )rK   r   r   rS   r%   ZGrouperr  r=   r
   r&   r>   )Útestr*   rA   r+   r+   r,   Útest_nunique_with_timegrouper'  s     r.  zkey, data, dropna, expectedr“   z
2019-01-01r   )r    r¡   )r"   r    iã  r  c             C   s8   t j| |dœƒ}|jdgƒd j|d�}tj||ƒ d S )N)r   r¡   r   r¡   )r  )rK   r   r%   r  r&   r>   )r   r¡   r  rA   r(   r*   r+   r+   r,   Útest_nunique_with_NaT8  s    r/  c              C   sV   t jdddgt jdgdd�d�} | jdddgƒjƒ }t jdg| jd�}tj||ƒ d S )Nr   r   ru   Zlevel_0)r    )r!   r   )rK   r   r   r%   r  r!   r&   r'   )r-  r*   rA   r+   r+   r,   Ú)test_nunique_preserves_column_level_names\  s     r0  c              C   s^   t tdƒtjdƒjdƒdœƒ} tddgtjddgdd	�d
d�}| jdƒj	j
ƒ }tj||ƒ d S )NÚabr   r0   ztimedelta64[ns])rƒ   Údeltr   r   rƒ   )r    r2  )r"   r    Úabab)r   rp   r9   Úarangerq   r
   rK   r   r%   r2  ry   r&   r>   )r(   rA   r*   r+   r+   r,   Ú#test_groupby_timedelta_cython_counth  s
     r5  c              C   sR  d} t d| d dd�}ttjjttƒ| ƒtjjdd| ƒtjj| ƒj	d	ƒtjjdd| ƒtjj|| ƒtjj| ƒj	d	ƒtjj| ƒj	d	ƒtjj|| ƒtjj|dƒ tjjttƒ| ƒd
œ	ƒ}x8|j
jdddgƒD ]"}tj|jtjj| | d ƒ|f< qÆW |d jdƒ|d< xNddddggD ]<}|j|ƒjƒ }|j|ƒjtjƒj|dd�}tj||ƒ �qW d S )Nr   é   z
2015-08-30r¸   r�   )r[   r]   r   rŠ   r   )	Ú1stÚ2ndZ3rdÚ4thZ5thZ6thZ7thZ8thÚ9thr7  r8  r9  r:  rW   )r†   i €  iöÿÿÿ)r   r   r9   rL   r!  rp   r   rM   rN   Úroundr!   rJ   r:   rå   rq   r%   ry   r=   r&   r'   )r  Zdrr(   r  r   r  r  r+   r+   r,   Ú
test_countq  s&    "r<  c              C   s¾   t jdddgdtjdgdtjtjggdddgd	�} | jdƒjƒ }| jdd
d�jƒ }tddgddggddgddgd�}d|j_tj	||j
ƒ ƒ tj	||ƒ | jdƒd jƒ }tj||d ƒ d S )Nr   r   r   r   r   ru   rv   rw   )r!   F)rx   r   )r!   r"   )rK   r   r9   r:   r%   ry   r"   r    r&   r'   rR   r>   )r(   Zcount_asZcount_not_asrA   Zcount_Br+   r+   r,   Útest_count_non_nullsŽ  s     "r=  c              C   sä   t jdgd dgd  dgd dgd  dœƒ} | jdƒjjƒ }t jddgt jddgdd�dd�}tj||ƒ t jdt	j
t	j
gdgd  dgd dgd  dœƒ} | jdƒjjƒ }t jd	dgt jddgdd�dd�}tj||ƒ d S )
Nr   r   r   r   )r   rñ   rñ   )r    )r"   r    r   )rK   r   r%   r   ry   r
   r   r&   r>   r9   r:   )r(   r*   rA   r+   r+   r,   Útest_count_object¢  s    0"4"r>  c              C   s°   t jt jjdddƒt jjdddƒfƒ} tj| ddddgd	�}t j||dk< |jddgƒjƒ }xNdD ]F}|d j	|ƒ|d< |d j	|ƒ|d< |jddgƒjƒ }t
j||ƒ qbW d S )Nr   rŠ   rº   r   r   r   rñ   rò   )r!   r›   r)  )rº   r   )rº   r   )r›   r)  )r9   ZhstackrL   rM   rK   r   r:   r%   ry   rq   r&   r'   )r   r(   rA   r¢   r*   r+   r+   r,   Útest_count_cross_type®  s    "
r?  c              C   s˜   t tjddddgtjƒtjddddgtjƒtjdddd	gtjƒtdƒdœƒ} | jdƒjƒ }t ddgddgddgdœt	j
td
ƒdd�d�}tj||ƒ d S )Nr   r   r   rº   r   rÊ   r0   rŠ   rY   r1  )r   r   rñ   Úgrpr@  )r   r   rñ   )r    )r"   r3  )r   r9   Úarrayr—   Zuint32r˜   rp   r%   ry   rK   r   r&   r'   )r(   r*   rA   r+   r+   r,   Útest_lower_int_prec_count¿  s    ,rB  c                 s†   G dd„ dt ƒ‰G ‡fdd„dƒ‰ t‡ fdd„tdƒD ƒtdƒd
œƒ} | jdƒjƒ }tdd	d	gitjtdƒdd�d�}tj	||ƒ d S )Nc               @   s   e Zd ZdS )zAtest_count_uses_size_on_exception.<locals>.RaisingObjectExceptionN)rO   Ú
__module__Ú__qualname__r+   r+   r+   r,   ÚRaisingObjectExceptionÐ  s   rE  c                   s*   e Zd Zd‡ fdd„	Z‡fdd„Z‡  ZS )z8test_count_uses_size_on_exception.<locals>.RaisingObjectúI will raise inside Cythonc                s   t ƒ jƒ  || _d S )N)ÚsuperÚ__init__rà   )Úselfrà   )Ú	__class__r+   r,   rH  Ô  s    
zAtest_count_uses_size_on_exception.<locals>.RaisingObject.__init__c                s   ˆ | j ƒ‚d S )N)rà   )rI  Úother)rE  r+   r,   Ú__eq__Ø  s    z?test_count_uses_size_on_exception.<locals>.RaisingObject.__eq__)rF  )rO   rC  rD  rH  rL  Ú__classcell__r+   )rE  )rJ  r,   ÚRaisingObjectÓ  s   rN  c                s   g | ]
}ˆ ƒ ‘qS r+   r+   )Ú.0Ú_)rN  r+   r,   ú
<listcomp>Ü  s    z5test_count_uses_size_on_exception.<locals>.<listcomp>r0   r1  r   )r   r@  r@  r   )r    )r"   r3  )
Ú	Exceptionr   r}   rp   r%   ry   rK   r   r&   r'   )r(   r*   rA   r+   )rN  rE  r,   Ú!test_count_uses_size_on_exceptionÏ  s    	$"rS  c       	      C   sb  | j ddgƒ}|jƒ }x$|D ]\}}|| t|ƒkst‚qW | j dƒ}|jƒ }x$|D ]\}}|| t|ƒksTt‚qTW | j dƒ}|jƒ }x$|D ]\}}|| t|ƒksŒt‚qŒW ttjjddƒtdƒd�} x^t	dd
dd
dgfƒD ]F\}}| j ||d�jƒ }| j ||d�d j
dd„ ƒ}tj||dd� qÜW tddgd�} tdtg dd�d�}tj| j dƒjƒ |ƒ d S )Nru   rv   rÕ   éè  r   rV   )r!   FTr   r   )r  rñ   c             S   s
   | j d S )Nr   )rQ   )r   r+   r+   r,   r”   ù  s    ztest_size.<locals>.<lambda>)rý   rš   )r    )r–   r"   )rT  r   )FT)r%   rˆ   rP   r6   r   r9   rL   r!  rp   r   r=   r&   r>   r
   r   )	r(   r@   r*   r   r^   r  r  r  Úoutr+   r+   r,   Ú	test_sizeæ  s(    

rV  c              C   sB   t dd d giƒ} | jdƒjƒ }tdtg dd�d�}tj||ƒ d S )Nru   rš   )r    )r–   r"   )r   r%   rˆ   r
   r   r&   r>   )r(   r*   rA   r+   r+   r,   Útest_size_groupby_all_null  s    rW  c              C   s@   t dgtjdgddd�d�} | jdd�}|jƒ }tj|| ƒ d S )Nr   Ú2000ru   r  )r    r]   )r"   )rµ   )r
   rK   ZPeriodIndexr%   rˆ   r&   r>   )Úserr@  r*   r+   r+   r,   Útest_size_period_index  s    rZ  ÚinterpolationZlinearÚlowerZhigherÚnearestZmidpointza_vals,b_valsg      @g      @z1/1/18r  )r]   r[   Úqg      Ð?g      à?g      è?c       	      C   sÀ   | dkr*|dkr*|ddddgkr*t jdƒ tj|ƒj|| d�}tj|ƒj|| d�}td	gt|ƒ d
gt|ƒ  || dœƒ}t||gdgtd	d
gdd�d�}|jdƒj|| d�}t	j
||ƒ d S )Nr]  g      à?r0   r   r   r   zBUnclear numpy expectation for nearest result with equidistant data)r[  r   r   )r   r   r   r   )r    )r!   r"   )rÞ   ÚskiprK   r
   Úquantiler   rP   r   r%   r&   r'   )	r[  Za_valsZb_valsr^  Z
a_expectedZ
b_expectedr(   rA   r*   r+   r+   r,   Útest_quantile  s     (ra  c              C   sô   t jddddddgiƒ} | jdddddgƒjdgƒ}t jjddgdggƒ}t jdddgi|d	�}tj||ƒ t jddddgdd
ddgdœƒ} t jjddgddggƒ}| jddddgƒjddgƒ}t jddddgddddgdœ|d	�}tj||ƒ d S )Nru   r   r   r   r   r0   g      Ð?g      @)r"   rŠ   rÊ   rX   )ru   rv   g      è?g      @g      @g      @g      @g      @g      @)rK   r   r%   r`  r   r¶   r&   r'   )r(   r*   r"   rA   r+   r+   r,   Útest_quantile_arrayC  s      rb  c              C   s¨   t jtjjdƒjddd d�tdƒd�} | jdƒjd	d
gƒ}t jddddddddddg
ddddddddddg
dœt j	j
dddddgd	d
ggdd gd�d�}tj||ƒ d S )!Nr   rŠ   r¸   r   )rˆ   ÚABC)r!   ru   g333333Ó?gffffffæ?gÍÌÌÌÌÌì?gÍÌÌÌÌÌ @gš™™™™™@g333333@gš™™™™™ù?g333333@gffffff@gš™™™™™@g        g333333ó?gffffff@gÍÌÌÌÌÌü?g      @gffffffþ?gÍÌÌÌÌÌ@)rv   rw   r   r   r0   )rÔ   )r"   )r¸   r   )rK   r   r9   rL   rÖ   rM   rp   r%   r`  r   r¶   r&   r'   )r(   r*   rA   r+   r+   r,   Útest_quantile_array2V  s    "$rd  c              C   sð   t jdddgdddgdœƒ} | jdddgdd	�jd
ddgƒ}t jddddddgddddddgdœt jjddgd
ddggƒd�}tj||ƒ | jdddgdd	�jdd
gƒ}t jddddgddddgdœt jjddgdd
ggƒd�}tj||ƒ d S )Nr   r   r   r   r0   rŠ   )ru   rv   F)r  g      Ð?g      à?g      è?g      ð?g      ø?g      @g      @g      @)r"   )rK   r   r%   r`  r   r¶   r&   r'   )r(   r*   rA   r+   r+   r,   Útest_quantile_array_no_sorth  s      re  c              C   s–   t jdddgdddgdddgdddgd	œƒ} | jd
dgƒjddgƒ}t jjddddgd
dd gd�}t jddddgddddgdœ|d�}tj||ƒ d S )Nr   r   r   r   r0   rŠ   r   r   )ru   rv   rñ   rò   rñ   rò   ç      Ð?ç      è?)rÔ   g       @g      
@g      @g      @)ru   rv   )r"   )r   r   rf  )r   r   rg  )r   r   rf  )r   r   rg  )rK   r   r%   r`  r   r×   r&   r'   )r(   r*   r"   rA   r+   r+   r,   Ú#test_quantile_array_multiple_levelsy  s    (
 rh  Ú
frame_sizer%   g333333ã?c                s  | \}‰t jtj‡fdd„t|ƒD ƒƒtˆƒd�}ttt|dƒƒƒgtˆ ƒ ˆg }‡fdd„tt|dƒƒD ƒgtˆ ƒ tttˆƒƒƒt|dƒ g }t j||ˆ d g d�}‡ ‡‡fdd„tt|dƒƒD ƒ}‡ fdd„tˆƒD ƒ}	t j|||	d	�}
|j	ˆ ƒj
ˆƒ}tj||
ƒ d S )
Nc                s   g | ]}ˆ |d  g ‘qS )r0   r+   )rO  rP  )Úncolr+   r,   rQ  �  s    zJtest_groupby_quantile_with_arraylike_q_and_int_columns.<locals>.<listcomp>)r!   r0   c                s   g | ]}ˆ D ]}|‘qqS r+   r+   )rO  r“   rP  )r^  r+   r,   rQ  “  s    )r{   r|   rÔ   c                s,   g | ]$}ˆD ]}t |ƒgˆtˆ ƒ  ‘qqS r+   )r`   rP   )rO  r“   rP  )r%   rj  r^  r+   r,   rQ  š  s    c                s   g | ]}|ˆ kr|‘qS r+   r+   )rO  r“   )r%   r+   r,   rQ  œ  s    )r"   r!   )rK   r   r9   rA  r}   rp   r7   rP   r   r%   r`  r&   r'   )ri  r%   r^  Znrowr(   Z
idx_levelsZ	idx_codesr„   Zexpected_valuesrs   rA   r*   r+   )r%   rj  r^  r,   Ú6test_groupby_quantile_with_arraylike_q_and_int_columnsˆ  s    &"$ rk  c           	   C   sP   t jddgddgddggddgd�} tjtdd	�� | jdƒjƒ  W d Q R X d S )
Nr   r   r   rñ   r   r   )r!   z+cannot be performed against 'object' dtypes)rÝ   )rK   r   rÞ   rß   Ú	TypeErrorr%   r`  )r(   r+   r+   r,   Útest_quantile_raises¥  s     rm  c              C   s„   t jtddddddgtdƒd�ƒ} | jddddddgƒ}tjtdd�� |jdƒ W d Q R X tjtdd�� |jd	ƒ W d Q R X d S )
Nr   r   rÊ   )r   r   zGot '50.0' instead)rÝ   rG   zGot '-1.0' insteadrÁ   )	rK   r   ræ   r}   r%   rÞ   rß   r  r`  )r(   rƒ   r+   r+   r,   Ú$test_quantile_out_of_bounds_q_raises®  s    "rn  c              C   sP   t jdt jdgƒ} tjt| tdƒd�ƒ}|jdƒ}xtdƒD ]}|jƒ  q<W d S )Ng      ð?r   )r   r   r   rº   )	r9   rA  r:   rK   r   ræ   r}   r%   r`  )r¡   r(   r@  rP  r+   r+   r,   Ú/test_quantile_missing_group_values_no_segfaults¹  s
    
ro  z$key, val, expected_key, expected_valg      @r   r   g      ø?é*   g      E@)r–   c             C   sd   t j| |dœƒ}t j|t j|dd�dgd�}|jdƒ}|jdƒ}tj||ƒ |jƒ }tj||ƒ d S )N)r   r   r   )r    r   )r"   r!   g      à?)rK   r   r   r%   r`  r&   r'   )r   r   Zexpected_keyZexpected_valr(   rA   r@  r*   r+   r+   r,   Ú2test_quantile_missing_group_values_correct_resultsÄ  s    

rq  c           	   C   s”   t jjdƒ} tddddddddg| jdƒ| jdƒdœƒ}dd„ }dd	„ }|jd
ƒj|ƒj|ƒ}tddgdd
d�}tj	ddgd|d�}t
j||ƒ d S )NiÒ–Ir   r   rY   )ru   rv   rw   c             S   s   | j jƒ | jjƒ jƒ  S )N)rv   r5   rw   r7   )Údfgbr+   r+   r,   rC   ó  s    ztest_pipe.<locals>.fc             S   s   | d S )Nr   r+   )Zsrsr+   r+   r,   Úsquareö  s    ztest_pipe.<locals>.squareru   r)  )r–   r    gÂÖ®vqû!@g‰	Ö¯Y @rv   )r    r"   )r9   rL   rÖ   r   rN   r%   Úpiper   rK   r
   r&   r>   )Zrandom_stater(   rC   rs  r*   r"   rA   r+   r+   r,   Ú	test_pipeå  s    ru  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„ }dd„ }| jdƒj|dƒj|dƒj|dƒ}t jdddgdd�}t jd%d&d'g|d�}tj||ƒ t jddddddgƒ}|j|ƒjdd„ ƒ}t jd d!d"gt jdddgƒd�}tj||ƒ d S )(Nru   rv   rw   g      ð?g       @g      @g      @g      $@g      Y@g     @�@)r^   r“   r  c                s   | j ‡ fdd„dd�j| jƒS )Nc                s   | j jƒ ˆ kS )N)r  rg   )r@  )Úarg1r+   r,   r”     s    z+test_pipe_args.<locals>.f.<locals>.<lambda>F)r  )Úfilterr%   Zgrouper)rr  rv  r+   )rv  r,   rC     s    ztest_pipe_args.<locals>.fc             S   s   | j ƒ | j ƒ j ƒ  | S )N)r<   )rr  Zarg2r+   r+   r,   rƒ     s    ztest_pipe_args.<locals>.gc             S   s   | j | j | S )N)r“   r  )r(   Zarg3r+   r+   r,   r,    s    ztest_pipe_args.<locals>.hr^   r   r¸   rº   )r    g#�šáS@gùÜbeøžS@éP   )r"   r   r   r   c             S   s   | j ƒ | jƒ  S )N)r<   ry   )r@  r+   r+   r,   r”   '  s    z test_pipe_args.<locals>.<lambda>r0   rY   é   g      YÀg     @�Àg#�šáSÀgùÜbeøžSÀi°ÿÿÿ)	rK   r   r%   rt  r   r
   r&   r>   Z
Int64Index)r(   rC   rƒ   r,  r*   r"   rA   rY  r+   r+   r,   Útest_pipe_args  s    " rz  c              C   sF   t jdddddgdddddgdœƒ} | jdƒd	 jƒ d d
ksBt‚d S )Nru   ij  i�  io  i`  l    @Ü~ÿÿ )ÚuserÚconnectionsr{  r|  l    ,fÌL™ )rK   r   r%   rg   r6   )r(   r+   r+   r,   Útest_groupby_mean_no_overflow.  s    r}  r‹   Úfunctionc             C   s¼   |dkrdnd}t j|gd td�}tjdddgtdd	�}tjd
|i|d�}tj| dd�jdƒ}t||ƒƒ }t	j
||ƒ |j|ƒ}t	j
||ƒ |j|gƒ}tjd
|fgƒ|_t	j
||ƒ d S )NrÀ   g      à?g      ø?r   )r–   r   r   r   )r–   r    r   )r"   ZInt64)r9   rA  r`   rK   r   r)  r   r%   r#   r&   r'   r;   r   r×   r!   )r‹   r~  ÚoutputZarrrÙ   rA   Úgroupsr*   r+   r+   r,   Ú,test_apply_to_nullable_integer_returns_float9  s    
r�  )r¥   r¦   iúÿÿÿéýÿÿÿr‚  r‚  rÁ   )r   r   )rº   r¸   )vr$   rd   ÚdtÚior   Ú	itertoolsr   ra   r   Znumpyr9   rÞ   Zpandas.errorsr   ZpandasrK   r   r   r   r	   r
   r   r   r   r   Zpandas._testingZ_testingr&   Zpandas.core.nanopsÚcorerŒ   Zpandas.utilr   ÚtdÚmarkZparametrizer:   r-   r8   rB   r5   r7   r<   rU   rt   r…   r‡   r�   r•   r£   rª   r°   r·   r¼   r¿   rg   rh   rz   rÀ   rk   rˆ   ÚparamZskip_if_no_scipyrÃ   rÉ   rÒ   rÚ   rÜ   rá   Zxfailrç   Úinfrø   rù   rú   r   r  r  r  r  r  r4  r$  r&  r(  r*  r.  Údater/  r0  r5  r<  r=  r>  r?  rB  rS  rV  rW  rZ  rp   ra  rb  rd  re  rh  rk  rm  rn  ro  r}   rA  rq  ru  rz  r}  ZNAr�  r+   r+   r+   r,   Ú<module>   sl  ,
   ?,(-

- e$$$$.$	 (* *.		
"& $ 	"  ,!($