a
    DBìj÷�  ã                   @   sX  d 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mZ ddlmZ ddlmZ dd„ Zdd„ Zejjej d	d
dg¡ej dddg¡ej dddg¡ejjdddddgged�ejjddddgged�ej dd
dg¡ej dddg¡ej dd
dg¡ej dd
dg¡ej dd
dg¡dd„ ƒƒƒƒƒƒƒƒƒƒƒZej d d
dg¡d!d"„ ƒZej d#d$d%gg d&¢g¡d'd(„ ƒZej d#d$d%gg d&¢g¡d)d*„ ƒZd+d,„ Zd-d.„ Zejd/d0„ ƒZ d1d2„ Z!d3d4„ Z"d5d6„ Z#d7d8„ Z$ej d9g d:¢¡ej dddg¡ej d;g d<¢¡ej d=d
dg¡ej d>d
dg¡d?d@„ ƒƒƒƒƒZ%ej dAd
dg¡ej dBddg dC¢g dD¢g dE¢fd
dg dF¢g dG¢g dH¢fd
d
g dI¢g dJ¢g dK¢fg¡dLdM„ ƒƒZ&ejdNdO„ ƒZ'ej dPddddQg dR¢g dS¢fd
d
ddQg dT¢g dU¢fd
dddQg dV¢g dW¢fd
dd
dXg dY¢g dW¢fg¡dZd[„ ƒZ(ejd\d]„ ƒZ)ej d^ddg d_¢g d`¢fdd
g da¢g db¢fd
dg dc¢g dd¢fd
d
g de¢g df¢fg¡dgdh„ ƒZ*ejdidj„ ƒZ+ej dkd
dldlge
j,g dm¢g dn¢do�fdg dp¢e
e	dlgƒe	g dq¢ƒe	drdsej-gƒgg dt¢g du¢g dv¢gg dn¢dw�fg¡ej dddg¡dxdy„ ƒƒZ.ej d=dd
g¡ej dzdd
g¡ej d{ddQej/g d|¢ej0d}�fd
dXe /g d~¢¡fg¡dd€„ ƒƒƒZ1d�d‚„ Z2ej d=d
dg¡ej d{ddQej/g d|¢ej0d}�fd
dXe /g d~¢¡fg¡dƒd„„ ƒƒZ3ej d=d
dg¡ej d{ddQej/g d…¢ej0d}�fd
dXe /g d†¢¡fg¡d‡dˆ„ ƒƒZ4ej d=d
dg¡ej d‰dg dŠ¢fd
g d‹¢fg¡ej d{ddQej/g dŒ¢ej0d}�fd
dXe /g d�¢¡fg¡dŽd�„ ƒƒƒZ5ej d=dd
g¡ej dzdd
g¡ej d{ddQej/g d|¢ej0d}�fd
dXe /g d~¢¡fg¡d�d‘„ ƒƒƒZ6ej d’ddQg d“¢fd
dXg df¢fg¡d”d•„ ƒZ7ej d–d—e8d˜ƒg d™¢fdše8d›ƒdœg g d�¢fg¡ej d=dd
g¡dždŸ„ ƒƒZ9ej d ddg¡d¡d¢„ ƒZ:d£d¤„ Z;d¥d¦„ Z<d§d¨„ Z=d©dª„ Z>d«d¬„ Z?ej d d
dg¡d­d®„ ƒZ@d¯d°„ ZAej d±d
dg¡ej dAd
dg¡d²d³„ ƒƒZBej d±d
dg¡ej dAd
dg¡d´dµ„ ƒƒZCdS )¶z­
these are systematically testing all of the args to value_counts
with different size combinations. This is to ensure stability of the sorting
and proper parameter handling
é    N)	ÚCategoricalÚCategoricalIndexÚ	DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚ
date_rangeÚto_datetime)ÚVersionc                  C   sˆ   t dgdgdœƒ} | d  d¡| d< |  d¡d  ¡ }t ddggddgd�}|d  d¡|d< t |¡}tdg|d	d
�}t ||¡ d S )NÚfemaleÚUS)ÚgenderÚcountryr   Úcategoryr   ©Úcolumnsé   Úcount©ÚindexÚname)	r   ÚastypeÚgroupbyÚvalue_countsr   Ú
from_framer   ÚtmÚassert_series_equal)ÚdfÚresultZdf_mi_expectedZmi_expectedÚexpected© r!   úm/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/groupby/methods/test_value_counts.pyÚ.tests_value_counts_index_names_category_column   s    þÿ
r#   c                 C   sÞ   t ddd�}ttj d¡ tdƒ|¡tj d¡ ||¡tj d¡ d|d |¡dœƒ}| rÚ|d  d	¡|d< tj	|j
dd d
…df< tj	|j
dd d…df< tj	|j
dd d…df< tj	|j
dd d…df< tj	|j
dd d…df< |S )Nz
2015-08-24é
   )Zperiodsé   Úabcdr   )Ú1stÚ2ndÚ3rdr)   Úfloaté   r'   é   é   r(   é   é   é   é	   )r	   r   ÚnpÚrandomZdefault_rngÚchoiceÚlistZintegersr   ÚnanÚloc)Ú	seed_nansÚnÚmÚdaysÚframer!   r!   r"   Úseed_df.   s    ýÿr=   r8   TFÚnum_rowsr$   é2   Úmax_inté   é   Úkeysr'   r(   )ZidsÚbinsÚisortznormalize, name)TÚ
proportion)Fr   ÚsortÚ	ascendingÚdropnac                 C   sº   t | ||ƒ}dd„ }|||	|
|dœ}|j||d�}|d jf i |¤Ž}|j||d�}|d jtjfi |¤Ž}|jjd d… dg |j_| |¡}t|||fƒ\}}t	 
| ¡ | ¡ ¡ d S )Nc                 S   s2   t t| jjt| jjƒƒƒ}tj|| jjd�| _| S )N©Únames)	r5   Úmapr   Zget_level_valuesÚrangeZnlevelsr   Úfrom_arraysrK   )r   Zarrr!   r!   r"   Úrebuild_index_   s    z7test_series_groupby_value_counts.<locals>.rebuild_index)Ú	normalizerG   rH   rI   rD   ©rG   r)   éÿÿÿÿ)r=   r   r   Úapplyr   r   rK   ÚrenamerL   r   r   Ú
sort_index)r8   r>   r@   rC   rD   rE   rP   r   rG   rH   rI   r   rO   ÚkwargsÚgrÚleftÚrightr!   r!   r"   Ú test_series_groupby_value_countsE   s     û
rZ   Úutcc                 C   s�   t g d¢g d¢dœƒ dg¡}t|d | dd�|d< | td	dd
�¡}|d  ¡  ¡ }|d  tj¡ ¡ }|j	j
|j	_
| d¡}t ||¡ d S )N©i©GI]i)™J]i�™J]i©êK]i)<M]iU=M]i©�N]©Úappler^   Úbananar_   Úoranger`   Úpear©Ú	TimestampÚFoodr,   rc   Ús©r[   ÚunitÚDatetimeÚ1D©ÚfreqÚkeyrd   r   )r   Údropr
   r   r   r   rU   rS   r   r   rK   rT   r   r   )r[   r   Údfgr   r    r!   r!   r"   Ú-test_series_groupby_value_counts_with_grouperz   s    	öÿó
ro   r   ÚAÚB)rp   rq   ÚCc                 C   sf   t | d�}| | d d… ¡}|| d   ¡ }tg |jdd�}tjg gt| ƒ | d�|_t	 
||¡ d S )Nr   rR   r   )Údtyper   rJ   )r   r   r   r   rs   r   rN   Úlenr   r   r   ©r   r   rn   r   r    r!   r!   r"   Ú&test_series_groupby_value_counts_empty™   s    
rv   c                 C   sP   t tt| ƒƒg| d�}| | d d… ¡}|| d   ¡ }| ¡ }t ||¡ d S )N)Údatar   rR   )r   rM   rt   r   r   r   r   ru   r!   r!   r"   Ú(test_series_groupby_value_counts_one_row¦   s
    rx   c                  C   sp   t tdgddgd�ƒ} |  dg¡ ¡ }t ddgt t ddg¡tddgddgddd�g¡d	d
