3
®ybÔ{  ã               @   s¼  d dl 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 d dljZdd„ Zdd„ Zejjd	d
�dd„ ƒZdd„ Zejjdedddddgdddddgdœƒdddgfed d ddgd dd dgdœƒd dgfeddgiƒdgfeddddddddgedƒdœƒddgfeddddddgddddddgdœƒdddgfeedƒddddddddddg
dd ddddddddg
dœƒdddgfedddgdddggdddgd �ddgfgd!d"d#d$d%d&d'gd(�d)d*„ ƒZd+d,„ Zejjd-d
�d.d/„ ƒZejjd0d1d2„ ejd3d2„ ejjd-d
�d4�d5d2„ ejd6d2„ ejjd-d
�d4�gƒd7d8„ ƒZd9d:„ Zd;d<„ Zd=d>„ Z d?d@„ Z!dAdB„ Z"dCdD„ Z#dEdF„ Z$dGdH„ Z%dIdJ„ Z&dKdL„ Z'dMdN„ Z(dOdP„ Z)dQdR„ Z*dSdT„ Z+dUdV„ Z,dWdX„ Z-ejjdYdZd[gƒd\d]„ ƒZ.d^d_„ Z/d`da„ Z0dbdc„ Z1ddde„ Z2dfdg„ Z3dhdi„ Z4djdk„ Z5dldm„ Z6dndo„ Z7dpdq„ Z8drds„ Z9ejjdte j:ƒ e j:ƒ j;ƒ e j:ƒ j<ƒ gƒdudv„ ƒZ=dwdx„ Z>ejjdyd[dZgƒdzd{„ ƒZ?d|d}„ Z@ejjd~ejAedƒƒejBd dƒejCd€dd�d‚�ej
jDd›dœd�gƒgƒdƒd„„ ƒZEejjd…d†d2„ d dgddggfd‡d2„ d dhddhgfdˆd2„ dždŸgfd‰d2„ d ddŠœdddŠœgfd‹d2„ d d iddigd diddiggfgƒdŒd�„ ƒZFdŽd�„ ZGejjd�d‘d2„ d’d2„ gƒd“d”„ ƒZHd•d–„ ZId—d˜„ ZJejjd-d
�d™dš„ ƒZKdS ) é    )Údatetime)ÚStringION)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚbdate_rangec              C   sÌ   d} t jt| ƒd dddgddggd�}|jdƒ}|j|jjƒjƒ }|j|jjƒjdd„ ƒ}t	j
||ƒ t jt| ƒd dddgd	�}t jd
ddgtdd�}tdddg|d�}|jdƒjdd„ ƒ}t	j||ƒ d S )Na+  2011.05.16,00:00,1.40893
2011.05.16,01:00,1.40760
2011.05.16,02:00,1.40750
2011.05.16,03:00,1.40649
2011.05.17,02:00,1.40893
2011.05.17,03:00,1.40760
2011.05.17,04:00,1.40750
2011.05.17,05:00,1.40649
2011.05.18,02:00,1.40893
2011.05.18,03:00,1.40760
2011.05.18,04:00,1.40750
2011.05.18,05:00,1.40649ÚdateÚtimeÚvalue)ÚheaderÚnamesZparse_datesÚ	date_timec             S   s   | j ƒ S )N)Úidxmax)Úx© r   úC/tmp/pip-install-4cy230dp/pandas/pandas/tests/groupby/test_apply.pyÚ<lambda>%   s    z#test_apply_issues.<locals>.<lambda>)r   r   z
2011.05.16z
2011.05.17z
2011.05.18)ÚdtypeÚnamez00:00z02:00)Úindexc             S   s   | d | d j ƒ  S )Nr
   r   )r   )r   r   r   r   r   /   s    )ÚpdZread_csvr   Ú	set_indexÚgroupbyr   r	   r   ÚapplyÚtmÚassert_frame_equalr   Úobjectr   Úassert_series_equal)ÚsÚdfÚexpectedÚresultZexp_idxr   r   r   Útest_apply_issues   s     
r#   c                 s�   t jdddddgdddddgdœd	d
gd�‰ t jˆ jdd … ˆ jdd … gdddgd�} ˆ jdd„ ˆ jD ƒdd�j‡ fdd„ƒ}tj|| ƒ d S )NÚaÚbg      ð?g       @g      @g      @g      @)ÚkeyÚdatar&   r'   )Úcolumnsé   Úfloat64r   )ÚaxisÚkeysc             S   s   g | ]}t |ƒ‘qS r   )Ústr)Ú.0r   r   r   r   ú
<listcomp>;   s    z&test_apply_trivial.<locals>.<listcomp>)r+   c                s   ˆ j dd … S )Nr)   )Úiloc)r   )r    r   r   r   <   s    z$test_apply_trivial.<locals>.<lambda>)	r   r   Úconcatr0   r   Údtypesr   r   r   )r!   r"   r   )r    r   Útest_apply_trivial3   s    ,r3   zqGH#20066; function passed into apply returns a DataFrame with the same index as the one to create GroupBy object.)Úreasonc                 s|   t jdddddgdddddgdœd	d
gd�‰ t jˆ ˆ gdddgd�} ˆ jdd„ ˆ jD ƒdd�j‡ fdd„ƒ}tj|| ƒ d S )Nr$   r%   g      ð?g       @g      @g      @g      @)r&   r'   r&   r'   )r(   r)   r*   r   )r+   r,   c             S   s   g | ]}t |ƒ‘qS r   )r-   )r.   r   r   r   r   r/   P   s    z+test_apply_trivial_fail.<locals>.<listcomp>)r+   c                s   ˆ S )Nr   )r   )r    r   r   r   P   s    z)test_apply_trivial_fail.<locals>.<lambda>)r   r   r1   r   r2   r   r   r   )r!   r"   r   )r    r   Útest_apply_trivial_failB   s    	(r5   c              C   s°   d} t jjdd| d�}t jjdd| d�}t||t jj| ƒdddd	g| d
  dœƒ}dd„ }|jddgƒ}|j}|j|j|j	d�}|j
