3
Êb_žI  ã               @   s®   d dl m Z mZ d dlmZ d dl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jjZejeddgddgƒd�dd	„ ƒZG d
d„ dƒZdS )é    )ÚdatetimeÚtime)ÚproductN)Ú	DataFrameÚDatetimeIndexÚIndexÚ
MultiIndexÚSeriesÚ
date_rangeÚperiod_rangeÚto_datetimeTF)Úparamsc             C   s   | j S )N)Úparam)Úrequest© r   úD/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/frame/test_timeseries.pyÚclose_open_fixture   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	e
jjdddddgidddgddfddddgidddgddfdddddgiddddgddfddejdgidddgddfdejejdgidddgddfddejdgidddgddfgƒdd„ ƒZe
jjdeegƒdd„ ƒZdd„ Zdd„ Zdd „ Zd!d"„ Zd#d$„ Ze
jjd%d&d'edƒedejd(�gƒd)d*„ ƒZd+d,„ Zd-d.„ Ze
jjd/d0d1d2dgƒd3d4„ ƒZd5d6„ Zd7d8„ Z d9d:„ Z!d;d<„ Z"d=d>„ Z#d?d@„ Z$dAdB„ Z%e
jjdCdDdEgƒdFdG„ ƒZ&dHS )IÚTestDataFrameTimeSeriesMethodsc             C   sR   t dddd�}tj|ƒ}ttjjt|ƒƒ|dœƒ}tj|d jtjdƒƒsNt	‚d S )Nz1/1/2000 00:00:00z1/1/2000 1:59:50Ú10s)Úfreq)ÚAÚBr   zM8[ns])
r
   ÚnpZasarrayr   ÚrandomÚrandnÚlenÚ
issubdtypeÚdtypeÚAssertionError)ÚselfÚrngÚdatesÚdfr   r   r   Ú!test_frame_ctor_datetime64_column   s    
z@TestDataFrameTimeSeriesMethods.test_frame_ctor_datetime64_columnc             C   sJ   t dddd�}ttjt|ƒƒd�}||d< tj|d jtjdƒƒsFt‚d S )Nz1/1/2000 00:00:00z1/1/2000 1:59:50r   )r   )Úindexr   zM8[ns])r
   r   r   Úaranger   r   r   r   )r   r    r"   r   r   r   Ú#test_frame_append_datetime64_column%   s    zBTestDataFrameTimeSeriesMethods.test_frame_append_datetime64_columnc             C   s"   t dtdddd�iƒ}t|ƒ d S )NÚyearz1/1/1700é2   zA-DEC)Úperiodsr   )r   r
   Úrepr)r   r"   r   r   r   Ú"test_frame_datetime64_pre1900_repr,   s    zATestDataFrameTimeSeriesMethods.test_frame_datetime64_pre1900_reprc       
      C   sX  d}dddddddg}t jd	ƒ}x�|D ]ˆ}t jd
j|d�ƒ}t j|t jd�j|ƒ}tdt j|ƒit j|ƒd�}|||< t|jdƒƒj	}|| j|ks˜t
‚|| j	|kjƒ s&t
‚q&W tdt j|ƒit j|ƒd�}t j|t jd�j|ƒ|d< xj|D ]b}t jd
j|d�ƒ}t j|t jd�j|ƒ}|jƒ }	||	d< t|jdƒƒj	}|	d j	|kjƒ sît
‚qîW d S )Néd   ÚhÚmÚsÚmsÚDÚMÚYzM8[ns]z
M8[{unit}])Úunit)r   Úints)r$   ÚOr!   )r   r   Úformatr%   Zint64Úviewr   r   ZastypeÚvaluesr   ÚallÚcopy)
r   ÚnZunitsZns_dtyper4   r   Úvalsr"   Zex_valsÚtmpr   r   r   Ú,test_frame_append_datetime64_col_other_units1   s(    


zKTestDataFrameTimeSeriesMethods.test_frame_append_datetime64_col_other_unitsc             C   sl   |j tjƒ ƒ}|j dƒ}tj|d |d ƒ |j ddd�}|j ddd�}|jg ƒ}|j dƒ}||k	sht‚d S )NZBMr   r   Úpad)Úmethod)ÚasfreqÚoffsetsZ	BMonthEndÚtmZassert_almost_equalZreindexr   )r   Zdatetime_frameZoffset_monthlyZrule_monthlyZfilledZ
filled_depZzero_lengthÚresultr   r   r   Útest_asfreqS   s    


