3
Êb_'­  ã               @   sÐ   d dl mZ d dlmZ d dlZd dlZd dlZd dlj	j
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mZ d dljZd dljjZd dljjZddd„Z dd	d
„Z!ddd„Z"ddd„Z#G dd„ dƒZ$dS )é    )Ú	timedelta)ÚDecimalN)
ÚCategoricalÚ	DataFrameÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚisnaÚnotnaÚto_datetimeÚto_timedeltaTFc                s  t || ƒ}|rrtdtddd�iƒ}	t |	| ƒƒ }
t|
tƒs<t‚tt|	ƒƒ|	d< t |	| ƒƒ }
t|
tƒsft‚t|
ƒsrt‚|rÜ‡ fdd„}tj	ˆ |ƒ}|dd	d
�}|dd	d
�}tj
||j|ƒ||d� tj
||j|dd�d	|d� nˆ }|dd�}|dd�}tj
||j|ƒ||d� | dk�r6|j|dd�}tj
||d	|d� |�rd|jj}||jk�sTt‚||jk�sdt‚tjtdd�� |dd� W dQ R X |�r|tj }t || ƒdd�}t || ƒdd�}| dk�r| dk�rÐdnd}tj||j|jd�}tj
||ƒ tj||j|jd�}tj
||ƒ dS )a¿  
    Check that operator opname works as advertised on frame

    Parameters
    ----------
    opname : string
        Name of the operator to test on frame
    alternative : function
        Function that opname is tested against; i.e. "frame.opname()" should
        equal "alternative(frame)".
    frame : DataFrame
        The object that the tests are executed on
    has_skipna : bool, default True
        Whether the method "opname" has the kwarg "skip_na"
    check_dtype : bool, default True
        Whether the dtypes of the result of "frame.opname()" and
        "alternative(frame)" should be checked.
    check_dates : bool, default false
        Whether opname should be tested on a Datetime Series
    check_less_precise : bool, default False
        Whether results should only be compared approximately;
        passed on to tm.assert_series_equal
    skipna_alternative : function, default None
        NaN-safe version of alternative
    Úbz1/1/2001é   )ÚperiodsÚac                s
   ˆ | j ƒS )N)Úvalues)Úx)Úalternative© úC/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/frame/test_analytics.pyÚwrapperN   s    z$assert_stat_op_calc.<locals>.wrapperr   F)ÚaxisÚskipnaé   )Úcheck_dtypeÚcheck_less_precise)r   ÚsumÚprodzNo axis named 2)ÚmatchN)ÚindexÚdtype)r   r   )r   r   )Úgetattrr   r	   Ú
isinstancer   ÚAssertionErrorÚrangeÚlenÚtmZ_make_skipna_wrapperÚassert_series_equalÚapplyr   r!   ÚpytestÚraisesÚ
ValueErrorÚnpÚNaNÚpdr    )Úopnamer   ÚframeÚ
has_skipnar   Úcheck_datesr   Úskipna_alternativeÚfÚdfÚresultr   Úskipna_wrapperÚresult0Úresult1ÚexpectedZ	lcd_dtypeÚall_naÚr0Úr1Úunitr   )r   r   Úassert_stat_op_calc   sh    $






r@   c             C   sp   t || ƒdd� t || ƒdd� |rlt || ƒddd� t || ƒddd� t || ƒddd� t || ƒddd� dS )a·  
    Check that API for operator opname works as advertised on frame

    Parameters
    ----------
    opname : string
        Name of the operator to test on frame
    float_frame : DataFrame
        DataFrame with columns of type float
    float_string_frame : DataFrame
        DataFrame with both float and string columns
    has_numeric_only : bool, default False
        Whether the method "opname" has the kwarg "numeric_only"
    r   )r   r   T)r   Únumeric_onlyFN)r"   )r0   Úfloat_frameÚfloat_string_frameÚhas_numeric_onlyr   r   r   Úassert_stat_op_apiŠ   s    rE   c          
      sT  t || ƒ}|rl‡ fdd„}‡ fdd„}|ddd�}|ddd�}tj||j|ƒƒ tj||j|dd	�dd
� nˆ }ˆ }|dd	�}|dd	�}tj||j|ƒƒ tj||j|dd	�dd
� tjtdd�� |dd	� W dQ R X |�rP|tj }	t |	| ƒdd	�}
t |	| ƒdd	�}| dk�r4|
j	ƒ  �s"t
‚|j	ƒ  �sPt
‚n|
jƒ �sBt
‚|jƒ �sPt
‚dS )aÛ  
    Check that bool operator opname works as advertised on frame

    Parameters
    ----------
    opname : string
        Name of the operator to test on frame
    alternative : function
        Function that opname is tested against; i.e. "frame.opname()" should
        equal "alternative(frame)".
    frame : DataFrame
        The object that the tests are executed on
    has_skipna : bool, default True
        Whether the method "opname" has the kwarg "skip_na"
    c                s   | j ƒ j}ˆ |ƒS )N)Údropnar   )r   Znona)r   r   r   r8   º   s    
