3
®yb0  ã               @   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m	Z	m
Z
mZmZmZmZmZmZ d dljZG dd„ dƒZdd„ Zd	d
„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ ZdS )é    )Úproduct)Úascii_lowercaseN)Ú	DataFrameÚIndexÚ
MultiIndexÚPeriodÚSeriesÚ	TimedeltaÚ	TimestampÚ
date_rangec            	   @   s  e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zdd„ Zdd„ Z	dd„ Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd „ Zd!d"„ Zejjd#d$d%„ ed&d'ƒD ƒd(d%„ ed&d'ƒD ƒd)d%„ ed&d'ƒD ƒd*d%„ ed&d'ƒD ƒgƒd+d,„ ƒZd-d.„ Zd/d0„ Zd1S )2ÚTestCountingc             C   sh   t dgdgdgdgdggdgd�}|jdƒ}|j}tdddddgƒ}tj||jƒ ƒ tj||jƒ ƒ d S )	NÚaÚbÚA)Úcolumnsr   é   é   é   )r   Úgroupbyr   r   ÚtmÚassert_series_equalÚcumcount)ÚselfÚdfÚgÚsgÚexpected© r   úF/tmp/pip-install-4cy230dp/pandas/pandas/tests/groupby/test_counting.pyÚtest_cumcount   s    "
zTestCounting.test_cumcountc             C   sN   t ƒ jdd�}ttd�jdd�}tdd�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   )Úlevel)ÚdtypeÚint64)r   r   r   Úobjectr   r   r   )r   ÚgeÚseÚer   r   r   Útest_cumcount_empty    s
    
z TestCounting.test_cumcount_emptyc             C   sz   t dgdgdgdgdggdgdgd d�}|jdƒ}|j}tddddd	gdgd d
�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   r   r   r   é   )r   Úindexr   r   r   )r)   )r   r   r   r   r   r   r   )r   r   r   r   r   r   r   r   Útest_cumcount_dupe_index*   s    (
z%TestCounting.test_cumcount_dupe_indexc             C   s–   t jddgddgddgddgddggƒ}tdgdgdgdgdggdg|d�}|jdƒ}|j}tdddddg|d	�}tj||jƒ ƒ tj||jƒ ƒ d S )
Nr   r   r   r   r   r   )r   r)   r   )r)   )	r   Úfrom_tuplesr   r   r   r   r   r   r   )r   Úmir   r   r   r   r   r   r   Útest_cumcount_mi6   s    ($
zTestCounting.test_cumcount_mic             C   s„   t dgdgdgdgdggdgdgd d�}|jdddddgƒ}|j}tddddd	gdgd d
�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   r   r   r   r(   )r   r)   r   r   r   )r)   )r   r   r   r   r   r   r   )r   r   r   r   r   r   r   r   Útest_cumcount_groupby_not_colA   s    (z*TestCounting.test_cumcount_groupby_not_colc             C   sV   t dtdƒiƒ}|jdƒ}|j}tdddddgƒ}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   Úaaabar   r   )r   Úlistr   r   r   r   r   Úngroup)r   r   r   r   r   r   r   r   Útest_ngroupM   s    
zTestCounting.test_ngroupc             C   sT   t dtdƒiƒ}|jdƒ}|j}ttdƒdd�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   Zabcder(   r"   )r!   )	r   r0   r   r   r   Úranger   r   r1   )r   r   r   r   r   r   r   r   Útest_ngroup_distinctW   s    
z!TestCounting.test_ngroup_distinctc             C   sT   t ddgd iƒ}|jdƒ}|j}tdgd ƒ}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   r   r(   )r   r   r   r   r   r   r1   )r   r   r   r   r   r   r   r   Útest_ngroup_one_groupa   s    
z"TestCounting.test_ngroup_one_groupc             C   sN   t ƒ jdd�}ttd�jdd�}tdd�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   )r    )r!   r"   )r   r   r   r#   r   r   r1   )r   r$   r%   r&   r   r   r   Útest_ngroup_emptyk   s
    