ƒ }|jƒ }	|j||	|ƒ\}
}| s¬t‚d S )Niè  r   iÐ  )Úsizeé   ÚfooÚbarÚbazÚquxé   )r&   Úkey2Úvalue1Úvalue2c             S   s   dS )Nr)   r   )Úgr   r   r   Úff   s    ztest_fast_apply.<locals>.fr&   r=   )r+   )ÚnpÚrandomÚrandintr   Úrandnr   ÚgrouperZ_get_splitterZ_selected_objr+   Z_get_group_keysZ_get_sorted_dataZ
fast_applyÚAssertionError)ÚNÚlabelsZlabels2r    rA   r@   rF   ZsplitterÚ
group_keysZsdataÚvaluesZmutatedr   r   r   Útest_fast_applyU   s     
rL   zdf, group_namesr)   é   r7   r$   r%   Úc)r$   r%   é   r<   é   é   é   é	   )r$   ÚtwoZ
aaabbbcccc)r$   ÚBÚC)r(   ZGH2936zGH7739 & GH10519ZGH10519ZGH2656ZGH12155ZGH20084ZGH21417)Úidsc                s‚   g ‰ ‡ fdd„}‡ fdd„}‡ fdd„}‡ fdd„}‡ fd	d
„}x<|||||gD ]*}ˆ d d …= | j dƒj|ƒ ˆ |ksPt‚qPW d S )Nc                s   ˆ j | jƒ | jƒ S )N)Úappendr   Úcopy)Úgroup)r   r   r   Úf_copy¡   s    z/test_group_apply_once_per_group.<locals>.f_copyc                s   ˆ j | jƒ | S )N)rX   r   )rZ   )r   r   r   Úf_nocopy¦   s    z1test_group_apply_once_per_group.<locals>.f_nocopyc                s   ˆ j | jƒ dS )Nr   )rX   r   )rZ   )r   r   r   Úf_scalar«   s    z1test_group_apply_once_per_group.<locals>.f_scalarc                s   ˆ j | jƒ d S )N)rX   r   )rZ   )r   r   r   Úf_none°   s    z/test_group_apply_once_per_group.<locals>.f_nonec                s   ˆ j | jƒ tdgdgdœƒS )Nr)   )r$   r%   )rX   r   r   )rZ   )r   r   r   Úf_constant_dfµ   s    z6test_group_apply_once_per_group.<locals>.f_constant_dfr$   )r   r   rG   )r    Zgroup_namesr[   r\   r]   r^   r_   Úfuncr   )r   r   Útest_group_apply_once_per_groupv   s    '
ra   c          
   C   s|   d}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
dgd�}|jdƒjdd„ ƒ | jƒ jjdƒ}||ksxt‚d S )NrM   r   r)   Ú0Ú2Ú4Ú6Ú8Ú10Z12Z14)Úgroup_by_columnZtest_column)r   rh   c             S   s   t dƒS )NÚfunction_called)Úprint)r    r   r   r   r   Ï   s    z2test_group_apply_once_per_group2.<locals>.<lambda>ri   )r   r   r   r   Z
readouterrÚoutÚcountrG   )Zcapsysr!   r    r"   r   r   r   Ú test_group_apply_once_per_group2Á   s    rm   zGH-34998c              C   sX   t dddgtdƒdœƒ} dd„ }dd„ }| jd	ƒj|ƒ}| jd	ƒj|ƒ}tj||ƒ d S )
Nr   r)   r7   )ÚAr%   c             S   s   | S )Nr   )rZ   r   r   r   ÚslowÞ   s    z,test_apply_fast_slow_identical.<locals>.slowc             S   s   | j ƒ S )N)rY   )rZ   r   r   r   Úfastá   s    z,test_apply_fast_slow_identical.<locals>.fastrn   )r   Úranger   r   r   r   )r    ro   rp   Zfast_dfZslow_dfr   r   r   Útest_apply_fast_slow_identicalÖ   s    rr   r`   c             C   s   | S )Nr   )r   r   r   r   r   í   s    r   c             C   s   | d d … S )Nr   )r   r   r   r   r   î   s    )Zmarksc             C   s   | j dd�S )NF)Údeep)rY   )r   r   r   r   r   ï   s    c             C   s   | j dd�S )NT)rs   )rY   )r   r   r   r   r   ñ   s    c             C   sJ   t jddddgddddgddddgd	œƒ}|jd
ƒj| ƒ}tj||ƒ d S )Nr)   rM   r7   r<   rP   rQ   rR   rO   )r@   r$   r%   r@   )r   r   r   r   r   r   )r`   r    r"   r   r   r   Ú5test_groupby_apply_identity_maybecopy_index_identicalê   s    *rt   c              C   s¤   t tjjdƒddddddgdœƒ} | jdd„ dd	�j}| j}tj||ƒ t d
dddddgiƒ} | jd | d< | j	dƒj
ƒ jƒ j}| j	ddd�j
ƒ j}tj||ƒ d S )NrQ   ÚonerT   Úthree)Úfoo1Úfoo2c             S   s   | S )Nr   )r   r   r   r   r   	  s    z-test_apply_with_mixed_dtype.<locals>.<lambda>r)   )r+   Úc1rM   rO   g       @Úc2F)Úas_index)r   rB   rC   rE   r   r2   r   r   ry   r   ÚmeanZreset_indexrz   )r    r"   r!   Úresult1Úresult2r   r   r   Útest_apply_with_mixed_dtype  s    
r   c             C   sP  t ddddddgddddddgtdƒdœƒ} | jd	d
d�}| jd	dd�}|jdƒj}|jdƒj}tddddgƒ}tj||ƒ tj||ƒ |jdd„ ƒj}|jdd„ ƒj}t	j
ddddgƒ}ddddg}	t	j
|	d	d gd�}
tj||
ƒ tj||ƒ ttdƒƒ}t ddgddgddgddgddgg|d�} | jddd�jdd„ ƒj}tj||ƒ d S )Nr%   r$   rN   r)   rM   r7   rQ   )Zitem_idÚuser_idr
   r€   T)r{   Fr   r<   c             S   s
   | j dƒS )NrM   )Úhead)r   r   r   r   r   (  s    z-test_groupby_as_index_apply.<locals>.<lambda>c             S   s
   | j dƒS )NrM   )r�   )r   r   r   r   r   )  s    )r   ZabcderP   )r   c             S   s   | S )Nr   )r   r   r   r   r   6  s    )r   r   )r   rM   )r)   r)   )rM   r<   )r)   r   )r)   rM   )rM   r)   )r7   r<   )r   rq   r   r�   r   r   r   Úassert_index_equalr   r   Úfrom_tuplesÚlist)r    Zg_asZg_not_asZres_asZ
