3
®ybDc  ã               @   sL   d dl Zd dlZd dlmZmZmZmZmZm	Z	 d dl
jZG dd„ dƒZdS )é    N)ÚCategoricalIndexÚ	DataFrameÚIndexÚ
MultiIndexÚSeriesÚcrosstabc               @   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$d2gd3d&ggƒd'd(„ ƒZd)d*„ Zd+d,„ Zd-d.„ Zd/d0„ Zd1S )4ÚTestCrosstabc             C   s„   t dddddddddddgdddddddddddgddd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 S )NÚfooÚbarÚoneÚtwoÚdullÚshinyé   )ÚAÚBÚCÚDÚEÚFT)Zignore_index)r   ÚnpÚrandomÚrandnÚappendÚdf)ÚselfÚmethodr   © r   úF/tmp/pip-install-4cy230dp/pandas/pandas/tests/reshape/test_crosstab.pyÚsetup_method	   sL    

zTestCrosstab.setup_methodc             C   sL   | j }t|d |d ƒ}|jddgƒjƒ jƒ }tj||jdƒjt	j
ƒƒ d S )Nr   r   r   )r   r   ÚgroupbyÚsizeÚunstackÚtmÚassert_frame_equalÚfillnaÚastyper   Úint64)r   r   ÚresultÚexpectedr   r   r   Útest_crosstab_single;   s    z!TestCrosstab.test_crosstab_singlec             C   s´   | j }t|d |d |d gƒ}|jdddgƒjƒ }|jdƒjdƒjdƒjtjƒ}t	j
||ƒ t|d |d g|d ƒ}|jdddgƒjƒ }|jdƒjdƒjtjƒ}t	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   Útest_crosstab_multipleA   s    z#TestCrosstab.test_crosstab_multiplec             C   sþ   t jjdddd�}t jjdddd�}t jjdddd�}t|||dœƒ}t|||gdgdd�}t|d |d	 |d
 gƒ}tj||ƒ t||g|dgdd�}t|d	 |d
 g|d ƒ}tj||ƒ t| jd j| jd jƒ}|j	j
dksèt‚|jj
dk� sút‚d S )Nr   é   éd   )r!   é   é
   )ÚaÚbÚcr0   r1   r2   )ÚrownamesÚcolnames)r4   r3   r   r   Úrow_0Úcol_0)r1   r2   )r1   r2   )r   r   Úrandintr   r   r#   r$   r   ÚvaluesÚindexÚnameÚAssertionErrorÚcolumns)r   r0   r1   r2   r   r(   r)   r   r   r   Útest_crosstab_ndarrayN   s    z"TestCrosstab.test_crosstab_ndarrayc             C   sª   t dddgdddgd�}t dddddgdddd	d
gd�}tjdddgƒ}tddgddggtddgdd�tddgdd�d�}t||ƒ}tj||ƒ t||ƒ}tj||ƒ d S )Nr   é   r0   r1   r2   )r9   r.   é   ÚdÚfr5   )r:   r6   )r9   r<   )r   r   Úarrayr   r   r   r#   r$   )r   r0   r1   r2   r)   r(   r   r   r   Útest_crosstab_non_alignedb   s     

