3
Êb_@d ã               @   sö   d dl mZm Z 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d dlmZ d dlmZmZ ejddgd	�d
d„ ƒZejd gd dgd fed dƒeddƒfgd	�dd„ ƒZG dd„ dƒZG dd„ dƒZ dS )é    )ÚdateÚdatetimeÚ	timedelta)ÚproductN)ÚCategoricalÚ	DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚconcatÚ
date_range)ÚCategoricalDtype)ÚcrosstabÚpivot_tableTF)Úparamsc             C   s   | j S )N)Úparam)Úrequest© r   úA/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/reshape/test_pivot.pyÚdropna   s    r   é   é   é   c             C   s   | j \}}ttjj|||ƒƒS )N)r   r   ÚpdÚIntervalIndexÚfrom_arrays)r   ÚclosedÚleftÚrightr   r   r   Úinterval_values   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ejjdddd gfddd dgfd!dd dgfgƒd"d#„ ƒZ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/d0„ ƒZd1d2„ Zejjd*d+d,gƒd3d4„ ƒZd5d6„ Zejjd7d8d9gejd8d9gƒej d8d9gƒej!d8d9gƒgƒejjd*d+d,gƒd:d;„ ƒƒZ"ejjd7d<d8gejd<d8gƒej d<d8gƒej!d<d8gƒgƒejjd*d+d,gƒd=d>„ ƒƒZ#ejj$d?d@�ejjd*d+d,gƒdAdB„ ƒƒZ%ejjd*d+d,gƒdCdD„ ƒZ&dEdF„ Z'dGdH„ Z(ejj$dId@�dJdK„ ƒZ)dLdM„ Z*dNdO„ Z+dPdQ„ Z,dRdS„ Z-dTdU„ Z.dVdW„ Z/dXdY„ Z0dZd[„ Z1ejjd\d]d^d_d`dadbggƒdcdd„ ƒZ2dedf„ Z3dgdh„ Z4didj„ Z5dkdl„ Z6dmdn„ Z7dodp„ Z8dqdr„ Z9ejj$dsd@�dtdu„ ƒZ:ejj$dsd@�dvdw„ ƒZ;dxdy„ Z<dzd{„ Z=d|d}„ Z>d~d„ Z?d€d�„ Z@d‚dƒ„ ZAd„d…„ ZBejjd†d‡ejCfdˆejDfd‰ejEfd‡dˆgejCejDgfd‡d‰gejCejEgfd‰dˆgejEejDgfgƒdŠd‹„ ƒZFejjGdŒd�„ ƒZHdŽd�„ ZId�d‘„ ZJd’d“„ ZKd”d•„ ZLd`S )–ÚTestPivotTablec             C   sv   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œƒ| _d S )	NÚfooÚbarÚoneÚtwoÚdullÚshinyé   )ÚAÚBÚCÚDÚEÚF)r   ÚnpÚrandomÚrandnÚdata)ÚselfÚmethodr   r   r   Úsetup_method#   sJ    

zTestPivotTable.setup_methodc             C   sì   ddg}d}t | jd|||d�}| jj d|||d�}tj||ƒ t | jd||d� t|ƒdkrt|jjt|ƒksˆt‚n|jj	|d ksˆt‚t|ƒdkr¦|j
j|ksºt‚n|j
j	|d ksºt‚| jj||g ƒd jtjƒjƒ }tj||ƒ d S )	Nr)   r*   r+   r,   )ÚvaluesÚindexÚcolumnsÚobserved)r6   r7   r9   r   r   )r   r2   ÚtmÚassert_frame_equalÚlenr7   ÚnamesÚtupleÚAssertionErrorÚnamer8   ÚgroupbyÚaggr/   ÚmeanÚunstack)r3   r9   r7   r8   ÚtableÚtable2Úexpectedr   r   r   Útest_pivot_tableS   s     "zTestPivotTable.test_pivot_tablec             C   sš   t jtdƒtdƒdddddgdœƒ}|jd	d
dtjdd�}|jjdƒ|_|jjdƒ|_|j	jdƒ|_	|j
jdƒ|_
|jd	d
dtjd|d�}tj||ƒ d S )NZabcdeZfghijr   é   r   r   é   )Úcol1Úcol2Úcol3rK   rM   rL   r   )r7   r6   r8   ÚaggfuncÚ
fill_valueÚcategory)r7   r6   r8   rN   rO   r9   )r   r   Úlistr   r/   Úsumr7   Úastyper8   rK   rL   r:   r;   )r3   r9   ÚdfrG   Úresultr   r   r   Ú+test_pivot_table_categorical_observed_equalo   s      z:TestPivotTable.test_pivot_table_categorical_observed_equalc             C   s†   t dddgdddgddd	gd
œƒ}|jdtjd�}|jdtjd�j}tj||ƒ |jdddid�}|jdddid�j}tj||ƒ d S )NÚaÚbÚcÚxÚyÚzr   rI   r   )ZrowsÚcolsr6   r]   )r8   rN   )r7   rN   r6   rC   )r   r   r/   rR   ÚTr:   r;   )r3   rT   ÚrsZxpr   r   r   Útest_pivot_table_nocolsŠ   s     z&TestPivotTable.test_pivot_table_nocolsc             C   s¼   t dddddœdddddœd	d
dddœdddddœdddddœdœƒ}|jddddgdd�}|jdddgddd�}tjddddd d!d"d#d$d%d&d'gddgd�}tj|j|ƒ tj|j|ƒ d S )(Ni`ê  i † iPÃ  i0u  )r   r   rI   r   r)   r*   r+   i[ i] i\ i^ rW   rX   rY   Údi€„ i ¡ i@B )ÚamountÚcustomerÚmonthr   Úquantityre   rd   rc   r   F)r   )r=   )r)   rW   )r)   rX   )r)   rY   )r)   ra   )r*   rW   )r*   rX   )r*   rY   )r*   ra   )r+   rW   )r+   rX   )r+   rY   )r+   ra   )r   r   r
   Úfrom_tuplesr:   Úassert_index_equalr8   r7   )r3   rT   Zpv_colZpv_indÚmr   r   r   Útest_pivot_table_dropna–   s4    z&TestPivotTable.test_pivot_table_dropnac             C   s¦   t ddddgdddgdd�}t ddddgdddgdd�}t||d	d
ddgdœƒ}tj|dddgdd�}tjj||gddgd�}tdd	d
ddgi|d�}tj||ƒ d S )NrW   rX   r\   T)Ú
categoriesÚorderedrY   ra   r[   r   rI   r   r   )r)   r*   r6   r6   r)   r*   )r6   r7   r   )r=   )r7   )r   r   r   r   r
   r   r:   r;   )r3   Zcat1Zcat2rT   rU   Z	exp_indexrG   r   r   r   Útest_pivot_table_categorical»   s    z+TestPivotTable.test_pivot_table_categoricalc             C   sø   ddddg}t dddddddddg	dddddddddg	tdd	ƒd
œƒ}|d jt|dd�ƒ|d< |jddd|d�}tdddgdd�}|jt|dd�ƒ}tdddgdd�}t dddgdddgdddgg||d�}|sè|jt|ƒd�jdƒ}tj	||ƒ d S )NrW   rX   rY   ra   r   rI   r   r   é	   )r)   r*   r+   r)   F)rk   r*   r+   )r7   r8   r6   r   )r@   é   r   é   rJ   é   )r7   r8   )r8   Úfloat)
r   ÚrangerS   ÚCDTr   r   Úreindexr   r:   r;   )r3   r   rj   rT   rU   Úexpected_columnsÚexpected_indexrG   r   r   r   Ú$test_pivot_table_dropna_categoricalsÊ   s"    z3TestPivotTable.test_pivot_table_dropna_categoricalsc             C   s  t jt jtjddddgddgdd�tdƒdœƒ}|jdd|d	�}t jdd
dgit jt jjddgddgdd�dd�d�}t	j
||ƒ t jt jdddddgdddgdd�tdƒdœƒ}|jdd|d	�}t jdd
ddgit jt jjddd
gdddgdd�dd�d�}t	j
||ƒ d S )NÚlowÚhighT)rj   rk   rJ   )r)   r*   r)   r*   )r7   r6   r   rI   r   r   r   )r@   )r7   r   )r   r   r   r/   Únanrr   r   r	   Z
from_codesr:   r;   )r3   r   rT   rU   rG   r   r   r   Ú%test_pivot_with_non_observable_dropnaæ   s8    
z4TestPivotTable.test_pivot_with_non_observable_dropnac             C   sJ   t |ddœƒ}|jdd|d�}t ddit|jƒ dd�d�}tj||ƒ d S )Nr   )r)   r*   r)   r*   )r7   r6   r   )r@   )r7   )r   r   r	   Úuniquer:   r;   )r3   r    r   rT   rU   rG   r   r   r   Útest_pivot_with_interval_index  s    z-TestPivotTable.test_pivot_with_interval_indexc             C   s¼   t jjddddgddddgƒ}ttjdddtjd�ddddgt j|dd	�jd
d�dœƒ}t j	|dddddd�}|d }t
dddgtt jddƒt jddƒdgdd�dtjd�}tj||ƒ d S )Nr   r   rI   r   )ÚdtyperW   rX   T)rk   F)Z	ascending)r)   r*   r+   r+   r*   r)   rR   )r7   r8   r6   rN   ÚmarginsÚAllr   ro   é
   )r@   )r7   r@   r~   éÿÿÿÿ)r   r   r   r   r/   ÚarangeZintpr   Zsort_valuesr   r   r	   ZIntervalr:   Úassert_series_equal)r3   Zordered_catrT   Z	pivot_tabrU   rG   r   r   r   Ú&test_pivot_with_interval_index_margins   s    
 