z+assert_bool_op_calc.<locals>.skipna_wrapperc                s
   ˆ | j ƒS )N)r   )r   )r   r   r   r   ¾   s    z$assert_bool_op_calc.<locals>.wrapperr   F)r   r   r   )r   )r   zNo axis named 2)r   r   NÚany)r"   r'   r(   r)   r*   r+   r,   r-   r.   rG   r$   Úall)r0   r   r1   r2   r5   r8   r   r9   r:   r<   r=   r>   r   )r   r   Úassert_bool_op_calc¥   s6    




rI   c             C   sŒ   |}t jjt|ƒƒdk|d< t|| ƒdd� t|| ƒdd� |rˆt|| ƒddd� t|| ƒddd� t|| ƒddd� t|| ƒddd� d	S )
a¹  
    Check that API for boolean operator opname works as advertised on frame

    Parameters
    ----------
    opname : string
        Name of the operator to test on frame
    float_frame : DataFrame
        DataFrame with columns of type float
    float_string_frame : DataFrame
        DataFrame with both float and string columns
    has_bool_only : bool, default False
        Whether the method "opname" has the kwarg "bool_only"
    g      à?Z_bool_r   )r   r   T)r   Ú	bool_onlyFN)r-   ÚrandomÚrandnr&   r"   )r0   Úbool_frame_with_narC   Úhas_bool_onlyÚmixedr   r   r   Úassert_bool_op_apiå   s    rP   c            '   @   s  e Zd Zdd„ Zdd„ Zejjdƒdd„ ƒZejj	dd	d
ddddddgƒdd„ ƒZ
ejj	dd
dddddgƒdd„ ƒZdd„ Zdd„ Zejj	dddgƒdd „ ƒZejj	dddgƒd!d"„ ƒZd#d$„ Zd%d&„ Zejj	d'dddgƒd(d)„ ƒZd*d+„ Zejd,d-„ ƒZejj	d.d/d0gd1gd2gd3ged3gd3gd4�ed5gƒed6gƒd7œfd8d0gd1gejgejejged9�eejgd3gd4�ejgeejgƒd7œfd/d:d;ejejgd:d;ejejgd<ejejejged3ejejejgd3gd4�ed5d=d=d=gƒed6d>d>d>gƒd?d<d@dAgdBœfd8d:d;ejejgd:d;ejejgd<ejejejgeejd3ejejgd3gd4�ed=d5d=d=gƒed>d6d>d>gƒd?d<d@dAgdBœfgƒdCdD„ ƒZ dEdF„ Z!dGdH„ Z"dIdJ„ Z#ejj	dKd‹dŒgƒdLdM„ ƒZ$dNdO„ Z%dPdQ„ Z&dRdS„ Z'dTdU„ Z(dVdW„ Z)dXdY„ Z*ejj+dZe,d/d[�d\d]„ ƒZ-d^d_„ Z.d`da„ Z/dbdc„ Z0ddde„ Z1dfdg„ Z2ejj	dhdidjgƒdkdl„ ƒZ3dmdn„ Z4dodp„ Z5dqdr„ Z6ejj	dsej7i d8fej8i d/fej7dtg id8fej8dtg id/fej7dtd8d8gid8fej8dtd8d8gid8fej7dtd/d8gid/fej8dtd/d8gid8fej7dtd/d/gid/fej8dtd/d/gid/fej7d8gd8gduœd8fej8d8gd8gduœd8fej7d8d8gd8d/gduœd/fej8d8d8gd8d/gduœd8fej8dtej9dvd2gdwd9�id8fej7dtej9dvd2gdwd9�id/fej8dtej9d?d<ge:d9�id8fej7dtej9d?d<ge:d9�id/fej;ej8dtej9d?d<gdxd9�id8ej<dyƒgdz�ej;ej7dtej9d?d<gdxd9�id/ej<dyƒgdz�ej;ej8dtej9d<d@gdxd9�id/ej<dyƒgdz�ej;ej7dtej9d<d@gdxd9�id/ej<dyƒgdz�ej;ej8dtej9d?d<gd{d9�id8ej<dyƒgdz�ej;ej7dtej9d?d<gd{d9�id/ej<dyƒgdz�ej;ej8dtej9d<d@gd{d9�id/ej<dyƒgdz�ej;ej7dtej9d<d@gd{d9�id/ej<dyƒgdz�ej8dtej9d?d<gd|d9�id8fej7dtej9d?d<gd|d9�id/fej8dtej9d<d@gd|d9�id/fej7dtej9d<d@gd|d9�id/fej;ej8ej9d}d~gdxd9�ej9d}d~gd{d9�duœd/ej<dyƒgdz�gƒdd€„ ƒZ=d�d‚„ Z>ejj	ddidjgƒdƒd„„ ƒZ?d…d†„ Z@d‡dˆ„ ZAd‰dŠ„ ZBdS )�ÚTestDataFrameAnalyticsc             C   sê   t d||dd� t d||dd� t d||ƒ t d||ƒ t d||ƒ t d||ƒ t d	||ƒ t d
||ƒ t d||ƒ t d||ƒ t d||ƒ t d||ƒ t d||ƒ y,ddlm}m} t d||ƒ t d||ƒ W n tk
rä   Y nX d S )NÚcountT)rD   r   ÚnuniqueÚmeanÚproductÚmedianÚminÚmaxÚmadÚvarÚstdÚsemr   )ÚskewÚkurtosisr]   Úkurt)rE   Úscipy.statsr]   r^   ÚImportError)ÚselfrB   rC   r]   r^   r   r   r   Útest_stat_op_api  s*    z'TestDataFrameAnalytics.test_stat_op_apic             C   s.  dd„ }dd„ }dd„ }dd„ }d	d
„ }dd„ }dd„ }	dd„ }
t d||dddd� t dtj|jdƒddd� t dtj|tjd� t dtj|dd� t dtj|ƒ t d||ƒ t d||ƒ t d||ƒ t d||ƒ t d ||dddd� y,d!d"lm}m	} t d#|	|ƒ t d$|
|ƒ W n t
k
�r(   Y nX d S )%Nc             S   s   t | ƒjƒ S )N)r   r   )Úsr   r   r   rR   %  s    z7TestDataFrameAnalytics.test_stat_op_calc.<locals>.countc             S   s   t tj| jƒ ƒƒS )N)r&   Ú
algorithmsZunique1drF   )rd   r   r   r   rS   (  s    z9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nuniquec             S   s   t j| | jƒ  ƒjƒ S )N)r-   ÚabsrT   )r   r   r   r   rY   +  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.madc             S   s   t j| dd�S )Nr   )Úddof)r-   rZ   )r   r   r   r   rZ   .  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.varc             S   s   t j| dd�S )Nr   )rg   )r-   r[   )r   r   r   r   r[   1  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.stdc             S   s   t j| dd�t jt| ƒƒ S )Nr   )rg   )r-   r[   Úsqrtr&   )r   r   r   r   r\   4  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.semc             S   s*   ddl m} t| ƒdk rtjS || dd�S )Nr   )r]   é   F)Úbias)r`   r]   r&   r-   Únan)r   r]   r   r   r   Úskewness7  s    z:TestDataFrameAnalytics.test_stat_op_calc.<locals>.skewnessc             S   s*   ddl m} t| ƒdk rtjS || dd�S )Nr   )r^   é   F)rj   )r`   r^   r&   r-   rk   )r   r^   r   r   r   r_   >  s    z6TestDataFrameAnalytics.test_stat_op_calc.<locals>.kurtrS   FT)r2   r   r3   r   Zfloat32)r   r   )r4   rT   )r3   rU   rY   rZ   r[   r\   rR   r   )r]   r^   r]   r_   )r@   r-   r   ÚastypeZnansumrT   r   Zscipyr]   r^   ra   )rb   Úfloat_frame_with_naZmixed_float_framerR   rS   rY   rZ   r[   r\   rl   r_   r]   r^   r   r   r   Útest_stat_op_calc$  sT    z(TestDataFrameAnalytics.test_stat_op_calczignore:All-NaN:RuntimeWarningc             C   s.   dd„ }t d||dd� t d||ddd� d S )Nc             S   s   t | ƒjƒ rtjS tj| ƒS )N)r
   rG   r-   rk   rV   )r   r   r   r   r   v  s    z3TestDataFrameAnalytics.test_median.<locals>.wrapperrV   T)r3   F)r   r3   )r@   )rb   ro   Ú	int_framer   r   r   r   Útest_mediant  s    z"TestDataFrameAnalytics.test_medianÚmethodr   rT   r   rZ   r[   r]   rW   rX   c             C   s¶   dddgdddgdddgd	œ}t |d
