3
®yb‘€  ã               @   s  d dl Z d dlmZ d dlZd dlZd dlmZ d dl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jjZd dlmZ ejejejejejgdddd	gd
�dd„ ƒ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%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/d0„ Z,d1d2„ Z-d3d4„ Z.d5d6„ Z/ej j!d7d8d9d:d;d<d=d>gƒej j!d?d@dAdddBœdddBœgifdCdAdddBœddDdBœgifdEdAdddBœdddBœgifdFdAdddBœddDdBœgifdGdddBœddDdBœgdgdHœfdIdddBœdddBœgd;dJœfgƒdKdL„ ƒƒZ0ej j!dMedNƒedOƒfd¥gƒdRdS„ ƒZ1ej j!dTdUd dgddgddgdVœfdWddgd dgd dgdVœfgƒdXdY„ ƒZ2dZd[„ Z3d\d]„ Z4d^d_„ Z5ej j!d`daej6fdbej7fdcej8fddej9fdeej)fdfej:fdEej(fdFej'fd@dgdh„ fdCdidh„ fdIej;fej<dje5ej=dk�gƒdldm„ ƒZ>dndo„ Z?dpdq„ Z@drds„ ZAdtdu„ ZBej j!dvdwdxgƒdydz„ ƒZCd{d|„ ZDd}d~„ ZEdd€„ ZFd�d‚„ ZGej j!dƒddd„ddd dDd„d¦ddgddddgfdd†ejHddejHejH d„d‡dejH gddddgfddej"ddej"ej"d„ejH dej"gddddgfgƒdˆd‰„ ƒZIej j!dƒdŠd‹dŒddDd„d§dd ddgddddgfejHdejH ejHdd¨ejH d„d©ejH ejH gddddgfddej"ddej"ej"d„ejH dej"gddddgfgƒd�dŽ„ ƒZJd�d�„ ZKd‘d’„ ZLd“d”„ ZMd•d–„ ZNd—d˜„ ZOd™dš„ ZPd›dœ„ ZQd�dž„ ZRej j!dŸdddddddddg	de	jSdde	jSdde	jSdg	dBœddddddgddddddgdBœgƒej j!d dadbddgƒd¡d¢„ ƒƒZTd£d¤„ ZUdS )ªé    N)ÚStringIO)ÚUnsupportedFunctionCall)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚisna)Ú_test_decoratorsznp.int32znp.int64z
np.float32z
np.float64)ÚparamsÚidsc             C   s`   | j }tj|ƒjdkr"tj|ƒjn
tj|ƒj}tj|ƒjdkrJtj|ƒjn
tj|ƒj}|||fS )z`
    Fixture of numpy dtypes with min and max values used for testing
    cummin and cummax
    Úi)ÚparamÚnpÚdtypeÚkindZiinfoÚminZfinfoÚmax)Úrequestr   Úmin_valÚmax_val© r   úF/tmp/pip-install-4cy230dp/pandas/pandas/tests/groupby/test_function.pyÚnumpy_dtypes_for_minmax   s    	((r   Ú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Úresultr   r   r   Útest_groupby_bool_aggs$   s    ""r6   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Ússr:   r<   F)Únumeric_only)r   r0   r   ÚAssertionErrorr   )Zaar5   r   r   r   Útest_max_min_non_numericG   s    &r?   c              C   s°   t jt jdddgƒdd�jj} t jtjdtjgdddg| dœƒ}|jdd	d
�d j	ƒ d }t jt jddgdd�dd�jj}t
j||ƒ |jdƒd j	ƒ }d|j_t
j||ƒ d S )Nz
2019-05-09z%Y-%m-%d)ÚformatÚ1r   r$   )r'   r(   Úcr(   F)Úas_indexrB   )r+   )ÚpdÚto_datetimer   ÚdtÚdater   r   Únanr0   r   r1   Úassert_series_equalr-   r+   )Údatesr3   r5   Úexpectedr   r   r   Útest_min_date_with_nansX   s    "rL   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   r   rH   r0   Úaggr/   ÚsumÚapplyr1   rI   )ÚsÚgroupedr5   Zresult2rK   r   r   r   Útest_intercept_builtin_sumj   s    rR   Ú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%   rU   rV   )r,   Zjolie)Zsubsetzinvalid frame shape: z (expected (z, 3))r&   TF)ÚinplaceZdrop)Zcheck_dtype)rX   r%   )rD   r   r   ÚrandomÚrandintÚrandnÚ__name__r0   rO   ÚlenZdrop_duplicatesÚshaper>   r1   r2   r.   rN   rM   Zreset_indexÚ	set_indexrI   )rT   rS   r3   Úfnamer5   ZngroupsZ
assert_msgrK   r   r   r   Útest_builtins_applyy   s    rb   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(�}xVd6D ]N}t
| jdƒ|ƒƒ }tj|j|ƒ t
| jdƒ|ƒd+d,�}tj|j|ƒ|ƒ �qW tdddddddgƒ}xRd7D ]J}t
| jdƒ|ƒƒ }tj|j|ƒ t
| jdƒ|ƒd+d,�}tj|j|ƒ �q~W tddddddddgƒ}xRd8D ]J}t
| jdƒ|ƒƒ }tj|j|ƒ t
| jdƒ|ƒd+d,�}tj|j|ƒ �qêW tdddddgƒ}| jdƒjƒ }tj|j|ƒ | jdƒjd+d,�}tj|j|ƒ tdddgƒ}xRd9D ]J}t
| jdƒ|ƒƒ }tj|j|ƒ t
| jdƒ|ƒd+d,�}tj|j|ƒ �qšW tddddddgƒ}xRd:D ]J}t
| jdƒ|ƒƒ }tj|j|ƒ t
| jdƒ|ƒd+d,�}tj|j|ƒ �qW tddddgƒ}t
| jdƒd5ƒƒ }tj|j|ƒ t
| jdƒd5ƒd+d,�}tj|j|ƒ d S );Nr$   r%   r&   g      @g      @g      @ÚabcÚcategoryé   é   é	   Z20130101)Úperiodsz
US/Eastern)rh   Útzz1 srP   )rh   Úfreq)	ÚgroupÚintÚfloatÚstringÚcategory_stringÚcategory_intÚdatetimeÚ
datetimetzÚ	timedeltark   rl   rm   rn   ro   rp   rq   rr   rs   )r,   g      @g      @z1.5sZ3sg      ø?z2013-01-01 12:00:00z2013-01-03 00:00:00)ri   )rp   rm   rs   rl   rq   rr   )r+   )r-   r,   ÚmeanÚmedianF)r=   r   r   ÚfirstÚlastÚprodÚcumprodÚcumminÚcummaxÚcumsum)rt   ru   )r   r   )rv   rw   )rx   ry   )rz   r{   )rD   r   Úlistr   Úastyper	   Ztimedelta_ranger   Z	Timedeltar   r.   r0   r1   Zassert_index_equalr,   r2   Zreindex_likerN   )r3   Zexpected_columns_numericrK   Úattrr5   Zexpected_columnsr   r   r   Útest_arg_passthru”   s¬    






r€   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)rC   r   )r,   r-   g        )r+   Úcountrt   Ústdr   z25%z50%z75%r   rf   )ÚlevelsÚcodesg      ð?g       @)r-   r,   T)r   r   rH   r0   r-   r+   Zmadr1   r2   rD   r   r   r}   ÚrangeÚdescribeÚconcatr�   ZunstackÚto_frameÚTr   Úidxmax)r3   ÚgZgnirK   r5   Z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%   rg   r&   r9   r�   r‚   rƒ   )r,   F)rC   )Úaxis)r   r   rH   r0   r|   r1   r2   ry   )r3   rK   r5   r   r   r   Útest_cython_api2[  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   rW   )Úsizeé   é   )r   r   rZ   r\   rH   Úvaluesr[   r~   rm   r0   ru   rM   ÚnanopsZ	nanmedianr1   r2   )r3   Úlabelsr5   r4   ÚrsZxpr   r   r   Útest_cython_medianr  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)ru   )Úxr   r   r   Ú<lambda>Š  s    z(test_median_empty_bins.<locals>.<lambda>)rD   r   r   rZ   r[   rˆ   Zcutr0   ru   rM   r1   r2   )rœ   r3   ZgrpsZbinsr5   rK   r   r   r   Útest_median_empty_binsƒ  s    rŸ   r   Zint8Zint16Úint32Úint64Úfloat32Úfloat64Zuint64zmethod,datarv   r3   )r'   r(   rw   r9   r   r   Únth)r3   Úargsr„   )r3   Ú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&   r9   r(   r¥   r¦   r3   r'   T)rY   )	rD   r   r(   r~   r`   r0   r.   r1   r2   )	r   ÚmethodÚdatar3   r¦   r4   Zdf_outZgrpdÚtr   r   r   Ú%test_groupby_non_arithmetic_agg_typesŽ  s    &


