3
®y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$G dd„ dƒZ%dd„ Z&ej'j(ddddgƒej'j(dddgƒdd„ ƒƒZ)dS )!é    )Ú	timedelta)ÚDecimalN)
ÚCategoricalÚ	DataFrameÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚisnaÚnotnaÚto_datetimeÚto_timedeltaTFçñhãˆµøä>ç:Œ0âŽyE>c	                s^  t || ƒ}	|r®| dkrtnd}
tdtddd�iƒ}tj|
ƒ� t || ƒƒ }W dQ R X t|tƒsbt‚t	t
|ƒƒ|d< tj|
ƒ� t || ƒƒ }W dQ R X t|tƒs¢t‚t
|ƒs®t‚|�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�r||j|dd�}tj||d||d� |�rª|jj}||jk�sšt‚||jk�sªt‚tjtdd�� |	dd� W dQ R X |�rZ|tj }t || ƒdd�}t || ƒdd�}| dk�rZ| 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
    rtol : float, default 1e-5
        Relative tolerance.
    atol : float, default 1e-8
        Absolute tolerance.
    skipna_alternative : function, default None
        NaN-safe version of alternative
    ÚmeanÚmedianNÚbz1/1/2001é   )ÚperiodsÚac                s
   ˆ | j ƒS )N)Úvalues)Úx)Úalternative© úE/tmp/pip-install-4cy230dp/pandas/pandas/tests/frame/test_analytics.pyÚwrapperR   s    z$assert_stat_op_calc.<locals>.wrapperr   F)ÚaxisÚskipnaé   )Úcheck_dtypeÚrtolÚatol)r   ÚsumÚprodzNo axis named 2)Úmatch)ÚindexÚdtype)r   r   )r"   r#   )r"   r#   )ÚgetattrÚFutureWarningr   r	   ÚtmÚassert_produces_warningÚ
isinstancer   ÚAssertionErrorÚrangeÚlenZ_make_skipna_wrapperÚassert_series_equalÚapplyr   r&   ÚpytestÚraisesÚ
ValueErrorÚnpÚNaNÚpdr%   )Úopnamer   ÚframeÚ
has_skipnar   Úcheck_datesr    r!   Úskipna_alternativeÚfZexpected_warningÚdfÚresultr   Úskipna_wrapperÚresult0Úresult1ÚexpectedZ	lcd_dtypeÚall_naÚr0Úr1Úunitr   )r   r   Úassert_stat_op_calc   st    %






rG   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'   )r7   Úfloat_frameÚfloat_string_frameÚhas_numeric_onlyr   r   r   Úassert_stat_op_api‘   s    rL   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   r?   ¿   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/   r0   r1   r2   r3   r4   r5   rN   r,   Úall)r7   r   r8   r9   r<   r?   r   r@   rA   rC   rD   rE   r   )r   r   Úassert_bool_op_calc«   s6    