ddgdd�}t tjdgtjdgtjdgdœtd�}xX||gD ]L}|jjtjksxt‚t||ƒdƒ}t|j	dƒ|ƒdƒ}|dkrbt
j||ƒ qbW d S )NgÈƒw@Ba@?gCùVÞúZ?g
?ZÁ½.F?r   g        gê94­³c4?gÏ@ð}�jX?gþïœÕN?)r   r   ÚcÚfooÚbarÚbazÚO)r    r!   r   ri   rm   )r   r   r   )r!   r   Zf8r   r   gÈƒw@Ba@¿gCùVÞúZ¿r   r   gþïœÕN¿)r   r   )r   r-   rk   Úobjectr   r!   Zobject_r$   r"   rn   r'   r(   )rb   rs   ÚdataÚdf1Údf2r6   r7   r;   r   r   r   Ú%test_stat_operators_attempt_obj_array€  s    
&z<TestDataFrameAnalytics.test_stat_operators_attempt_obj_arrayÚopr_   r\   c          
   C   s|   t ddddgddddgd	d
ddgdœƒ}t||ƒƒ }t|ƒdksDt‚tjddƒ�" t||ƒƒ }t|ƒdksnt‚W d Q R X d S )Nr   r   ri   rm   g      ð?g       @g      @g      @r   r   rt   Úd)ÚintÚfloatÚstrÚuse_bottleneckF)r   r"   r&   r$   r/   Úoption_context)rb   r~   r6   r7   r   r   r   Útest_mixed_opsž  s    