res_not_asÚexpZres_as_applyZres_not_as_applyZexp_not_as_applyÚtpZexp_as_applyÚindÚresr   r   r   Útest_groupby_as_index_apply  s,    *r‰   c             C   sx   | j ddgƒ}dd„ }dd„ }dd„ }|j|ƒ}|jjd
ks@t‚|j|ƒ}|jjdksZt‚|j|ƒ}|jjdkstt‚d S )Nrn   rU   c             S   s   | j ƒ }d|j_|S )NÚstat)Údescriber   r   )rZ   r"   r   r   r   Údesc=  s    z.test_apply_concat_preserve_names.<locals>.descc             S   s$   | j ƒ }d|j_|d t| ƒ… }|S )NrŠ   )r‹   r   r   Úlen)rZ   r"   r   r   r   Údesc2B  s    z/test_apply_concat_preserve_names.<locals>.desc2c             S   s0   | j ƒ }dt| ƒd›�|j_|d t| ƒ… }|S )NZstat_Úd)r‹   r�   r   r   )rZ   r"   r   r   r   Údesc3I  s    z/test_apply_concat_preserve_names.<locals>.desc3rŠ   )rn   rU   rŠ   )rn   rU   rŠ   )rn   rU   N)r   r   r   r   rG   )Zthree_groupÚgroupedrŒ   rŽ   r�   r"   r~   Zresult3r   r   r   Ú test_apply_concat_preserve_names:  s    



r’   c              C   sb   dd„ } t ddd�}ttjjdƒ|d�}|jdd„ ƒ}|j| ƒ}t|tƒsNt	‚t
j|j|jƒ d S )	Nc             S   s:   t jdd�� t j| ƒ}W d Q R X t| | | jƒ  |dœƒS )NÚignore)Úinvalid)r   ZdemeanedÚlogged)rB   ZerrstateÚlogr   r|   )Zpiecer•   r   r   r   rA   ^  s    z%test_apply_series_to_frame.<locals>.fz1/1/2000éd   )Úperiods)r   c             S   s   | j S )N)Úmonth)r   r   r   r   r   h  s    z,test_apply_series_to_frame.<locals>.<lambda>)r   r   rB   rC   rE   r   r   Ú
isinstancer   rG   r   r‚   r   )rA   ZdrÚtsr‘   r"   r   r   r   Útest_apply_series_to_frame]  s    
rœ   c             C   s4   | j ddgƒd jtƒ}|jjd d… dks0t‚d S )Nrn   rU   rV   rM   )rn   rU   )r   r   r�   r   r   rG   )r    r"   r   r   r   Ú test_apply_series_yield_constanto  s    r�   c             C   sl   | j ddgƒjtƒ}t|tƒs"t‚|jd ks0t‚| j ddgƒddg jtƒ}t|tƒsZt‚|jd ksht‚d S )Nrn   rU   rV   ÚD)r   r   r�   rš   r   rG   r   )r    r"   r   r   r   Útest_apply_frame_yield_constantt  s    rŸ   c             C   sH   | j ddgƒ}|jtƒ}|jƒ d }tj|j|jƒ tj|j|jƒ d S )Nrn   rU   rV   )	r   r   r�   rl   r   r‚   r   Zassert_numpy_array_equalrK   )r    r‘   r"   r!   r   r   r   Útest_apply_frame_to_series  s
    