z5TestPivotTable.test_pivot_with_interval_index_marginsc             C   s<   | j jd| j j| j jd�}| j jdddd�}tj||ƒ d S )Nr,   )r7   r8   r)   r+   )r2   r   r)   r+   r:   r;   )r3   rU   rG   r   r   r   Útest_pass_array:  s    zTestPivotTable.test_pass_arrayc             C   sD   | j jddd„ | j jd�}| j jd| j jd dd�}tj||ƒ d S )Nr,   c             S   s   | d S )NrJ   r   )rZ   r   r   r   Ú<lambda>@  s    z3TestPivotTable.test_pass_function.<locals>.<lambda>)r7   r8   rJ   r+   )r2   r   r+   r7   r:   r;   )r3   rU   rG   r   r   r   Útest_pass_function?  s    z!TestPivotTable.test_pass_functionc             C   sJ   ddg}d}t | j||d�}| jj||g ƒjtjƒjƒ }tj||ƒ d S )Nr)   r*   r+   )r7   r8   )	r   r2   rA   rB   r/   rC   rD   r:   r;   )r3   r7   r8   rE   rG   r   r   r   Útest_pivot_table_multipleD  s
    z(TestPivotTable.test_pivot_table_multiplec             C   s  t ddddgddddgddddgd	œƒ}|jd
 dks:t‚t|d
dgdgdtjd�}|j}ttjdƒgd tt	dƒdd�d�}t
j||ƒ t ddddgddddgddddgd	œƒ}|jd
 dksÄt‚t|d
dgdgdtjd�}|j}ttjdƒgd tt	dƒdd�d�}t
j||ƒ d S )NÚcatZbatr   rI   r   r   rW   rX   )rW   ÚvÚir‹   Úint64rŒ   r   )r6   r7   r8   rO   rN   Úab)r@   )r7   g      ø?g      @g      @g      @Úfloat64)r   Údtypesr?   r   r/   rR   r   r~   r	   rQ   r:   r„   rC   )r3   Úfr\   rU   rG   r   r   r   Útest_pivot_dtypesK  s(    

$

$z TestPivotTable.test_pivot_dtypeszcolumns,valuesÚbool1Úfloat1Úfloat2Úbool2c             C   sj   t jdt jd�}t||d |dk|dkdœƒ}|jƒ jd||d�}t|jƒ}d	d
„ |D ƒ}||ksft‚d S )NrJ   )r~   g       @rI   r   )r”   r•   r“   r–   r7   )r7   r8   r6   c             S   s0   i | ](}|d  j dƒr tjdƒntjdƒ|“qS )r   rX   ÚOr�   )Ú
startswithr/   r~   )Ú.0Úcolr   r   r   ú
<dictcomp>ƒ  s   z=TestPivotTable.test_pivot_preserve_dtypes.<locals>.<dictcomp>)	r/   rƒ   r�   r   Úreset_indexr   Údictr�   r?   )r3   r8   r6   r‹   rT   Zdf_resrU   rG   r   r   r   Útest_pivot_preserve_dtypeso  s    

z)TestPivotTable.test_pivot_preserve_dtypesc             C   sZ  t jdddddgƒ}t jdddddd	gi|d
�}|j|jj|jjd�}t jjddgƒ}t jddgdt	j
ggddg|d�}tj||ƒ t jddddd	gt jddd	d�dœ|d
�}|j|jjt jddd�d�}t jjdt jdƒfgƒ}d dg|_t jddgddg|d�}tj||ƒ |jt jdd�t jddd�d�}t jdgt jdgƒ|d�}tj||ƒ d S )Nz
2011-01-01z
2011-02-01z
2011-01-02r)   r   rI   r   r   rJ   )r7   )r7   r8   g      @g      @g       @r,   )ÚfreqÚperiods)r)   Údtr¡   ÚM)ÚkeyrŸ   z
2011-01-31g      
@)rŸ   z
2011-12-31)r)   r   )r)   rI   )r   ÚDatetimeIndexr   r   r7   rd   Údayr
   rf   r/   rz   r:   r;   r   r   Ú	Timestampr=   )r3   ÚidxrT   ÚresZexp_columnsÚexpr   r   r   Útest_pivot_no_values‰  s.    
z#TestPivotTable.test_pivot_no_valuesc             C   sN   t | jddgdddgdd�}t | jjdgd	d
�dddgdd�}tj||ƒ d S )Nr,   r-   r)   r*   r+   r   )r6   r7   r8   rO   r.   r   )Úaxis)r7   r8   rO   )r   r2   Zdropr:   r;   )r3   rU   rG   r   r   r   Útest_pivot_multi_values®  s
     z&TestPivotTable.test_pivot_multi_valuesc                s¨   ‡ fdd„}|t jt jgƒ}|t jƒ}|t jƒ}t||gddgdd�}tj||ƒ ‡ fdd„}|t jt jgƒ}|t jƒ}|t jƒ}t||gddgdd�}tj||ƒ d S )Nc                s   t ˆ jddgddgd| d�S )Nr,   r-   r)   r*   r+   )r6   r7   r8   rN   )r   r2   )Úfunc)r3   r   r   r‡   ¸  s   z;TestPivotTable.test_pivot_multi_functions.<locals>.<lambda>rC   Ústdr   )Úkeysr«   c                s   t ˆ jddgddgd| dd�S )Nr,   r-   r)   r*   r+   T)r6   r7   r8   rN   r   )r   r2   )r­   )r3   r   r   r‡   Â  s   )r/   rC   r®   r   r:   r;   )r3   r‘   rU   ZmeansZstdsrG   r   )r3   r   Útest_pivot_multi_functions·  s    



z)TestPivotTable.test_pivot_multi_functionsr4   TFc       	      C   sä  t j}tdd|dgddddgdd	d
dgdœƒ}|rB|jdddƒ}ntj|dddƒ}t||d
|gd|||g|d	||g|||dggt|dddgdd�tddddgdd�d�}tj||ƒ tj|jdddƒ|jƒ ttj	dddd�dt j
dƒ dœƒ}|d tjdƒ |d< | |jd< |jd< | |jd< |jd< |�rD|jdddƒ}ntj|dddƒ}|jƒ jjƒ t|ƒk�spt‚x:|jƒ D ].\}}|j|d |d f |d k�szt‚�qzW |�rÂ|jdddƒ}ntj|dddƒ}tj||jƒ d S ) NZR1ZR2ZR4ÚC1ÚC2ZC3ZC4r�   é   é   é   )rW   rX   rY   rW   rX   rY   )r@   )r7   r8   z
2014-02-01rn   r,   )r    rŸ   éd   )rW   rY   z
2014-02-02r   r   r   )r   rW   )r   rW   )r   rX   )r   rX   )r/   rz   r   Úpivotr   r	   r:   r;   r^   r   rƒ   r¦   ÚlocZnotnar6   rR   r<   r?   Ziterrows)	r3   r4   rz   rT   rU   rG   ÚpvÚ_Úrowr   r   r   Útest_pivot_index_with_nanÐ  sB    