rª   r   z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(   rK   )rK   r¥   r%   )rv   rw   r   r   r¤   r„   r¥   r'   )rD   r   Úitemsr0   r.   Úilocr(   r>   )r   r3   Zgrp_expr§   r¨   rQ   Ú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 )Nr�   r‚   r$   r%   r&   r9   g®Gáz@g=
×£p=@gR¸…ëQ @gÍÌÌÌÌÌð?Z2019Z2018Z2016Z2017)r+   r±   r²   r³   r³   r+   )r+   )r-   )rD   r   rE   r.   r0   r   r1   r2   )Úfuncr•   r3   r5   rK   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-06rA   Ú2Úid)r+   )r-   r,   r$   r7   r%   r8   r&   é!   r9   rš   r   )Úlevelr�   Zffill)r§   )r   rD   r   Úfrom_productr	   r   r   rH   r0   ZfillnarŒ   r1   r2   )r3   rK   r5   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)ry   )r�   r   r   r   rž   $  s    z&test_groupby_cumprod.<locals>.<lambda>éd   c             S   s   | j ƒ S )N)ry   )r�   r   r   r   rž   -  s    )
rD   r   r0   ry   rO   r+   r1   rI   r~   rm   )r3   ÚactualrK   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_sem2  s    rÃ   z	op,targoprt   ru   r…   ÚvarrN   rx   c             C   s
   | j d S )Nr   )r®   )r�   r   r   r   rž   C  s    rž   c             C   s
   | j d S )Nr$   éÿÿÿÿ)r®   )r�   r   r   r   rž   D  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   rW   )r’   )r   r   rZ   r\   r[   r~   rm   r.   r0   rM   r1   r2   )ÚopZtargopr3   r—   r5   rK   r   r   r   Útest_ops_general8  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)rD   Zread_csvr   r0   r   r‹   r1   r2   r
   r   r>   )Úrawr3   ÚgbÚrÚer   r   r   Útest_max_nan_bugR  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”   re   r%   rg   r   r9   é   r¼   r'   r(   Úaaabbbrf   )r-   rw   )ÚkeepÚaaaaaÚbbbbbÚ