r    c                 sŠ   dd„ } ‡ fdd„}t tjjdddƒtjjdddƒtjjdƒdœƒ‰ ˆ jd	ƒj| ƒ}ˆ jd	ƒd
 j|ƒ}tj||dd� |j	d
ks†t
‚d S )Nc             S   s   | j dƒd jƒ jƒ d d… S )NrU   rV   rM   )r   ÚsumÚsort_values)rZ   r   r   r   Útransˆ  s    z-test_apply_frame_concat_series.<locals>.transc                s*   | j ˆ j| jƒd ƒ}|jƒ jƒ d d… S )NrU   rM   )r   Úreindexr   r¡   r¢   )rZ   r‘   )r    r   r   Útrans2‹  s    z.test_apply_frame_concat_series.<locals>.trans2r   rP   iè  )rn   rU   rV   rn   rV   F)Zcheck_names)r   rB   rC   rD   rE   r   r   r   r   r   rG   )r£   r¥   r"   r…   r   )r    r   Útest_apply_frame_concat_series‡  s    r¦   c             C   s:   | j dd„ ƒ}|jdd„ ƒ}|jdd„ ƒ}tj||ƒ d S )Nc             S   s   | j S )N)r™   )r   r   r   r   r   ž  s    z&test_apply_transform.<locals>.<lambda>c             S   s   | d S )NrM   r   )r   r   r   r   r   Ÿ  s    c             S   s   | d S )NrM   r   )r   r   r   r   r      s    )r   r   Ú	transformr   r   )r›   r‘   r"   r!   r   r   r   Útest_apply_transform�  s    r¨   c             C   sT   | j dd„ dd„ gƒ}dd„ }|j|ƒ}x&|D ]\}}tj|j| ||ƒƒ q.W d S )Nc             S   s   | j S )N)Úyear)r   r   r   r   r   ¥  s    z,test_apply_multikey_corner.<locals>.<lambda>c             S   s   | j S )N)r™   )r   r   r   r   r   ¥  s    c             S   s   | j dƒdd … S )Nrn   rP   éûÿÿÿ)r¢   )rZ   r   r   r   rA   §  s    z%test_apply_multikey_corner.<locals>.f)r   r   r   r   Úloc)Útsframer‘   rA   r"   r&   rZ   r   r   r   Útest_apply_multikey_corner¤  s
    
r­   c           
   C   sb   t dddddddddg	tdƒdœƒ} | jddd�jd	d
„ ƒ}| jddddddgƒ}tj||ƒ d S )Nr)   rM   r7   rS   )r&   r   r&   F)rJ   c             S   s   | d d… S )NrM   r   )r   r   r   r   r   ³  s    z'test_apply_chunk_view.<locals>.<lambda>r   r<   rQ   rR   )r   rq   r   r   Ztaker   r   )r    r"   r!   r   r   r   Útest_apply_chunk_view¯  s    $r®   c              C   s`   t ddddddddddg
ddddddddddg
tdd
dƒdœƒ} | jddgƒ}|jdd	„ ƒ d S )Nr)   rM   r   rS   )r   Úname2r   r   r¯   c             S   s   | j ddd�S )Nr   T)Zinplace)r¢   )r   r   r   r   r   Ã  s    z4test_apply_no_name_column_conflict.<locals>.<lambda>éÿÿÿÿr°   )r   rq   r   r   )r    r‘   r   r   r   Ú"test_apply_no_name_column_conflict¸  s    r±   c              C   sx   t ddddddgtjdddgdƒtjddƒdœƒ} d	d
„ }| jdƒj|ƒ}| jƒ }tjdddgdƒ|d< tj||ƒ d S )Ng      ð?g       @r$   r%   rN   rM   g      @)r�   rN   Úvc             S   s,   | d }||j ƒ  |jƒ |j ƒ   | d< | S )Nr²   Úv2)ÚminÚmax)rZ   r²   r   r   r   rA   Ï  s     z#test_apply_typecast_fail.<locals>.fr�   g        g      à?r)   r³   )	r   rB   ÚtileÚaranger   r   rY   r   r   )r    rA   r"   r!   r   r   r   Útest_apply_typecast_failÆ  s    r¸   c              C   s¢   t jddddddgddddddggƒ} tddddddgtjddd	gdƒtjdd
ƒdœ| d�}dd„ }|jdƒj|ƒ}|jƒ }tjdddgdƒ|d< t	j
||ƒ d S )Nr   r)   rM   r7   g      ð?g       @r$   r%   rN   g      @)r�   rN   r²   )r   c             S   s,   | d }||j ƒ  |jƒ |j ƒ   | d< | S )Nr²   r³   )r´   rµ   )rZ   r²   r   r   r   rA   ç  s     z%test_apply_multiindex_fail.<locals>.fr�   g        g      à?r³   )r   Úfrom_arraysr   rB   r¶   r·   r   r   rY   r   r   )r   r    rA   r"   r!   r   r   r   Útest_apply_multiindex_failÜ  s    &rº   c             C   s0   | j dd„ ƒjdd„ ƒ}| d }tj||ƒ d S )Nc             S   s   | j S )N)r©   )r   r   r   r   r   õ  s    z#test_apply_corner.<locals>.<lambda>c             S   s   | d S )NrM   r   )r   r   r   r   r   õ  s    rM   )r   r   r   r   )r¬   r"   r!   r   r   r   Útest_apply_cornerô  s    r»   c              C   sh   t ddddgddddgddd	d
gdœƒ} dd„ }dd„ }| jdƒj|ƒ}| jdƒj|ƒ}tj||ƒ d S )Nr—   éÈ   i,  r$   r%   rN   r)   rM   r7   r<   )Úid_fieldÚcategoryr   c             S   s(   | j d dkr| jƒ S | | jdk S d S )Nr   r)   rN   )ÚshaperY   r¾   )r   r   r   r   Úfilt1  s    z&test_apply_without_copy.<locals>.filt1c             S   s$   | j d dkr| S | | jdk S d S )Nr   r)   rN   )r¿   r¾   )r   r   r   r   Úfilt2  s    z&test_apply_without_copy.<locals>.filt2r½   )r   r   r   r   r   )r'   rÀ   rÁ   r!   r"   r   r   r   Útest_apply_without_copyú  s    