z*TestDataFrameTimeSeriesMethods.test_asfreqc             C   sp   t ddddgitdddƒtdddƒtdddƒgd�}|jdƒ}t|jtƒsNt‚|d jdƒ}t|jtƒslt‚d S )	Nr   é   é   é   iÛ  é   )r$   r   )r   r   rB   Ú
isinstancer$   r   r   )r   r"   Útsr   r   r   Útest_asfreq_datetimeindexd   s    &
z8TestDataFrameTimeSeriesMethods.test_asfreq_datetimeindexc             C   s¦   t jdddd�}t jtjt|ƒƒ|d�}t jd|iƒ}d |jd< |jdd	d
�}|jdd�j	d	ƒ}d |jd< t
j||ƒ |jdd�j	d	ƒ}|jdd	d
�}t
j||ƒ d S )Nz1/1/2016é
   Z2S)r)   r   )r$   Úoneú2016-01-01 00:00:08Z1Sg      "@)r   Z
fill_value)r   )rP   rO   )rP   rO   )Úpdr
   r	   r   r%   r   r   ÚlocrB   ZfillnarD   Úassert_frame_equalÚassert_series_equal)r   r    rL   r"   Z	actual_dfZexpected_dfZexpected_seriesZactual_seriesr   r   r   Útest_asfreq_fillvalueo   s    

z4TestDataFrameTimeSeriesMethods.test_asfreq_fillvaluez%data,idx,expected_first,expected_lastr   rG   rH   rI   é   Údc             C   s„  t |jƒ}tjj|ƒ}tj|d d…< tj|d
d …< td|i|jd�}|jƒ }	|	|jd ks^t‚|j	ƒ }	|	|jd ksxt‚tƒ }
|
j	ƒ d ksŽt‚|
jƒ d ksžt‚tj|d d …< |j	ƒ d ks¼t‚|jƒ d ksÌt‚t
d|dd�|_d|jd< d|jd< |jƒ |jd k�st‚|j	ƒ |jd k�s t‚|jƒ j|jjk�s8t‚|j	ƒ j|jjk�sPt‚t||d�}||jƒ k�snt‚||j	ƒ k�s€t‚d S )Né   Úfoo)r$   é   Z20110101r   )r)   r   rG   rH   éûÿÿÿiúÿÿÿéþÿÿÿr\   )r   r$   r   r   r   Únanr   Úfirst_valid_indexr   Zlast_valid_indexr
   Úilocr   )r   Zfloat_frameÚdataÚidxZexpected_firstZexpected_lastÚNÚmatÚframer$   Úemptyr"   r   r   r   Útest_first_last_validƒ   s2    


z4TestDataFrameTimeSeriesMethods.test_first_last_validÚklassc             C   s:   |t jgƒ}|jƒ d kst‚|jd d… jƒ d ks6t‚d S )Nr   )r   r]   r^   r   r_   )r   rg   Úobjr   r   r   Útest_first_valid_index_all_nan¶   s    z=TestDataFrameTimeSeriesMethods.test_first_valid_index_all_nanc             C   sº   t jdd�}|jdƒ}t|ƒdks&t‚t jdd�}|jdƒ}t|ƒdksLt‚|jdƒ}|d d… }t j||ƒ |jd	ƒ}|d d
… }t j||ƒ |d d… jdƒ}t j||d d… ƒ d S )NÚ12h)r   Ú10dé   r1   rN   Ú3Mz	3/31/2000Ú21Dé   r   )rD   ÚmakeTimeDataFrameÚfirstr   r   rS   )r   rL   rE   Úexpectedr   r   r   Útest_first_subset¾   s    



z0TestDataFrameTimeSeriesMethods.test_first_subsetc          	   C   s>   t jdddgdddggƒ}tjtƒ� |jdƒ W d Q R X d S )NrG   rH   rI   rV   rX   rZ   Ú1D)rQ   r   ÚpytestÚraisesÚ	TypeErrorrq   )r   r"   r   r   r   Útest_first_raisesÒ   s    z0TestDataFrameTimeSeriesMethods.test_first_raisesc             C   s¼   t jdd�}|jdƒ}t|ƒdks&t‚t jddd�}|jdƒ}t|ƒdksNt‚|jd	ƒ}|d
d … }t j||ƒ |jd	ƒ}|dd … }t j||ƒ |d d… jdƒ}t j||d d… ƒ d S )Nrj   )r   rk   rl   é   r1   )Znperr   rN   rn   z
2000-01-10ro   r   rm   iëÿÿÿ)rD   rp   Úlastr   r   rS   )r   rL   rE   rr   r   r   r   Útest_last_subsetØ   s    