�}t	 
||¡ d S )NÚaÚb)Ú
categoriesr   r   Fr   )r{   Úorderedrs   r   ©rw   r   r   )r   r   r   r   r   rN   r2   Úarrayr   r   r   )re   r   r    r!   r!   r"   Ú/test_series_groupby_value_counts_on_categorical²   s    ÿþÿör   c                  C   s–   t g d¢g d¢g d¢dœƒ} | jddgdd�d	 }|jdd�}td
dgddgg d¢gg d¢g d¢g d¢gg d¢d�}tg d¢|dd�}t ||¡ d S )N©Úmaler�   r   r�   r   r�   ©ÚlowÚmediumÚhighrƒ   r…   rƒ   ©r   ÚFRr   r‡   r‡   r‡   ©r   Ú	educationr   r   r   FrQ   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‰   ©ÚlevelsÚcodesrK   ©r   r   r   r%   r   r   r   )r   r   r   r   r   r   r   )r   Úgbr   r   r    r!   r!   r"   Ú(test_series_groupby_value_counts_no_sortÍ   s    ýÿýr�   c                   C   s   t g d¢g d¢g d¢dœƒS )Nr€   r‚   r†   rˆ   ©r   r!   r!   r!   r"   Úeducation_dfá   s    ýÿr’   c                 C   sz   d}t jt|d�� | jddd�}W d   ƒ n1 s60    Y  tjtdd�� | ¡  W d   ƒ n1 sl0    Y  d S )Nz+DataFrame.groupby with axis=1 is deprecated©Úmatchr   r   ©Úaxisr–   )r   Úassert_produces_warningÚFutureWarningr   ÚpytestÚraisesÚNotImplementedErrorr   )r’   ÚmsgÚgpr!   r!   r"   Ú	test_axisì   s
    ,rž   c                 C   sJ   |   d¡}tjtdd�� |jdgd� W d   ƒ n1 s<0    Y  d S )Nr   Úsubsetr“   ©rŸ   )r   r™   rš   Ú