zTestCounting.test_ngroup_emptyc             C   s@   t dtdƒiƒ}ttdƒƒ}tj|j|ƒjƒ |j|ƒjƒ ƒ d S )Nr   r/   )r   r0   r   r   r   r   r1   )r   r   Úsr   r   r   Ú test_ngroup_series_matches_frameu   s    z-TestCounting.test_ngroup_series_matches_framec             C   sj   t dtdƒidgd d�}|jdƒ}|j}tdddddgdgd d�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   r/   r   r(   )r)   r   )r   r0   r   r   r   r   r   r1   )r   r   r   r   r   r   r   r   Útest_ngroup_dupe_index{   s    
z#TestCounting.test_ngroup_dupe_indexc             C   s†   t jddgddgddgddgddggƒ}tdtdƒi|d�}|jdƒ}|j}tdddddg|d�}tj||j	ƒ ƒ tj||j	ƒ ƒ d S )Nr   r   r   r   r/   )r)   )
r   r+   r   r0   r   r   r   r   r   r1   )r   r,   r   r   r   r   r   r   r   Útest_ngroup_mi…   s    (
zTestCounting.test_ngroup_mic             C   st   t dtdƒidgd d�}|jdddddgƒ}|j}tdddddgdgd d�}tj||jƒ ƒ tj||jƒ ƒ d S )Nr   r/   r   r(   )r)   r   )r   r0   r   r   r   r   r   r1   )r   r   r   r   r   r   r   r   Útest_ngroup_groupby_not_col�   s    z(TestCounting.test_ngroup_groupby_not_colc             C   sŠ   t dddddgdgd�}|jdgƒ}tdddddgƒ}tdddddgƒ}tj||jd | ƒ tj||jdd�ƒ tj||jd	d�ƒ d S )
Nr   r   r   )r   r   r   T)Ú	ascendingF)r   r   r   r   r   Zngroupsr1   )r   r   r   r<   Z
descendingr   r   r   Útest_ngroup_descending™   s    z#TestCounting.test_ngroup_descendingc             C   sŒ   t ddgddgddgddgddggddgd�}|jddgƒ}|jƒ }|jƒ }tdd	d
ddgƒ}tdddd	dgƒ}tj||ƒ tj||ƒ d S )Nr   ÚxÚyr   r   ÚX)r   r   r   r   r   )r   r   r1   r   r   r   r   )r   r   r   Zg_ngroupZ
g_cumcountZexpected_ngroupZexpected_cumcountr   r   r   Útest_ngroup_matches_cumcount¤   s     z)TestCounting.test_ngroup_matches_cumcountc                s’   xŒt tdƒdd�D ]x‰tdˆiƒ}|jdgƒ}ttˆƒƒ‰ ‡ fdd„ˆD ƒ}‡fdd„tˆƒD ƒ}tj|j	ƒ t
|ƒƒ tj|jƒ t
|ƒƒ qW d S )Nr   é   )Úrepeatr   c                s   g | ]}ˆ j |ƒ‘qS r   )r)   )Ú.0Úval)Úorderr   r   ú
<listcomp>º   s    z:TestCounting.test_ngroup_cumcount_pair.<locals>.<listcomp>c                s"   g | ]\}}ˆ d |… j |ƒ‘qS )N)Úcount)rD   ÚirE   )Úpr   r   rG   »   s    )r   r3   r   r   ÚsortedÚsetÚ	enumerater   r   r1   r   r   )r   r   r   ZngroupdZ
cumcountedr   )rF   rJ   r   Útest_ngroup_cumcount_pair³   s    z&TestCounting.test_ngroup_cumcount_pairc       	      C   sÜ   t jjdƒ tdt jjtdƒdƒiƒ}x°dD ]¨}|jdg|d�}d|d	< d|d
< xNt|ƒD ]B\}\}}||j|j	d	f< x$t|j	ƒD ]\}}||j|d
f< q‚W qZW t
jt|d	 jƒ|jƒ ƒ t
jt|d
 jƒ|jƒ ƒ q,W d S )Nr   r   Zabcdeféd   FT)Úsortr   Zgroup_idZgroup_index)FTéÿÿÿÿrQ   )ÚnpÚrandomÚseedr   Úchoicer0   r   rM   Úlocr)   r   r   r   Úvaluesr1   r   )	r   r   Z	sort_flagr   rI   Ú_ÚgroupÚjÚindr   r   r   Ú"test_ngroup_respects_groupby_orderÀ   s    
z/TestCounting.test_ngroup_respects_groupby_orderÚdatetimelikec             C   s   g | ]}t d |d›d�ƒ‘qS )z2016-05-Ú02dz 20:09:25+00:00)r
   )rD   rI   r   r   r   rG   Ó   s    zTestCounting.<listcomp>r   rB   c             C   s   g | ]}t d |d›d�ƒ‘qS )z2016-05-r^   z	 20:09:25)r
   )rD   rI   r   r   r   rG   Ô   s    c             C   s   g | ]}t |d d�‘qS )Úh)Úunit)r	   )rD   r>   r   r   r   rG   Õ   s    c             C   s   g | ]}t d d|d�‘qS )Z2Wiá  )ÚfreqÚyearÚmonth)r   )rD   r>   r   r   r   rG   Ö   s    c             C   sR   t dddg|dœƒ}|jdƒjƒ }t dddgiddgd�}d|j_tj||ƒ d S )	Nr   r   )r>   r?   r>   r?   r   r   )r)   )r   r   rH   r)   Únamer   Úassert_frame_equal)r   r]   r   Úresr   r   r   r   Útest_count_with_datetimelikeÐ   s
    z)TestCounting.test_count_with_datetimelikec             C   sx   t tjtjgddgddgdœƒ}|jddgƒjjƒ }tg ddggg g gddgd�}tg |tjd	d
