3
®ybJ ã               @   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 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dS )é    )ÚdateÚdatetimeÚ	timedelta)ÚproductN)ÚCategoricalÚ	DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚconcatÚ
date_range)ÚCategoricalDtype)Úpivot_tableTF)Úparamsc             C   s   | j S )N)Úparam)Úrequest© r   úC/tmp/pip-install-4cy230dp/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#d?d@„ Z$ejj%dAdB�ejjd*d+d,gƒdCdD„ ƒƒZ&ejjd*d+d,gƒdEdF„ ƒZ'dGdH„ Z(ejjdIdJej)dKdKdLdLgdMdMdNdNgge!d<dOdPdOgdJdQ�fdJdRgdSdTdUdVdWdXdYgdZd[d\dYdYdVgge*j+dµd¶d·d¸d¹dºgdJdRgd_�fgƒd`da„ ƒZ,dbdc„ Z-ejj%dddB�dedf„ ƒZ.ejjdgd»d¼d½d¾gƒdldm„ ƒZ/dndo„ Z0dpdq„ Z1drds„ Z2dtdu„ Z3dvdw„ Z4dxdy„ Z5dzd{„ Z6d|d}„ Z7d~d„ Z8ejjd€dPd]d�d‚djdkggƒdƒd„„ ƒZ9d…d†„ Z:d‡dˆ„ Z;d‰dŠ„ Z<d‹dŒ„ Z=d�dŽ„ Z>d�d�„ Z?d‘d’„ Z@ejj%d“dB�d”d•„ ƒZAejj%d“dB�d–d—„ ƒZBd˜d™„ ZCdšd›„ ZDdœd�„ ZEdždŸ„ ZFd d¡„ ZGd¢d£„ ZHd¤d¥„ ZIejjd¦dSejJfd§ej)fd¨ejKfdSd§gejJej)gfdSd¨gejJejKgfd¨d§gejKej)gfgƒd©dª„ ƒZLejjMd«d¬„ ƒZNd­d®„ ZOd¯d°„ ZPd±d²„ ZQd³d´„ ZRd‚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)r5   r6   r8   r   r   )r   r1   ÚtmÚassert_frame_equalÚlenr6   ÚnamesÚtupleÚAssertionErrorÚnamer7   ÚgroupbyÚaggr.   ÚmeanÚunstack)r2   r8   r6   r7   Ú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Úcol3rJ   rL   rK   r   )r6   r5   r7   ÚaggfuncÚ
fill_valueÚcategory)r6   r5   r7   rM   rN   r8   )r   r   Úlistr   r.   Úsumr6   Úastyper7   rJ   rK   r9   r:   )r2   r8   ÚdfrF   Ú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   rH   r   )ZrowsÚcolsr5   r\   )r7   rM   )r6   rM   r5   rB   )r   r   r.   rQ   ÚTr9   r:   )r2   rS   Ú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   rH   r   r(   r)   r*   i[ i] i\ i^ rV   rW   rX   Údi€„ i ¡ i@B )ÚamountÚcustomerÚmonthr   Úquantityrd   rc   rb   r   F)r   )r<   )r(   rV   )r(   rW   )r(   rX   )r(   r`   )r)   rV   )r)   rW   )r)   rX   )r)   r`   )r*   rV   )r*   rW   )r*   rX   )r*   r`   )r   r   r
   Úfrom_tuplesr9   Zassert_index_equalr7   r6   )r2   rS   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 )NrV   rW   r[   T)Ú
categoriesÚorderedrX   r`   rZ   r   rH   r   r   )r(   r)   r5   r5   r(   r)   )r5   r6   r   )r<   )r6   )r   r   r   r   r
   r   r9   r:   )r2   Zcat1Zcat2rS   rT   Z	exp_indexrF   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 )NrV   rW   rX   r`   r   rH   r   r   é	   )r(   r)   r*   r(   F)ri   r)   r*   )r6   r7   r5   r   )r?   é   r   é   rI   é   )r6   r7   )r7   Úfloat)
r   ÚrangerR   ÚCDTr   r   Zreindexr   r9   r:   )r2   r   rh   rS   rT   Úexpected_columnsÚexpected_indexrF   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)rh   ri   rI   )r(   r)   r(   r)   )r6   r5   r   rH   r   r   r   )r?   )r6   r   )r   r   r   r.   Únanrp   r   r	   Z
from_codesr9   r:   )r2   r   rS   rT   rF   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)   )r6   r5   r   )r?   )r6   )r   r   r	   Úuniquer9   r:   )r2   r   r   rS   rT   rF   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   rH   r   )ÚdtyperV   rW   T)ri   F)Z	ascending)r(   r)   r*   r*   r)   r(   rQ   )r6   r7   r5   rM   ÚmarginsÚAllr   rm   é
   )r?   )r6   r?   r{   éÿÿÿÿ)r   r   r   r   r.   ÚarangeZintpr   Zsort_valuesr   r   r	   ZIntervalr9   Úassert_series_equal)r2   Zordered_catrS   Z	pivot_tabrT   rF   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+   )r6   r7   r(   r*   )r1   r   r(   r*   r9   r:   )r2   rT   rF   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 )NrI   r   )rY   r   r   r   Ú<lambda>@  s    z3TestPivotTable.test_pass_function.<locals>.<lambda>)r6   r7   rI   r*   )r1   r   r*   r6   r9   r:   )r2   rT   rF   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*   )r6   r7   )	r   r1   r@   rA   r.   rB   rC   r9   r:   )r2   r6   r7   rD   rF   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   rH   r   r   rV   rW   )rV   ÚvÚirˆ   Úint64r‰   r   )r5   r6   r7   rN   rM   Úab)r?   )r6   g      ø?g      @g      @g      @Úfloat64)r   Údtypesr>   r   r.   rQ   r   r{   r	   rP   r9   r�   rB   )r2   Úfr[   rT   rF   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 )NrI   )r{   g       @rH   r   )r‘   r’   r�   r“   r6   )r6   r7   r5   c             S   s0   i | ](}|d  j dƒr tjdƒntjdƒ|“qS )r   rW   Ú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>   )r2   r7   r5   rˆ   rS   Zdf_resrT   rF   r   r   r   Útest_pivot_preserve_dtypeso  s    

z)TestPivotTable.test_pivot_preserve_dtypesc             C   s^  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d�|d�}tj||ƒ d S )Nz
2011-01-01z
2011-02-01z
2011-01-02r(   r   rH   r   r   rI   )r6   )r6   r7   g      @g      @g       @r+   )ÚfreqÚperiods)r(   Údtrž   ÚM)Úkeyrœ   z
2011-01-31g      
@)rœ   z
2011-12-31)r(   r   )r(   rH   )r   ÚDatetimeIndexr   r   r6   rc   Údayr
   re   r.   rw   r9   r:   r   r   Ú	Timestampr<   )r2   ÚidxrS   Ú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   )r5   r6   r7   rN   r-   r   )Úaxis)r6   r7   rN   )r   r1   Zdropr9   r:   )r2   rT   rF   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*   )r5   r6   r7   rM   )r   r1   )Úfunc)r2   r   r   r„   ¸  s   z;TestPivotTable.test_pivot_multi_functions.<locals>.<lambda>rB   Ústdr   )Úkeysr¨   c                s   t ˆ jddgddgd| dd�S )Nr+   r,   r(   r)   r*   T)r5   r6   r7   rM   r|   )r   r1   )rª   )r2   r   r   r„   Â  s   )r.   rB   r«   r   r9   r:   )r2   rŽ   rT   ZmeansZstdsrF   r   )r2   r   Útest_pivot_multi_functions·  s    



z)TestPivotTable.test_pivot_multi_functionsr3   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~   é   é   é   )rV   rW   rX   rV   rW   rX   )r?   )r6   r7   z
2014-02-01rl   r+   )r�   rœ   éd   )rV   rX   z
2014-02-02r   r   r   )r   rV   )r   rV   )r   rW   )r   rW   )r.   rw   r   Úpivotr   r	   r9   r:   r]   r   r€   r£   ÚlocZnotnar5   rQ   r;   r>   Ziterrows)	r2   r3   rw   rS   rT   rF   Ú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   rk   r   rH   iÞ  r   rŠ   )r{   )Údt1Údt2Údata1Údata2rº   c             S   s   t j| dd�S )Nz
US/Pacific)Útz)r   r£   )r`   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£   )r`   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)r6   r7   )r6   r7   r5   )r   r   r.   r€   Úapplyr	   r   r¡   r
   r   r´   r9   r:   )r2   r3   rS   Úexp_col1Úexp_col2Úexp_colrF   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)rY   r   r   r   r„   ^  s    z8TestPivotTable.test_pivot_tz_in_values.<locals>.<lambda>rÄ   )r5   r6   r7   rM   )r?   z2016-08-12 00:00:00z2016-08-25 00:00:00)r6   r7   )r   r   r£   Ú	set_indexr™   rÅ   Úmapr   r.   Úminr	   r¡   r9   r:   )r2   rS   ZminsrT   rF   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½   rH   rÐ   )r?   rœ   r   r   r   rÏ   )r6   r7   )r6   r7   r5   )r   r   ÚPeriodr.   r€   r	   ZPeriodIndexr
   r   r´   r9   r:   )r2   r3   rS   rÀ   rÁ   rÂ   rF   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   rH   Z2019Q1Z2019Q2g      ð?)rV   rW   rY   r}   rV   )r?   rW   )r1   r6   r7   rY   T)r6   r7   r5   r|   )r   r   rÑ   r	   r   r9   r:   )r2   rS   rF   rT   r   r   r   Útest_pivot_periods_with_margins§  s    


 z.TestPivotTable.test_pivot_periods_with_marginsr5   Ú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   rH   r   r   rI   rl   rY   rZ   r[   ÚqÚwÚt)r!   r"   rÔ   rÕ   r!   r"   )r6   r7   r5   )r1   r?   rÔ   rÕ   r   )ÚlevelsÚcodesr<   Úobject)r1   r6   r7   r{   )r   r   r´   r	   r
   r9   r:   )	r2   r5   r3   rS   rT   r1   r6   r7   rF   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   rH   r   r   rI   rl   rY   rZ   r[   rÖ   r×   rØ   )r!   r"   rÔ   rÕ   rÕ   r!   )r6   r7   r5   )r1   r?   r"   rÔ   r   )rÙ   rÚ   r<   rÛ   )r1   r6   r7   r{   )	r   r   r´   r.   rw   r	   r
   r9   r:   )	r2   r5   r3   rS   rT   r1   r6   r7   rF   r   r   r   Ú%test_pivot_with_list_like_values_nanså  s*    z4TestPivotTable.test_pivot_with_list_like_values_nansc             C   sT   t jdddgdddgdddgdœƒ}d}tjt|d	�� |jd
dd� W d Q R X d S )NrV   rW   rX   r   rH   r   )rJ   rK   rL   z0pivot\(\) missing 1 required argument: 'columns')ÚmatchrJ   rL   )r6   r5   )r   r   ÚpytestÚraisesÚ	TypeErrorr´   )r2   rS   Úmsgr   r   r   Ú#test_pivot_columns_none_raise_error  s
     z2TestPivotTable.test_pivot_columns_none_raise_errorzBMultiIndexed 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   rH   r   r   rI   )r1   r#   r(   rY   r)   rZ   r*   r[   r$   rÖ   r×   rl   rØ   r"   rÔ   ÚfirstrÈ   )rÙ   rÚ   rÛ   )r1   r6   r7   r{   )r6   r7   r5   )r6   )r(   r)   r*   )r"   rå   )r"   rÈ   )rÔ   rå   )r"   rå   )r"   rÈ   )rÔ   rå   )r	   r
   r   r´   r   r   r9   r:   )r2   r3   r6   r1   r7   rS   rT   rF   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   rH   r   r   rI   rl   rY   rZ   r[   rÖ   r×   rØ   )r!   r"   rÔ   rÕ   z^\('bar', 'baz'\)$)rÞ   rÕ   r!   r"   rÔ   )r6   r7   r5   )r"   rÔ   )r"   rÔ   )r   r   rß   rà   ÚKeyErrorr´   )r2   r3   rS   r   r   r   Útest_pivot_with_tuple_of_valuesC  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dd�}x4dD ],}|jd|f }|ˆ j | jƒ k�s(t‚�q(W 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µ   r6   r1   r@   rB   r9   r�   r?   r>   Z
sort_indexZiloc)rT   Z
values_colr6   r7   Úmargins_colZcol_marginsZexpected_col_marginsZindex_marginsZexpected_ix_marginsZgrand_total_marginsZexpected_total_margins)r2   r   r   Ú_check_outputV  s    z2TestPivotTable.test_margins.<locals>._check_outputr+   T)r5   r6   r7   r|   rM   ZTotals)r5   r6   r7   r|   rM   Úmargins_name)rë   )r6   r7   r|   rM   r   c             S   s   g | ]}|d  ‘qS )rH   r   )r–   Úkr   r   r   ú
<listcomp>†  s    z/TestPivotTable.test_margins.<locals>.<listcomp>ZAAÚBB)r6   r|   rM   rê   rB   ÚDDÚEEÚFF)r}   rê   )rñ   rò   ró   )r}   rê   )r1   r   r.   rB   r7   rÙ   rµ   r>   )r2   rì   rT   rD   Z	value_colZtotalsÚitemr   )r2   r   Útest_marginsU  s2    

zTestPivotTable.test_marginsz*columns, aggfunc, values, expected_columnsr(   g      @gš™™™™™@g       @gš™™™™™@r}   r!   )r?   r)   rQ   rk   é   é   rI   rl   r'   é   é   é    r#   r$   )r<   c             C   s¨   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œƒ}|j|d|d�}t j|tddgƒ|d�}tj||ƒ d S )Nr!   r"   r#   r$   ÚsmallZlarger   rH   r   r   rI   rl   rm   rn   rk   )r(   r)   r*   r+   r,   T)r7   r|   rM   r+   r,   )r6   r7   )r   r   r   r	   r9   r:   )r2   r7   rM   r5   rr   rS   rT   rF   r   r   r   Ú%test_margin_with_only_columns_defined‘  s$    z4TestPivotTable.test_margin_with_only_columns_definedc             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<   é   é   rk   é-   é!   r   é$   é3   éx   )r%   r&   )r6   r*   r   )r¨   r%   r&   T)r5   r6   r7   r|   rM   rN   )r}   rê   )r(   r)   )r1   Úcopyr.   r€   r;   ÚreshaperP   r   r
   re   r   Úrename_axisr   rQ   r9   r:   )r2   rS   Úmi_valÚmirF   rT   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   rH   rI   r   rl   )r%   r&   )r6   r*   )r¨   r%   r&   r+   T)r5   r6   r7   r|   rM   rN   )r}   rê   )r(   r)   )rP   r   r
   re   r   r  r1   r   r;   r9   r:   )r2   r  r  rF   rT   r   r   r   Útest_margins_dtype_lenã  s    $
z%TestPivotTable.test_margins_dtype_lenr\   r   rH   rV   rW   c          	   C   sx   t |d dddg|d dddgddddgiƒ}|jd|d	�}t dddggtjdddg|d
�tdgƒd�}tj||ƒ d S )Nr   r   rH   r   rˆ   r   rI   rl   )r5   r7   )r<   )r7   r6   )r   r   )rH   rH   )r   r   )r   r   r
   re   r	   r9   r:   )r2   r\   Údf2rT   rF   r   r   r   Ú test_pivot_table_multiindex_only÷  s    .
z/TestPivotTable.test_pivot_table_multiindex_onlyc             C   sZ   t dddd�}ttjjdƒtjjdƒ|dœƒ}|jddgdd	�}|jjd
 j|ƒsVt	‚d S )Nz
2016-01-01r   zEurope/Amsterdam)r�   r¾   )r(   r)   r*   r)   r*   F)r6   r   r   )
r   r   r.   r/   r0   r   r6   rÙ   Úequalsr>   )r2   ZdtirS   rT   r   r   r   Útest_pivot_table_retains_tz  s     z*TestPivotTable.test_pivot_table_retains_tzc                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‰   )r`   r   r   rï     s    z=TestPivotTable.test_pivot_integer_columns.<locals>.<listcomp>r²   g      ð?r   r   r   r   rH   )r5   r6   r7   )r7   Ú4Ú0Ú1Ú3Ú2F)ré   )r   rÍ   rP   r   rp   r   r   ÚrenameÚstrr9   r:   )r2   r1   rS   rD   r  rE   r   )r`   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 )NrV   rW   rH   r   r   r!   r   r"   é   )rV   rW   rX   Úvaluer  rX   )r6   r7   Úall)r¨   Úhow)r   r.   r/   r0   r   r@   rB   rC   r   r9   r:   )r2   r1   rD   ZgroupedrF   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       @rB   )r6   r7   rM   )r   r!  )r   r"  )r   r#  )r$  r%  )r$  r&  )r$  r'  )r(  r)  )r(  r*  )r(  r+  )r.   r{   rÛ   Úintro   ÚarrayÚemptyr/   Úrandintr;   r   r   r   Úyearrc   r¢   Z	lognormalr   r   r7   Zis_monotonicr>   )
r2   Únr{   ZproductsÚitemsZiproductZdrÚdatesrS   Zpivotedr   r   r   Útest_pivot_columns_lexsorted4  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«   rQ   )r+   r,   r(   r)   )r6   r7   rM   )r1   r@   rA   rC   r   r9   r:   )r2   rŽ   rF   rT   r   r   r   Útest_pivot_complex_aggfunch  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)r6   rM   r|   r   r   r   )r1   r   r;   ÚtolistrQ   r>   )r2   rT   Úresult_listr   r   r   Útest_margins_no_values_no_colso  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)r6   r7   rM   r|   g      @g      ð?g      @g      &@)r1   r   r;   r}   r7  r>   )r2   rT   r   r   r   Útest_margins_no_values_two_rowsw  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)r6   r7   rM   r|   g      @g      @g      &@)r1   r   r;   r}   r7  r>   )r2   rT   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 )NrV   rW   rX   r`   ÚerŽ   ÚgÚhr‰   Újrî   r+   r(   r)   r*   T)r6   r7   rM   r|   g      @g      ð?g      @g      &@)r1   r   r;   r}   r7  r>   )r2   rT   r   r   r   Ú'test_margins_no_values_two_row_two_cols‡  s     z6TestPivotTable.test_margins_no_values_two_row_two_colsÚmargin_nameiš  Nc             C   s°   d|› d�}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 )
NzConflicting name "z3" in margins|margins_name argument must be a string)rÞ   r+   r(   r)   r*   T)r5   r6   r7   r|   rí   )rß   rà   Ú
ValueErrorr   r1   )r2   rA  râ   r   r   r   Ú-test_pivot_table_with_margins_set_margin_name�  s2    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jtdddƒgdd�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jtdddƒtdddƒgdd�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jtddd(ƒtdd	dƒtdd!d(ƒtdddƒgd*d�tjtddd(ƒtdd	dƒtdd!d(ƒtdddƒgd*d�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   rI   rn   rk   iÝ  r~   rH   rý   )ÚBranchÚBuyerr  ÚDaterF  rù   rŠ   )r{   r,  r(   )rœ   zCarl Joe Mark)r6   r7   rE  r  )r6   r7   r5   rM   rm   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°   é   )rD  rE  r  rF  ÚPayDayrŸ   rI  rl   )r<   r)   rD  )r   Úsplitr   rË   r.   r.  r  r   r¡   r6   r?   r7   r   r   rQ   r9   r:   r]   rw   r™   rß   rà   rç   rB  r
   re   )r2   rS   rF   rT   râ   Ztuplesr¤   r   r   r   Útest_pivot_timegrouper¶  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:00rV   rW   rl   rŠ   )r{   r   rH   r   )Úlabelrº   r»   Úvalue1Úvalue2rº   c             S   s   t j| dd�S )Nz