ValueErrorr   )r’   r�   r!   r!   r"   Útest_bad_subsetô   s    
r¢   c                 C   sv   t tjƒt dƒkr(| tjjddd�¡ |  d¡ddg jdd	�}t	g d
¢t
jg d¢g d¢d�dd�}t ||¡ d S )Nú1.25úYpandas default unstable sorting of duplicatesissue with numpy>=1.25 with AVX instructionsF©ÚreasonÚstrictr   r   r‰   T©rP   )ç      à?ç      Ð?rª   r©   r©   )©r‡   r�   rƒ   ©r‡   r   r…   ©r‡   r�   r„   ©r   r   r…   ©r   r�   rƒ   rŠ   rJ   rF   r}   )r   r2   Ú__version__Úapplymarkerr™   ÚmarkÚxfailr   r   r   r   Úfrom_tuplesr   r   )r’   Úrequestr   r    r!   r!   r"   Ú
test_basicú   s&    ûÿ	ÿø
ôr¶   c                 C   s   | | j |||d�S )N©rP   rG   rH   )r   )r   rC   rP   rG   rH   r!   r!   r"   Ú_frame_value_counts  s    r¸   r   ©Úcolumnr~   Úfunctionzsort, ascending))FN)TT)TFÚas_indexr<   c
                    sÊ  t tjƒt dƒkr4|r4|r4|r4| tjjddd�¡ dˆ d j‡ fdd„dœ| }
ˆ j|
|d	�}|d
dg j	|||d�}|�r€|dkrŠt
nd }d}tj||d��& | td
dg|||¡}W d   ƒ n1 sÌ0    Y  |rèt ||¡ n”|rðdnd}| ¡ jd|idd�}|dk�r>|jddidd�}t |d dd¡|d< n2|dk�rZ|d dk|d< nt |d dd¡|d< t ||¡ �nFˆ d
 d ˆ d  ˆ d< |d j	|||d�}||_|�rZ|jjdd�}|d j d¡j d¡|d