rP   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)r4   ÚrandomÚrandnr.   r'   )r7   Úbool_frame_with_narJ   Úhas_bool_onlyÚmixedr   r   r   Úassert_bool_op_apiê   s    rW   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*dZd[„ Z+d\d]„ Z,d^d_„ Z-d`da„ Z.dbdc„ Z/ddde„ Z0ejj	dfdgdhgƒdidj„ ƒZ1dkdl„ Z2dmdn„ Z3dodp„ Z4ejj	dqej5i d8fej6i d/fej5drg id8fej6drg id/fej5drd8d8gid8fej6drd8d8gid8fej5drd/d8gid/fej6drd/d8gid8fej5drd/d/gid/fej6drd/d/gid/fej5d8gd8gdsœd8fej6d8gd8gdsœd8fej5d8d8gd8d/gdsœd/fej6d8d8gd8d/gdsœd8fej6drej7dtd2gdud9�id8fej5drej7dtd2gdud9�id/fej6drej7d?d<ge8d9�id8fej5drej7d?d<ge8d9�id/fej9ej6drej7d?d<gdvd9�id8ej:dwƒgdx�ej9ej5drej7d?d<gdvd9�id/ej:dwƒgdx�ej9ej6drej7d<d@gdvd9�id/ej:dwƒgdx�ej9ej5drej7d<d@gdvd9�id/ej:dwƒgdx�ej9ej6drej7d?d<gdyd9�id8ej:dwƒgdx�ej9ej5drej7d?d<gdyd9�id/ej:dwƒgdx�ej9ej6drej7d<d@gdyd9�id/ej:dwƒgdx�ej9ej5drej7d<d@gdyd9�id/ej:dwƒgdx�ej6drej7d?d<gdzd9�id8fej5drej7d?d<gdzd9�id/fej6drej7d<d@gdzd9�id/fej5drej7d<d@gdzd9�id/fej9ej6ej7d{d|gdvd9�ej7d{d|gdyd9�dsœd/ej:dwƒgdx�gƒd}d~„ ƒZ;dd€„ Z<ejj	ddgdhgƒd�d‚„ ƒZ=dƒd„„ Z>d…d†„ Z?d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)rK   r"   Únuniquer   Úproductr   ÚminÚmaxÚmadÚvarÚstdÚsemr   )ÚkurtosisÚskewrc   Úkurt)rL   Úscipy.statsrb   rc   ÚImportError)ÚselfrI   rJ   rb   rc   r   r   r   Útest_stat_op_api  s*    z'TestDataFrameAnalytics.test_stat_op_apic             C   s4  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jd� 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   rY   *  s    z7TestDataFrameAnalytics.test_stat_op_calc.<locals>.countc             S   s   t tj| jƒ ƒƒS )N)r.   Ú
algorithmsZunique1drM   )ri   r   r   r   rZ   -  s    z9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nuniquec             S   s   t j| | jƒ  ƒjƒ S )N)r4   Úabsr   )r   r   r   r   r^   0  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.madc             S   s   t j| dd�S )Nr   )Úddof)r4   r_   )r   r   r   r   r_   3  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.varc             S   s   t j| dd�S )Nr   )rl   )r4   r`   )r   r   r   r   r`   6  s    z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.stdc             S   s   t j| dd�t jt| ƒƒ S )Nr   )rl   )r4   r`   Úsqrtr.   )r   r   r   r   ra   9  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   )rc   é   F)Úbias)re   rc   r.   r4   Únan)r   rc   r   r   r   Úskewness<  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   )rb   é   F)ro   )re   rb   r.   r4   rp   )r   rb   r   r   r   rd   C  s    z6TestDataFrameAnalytics.test_stat_op_calc.<locals>.kurtrZ   FT)r9   r   r:   r"   Zfloat32gü©ñÒMbP?)r   r    )r;   r   )r:   r[   r^   r_   r`   ra   rY   r   )rb   rc   rc   rd   )rG   r4   r"   ÚastypeZnansumr   r#   ZnanprodZscipyrb   rc   rf   )rg   Úfloat_frame_with_naZmixed_float_framerY   rZ   r^   r_   r`   ra   rq   rd   rb   rc   r   r   r   Útest_stat_op_calc)  sV    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
   rN   r4   rp   r   )r   r   r   r   r     s    z3TestDataFrameAnalytics.test_median.<locals>.wrapperr   T)r:   F)r   r:   )rG   )rg   rt   Ú	int_framer   r   r   r   Útest_median}  s    z"TestDataFrameAnalytics.test_medianÚmethodr"   r   r#   r_   r`   rc   r\   r]   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   rn   rr   )r   r   r   )r&   r   Zf8r"   r#   gÈƒw@Ba@¿gCùVÞúZ¿r   r   gþïœÕN¿)r"   r#   )r   r4   rp   Úobjectr   r&   Zobject_r,   r'   rs   r)   r/   )rg   rx   ÚdataÚdf1Údf2r=   r>   rB   r   r   r   Ú%test_stat_operators_attempt_obj_array‰  s    
&z<TestDataFrameAnalytics.test_stat_operators_attempt_obj_arrayÚoprd   ra   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   rn   rr   g      ð?g       @g      @g      @r   r   ry   Úd)ÚintÚfloatÚstrÚuse_bottleneckF)r   r'   r.   r,   r6   Úoption_context)rg   rƒ   r=   r>   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   ry   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   r4   Úarrayr~   r/   ÚT)rg   r=   Ú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   rn   )ÚAÚBÚCF)rM   )r   )r   r   r   )r   rM   )r   r4   rp   r)   r/   rZ   r   )rg   r=   r   r   r   Útest_nuniqueÉ  s    $ z#TestDataFrameAnalytics.test_nuniqueÚtzNÚUTCc             C   sd   t jddgt jd|d�gd dœƒ}tjtƒ� |jƒ }W d Q R X t jdgdgd�}tj||ƒ d S )	Nr   Ú2000)rŸ   r   )r›   rœ   g      ð?r›   )r%   )	r6   r   r   r)   r*   r(   r   r   r/   )rg   rŸ   r=   r>   rB   r   r   r   Ú test_mean_mixed_datetime_numericÔ  s
    $z7TestDataFrameAnalytics.test_mean_mixed_datetime_numericc          
   C   sZ   t jdt jd|d�gd iƒ}tjtƒ� |jƒ }W d Q R X t jtj	d�}tj