z/TestDataFrameTimeSeriesMethods.test_last_subsetc          	   C   s>   t jdddgdddggƒ}tjtƒ� |jdƒ W d Q R X d S )NrG   rH   rI   rV   rX   rZ   rt   )rQ   r   ru   rv   rw   rz   )r   r"   r   r   r   Útest_last_raisesì   s    z/TestDataFrameTimeSeriesMethods.test_last_raisesc             C   sf  t dddd�}ttjjt|ƒdƒ|d�}|j|d ƒ}|jj|d jkj	ƒ sPt
‚|jj|d jkj	ƒ sjt
‚|jj|d jkj	ƒ s„t
‚|jdƒ}|jtd	d
ƒƒ}tj||ƒ |jtd	d
ƒ }|j|jd	k|jd
k@  }tj||ƒ t ddƒ}ttjjt|ƒdƒ|d�}|jtddƒƒ}tj||ƒ t dddd�}ttjjt|ƒdƒ|ƒ}|jdƒ}t|ƒdk�sbt
‚d S )Nz1/1/2000z1/5/2000Ú5min)r   rH   )r$   rG   z9:30é	   ry   z	1/31/2000rI   r   z1/1/2012Z23Mini€  )r   r)   z16:00)r
   r   r   r   r   r   Úat_timer$   Úhourr:   r   ÚminuteÚsecondr   rD   rS   rR   )r   r    rL   ÚrsrE   rr   r   r   r   Útest_at_timeò   s(    


z+TestDataFrameTimeSeriesMethods.test_at_timer€   z1:00z1:00AM)Útzinfoc          	   C   sˆ   t jdddd�}t jttt|ƒƒƒ|d�}t|dd ƒd kr`|j|ƒ}|jdd… }t	j
||ƒ n$tjtd	d
�� |j|ƒ W d Q R X d S )NÚ2018rI   ÚH)r)   r   )r$   r…   rG   rH   zIndex must be timezone)Úmatch)rQ   r
   r   ÚlistÚranger   Úgetattrr   r_   rD   rS   ru   rv   Ú
ValueError)r   r€   Údtir"   rE   rr   r   r   r   Útest_at_time_errors  s    
z2TestDataFrameTimeSeriesMethods.test_at_time_errorsc             C   sb   t jddddd�}t jttt|ƒƒƒ|d�}|jtdtj	dƒd	�ƒ}|j
d
d… }tj||ƒ d S )Nr†   rI   r‡   z
US/Pacific)r)   r   Útz)r$   rV   z
US/Eastern)r…   rG   rH   )rQ   r
   r   r‰   rŠ   r   r   r   ÚpytzÚtimezoner_   rD   rS   )r   r�   r"   rE   rr   r   r   r   Útest_at_time_tz  s
    z.TestDataFrameTimeSeriesMethods.test_at_time_tzc          	   C   s>   t jdddgdddggƒ}tjtƒ� |jdƒ W d Q R X d S )NrG   rH   rI   rV   rX   rZ   z00:00)rQ   r   ru   rv   rw   r   )r   r"   r   r   r   Útest_at_time_raises'  s    z2TestDataFrameTimeSeriesMethods.test_at_time_raisesÚaxisr$   Úcolumnsr   c             C   s¬   t dddd�}ttjjt|ƒt|ƒƒƒ}|| |_|_||jdk|j	dk@ |j
dk@  }|dkrt|j|d d …f }n|dkrŽ|jd d …|f }|jd|d�}tj||ƒ d S )Nz1/1/2000z1/5/2000r}   )r   r~   ry   r   r$   r•   rG   z9:30)r”   )r$   r   )r•   rG   )r
   r   r   r   r   r   r$   r•   r€   r�   r‚   rR   r   rD   rS   )r   r”   r    rL   Úindicesrr   rE   r   r   r   Útest_at_time_axis-  s    "z0TestDataFrameTimeSeriesMethods.test_at_time_axisc             C   s  t dddd�}ttjjt|ƒdƒ|d�}tddƒ}tddƒ}|\}}|j||||ƒ}d}	|sd|	d8 }	|sp|	d
8 }	t|ƒ|	ks€t‚xR|j	D ]H}
|
jƒ }|r¦||ks²t‚n||ks²t‚|rÄ||ksÐt‚qˆ||k sˆt‚qˆW |jddƒ}|j||ƒ}t
j||ƒ t dddd�}ttjjt|ƒdƒ|d�}tddƒ}tddƒ}|j||||ƒ}d}	|�sV|	d
8 }	|�sd|	d
8 }	t|ƒ|	k�svt‚xˆ|j	D ]~}
|
jƒ }|�rª||k�sÂ||k�sÂt‚n||k�sÂ||k�sÂt‚|�râ||k�sú||k�sút‚n||k �s~||k�s~t‚�q~W d S )Nz1/1/2000z1/5/2000r}   )r   rH   )r$   r   rG   é   rV   rX   z00:00z01:00é   r~   é   rJ   é4   é5   é„   é…   i  i  )r
   r   r   r   r   r   r   Úbetween_timer   r$   rD   rS   )r   r   r    rL   ÚstimeÚetimeZ	inc_startZinc_endÚfilteredÚexp_lenrƒ   ÚtrE   rr   r   r   r   Útest_between_time>  sT    



z0TestDataFrameTimeSeriesMethods.test_between_timec             C   sB   t jdddgdddggƒ}tjtƒ� |jddd	� W d Q R X d S )
NrG   rH   rI   rV   rX   rZ   z00:00z12:00)Ú
start_timeÚend_time)rQ   r   ru   rv   rw   rŸ   )r   r"   r   r   r   Útest_between_time_raisesw  s    z7TestDataFrameTimeSeriesMethods.test_between_time_raisesc             C   sª   t dddd�}ttjjt|ƒt|ƒƒƒ}d\}}d}|dkrv||_t|j||ƒƒ|ksZt‚t|j||d	d
�ƒ|ksvt‚|dkr¦||_	|j||dd
�j	}t|ƒ|ks¦t‚d S )Nz1/1/2000r,   Ú10min)r)   r   ú08:00:00ú09:00:00é   r$   r   )r”   r•   rG   )rª   r«   )r$   r   )r•   rG   )
r
   r   r   r   r   r   r$   rŸ   r   r•   )r   r”   r    rL   r    r¡   r£   Úselectedr   r   r   Útest_between_time_axis}  s    z5TestDataFrameTimeSeriesMethods.test_between_time_axisc       	      C   sè   t dddd�}tjdt|ƒƒ}tjjt|ƒt|ƒƒ}t|||d�}d\}}d	}|dkr¬||_tj	t
|d�� |j||ƒ W d Q R X tj	t
|d�� |j||dd� W d Q R X |dkrä||_tj	t
|d�� |j||dd� W d Q R X d S )Nz1/1/2000r,   r©   )r)   r   r   )r$   r•   ú08:00:00ú09:00:00zIndex must be DatetimeIndexr•   rG   )rˆ   )r”   r$   )r¯   r°   )r•   rG   )r$   r   )r
   r   r%   r   r   r   r   r$   ru   rv   rw   rŸ   r•   )	r   r”   r    ÚmaskZ	rand_datarL   r    r¡   Úmsgr   r   r   Útest_between_time_axis_raisesŽ  s     z<TestDataFrameTimeSeriesMethods.test_between_time_axis_raisesc             C   sà   t jdt jt jt jdƒgiƒ}|jƒ }t jt jdƒgdgd�}tj||ƒ |jƒ }t jt jdƒgdgd�}tj||ƒ t jdt jt jgiƒ}|jƒ }t jt jgdgd�}tj||ƒ |jƒ }t jt jgdgd�}tj||ƒ d S )NrY   z
2012-05-01)r$   )	rQ   r   ZNaTZ	TimestampÚminr	   rD   rT   Úmax)r   r"   ÚresÚexpr   r   r   Útest_operation_on_NaT£  s    z4TestDataFrameTimeSeriesMethods.test_operation_on_NaTc             C   s–   t jddgdd�}tj|ƒjƒ }||d< tjdd gdd gdœdd�}tj||ƒ t jddgdd�}||d< tjdd gdd gdœdd�}tj||ƒ d S )	NrG   Znatzdatetime64[ns])r   Únew)r   r¹   zdatetime64[s]g    eÍÍA)r   ÚarrayrQ   r	   Zto_framer   rD   rS   )r   Zdata_nsrE   rr   Zdata_sr   r   r   Ú5test_datetime_assignment_with_NaT_and_diff_time_unitsº  s    zTTestDataFrameTimeSeriesMethods.test_datetime_assignment_with_NaT_and_diff_time_unitsc          
   C   sú   d}t ddƒ}tddƒ}ttjjt|ƒ|ƒ|d�}d|d< |jƒ }|jƒ }||_	t
j||ƒ |jdƒ}t
j|j	|j	jdƒƒ |j}|jdd	�}|jƒ }||_t
j||ƒ |jddd	�}t
j|j|jjdƒƒ d
}tjt|d�� |jdd	� W d Q R X d S )NrX   z1/1/2000z1/1/2001)r$   ÚaZmixr2   rG   )r”   zENo axis named 2 for object type <class 'pandas.core.frame.DataFrame'>)rˆ   rH   )r
   r   r   r   r   r   r   Z	to_periodr;   r$   rD   rS   Úassert_index_equalrB   ÚTr•   ru   rv   rŒ   )r   ÚKZdrÚprr"   Zptsr·   r²   r   r   r   Útest_frame_to_periodË  s*    


z3TestDataFrameTimeSeriesMethods.test_frame_to_periodÚfnÚtz_localizeÚ
tz_convertc             C   sÐ  t dddd�}t dddd�}ttdƒƒ}|dkrD|jdƒ}|jdƒ}�xÖ||gD �]È}t||ƒdƒ}t||ƒdƒ}ttjdƒ|d�}t||ƒdƒ}tj	|j
|ƒ ttjdƒtj||gƒƒ}	t|	|ƒdd	d
�}
|
j
jd	 j|ƒ sät‚tj	|
j
jd	 |ƒ tj	|
j
jd |ƒ |
j
jd j|ƒ �s&t‚t|	|ƒddd
�}
tj	|
j
jd	 |ƒ |
j
jd	 j|ƒ �sft‚tj	|
j
jd |ƒ |
j
jd j|ƒ �s”t‚ttjdƒtj||gƒƒ}t||ƒddd
�}tj	|
j
jd	 |ƒ |
j
jd	 j|ƒ �sît‚tj	|
j
jd |ƒ |
j
jd j|ƒ sPt‚qPW tjtdd�� t|d�}t||ƒdƒ}W d Q R X tjtdd��2 ttjdƒtj||gƒƒ}t||ƒdd	d
�}W d Q R X tjtdd��" t|d�}t||ƒddd
�}W d Q R X d S )NZ20140701rX   r1   )r)   r   rÄ   ÚUTCz
US/Pacific)r$   r   )ÚlevelrG   r   )rˆ   z	not valid)r
   r   rŠ   rÃ   r‹   r   r   ZonesrD   r½   r$   r   Zfrom_arraysZlevelsÚequalsr   ru   rv   rw   rŒ   )r   rÂ   Zl0Úl1Zint_idxra   Zl0_expectedZl1_expectedZdf1Zdf2Zdf3Zdf4Zdf5r"   r   r   r   Útest_tz_convert_and_localizeè  sL    



z;TestDataFrameTimeSeriesMethods.test_tz_convert_and_localizeN)'Ú__name__Ú
__module__Ú__qualname__r#   r&   r+   r?   rF   rM   rU   ru   ÚmarkZparametrizer   r]   rf   r	   r   ri   rs   rx   r{   r|   r„   r   r�   rÅ   rŽ   r’   r“   r—   r¥   r¨   r®   r³   r¸   r»   rÁ   rÉ   r   r   r   r   r      sD   "*+&9r   )r   r   Ú	itertoolsr   Znumpyr   ru   r�   ZpandasrQ   r   r   r   r   r	   r
   r   r   Zpandas._testingZ_testingrD   Zpandas.tseries.offsetsZtseriesrC   Zfixturer   r   r   r   r   r   Ú<module>   s   (

"