z&TestCrosstab.test_crosstab_non_alignedc             C   sH  t jjdddd�}t jjdddd�}t jjdddd�}t|||dœƒ}t|||gdgddd�}|jjdksnt‚|jjd	d
gks‚t‚|d }|j	dgƒj
ƒ jdƒ}tt|ƒgtdgdd�d�}|j|ƒ}d|_tj||ƒ |jd }	|j	d	d
gƒj
ƒ jdƒ}
|
jtt|ƒgdgd�ƒ}
d|
_|
j|	jƒ}
|
jdƒjt jƒ}
tj|	|
ƒ d S )Nr   é   r-   )r!   r.   r,   )r0   r1   r2   r0   r1   r2   T)r3   r4   ÚmarginsÚAllÚ Úi8)r:   )r9   )r1   r2   )r0   )rF   rG   )rF   rG   )rF   rG   )r   r   r7   r   r   r9   Únamesr;   r<   r    r!   r&   r   Úlenr   r   r:   r#   Úassert_series_equalÚlocÚreindexr%   r'   )r   r0   r1   r2   r   r(   Úall_colsÚexp_colsÚ
exp_marginÚall_rowsÚexp_rowsr   r   r   Útest_crosstab_marginst   s(    

z"TestCrosstab.test_crosstab_marginsc             C   sœ  t jjdddd�}t jjdddd�}t jjdddd�}t|||dœƒ}t|||gdgdddd�}|jjdkspt‚|jjd	d
gks„t‚|d }|j	dgƒj
ƒ jdƒ}tt|ƒgtdgdd�d�}|j|ƒ}d|_tj||ƒ |jd }	|j	d	d
gƒj
ƒ jdƒ}
|
jtt|ƒgdgd�ƒ}
d|
_|
j|	jƒ}
|
jdƒjt jƒ}
tj|	|
ƒ d}xLdd dd	ggD ]:}tjt|d��  t|||gdgdd|d� W d Q R X �qZW d S )Nr   rD   r-   )r!   r.   r,   )r0   r1   r2   r0   r1   r2   TÚTOTAL)r3   r4   rE   Úmargins_namerG   rH   )r:   )r9   z&margins_name argument must be a stringiš  )Úmatch)r1   r2   )r0   )rT   rG   )rT   rG   )rT   rG   )r1   r2   )r   r   r7   r   r   r9   rI   r;   r<   r    r!   r&   r   rJ   r   r   r:   r#   rK   rL   rM   r%   r'   ÚpytestÚraisesÚ
ValueError)r   r0   r1   r2   r   r(   rN   rO   rP   rQ   rR   ÚmsgrU   r   r   r   Ú%test_crosstab_margins_set_margin_name’   sH    

z2TestCrosstab.test_crosstab_margins_set_margin_namec             C   sœ   t jjdddd�}t jjdddd�}t jjdddd�}t jjdƒ}t||g||t jddgd	gd
�}t||||dœƒ}|jdddgd	t jd�}tj	||ƒ d S )Nr   rD   r-   )r!   r.   r,   r	   r
   Úbaz)Úaggfuncr3   r4   )r	   r
   r\   r8   r8   )r9   r<   r]   )
r   r   r7   r   r   Úsumr   Zpivot_tabler#   r$   )r   r0   r1   r2   r8   Útabler   r)   r   r   r   Útest_crosstab_pass_valuesÄ   s    z&TestCrosstab.test_crosstab_pass_valuesc             C   sœ   t jdddddddgtd�}t jdddddddgtd�}t jdddddddgtd�}t|||gdgd	d
gdd�}tjddddgd	d
gd�}tj|j|ƒ d S )Nr	   r
   )Údtyper   r   r   r   r0   r1   r2   F)r3   r4   Údropna)rI   )r   r   )r   r   )r   r   )r   r   )	r   rB   Úobjectr   r   Úfrom_tuplesr#   Zassert_index_equalr<   )r   r0   r1   r2   ÚresÚmr   r   r   Útest_crosstab_dropnaÕ   s    
z!TestCrosstab.test_crosstab_dropnac             C   sP   t dddgdddgd�}t dddgdddgd�}t||ƒ}tƒ }tj||ƒ d S )Nr>   é   r.   )r9   r?   r,   é   )r   r   r   r#   r$   )r   Ús1Ús2Úactualr)   r   r   r   Útest_crosstab_no_overlapã   s
    