US/Pacific)r¾   )r   r£   )r`   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£   )r`   r   r   r   r„   ä  s    z
US/Pacific)r¾   r?   rM  rL  )r?   r   r   rI   )r6   r7   )r6   r7   r5   rQ   rB   rN  z
Asia/Tokyo)r6   r7   r5   rM   )r   r.   r€   r¿   r   r¡   r	   r
   r   r   r9   r:   r.  rQ   rB   )r2   Údates1Údates2rS   Úexp_idxrÀ   rÁ   rÂ   rF   rT   Zexp_col3r   r   r   Útest_pivot_datetime_tzÉ  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:00rV   rW   rl   rŠ   )r{   r   rH   r   )rL  rº   r»   rM  rN  rº   c             S   s
   t j| ƒS )N)r   r£   )r`   r   r   r   r„   +  s    z6TestPivotTable.test_pivot_dtaccessor.<locals>.<lambda>r»   c             S   s
   t j| ƒS )N)r   r£   )r`   r   r   r   r„   ,  s    rL  rM  )r6   r7   r5   )r?   r   r   rI   )rm   rn   rk   rm   rn   rk   )r6   r7   )r<   iÝ  ÚXÚY)r   r.   r€   r¿   r   rž   rÆ   r	   r9   r:   rc   r1  r5   r
   r   r.  rw   )r2   rO  rP  rS   rT   rQ  rF   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œ   )r6   )r6   r7   r   r   io  F)ré   )r   r   r.   r/   r0   r;   r   r   r6   r1  Z	dayofyearr7   Ú	droplevelZasarrayrp   r   r9   r�   r?   r>   )r2   ÚrngrÅ   ÚannualZdoyr‰   ÚsubsetrT   r   r   r   Ú