*z(TestPivotTable.test_pivot_index_with_nanc             C   sÒ  t tdddddƒtdddddƒtdddddƒtdddddƒgtdddddƒtdddddƒtdddddƒtdddddƒgtjddd	�tjddd	�d
œƒ}|d jdd„ ƒ|d< |d jdd„ ƒ|d< tddddgƒ}tjddgd ddd�}tjj	||gƒ}t ddddgddddggtjddgddd�|d�}|�rB|j
ddd�}ntj
|ddd�}tj||ƒ t ddgddggtjddgddd�tjddgddd�d�}|�r°|j
dddd�}ntj
|dddd�}tj||ƒ d S )NiÝ  r   rm   r   rI   iÞ  r   r�   )r~   )Údt1Údt2Údata1Údata2r½   c             S   s   t j| dd�S )Nz
US/Pacific)Útz)r   r¦   )ra   r   r   r   r‡     s    z3TestPivotTable.test_pivot_with_tz.<locals>.<lambda>r¾   c             S   s   t j| dd�S )Nz
Asia/Tokyo)rÁ   )r   r¦   )ra   r   r   r   r‡     s    r¿   rÀ   z2014/01/01 09:00z2014/01/02 09:00z
Asia/Tokyo)r@   rÁ   r   z2013/01/01 09:00z2013/01/02 09:00z
US/Pacific)r7   r8   )r7   r8   r6   )r   r   r/   rƒ   Úapplyr	   r   r¤   r
   r   r·   r:   r;   )r3   r4   rT   Úexp_col1Úexp_col2Úexp_colrG   r¹   r   r   r   Útest_pivot_with_tz  sH    z!TestPivotTable.test_pivot_with_tzc          
   C   s  t jdt jddd�dœdt jddd�dœdt jddd�dœdt jddd�dœdt jd	dd�dœgƒ}|jd
ƒjƒ }|jjdd„ ƒ}t j|jd
ƒjƒ d
dg|gtj	d�}t jt jddd�t jddd�ggt j
dgdd�t jt jddd�t jddd�gd
d�d�}tj||ƒ d S )NZaaz2016-08-12 13:00:00-0700z
US/Pacific)rÁ   )ÚuidÚtsz2016-08-12 08:00:00-0700z2016-08-12 14:00:00-0700z2016-08-25 11:00:00-0700z2016-08-25 13:00:00-0700rÈ   c             S   s   | j ddddd�S )Nr   )ÚhourÚminuteÚsecondÚmicrosecond)Úreplace)rZ   r   r   r   r‡   ^  s    z8TestPivotTable.test_pivot_tz_in_values.<locals>.<lambda>rÇ   )r6   r7   r8   rN   )r@   z2016-08-12 00:00:00z2016-08-25 00:00:00)r7   r8   )r   r   r¦   Ú	set_indexrœ   rÈ   Úmapr   r/   Úminr	   r¤   r:   r;   )r3   rT   ZminsrU   rG   r   r   r   Útest_pivot_tz_in_valuesB  s8    
z&TestPivotTable.test_pivot_tz_in_valuesc             C   s„  t tjddƒtjddƒtjddƒtjddƒgtjddƒtjddƒtjddƒtjddƒgtjddd	�tjddd	�d
œƒ}tddddgƒ}tjddgd ddd�}tjj||gƒ}t ddddgddddggtjddgddd�|d�}|rô|j	ddd�}ntj	|ddd�}t
j||ƒ t ddgddggtjddgddd�tjddgddd�d�}|�rb|j	dddd�}ntj	|dddd�}t
j||ƒ d S )Nz
2013-01-01r,   z
2013-01-02z2013-01r¢   z2013-02r   r�   )r~   )Úp1Úp2r¿   rÀ   r¿   rÀ   rI   rÓ   )r@   rŸ   r   r   r   rÒ   )r7   r8   )r7   r8   r6   )r   r   ÚPeriodr/   rƒ   r	   ZPeriodIndexr
   r   r·   r:   r;   )r3   r4   rT   rÃ   rÄ   rÅ   rG   r¹   r   r   r   Útest_pivot_periodsy  s<    





z!TestPivotTable.test_pivot_periodsc             C   s”   t ddddgtjdƒtjdƒtjdƒtjdƒgddœƒ}t dtjdddgdd	�tjtjdƒtjdƒdgd
d	�d�}|jdd
ddd�}tj||ƒ d S )Nr   rI   Z2019Q1Z2019Q2g      ð?)rW   rX   rZ   r€   rW   )r@   rX   )r2   r7   r8   rZ   T)r7   r8   r6   r   )r   r   rÔ   r	   r   r:   r;   )r3   rT   rG   rU   r   r   r   Útest_pivot_periods_with_margins§  s    


 z.TestPivotTable.test_pivot_periods_with_marginsr6   ÚbazÚzooc       	   
   C   sø   t jddddddgddddddgdddd	d
dgddddddgdœƒ}|rZ|jdd|d�}nt j|dd|d�}ddddddgd	d
ddddgg}tddgdd�}tddgdddggddddddgddddddggd dgd�}t|||dd�}tj||ƒ d S )Nr$   r%   r)   r*   r+   r   rI   r   r   rJ   rn   rZ   r[   r\   ÚqÚwÚt)r"   r#   r×   rØ   r"   r#   )r7   r8   r6   )r2   r@   r×   rØ   r   )ÚlevelsÚcodesr=   Úobject)r2   r7   r8   r~   )r   r   r·   r	   r
   r:   r;   )	r3   r6   r4   rT   rU   r2   r7   r8   rG   r   r   r   Ú test_pivot_with_list_like_valuesÁ  s      z/TestPivotTable.test_pivot_with_list_like_valuesr#   c       	   
   C   s.  t jddddddgddddddgdddd	d
dgddddddgdœƒ}|rZ|jdd|d�}nt j|dd|d�}tjdtjd	gtjdtjdgtjdtjd
gdtjdtjgdtjdtjgdtjdtjgg}tddddddg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|||dd�}tj||ƒ d S )Nr$   r%   r)   r*   r+   r   rI   r   r   rJ   rn   rZ   r[   r\   rÙ   rÚ   rÛ   )r"   r#   r×   rØ   rØ   r"   )r7   r8   r6   )r2   r@   r#   r×   r   )rÜ   rÝ   r=   rÞ   )r2   r7   r8   r~   )	r   r   r·   r/   rz   r	   r
   r:   r;   )	r3   r6   r4   rT   rU   r2   r7   r8   rG   r   r   r   Ú%test_pivot_with_list_like_values_nanså  s*    z4TestPivotTable.test_pivot_with_list_like_values_nanszBMultiIndexed unstack with tuple names fails with KeyError GH#19966)Úreasonc          	   C   s  t ddddddgd�}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ddddgg}tddgddggddddgddddggd�}t|||dd�}|r¨|jddd d�}ntj|d!d"d#d�}tddgddgd�tddgddgd�tddgddgd�dœ}t|ƒ}tj||ƒ d S )$Nr   r   rI   r   r   rJ   )r2   r$   r)   rZ   r*   r[   r+   r\   r%   rÙ   rÚ   rn   rÛ   r#   r×   ÚfirstrË   )rÜ   rÝ   rÞ   )r2   r7   r8   r~   )r7   r8   r6   )r7   )r)   r*   r+   )r#   râ   )r#   rË   )r×   râ   )r#   râ   )r#   rË   )r×   râ   )r	   r
   r   r·   r   r   r:   r;   )r3   r4   r7   r2   r8   rT   rU   rG   r   r   r   Útest_pivot_with_multiindex  s4    





z)TestPivotTable.test_pivot_with_multiindexc             C   sŠ   t jddddddgddddddgdddd	d
dgddddddgdœƒ}tjtdd��. |rj|jdddd� nt j|dddd� W d Q R X d S )Nr$   r%   r)   r*   r+   r   rI   r   r   rJ   rn   rZ   r[   r\   rÙ   rÚ   rÛ   )r"   r#   r×   rØ   z^\('bar', 'baz'\)$)ÚmatchrØ   r"   r#   r×   )r7   r8   r6   )r#   r×   )r#   r×   )r   r   ÚpytestÚraisesÚKeyErrorr·   )r3   r4   rT   r   r   r   Útest_pivot_with_tuple_of_values:  s    z.TestPivotTable.test_pivot_with_tuple_of_valuesc                s„  ddgdgdf‡ fdd„	}ˆ j jdddgddtjd	�}||dƒ ˆ j jdddgddtjd
d�}||dd
d� ˆ j jddgddtjd�}x"|jjd D ]}||| |ƒ q”W dd„ ˆ j jD ƒˆ j _ˆ j jddgdtjd�}x2|jD ](}|jd|f }|ˆ j | jƒ ksàt‚qàW ˆ j jddgdtjd�}t|t	ƒ�s4t‚ˆ j jddgddd�}x4dD ],}|jd|f }|ˆ j | jƒ k�sPt‚�qPW d S )Nr)   r*   r+   r€   c                sÐ   | j | jd d… |f }ˆ jj|ƒ| jƒ }tj||dd� |j|ksJt‚| j	ƒ } | j |df j
d d… }ˆ jj|ƒ| jƒ }tj||dd� |j|dfks t‚| j |df|f }	ˆ j| jƒ }
|	|
ksÌt‚d S )Nr   F)Úcheck_namesÚ r‚   r‚   )r¸   r7   r2   rA   rC   r:   r„   r@   r?   Z
sort_indexZiloc)rU   Z
values_colr7   r8   Úmargins_colZcol_marginsZexpected_col_marginsZindex_marginsZexpected_ix_marginsZgrand_total_marginsZexpected_total_margins)r3   r   r   Ú_check_outputM  s    z2TestPivotTable.test_margins.<locals>._check_outputr,   T)r6   r7   r8   r   rN   ZTotals)r6   r7   r8   r   rN   Úmargins_name)rë   )r7   r8   r   rN   r   c             S   s   g | ]}|d  ‘qS )rI   r   )r™   Úkr   r   r   ú
<listcomp>}  s    z/TestPivotTable.test_margins.<locals>.<listcomp>ZAAZBB)r7   r   rN   rê   )r8   r   rN   rC   ÚDDÚEEÚFF)r€   rê   )rð   rñ   rò   )r€   rê   )
r2   r   r/   rC   r8   rÜ   r¸   r?   Ú
isinstancer   )r3   rì   rU   rE   Z	value_colZtotalsZrtableÚitemr   )r3   r   Útest_marginsL  s8    