z%TestDataFrameAnalytics.test_mixed_opsc             C   s„   t dddddgdddddgdd	d
ddgdœƒ}|jdddgd� |jdd�}tj|jtjdddgtd�ƒ tj	||j
jdd�ƒ d S )NTFé
   é   é   é(   é2   r   r   rt   r   Úe)Ú	bool_dataÚint_dataÚstring_datarŒ   r�   rŽ   )Úcolumnsr   )r   r   é–   Zabcde)r!   r   )r   Úreindexr   r'   Zassert_numpy_array_equalr   r-   Úarrayry   r(   ÚT)rb   r6   Útestr   r   r   Útest_reduce_mixed_frame°  s    z.TestDataFrameAnalytics.test_reduce_mixed_framec             C   s¦   t dddgdddgdtjdgdœƒ}tj|jƒ tddddœƒƒ tj|jdd�tddddœƒƒ tj|jdd�tddddœƒƒ tj|jddd	�tddddœƒƒ d S )
Nr   r   ri   )ÚAÚBÚCF)rF   )r   )r   r   r   )r   rF   )r   r-   rk   r'   r(   rS   r   )rb   r6   r   r   r   Útest_nuniqueÀ  s    $ z#TestDataFrameAnalytics.test_nuniqueÚtzNÚUTCc             C   sN   t jddgt jd|d�gd dœƒ}|jƒ }t jdgdgd�}tj||ƒ d S )	Nr   Ú2000)rš   r   )r–   r—   g      ð?r–   )r    )r/   r   r   rT   r   r'   r(   )rb   rš   r6   r7   r;   r   r   r   Ú test_mean_mixed_datetime_numericË  s    $z7TestDataFrameAnalytics.test_mean_mixed_datetime_numericc             C   sD   t jdt jd|d�gd iƒ}|jƒ }t jtjd�}tj||ƒ d S )Nr–   rœ   )rš   r   )r!   )	r/   r   r   rT   r   r-   Úfloat64r'   r(   )rb   rš   r6   r7   r;   r   r   r   Útest_mean_excludes_datetimesÓ  s    z3TestDataFrameAnalytics.test_mean_excludes_datetimesc             C   sÈ   dd t dƒdœdd t dƒdœdd t dƒdœdd t dƒdœd	d t d
ƒdœddt dƒdœdd t dƒdœd	d t dƒdœdd t dƒdœdd t dƒdœg
}tj|ƒ}|jƒ }tjddgddgd�}tj||ƒ d S )Nr   z628.00)r–   r—   r˜   r   z383.00ri   z651.00z575.00rm   z1114.00ZTESTz241.00z572.00z609.00z820.00é   z1223.00gš™™™™™@gÍÌÌÌÌL…@r–   r˜   )r    )r   r/   r   rT   r   r'   r(   )rb   r   r6   r7   r;   r   r   r   Útest_mean_mixed_string_decimalÝ  s    
z5TestDataFrameAnalytics.test_mean_mixed_string_decimalc             C   s¾   |j dd�}|jdd„ ƒ}tj||ƒ |jdd�}|jdd„ ƒ}tj||ƒ tjtjjdƒddƒ}tj	|dd	�}|dk j
ƒ  s‚t‚tjd
dƒ�& tj	|dd	�}|dk j
ƒ  s°t‚W d Q R X d S )Nrm   )rg   c             S   s   | j dd�S )Nrm   )rg   )r[   )r   r   r   r   Ú<lambda>ö  s    z5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>c             S   s   | j dd�S )Nrm   )rg   )rZ   )r   r   r   r   r¢   ú  s    r   éè  r   )r   rƒ   F)r   r£   )r[   r)   r'   Úassert_almost_equalrZ   r-   ÚrepeatrK   ÚnanopsZnanvarrG   r$   r/   r„   )rb   Údatetime_framer7   r;   Úarrr   r   r   Útest_var_stdô  s    z#TestDataFrameAnalytics.test_var_stdÚmethc             C   s  t tjjddƒdddgd�}d|jd< t tjjddƒdddgd�}d	|jd< t||ƒd
dd�}t|ddg |ƒd
d�}tj||ƒ t||ƒd
dd�}t|ddg |ƒd
d�}tj||ƒ d}tj	t
|d�� t||ƒd
dd� W d Q R X d}tj	t
|d�� t||ƒd
dd� W d Q R X d S )Nr    ri   ru   rv   rw   )r�   Z100r   r   r   T)r   rA   )r   z6unsupported operand type\(s\) for -: 'float' and 'str')r   Fz&could not convert string to float: 'a')r   ru   )r   ru   )r   r-   rK   rL   Úlocr"   r'   r(   r*   r+   Ú	TypeError)rb   rª   r{   r|   r7   r;   Úmsgr   r   r   Útest_numeric_only_flag  s     

z-TestDataFrameAnalytics.test_numeric_only_flagc             C   s˜   |j dd�}|jdd„ ƒ}tj||ƒ tjtjjdƒddƒ}tj|dd�}|dk j	ƒ  s\t
‚tjd	d
ƒ�& tj|dd�}|dk j	ƒ  sŠt
‚W d Q R X d S )Nrm   )rg   c             S   s   | j dd�tjt| ƒƒ S )Nrm   )rg   )r[   r-   rh   r&   )r   r   r   r   r¢   "  s    z1TestDataFrameAnalytics.test_sem.<locals>.<lambda>r   éè  r   )r   rƒ   F)r   r¯   )r\   r)   r'   r¤   r-   r¥   rK   r¦   ZnansemrG   r$   r/   r„   )rb   r§   r7   r;   r¨   r   r   r   Útest_sem   s    zTestDataFrameAnalytics.test_semc          
   C   s¨   t dgdddgddggddddddgddddddgddddddggd�}ttjjd	d