z%TestCrosstab.test_crosstab_no_overlapc             C   s  t dddddtjgddddddgdœƒ}t|j|jddd�}t dddgdddgddd	ggƒ}td
ddgdd�|_tdddgdd�|_t	j
||ƒ t dtjtjtjdtjgdtjddddgdœƒ}t|j|jddd�}t dddgdddgdddggƒ}td
ddgdd�|_tdddgdd�|_t	j
||ƒ t dtjtjtjtjdgddddddgdœƒ}t|j|jddd�}t dddgdddgdddggƒ}td
ddgdd�|_tdddgdd�|_t	j
||ƒ t dddddtjgddddddgdœƒ}t|j|jddd�}t dddgdddgdddggƒ}td
ddgdd�|_tdddgdd�|_t	j
||ƒ t dtjtjtjdtjgdtjddddgdœƒ}t|j|jddd�}t dddgdddgdddggƒ}td
ddgdd�|_tdddgdd�|_t	j
||ƒ tjdddddddgtd�}tjdddddtjdgtd�}tjdddddddgtd�}t|||gdgddgddd�}tjdddddgdddddggddgd�}t dddddgddddd	gdddddgg|d �}tdddgdd�|_t	j
||ƒ t||g|ddgdgddd�}tjdddddgdddddggddgd�}t dddgdddgdddgdddgd	ddgg|d!�}tdddgdd�|_t	j
||ƒ t||g|ddgdgddd�}tjdddddgdddddggddgd�}t dddgdddgdddgdddgd	ddgg|d!�}tdddgdd�|_t	j
||ƒ d S )"Nr>   rh   r.   r?   )r0   r1   T)rE   rb   r   r,   g      ð?g       @rF   r0   )r:   r1   g      @g      @Fri   r	   r
   )ra   r   r   r   r   r2   )r3   r4   rE   rb   rG   )rI   rD   )r<   )r9   )r   r   Únanr   r0   r1   r   r9   r<   r#   r$   rB   rc   r   Úfrom_arrays)r   r   rl   r)   r0   r1   r2   rf   r   r   r   Útest_margin_dropnaî   s‚    ( . , ( . .22zTestCrosstab.test_margin_dropnac             C   s®  t dddddgdddddgddtjddgdœƒ}tddgdd�}tddgdd�}t d	d
gd	dgg||d�}t dd
gddgg||d�}t dd
gddgg||d�}tjt|j|jdd�|ƒ tjt|j|jdd�|ƒ tjt|j|jdd�|ƒ tjt|j|jdd�|ƒ tjt|j|jdd�t|j|jdd�ƒ tjt|j|jd
d�t|j|jdd�ƒ t dd
gddgddggtdddgddd�tddgddd�d�}t dd
d	gdddggtddgddd�tdddgddd�d�}t d	d
d	gd	ddgdddggtdddgddd�tdddgddd�d�}	tjt|j|jddd�|ƒ tjt|j|jddd�|ƒ tjt|j|jddd�|	ƒ ttj	ddddgƒtj	ddddgƒgtj	ddddgƒƒ t dd
dgdddgdddggtdddgddd�tdddgdd�d�}
t|j|j|j
dddd�}tj||
ƒ t dddddgdddddgd
dtjddgdœƒ}t d
d
dgdddgdddggtdddgddd�tdddgddd�d�}t|j|j|j
tjddd�}tj||ƒ d S )Nr>   rh   r.   r?   )r0   r1   r2   r0   )r:   r1   gš™™™™™É?r   g333333ã?)r9   r<   g      ð?g      Ð?g      è?g      à?Úall)Ú	normalizeTr9   r<   gš™™™™™Ù?rF   rc   )r:   ra   gš™™™™™é?)rr   rE   Úcount)r]   rr   rE   g        )r   r   rn   r   r#   r$   r   r0   r1   rB   r2   r^   )r   r   ÚrindexZcindexZfull_normalZ
row_normalZ
col_normalZrow_normal_marginsZcol_normal_marginsZall_normal_marginsZnorm_countsZ	test_caseZnorm_sumr   r   r   Útest_crosstab_normalizeO  sh    .$6.z$TestCrosstab.test_crosstab_normalizec             C   sü   t dddddgdddddgtjtjtjtjtjgdœƒ}t ddgddggtddgddd	�tddgd
d�d�}x0dD ](}t|j|j|jd|d�}tj	||ƒ qrW t dtjgddggtddgddd	�tddgd
d�d�}t|j|j|jddd�}tj	||ƒ d S )Nr>   rh   r.   r?   )r0   r1   r2   g        r0   r'   )r:   ra   r1   )r:   )r9   r<   Tr9   r<   rs   )r8   r]   rr   F)Tr9   r<   )
r   r   rn   r   r   r0   r1   r2   r#   r$   )r   r   ÚemptyÚiZ
calculatedZnansr   r   r   Útest_crosstab_with_empties   s"    
z'TestCrosstab.test_crosstab_with_emptiesc          )   C   s&  t dddddgdddddgddtjddgdœƒ}d}tjt|d�� t|j|j|j	d� W d Q R X d	}tjt|d�� t|j|jtj
d
� W d Q R X d}tjt|d�� t|j|jdd� W d Q R X tjt|d�� t|j|jdd� W d Q R X d}tjt|d�� t|j|jddd� W d Q R X d S )Nr>   rh   r.   r?   )r0   r1   r2   z)values cannot be used without an aggfunc.)rV   )r8   z%aggfunc cannot be used without values)r]   zNot a valid normalize argumentZ42)rr   é*   zNot a valid margins argumentrq   )rr   rE   )r   r   rn   rW   rX   rY   r   r0   r1   r2   Zmean)r   r   Úerrorr   r   r   Útest_crosstab_errors½  s     .z!TestCrosstab.test_crosstab_errorsc             C   s¸   t ddddddgddddddgdœƒ}dddg}|d jd	ƒjj|ƒ|d< t|d
 |d ƒ}tdddgd