zTestPivotTable.test_marginsc             C   sÌ   | j jƒ }tjt|ƒd ƒjt|ƒdƒ|dddg< ttddgddgƒƒd g }tj	|d!d�}t
dddddgdddddgdœ|d�jddd�}|d |d  |d	< |jdddgddtjdd�}tj||ƒ d S )"Nr   r,   r-   r.   r#   r"   r$   r%   r€   rê   r)   r*   )r=   é   é   rm   é-   é!   r   é$   é3   éx   )r&   r'   )r7   r+   r   )r«   r&   r'   T)r6   r7   r8   r   rN   rO   )r€   rê   )r)   r*   )r2   Úcopyr/   rƒ   r<   ÚreshaperQ   r   r
   rf   r   Úrename_axisr   rR   r:   r;   )r3   rT   Úmi_valÚmirG   rU   r   r   r   Útest_margins_dtypeŽ  s     
($
z!TestPivotTable.test_margins_dtypez1GH#17035 (len of floats is casted back to floats)c             C   sš   t tddgddgƒƒdg }tj|dd	�}td
d
dd
dgdddddgdœ|d�jdd
d�}|d |d  |d< | jjdddgddtdd�}t	j
||ƒ d S )Nr#   r"   r$   r%   r€   rê   r)   r*   )r=   r   rI   rJ   r   rn   )r&   r'   )r7   r+   )r«   r&   r'   r,   T)r6   r7   r8   r   rN   rO   )r€   rê   )r)   r*   )rQ   r   r
   rf   r   rÿ   r2   r   r<   r:   r;   )r3   r   r  rG   rU   r   r   r   Útest_margins_dtype_len¦  s    $
z%TestPivotTable.test_margins_dtype_lenc                s”   t j‰ ttddgdddgddg‡ fdd	„td
ƒD ƒdgƒƒ}t|ƒ}|jddddgdgd�}|jtd�}|jddddgdgd�}t	j
||dd� d S )Nr"   r#   r)   r*   r+   Úx1Zx2c                s   g | ]}ˆ t |ƒ ‘qS r   )r   )r™   rŒ   )ra   r   r   rï   Ã  s    z=TestPivotTable.test_pivot_integer_columns.<locals>.<listcomp>rµ   g      ð?r   r   r   r   rI   )r6   r7   r8   )r8   Ú4Ú0Ú1Ú3Ú2F)ré   )r   rÐ   rQ   r   rr   r   r   ÚrenameÚstrr:   r;   )r3   r2   rT   rE   Zdf2rF   r   )ra   r   Útest_pivot_integer_columnsº  s    
z)TestPivotTable.test_pivot_integer_columnsc          
   C   s¬   t ddddddddgd ddddddddgd dgd dgd  d tjjd	ƒd
œƒ}|jddddgd�}|jdddgƒd jƒ }|jdƒjdƒjddd�}t	j
||ƒ d S )NrW   rX   rI   r   r   r"   r   r#   é   )rW   rX   rY   Úvaluer  rY   )r7   r8   Úall)r«   Úhow)r   r/   r0   r1   r   rA   rC   rD   r   r:   r;   )r3   r2   rE   ZgroupedrG   r   r   r   Útest_pivot_no_level_overlapÏ  s    z*TestPivotTable.test_pivot_no_level_overlapc       
      C   sB  d}t jdtfdtfdtfdtfdtfdtfdtfgƒ}t jd d!d"d#d$d%d&d'd(g	dtfdtfgd�}t j||d�}t jjdt	|ƒ|ƒ}|d | |d< |d | |d< t
jtdddƒtdddƒƒ}|t jjdt	|ƒ|ƒ }|j|d< |j|d< |j|d< t jjdd|ƒ|d< t|ƒ}|jdddgdddgdd�}	|	jj�s>t‚d S ))Ni'  r	   ZSymbolÚYearÚMonthZDayÚQuantityZPriceÚSP500ÚADBEÚNVDAÚORCLÚNDQ100ÚAAPLÚMSFTÚGOOGÚFTSEúDGE.LúTSCO.LúGSK.L)r~   r   iÐ  r   iÚ  rö   é   g      @g       @rC   )r7   r8   rN   )r  r  )r  r  )r  r  )r  r  )r  r  )r  r  )r  r  )r  r  )r  r   )r/   r~   rÞ   Úintrq   ÚarrayÚemptyr0   Úrandintr<   r   r   r   Úyearrd   r¥   Z	lognormalr   r   r8   Zis_monotonicr?   )
r3   Únr~   ZproductsÚitemsZiproductZdrÚdatesrT   Zpivotedr   r   r   Útest_pivot_columns_lexsortedá  sJ    