< |d j d¡j d¡|d< |d= |jdd idd�}t |¡|_|j ¡ d �rLd g|jjdd …  |j_t ||¡ nl| dd
|d j d¡j d¡¡ | dd|d j d¡j d¡¡ |	�r´|  dddœ¡}|d= t ||¡ d S )Nr£   r¤   Fr¥   r   c                    s   ˆ d |  dkS )Nr   r   r!   )Úx©r’   r!   r"   Ú<lambda>K  ó    z6test_against_frame_and_seriesgroupby.<locals>.<lambda>r¹   )Úbyr¼   r   r‰   r·   rº   z7DataFrameGroupBy.apply operated on the grouping columnsr“   rF   r   r   r   r•   Úlevel_0r   r‡   r»   ú-Zboth©r   r%   Ústr)r   r‰   )!r   r2   r°   r±   r™   r²   r³   Úvaluesr   r   r˜   r   r—   rS   r¸   r   Úreset_indexrT   ÚwhereÚassert_frame_equalr   r   Zto_framerÅ   ÚsplitÚgetr   r   r   ZisnarK   Úinsertr   )r’   r   rP   r   rG   rH   r¼   r<   rµ   Úusing_infer_stringrÁ   r�   r   Úwarnrœ   r    Zindex_frameZindex_frame2r!   r¾   r"   Ú$test_against_frame_and_seriesgroupby  sp     ûÿ

ýüÿÿ"

ÿ""rÏ   rP   zCsort, ascending, expected_rows, expected_count, expected_group_size)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   r%   rÐ   r,   )r   r   r   r   r%   )r   r,   r   r   r,   c	                    s  |}	ˆ  |	¡‰ˆj  |	¡ˆ_ˆjddgddd�}
|
d j|||d�}tƒ }dD ]4‰ ‡ ‡fdd	„|D ƒ|ˆ < |  |	¡}|j  |	¡|_qN|rº||d
< |d
  |  < |	dkrÚ|d
  ¡ |d
< n ||d< |	dkrÚ|d  ¡ |d< |rø|	tkrø|  ddddœ¡}t ||¡ d S )Nr   r   F©r¼   rG   r‰   r·   rŠ   c                    s   g | ]}ˆˆ  | ‘qS r!   r!   ©Ú.0Úrow©rº   r’   r!   r"   Ú
<listcomp>¤  rÀ   z!test_compound.<locals>.<listcomp>rF   zstring[pyarrow]r   rÅ   )	r   r   r   r   r   Zconvert_dtypesÚobjectr   rÉ   )r’   rP   rG   rH   Úexpected_rowsZexpected_countZexpected_group_sizeZany_string_dtyperÍ   rs   r�   r   r    r!   rÕ   r"   Útest_compound†  s2    
ÿ

ÿrÙ   c                   C   s$   t g d¢g d¢g d¢dœg d¢d�S )N©r   r   r   r   )r%   rÐ   rÐ   é   )r%   r   r   r   ©rl   Znum_legsZ	num_wings)ZfalconÚdogÚcatÚantrÄ   r‘   r!   r!   r!   r"   Ú
animals_df¹  s    þrà   z?sort, ascending, normalize, name, expected_data, expected_indexr   ©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Û   )r   r%   r   rF   )r©   rª   rª   c           
      C   s^   | j |||d�}t|tj|g d¢d�|d�}t ||¡ |  d¡j |||d�}	t |	|¡ d S )N)rG   rH   rP   rÜ   rJ   r}   rl   )r   r   r   rN   r   r   r   )