||ƒ d S )Nr›   r¡   )rŸ   r   )r&   )r6   r   r   r)   r*   r(   r   r   r4   Úfloat64r/   )rg   rŸ   r=   r>   rB   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.00rn   z651.00z575.00rr   z1114.00ZTESTz241.00z572.00z609.00z820.00é   z1223.00gš™™™™™@gÍÌÌÌÌL…@r›   r�   )r%   )r   r6   r   r   r   r)   r/   )rg   r„   r=   r>   rB   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 )Nrr   )rl   c             S   s   | j dd�S )Nrr   )rl   )r`   )r   r   r   r   Ú<lambda>  s    z5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>c             S   s   | j dd�S )Nrr   )rl   )r_   )r   r   r   r   r§     s    r   éè  r   )r   rˆ   F)r   r¨   )r`   r0   r)   Úassert_almost_equalr_   r4   ÚrepeatrR   ÚnanopsZnanvarrN   r,   r6   r‰   )rg   Údatetime_framer>   rB   Ú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¥   rn   rz   r{   r|   )r”   Z100r   r   r   T)r   rH   )r   z6unsupported operand type\(s\) for -: 'float' and 'str')r$   Fz&could not convert string to float: 'a')r   rz   )r   rz   )r   r4   rR   rS   Úlocr'   r)   r/   r1   r2   Ú	TypeError)rg   r¯   r€   r�   r>   rB   Ú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 )Nrr   )rl   c             S   s   | j dd�tjt| ƒƒ S )Nrr   )rl   )r`   r4   rm   r.   )r   r   r   r   r§   .  s    z1TestDataFrameAnalytics.test_sem.<locals>.<lambda>r   éè  r   )r   rˆ   F)r   r´   )ra   r0   r)   r©   r4   rª   rR   r«   ZnansemrN   r,   r6   r‰   )rg   r¬   r>   rB   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 )Nr{   ÚoneÚtwoZthreer   r   r   )ZlevelsÚcodesé   rn   )r%   )ÚlevelF)Zcheck_names)r   r   r4   rR   rS   rd   Úxsr)   r/   Únamer,   )rg   r%   r=   rd   Zkurt2r   r   r   Ú	test_kurt9  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   ÚNaTrp   r   r   rn   )Ú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‹   rn   r   r   rÆ   z2000-1-2z1 daysrp   rÄ   rÅ   rr   Úint64)r&   )r›   rœ   r�   rÀ   rÁ   rÂ   rÃ   rÇ   rÈ   rÉ   rÊ   rË   rÌ   rÍ   )rM   )r   r4   rp   r   r   r   ÚarangeÚsortedÚkeysÚmoder)   Úassert_frame_equal)rg   rM   rB   r=   r>   r   r   r   Útest_mode_dropnaG  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)rM   )ZbyT)Zdrop)
r   r4   rp   r)   r*   ÚUserWarningrÔ   Zsort_valuesZreset_indexrÕ   )rg   r=   rB   r>   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-1rn   rÀ   )r   Úfreqz2012-1-2Z20120101r¥   )ÚminutesÚseconds)r›   rœ   r�   r›   r�   rœ   )r›   rœ   r   r   )r   r   rz   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   r\   r°   r,   rO   r]   rk   r)   rÕ   Úcopyr   r6   Z	Timedeltar”   r/   r&   Z_consolidate_inplace)rg   r=   Zdiffsr>   Zresult2rB   rV   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.   )rg   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   ry   )r   r   ry   r£   )r%   r&   r   )Ú	min_count)r%   r   r‹   r¥   )r›   rœ   r›   rœ   r¹   )	r6   r   r4   rp   r'   r   r)   r/   Úiloc)rg   rx   rF   Úidxr=   r>   rB   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   ry   r   )r   r   ry   zm8[ns])r&   r%   )rå   r   )
r6   r   r4   rp   r0   r   r"   r   r)   r/   )rg   rç   r=   r�   r>   rB   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   rs   r…   r   r%   r”   r   r"   )rg   rI   r   r8   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   )r4   Úisnanr"   )rg   rI   Úboolsr   r   r   Útest_sum_bool@  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¡   rr   )r   r   r   rn   )r›   rœ   rœ   g      @)r6   r   r	   r–   r"   r   r)   r/   )rg   r=   r>   rB   r   r   r   Útest_sum_mixed_datetimeF  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   rH   r   r›   Úbool)	r   r"   r)   Zassert_index_equalr%   r.   r”   r,   r   )rg   rI   rJ   Zthe_meanZthe_sumZmeansr   r   r   Útest_mean_cornerP  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
||ƒ t	jtƒ� |jƒ }W d Q R X t jd|jd dœƒ}t	j
||ƒ d S )Nrn   z
2016-01-01)r   Ú1DÚ2016r›   )r   rÙ   )r›   rœ   r�   rÀ   T)rH   g      ð?r   r�   )r›   r�   )r   r�   )r6   r   r4   rÑ   r	   Útimedelta_rangeÚperiod_ranger   r   r)   r/   r*   r(   r°   )rg   r=   r>   rB   r   r   r   Útest_mean_datetimelikea  s    z-TestDataFrameAnalytics.test_mean_datetimelikec          
   C   s    t jtjdƒt jddd�t jddd�dœƒ}|jdd�}t 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 )Nrn   z