test_dailyc  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œ   )r6   )r6   r7   r   r   rö   F)ré   )r   r   r.   r/   r0   r;   r   r   r   r6   r1  rc   r7   rV  rp   r   r9   r�   r?   r>   )r2   rW  rÅ   rX  rc   r‰   rY  rT   r   r   r   Útest_monthlyv  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 )NrQ   rB   )r+   r,   r(   )r6   r5   rM   c             s   s   | ]
}|V  qd S )Nr   )r–   r  r   r   r   ú	<genexpr>”  s    zGTestPivotTable.test_pivot_table_with_iterator_values.<locals>.<genexpr>)r   r   r1   rP   r¬   r9   r:   )r2   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)r6   r7   r|   rí   rM   rÛ   )r{   r?   rB   r^  Úmax)r<   )r6   r7   )rB   r^  rŸ   )rB   r^  r]   )r_  r^  rŸ   )r_  r^  r]   )r   r   r   r.   rB   r_  r	   r
   re   r5   r9   r:   )r2   rí   ZcostsrD   ÚixZtupsr\   rF   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 )Nrn   r   rH   )rY   rZ   r[   g      ð?g       @g      ø?rI   rl   g      @r   g      @r   r   r}   rZ   )r?   r[   rY   T)r   r|   )
r   r   r.   r€   r	   r6   r7   r   r9   r:   )r2   r8   rS   rF   rD   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 )Nrn   r   rH   )rY   rZ   r[   g      ð?g       @g      ø?rI   rl   g      @r   g      @r   r   r}   rZ   )r?   r[   rO   rY   T)r   r|   )r   r   r.   r€   r	   r6   r7   rZ   rR   r[   r   r9   r:   )r2   r8   rS   rF   rD   r   r   r   Ú!test_categorical_margins_categoryÆ  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 )NrH   r   rl   rn   r   rI   r   rS  rT  )r(   r)   r*   r+   r+   T)r6   r|   rm   g      @g      @g      @g      @)r(   r)   r*   r}   )r?   )r6   )r   r   r   r	   r9   r:   )r2   r8   rS   rT   rF   r   r   r   Útest_margins_casted_to_floatÕ  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 )Nru   rv   r(   r)   )rh   ri   r   rl   )ÚInÚColÚValre  rf  rg  )r6   r7   r5   r8   )ri   r?   g       @g      @)r1   r7   )r?   )r7   r5   r8   g      @)r1   r7   r6   )r.   rw   r   r   r   rp   r   ÚCategoricalIndexr	   r6   r9   r:   )	r2   r8   ri   r¤   r—   rS   rT   Zexpected_colsrF   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*   rV   rW   r   rH   r   r   )r®   r¯   ÚVr®   rO   rj  r¯   Úcount)r6   r7   r   rM   F)rh   ri   r?   )r?   g      ð?g       @)r6   r7   )r   r   rR   r   rh  r	   r.   r.  rw   r9   r:   )r2   r8   rS   rT   rs   rr   Zexpected_datarF   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  rO   ro  r  rQ   )r5   r6   r7   r   rM   )r?   F)rh   ri   r?   i@  )r6   r7   )r   r   rR   r‡   Zset_categoriesr   Z
Int64Indexrh  r   r.   rŠ   r9   r:   )r2   r8   rS   ÚmonthsrT   rr   rs   rF   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   rI   r*   r+   r,   r   rk   )rJ   rK   rL   rJ   rL   rK   )r6   rM   )r<   )r6   r7   )r6   r7   rM   )r?   rQ   )
r   r   r.   rQ   r
   r   r9   r:   ÚNaNr	   )r2   rS   rT   rf   rF   r   r   r   Útest_pivot_table_not_seriesM  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   rH   r   T)r6   rM   r|   rí   rÛ   )r{   r?   )r6   )r   r   r   r;   r	   r9   r:   )r2   ÚgreekÚframerD   r6   rF   r   r   r   Útest_pivot_margins_name_unicodei  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)   rQ   )r6   r7   rM   r*   r   r   )rÙ   rÚ   r<   r°   rö   )r"   r!   rm   r²   )r7   rB   g      @g      