z+TestPivotTable.test_pivot_columns_lexsortedc             C   sL   dgdgdœ}| j jddgƒj|ƒjdƒ}| j jdd|d�}tj||ƒ d S )Nr®   rR   )r,   r-   r)   r*   )r7   r8   rN   )r2   rA   rB   rD   r   r:   r;   )r3   r‘   rG   rU   r   r   r   Útest_pivot_complex_aggfunc  s    z)TestPivotTable.test_pivot_complex_aggfuncc             C   sF   | j ddg jddgtdd�}|jƒ }t|d d… ƒ|d ksBt‚d S )Nr)   r*   T)r7   rN   r   r   r‚   r‚   )r2   r   r<   ÚtolistrR   r?   )r3   rU   Zresult_listr   r   r   Útest_margins_no_values_no_cols  s    z-TestPivotTable.test_margins_no_values_no_colsc             C   sB   | j dddg jddgdtdd�}|jjƒ ddddd	gks>t‚d S )
Nr)   r*   r+   T)r7   r8   rN   r   g      @g      ð?g      @g      &@)r2   r   r<   r€   r,  r?   )r3   rU   r   r   r   Útest_margins_no_values_two_rows$  s    z.TestPivotTable.test_margins_no_values_two_rowsc             C   s8   | j ddg jddtdd�}|jjƒ dddgks4t‚d S )Nr)   r*   T)r7   r8   rN   r   g      @g      @g      &@)r2   r   r<   r€   r,  r?   )r3   rU   r   r   r   Ú&test_margins_no_values_one_row_one_col,  s    z5TestPivotTable.test_margins_no_values_one_row_one_colc             C   sh   ddddddddd	d
dg| j d< | j ddddg jddgddgtdd�}|jjƒ dddddgksdt‚d S )NrW   rX   rY   ra   Úer‘   ÚgÚhrŒ   Újrî   r,   r)   r*   r+   T)r7   r8   rN   r   g      @g      ð?g      @g      &@)r2   r   r<   r€   r,  r?   )r3   rU   r   r   r   Ú'test_margins_no_values_two_row_two_cols4  s     z6TestPivotTable.test_margins_no_values_two_row_two_colsÚmargin_namer"   r$   iš  NrW   rX   c             C   s®   dj |ƒ}tjt|d��" t| jdddgdgd|d� W d Q R X tjt|d��" t| jddgddgd|d� W d Q R X tjt|d��  t| jddgdgd|d� W d Q R X d S )	NzGConflicting name "{}" in margins|margins_name argument must be a string)rä   r,   r)   r*   r+   T)r6   r7   r8   r   rí   )Úformatrå   ræ   Ú
ValueErrorr   r2   )r3   r5  Úmsgr   r   r   Ú-test_pivot_table_with_margins_set_margin_name=  s4    z<TestPivotTable.test_pivot_table_with_margins_set_margin_namec          .   C   sÀ  t djƒ djƒ ddddddddgtdddƒtdddƒtdd	dƒtdd	d
ƒtdd	dƒtdd	d
ƒtddd
ƒtddd
ƒgdœƒjdƒ}t tjd	ddgdd�jddƒtdddƒgdjƒ d�}d|j_d|j	_t
|tdd�ddtjd�}tj||ƒ t
|dtdd�dtjd�}tj||jƒ t tjdtjdddtjgƒjd
dƒtdddƒtdddƒgdjƒ d�}d|j_d|j	_t
|tdd�ddtjd�}tj||ƒ t
|dtdd�dtjd�}tj||jƒ |jƒ }t
|tddd�ddtjd�}tj||ƒ t
|dtddd�dtjd�}tj||jƒ d}tjt|d��" t
|tddd�ddtjd� W d Q R X tjt|d��" t
|dtddd�dtjd� W d Q R X |jdƒ}t
|tddd�ddtjd�}tj||ƒ t
|dtddd�dtjd�}tj||jƒ d }tjt|d��" t
|tddd�ddtjd� W d Q R X tjt|d��" t
|dtddd�dtjd� W d Q R X t djƒ djƒ ddddddddgtdd!dd"d#ƒtdddd"dƒtdd	dd$d#ƒtdd	d
d	d#ƒtdd!dd$d#ƒtdd	d
d	d#ƒtdd	d
dd#ƒtdddd%d#ƒgtdd	d&d#d#ƒtdd	d'd"dƒtdddd$d#ƒtdd!d
d	d#ƒtdd	dd$d#ƒtdddd	d#ƒtddd(dd#ƒtdd!d$d%d#ƒgd)œƒ}t
|td*dd�td*d+d�dtjd�}t tjtjdtjtjd,tjddtjdtjtjtjtjdtjgƒjd&d&ƒtddd(ƒtdd	dƒtdd!d(ƒtdddƒgtddd(ƒtdd	dƒtdd!d(ƒtdddƒgd�}d|j_d+|j	_tj||ƒ t
|td*d+d�td*dd�dtjd�}tj||jƒ tddd(ƒtdd	dƒftdd	dƒtddd(ƒftdd	dƒtdd!d(ƒftdd	dƒtdddƒftdd!d(ƒtdd	dƒftdddƒtdd!d(ƒfg}tj|dd+gd-�}t tjdtjd,tjdtjdtjdtjtjdgƒjd,d
ƒ|dd.gd�}d/|j	_t
|td*dd�td*d+d�gd/gdtjd�}tj||ƒ t
|d/gtd*dd�td*d+d�gdtjd�}tj||jƒ d S )0NzA A A A A A A Bz$Carl Mark Carl Carl Joe Joe Joe Carlr   r   rJ   rp   rm   iÝ  r�   rI   rö   )ÚBranchÚBuyerr  ÚDater<  é   r�   )r~   r!  zCarl Joe Mark)r7   r8   r;  r)   )rŸ   r  )r7   r8   r6   rN   ro   Z6MS)rŸ   r£   z#'The grouper name foo is not found')rä   r"   )rŸ   ÚlevelzThe level foo is not validr(   é   r   rµ   é   r   r³   é   )r:  r;  r  r<  ÚPayDayr¢   rB  rn   )r=   r*   r:  )r   Úsplitr   rÎ   r/   r#  rþ   r7   r@   r8   r   r   rR   r:   r;   r^   rz   rœ   rå   ræ   rç   r7  r
   rf   )r3   rT   rG   rU   r8  Ztuplesr§   r   r   r   Útest_pivot_timegrouperc  s˜   








 



























*

z%TestPivotTable.test_pivot_timegrouperc             C   sÔ  ddddddg}ddddddg}t ddddddg||tjdd	d
�ddgd dœƒ}|d jdd„ ƒ|d< |d jdd„ ƒ|d< tjdddgddd�}tddgƒ}tddgdd�}tj||gƒ}t ddgddgddgg||d�}t	|dgdgdgd�}	t
j|	|ƒ tddddddddgƒ}tddd d gd ƒ}tjddgd d!dd�}
tj|||
gƒ}t tjddddddddgddddddddgddddddddggd	d
�||d�}t	|dgdgdd gtjtjgd"�}	t
j|	|ƒ d S )#Nz2011-07-19 07:00:00z2011-07-19 08:00:00z2011-07-19 09:00:00z2013-01-01 15:00:00z2013-02-01 15:00:00rW   rX   rn   r�   )r~   r   rI   r   )Úlabelr½   r¾   Úvalue1Úvalue2r½   c             S   s   t j| dd�S )Nz
US/Pacific)rÁ   )r   r¦   )ra   r   r   r   r‡   ˆ  s    z7TestPivotTable.test_pivot_datetime_tz.<locals>.<lambda>r¾   c             S   s   t j| dd�S )Nz
Asia/Tokyo)rÁ   )r   r¦   )ra   r   r   r   r‡   ‰  s    z
US/Pacific)rÁ   r@   rF  rE  )r@   r   r   rJ   )r7   r8   )r7   r8   r6   rR   rC   rG  z
Asia/Tokyo)r7   r8   r6   rN   )r   r/   rƒ   rÂ   r   r¤   r	   r
   r   r   r:   r;   r#  rR   rC   )r3   Údates1Údates2rT   Úexp_idxrÃ   rÄ   rÅ   rG   rU   Zexp_col3r   r   r   Útest_pivot_datetime_tzn  sh     
z%TestPivotTable.test_pivot_datetime_tzc          	   C   s\  ddddddg}ddddddg}t ddddddg||tjdd	d
�ddgd dœƒ}|d jdd„ ƒ|d< |d jdd„ ƒ|d< t|d|d jjdd�}tddgdd�}t ddgddgddgdœ|tdddgdd�d�}tj	||ƒ t||d jj
|d jjdd�}t ddgddgddgdœtddgdd�tdddgdd�d�}tj	||ƒ t||d jjj|d jj|d jj
gdd�}tjddddddgddgd gddgd �}t tjddddddggd	d
�d!g|d�}tj	||ƒ t|tjd"d"d"d"d#d#gƒ|d jj|d jj
gdd�}t tjdddtjdtjgtjtjtjdtjdggƒd"d#g|d�}tj	||ƒ d S )$Nz2011-07-19 07:00:00z2011-07-19 08:00:00z2011-07-19 09:00:00z2013-01-01 15:00:00z2013-02-01 15:00:00rW   rX   rn   r�   )r~   r   rI   r   )rE  r½   r¾   rF  rG  r½   c             S   s
   t j| ƒS )N)r   r¦   )ra   r   r   r   r‡   Ð  s    z6TestPivotTable.test_pivot_dtaccessor.<locals>.<lambda>r¾   c             S   s
   t j| ƒS )N)r   r¦   )ra   r   r   r   r‡   Ñ  s    rE  rF  )r7   r8   r6   )r@   r   r   rJ   )ro   rp   rm   ro   rp   rm   )r7   r8   )r=   iÝ  ÚXÚY)r   r/   rƒ   rÂ   r   r¡   rÉ   r	   r:   r;   rd   r&  r6   r
   r   r#  rz   )r3   rH  rI  rT   rU   rJ  rG   rÅ   r   r   r   Útest_pivot_dtaccessorµ  sp    &&,z$TestPivotTable.test_pivot_dtaccessorc             C   s´   t dddd�}ttjjt|ƒƒ|d�}tt|ƒ|jj	|jj
