3
®yb‰  ã               @   s’   d 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 ddljZddlmZ G dd„ dƒZG dd„ dƒZG d	d
„ d
ƒZG dd„ dƒZdS )zG test where we are determining what we are grouping, or getting groups é    N)ÚCategoricalIndexÚ	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_range)ÚGroupingc               @   sD   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S )ÚTestSelectionc             C   sn   t ddggddgd�}|jdƒ}tjtdd�� |dg  W d Q R X tjtd	d�� |ddg  W d Q R X d S )
Né   é   ÚAÚB)Úcolumnsz"Columns not found: 'C'")ÚmatchÚCz^[^A]+$)r   ÚgroupbyÚpytestÚraisesÚKeyError)ÚselfÚdfÚg© r   úF/tmp/pip-install-4cy230dp/pandas/pandas/tests/groupby/test_grouping.pyÚtest_select_bad_cols   s    
z"TestSelection.test_select_bad_colsc             C   s²   t ddddgtdƒtddƒtdddƒgd	�}d
}tjt|d�� |jdƒ W d Q R X tjt|d�� |jddgƒ W d Q R X |jdƒ}|jƒ }|jjdksžt	‚|jj
dks®t	‚d S )Nr   r   r   é   r   é   r   é   )r   Údataz!Grouper for 'A' not 1-dimensional)r   r   é   )r   Úranger   r   Ú
ValueErrorr   Úcountr   ZnlevelsÚAssertionErrorÚsize)r   r   ÚmsgÚgroupedÚcr   r   r   Ú'test_groupby_duplicated_column_errormsg#   s    *
z5TestSelection.test_groupby_duplicated_column_errormsgc             C   sf   |j dƒjjƒ }|j dƒd jƒ }tj||ƒ d|d< |j dƒjƒ }|j dƒjtjƒ}tj||ƒ d S )Nr   r   g      ø?Úmean)	r   r   ÚsumÚtmÚassert_series_equalr*   ÚaggÚnpÚassert_frame_equal)r   r   ÚresultÚexpectedr   r   r   Útest_column_select_via_attr4   s    z)TestSelection.test_column_select_via_attrc          
   C   s¼   t ddddddddgddddddddgtjjdƒtjjdƒtjjdƒdœƒ}|jdƒd	d
g jƒ }|jdƒ|jdd…  jƒ }|jd d …dd	d
gf jdƒjƒ }tj	||ƒ tj	||ƒ d S )NÚfooÚbarÚoneÚtwoÚthreer   )r   r   r   ÚDÚEr   r   r9   r   r   )
r   r/   ÚrandomÚrandnr   r*   r   Úlocr,   r0   )r   r   r1   Úresult2r2   r   r   r   Útest_getitem_list_of_columns>   s    

"z*TestSelection.test_getitem_list_of_columnsc          
   C   sÊ   t tdƒd tjjdƒtjjdƒtjjdƒdœƒ}|jdƒ|jdd…  jƒ }|jdƒddg jƒ }|jd d …dddgf jdƒjƒ }t	j
||ƒ t	j
||ƒ t	jtƒ� |jdƒd	 jƒ  W d Q R X d S )
NÚabcdr   r   )r   r   r   r   r   r   r    r   )r   r   )r   Úlistr/   r;   r<   r   r   r*   r=   r,   r0   Úassert_produces_warningÚFutureWarning)r   r   r1   r>   r2   r   r   r   Ú!test_getitem_numeric_column_namesQ   s    


"z/TestSelection.test_getitem_numeric_column_namesc          
   C   s,   t jtƒ� |jdƒd jƒ  W d Q R X d S )Nr   r   r9   )r   r9   )r,   rB   rC   r   r*   )r   r   r   r   r   Ú#test_getitem_single_list_of_columnsg   s    z1TestSelection.test_getitem_single_list_of_columnsc          
   C   s¤   t ddddddddgddddddddgtjjdƒtjjdƒtjjdƒdœƒ}|jdƒd	 jƒ }|jd d …dd	gf jdƒjƒ }|jd d …d
f }|}tj	||ƒ d S )Nr4   r5   r6   r7   r8   r   )r   r   r   r9   r:   r   r   r   )
r   r/   r;   r<   r   r*   r=   Úilocr,   r-   )r   r   r1   Zas_frameZ	as_seriesr2   r   r   r   Útest_getitem_single_columnl   s    

 z(TestSelection.test_getitem_single_columnN)
Ú__name__Ú
__module__Ú__qualname__r   r)   r3   r?   rD   rE   rG   r   r   r   r   r
      s   