@g      @g«ªªªªª@)r*   r#   )r*   r$   )rB   r*   r#   )rB   r*   r$   )rQ   r*   r#   )rQ   r*   r$   )r   rp   r   r
   r  r9   r:   )r2   r1   rT   r  rF   r   r   r   Útest_pivot_string_as_funct  sZ    & 


z(TestPivotTable.test_pivot_string_as_funcz
f, f_numpyrB   r«   c             C   s4   t | jdd|d�}t | jdd|d�}tj||ƒ d S )Nr(   r)   )r6   r7   rM   )r   r1   r9   r:   )r2   rŽ   Zf_numpyrT   rF   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 )NrH   r  r   )Úind1Úind2rk  z6Unstacked DataFrame is too big, causing int32 overflow)rÞ   r{  r|  rk  )r6   r7   r5   rM   i   i   )r   r.   r€   rß   rà   rB  r   )r2   rS   râ   r   r   r   Ú-test_pivot_number_of_levels_larger_than_int32Ä  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   rH   rm   rl   )ÚfruitÚsizeÚtastec             S   s   dS )Nr   r   )rY   r   r   r   Úret_oneÛ  s    z?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_onec             S   s   t | ƒS )N)rQ   )rY   r   r   r   Úret_sumÞ  s    z?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_sumc             S   s   t jS )N)r.   rw   )rY   r   r   r   Úret_noneá  s    z@TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_noner~  )r7   rM   r   r   rö   r‚  rƒ  r�  )r<   r  r€  )r6   r7   r7   )r¨   )
r   r   r   r.   rw   r
   Zfrom_productr   r9   r:   )