ƒ|d�}|jƒ }|jdd�jdƒ}tj||dd� |j	d ks–t
‚|j	dks¤t
‚d S )Nrv   ÚoneÚtwoZthreer   r   r   )ZlevelsÚcodesé   ri   )r    )ÚlevelF)Úcheck_names)r   r   r-   rK   rL   r_   Úxsr'   r(   Únamer$   )rb   r    r6   r_   Zkurt2r   r   r   Ú	test_kurt-  s    2z TestDataFrameAnalytics.test_kurtzdropna, expectedTé   g      $@g      ð?r   )Ú
categoriesz2000-1-2z1 days)r–   r—   r˜   ÚDÚEÚFÚGF)r!   é   é	   r   ÚNaTrk   r   r   ri   )ÚHÚIÚJÚKÚLÚMÚNc             C   sü   t ddddgddtjdgdtjtjtjgtjtjdtjgttjtjdtjgƒtdd	ddgƒtd
dddgƒddddgddddgddtjtjgtdtjdtjgƒtd	d	ddgƒtd
dd
dgƒtjddd�dœƒ}|t|jƒ ƒ j	|d�}t |ƒ}t
j||ƒ d S )Nrº   é   é   r†   ri   r   r   rÂ   z2000-1-2z1 daysrk   rÀ   rÁ   rm   Zint64)r!   )r–   r—   r˜   r¼   r½   r¾   r¿   rÃ   rÄ   rÅ   rÆ   rÇ   rÈ   rÉ   )rF   )r   r-   rk   r   r   r   ÚarangeÚsortedÚkeysÚmoder'   Úassert_frame_equal)rb   rF   r;   r6   r7   r   r   r   Útest_mode_dropna;  s$    7


z'TestDataFrameAnalytics.test_mode_dropnac          
   C   st   t dtjtjddgiƒ}t ddtjgiƒ}tjtdd��& |jdd�}|jdd�jdd�}W d Q R X tj	||ƒ d S )	Nr–   r   F)Zcheck_stacklevel)rF   )ZbyT)Zdrop)
r   r-   rk   r'   Úassert_produces_warningÚUserWarningrÏ   Zsort_valuesZreset_indexrÐ   )rb   r6   r;   r7   r   r   r   Útest_mode_sortwarning‰  s    z,TestDataFrameAnalytics.test_mode_sortwarningc          	   C   sü  t ttdddd�tdddd�tdƒtddd� d	�ƒ}t t|d
 |d  |d
 |d  d�ƒ}|jƒ }|d |jd$ ks|t‚|d |jd% ks’t‚|jdd�}||jd& kjƒ s´t‚|j	ƒ }|d |jd' ksÒt‚|d |jd( ksèt‚|j	dd�}||d
 kjƒ �s
t‚|j
ƒ }t
|ƒ}t t|d
 |d  |d |d
  d�ƒ}tj||ƒ tj||ƒ |jƒ }d|d< d|d< d|d< tdƒ|d< |jƒ }ttjtd*d�ƒtjtd+d�ƒdddtdƒg|jd�}tj||ƒ |jdd�}tdddgdddgd�}tj||ƒ |d
dg jdƒ}ttd,d�gd ƒ}tj||ƒ |d
dg jƒ }ttd.d�td/d�gd
dgd�}tj||ƒ t tddd�tddd�dœƒ}|d |d   |d!< |d! jd"k�s´t‚|d  |d  |d#< |jƒ  |d! jd"k�sät‚|d# jd"k�søt‚d S )0Nz2012-1-1ri   r¼   )r   Úfreqz2012-1-2Z20120101r    )ÚminutesÚseconds)r–   r—   r˜   r–   r˜   r—   )r–   r—   r   r   )r   r   ru   g      ð?r½   Z20130101r¾   é<   )r×   )Údays)r    Z20130102)r   Z20130105)ÚtimeÚtime2rÛ   rÚ   Zoff1ztimedelta64[ns]Zoff2)r   r–   )r   r—   )r   r—   )r   r–   )r   r—   i,  i1  éÿÿÿÿrÜ   i,  i1  rÜ   )r   Údictr	   r   r   rW   r«   r$   rH   rX   rf   r'   rÐ   Úcopyr   r/   Z	Timedeltar�   r(   r!   Z_consolidate_inplace)rb   r6   Zdiffsr7   Zresult2r;   rO   r   r   r   Útest_operators_timedelta64–  sn    ((

z1TestDataFrameAnalytics.test_operators_timedelta64c             C   sZ   t ƒ }|jdƒ}|jdƒ}t|tƒs(t‚t|tƒs6t‚t|ƒdksFt‚t|ƒdksVt‚d S )Nr   r   )r   r   r#   r   r$   r&   )rb   Zempty_frameZaxis0Zaxis1r   r   r   Útest_sum_cornerí  s    