r
   c               @   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d#d$„ Zejjd%d&d'gƒd(d)„ ƒZd*d+„ Zejjd%d&d'gƒd,d-„ ƒZd.d/„ Zejjd0d&d1d1d1d2d2d3d3d4d4d4g
gd'd2d2d2d3d3d1d1d4d4d4g
ggƒd5d6„ ƒZd7d8„ Zd9d:„ Zejjd;d<ej d1e!j"ej#d2d2d3ƒd=�fd>ej d1e!j"ej$g d3d?�d=�fd@ej d1e!j"ej$g d3d?�d=�fgƒdAdB„ ƒZ%dCdD„ Z&dEdF„ Z'dGdH„ Z(dIS )JÚTestGroupingc             C   sš   t tjdƒjddƒtdƒd�}xvtjtjtjtj	tj
tjgD ]V}|t|ƒƒ|_|jtdƒƒjdd„ ƒ tt|jjƒ ƒƒ|_|jtdƒƒjd	d„ ƒ q<W d S )
Né
   é   r   ZAB)r   Zabcdec             S   s   | S )Nr   )Úxr   r   r   Ú<lambda>“   s    z7TestGrouping.test_grouper_index_types.<locals>.<lambda>c             S   s   | S )Nr   )rN   r   r   r   rO   –   s    )r   r/   ÚarangeÚreshaperA   r,   ZmakeFloatIndexZmakeStringIndexZmakeUnicodeIndexZmakeIntIndexZmakeDateIndexZmakePeriodIndexÚlenÚindexr   ÚapplyÚreversedÚtolist)r   r   rS   r   r   r   Útest_grouper_index_types…   s    z%TestGrouping.test_grouper_index_typesc       	      C   s  ddl m}m} |jƒ |dd� }t||jƒ ƒ}tjj||gddgd�}tjt	j