r2   r   rS   r�  r‚  rƒ  rT   r1   r—   rF   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   rH   r   )r(   rY   rZ   r(   )r7   rM   r   g      @)r?   rY   rZ   )r6   r7   r7   )r¨   )
r   r   r.   rw   r   rB   r	   r   r9   r:   )r2   r   rS   rT   r1   r—   rF   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 )NrH   r   rI   rl   rm   rn   rk   ÚprÖ   )r(   Úidr*   r+   r(   r+   r‡  )r6   r7   r5   rM   )r   r   r   r.   r  r9   r:   )r2   rS   rT   rF   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.   rB   )Úlr   r   r   rA     s    z=TestPivotTable.test_pivot_table_no_column_raises.<locals>.aggr   r   r~   r²   rH  é(   )rS  rT  ÚZZ
notpresent)rÞ   rS  rT  )rM   )r   r   rß   rà   rç   r   )r2   rA   r!   r   r   r   Ú!test_pivot_table_no_column_raises  s
    &z0TestPivotTable.test_pivot_table_no_column_raises)r"   r#   )r"   r$   )r"   r}   )r!   r#   )r!   r$   )r!   r}   )r   rH   )rV   rW   )r   rW   )rV   r   )SÚ__name__Ú
__module__Ú__qualname__r4   rG   rU   r_   rg   rj   rt   rx   rz   r‚   rƒ   r…   r†   r�   rß   ÚmarkZparametrizer›   r§   r©   r­   r¹   rÃ   rÎ   rÒ   rÓ   r.   r.  r   r   r	   rÜ   rÝ   rã   Zxfailræ   rè   rõ   rB   r
   re   rü   r	  r
  r  r  r  r  r5  r6  r9  r:  r;  r@  rC  rK  rR  rU  rZ  r[  r]  ra  rb  rc  rd  ri  rl  rs  ru  rx  ry  rQ   r«   rz  Zslowr}  r„  r…  rˆ  rŒ  r   r   r   r   r    "   sØ   0%3$
%	6<7."	'<$4	$&  GS'+> 
#r    )r   r   r   Ú	itertoolsr   Znumpyr.   rß   Zpandasr   r   r   r   r	   r
   r   r   r   Zpandas._testingZ_testingr9   Zpandas.api.typesr   rq   Zpandas.core.reshape.pivotr   Zfixturer   rp   r   r    r   r   r   r   Ú<module>   s   (

8