2016-01-01)r   rñ   )r›   rœ   r�   F)rH   r   rœ   r�   rò   r›   )r   rÙ   rÀ   z"mean is not implemented for Period)r$   )r   rœ   )r   r�   )r6   r   r4   rÑ   r	   ró   r   r   r°   r)   r/   rô   r1   r2   r±   )rg   r=   r>   rB   r   r   r   Ú)test_mean_datetimelike_numeric_only_falsew  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¥   )ÚsizeÚInt64)r&   T)rH   )r‹   r¥   )r4   rR   Úrandintr6   r   r   r)   r/   )rg   r­   r=   r>   rB   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`   r_   r   rc   )rg   rJ   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,   )rg   r=   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   z)No axis named 2 for object type DataFrame)r$   )r   éþÿÿÿ)TF)r   r   )r4   rp   ræ   Zidxminr0   r   r)   r/   r1   r2   r3   )
rg   rI   rv   r8   r   r   r=   r>   rB   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   z)No axis named 2 for object type DataFrame)r$   )r   rþ   )TF)r   r   )r4   rp   ræ   Zidxmaxr0   r   r)   r/   r1   r2   r3   )
rg   rI   rv   r8   r   r   r=   r>   rB   r²   r   r   r   Útest_idxmax±  s    

z"TestDataFrameAnalytics.test_idxmaxr7   rN   rO   c             C   s*   t |tt|ƒ|dd� t|||dd� d S )NT)r9   )rU   )rP   r'   r4   rW   )rg   r7   rT   rJ   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   ry   )r%   r›   rœ   r   )rQ   )r   r�   )r   rN   r   r)   r/   rO   Úitemr,   )rg   r=   r>   rB   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   rn   z
1960-02-15z
1960-02-16)r›   rœ   TF)
r4   rp   r6   r   rÆ   r   rN   r   r)   r/   )rg   Z
float_dataZdatetime_datar=   r>   rB   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   rn   rr   r¥   r¹   )Úcol1Úcol2Úcol3T)rQ   )r&   F)r  r  r  Úcol4r  )r   rO   r   r4   Úbool_r)   r/   )rg   r=   r>   rB   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+   r4   r	  r,   r  r'   Ú__name__)rg   Úfuncr   rB   r>   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)r4   rO   r   r  r,   rN   )rg   r>   r   r   r   Útest_any_all_objectx  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_productr1   r2   r3   r'   )rg   rx   r=   Zxprr   r   r   Ú#test_any_all_level_axis_none_raises€  s    z:TestDataFrameAnalytics.test_any_all_level_axis_none_raisesc          
   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 )Nrn   rr   r   r   ry   ÚpÚqÚrri   )r%   r”   r   r¶   r·   )r%   r   r¥   Zaligned)r$   )r   r4   rR   rS   ÚoperatorÚmatmulÚdotr   r)   rÕ   r¶   r   r/   r+   r,   r”   Úequalsr%   r6   ÚIndexr-   r©   Útolistr  Úroundrs   r…   r1   r2   r3   )rg   r   r   r>   rB   r=   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   r4   rp   r   r)   r*   Zclipr'   )rg   r=   Zdf_nanri   Zs_nanrƒ   r   r   r   Útest_series_broadcastingÍ  s    