d�}|jjdƒ|_tj|jj
ƒ}xRtdd	ƒD ]D}|||k }|jj	|_|| jƒ }tj||d
d� |j|ksht‚qhW d S )Nz1/1/2000z
12/31/2004r,   )rŸ   )r7   )r7   r8   r   r   io  F)ré   )r   r   r/   r0   r1   r<   r   r   r7   r&  Z	dayofyearr8   Ú	droplevelZasarrayrr   r   r:   r„   r@   r?   )r3   ÚrngrÈ   ÚannualZdoyrŒ   ÚsubsetrU   r   r   r   Ú
test_daily  s    
zTestPivotTable.test_dailyc             C   s°   t dddd�}ttjjt|ƒƒ|d�}ttj|ƒ|j	j
|j	jd�}|jjdƒ|_|j	j}xRtdd	ƒD ]D}|||k }|j	j
|_	|| jƒ }tj||d
d� |j|ksdt‚qdW d S )Nz1/1/2000z
12/31/2004r¢   )rŸ   )r7   )r7   r8   r   r   r?  F)ré   )r   r   r/   r0   r1   r<   r   r   r   r7   r&  rd   r8   rO  rr   r   r:   r„   r@   r?   )r3   rP  rÈ   rQ  rd   rŒ   rR  rU   r   r   r   Útest_monthly  s    
zTestPivotTable.test_monthlyc             C   s†   dddœ}t j| jdgt|jƒ ƒ|d�}t j| jdg|jƒ |d�}tj||ƒ dd„ |jƒ D ƒ}t j| jdg||d�}tj||ƒ d S )NrR   rC   )r,   r-   r)   )r7   r6   rN   c             s   s   | ]
}|V  qd S )Nr   )r™   r  r   r   r   ú	<genexpr>9  s    zGTestPivotTable.test_pivot_table_with_iterator_values.<locals>.<genexpr>)r   r   r2   rQ   r¯   r:   r;   )r3   ZaggsZpivot_values_listZpivot_values_keysZagg_values_genZpivot_values_genr   r   r   Ú%test_pivot_table_with_iterator_values,  s    
z4TestPivotTable.test_pivot_table_with_iterator_valuesc             C   s²   d}t jddddgddddgddd	d	gd
œƒ}|jddd|tjtgd�}t jdd|gddd�}dddd|fdddd|fg}t jj|d d dgd�}t j|j	||d�}t
j||ƒ d S )NZWeeklyZbaconZcheeseg      @g      @gš™™™™™	@gffffff
@r¢   r^   )rô   Úcostr¥   rô   r¥   T)r7   r8   r   rí   rN   rÞ   )r~   r@   rC   rW  Úmax)r=   )r7   r8   )rC   rW  r¢   )rC   rW  r^   )rX  rW  r¢   )rX  rW  r^   )r   r   r   r/   rC   rX  r	   r
   rf   r6   r:   r;   )r3   rí   ZcostsrE   ÚixZtupsr]   rG   r   r   r   Ú/test_pivot_table_margins_name_with_aggfunc_list?  s*    

z>TestPivotTable.test_pivot_table_margins_name_with_aggfunc_listz1GH#17035 (np.mean of ints is casted back to ints)c             C   sš   t jtjdƒtjdƒd tjdƒd dœƒ}t j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�|_|jddd|dd�}tj	||ƒ d S )Nrp   r   rI   )rZ   r[   r\   g      ð?g       @g      ø?rJ   rn   g      @r   g      @r   r   r€   r[   )r@   r\   rZ   T)r   r   )
r   r   r/   rƒ   r	   r7   r8   r   r:   r;   )r3   r9   rT   rG   rE   r   r   r   Útest_categorical_margins]  s    ("z'TestPivotTable.test_categorical_marginsc             C   s¶   t jtjdƒtjdƒd tjdƒd dœƒ}t j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�|_|jjdƒ|_|j	jdƒ|_	|j
ddd|dd�}tj||ƒ d S )Nrp   r   rI   )rZ   r[   r\   g      ð?g       @g      ø?rJ   rn   g      @r   g      @r   r   r€   r[   )r@   r\   rP   rZ   T)r   r   )r   r   r/   rƒ   r	   r7   r8   r[   rS   r\   r   r:   r;   )r3   r9   rT   rG   rE   r   r   r   Ú!test_categorical_margins_categoryk  s    ("z0TestPivotTable.test_categorical_margins_categoryc             C   sŒ   t jddddgddddgddddgddd	d	gd
œƒ}t j|ddd�}t jdddgdddgdddgdœt jdd	dgdd�d�}tj||ƒ d S )NrI   r   rn   rp   r   rJ   r   rL  rM  )r)   r*   r+   r,   r,   T)r7   r   ro   g      @g      @g      @g      @)r)   r*   r+   r€   )r@   )r7   )r   r   r   r	   r:   r;   )r3   r9   rT   rU   rG   r   r   r   Útest_margins_casted_to_floatz  s    


z+TestPivotTable.test_margins_casted_to_floatc       	      C   s
  t jdddt jg}t jddt jdg}tjtj|ddg|d�tj|ddg|d�tddƒdœƒ}|jd	d