�}t	j
||dd� d S )Nr   r   r   r   )r   ÚBÚCr   rh   )ZlevelsÚcodesÚnamesri   )r)   r!   rd   F)Zcheck_index_type)r   rR   Únanr   ri   rH   r   r   r"   r   r   )r   r   Úresultr,   r   r   r   r   Ú(test_count_with_only_nans_in_first_groupã   s
     z5TestCounting.test_count_with_only_nans_in_first_groupc             C   sl   t dddddgddtjddgdœƒ}|jdgƒjƒ }t tdd	d
dgdd�dddddgid�}tj||ƒ d S )Nr   r(   rB   r   r   )r   rh   rh   g        g      @g      @g      @)rd   r   )r)   Údata)r   rR   ÚNaNr   rH   r   r   re   )r   r   rf   r   r   r   r   Ú4test_count_groupby_column_with_nan_in_groupby_columnë   s
    $&zATestCounting.test_count_groupby_column_with_nan_in_groupby_columnN)Ú__name__Ú
__module__Ú__qualname__r   r'   r*   r-   r.   r2   r4   r5   r6   r8   r9   r:   r;   r=   rA   rN   r\   ÚpytestÚmarkZparametrizer3   rg   rn   rq   r   r   r   r   r      s2   








 r   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   rB   ztimedelta64[ns])r   Údeltr   r   r   )rd   rx   )r)   rd   Úabab)r   r0   rR   ZarangeÚastyper   Úpdr   r   rx   rH   r   r   )r   r   rm   r   r   r   Ú#test_groupby_timedelta_cython_countõ   s
     r|   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-30é
   ÚT)Zperiodsra   r   r(   r   )	Ú1stÚ2ndZ3rdÚ4thZ5thZ6thZ7thZ8thÚ9thr€   r�   r‚   rƒ   Úcategory)Zaxisi €  iöÿÿÿ)r   r   rR   rS   rU   r0   r   ÚrandintZrandnÚroundr   Zdroprl   rV   rz   r   rH   Úapplyr   re   )ÚnZdrr   ÚcolÚkeyÚleftÚrightr   r   r   Ú
test_countþ   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   ZfooÚbarr   r   rh   ri   )r   F)Zas_indexr   )r   r)   )r{   r   rR   rl   r   rH   r)   rd   r   re   Zreset_indexr   )r   Zcount_asZcount_not_asr   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   Úcr�   )rd   )r)   rd   r   )r{   r   r   r   rH   r   r   r   r   rR   rl   )r   rm   r   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(   rO   r   r   r   r�   Úd)r   Úfloat32r#   )rO   r   )rO   r   )r“   r#   )rR   ZhstackrS   r…   r{   r   rl   r   rH   rz   r   re   )Úvalsr   r   Útrm   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   rO   r   é   rB   r(   é   rw   )r   r   r�   Úgrpr™   )r   r   r�   )rd   )r)   ry   )r   rR   ÚarrayZint8Zuint32Zint16r0   r   rH   r{   r   r   re   )r   rm   r   r   r   r   Útest_lower_int_prec_countL  s    ,r›   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)rr   rs   rt   r   r   r   r   ÚRaisingObjectException]  s   rœ   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__Úmsg)r   r    )Ú	__class__r   r   rŸ   a  s    
zAtest_count_uses_size_on_exception.<locals>.RaisingObject.__init__c                s   ˆ | j ƒ‚d S )N)r    )r   Úother)rœ   r   r   Ú__eq__e  s    z?test_count_uses_size_on_exception.<locals>.RaisingObject.__eq__)r�   )rr   rs   rt   rŸ   r£   Ú__classcell__r   )rœ   )r¡   r   ÚRaisingObject`  s   r¥   c                s   g | ]
}ˆ ƒ ‘qS r   r   )rD   rX   )r¥   r   r   rG   i  s    z5test_count_uses_size_on_exception.<locals>.<listcomp>rB   rw   r   )r   r™   r™   r   )rd   )r)   ry   )
Ú	Exceptionr   r3   r0   r   rH   r{   r   r   re   )r   rm   r   r   )r¥   rœ   r   Ú!test_count_uses_size_on_exception\  s    	$"r§   )Ú	itertoolsr   Ústringr   ZnumpyrR   ru   Zpandasr{   r   r   r   r   r   r	   r
   r   Zpandas._testingZ_testingr   r   r|   r�   r�   r‘   r–   r›   r§   r   r   r   r   Ú<module>   s   (

 a	