d�}t||ddd�}dddgdddgdddgg}t |||d�}tj||ƒ d S )NZHondaZAcuraZTeslaZSedanZElectricZPickup)ÚMAKEÚMODELr}   Úcategoryr|   )r:   F)Ú
categoriesÚorderedr:   rh   r   r>   )r9   r<   )	r   r&   ÚcatZset_categoriesr   r   r   r#   r$   )r   r   r   r(   Úexpected_indexZexpected_columnsÚexpected_datar)   r   r   r   Ú%test_crosstab_with_categorial_columns×  s    
z2TestCrosstab.test_crosstab_with_categorial_columnsc             C   s^  t ddddgd dddgd d	d	d	d
d
d
gd tjjdƒtjjdƒdœƒ}t|d |d g|d gdtj|d d�}tddddgddddggddddddddddg
ddddddddddg
gddgd�}td
d	dgddd�}tjdddgdddgdddgdtj	dgtj	ddgdtj	dgtj	ddgdtj	dgtj	ddgdddgg
ƒ}t |||d�}t
j||ƒ d S )Nr   r   Úthreeri   r   r   r   é   r	   r
   r?   é   )r   r   r   r   r   Tr   )r9   r<   rE   r]   r8   rF   rG   r>   rh   r.   r   )ÚlevelsÚcodesrI   rc   )ra   r:   g       @g      @g      (@g      8@)r9   r<   )r   r   r   r   r   r!   r   r   rB   rn   r#   r$   )r   r   r(   r‚   Zexpected_columnrƒ   r)   r   r   r   Útest_crosstab_with_numpy_sizeí  s>    
.