aaaaabbbbb)r   r}   r0   Únlargestr   Úfrom_arraysr1   rI   )r'   r(   rÊ   rË   rÌ   r   r   r   Útest_nlargest`  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¼   )rh   ZoneZtworv   Úsecond)Únamesé   )r-   r$   r   r%   r&   r9   r”   rÎ   re   rf   rg   g-rö´@g-µ`¦wý?g@Ñf¡|ë?gé‡p—¿ö?g=±J-î?g©],l;óà?g]£f˜$žê?gM8r‰ ë?gÅ«­4YØ?g¯
F;±é?Fgü©ñÒMbP?)Zcheck_exactZrtolgM8r‰ ë¿g¯
F;±é¿)r   rZ   ZRandomStater	   r   rº   r   r\   r0   rÔ   Úfrom_tuplesr1   rI   )	ZnprZdtsÚ	iterablesÚidxrP   r5   Zexp_idxZ
exp_valuesrK   r   r   r   Útest_nlargest_mi_groupert  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”   re   r%   rg   r   r9   rÎ   r¼   r'   r(   rÏ   rf   )r-   rw   )rÐ   rÑ   rÒ   rÓ   )r   r}   r0   Ú	nsmallestr   rÕ   r1   rI   )r'   r(   rÊ   rË   rÌ   r   r   r   Útest_nsmallest¡  s    

"
"rß   r´   ry   r|   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&   )r�   r‚   r�   z+numpy operations are not valid with groupby)Úmatch)r    )rD   r   r0   ÚpytestÚraisesr   r.   )r´   r3   rŽ   Úmsgr   r   r   Útest_numpy_compatµ  s    
rä   c          
   C   s<  | d }| d }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}|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|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tdgt jdgƒd�ƒ}t jt jdƒdgdd�}|jdƒd jƒ }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%   r&   r9   )r�   r‚   r‚   r�   c             S   s   | j ƒ S )N)rz   )r�   r   r   r   rž   Ò  s    ztest_cummin.<locals>.<lambda>rÎ   re   c             S   s   | j ƒ S )N)rz   )r�   r   r   r   rž   Ú  s    c             S   s   | j ƒ S )N)rz   )r�   r   r   r   rž   â  s    Ú2001)r'   r(   r(   )r-   r+   r'   )r+   )rD   r   r~   r0   rz   r1   r2   r‚   rO   r‹   Úlocr   rH   ÚdictrE   r   rI   r(   )r   r   r   Úbase_dfZexpected_minsr3   rK   r5   r   r   r   Útest_cumminÃ  s>    ,
