3
Êb_ON  ã               @   sz  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
 d dljZdd„ Zejjdddgƒdd	„ ƒZejjd
d dMgƒdd„ ƒZejjdddgƒdd„ ƒZdd„ Zdd„ Zdd„ Zdd„ Zejjddge	ddd�dgdœdge	ddd�dgdœdge	ddd�dgdœfdddge	dd d�e	ddd�e	d!d"d�gdd#d$gdœddge	dd d�e	ddd�gdd#gdœddge	d!d"d�e	ddd�gd$d#gdœfgƒd%d&„ ƒZejjd'de	d(d)d�d*gde	d+d)d�d,ggƒd-d.„ ƒZejjd/ejd0d1gd2d3�ejdd#gd4d3�ejd5d6gƒejdd#gd7d8�gƒejjd9ddd:d;gƒd<d=„ ƒƒZd>d?„ Zd@dA„ ZdBdC„ Z dDdE„ Z!dFdG„ Z"ejjdHddIdJgƒdKdL„ ƒZ#dS )Né    N)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚisnac             C   s  | j dƒ}|jƒ }| jddgdddgf }tddgdd	�|_|jƒ }tj||ƒ |jdƒ}tj||ƒ |j	ƒ }| jd
dgdddgf }tddgdd	�|_tj||ƒ |jdƒ}tj||ƒ |jdƒ}| jddgdddgf j
ƒ }tddgdd	�|_|jƒ }tj||ƒ |d jƒ  |d j	ƒ  |d jdƒ tj| j| d dkdf< t|d jƒ d ƒ�s^t‚t|d j	ƒ d ƒ�sxt‚t|d jdƒd ƒ�s”t‚tdtjgddgd
dggddgd�} | j dƒ}|jƒ }| jddg jdƒ}tj||ƒ | jddg jdƒ}|jddd�}tj||ƒ d S )NÚAé   r   ÚBÚCÚDÚbarÚfoo)Únameé   é   é   é   é   é   )ÚcolumnsÚany)Údropnaéÿÿÿÿ)ÚgroupbyÚfirstÚlocr   ÚindexÚ
sort_indexÚtmÚassert_frame_equalÚnthÚlastÚcopyÚnpÚnanr   ÚAssertionErrorr   ÚilocÚ	set_index)ÚdfÚgroupedr   Úexpectedr!   r"   ÚgÚresult© r.   ú?/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/groupby/test_nth.pyÚtest_first_last_nth	   sD    



$
r0   Úmethodr   r"   c             C   s”   t jddddgddd|gdœƒjdƒ}t|| ƒƒ }| dkrDddg}nddg}tj||d jd�}t jddgdd	�}t jd|i|d
�}tj	||ƒ d S )Nr	   r   r   )ÚaÚbr2   r   r3   )Údtype)r   )r   )
Úpdr   r   Úgetattrr$   Úarrayr4   r   r   r    )r1   Únulls_fixtureÚgroupsr-   ÚvaluesÚidxr+   r.   r.   r/   Útest_first_last_with_na_object9   s     
r<   r   r	   c             C   s’   t jddddgddd|gdœƒjdƒ}|j| ƒ}| dkrBddg}nd|g}tj||d jd�}t jddgdd	�}t jd|i|d
�}tj	||ƒ d S )Nr	   r   r   )r2   r3   r2   r   r3   )r4   )r   )r   )
r5   r   r   r!   r$   r7   r4   r   r   r    )r   r8   r9   r-   r:   r;   r+   r.   r.   r/   Útest_nth_with_na_objectM   s     

r=   c             C   s@   t jjdgd gdœƒ}|jddd�}t|| ƒƒ }tj||ƒ d S )Nr2   )ÚidÚvaluer>   F)Úas_index)r5   r   Z	from_dictr   r6   r   r    )r1   r)   r9   r-   r.   r.   r/   Útest_first_last_with_Nonea   s    rA   c       
      C   s^  | j ƒ }d|d< d|d< |jdƒ}|jƒ }|jddgddd	ddgf }td