z*TestCrosstab.test_crosstab_with_numpy_sizec             C   sT   t tdƒdd�}t||ƒ}ttdƒdd�}ttjdtjd�||d�}tj	||ƒ d S )Nr.   r	   )r:   )ra   )r9   r<   )
r   Úranger   r   r   r   Úeyer'   r#   r$   )r   Úsr(   r‚   r)   r   r   r   Útest_crosstab_dup_index_names  s    
z*TestCrosstab.test_crosstab_dup_index_namesrI   r0   r1   r2   c             C   sv   t tdƒ|d d�}t tddƒ|d d�}tjtdƒtddƒg|d�}t d|d�jddd�}t||ƒ}tj||ƒ d S )	Nr.   r   )r:   r>   r?   )rI   )r9   )Z
fill_value)r   r‹   r   ro   r"   r   r#   r$   )r   rI   rj   rk   Úmir)   r(   r   r   r   Útest_crosstab_tuple_name#  s    
z%TestCrosstab.test_crosstab_tuple_namec             C   sj   t tdƒd
d�}t tdƒdd�}ttjddd�ttdƒdd�ttdƒdd�d	�}t||ƒ}tj||ƒ d S )Nr.   r0   r1   )r:   r2   r@   r'   )ra   )r9   r<   )r0   r1   )r2   r@   )r0   r1   )r2   r@   )	r   r‹   r   r   rŒ   r   r   r#   r$   )r   rj   rk   r)   r(   r   r   r   Útest_crosstab_both_tuple_names.  s    
z+TestCrosstab.test_crosstab_both_tuple_namesc             C   s˜   t dddgdddgdœdd	d
gd�}t|j|j|jgƒ}td	d
dgdd�}tjdddgddgd�}t dddgdddgdddgg||d�}tj	||ƒ d S )Nr.   r>   rh   r,   r?   ri   )r1   r0   r   r   r   )r9   r5   )r:   r1   r0   )rI   r   )r9   r<   )r>   r?   )rh   ri   )r.   r,   )
r   r   r9   r1   r0   r   r   rd   r#   r$   )r   r   r(   Ze_idxZ	e_columnsr)   r   r   r   Útest_crosstab_unsorted_order;  s    $$z)TestCrosstab.test_crosstab_unsorted_orderc             C   sÖ   t ddddgd dddgd d	d	d	d
d
d
gd dgd dgd dœƒ}t|j|jg|j|jtjddd�}t tjdgd dg t	d�j
ddƒtd
d	dgddd�tjddddd d!d"d#d$d%g
ddgd�d�}tj||ƒ d S )&Nr   r   r…   ri   r   r   r   r†   r	   r
   r?   r   r‡   )r   r   r   r   r   T)r8   r]   rr   rE   é   r>   )ra   r/   r.   rF   rc   )ra   r:   rG   )rI   )r<   r9   )r   r   )r   r   )r   r   )r…   r   )r…   r   )r…   r   )r   r   )r   r   )r   r   )rF   rG   )r   r   r   r   r   r   r   r^   rB   ÚfloatZreshaper   r   rd   r#   r$   )r   r   r(   r)   r   r   r   Ú(test_crosstab_normalize_multiple_columnsE  s:    
 z5TestCrosstab.test_crosstab_normalize_multiple_columnsc             C   sT  t dddddddddg	dddddddddg	dddddddddg	dddd	d	d
dddg	dd
dddddddg	dœƒ}t|j|jg|jdddd�}t ddgddgddgddgddggƒ}tdddgdddggdddddgdddddggddgd�|_tddgddd �|_t	j
||ƒ t|j|jg|jdddd�}t d!d"d#gd!d"d#gdd"dgdd$d#ggƒ}tdddgddd �|_tddgddggddddgddddggddgd�|_t	j
||ƒ t|j|jg|jdddd�}t d%d%d#gd%d%d#gd#d%dgd&d#d#gdd'dggƒ}tdddgddd �|_tdddgdddggdddddgdddddggddgd�|_t	j
||ƒ d S )(Nr	   r
   r   r   ÚsmallZlarger>   rh   r.   r?   r,   ri   rD   r†   é	   )r   r   r   r   r   Tz	Sub-Totalr   )rE   rU   rr   g      à?g]QJVUå?gF]kïSUÕ?g³Ñ9?ÅqÜ?g'c`Çá?rG   r   r   )rˆ   r‰   rI   rc   r   )ra   r:   g      Ð?gš™™™™™É?g³Ñ9?ÅqÌ?gš™™™™™Ù?g³Ñ9?Åq¼?g        g#„GÇá?)r   r   r   r   r   r   r9   r   r<   r#   r$   )r   r   r(   r)   r   r   r   Útest_margin_normalizem  sj    $z"TestCrosstab.test_margin_normalizeN)r1   r2   )r0   r1   )Ú__name__Ú
__module__Ú__qualname__r   r*   r+   r=   rC   rS   r[   r`   rg   rm   rp   ru   rx   r{   r„   rŠ   rŽ   rW   ÚmarkZparametrizer�   r‘   r’   r•   r˜   r   r   r   r   r      s,   22aQ+"
(r   )Znumpyr   rW   Zpandasr   r   r   r   r   r   Zpandas._testingZ_testingr#   r   r   r   r   r   Ú<module>   s    