&ré   c           	   C   s‚   t jddddddddgtjgd dœƒ} t jdtjgd iƒ}| jdƒjƒ }tj||ƒ | jdƒjj	dd„ ƒj
ƒ }tj||ƒ d S )	Nr$   r%   rf   )r�   r‚   r‚   r�   c             S   s   | j ƒ S )N)rz   )r�   r   r   r   rž   ù  s    z,test_cummin_all_nan_column.<locals>.<lambda>)rD   r   r   rH   r0   rz   r1   r2   r‚   rO   r‹   )rè   rK   r5   r   r   r   Útest_cummin_all_nan_columnó  s    (rê   c          
   C   s<  | d }| d }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}|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|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tdgt jdgƒd�ƒ}t jt jdƒdgdd�}|jdƒd jƒ }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$   r&   r9   )r�   r‚   r‚   r�   c             S   s   | j ƒ S )N)r{   )r�   r   r   r   rž     s    ztest_cummax.<locals>.<lambda>rÎ   re   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'   r(   r(   )r-   r+   r'   )r+   )rD   r   r~   r0   r{   r1   r2   r‚   rO   r‹   ræ   r   rH   rç   rE   r   rI   r(   )r   r   r   rè   Zexpected_maxsr3   rK   r5   r   r   r   Útest_cummaxý  s>    ,
&rë   c           	   C   s‚   t jddddddddgtjgd dœƒ} t jdtjgd iƒ}| jdƒjƒ }tj||ƒ | jdƒjj	dd„ ƒj
ƒ }tj||ƒ d S )	Nr$   r%   rf   )r�   r‚   r‚   r�   c             S   s   | j ƒ S )N)r{   )r�   r   r   r   rž   3  s    z,test_cummax_all_nan_column.<locals>.<lambda>)rD   r   r   rH   r0   r{   r1   r2   r‚   rO   r‹   )rè   rK   r5   r   r   r   Útest_cummax_all_nan_column-  s    (rì   zin_vals, out_valsr”   rÎ   gÍÌÌÌÌÌ @r7   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 )NrA   r¶   Ú3Ú4Ú5Ú6Ú7Ú8Ú9Ú10Ú11r'   r(   rB   Úd)r�   r‚   rƒ   r‚   Úabcd)r+   rƒ   )r-   r¨   r+   c             S   s   | j S )N)Úis_monotonic_increasing)r�   r   r   r   rž   W  s    z.test_is_monotonic_increasing.<locals>.<lambda>)rD   r   r0   rƒ   rø   r   r}   r   r1   rI   rO   )Úin_valsÚout_valsÚsource_dictr3   r5   r-   rK   r   r   r   Útest_is_monotonic_increasing7  s    
rü   r¼   rg   re   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 )NrA   r¶   rí   rî   rï   rð   rñ   rò   ró   rô   rõ   r'   r(   rB   rö   )r�   r‚   rƒ   r‚   r÷   )r+   rƒ   )r-   r¨   r+   )
rD   r   r0   rƒ   Zis_monotonic_decreasingr   r}   r   r1   rI   )rù   rú   rû   r3   r5   r-   rK   r   r   r   Útest_is_monotonic_decreasing[  s    
rý   c             C   s   | j dd�}|jƒ  d S )Nrv   )r¹   )r0   r‰   )ZmframerQ   r   r   r   Útest_apply_describe_bug€  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ž   ‡  s    z/test_series_describe_multikey.<locals>.<lambda>c             S   s   | j S )N)Úmonth)r�   r   r   r   rž   ‡  s    rt   F)Zcheck_namesr…   r   )r1   ÚmakeTimeSeriesr0   r‰   rI   rt   r…   r   )ÚtsrQ   r5   r   r   r   Útest_series_describe_multikey…  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ž   �  s    z-test_series_describe_single.<locals>.<lambda>c             S   s   | j ƒ S )N)r‰   )r�   r   r   r   rž   ‘  s    )r1   r  r0   rO   r‰   ÚstackrI   )r  rQ   r5   rK   r   r   r   Útest_series_describe_singleŽ  s
    r  c             C   s@   | j d d …dgf j| d ƒ}|jdd„ ƒ}|jjdks<t‚d S )Nrƒ   r�   c             S   s   | j ƒ S )N)rt   )r�   r   r   r   rž   ˜  s    z(test_series_index_name.<locals>.<lambda>)ræ   r0   rM   r-   r+   r>   )r3   rQ   r5   r   r   r   Útest_series_index_name–  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�   )r�   r‚   rƒ   ÚD)r0   r‰   rD   r   r,   r^   rˆ   r   r•   r-   ÚappendrŠ   r1   r2   rŒ   )	ZtsframerQ   r5   Zdesc_groupsÚcolrk   Z	group_colrK   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&   r9   r”   r¼   rÙ   é   é(   rW   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â   Ú
ValueErrorr0   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)ri   iža  z2011-01-06 12:43:33i›c  z2011-01-06 12:54:09i /hYl    rT i áõ)ÚPRICEÚVOLUMEr  )r+   r„   rt   r…   r   z25%z50%z75%r   )r-   r,   )rD   r   r   r0   r  r‰   r  r•   Útolistr   r1   r2   )ZpricesZvolumesr3   r5   r¨   rK   r   r   r   Ú$test_frame_describe_unstacked_formatÉ  s    r  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 )Nr�   ij  i�  io  i`  l    @Ü~ÿÿ )ÚuserÚconnectionsr  r  l    ,fÌL™ )rD   r   r0   rt   r>   )r3   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-   ÚInt64)r   Úarrayrm   rD   r   Úobjectr   r0   r.   r1   r2   rM   r   rÚ   r,   )r•   r  ÚoutputZarrrÜ   rK   Úgroupsr5   r   r   r   Ú,test_apply_to_nullable_integer_returns_floatî  s    
r!  c              C   sÀ   t jdddgdddgdddgdœdd�} | jdƒ}t jdddgtdd�}|d	 jdd
�}t jt jgd d|d	d�}tj	||ƒ |jdd
�}t jt jgd t jgd dœd|d�}tj
||ƒ d S )Nr   r$   r%   )r'   r(   rB   r  )r   r'   )r   r+   r(   )Z	min_countr&   )r   r-   r+   )r(   rB   )r   r-   )rD   r   r0   r   r  rN   r   ÚNAr1   rI   r2   )r3   rQ   rÜ   r5   rK   r   r   r   Ú0test_groupby_sum_below_mincount_nullable_integer  s    (
"r#  )r«   r¬   iúÿÿÿéýÿÿÿr$  r$  )Vr/   Úior   Znumpyr   rá   Zpandas.errorsr   ZpandasrD   r   r   r   r   r   r	   r
   Zpandas._testingZ_testingr1   Zpandas.core.nanopsÚcorer–   Zpandas.utilr   ÚtdZfixturer    r¡   r¢   r£   r   ÚmarkZparametrizerH   r6   r?   rL   rR   r   r   rN   rb   r€   r�   r‘   r™   rŸ   rª   r°   rµ   r»   rÀ   rÃ   rt   ru   r…   rÄ   rx   r’   r   Zskip_if_no_scipyrÇ   rÍ   rÖ   rÝ   rß   rä   ré   rê   rë   rì   Úinfrü   rý   rþ   r  r  r  r
  r  r  r  r"  r!  r#  r   r   r   r   Ú<module>   sä   $
   	?,(-

-0
0
$$$$,$	$