dgdd�|_|jƒ }tj||ƒ |j	ƒ }|jddgddd	ddgf }td
dgdd�|_|jƒ }tj||ƒ |j
dƒ}|jddgddd	ddgf }td
dgdd�|_|jƒ }tj||ƒ ttdƒƒ}|jdƒ ttdƒ|dd�}|jdk�s:t‚|jdd�jƒ }	|	jdk�sZt‚d S )NTÚEr	   ÚFr   r   r
   r   r   r   r   )r   r   r   r   r   é
   é	   é   ZIntCol)Údatar   r   Úint64)Úlevel)r#   r   r   r   r   r   r   r   r    r"   r!   ÚlistÚrangeÚappendr   r4   r&   )
Zdf_mixed_floatsr)   r*   r   r+   r"   r!   r;   ÚsÚfr.   r.   r/   Útest_first_last_nth_dtypesl   s2    


rO   c           
   C   s†   t jt jdƒddgt jdƒddgdddgd	d
dgiƒ} | jdƒjƒ }tddd
ggttdƒtdƒd	gƒtdgdd�d�}tj||ƒ d S )Nz2012-01-01 00:00:00r2   r3   z2012-01-02 00:00:00ÚcÚdr   ÚeZaaaarN   r,   z
2012-01-01z
2012-01-02)r   )r   r   )r5   r   r   r   r   r   r   r    )Útestr-   r+   r.   r.   r/   Útest_first_strings_timestamps�   s    
rT   c              C   s  t dtjgddgddggddgd�} | jdƒ}tj|jdƒ| jdd	g jdƒƒ tj|jdƒ| jdg jdƒƒ tj|jd	ƒ| j	g  jdƒƒ tj|jdCƒ| jdd	g jdƒƒ tj|jdDƒ| jdg jdƒƒ tj|jdEƒ| j	g  jdƒƒ tj
|jjdƒ| jdƒjjdd	g ƒ tj
|jjdƒ| jdƒjjdg ƒ tj|dg jdƒ| j	dd	gddgf jdƒƒ | jdƒ}tj|jddd�|jdd	g ƒ tj|jdFdd�|jdd	g ƒ tj|d< tj|jddd�|jdd	g ƒ tj|jd	dd�|jdd	g ƒ t ddddddœddddddœddGdHdddœddIddJddœdœƒjdd gƒ} | jdd!d"�jd	ƒ}| jdKg }tj||ƒ | jdd!d"�jd
ƒ}| j	g  }tj||ƒ t tjjdd#dLƒd%d&�} | d }| d }|j|ƒjƒ }|j|ƒjd'd(„ ƒ}tj
||d!d)� |jdk�st‚|jdk�st‚||dk jd }|jd |k�s>t‚|jd |k�sRt‚|j|d!d*�jƒ }|j|d!d*�jdd+d�}tj
||ƒ tjtd,d-�� |j|d!d*�jdd.d� W d Q R X t dtjgddgddggddgd�} | jdƒ}|jjdd+d�}|jjƒ }tj
||ƒ t dtjgdd
gddgddgddggddgd�} | jdƒ}tj|jdƒ| jdd
g jdƒƒ tj|jdgƒ| jdd
g jdƒƒ tj|jddgƒ| jddd
dg jdƒƒ tj|jddMgƒ| jdd	d
dg jdƒƒ tj|jddd	gƒ| jddd	d
dg jdƒƒ tj|jdddNgƒ| jddd	d
dg jdƒƒ tj|jd	gƒ| jd	g jdƒƒ tj|jd
dgƒ| j	g  jdƒƒ tjd/d0dd1�}t d|d2d3gd4�} | jj| jjg}	| j|	d!d5�jdd
dOdPgƒ}tjd6d7d8d9d:d;d<d=d>d?d@dAgƒ}
t dd2d3g|
dB�}tj||ƒ d S )QNr	   r   r   r   r   r
   )r   r   r   r   r   )r   r   ZgreenZred)r   r	   r   r   r   ZhamÚeggsZporkgþI|î»ø?gçoB!²?gHk:!4@gn‹2d’Ý?gC8fÙ“Àà?g£W”†â?gV¿Òùð,ï?gN'ÙêrŠð?gÃGÄ”H"é?gû­�(	‰æ?)ÚcolorÚfoodÚtwoÚonerV   rW   F)rI   r@   rD   éd   rH   )r4   c             S   s
   | j d S )Nr   )r'   )Úxr.   r.   r/   Ú<lambda>Ý   s    ztest_nth.<locals>.<lambda>)Zcheck_names)ÚsortÚallzFor a DataFrame groupby)ÚmatchTz4/1/2014z	6/30/2014)ÚstartÚendÚfreqr2   r3   )r   r   )r@   z2014/4/1z2014/4/4z	2014/4/29z	2014/4/30z2014/5/1z2014/5/6z	2014/5/29z	2014/5/30z2014/6/2z2014/6/5z	2014/6/27z	2014/6/30)r   r   r   éþÿÿÿéýÿÿÿr   gçoB!²¿gHk:!4ÀgV¿Òùð,ï¿gÃGÄ”H"é¿r   )rZ   r   r   r   rc   r   )r   r$   r%   r   r   r    r!   r'   r(   r   Úassert_series_equalr
   ÚrandomÚrandintr   Úapplyr   r&   ÚpytestZraisesÚ
ValueErrorr5   Ú
date_ranger   ÚyearÚmonthÚto_datetime)r)   r,   Úexpr-   r+   rM   Z	expected2ÚvZbusiness_datesÚkeyZexpected_datesr.   r.   r/   Útest_nth¢   s®    $
" " &$0
  
  