rÂ   Útest_seriesTFc             C   sª   t jddgddgddggddgdddgd�}| rr|jdƒd }|jd	d
�jdd„ ƒ}|jƒ }|jƒ }tj||ƒ n4|jdƒjdd„ ƒ}|jdƒ}|jdƒ}tj	||ƒ d S )Nr   ÚpÚoÚXÚYr)   rM   )r(   r   r   )Úlevelc             S   s   | S )Nr   )r   r   r   r   r     s    z<test_apply_with_duplicated_non_sorted_axis.<locals>.<lambda>c             S   s   | S )Nr   )r   r   r   r   r   &  s    )
r   r   r   r   r   Z
sort_indexr   r   r¢   r   )rÃ   r    Zserr"   r!   r   r   r   Ú*test_apply_with_duplicated_non_sorted_axis  s    (

rÉ   c              C   sn   ddddg} ddddg}t jddgd | dœ|d�}t j| |d	d
�}dd„ }|jdƒjj|ƒ}tj||ƒ d S )Nr)   rM   r7   r<   ZGroup1ZGroup2)rZ   r   )r   r   )r   r   c             S   s"   | j tj| jjƒ | jjƒ d ƒƒS )Nr)   )r¤   rB   r·   r   r´   rµ   )r   r   r   r   Úreindex_helper:  s    z1test_apply_reindex_values.<locals>.reindex_helperrZ   )r   r   r   r   r   r   r   r   )rK   Úindicesr    r!   rÊ   r"   r   r   r   Útest_apply_reindex_values.  s    rÌ   c              C   sj   d} t jjdd| d�}t|t jj| ƒddddg| d	  d
œƒ}|jdƒ}dd„ }|j|ƒ}d|ksft‚d S )Niè  r   r—   )r6   r8   r9   r:   r;   r<   )r&   r>   r?   r&   c             S   s   | d d | d< | S )Nr>   rM   Úvalue3r   )r@   r   r   r   rA   Q  s    z"test_apply_corner_cases.<locals>.frÍ   )rB   rC   rD   r   rE   r   r   rG   )rH   rI   r    r‘   rA   r"   r   r   r   Útest_apply_corner_casesB  s    


rÎ   c              C   sT  t jddgdgd ddgdœƒ} | jdgƒjdd	„ ƒ}t j| jƒ| _| jdgƒjd
d	„ ƒ}tj|d |d ƒ t jdddgdddgt jdƒgd dœƒ} dd„ }| jdƒj|ƒd }| j	}| j
|_tj||ƒ dd„ }t jddddgddddgddddgdd d!d!gd"œƒ}|jƒ }t j|jƒ|_|jd#ƒj|ƒj}|jd#ƒj|ƒj}tj||ƒ d S )$Nr)   rM   z
2017-03-02r8   Úinf)ÚNumberÚDateÚStrrÐ   c             S   s
   | j d S )Nr   )r0   )r   r   r   r   r   c  s    z;test_apply_numeric_coercion_when_datetime.<locals>.<lambda>c             S   s
   | j d S )Nr   )r0   )r   r   r   r   r   e  s    rÒ   é
   é   é   Ú3rd   z12:31:22r7   )rn   rU   ÚTc             S   s   | j d dg S )Nr   rU   )r0   )r@   r   r   r   Úget_Bm  s    z8test_apply_numeric_coercion_when_datetime.<locals>.get_Brn   rU   c             S   sŽ   t jdddgtd�}dt| jƒkr@t| | jdk jjd ƒ|d< dt| jƒkrŠt| | jdk jjd ƒ|d< t| | jdk jjd ƒ|d< |S )NÚp1Úp2ZuseTime)r   r   Ústep1r   Ústep2)	r   r   r   r„   ÚStater-   ÚMachinerK   ÚoTime)Ztoolrk   r   r   r   Úpredictionsv  s    z>test_apply_numeric_coercion_when_datetime.<locals>.predictionsrÛ   rÜ   Ú z2016-09-19 05:24:33z2016-09-19 23:59:04Z23Z36LZ36R)ÚKeyrÝ   rß   rÞ   râ   )r   r   r   r   Zto_datetimerÑ   r   r   Ú	TimestamprU   rn   r   rY   rß   rÙ   )r    r!   r"   rØ   rà   Údf1Údf2r   r   r   Ú)test_apply_numeric_coercion_when_datetimeY  s0    &	