jddd	ƒ|d
�}|jƒ jtjddd�tjddd�gƒjƒ }tjdgdd�|_|jtjddd�tjddd�gƒjƒ }tj||ƒ |jtjddd�tjddd�gƒjƒ }tj||ƒ d S )Nr   )ÚdateÚ	timedeltaé   )Údaysr4   r5   )Únameséd   éá   )rS   ÚW)ÚkeyÚfreqÚint64)Údtype)Úlevelra   r   )ÚdatetimerX   rY   Útodayr   Úpdr   Úfrom_productr   r/   r;   ÚrandintÚreset_indexr   ÚGrouperr+   r   r   r,   r0   )	r   rX   rY   Zd0ÚdatesZ
date_indexr   r2   r1   r   r   r   Útest_grouper_multilevel_freq˜   s    """z)TestGrouping.test_grouper_multilevel_freqc          	   C   sX  t ddddddgddddddgdœƒ}|jd	ƒ}|jƒ }|jtjd	d
�ƒ}|jƒ }tj||ƒ |jdd„ ƒ}tj||ƒ |jtjd	dd�ƒ}|jƒ }tj||ƒ t ddddddgddddddgddddddgdœƒ}|jd	ƒjƒ }|jtjd	d
�gƒ}|jƒ }tj||ƒ |jd	dgƒjƒ }|jtjd	d
�tjdd
�gƒ}|jƒ }tj||ƒ |jd	tjdd
�gƒ}|jƒ }tj||ƒ |jtjd	d
�dgƒ}|jƒ }tj||ƒ tt	j
ddd�tjjtdƒtdƒtddd�gdddgd�d�}|jtjddd�ƒjƒ }tdgttdƒgddd�d�}tj||ƒ |jtjdd �ƒjƒ }|jdd �jƒ }tj||ƒ d S )!Nr   r   r   r    r   rM   r   )r   r   r   )r`   c             S   s   | j ƒ S )N)r+   )rN   r   r   r   rO   Â   s    z8TestGrouping.test_grouper_creation_bug.<locals>.<lambda>)r`   Úaxis)r   r   r   r   r   rb   )rc   ÚabÚ20130101)Úperiodsr6   r7   r8   )r\   )rS   ÚM)rd   ra   é   z
2013-01-31)ra   Úname)rd   )r   r   r+   rg   rk   r,   r0   rT   r   r/   rP   r   rh   rA   r!   r   r   r   r-   )r   r   r   r2   r1   Úsr   r   r   Útest_grouper_creation_bug·   sN    &
2z&TestGrouping.test_grouper_creation_bugc             C   sF  t jjddddddgƒ}ddg|_t jtjdƒd	d	d
d
d	d	gdœ|d�}|jdt jdd�gƒj	ƒ }|j
ƒ jddgƒj	ƒ }tj||ƒ |jt jdd�dgƒj	ƒ }|j
ƒ jddgƒj	ƒ }tj||ƒ |j
dƒ}|jdt jdd�gƒj	ƒ }|j
ƒ jddgƒj	ƒ }tj||ƒ |jt jdd�dgƒj	ƒ }|j
ƒ jddgƒj	ƒ }tj||ƒ d S )NÚar   r   r    ÚbÚouterÚinnerr   r6   r7   )r   r   )rS   r   )rd   )rw   r   )rw   r   )rw   r    )rx   r   )rx   r   )rx   r    )rg   r   Úfrom_tuplesr\   r   r/   rP   r   rk   r*   rj   r,   r0   )r   ÚidxZdf_multir1   r2   Z	df_singler   r   r   Útest_grouper_column_and_indexú   s&    

z*TestGrouping.test_grouper_column_and_indexc             C   s’   ddg}t jjddddg|d	�}t jtjd
ƒjddƒ|d�}|j|d�jƒ }|j	ƒ j|ƒjƒ }t
j||dd� t j|jtjd�|_t
j||ƒ d S )NrN   Úyr   r   r    r   rM   r   )r\   é   )rS   )rd   F)Zcheck_column_type)rc   )r   r   )r   r   )r    r   )rM   r   éÿÿÿÿ)rg   r   r{   r   r/   rP   rQ   r   r*   rj   r,   r0   r   r   rb   )r   Z	idx_namesr|   r   Z	by_levelsZ
by_columnsr   r   r   Útest_groupby_levels_and_columns  s    z,TestGrouping.test_groupby_levels_and_columnsc          	   C   s  ddddg}ddg}t jddddgddddgddddgddddgddddggtƒ}t||dd�}t||d�}|jdd|d	�jƒ }t jd
dgd
dgd
dgd
dgd
dggtƒ}t||dd�}	t||	d�}
tj||
ƒ t|j	|d�}|jdd|d	�jƒ }t|j	|	d�}
tj||
ƒ d S )Nr   r   r   r   T)Ú
categoriesÚordered)r   r   r   )rn   rd   Úobservedr   )rS   )r   rS   )
r/   ÚarrayÚintr   r   r   r+   r,   r0   ÚT)r   r„   r   r‚   r   Zcat_columnsr   r1   Zexpected_dataZexpected_columnsr2   r   r   r   Ú*test_groupby_categorical_index_and_columns-  s     :*z7TestGrouping.test_groupby_categorical_index_and_columnsc          	   C   s    t dditjjtdƒtddd�gddgd	�d
�}|jtjdd�tjddd�gƒjƒ }t dddddddgitjtdƒtdddd�gddgd	�d
�}t	j
||ƒ d S )Nr   r   ro   rp   éP   )rq   r6   r7   )r\   )rS   )rd   rr   )rd   ra   é   rs   é   r    )ra   rq   )r   rg   r   rh   rA   r   r   rk   r+   r,   r0   )r   r   r1   r2   r   r   r   Ú#test_grouper_getting_correct_binnerD  s    " z0TestGrouping.test_grouper_getting_correct_binnerc             C   s    t |jdƒjƒddgkst‚d S )Nr   r5   r4   )Úsortedr   Úgrouperr$   )r   r   r   r   r   Útest_grouper_iter[  s    zTestGrouping.test_grouper_iterc          	   C   s(   t jtdd�� |jg ƒ W d Q R X d S )NzNo group keys passed!)r   )r   r   r"   r   )r   r   r   r   r   Útest_empty_groups^  s    zTestGrouping.test_empty_groupsc             C   s2   |j dƒ}|j |jƒjƒ }|jƒ }tj||ƒ d S )Nr   )r   rŽ   r*   r,   r0   )r   r   r'   r1   r2   r   r   r   Útest_groupby_grouperc  s    
z!TestGrouping.test_groupby_grouperc             C   sä   ddl m} |ddiƒ}|jddiƒjtƒ}|jdgƒjtƒ}tj||ƒ |dddd	gtd
ƒd�}dddddœ}|j|ƒjƒ }|j|ƒjt	jƒ}|jddddgƒjƒ }|jddddgƒjƒ }tj||ƒ tj||ƒ tj||ƒ d S )Nr   )r   ZT1rM   ZT2g      ð?g       @g      @g      @r@   )rS   r   )rw   rx   r(   Úd)
Úpandasr   r   r.   r+   r,   r-   rA   r*   r/   )r   r   ru   r1   r2   Úmappingr>   Z	expected2r   r   r   Útest_groupby_dict_mappingj  s    z&TestGrouping.test_groupby_dict_mappingc          
   C   sR   t dddd�}ttjjdƒ|d�}d}tjt|d�� |jdd	„ ƒ W d Q R X d S )
Nz01-Jan-2013r   ZMS)rq   ra   )rS   z4Grouper result violates len\(labels\) == len\(data\))r   c             S   s   | dd… S )Nr   r   r   )r`   r   r   r   rO   �  s    zDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>)	r   r   r/   r;   r<   r   r   r$   r   )r   rl   Útsr&   r   r   r   Ú%test_groupby_grouper_f_sanity_checked~  s
    z2TestGrouping.test_groupby_grouper_f_sanity_checkedc             C   s6   d}t jt|d�� t|j|ddg ƒ W d Q R X d S )NzEGrouper for '<class 'pandas.core.frame.DataFrame'>' not 1-dimensional)r   r   )r   r   r"   r	   rS   )r   r   r&   r   r   r   Ú%test_grouping_error_on_multidim_input�  s    z2TestGrouping.test_grouping_error_on_multidim_inputc             C   s\   t jdddgdddgddd	ggƒ}t jjdddgƒ|_|jdd
dgd�jƒ }tj||ƒ d S )Nr   r   r    r   rM   r   é   r   é	   r   )rn   rd   )r   r   )r   r   )r   r   )	rg   r   r   r{   r   r   Úfirstr,   r0   )r   r   r1   r   r   r   Útest_multiindex_passthru”  s    "z%TestGrouping.test_multiindex_passthruc             C   s´   |j dd�jƒ }|j dd�jƒ }tj||ƒ |j dd�jƒ }|j dd�jƒ }tj||ƒ |j dd	gd�jƒ }|}tj||ƒ |j d
dgd�jƒ }|j ddgd�jƒ }tj||ƒ d S )Nr   )rd   Úsecondr   r›   r€   éþÿÿÿrž   r€   r€   )r   r+   r,   r0   )r   Úmframer1   r2   r   r   r   Útest_multiindex_negative_levelž  s    z+TestGrouping.test_multiindex_negative_levelc             C   s4   t jt|jƒƒ|_|jddd�d jdt jiƒ d S )Nr   F)Zas_indexr   ÚQ)r/   rP   rR   r   r   r.   r*   )r   r   r   r   r   Ú&test_multifunc_select_col_integer_cols°  s    z3TestGrouping.test_multifunc_select_col_integer_colsc             C   sê   ddgddgg}t j|ƒ}tddgg|d�}|jdƒj}|d dgksJt‚|jdgƒj}|d dgksjt‚tddgd	d
gg|d�}|jdƒj}|jdgƒj}||ks¨t‚tddgd	dgg|d�}|jdƒj}|jdgƒj}tj||ƒ d S )Nr#   Úvaluesú	to filterÚ r   r   )r   r   r   r   )r¤   r¥   )r¤   r¥   )r¤   r¥   )r   r{   r   r   Úgroupsr$   r,   Úassert_dict_equal)r   ÚlstZmidxr   r'   r2   r1   r   r   r   Ú#test_multiindex_columns_empty_level¶  s    
z0TestGrouping.test_multiindex_columns_empty_levelc             C   s  t jddddgddddgddddggt jjdddd	gddddggƒd
�}|jdgƒj}|jdƒj}tj||ƒ t j|jt jjdddd	gddddggƒd
�}|jdgƒj}|jdƒj}tj||ƒ t j|jdddd	gd
�}|jdgƒj}|jdƒj}tj||ƒ d S )Nr   r   r    r   rM   r   rw   rx   r(   )r   r’   Úe)rx   r   )rx   r   )rx   r’   )rx   r   )rw   r’   )rx   r’   )rx   rª   )rx   r’   )rx   r   )	rg   r   r   Úfrom_arraysr   r¦   r,   r§   r£   )r   r   r2   r1   Zdf2Zdf3r   r   r   Útest_groupby_multiindex_tupleÎ  s"     $z*TestGrouping.test_groupby_multiindex_tupleÚsortTFc          
   C   sŠ  |}|j ƒ }|jd|d�jƒ }|jd|d�jƒ }|j|d j|d�jƒ }|j|d j|d�jƒ }	d|j_d|	j_|jjdks€t‚|jjdks�t‚tj||ƒ tj||	ƒ |jj|jj	d ksÀt‚|jj|jj	d ksØt‚|jd|d�jƒ }|jd|d�jƒ }tj||ƒ tj||	ƒ |j
jdd|d�jƒ }|j
jdd|d�jƒ }tj||j
ƒ tj||	j
ƒ d}
tjt|
d	�� |jdd
� W d Q R X d S )Nr   )rd   r­   r   r›   )r­   r�   )rd   rn   r­   z2level > 0 or level < -1 only valid with MultiIndex)r   )rd   )rj   r   r+   r£   rS   rt   r$   r,   r0   r\   r‡   r   r   r"   )r   r­   rŸ   r   ÚframeZ	deleveledZresult0Úresult1Z	expected0Z	expected1r&   r   r   r   Útest_groupby_levelç  s2    zTestGrouping.test_groupby_levelc             C   s€   t dgd dgd  tdƒdœƒjdƒ}|dkr6|j}|jd|d	� d
|j|ƒ› �}tjt|d�� |jd|d	� W d Q R X d S )Nr   r    r   r   )ÚexpZvar1r±   r   r   )rd   rn   z&level name foo is not the name of the )r   r4   )r   r   )	r   r!   Ú	set_indexr‡   r   Z_get_axis_namer   r   r"   )r   rn   r   r&   r   r   r   Útest_groupby_level_index_names  s    "z+TestGrouping.test_groupby_level_index_namesc             C   s  t ddgddddggddddddddgddddddddggd�}ttjdƒ|d�}|jd|d�jƒ }td	d
gddgd�}tj||ƒ t ddgddddggddddddddgddddddddggd�}ttjdƒ|d�}|jd|d�jƒ }td	dgddgd�}tj||ƒ d S )Nr   r   r   r    )ÚlevelsÚcodesg       @)rS   )rd   r­   g      @g      6@g      2@g        g      ð?r€   )r   r   r/   rP   r   r+   r,   r-   )r   r­   rS   ru   r1   r2   r   r   r   Útest_groupby_level_with_nas  s    ,,z(TestGrouping.test_groupby_level_with_nasc             C   sZ   |}d}t jt|d�� |jƒ  W d Q R X d}t jt|d�� |jd d d� W d Q R X d S )Nz*You have to supply one of 'by' and 'level')r   )Zbyrd   )r   r   Ú	TypeErrorr   )r   rŸ   r®   r&   r   r   r   Útest_groupby_args5  s    zTestGrouping.test_groupby_argszsort,labelsr   r   r   r    c             C   s4   |j d|d�}tj|tjƒ}tj|jjd |ƒ d S )Nr   )rd   r­   )r   r/   r…   Úintpr,   Úassert_almost_equalrŽ   rµ   )r   r­   ÚlabelsrŸ   r'   Ú
exp_labelsr   r   r   Útest_level_preserve_orderA  s    	z&TestGrouping.test_level_preserve_orderc             C   sN   |j |jjdƒƒ}tjddddddddddg
tjd�}tj|jj	d |ƒ d S )Nr   r   r   r    )rc   )
r   rS   Zget_level_valuesr/   r…   r¹   r,   rº   rŽ   rµ   )r   rŸ   r'   r¼   r   r   r   Útest_grouping_labelsN  s    $z!TestGrouping.test_grouping_labelsc             C   s”   t jdt jdddd�iƒ}t j|jd< t jddd�}|j|gƒ}t jd	ƒt jt	t
d
ƒƒƒi}tj|j|ƒ |j|ƒ}t jd	ƒdi}tj|j|ƒ d S )NrX   z1/1/2011im  r9   )rq   ra   r   ZAS)r`   ra   z
2011-01-01il  r€   )rg   r   r   ZNaTrF   rk   r   r   r   rA   r!   r,   r§   r¦   )r   r   rŽ   r1   r2   r   r   r   Útest_list_grouper_with_natS  s    
z'TestGrouping.test_list_grouper_with_natzfunc,expectedZ	transform)rt   rc   rS   r.   )rt   rT   c             C   s@   t jg g dœƒ}|jdƒ}t|d |ƒdd„ ƒ}tj||ƒ d S )N)r   r   r   r   c             S   s   | S )Nr   )rN   r   r   r   rO   {  s    z>TestGrouping.test_evaluate_with_empty_groups.<locals>.<lambda>)rg   r   r   Úgetattrr,   r-   )r   Úfuncr2   r   r   r1   r   r   r   Útest_evaluate_with_empty_groupsc  s    
z,TestGrouping.test_evaluate_with_empty_groupsc             C   sº   t jg ddd�}|jg ƒ}|jƒ }tj||ƒ t|jjƒdksBt	‚tj
|jjd tjg tjdƒd�ƒ tj
|jjd tjg tjdƒd�ƒ |jjd	 dksžt	‚|j|ƒjjdgks¶t	‚d S )
Nrt   Úfloat64)rt   rc   r   r   rb   )rc   r†   r   )rg   r   r   r*   r,   r-   rR   rŽ   Ú	groupingsr$   Zassert_numpy_array_equalZ
group_infor/   r…   rc   r\   )r   ru   Úgrr1   r   r   r   Útest_groupby_empty~  s    
  zTestGrouping.test_groupby_emptyc             C   sŽ   t dtjdgd tjdggdddgd�jddgƒ}|jddgd�jƒ }t g ttdgd	d
�tg dd
�gg g gddgd�dgdd�}tj	||ƒ d S )NrN   rL   é   r   r   r   )r   )rd   Úobject)rc   rÃ   )r´   rµ   r\   rb   )r   rS   r   rc   )
r   r/   Únanr²   r   r+   r   r   r,   r0   )r   r   r1   r2   r   r   r   Ú%test_groupby_level_index_value_all_na•  s    $

z2TestGrouping.test_groupby_level_index_value_all_nac             C   sz   t jdddgdddggdddgd	�}|jddgƒ}||jd
k  }|jdƒjƒ }t jddgt jg dd�d�}tj||ƒ d S )Né{   rw   g      ð?rx   g       @ÚidÚcategoryÚvalue)r   r   rÃ   )rt   )rc   r   rS   )	rg   r   r²   rÎ   r   r+   Z
Int64Indexr,   r0   )r   r   Úemptyr1   r2   r   r   r   Ú#test_groupby_multiindex_level_empty§  s     z0TestGrouping.test_groupby_multiindex_level_emptyN))rH   rI   rJ   rW   rm   rv   r}   r�   rˆ   rŒ   r�   r�   r‘   r•   r—   r˜   rœ   r    r¢   r©   r¬   r   ÚmarkZparametrizer°   r³   r¶   r¸   r½   r¾   r¿   rg   r   r/   rÃ   Z
RangeIndexZFloat64IndexrÂ   rÆ   rÊ   rÐ   r   r   r   r   rK   „   sN   C"
)(	*rK   c               @   s<   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zdd„ ZdS )ÚTestGetGroupc             C   sŠ  t tjddddddgƒddddddgddddd	d
gdœƒ}|jdƒ}t|jƒd }|j|ƒ}|jt|ƒjƒ ƒ}|jt	t|ƒƒƒ}t
j||ƒ t
j||ƒ |jddgƒ}t|jƒd }|j|ƒ}|jt|d ƒjƒ |d fƒ}|jt	t|d ƒƒ|d fƒ}t
j||ƒ t
j||ƒ d}tjt|d�� |jdƒ W d Q R X tjt|d�� |jdƒ W d Q R X d}tjt|d�� |jdƒ W d Q R X d S )Nz10-Oct-2013z11-Oct-2013r4   r5   r   r   r    r   rM   r   )ÚDATEÚlabelZVALrÓ   r   rÔ   z<must supply a tuple to get_group with multiple grouping keys)r   zHmust supply a same-length tuple to get_group with multiple grouping keysÚbaz)r4   r5   rÕ   )r   rg   Úto_datetimer   rA   r¦   Ú	get_groupr   Zto_pydatetimeÚstrr,   r0   r   r   r"   )r   r   r   r`   r¯   r>   Zresult3r&   r   r   r   Útest_get_groupº  s@    


zTestGetGroup.test_get_groupc             C   sž   t jddddgƒ}ddddg}|jt j|d |ƒ|d	�}|jt jddƒƒ}tddgddgd
�}tj||ƒ d}tj	t
|d�� |jt jddƒƒ W d Q R X d S )Nr    r   r™   r   r   rM   rL   é   )r„   )rS   z"Interval\(10, 15, closed='right'\))r   )rg   r   r   Zcutr×   ZIntervalr,   r0   r   r   r   )r   r„   r’   Zbinsr   r1   r2   r&   r   r   r   Útest_get_group_empty_binsé  s    z&TestGetGroup.test_get_group_empty_binsc             C   sÂ   t d
dddggdgd�j}|jdƒ}t dddgiddgd�}|jdƒ}tj||ƒ tjddddgƒ}t ddd	„ |D ƒiƒ}|jdƒ}|jdƒ}t d|d f|d fgiddgd�}tj||ƒ d S )Nr   r   Úids)rS   r   ú
2010-01-01z
2010-01-02c             S   s   g | ]
}|f‘qS r   r   )Ú.0rN   r   r   r   ú
<listcomp>  s    z@TestGetGroup.test_get_group_grouped_by_tuple.<locals>.<listcomp>)r   )r   r   )r   )r   r   )r   )r   )r   )rÝ   )r   r‡   r   r×   r,   r0   rg   rÖ   )r   r   rÅ   r2   r1   Údtr   r   r   Útest_get_group_grouped_by_tupleù  s    



$z,TestGetGroup.test_get_group_grouped_by_tuplec             C   sN   t jf ƒ}f }t j||td�}t jdd�}|j|ƒ}tt|ƒd ƒd ksJt‚d S )N)rc   r9   )ra   )	rg   ÚDatetimeIndexr   rÈ   rk   r   ÚnextÚiterr$   )r   rS   r   ZseriesrŽ   r'   r   r   r   Útest_groupby_with_empty  s    

z$TestGetGroup.test_groupby_with_emptyc             C   s˜   t jdtdƒiƒ}tj|jdƒjdƒ|jddg ƒ t jt jdddgdd�d�}tj|jdƒj	ƒ |ƒ tj|jdƒj
ƒ |ƒ tj|jdƒjd	ƒ|ƒ d S )
Nrw   Zabssbabr   rM   rx   ru   )rt   )rS   r   )rg   r   rA   r,   r0   r   r×   rF   r   r#   r+   Znth)r   r   r±   r   r   r   Útest_groupby_with_single_column  s    "z,TestGetGroup.test_groupby_with_single_columnc             C   s~   t jddddgddddgddddggd	d
ddgd�}|jd	d
gƒ}|jd	d
dgƒjƒ }|jd dksht‚|jd dkszt‚d S )Nr4   r5   r   r   r   rÕ   r   r    r›   r�   Zthirdr6   )r   )r4   r5   r   )r4   rÕ   r   )rg   r   r²   r   r%   r=   r$   )r   r   r   r   r   Útest_gb_key_len_equal_axis_len  s     z+TestGetGroup.test_gb_key_len_equal_axis_lenN)	rH   rI   rJ   rÙ   rÛ   rá   rå   ræ   rç   r   r   r   r   rÒ   ¹  s   /	rÒ   c               @   sD   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S )ÚTestIterationc             C   sÌ   |j dgƒ}|j}||jks t‚x0|jjƒ D ]"\}}|j| d |kjƒ s,t‚q,W |j ddgƒ}|j}||jkstt‚xR|jjƒ D ]D\}}|j| d |d kjƒ s¦t‚|j| d |d kjƒ s€t‚q€W d S )Nr   r   r   r   )r   r¦   r$   Úitemsr=   Úall)r   r   r'   r¦   ÚkÚvr   r   r   Útest_groups,  s    zTestIteration.test_groupsc             C   s0   |j dd„ dd„ gƒ}x|jjd D ]}q$W d S )Nc             S   s   | j ƒ S )N)Úweekday)rN   r   r   r   rO   ?  s    z9TestIteration.test_grouping_is_iterable.<locals>.<lambda>c             S   s   | j S )N)Úyear)rN   r   r   r   rO   ?  s    r   )r   rŽ   rÄ   )r   Ztsframer'   r   r   r   r   Útest_grouping_is_iterable<  s    z'TestIteration.test_grouping_is_iterablec             C   sä   t tjdƒƒ}tjddddddgƒ}tjddddddgƒ}|j||gƒ}t|ƒ}dd|ddg fdd|dg fdd|d	g fdd|d
dg fg}xNt|ƒD ]B\}\\}}	}
|| \}}}||ksÄt‚||	ksÐt‚tj	|
|ƒ qšW d S )Nr   rw   rx   Ú1Ú2r   r   r   r   r    rM   )
r   r/   rP   r…   r   rA   Ú	enumerater$   r,   r-   )r   ru   Úk1Úk2r'   Úiteratedr2   Úir6   r7   r8   Úe1Úe2Úe3r   r   r   Útest_multi_iterE  s    zTestIteration.test_multi_iterc             C   sÄ  t jddddddgƒ}t jddddddgƒ}tt jjdƒt jjdƒ||dœddd	d
ddgd�}|jddgƒ}t|ƒ}|j}dd|j|dg  fdd|j|ddg  fdd|j|ddg  fdd|j|dg  fg}xRt	|ƒD ]F\}	\\}
}}||	 \}}}||
k�st
‚||k�st
‚tj||ƒ qÜW t jddddddgƒ|d< t jddddddgƒ|d< |jddgƒ}dd„ |D ƒ}t|ƒdk�sˆt
‚|jdddgƒjƒ }|jjddd�}x|D ]
\}}�q²W d S )Nrx   rw   rñ   rò   r   )Zv1Zv2rô   rõ   r6   r7   r8   ZfourZfiveÚsix)rS   rô   rõ   r   r    rM   r   r   r   c             S   s   i | ]\}}||“qS r   r   )rÞ   r`   Zgpr   r   r   ú
<dictcomp>v  s    z7TestIteration.test_multi_iter_frame.<locals>.<dictcomp>r   r   r   )rn   rd   )r   r   )r/   r…   r   r;   r<   r   rA   rS   r=   ró   r$   r,   r0   rR   r*   r‡   )r   Zthree_grouprô   rõ   r   r'   rö   r|   r2   r÷   r6   r7   r8   rø   rù   rú   r¦   Zthree_levelsr`   Úgroupr   r   r   Útest_multi_iter_frameY  s4    z#TestIteration.test_multi_iter_framec             C   s˜   t t|jdƒƒƒ t t|jddgƒƒƒ t t|d j|d ƒƒƒ t t|d j|d |d gƒƒƒ t t|jdƒd ƒƒ t t|jddgƒd ƒƒ d S )Nr   r   r   )Údicträ   r   )r   r   r   r   r   Útest_dictify  s    "zTestIteration.test_dictifyc             C   s0  t jddgddgdœt jddgƒd�}|jt jdd	�d
gƒ}t|jƒdksNt‚|jdks\t‚t j	dƒdf|jkstt‚t j	dƒdf|jksŒt‚|j
t j	dƒdfƒ}tj||jdgd d …f ƒ |j
t j	dƒdfƒ}tj||jdgd d …f ƒ t jdddgdddgdœt jdddgƒd�}|jt jdd	�d
gƒ}t|jƒdk�sBt‚|jdk�sRt‚t j	dƒdf|jk�slt‚t j	dƒdf|jk�s†t‚|j
t j	dƒdfƒ}tj||jddgd d …f ƒ |j
t j	dƒdfƒ}tj||jdgd d …f ƒ t jdddgdddgdœt jdddgƒd�}|jt jdd	�d
gƒ}t|jƒdk�s>t‚|jdk�sNt‚t j	dƒdf|jk�sht‚t j	dƒdf|jk�s‚t‚t j	dƒdf|jk�sœt‚|j
t j	dƒdfƒ}tj||jdgd d …f ƒ |j
t j	dƒdfƒ}tj||jdgd d …f ƒ |j
t j	dƒdfƒ}tj||jdgd d …f ƒ d S )NÚstartiÒ  i.  )ÚeventZchangez
2014-09-10z
2013-10-10)rS   rr   )ra   r  r   z
2014-09-30z
2013-10-31r   r   i£#  z
2014-09-15z
2014-08-05r    z
2014-08-31)rg   r   râ   r   rk   rR   r¦   r$   Zngroupsr   r×   r,   r0   rF   )r   r   r'   Úresr   r   r   Útest_groupby_with_small_elem‡  sN    z*TestIteration.test_groupby_with_small_elemc             C   s\   t jtdƒtdƒgƒ}tdddgg|d�}|j|d ƒ}|jjd	 jƒ }d
}||ksXt‚d S )NZAABZabar   r   r    )r   r   rw   r   zGrouping(('A', 'a')))r   rw   )	r   r«   rA   r   r   rŽ   rÄ   Ú__repr__r$   )r   Úmir   rÅ   r1   r2   r   r   r   Útest_grouping_string_repr»  s    z'TestIteration.test_grouping_string_reprN)
rH   rI   rJ   rí   rð   rû   rÿ   r  r  r  r   r   r   r   rè   +  s   	&4rè   )Ú__doc__Znumpyr/   r   r“   rg   r   r   r   r   r   r   r   Zpandas._testingZ_testingr,   Zpandas.core.groupby.grouperr	   r
   rK   rÒ   rè   r   r   r   r   Ú<module>   s   $	
m    9r