d|d�}tjddg|d
d�}tjdt jgt jdgg|d�}ttjddgddg|d�d	d�|_	t
j||ƒ |jd
d|d�}tjddgg|tdgƒd�}t
j||ƒ d S )Nrx   ry   r)   r*   )rj   rk   r   rn   )ÚInÚColÚValr^  r_  r`  )r7   r8   r6   r9   )rk   r@   g       @g      @)r2   r8   )r@   )r8   r6   r9   g      @)r2   r8   r7   )r/   rz   r   r   r   rr   r   ÚCategoricalIndexr	   r7   r:   r;   )	r3   r9   Zordered_fixturer§   rš   rT   rU   Zexpected_colsrG   r   r   r   Útest_pivot_with_categoricalŒ  s.    
z*TestPivotTable.test_pivot_with_categoricalc             C   sÂ   t jddddgddddgdddd	gd
œƒ}|d jdƒ|d< |jddd|dd�}t jdddgdddgddd�}t jddgdd�}tjdtjgdtjgtjdggƒ}t j|||d�}t	j
||ƒ d S )Nr)   r*   r+   rW   rX   r   rI   r   r   )r±   r²   ÚVr±   rP   rc  r²   Úcount)r7   r8   r   rN   F)rj   rk   r@   )r@   g      ð?g       @)r7   r8   )r   r   rS   r   ra  r	   r/   r#  rz   r:   r;   )r3   r9   rT   rU   rv   ru   Úexpected_datarG   r   r   r   Útest_categorical_aggfunc¹  s    &"z'TestPivotTable.test_categorical_aggfuncc             C   sÎ   t jdddgdddgdddgdœƒ}ddd	d
ddddddddg}|d jdƒjj|ƒ|d< |jddd|dd�}t jddgdd�}t jdg|ddd�}t jddgg||d�}|s¾|jƒ jt	j
ƒ}tj||ƒ d S )Nr¶   rü   éÜ   ÚJanuaryiÝ  iÞ  )ÚSalesr  r  ÚFebruaryZMarchZAprilÚMayZJuneZJulyZAugustZ	SeptemberZOctoberZNovemberZDecemberr  rP   ri  r  rR   )r6   r7   r8   r   rN   )r@   F)rj   rk   r@   i@  )r7   r8   )r   r   rS   rŠ   Úset_categoriesr   Z
Int64Indexra  r   r/   r�   r:   r;   )r3   r9   rT   ÚmonthsrU   ru   rv   rG   r   r   r   Ú%test_categorical_pivot_index_orderingÍ  s>    z4TestPivotTable.test_categorical_pivot_index_orderingc             C   sB  t dddgdddgdddgd	œƒ}|jd
ddgtjd�}tjdddgdddggddgd�}t dddg|d
gd�}tj||ƒ |jd
ddtjd�}t dtjtjgtjdtjgtjtjdggt	dddgdd�t	dddgdd�d�}tj||ƒ |jd
dtjgd�}tjdgd
ggƒ}t dddgt	dddgdd�|d�}tj||ƒ d S )Nr   r   rJ   r+   r,   r-   r   rm   )rK   rL   rM   rK   rM   rL   )r7   rN   )r=   )r7   r8   )r7   r8   rN   )r@   rR   )
r   r   r/   rR   r
   r   r:   r;   ÚNaNr	   )r3   rT   rU   rh   rG   r   r   r   Útest_pivot_table_not_seriesø  s    ""&"z*TestPivotTable.test_pivot_table_not_seriesc             C   sb   d}t jddddgiƒ}t j|dgtd|d�}t jddd|gddd	�}t j|d
�}tj||ƒ d S )Nu   Î”Î¿ÎºÎ¹Î¼Î®r"   r   rI   r   T)r7   rN   r   rí   rÞ   )r~   r@   )r7   )r   r   r   r<   r	   r:   r;   )r3   ÚgreekÚframerE   r7   rG   r   r   r   Útest_pivot_margins_name_unicode  s    z.TestPivotTable.test_pivot_margins_name_unicodec             C   sJ  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tdƒdœƒ}t|ddd	d
�}tdgddggddgddggd dgd�}t ddddœddddœi|d�jdƒ}tj||ƒ t|ddd	dgd
�}td	dgdgddggddddgddddgddddggd d dgd�}t ddddœddddœddddœddddœi|d�jdƒ}tj||ƒ d S ) Nr"   r#   r$   r%   r(   )r)   r*   r+   r)   r*   rR   )r7   r8   rN   r+   r   r   )rÜ   rÝ   r=   r³   r?  )r#   r"   ro   rµ   )r8   rC   g      @g      
@g      @g«ªªªªª@)r+   r$   )r+   r%   )rC   r+   r$   )rC   r+   r%   )rR   r+   r$   )rR   r+   r%   )r   rr   r   r
   rÿ   r:   r;   )r3   r2   rU   r  rG   r   r   r   Útest_pivot_string_as_func  sZ    & 


z(TestPivotTable.test_pivot_string_as_funcz
f, f_numpyrR   rC   r®   c             C   s4   t | jdd|d�}t | jdd|d�}tj||ƒ d S )Nr)   r*   )r7   r8   rN   )r   r2   r:   r;   )r3   r‘   Zf_numpyrU   rG   r   r   r   Útest_pivot_string_func_vs_func]  s    z-TestPivotTable.test_pivot_string_func_vs_funcc             C   sP   t tjdƒtjdƒddœƒ}d}tjt|d�� |jddd	d	d
� W d Q R X d S )NrI   r  r   )Úind1Úind2rd  z6Unstacked DataFrame is too big, causing int32 overflow)rä   rv  rw  rd  )r7   r8   r6   rN   i   i   )r   r/   rƒ   rå   ræ   r7  r   )r3   rT   r8  r   r   r   Ú-test_pivot_number_of_levels_larger_than_int32o  s    z<TestPivotTable.test_pivot_number_of_levels_larger_than_int32c       
      C   sÒ   t jdddgdddgdddgdœƒ}dd	„ }d
d„ }dd„ }t j|d|||g|d�}ddtjtjddgddtjtjddgg}t jjdddgddggd dgd�}t j|ddg|d�}	|rÂ|	jdd�}	tj	||	ƒ d S )NZappleZpeachr   rI   ro   rn   )ÚfruitÚsizeÚtastec             S   s   dS )Nr   r   )rZ   r   r   r   Úret_one†  s    z?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_onec             S   s   t | ƒS )N)rR   )rZ   r   r   r   Úret_sum‰  s    z?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_sumc             S   s   t jS )N)r/   rz   )rZ   r   r   r   Úret_noneŒ  s    z@TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_nonery  )r8   rN   r   r   r?  r}  r~  r|  )r=   rz  r{  )r7   r8   r8   )r«   )
r   r   r   r/   rz   r
   Zfrom_productr   r:   r;   )
r3   r   rT   r|  r}  r~  rU   r2   rš   rG   r   r   r   Útest_pivot_table_aggfunc_dropna|  s"    (z.TestPivotTable.test_pivot_table_aggfunc_dropnac             C   s˜   t jdddgdtjdgdtjtjgdœƒ}t j|dtj|d�}d	tjgdtjgg}t jddgdd
�}t j|ddg|d�}|rˆ|jdd�}tj	||ƒ d S )Nr$   r%   r   rI   r   )r)   rZ   r[   r)   )r8   rN   r   g      @)r@   rZ   r[   )r7   r8   r8   )r«   )
r   r   r/   rz   r   rC   r	   r   r:   r;   )r3   r   rT   rU   r2   rš   rG   r   r   r   Ú&test_pivot_table_aggfunc_scalar_dropnaŸ  s    &z5TestPivotTable.test_pivot_table_aggfunc_scalar_dropnac          	   C   sh   t jdddddgdddddgdd	d	dd	gd d d d d gd
œƒ}|jdddtjd�}t jƒ }tj||ƒ d S )NrI   r   rJ   rn   ro   rp   rm   ÚprÙ   )r)   Úidr+   r,   r)   r,   r‚  )r7   r8   r6   rN   )r   r   r   r/   rz  r:   r;   )r3   rT   rU   rG   r   r   r   Útest_pivot_table_empty_aggfunc°  s    z-TestPivotTable.test_pivot_table_empty_aggfuncc             C   sb   dd„ }t jddddgddddgddddgd	œƒ}tjtd
d�� |jd
dd|d� W d Q R X d S )Nc             S   s
   t j| ƒS )N)r/   rC   )Úlr   r   r   rB   À  s    z=TestPivotTable.test_pivot_table_no_column_raises.<locals>.aggr   r   r�   rµ   rA  é(   )rL  rM  ÚZZ
notpresent)rä   rL  rM  )rN   )r   r   rå   ræ   rç   r   )r3   rB   r"   r   r   r   Ú!test_pivot_table_no_column_raises¾  s
    &z0TestPivotTable.test_pivot_table_no_column_raises)MÚ__name__Ú
__module__Ú__qualname__r5   rH   rV   r`   ri   rl   rw   r{   r}   r…   r†   rˆ   r‰   r’   rå   ÚmarkÚparametrizerž   rª   r¬   r°   r¼   rÆ   rÑ   rÕ   rÖ   r/   r#  r   r   r	   rß   rà   Zxfailrã   rè   rõ   r  r  r  r  r*  r+  r-  r.  r/  r4  r9  rD  rK  rN  rS  rT  rV  rZ  r[  r\  r]  rb  rf  rn  rp  rs  rt  rR   rC   r®   ru  Zslowrx  r  r€  rƒ  r‡  r   r   r   r   r!   "   s°   0%3$
%	6<7."'B4	$&  G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ejjd#d$d.gd/d&ggƒd'd(„ ƒZd)d*„ Zd+d,„ Zd-S )0Ú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 )Nr"   r#   r$   r%   r&   r'   r(   )r)   r*   r+   r,   r-   r.   T)Zignore_index)r   r/   r0   r1   ÚappendrT   )r3   r4   rT   r   r   r   r5   Ë  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   )rT   r   rA   rz  rD   r:   r;   ÚfillnarS   r/   r�   )r3   rT   rU   rG   r   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   )rT   r   rA   rz  rD   r�  rS   r/   r�   r:   r;   )r3   rT   rU   rG   r   r   r   Útest_crosstab_multiple  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   rJ   r¶   )rz  r   r�   )rW   rX   rY   rW   rX   rY   )ÚrownamesÚcolnames)r“  r’  r)   r+   Úrow_0Úcol_0)rX   rY   )rX   rY   )r/   r0   r%  r   r   r:   r;   rT   r6   r7   r@   r?   r8   )r3   rW   rX   rY   rT   rU   rG   r   r   r   Útest_crosstab_ndarray  s    z"TestCrosstab.test_crosstab_ndarrayc             C   s°   t jdddgdddgd�}t jdddddgdddd	d
gd�}tjdddgƒ}t j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   r   rW   rX   rY   )r7   r   r   ra   r‘   r”  )r@   r•  )r7   r8   )	r   r   r/   r#  r   r	   r   r:   r;   )r3   rW   rX   rY   rG   rU   r   r   r   Útest_crosstab_non_aligned$  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   ro   r¶   )rz  r   rJ   )rW   rX   rY   rW   rX   rY   T)r’  r“  r   r€   rê   Úi8)r@   )r7   )rX   rY   )rW   )r€   rê   )r€   rê   )r€   rê   )r/   r0   r%  r   r   r7   r=   r?   r8   rA   rz  rS   r   r<   r	   rŽ  r@   r:   r„   r¸   rt   r�  r�   )r3   rW   rX   rY   rT   rU   Úall_colsÚexp_colsÚ
exp_marginÚall_rowsÚexp_rowsr   r   r   Útest_crosstab_margins6  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   ro   r¶   )rz  r   rJ   )rW   rX   rY   rW   rX   rY   TÚTOTAL)r’  r“  r   rí   rê   r˜  )r@   )r7   z&margins_name argument must be a stringiš  )rä   )rX   rY   )rW   )rŸ  rê   )rŸ  rê   )rŸ  rê   )rX   rY   )r/   r0   r%  r   r   r7   r=   r?   r8   rA   rz  rS   r   r<   r	   rŽ  r@   r:   r„   r¸   rt   r�  r�   rå   ræ   r7  )r3   rW   rX   rY   rT   rU   r™  rš  r›  rœ  r�  r8  rí   r   r   r   Ú%test_crosstab_margins_set_margin_nameT  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   ro   r¶   )rz  r   rJ   r"   r#   r×   )rN   r’  r“  )r"   r#   r×   r6   r6   )r7   r8   rN   )
r/   r0   r%  r1   r   rR   r   r   r:   r;   )r3   rW   rX   rY   r6   rE   rT   rG   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j|||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#   )r~   r$   r%   r&   r'   rW   rX   rY   F)r’  r“  r   )r=   )r$   r&   )r$   r'   )r%   r&   )r%   r'   )
r/   r#  rÞ   r   r   r
   rf   r:   rg   r8   )r3   rW   rX   rY   r¨   rh   r   r   r   Útest_crosstab_dropna—  s    
z!TestCrosstab.test_crosstab_dropnac             C   sV   t jdddgdddgd�}t jdddgdddgd�}t||ƒ}t jƒ }tj||ƒ d S )Nr   rI   r   )r7   r   rJ   rn   )r   r   r   r   r:   r;   )r3   Ús1Ús2ÚactualrG   r   r   r   Útest_crosstab_no_overlap¥  s
    