ræ   c              C   sŽ   t jdddgtjdƒgd dœƒ} | j| j | d< | jdƒjd	d
„ ƒ}t jdddgtjddƒgd tjdƒgd dœƒjdƒ}t	j
||ƒ d S )Nrn   rU   rV   z2017-02-01 00:00:00r7   )Úclientidr   Útime_delta_zerorç   c             S   s   t jt| jjƒ | jjƒ d�ƒS )N)Úclientid_ager	   )r   r   Údictrè   r´   r   )Zddfr   r   r   r   š  s   z?test_apply_aggregating_timedelta_and_datetime.<locals>.<lambda>r   rž   )rç   ré   r	   )r   r   rB   Z
datetime64r   r   r   Ztimedelta64r   r   r   )r    r"   r!   r   r   r   Ú-test_apply_aggregating_timedelta_and_datetimeŽ  s    

rë   c              C   s´   t jddd„ tdƒD ƒdœƒ} dd„ }dd	„ }| jd
gd�j|ƒ}t jddidgd�}d
|j_| jd
gd�j|ƒ}t jtdddƒddœdgd�}d
|j_tj	||ƒ tj	||ƒ d S )Nr)   c             S   s   g | ]}t jƒ ‘qS r   )r   Únow)r.   Únnr   r   r   r/   ¯  s    z'test_time_field_bug.<locals>.<listcomp>rÓ   )r$   r%   c             S   s   t jddiƒS )NrN   rM   )r   r   )Úbatchr   r   r   Úfunc_with_no_date±  s    z.test_time_field_bug.<locals>.func_with_no_datec             S   s   t jtdddƒddœƒS )Niß  r)   rM   )r%   rN   )r   r   r   )rî   r   r   r   Úfunc_with_date´  s    z+test_time_field_bug.<locals>.func_with_dater$   )ZbyrN   rM   )r   iß  )r%   rN   )
r   r   rq   r   r   r   r   r   r   r   )r    rï   rð   Zdfg_no_conversionZdfg_no_conversion_expectedZdfg_conversionZdfg_conversion_expectedr   r   r   Útest_time_field_bug©  s    rñ   c                 s°   t ddddddddddddgddddddddddddgdddd	d
ddd	ddddgdddddddddd
d	dgdœƒ} | jddgƒ} | jddgdd�}dd„ ‰ |j‡ fdd„ƒ d S )Nr$   r%   rN   r�   Úegš™™™™™ñ?rM   r7   r<   rP   rQ   rO   r)   gffffff@rS   rÓ   é   é   rR   )Úgroup1Úgroup2Úweightr   rõ   rö   T)rÈ   Úsortc             S   s   t j| | ƒjdƒ}|S )Nr7   )rB   ÚarrayÚrepeat)r   r÷   rk   r   r   r   ÚnoddyÓ  s    z7test_gb_apply_list_of_unequal_len_arrays.<locals>.noddyc                s   ˆ | j | jƒS )N)r   r÷   )r   )rû   r   r   r   Ý  s    z:test_gb_apply_list_of_unequal_len_arrays.<locals>.<lambda>)r   r   r   r   )r    Z
df_groupedr   )rû   r   Ú(test_gb_apply_list_of_unequal_len_arraysÅ  s    "
rü   c              C   sL   t ddddgddddgdœƒ} dd	„ }| jd
ƒj|ƒ}t ƒ }tj||ƒ d S )Nr   r)   rO   rR   r<   rP   )ÚgroupsZrandom_varsc             S   s   d S )Nr   )r   r   r   r   Ú	test_funcå  s    z.test_groupby_apply_all_none.<locals>.test_funcrý   )r   r   r   r   r   )Ztest_dfrþ   r"   r!   r   r   r   Útest_groupby_apply_all_noneà  s
    rÿ   c        	      C   sð   t ddddgddddgdœƒ} t ddddgddddgdœƒ}dd„ }| jdƒj|ƒ}|jdƒj|ƒ}tjddgddggdd gd	�}tjddgddggdd gd	�}t ddgddgdœ|d
�}t ddgddgdœ|d
�}tj||ƒ tj||ƒ d S )Nr)   rM   r   r7   )rý   Úvarsc             S   s    | j d dk rd S | jddg S )Nr   rM   r)   r°   )r¿   r0   )r   r   r   r   rþ   ò  s    z0test_groupby_apply_none_first.<locals>.test_funcrý   )r   )r   )r   r   r   r   r¹   r   r   )	Ztest_df1Ztest_df2rþ   r}   r~   Zindex1Úindex2Z	expected1Z	expected2r   r   r   Útest_groupby_apply_none_firstí  s    r  c              C   sr   t jtddgddgd�ƒ} | jdƒ}|jdd„ ƒ}t jdgd	tjddgdggdd gd
�jdƒd�}t	j
||ƒ d S )Nr   r)   ZfilledÚempty)r   rZ   rZ   c             S   s   | | j dk d S )Nr)   r   )r   )rZ   r   r   r   r     s    z7test_groupby_apply_return_empty_chunk.<locals>.<lambda>r   )r   )r   r   )r   r   rê   r   r   r   r   Zfrom_productZdropr   r   )r    rý   r"   r!   r   r   r   Ú%test_groupby_apply_return_empty_chunk  s    