z&TestDataFrameAnalytics.test_sum_cornerzmethod, unitc             C   sx  dddg}t j||g|tjgtjtjgdœƒ}t||ƒ}t j|||g|dd�}t||ƒdd�}t j||tjg|d	�}tj||ƒ t||ƒd
d�}t j|||g|dd�}tj||ƒ t|jdd … |ƒdd�}t j|tjtjg|d	�}tj||ƒ t j|gd |gd tjgd  dœƒ}t||ƒdd�}t j|ddgd	�}tj||ƒ t||ƒdd�}t j|ddgd	�}tj||ƒ d S )Nr   r   rt   )r   r   rt   rž   )r    r!   r   )Ú	min_count)r    r   r†   r    )r–   r—   r–   r—   r´   )	r/   r   r-   rk   r"   r   r'   r(   Úiloc)rb   rs   r?   Úidxr6   r7   r;   r   r   r   Útest_sum_prod_nanops÷  s*    
 
(z+TestDataFrameAnalytics.test_sum_prod_nanopsc             C   s°   dddg}t jddgdtjgtjtjgdœƒ}|jt jƒ}|jƒ }t jdddgd|d�}tj	||ƒ |jdd�}tj	||ƒ |jd	d�}t jddtjgd|d�}tj	||ƒ d S )
Nr   r   rt   r   )r   r   rt   zm8[ns])r!   r    )rá   r   )
r/   r   r-   rk   r)   r   r   r   r'   r(   )rb   rã   r6   r|   r7   r;   r   r   r   Útest_sum_nanops_timedelta  s    
$z0TestDataFrameAnalytics.test_sum_nanops_timedeltac             C   s6   |j jtƒ}t||j|jd�}|tdƒ }|jƒ  d S )N)r    r�   r   )r   rn   r€   r   r    r�   r   r   )rb   rB   r   r1   Zdeltasr   r   r   Útest_sum_object.  s    z&TestDataFrameAnalytics.test_sum_objectc             C   s"   t j|ƒ}|jdƒ |jdƒ d S )Nr   r   )r-   Úisnanr   )rb   rB   Úboolsr   r   r   Útest_sum_bool4  s    

z$TestDataFrameAnalytics.test_sum_boolc             C   sT   t jt jddd�ddddgdœƒjdddgƒ}|jƒ }t jdd	iƒ}tj||ƒ d S )
Nrœ   rm   )r   r   r   ri   )r–   r—   r—   g      @)r/   r   r	   r‘   r   r   r'   r(   )rb   r6   r7   r;   r   r   r   Útest_sum_mixed_datetime:  s    z.TestDataFrameAnalytics.test_sum_mixed_datetimec             C   s¤   |j dd�}|jddd�}tj|j|jƒ t|jƒt|jƒk sBt‚|j dd�}|jddd�}tj|j|jƒ |d dk|d< |j dƒ}|d |d jj ƒ ks t‚d S )Nr   )r   T)r   rA   r   r–   Úbool)	rT   r   r'   Zassert_index_equalr    r&   r�   r$   r   )rb   rB   rC   Zthe_meanZthe_sumZmeansr   r   r   Útest_mean_cornerD  s    
z'TestDataFrameAnalytics.test_mean_cornerc          	   C   sŽ   t jtjdƒt jddd�t jddd�t jdddd�dœƒ}|jd	d
�}t jddiƒ}t	j
||ƒ |jƒ }t jd|jd dœƒ}t	j
||ƒ d S )Nri   z
2016-01-01)r   Ú1DÚ2016r–   )r   rÕ   )r–   r—   r˜   r¼   T)rA   g      ð?r   r˜   )r–   r˜   )r   r˜   )r/   r   r-   rÌ   r	   Útimedelta_rangeÚperiod_rangerT   r   r'   r(   r«   )rb   r6   r7   r;   r   r   r   Útest_mean_datetimelikeU  s    z-TestDataFrameAnalytics.test_mean_datetimelikez6casts to object-dtype and then tries to add timestamps)Úreasonr+   Ústrictc          
   C   s¶   t jtjdƒt jddd�t jddd�t jdddd�dœƒ}|jd	d
�}t jd|j	d |j	d |j	d dœƒ}t
j||ƒ t jdddd�|d< tjtdd�� |jd	d
� W d Q R X d S )Nri   z
2016-01-01)r   rí   rî   r–   )r   rÕ   )r–   r—   r˜   r¼   F)rA   r   r—   r˜   r¼   z"mean is not implemented for Period)r   )r   r—   )r   r˜   )r   r¼   )r/   r   r-   rÌ   r	   rï   rð   rT   r   r«   r'   r(   r*   r+   r¬   )rb   r6   r7   r;   r   r   r   Ú)test_mean_datetimelike_numeric_only_falsei  s    "z@TestDataFrameAnalytics.test_mean_datetimelike_numeric_only_falsec             C   sH   t jjdd	d�}tj|dd�}|jdd�}tj|ƒjƒ }tj||ƒ d S )
Niè  r†   r    )ÚsizeZInt64)r!   T)rA   )r†   r    )r-   rK   Úrandintr/   r   rT   r'   r(   )rb   r¨   r6   r7   r;   r   r   r   Ú*test_mean_extensionarray_numeric_only_true„  s
    zATestDataFrameAnalytics.test_mean_extensionarray_numeric_only_truec             C   s,   |j dƒ |jdƒ |jdƒ |jdƒ d S )Nr   )r[   rZ   rT   r]   )rb   rC   r   r   r   Útest_stats_mixed_typeŒ  s    