z/TestDataFrameAnalytics.test_series_broadcasting)r"   r   )r#   r   )@r  Ú
__module__Ú__qualname__rh   ru   r1   ÚmarkÚfilterwarningsrw   Úparametrizer‚   rŠ   rš   rž   r¢   r¤   r¦   r®   r³   rµ   ÚtdZskip_if_no_scipyr½   r   r   r   r4   rp   r—   r~   r6   rÆ   rÖ   rØ   rã   rä   rè   ré   rê   rí   rî   rð   rõ   rö   rú   rû   rü   rÿ   r   r  r  r  r
  rN   rO   r   r…   ÚparamZskip_if_np_ltr  r  r  r  r&  r   r   r   r   rX     s  T "	W
"
	!

>rX   c               @   sV   e Zd Zdd„ Zdd„ Zdd„ Zejjddd	gƒejjd
ddgƒe	dœdd„ƒƒZ
dS )ÚTestDataFrameReductionsc             C   sà   t jdt jt jt jdƒgiƒ}|jƒ }t jt jdƒgdgd�}tj||ƒ |jƒ }t jt jdƒgdgd�}tj||ƒ t jdt jt jgiƒ}|jƒ }t jt jgdgd�}tj||ƒ |jƒ }t jt jgdgd�}tj||ƒ d S )Nrz   z
2012-05-01)r%   )	r6   r   rÆ   r   r\   r   r)   r/   r]   )rg   r=   ÚresÚexpr   r   r   Útest_min_max_dt64_with_NaTÜ  s    z2TestDataFrameReductions.test_min_max_dt64_with_NaTc             C   sž   t jtt jg ƒd�ƒ}t jt jg ƒƒ}|jdd�jt jk|jƒ t jkksLt‚|j	dd�jt jk|j	ƒ t jkksrt‚t
j|jdd�|ƒ t
j|j	dd�|ƒ d S )N)r   r   )r   r   )r6   r   rá   r   r   r\   r   rÆ   r,   r]   r)   r/   )rg   r=   Zexpected_dt_seriesr   r   r   Ú*test_min_max_dt64_api_consistency_with_NaTó  s    &&zBTestDataFrameReductions.test_min_max_dt64_api_consistency_with_NaTc             C   s–   t jtg d�ƒ}t jg td�}tj|jdd�jƒtj|jƒ ƒksDt	‚tj|j
dd�jƒtj|j
ƒ ƒksjt	‚tj|jdd�|ƒ tj|jdd�|ƒ d S )N)r   )r&   r   )r   r   )r6   r   rá   r   r†   r4   rë   r\   r   r,   r]   r)   r/   )rg   r=   Zexpected_float_seriesr   r   r   Ú*test_min_max_dt64_api_consistency_empty_df  s    &&zBTestDataFrameReductions.test_min_max_dt64_api_consistency_empty_dfÚinitialz2018-10-08 13:36:45+00:00z2018-10-08 13:36:45+03:00rx   r\   r]   )r4  c             C   s>   t j|ƒ}t|gƒ}t|gƒ}t||ƒdd�}tj||ƒ d S )Nr   )r   )r6   r   r   r   r'   r)   r/   )rg   r4  rx   Z
initial_dtrB   r=   r>   r   r   r   Útest_preserve_timezone  s
    


z.TestDataFrameReductions.test_preserve_timezoneN)r  r'  r(  r1  r2  r3  r1   r)  r+  r‡   r5  r   r   r   r   r.  Û  s   r.  c              C   sT   t jddggtdƒd�} | jddiƒ} | jƒ }t jddgddgd�}tj||ƒ d S )Nr   r   Úab)r”   r   rø   )r%   )r6   r   Úlistrs   r"   r   r)   r/   )r=   r>   rB   r   r   r   Ú!test_mixed_frame_with_integer_sum  s
    r8  rH   rx   r\   r]   c             C   sp   t jdƒ}t|jd |jgtjƒ d�}td|iƒ}t|| ƒ|d�}tt|| ƒgtj	dgdd�d�}t
j||ƒ d S )NrÐ   )r&   rø   )rH   r~   )r%   )r4   Ziinfor   r]   r\   r6   Z
Int64Dtyper   r'   r  r)   r/   )rx   rH   Z
int64_infoZserr=   r>   rB   r   r   r   Útest_minmax_extensionarray%  s    
r9  )TTFr   r   N)F)T)F)*Údatetimer   Údecimalr   r  Znumpyr4   r1   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsr,  Zpandasr6   r   r   r   r   r   r	   r
   r   r   r   Zpandas._testingZ_testingr)   Zpandas.core.algorithmsÚcorerj   Zpandas.core.nanopsr«   rG   rL   rP   rW   rX   r.  r8  r)  r+  r9  r   r   r   r   Ú<module>   s>   0
     
l

@
       ZA	