r  c              C   s€   t jdjƒ dddgdddgdœƒ} | jd	ƒ}|jd
d„ ƒ}t jdddgdddgdœƒ}tj||ƒ |jdd„ ƒ}tj||ƒ d S )Nza a br)   rM   r7   r<   rQ   rP   )rn   rU   rV   rn   c             S   s   | | j ƒ  S )N)r¡   )r   r   r   r   r     s    z-test_apply_with_mixed_types.<locals>.<lambda>g      @gš™™™™™Ù?g333333ã?g      ð?)rU   rV   c             S   s   | | j ƒ  S )N)r¡   )r   r   r   r   r     s    gUUUUUUÕ?gUUUUUUå?)r   r   Úsplitr   r§   r   r   r   )r    r@   r"   r!   r   r   r   Útest_apply_with_mixed_types  s    "
r  c              C   sp   t dddgitjddgƒd�} | jdƒjdd„ ƒ}ttjdgƒtjdgƒgtjddgdd�d�}tj||ƒ d S )Nr$   r)   rM   )r   c             S   s   | j S )N)r   )r@   r   r   r   r      s    z*test_func_returns_object.<locals>.<lambda>)r   )r   r   Z
Int64Indexr   r   r   r   r   )r    r"   r!   r   r   r   Útest_func_returns_object  s
    ,r  Úgroup_column_dtlikec             C   sX   t jdg| gdœƒ}|jdƒjdd„ ƒ}t jdgtdgddd�d	gd
�}tj||ƒ d S )Nr8   )r$   r%   r$   c             S   s   t jdgdgd�S )NÚspamé*   )r   )r   r   )r   r   r   r   r   3  s    z+test_apply_datetime_issue.<locals>.<lambda>r	  r   )r   r   r
  )r(   )r   r   r   r   r   r   r   )r  r    r"   r!   r   r   r   Útest_apply_datetime_issue(  s
    
r  c           	   C   sœ   t tjdƒtjdƒtjdƒtjdƒtjdƒdœddddddœddddddœdœƒ} dd„ }| jd	ƒj|ƒd
 }tjdgtjdgd	d�d
d�}tj||ƒ d S )Nz2015-02-24 00:00:00)r   r)   rM   r7   r<   zsome UA stringzanother UA stringZ17661101)ÚdayZ	userAgentÚuserIdc             S   s   t dd„ | jƒ D ƒƒS )Nc             S   s    i | ]\}}|j ƒ jd  |“qS )r   )Zvalue_countsr   )r.   rN   r   r   r   r   ú
<dictcomp>X  s    zYtest_apply_series_return_dataframe_groups.<locals>.most_common_values.<locals>.<dictcomp>)r   Ú	iteritems)r    r   r   r   Úmost_common_valuesW  s    zEtest_apply_series_return_dataframe_groups.<locals>.most_common_valuesr  r  z
2015-02-24)r   )r   r   )	r   r   rã   r   r   r   ÚDatetimeIndexr   r   )Ztdfr  r"   r!   r   r   r   Ú)test_apply_series_return_dataframe_groups;  s*    r  r¾   c             C   sÚ   ddgd }| r@t j|dddgd�}t jddgdddgdd�}nt jddgdd�}t jtjd	ƒ|ttd	ƒƒttd	ƒƒd
œƒj	ddgƒ}|j
dƒjdd„ ƒ}t jddgddgdœ|d�}tj||ƒ |jjddgksÖt‚d S )Nr)   rM   rP   r7   )Ú
categoriesrU   )r  r   )r   rÓ   )rn   rU   rV   rž   rn   c             S   s   | j ƒ S )N)r¡   )r   r   r   r   r   m  s    z-test_apply_multi_level_name.<locals>.<lambda>rÔ   é   )rV   rž   )r   )r   ZCategoricalÚCategoricalIndexr   r   rB   r·   r„   rq   r   r   r   r   r   r   r   rG   )r¾   r%   Zexpected_indexr    r"   r!   r   r   r   Útest_apply_multi_level_namea  s    &
r  c           	   C   sÀ   t jjt jdddƒddddft jdddƒddd	d
ft jdddƒddddft jdddƒddddfgdddddgd�} | jdƒjdd„ ƒj}ttj	dƒt
t
tjt
gdddddgd�}tj||ƒ d S )Nià  r)   ZredZdarkrf   iß  ZgreenZstormyrM   Ú9iÞ  ZblueZbrightr7   rg   iÝ  Zcalmr<   ZpotatoZobservationÚcolorZmoodZ	intensityZscore)r(   c             S   s
   | j d S )Nr   )r0   )r@   r   r   r   r   ~  s    z;test_groupby_apply_datetime_result_dtypes.<locals>.<lambda>zdatetime64[ns])r   )r   r   Zfrom_recordsrã   r   r   r2   r   rB   r   r   Zint64r   r   )r'   r"   r!   r   r   r   Ú)test_groupby_apply_datetime_result_dtypess  s    r  r   ÚabcZ2020rž   )r˜   Úfreqc             C   sB   t dddgdddgdœ| d�}|jdƒjdd„ ƒ}tj||ƒ d S )	Nr)   rM   r   )rZ   r   )r   rZ   c             S   s   | S )Nr   )r   r   r   r   r   ’  s    z8test_apply_index_has_complex_internals.<locals>.<lambda>)r   r   r   r   r   )r   r    r"   r   r   r   Ú&test_apply_index_has_complex_internals†  s    r  zfunction, expected_valuesc             C   s
   | j jƒ S )N)r   Úto_list)r   r   r   r   r   ™  s    c             C   s   t | jjƒ ƒS )N)Úsetr   r  )r   r   r   r   r   š  s    c             C   s   t | jjƒ ƒS )N)Útupler   r  )r   r   r   r   r   ›  s    c             C   s   dd„ t | jjƒ ƒD ƒS )Nc             S   s   i | ]\}}||“qS r   r   )r.   ÚnÚir   r   r   r  �  s    z<lambda>.<locals>.<dictcomp>)Ú	enumerater   r  )r   r   r   r   r   �  s    )r   r)   c             C   s   dd„ t | jjƒ ƒD ƒS )Nc             S   s   g | ]\}}||i‘qS r   r   )r.   r   r!  r   r   r   r/   ¡  s    z<lambda>.<locals>.<listcomp>)r"  r   r  )r   r   r   r   r   ¡  s    c             C   sT   t jddddgdgd�}|jdƒj| ƒ}t j|t jddgdd�d�}tj||ƒ d S )Nrn   rU   rý   )r(   )r   )r   )r   r   r   r   r   r   r   r   )ÚfunctionZexpected_valuesr    r"   r!   r   r   r   Ú1test_apply_function_returns_non_pandas_non_scalar–  s    r$  c              C   sx   dd„ } t jddddgdddtjgd	œƒ}|jd