z,TestDataFrameAnalytics.test_stats_mixed_typec             C   s8   t tdƒtdƒd�}t|ƒ}|jdd�d dks4t‚d S )Nr   r†   )r    r�   )r   r   )r   r%   r
   r   r$   )rb   r6   rè   r   r   r   Útest_sum_bools“  s    z%TestDataFrameAnalytics.test_sum_boolsc       
   
   C   s´   |}t j|jdd…< t j|jdd…dd …f< xXdD ]P}xJdD ]B}x<||gD ]0}|j||d
�}|jtj||d
�}tj||ƒ qJW q<W q2W d}	tj	t
|	d�� |jdd� W d Q R X d S )Nr    r†   é   r‡   r   TFr   r   )r   r   zENo axis named 2 for object type <class 'pandas.core.frame.DataFrame'>)r   )r   éþÿÿÿ)TF)r   r   )r-   rk   r«   Zidxminr)   r   r'   r(   r*   r+   r,   )
rb   rB   rq   r1   r   r   r6   r7   r;   r­   r   r   r   Útest_idxmin›  s    

z"TestDataFrameAnalytics.test_idxminc       
   
   C   s´   |}t j|jdd…< t j|jdd…dd …f< xXdD ]P}xJdD ]B}x<||gD ]0}|j||d
�}|jtj||d
�}tj||ƒ qJW q<W q2W d}	tj	t
|	d�� |jdd� W d Q R X d S )Nr    r†   rú   r‡   r   TFr   r   )r   r   zENo axis named 2 for object type <class 'pandas.core.frame.DataFrame'>)r   )r   rû   )TF)r   r   )r-   rk   r«   Zidxmaxr)   r   r'   r(   r*   r+   r,   )
rb   rB   rq   r1   r   r   r6   r7   r;   r­   r   r   r   Útest_idxmaxª  s    

z"TestDataFrameAnalytics.test_idxmaxr0   rG   rH   c             C   s*   t |tt|ƒ|dd� t|||dd� d S )NT)r2   )rN   )rI   r"   r-   rP   )rb   r0   rM   rC   r   r   r   Útest_any_all¼  s    z#TestDataFrameAnalytics.test_any_allc             C   s.  t dddgdddgdddgdœdddgd�}|dd	g jd
ƒ}tdddgdddgd�}tj||ƒ |dd	g jd
dd�}tj||ƒ |jd
ƒ}tdddgdddgd�}tj||ƒ |jd
dd�}tj||ƒ |jd d�jƒ }|dksèt‚|jd d�jƒ }|dk�st‚|dg jd d�jƒ }|dk�s*t‚d S )NTF)r–   r—   r˜   r   r   rt   )r    r–   r—   r   )rJ   )r   r˜   )r   rG   r   r'   r(   rH   Úitemr$   )rb   r6   r7   r;   r   r   r   Útest_any_all_extraÅ  s*    
z)TestDataFrameAnalytics.test_any_all_extrac             C   sd   dt jdt jg}tjdƒtjdƒtjtjg}t||dœƒ}|jdƒ}tddddgƒ}tj	||ƒ d S )Nr   ri   z
1960-02-15z
1960-02-16)r–   r—   TF)
r-   rk   r/   r   rÂ   r   rG   r   r'   r(   )rb   Z
float_dataZdatetime_datar6   r7   r;   r   r   r   Útest_any_datetimeæ  s    
z(TestDataFrameAnalytics.test_any_datetimec             C   s˜   t dddgdddgd d d gdœƒ}|jdd	�}ttjd
�}tj||ƒ t dddgdddgd d d gdddgdœƒ}|jdd	�}tddiƒ}tj||ƒ d S )Nr   r   ri   rm   r    r´   )Úcol1Úcol2Úcol3T)rJ   )r!   F)r  r  r  Úcol4r  )r   rH   r   r-   rë   r'   r(   )rb   r6   r7   r;   r   r   r   Útest_any_all_bool_onlyö  s     z-TestDataFrameAnalytics.test_any_all_bool_onlyzfunc, data, expectedr–   )r–   r—   g        r�   zM8[ns]z1.15)Zmarkszm8[ns]Úcategoryr†   r‡   c             C   sj   t |ƒ}||ƒ}t|tjƒs t‚|jƒ |ks0t‚tt |ƒ|jƒd d�}t|tjƒsVt‚|jƒ |ksft‚d S )N)r   )r   r#   r-   Zbool_r$   rÿ   r"   Ú__name__)rb   Úfuncrz   r;   r7   r   r   r   Útest_any_all_np_func  s    Yz+TestDataFrameAnalytics.test_any_all_np_funcc             C   sL   t jtddgd�ƒjƒ }|dks$t‚t jtddgd�ƒjƒ }|dksHt‚d S )Nr   r   )r�   TF)r-   rH   r   rÿ   r$   rG   )rb   r7   r   r   r   Útest_any_all_objectq  s    z*TestDataFrameAnalytics.test_any_all_objectc             C   s^   t dditjddgddggddgd�d	�}d
}tjt|d�� t||ƒd dd� W d Q R X d S )Nr–   r   r—   r   r   ÚoutÚin)Únames)r    z.Must specify 'axis' when aggregating by level.)r   )r   rµ   )r   r   Zfrom_productr*   r+   r,   r"   )rb   rs   r6   Zxprr   r   r   Ú#test_any_all_level_axis_none_raisesy  s    z:TestDataFrameAnalytics.test_any_all_level_axis_none_raisesc             C   s  t tjjddƒdddgdddd	gd
�}t tjjddƒdddd	gddgd
�}|j|ƒ}t tj|j|jƒdddgddgd
�}|jt|jƒd�}|j|ƒ}t	j
||ƒ |j|d ƒ}t	j||d dd� |jd ksÐt‚|j|d ƒ}t	j||d dd� |jd k�st‚|jd j}|j|ƒ}|j|jd ƒ}t	j||ƒ tjtdd�� |j|d d… ƒ W d Q R X tjjddƒ}tjjddƒ}t |ƒ}t |ƒ}|j|ƒ}t tjjddƒdddgtdƒd
�}	t tjjddƒtdƒdddgd
�}
tjtdd�� |	j|
ƒ W d Q R X d S )Nri   rm   r   r   rt   ÚpÚqÚrrd   )r    r�   r   r±   r²   )r    F)r¶   r   zDot product shape mismatch)r   r   r    ÚalignedrÜ   )r   r-   rK   rL   Údotr   r‘   Úreversedr    r'   rÐ   r(   r¸   r$   râ   r*   r+   r,   Zrandr%   )rb   r   r   r7   r;   Zb1Úrowr–   r—   r6   r|   r   r   r   Útest_dotˆ  s>    $"
"