z%TestCrosstab.test_crosstab_no_overlapc             C   s.  t jdddddtjgddddddgdœƒ}t j|j|jddd�}t j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|jddd�}t j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|jddd�}t j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tjgddddddgdœƒ}t j|j|jddd�}t j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|jddd�}t j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 j|||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 j||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 j||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   rI   r   r   )rW   rX   T)r   r   r   rJ   g      ð?g       @r€   rW   )r@   rX   g      @g      @Frn   r"   r#   )r~   r$   r%   r&   r'   rY   )r’  r“  r   r   rê   )r=   ro   )r8   )r7   )r   r   r/   rz   r   rW   rX   r	   r7   r8   r:   r;   r#  rÞ   r
   r   )r3   rT   r¥  rG   rW   rX   rY   rh   r   r   r   Útest_margin_dropna°  s‚    *".","*".".22zTestCrosstab.test_margin_dropnac             C   sö  t jdddddgdddddgddtjddgdœƒ}t jddgdd�}t jddgdd�}t jd	d
gd	dgg||d�}t jdd
gddgg||d�}t jdd
gddgg||d�}tjt j|j|j	dd�|ƒ tjt j|j|j	dd�|ƒ tjt j|j|j	dd�|ƒ tjt j|j|j	dd�|ƒ tjt j|j|j	dd�t j|j|j	dd�ƒ tjt j|j|j	d
d�t j|j|j	dd�ƒ t jdd
gddgddggt jdddgddd�t jddgddd�d�}t jdd
d	gdddggt jddgddd�t jdddgddd�d�}t jd	d
d	gd	ddgdddggt jdddgddd�t jdddgddd�d�}	tjt j|j|j	ddd�|ƒ tjt j|j|j	ddd�|ƒ tjt j|j|j	ddd�|	ƒ t jtj
ddddgƒtj
ddddgƒgtj
ddddgƒƒ t jdd
dgdddgdddggt jdddgddd�t jdddgdd�d�}
t j|j|j	|jdddd�}tj||
ƒ t jdddddgdddddgd
dtjddgdœƒ}t jd
d
dgdddgdddggt jdddgddd�t jdddgddd�d�}t j|j|j	|jtjddd�}tj||ƒ d S )Nr   rI   r   r   )rW   rX   rY   rW   )r@   rX   gš™™™™™É?r   g333333ã?)r7   r8   g      ð?g      Ð?g      è?g      à?r  )Ú	normalizeTr7   r8   gš™™™™™Ù?r€   rÞ   )r@   r~   gš™™™™™é?)r¨  r   rd  )rN   r¨  r   g        )r   r   r/   rz   r	   r:   r;   r   rW   rX   r#  rY   rR   )r3   rT   Ú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_normalize	  sn    .6.z$TestCrosstab.test_crosstab_normalizec             C   s  t j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 jddgddggt jddgddd	�t jddgd
d�d�}x2dD ]*}t j|j|j|jd|d�}t	j
||ƒ qzW t jdtjgddggt jddgddd	�t jddgd
d�d�}t j|j|j|jddd�}t	j
||ƒ d S )Nr   rI   r   r   )rW   rX   rY   g        rW   r�   )r@   r~   rX   )r@   )r7   r8   Tr7   r8   rd  )r6   rN   r¨  F)Tr7   r8   )r   r   r/   rz   r	   r   rW   rX   rY   r:   r;   )r3   rT   r$  rŒ   Z
calculatedZnansr   r   r   Útest_crosstab_with_emptiesf	  s&    
z'TestCrosstab.test_crosstab_with_emptiesc          )   C   s2  t j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	|j
d� W d Q R X d	}tjt|d�� t j|j|j	tjd
� W d Q R X d}tjt|d�� t j|j|j	dd� W d Q R X tjt|d�� t j|j|j	dd� W d Q R X d}tjt|d�� t j|j|j	ddd� W d Q R X d S )Nr   rI   r   r   )rW   rX   rY   z)values cannot be used without an aggfunc.)rä   )r6   z%aggfunc cannot be used without values)rN   zNot a valid normalize argumentZ42)r¨  é*   zNot a valid margins argumentr  )r¨  r   )r   r   r/   rz   rå   ræ   r7  r   rW   rX   rY   rC   )r3   rT   Úerrorr   r   r   Útest_crosstab_errors‡	  s     .  z!TestCrosstab.test_crosstab_errorsc             C   sÂ   t j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 j|d
 |d ƒ}t jdddgd
d�}t j||ddd�}dddgdddgdddgg}t j|||d�}tj	||ƒ d S )NZHondaZAcuraZTeslaZSedanZElectricZPickup)ÚMAKEÚMODELr°  rP   r¯  )r@   F)rj   rk   r@   rI   r   r   )r7   r8   )
r   r   rS   rŠ   rl  r   r	   ra  r:   r;   )r3   rT   rj   rU   rv   ru   re  rG   r   r   r   Ú%test_crosstab_with_categorial_columns¡	  s    
z2TestCrosstab.test_crosstab_with_categorial_columnsc             C   sh  t j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 j|d |d g|d gdtj|d d�}t j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 j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 j|||d�}tj||ƒ d S )Nr$   r%   Zthreern   r)   r*   r+   rp   r"   r#   r   é   )r)   r*   r+   r,   r-   Tr,   )r7   r8   r   rN   r6   r€   rê   r   rI   r   r   )rÜ   rÝ   r=   rÞ   )r~   r@   g       @g      @g      (@g      8@)r7   r8   )r   r   r/   r0   r1   r   rz  r
   r	   r#  rz   r:   r;   )r3   rT   rU   rv   Zexpected_columnre  rG   r   r   r   Útest_crosstab_with_numpy_size·	  s>    
.





z*TestCrosstab.test_crosstab_with_numpy_sizec             C   s\   t jtdƒdd�}t j||ƒ}t jtdƒdd�}t jtjdtjd�||d�}t	j
||ƒ d S )Nr   r"   )r@   )r~   )r7   r8   )r   r   rr   r   r	   r   r/   Zeyer�   r:   r;   )r3   ÚsrU   rv   rG   r   r   r   Útest_crosstab_dup_index_namesâ	  s    z*TestCrosstab.test_crosstab_dup_index_namesr=   rW   rX   rY   c             C   s€   t jtdƒ|d d�}t jtddƒ|d d�}t jjtdƒtddƒg|d�}t jd|d�jddd�}t j||ƒ}tj||ƒ d S )	Nr   r   )r@   r   r   )r=   )r7   )rO   )	r   r   rr   r
   r   rD   r   r:   r;   )r3   r=   r£  r¤  r  rG   rU   r   r   r   Útest_crosstab_tuple_nameí	  s    z%TestCrosstab.test_crosstab_tuple_namec             C   s¢   t jdddgdddgdœdd	d
gd�}t j|j|j|jgƒ}t jd	d
dgdd�}t jjdddgddgd�}t jdddgdddgdddgg||d�}t	j
||ƒ d S )Nr   r   rI   rJ   r   rn   )rX   rW   r+   r)   r*   )r7   r”  )r@   rX   rW   )r=   r   )r7   r8   )r   r   )rI   rn   )r   rJ   )r   r   r   r7   rX   rW   r	   r
   rf   r:   r;   )r3   rT   rU   Ze_idxZ	e_columnsrG   r   r   r   Útest_crosstab_unsorted_orderø	  s    &$z)TestCrosstab.test_crosstab_unsorted_orderc             C   sb  t j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|jg|jdddd�}t j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|jg|jdddd�}t j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|jg|jdddd�}t j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   rI   r   r   rJ   rn   ro   rp   rm   )r)   r*   r+   r,   r-   Tz	Sub-Totalr   )r   rí   r¨  g      à?g]QJVUå?gF]kïSUÕ?g³Ñ9?ÅqÜ?g'c`Çá?rê   r)   r*   )rÜ   rÝ   r=   rÞ   r+   )r~   r@   g      Ð?gš™™™™™É?g³Ñ9?ÅqÌ?gš™™™™™Ù?g³Ñ9?Åq¼?g        g#„GÇá?)r   r   r   r)   r*   r+   r
   r7   r	   r8   r:   r;   )r3   rT   rU   rG   r   r   r   Útest_margin_normalize
  sj    $z"TestCrosstab.test_margin_normalizeN)rX   rY   )rW   rX   )rˆ  r‰  rŠ  r5   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   r   r�  Ê  s(   22aU!+"r�  )!r   r   r   Ú	itertoolsr   Znumpyr/   rå   Zpandasr   r   r   r   r	   r
   r   r   r   Zpandas._testingZ_testingr:   Zpandas.api.typesr   rs   Zpandas.core.reshape.pivotr   r   Zfixturer   rr   r    r!   r�  r   r   r   r   Ú<module>   s6   (

8               7