"$

0
"$**..""rr   c             C   s0   | j ddgƒ}|jdƒ}|jƒ }tj||ƒ d S )Nr   r
   r   )r   r!   r   r   r    )Úthree_groupr*   r-   r+   r.   r.   r/   Útest_nth_multi_index  s    
rt   z#data, expected_first, expected_lastr   z2012-02-01 14:00:00z
US/Central)Útz)r>   Útimer   r
   z2012-01-01 13:00:00zAmerica/New_Yorkz2012-03-01 12:00:00zEurope/Londonr   r   c             C   sÐ   t | ƒ}|jddd�jƒ }t |ƒ}dddg}tj|| || ƒ |jddd�d jƒ }tj||ddg ƒ |jddd�jƒ }t |ƒ}dddg}tj|| || ƒ |jddd�d jƒ }tj||ddg ƒ d S )Nr>   F)r@   rv   r   )r   r   r   r   r    r"   )rG   Zexpected_firstZexpected_lastr)   r-   r+   Úcolsr.   r.   r/   Útest_first_last_tz'  s    6

rx   zmethod, ts, alphaz
2013-01-01z
US/Easternr2   z
2013-01-02r3   c             C   s˜   t jtdƒƒjdƒ}t jdddg|t jdddd�d	œƒ}t|jd
ƒ| ƒƒ }t jt j|dg|j	d�|t
ddd�gdœt jddgd
d�d�}tj||ƒ d S )NÚabcÚcategoryr	   r   Z20130101r   z
US/Eastern)Zperiodsru   )ÚgroupÚcategory_stringÚ
datetimetzr{   rP   )r4   z
2013-01-03)ru   )r|   r}   )r   )r   )r5   r   rJ   Úastyper   rk   r6   r   ZCategoricalr4   r   r   r   r    )r1   ÚtsÚalphar|   r)   r-   r+   r.   r.   r/   Útest_first_last_tz_multi_columnp  s    	r�   r:   TFÚboolean)r4   ZInt64z
2020-01-01z
2020-02-01r   )ÚunitÚfunctionÚminÚmaxc       	      C   s„   t ddg| dœƒ}|jdƒ}tddgdd�}t| d|d�}t d| i|d�}t|d |ƒƒ }tj||ƒ |jd|iƒ}tj||ƒ d S )	Nr	   r   )r2   r3   r2   )r   r3   )r   r   )r   )	r   r   r   r   r6   r   re   Zaggr    )	r:   r„   r)   r*   r;   Zexpected_seriesZexpected_frameZresult_seriesZresult_framer.   r.   r/   Ú+test_first_last_extension_array_keeps_dtypeŽ  s    
r‡   c              C   s´   t dddddddddddgdddddddddddgdddddddddddgdœƒ} | jdd	gƒ}|jd
ƒ}t dddddgitjddddgddddggdd	gd�d�}tj||ƒ d S )Nr   r   rY   rX   ZdullZshiny)r   r
   r   r   r
   r   r   )Únames)r   )r   r   r!   r   Zfrom_arraysr   r    )rs   r*   r-   r+   r.   r.   r/   Ú test_nth_multi_index_as_expected¨  sT    