rà   rG   rH   rP   r   Úexpected_dataÚexpected_indexÚresult_framer    Úresult_frame_groupbyr!   r!   r"   Útest_data_frame_value_countsÁ  s    ÿÿû
ÿrê   c                  C   s`   t j} tdd| d| ddddg	ddd| | ddddg	dddddd| d| g	ddddddd| | g	d	œƒS )
Nr   rÐ   rÛ   r,   r%   rA   r0   r.   )rp   rq   rr   ÚD)r2   r6   r   )r9   r!   r!   r"   Únulls_dfé  s    üÿrì   z:group_dropna, count_dropna, expected_rows, expected_values)	r   r   r,   rA   r.   rÛ   r0   r%   rÐ   )	r©   r©   ç      ð?rª   rª   rª   rª   rí   rí   )r   r   r,   rA   r%   rÐ   )r©   r©   rí   rí   rí   rí   )r   r   rA   r.   rÛ   r0   )r©   r©   rª   rª   rª   rª   )r   r   rA   )r©   r©   rí   c                    s    t tjƒt dƒkr,|s,| tjjddd�¡ ˆjddg|d�}|jdd|d	�}t	ƒ }ˆj
D ]‰ ‡ ‡fd
d„|D ƒ|ˆ < qZt |¡}	t||	dd�}
t ||
¡ d S )Nr£   r¤   Fr¥   rp   rq   )rI   T)rP   rG   rI   c                    s   g | ]}ˆˆ  | ‘qS r!   r!   rÒ   ©rº   rì   r!   r"   rÖ     rÀ   z,test_dropna_combinations.<locals>.<listcomp>rF   r}   )r   r2   r°   r±   r™   r²   r³   r   r   r   r   r   r   r   r   r   )rì   Zgroup_dropnaZcount_dropnarØ   Úexpected_valuesrµ   r�   r   r   r   r    r!   rî   r"   Útest_dropna_combinationsö  s    ûÿ	

rð   c                 C   s    t g d¢g d¢d| | dgdœƒS )NrÚ   )ÚJohnÚAnnerñ   ÚBethÚSmithÚLouise©rl   Z
first_nameZmiddle_namer‘   )Znulls_fixturer!   r!   r"   Únames_with_nulls_df  s    
ýÿr÷   z%dropna, expected_data, expected_indexr   )©r   r   )ró   rñ   )rõ   rô   rö   rJ   rÚ   )rò   ró   rñ   rõ   rô   )r   r   r   r   )r   r   r%   r%   )r%   r   r   r%   r‹   c           	      C   s`   | j ||d�}t|||d�}|r0|tt|ƒƒ }t ||¡ |  d¡j ||d�}t ||¡ d S )N)rI   rP   r}   rl   )r   r   r*   rt   r   r   r   )	r÷   rI   rP   r   ræ   rç   rè   r    ré   r!   r!   r"   Ú#test_data_frame_value_counts_dropna&  s    !ý
ÿrù   Úobservedznormalize, name, expected_data)r%   r   r   r   r   r   r   r   r   r   r   r   ©rs   )r©   rª   rª   ç        rü   rü   r©   r©   rü   rü   rü   rü   c                 C   sÐ   t tjƒt dƒkr(| tjjddd�¡ |  d¡jd||d�}|j	|d�}t
jg d	¢g d
¢d�}	t||	|d�}
tdƒD ]"}|
jjt|
jj| ƒ|d�|
_qv|r¬t ||
¡ n |
j|r¸dndd�}t ||¡ d S )Nr£   r¤   Fr¥   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�   r…   ©r   r�   r„   rŠ   rJ   r}   r,   ©ÚlevelrF   r   ©r   )r   r2   r°   r±   r™   r²   r³   r   r   r   r   r´   r   rM   r   Ú
set_levelsr   rŒ   r   r   rÇ   rÉ   ©r’   r¼   rú   rP   r   ræ   rµ   r�   r   rç   Úexpected_seriesÚir    r!   r!   r"   Ú=test_categorical_single_grouper_with_only_observed_categoriesY  s<    ûÿ

ÿñýÿ

ÿr  c                 C   sÔ   |   ¡  d¡} | d j dg¡| d< | jd||d�}|j|d�}t|tj|g d¢d�|d�}	t	d	ƒD ]@}
t
|	jj|
 ƒ}|