ƒj| ƒ}t jddgdgtjggt jdddgd
d�d�}tj	||ƒ d S )Nc             S   s   | d j jƒ S )NrU   )rK   Úflatten)rZ   r   r   r   Úfct°  s    z4test_apply_function_returns_numpy_array.<locals>.fctr$   r%   Únoner)   rM   r7   )rn   rU   rn   g      ð?g       @g      @)r   )r   )
r   r   rB   Únanr   r   r   r   r   r   )r&  r    r"   r!   r   r   r   Ú'test_apply_function_returns_numpy_array®  s    "*r)  r#  c             C   s   | j S )N)r   )Úgrr   r   r   r   ½  s    c             C   s   | j d d S )Nr)   )r   )r*  r   r   r   r   ½  s    c             C   sŽ   t jddddddddddg
dgd�}|jdƒj| ƒ}t jt jdddd	gƒt jdddd
gƒt jddgƒgt jdddgdd�d�}tj||ƒ d S )Nr)   rM   r7   Úid)r(   r   r<   rR   rS   rP   rQ   rO   )r   )r   )r   r   r   r   r   r   r   r   )r#  r    r"   r!   r   r   r   Ú test_apply_function_index_return¼  s    $.r,  c           
   C   s†   t jddddddgddddddgd	œƒ} d
d„ }| jdgdd�j|ƒ}t jddddddgt jjddddddgƒdd�}tj||ƒ d S )Nrn   rU   r)   rM   r7   r<   rP   rQ   )Úcol1Úcol2c             S   s   d| j | jd < | j S )Nr   r)   r°   )r.  r   )r   r   r   r   ÚfnÐ  s    z-test_apply_function_with_indexing.<locals>.fnr-  F)r{   r   r.  )r   r   )r   r   )r   r)   )r   rM   )r)   r7   )r)   r<   )r)   rP   )	r   r   r   r   r   r   rƒ   r   r   )r    r/  r"   r!   r   r   r   Ú!test_apply_function_with_indexingÊ  s    $r0  c              C   sh   t ddddddgddddddgd	œƒ} | jd
dd�jdd„ ƒ}t dddgdddgd	œƒ}tj||ƒ d S )Nru   rT   rv   r)   rM   r<   rP   rQ   )rw   rx   rw   F)r{   c             S   s   | j ƒ S )N)r|   )r   r   r   r   r   ç  s    zAtest_apply_function_with_indexing_return_column.<locals>.<lambda>g      @g      @)r   r   r   r   r   )r    r"   r!   r   r   r   Ú/test_apply_function_with_indexing_return_columnß  s    r1  c              C   sº   dgd dgd  dgd  } t j| ƒ}t j| dd�}t jttdƒƒd tdƒ|d	œƒ}t jttdƒƒd tdƒ|d	œƒ}|jd
dd�jdd„ ƒ}|jd
dd�jdd„ ƒ}tj||ƒ d S )Nz
2001-01-01rM   z
2001-01-02z
2001-01-03ÚUTC)Útzr7   rQ   )r   ÚyÚtr   F)rJ   c             S   s   | ddg j ƒ S )Nr   r4  )rY   )r    r   r   r   r   ö  s    z1test_apply_with_timezones_aware.<locals>.<lambda>c             S   s   | ddg j ƒ S )Nr   r4  )rY   )r    r   r   r   r   ÷  s    )	r   r  r   r„   rq   r   r   r   r   )ÚdatesZindex_no_tzZindex_tzrä   rå   r}   r~   r   r   r   Útest_apply_with_timezones_awareì  s    
""r7  )r$   r   )r$   r)   )r%   r   )r   r)   )rM   r7   )Lr   Úior   ZnumpyrB   ZpytestZpandasr   r   r   r   r   r   Zpandas._testingZ_testingr   r#   r3   ÚmarkZxfailr5   rL   Zparametrizerq   r„   ra   rm   rr   Úparamrt   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  Útodayr	   r
   r  r  r  r  r  Zinterval_rangeZperiod_rangerƒ   r  r$  r)  r,  r0  r1  r7  r   r   r   r   Ú<module>   s¾   
'!*$(.
*0$%#	5(&

.