""zTestDataFrameAnalytics.test_dotc          
   C   sr  t tjjddƒdddgdddd	gd
�}t tjjddƒdddd	gddgd
�}tj||ƒ}t tj|j|jƒdddgddgd
�}tj	||ƒ tj||j
ƒ}ttj|j|j
jƒdddgd�}tj||ƒ tj|j|ƒ}t|t ƒsÜt‚|jj|jƒsît‚|jjtjtdƒƒƒ�s
t‚tj|j|jƒ}tj|j|ƒ tj|jjƒ |ƒ}t tj|j|jƒdddgddgd
�}tj|j|jƒ |jjƒ jtƒ|d< tj||ƒ}t tj|j|jƒdddgddgd
�}tj	||ƒ |jtƒ}tj||ƒ}t tj|j|jƒdddgddgd
�}tj	||ƒ t tjjddƒdddgtdƒd
�}t tjjddƒtdƒdddgd
�}tjtdd�� tj||ƒ W d Q R X d S )Nri   rm   r   r   rt   r  r  r  rd   )r    r�   r   r±   r²   )r    r   r    r  )r   )r   r-   rK   rL   ÚoperatorÚmatmulr  r   r'   rÐ   r±   r   r(   r#   r$   r�   Úequalsr    r/   ÚIndexr%   r¤   Útolistr  Úroundrn   r€   r*   r+   r,   )rb   r   r   r7   r;   r6   r|   r   r   r   Útest_matmul½  sF    $"" ""
"""z"TestDataFrameAnalytics.test_matmulc             C   sŒ   t dddgƒ}t dtjdtjgiƒ}tdddgƒ}ttjtjdgƒ}tjd ƒ�4 |j|dd� xdD ]}t||ƒ|dd� qdW W d Q R X d S )Ng      ð?r–   g       @r   r   )Úlowerr   ÚltÚleÚgtÚgeÚeqÚne)r   )r   r!  r"  r#  r$  r%  )r   r-   rk   r   r'   rÒ   Zclipr"   )rb   r6   Zdf_nanrd   Zs_nanr~   r   r   r   Útest_series_broadcastingû  s    
z/TestDataFrameAnalytics.test_series_broadcasting)r   r   )r   r   )Cr  Ú
__module__Ú__qualname__rc   rp   r*   ÚmarkÚfilterwarningsrr   Zparametrizer}   r…   r•   r™   r�   rŸ   r¡   r©   r®   r°   ÚtdZskip_if_no_scipyr¹   r   r   r   r-   rk   r’   ry   r/   rÂ   rÑ   rÔ   rß   rà   rä   rå   ræ   ré   rê   rì   rñ   Zxfailr¬   rô   r÷   rø   rù   rü   rý   rþ   r   r  r  rG   rH   r   r€   ÚparamZskip_if_np_ltr
  r  r  r  r  r&  r   r   r   r   rQ     s&  P "
W
"
	!

5>rQ   )TTFFN)F)T)F)%Údatetimer   Údecimalr   r  Znumpyr-   r*   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsr+  Zpandasr/   r   r   r   r   r   r	   r
   r   r   r   Zpandas._testingZ_testingr'   Zpandas.core.algorithmsÚcorere   Zpandas.core.nanopsr¦   r@   rE   rI   rP   rQ   r   r   r   r   Ú<module>   s&   0
    
f

A