d
kr’| | d jj¡}|	jj||
d�|	_qd|r¸t ||	¡ n|	j|d�}t ||¡ d S )Nr   r   ÚASIArý   r¨   rŠ   rJ   r}   r,   r   r  r  )Úcopyr   rÞ   Zadd_categoriesr   r   r   r   r´   rM   r   r   rŒ   Zset_categoriesr{   r	  r   r   rÇ   rÉ   )r’   r¼   rú   rç   rP   r   ræ   r�   r   r  r  Zindex_levelr    r!   r!   r"   Ú!assert_categorical_single_grouper¤  s.    þú
ÿr  c              	   C   sJ   t tjƒt dƒkr(| tjjddd�¡ g d¢}t| |d||||d� d S )Nr£   r¤   Fr¥   rþ   T©r’   r¼   rú   rç   rP   r   ræ   ©r   r2   r°   r±   r™   r²   r³   r  ©r’   r¼   rP   r   ræ   rµ   rç   r!   r!   r"   Ú-test_categorical_single_grouper_observed_trueÇ  s"    ûÿ
ù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©   rü   rü   rü   rü   rü   rü   rü   rü   rü   rü   c              	   C   sJ   t tjƒt dƒkr(| tjjddd�¡ g d¢}t| |d||||d� d S )Nr£   r¤   Fr¥   )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ƒ   )r  r�   r„   r  r  r  r!   r!   r"   Ú.test_categorical_single_grouper_observed_false  s"    ,ûÿ
ùr  zobserved, expected_index)©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�   )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í   rü   rí   rü   rí   rü   rí   rü   rí   rü   rü   rü   c                 C   sÚ   |   ¡ } | d  d¡| d< | d  d¡| d< | jddg||d�}|j|d�}t|r^||dk n|tj|g d¢d�|d	�}	td
ƒD ]"}
|	jj	t
|	jj|
 ƒ|
d�|	_q€|r¶t ||	¡ n |	j|rÂdndd�}t ||¡ d S )Nr   r   r‰   rý   r¨   rü   )r   r‰   r   rJ   r}   r%   r  rF   r   r  )r  r   r   r   r   r   r´   rM   r   r	  r   rŒ   r   r   rÇ   rÉ   )r’   r¼   rú   rç   rP   r   ræ   r�   r   r  r  r    r!   r!   r"   Ú"test_categorical_multiple_groupersX  s2    7
ÿþúÿ

ÿr  c                 C   sø   t tjƒt dƒkr(| tjjddd�¡ |  ¡ } | d  d¡| d< | d  d¡| d< | j	d||d	�}|j
|d
�}g d¢}	t|tj|	g d¢d�|d�}
tddƒD ]"}|
jjt|
jj| ƒ|d�|
_qž|rÔt ||
¡ n |
j|ràdndd�}t ||¡ d S )Nr£   r¤   Fr¥   r   r   r‰   r   rý   r¨   rþ   rŠ   rJ   r}   r   r,   r  rF   r   r  )r   r2   r°   r±   r™   r²   r³   r  r   r   r   r   r   r´   rM   r   r	  r   rŒ   r   r   rÇ   rÉ   r
  r!   r!   r"   Útest_categorical_non_groupers®  s>    ûÿ
þúÿ

ÿr  z*normalize, expected_label, expected_valuesrâ   c                 C   s†   t g d¢g d¢dœƒ}|jg d¢ddd„ gdd	�}|jd
| d�}t dtjg d¢td�dg d¢dg d¢dg d¢||iƒ}t ||¡ d S )Nrá   ©r   r%   r,   )rp   rq   )rÐ   rA   rÐ   rp   c                 S   s   | dkrdS dS )Nr   r.   r0   r!   )r  r!   r!   r"   r¿     rÀ   z&test_mixed_groupings.<locals>.<lambda>F©r¼   T©rG   rP   rÂ   )rÐ   rÐ   rA   rû   rä   Zlevel_2)r0   r0   r.   rq   )r   r,   r%   )r   r   r   r2   r~   Úintr   rÉ   )rP   Úexpected_labelrï   r   r�   r   r    r!   r!   r"   Útest_mixed_groupingsü  s    	ûÿ	r"  ztest, columns, expected_namesÚrepeatZabbde)ry   NÚdrz   rz   Úer  r&   Úlevel_1)ry   Nr$  rz   Úcr&  c           
      C   sº   t g d¢g d¢g|d�}ddg}dtjddgtjd	�d