r‰   c              C   sJ  t ddgddgddggddgd�} | jdd	d
�}| jddd
�}tj| jddg |jdƒƒ tj| jddg |jdƒƒ t | jtj	g | j
jd�d�}|d j| jjƒ|d< |d j| jjƒ|d< tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj| |jdƒƒ tj| |jdƒƒ | }tj|jddg |jdƒƒ tj|jddg |jdƒƒ t |j
d d… | jd�}|d j| jjƒ|d< |d j| jjƒ|d< tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj||jdƒƒ tj|g  jdƒ|jddgg f ƒ tj|dg jdƒ|jddgdgf ƒ tj|dg jdƒ|jddgdgf ƒ tj|ddg jdƒ|jddg ƒ tj|g  jdƒ|jddgg f ƒ tj|dg jdƒ|jddgdgf ƒ tj|dg jdƒ|jddgdgf ƒ tj|ddg jdƒ|jddg ƒ d S )Nr	   r   r   r   r   r   r
   )r   T)r@   Fr   )r4   )r   r   r   )r   r   r   r   r   r   )r   r   r   r    r   ÚheadÚtailr   r5   r   r   r4   r~   r   r
   )r)   Zg_asZg_not_asZempty_not_asZdf_asZempty_asr.   r.   r/   Útest_groupby_head_tailâ  sF    "$(($$((rŒ   c              C   s  t ddgddgddggddgd�} | jd	dg jdƒ}| jdƒ}|jdd
�}|jd	ƒ}tj|| ƒ tj||ƒ | jdƒ}|jdd
�}|jd	ƒ}tj|| ƒ tj||ƒ | jdƒ}|jd	ƒ}|jdd
�}tj||ƒ tj|| ƒ | jdƒ}|jd	ƒ}|jdd
�}tj||ƒ tj|| ƒ d S )Nr	   r   r   r   r   r   r
   )r   r   )Ún)	r   r'   r(   r   rŠ   r!   r   r    r‹   )r)   r+   r,   Zresult1Zresult2r.   r.   r/   Útest_group_selection_cache  s,    "







rŽ   c              C   s�   t dgdddgd�} | jdƒjdƒ}t tg dd�ddgd�}tj||ƒ | jddgƒjdƒ}t tg g gg g gddgd�dgd�}tj||ƒ d S )	Nr   r2   r3   rP   )r   r   rD   )r   )rˆ   )r   r   r!   r   r   r    r   )r)   r-   r+   r.   r.   r/   Útest_nth_empty3  s    "r�   c              C   sÐ   t dddgdddgddtjgdddgdd	d
ggdddgd�} | jdƒjdƒ}t ddgddggddgtddgdd�d�}tj||ƒ | jdƒjddd�}t ddgd	dggddgtddgdd�d�}tj||ƒ d S )Nr	   r3   rZ   r2   é2   r   rP   éÈ   rQ   é–   r   r   r
   )r   r   g      Y@g      i@)r   )r   r   r   )r   g      I@g     Àb@r   )r   r$   r%   r   r!   r   r   r    )r)   r-   r+   r.   r.   r/   Útest_nth_column_orderA  s    ,((r“   r   r   r^   c             C   sŽ   t tjddgdddgtjddgdd	d
gtjddggtdƒd�}|jdƒjd| d�}tj ddgd	d
ggtdƒtddgdd�d�}tj	||ƒ d S )Nr   r	   ry   r   r   r   r   Údefr   r   é   rE   )r   r2   )r   Zbc)r   )r   r   )
r   r$   r%   rJ   r   r!   r5   r   r   r    )r   r)   r-   r+   r.   r.   r/   Útest_nth_nan_in_grouperU  s    0(r–   r   )$Znumpyr$   ri   Zpandasr5   r   r   r   r   r   r   Zpandas._testingZ_testingr   r0   ÚmarkZparametrizer<   r=   rA   rO   rT   rr   rt   rx   r�   r7   rn   Zto_timedeltar‡   r‰   rŒ   rŽ   r�   r“   r–   r.   r.   r.   r/   Ú<module>   sj    
0#|	








 :3