g}|j||d� ¡ }|rvtdtj||d�dd�}t	 
||¡ n@dd„ |D ƒ}t|ƒ}	d|	d< |	 d¡ t ||	d�}t	 ||¡ d S )N)r   r,   rA   r.   r1   )r%   rÐ   rÛ   r0   r$   r   )r   r   r.   r,   rA   r1   )r%   r   r0   rÐ   rÛ   r$   ry   r   r   rû   r$  r  rø   rJ   r   r}   c                 S   s   g | ]}t |ƒd g ‘qS )r   )r5   rÒ   r!   r!   r"   rÖ   .  rÀ   z0test_column_label_duplicates.<locals>.<listcomp>r&  )r   r2   r~   Úint64r   r   r   r   r´   r   r   r5   ÚappendrÉ   )
Útestr   Zexpected_namesr¼   r   ræ   rC   r   r    Zexpected_columnsr!   r!   r"   Útest_column_label_duplicates  s(    þú
r+  znormalize, expected_labelc                 C   sl   t g d¢gdd|gd�jddd�}d|› d�}tjt|d	�� |j| d
� W d   ƒ n1 s^0    Y  d S )Nr  ry   rz   r   Fr  zColumn label 'z' is duplicate of result columnr“   r¨   )r   r   r™   rš   r¡   r   )rP   r!  r�   rœ   r!   r!   r"   Útest_result_label_duplicates6  s    	ÿr,  c                  C   sf   t dddgiƒ} |  tjddgtjd�¡}| ¡ }tdgtjddggd dgd�dd�}t	 
||¡ d S )Nry   r   rû   r%   rJ   r   r   )r   r   r2   r~   r(  r   r   r   r´   r   r   )r   r�   r   r    r!   r!   r"   Útest_ambiguous_groupingG  s    ÿr-  c                  C   sh   t g d¢g d¢dœg d¢d�} d}tjt|d��$ |  d¡jdgd	� W d   ƒ n1 sZ0    Y  d S )
N©ry   rz   r'  ©r½   Úyr0  ©Úc1Úc2©r   r   r   rÄ   z;Keys {'c1'} in subset cannot be in the groupby column keys.r“   r2  r    ©r   r™   rš   r¡   r   r   ©r   rœ   r!   r!   r"   Ú"test_subset_overlaps_gb_key_raisesR  s    r7  c                  C   sh   t g d¢g d¢dœg d¢d�} d}tjt|d��$ |  d¡jd	gd
� W d   ƒ n1 sZ0    Y  d S )Nr.  r/  r1  r4  rÄ   z4Keys {'c3'} in subset do not exist in the DataFrame.r“   r2  Úc3r    r5  r6  r!   r!   r"   Ú!test_subset_doesnt_exist_in_frameZ  s    r9  c                  C   sp   t g d¢g d¢dœg d¢d�} | jdd�jdgd	�}td
dgtjdd
gddggd dgd�dd�}t ||¡ d S )Nr.  r/  r1  r4  rÄ   r   r  r3  r    r   r%   r½   r0  rJ   r   r   ©r   r   r   r   r   rN   r   r   ©r   r   r    r!   r!   r"   Útest_subsetb  s    ýr<  c                  C   s€   t g d¢g d¢g d¢gg d¢g d¢d�} | jdd�jdgd	�}td
dgtjdd
gddgddggg d¢d�dd�}t ||¡ d S )N)ry   r½   r½   )rz   r0  r0  r4  )r2  r3  r3  )r   r   r   r  r3  r    r   r%   r½   r0  )Nr3  r3  rJ   r   r   r:  r;  r!   r!   r"   Útest_subset_duplicate_columnsn  s    ýÿûr=  c           	      C   sÄ   t g d¢g d¢dœƒ dg¡}t|d | dd�j |¡|d< | td	dd
�¡}| ¡ }tg d¢| d� |¡}|d  ¡ }t	||g d¢gg d¢t
dƒg d¢gg d¢d�}td|dd�}t ||¡ d S )Nr\   r]   rb   r,   rc   re   rf   rh   ri   rj   )z
2019-08-06z
2019-08-07z
2019-08-09z
2019-08-10)r[   )r^   r_   r`   ra   )r   r   r   r%   r%   r,   rÛ   )r   r   r   r%   r%   r,   )rh   rc   rd   r‹   r   r   r   )r   rm   r
   ÚdtZas_unitr   r   r   Úuniquer   rM   r   r   r   )	r[   rg   r   r�   r   ÚdatesZ
timestampsr   r    r!   r!   r"   Útest_value_counts_time_grouper€  s.    	öÿóÿþýrA  c                  C   sj   t g d¢g d¢g d¢dœƒ} | jddgddd�}|d	  ¡ }t g d¢g d¢g d¢dd
œƒ}t ||¡ d S )N)ry   ry   ry   )ry   ry   r$  r.  r  r   r%   FrÑ   r,   )r   r%   r,   r   )r   r   r   r   rÉ   )r   r�   r   r    r!   r!   r"   Ú!test_value_counts_integer_columns¢  s    ÿrB  Úvc_sortc           
      C   sà   t g d¢g d¢dœƒ}|jd| d�}|j||d�}|r@g d¢}ng d¢}td	d
gddggg d¢g d¢gddgd�}t|||r€dndd�}| rš|ršg d¢}	n,| r¬|s¬g d¢}	n| s¾|r¾g d¢}	ng d¢}	| |	¡}t ||¡ d S )N©r%   r   r   r   ©r,   rÐ   r,   r,   ©ry   r   ry   rQ   r  )çUUUUUUå?çUUUUUUÕ?rí   rå   r   r%   r,   rÐ   )r   r   r   )r   r   r   r   r‹   rF   r   r   )r   r   r%   )r   r%   r   )r%   r   r   )r   r   r   r   r   Útaker   r   )
rG   rC  rP   r   r�   r   rÆ   r   r    Útakerr!   r!   r"   Útest_value_counts_sort­  s&    
"ÿ



rK  c           
      C   sä   t g d¢g d¢dœdd�}|jd| dd�}|j||d	�}|rFg d
¢}ng d¢}|rVdnd}t dtg d¢ƒdtg d¢ƒ||iƒ ddg¡| }| rž|ržg d¢}	n,| r°|s°g d¢}	n| sÂ|rÂg d¢}	ng d¢}	| |	¡}t ||¡ d S )NrD  rE  rF  r   rû   ry   T)rG   rú   r  )rG  rH  rí   rü   )r%   r   r   r   rF   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   Z	set_indexrI  r   r   )
rG   rC  rP   r   r�   r   rÆ   r   r    rJ  r!   r!   r"   Ú"test_value_counts_sort_categoricalÊ  s4    
ýÿúú



rL  )DÚ__doc__Únumpyr2   r™   Zpandasr   r   r   r   r   r   r   r	   r
   Zpandas._testingZ_testingr   Zpandas.util.versionr   r#   r=   r²   ZslowZparametrizeÚreprrZ   ro   rv   rx   r   r�   Zfixturer’   rž   r¢   r¶   r¸   rÏ   rÙ   rà   rê   rì   rð   r÷   rN   r6   rù   r~   r(  r  r  r  r  r  r  r"  r5   r+  r,  r-  r7  r9  r<  r=  rA  rB  rK  rL  r!   r!   r!   r"   Ú<module>   sÐ  ,*




 þ\ýþ*
úüþ

ü÷þ


þý	
ýùý÷þýýúþ:#ýýúþ*
ÿýÿýøþ&0þþîþ ýüúþ%ýüúþ<þþ
þþþþ


!