a
    DBìjhÉ  ã                   @   s¬   d dl Z d dlmZ d dlZd dlZd dlZd dlm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mZ d dlmZ d dlm  mZ d dlmZ G dd„ dƒZdS )é    N)ÚStringIO)ÚParserError)
Ú	DataFrameÚIndexÚ
MultiIndexÚNaTÚSeriesÚ	TimestampÚ
date_rangeÚperiod_rangeÚread_csvÚto_datetime)Ú
get_handlec                   @   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 ddddgg¡dd„ ƒZe
jjdd„ ƒZdždd„Ze
jje
j dg d¢¡dd„ ƒƒZe
jje
j dg d¢¡e
j dg d¢¡e
j d g d!¢¡e
j d"¡d#d$„ ƒƒƒƒƒZe
jje
j dg d%¢¡e
j d g d!¢¡d&d'„ ƒƒƒZe
jje
j dg d(¢¡d)d*„ ƒƒZe
jjd+d,„ ƒZe
jjd-d.„ ƒZe
jje
j dg d¢¡e
j d g d/¢¡e
j d0d1d2id3d2igd4d2id5d2igd2d2d6œd2d2d7œgg¡d8d9„ ƒƒƒƒZd:d;„ Zd<d=„ Zd>d?„ Zd@dA„ ZdBdC„ ZdDdE„ ZdFdG„ ZdHdI„ Z dJdK„ Z!dLdM„ Z"dNdO„ Z#dPdQ„ Z$e
j dRg dS¢¡dTdU„ ƒZ%e
jjdVdW„ ƒZ&dXdY„ Z'dZd[„ Z(d\d]„ Z)d^d_„ Z*d`da„ Z+dbdc„ Z,ddde„ Z-e
j dfddgg¡dhdi„ ƒZ.djdk„ Z/dldm„ Z0dndo„ Z1dpdq„ Z2e
j dre3g ds¢g dt¢gdudvgg dw¢dx�dfe3g dy¢gg dw¢dz�d{fe3d|g d}¢g g dw¢dz�d~fe3d|g d¢g g dw¢dz�d€fg¡d�d‚„ ƒZ4dƒd„„ Z5e
j d…e6 7d†¡e6 7d‡¡g¡dˆd‰„ ƒZ8dŠd‹„ Z9dŒd�„ Z:dŽd�„ Z;d�d‘„ Z<d’d“„ Z=d”d•„ Z>d–d—„ Z?d˜d™„ Z@dšd›„ ZAdœd�„ ZBdS )ŸÚTestDataFrameToCSVc                 K   s(   ddi}|j f i |¤Ž t|fi |¤ŽS )NÚ	index_colr   )Úupdater   )ÚselfÚpathÚkwargsÚparams© r   úe/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/frame/methods/test_to_csv.pyr      s    zTestDataFrameToCSV.read_csvc              	   C   s~  t  d¡��\}tj|jd d…|j d¡f< | |¡ |j|ddgd� |j|dd� |j|dd� |j 	d ¡|_| |¡ | j
|d	d
�}t  ||¡ |j|dd� | j
|d d	d�}t|jƒt|jƒd ksÎJ ‚|j|dd� | j
|d d	d�}t  |j|j¡ tttdƒtjdtjd�d�ttdƒtjdtjd�d�dœƒ}| |¡ |  
|¡}t  ||¡ W d   ƒ n1 �sp0    Y  d S )NZ__tmp_to_csv_from_csv1__é   ÚAÚB©ÚcolumnsF©Úheader©ÚindexT)Úparse_datesr    ©Zindex_label©r   r!   é   é   ©Údtypeé   )Ús1Ús2)ÚtmÚensure_cleanÚnpÚnanÚilocr   Zget_locÚto_csvr    Ú
_with_freqr   Úassert_frame_equalÚlenÚassert_almost_equalÚvaluesr   r   ÚrangeÚarangeÚint64)r   Úfloat_frameÚdatetime_framer   ÚreconsÚdmr   r   r   Útest_to_csv_from_csv1$   s0    

þÿ

z(TestDataFrameToCSV.test_to_csv_from_csv1c           
   	   C   sV  t  d¡��4}ttj d¡ d¡g d¢g d¢d�}| |¡ |  |¡}t  	||¡ t
 g d¢¡}ttj d¡ d¡|g d¢d�}| |¡ | j|g d¢d	d
�}t j	||d	d� tg d¢ƒ}|j||d� |  |¡}| ¡ }||_t  	||¡ d}	tjt|	d��" |j|ddgd� W d   ƒ n1 �s(0    Y  W d   ƒ n1 �sH0    Y  d S )NZ__tmp_to_csv_from_csv2__r(   ©r%   r%   ©Úar@   Úb)ÚxÚyÚz©r    r   )©r   r$   r(   rF   )r   r$   r(   ©r   r$   r(   Fr#   ©Zcheck_names)ÚAAÚXÚYÚZr   z Writing 4 cols but got 2 aliases©ÚmatchrI   rJ   )r+   r,   r   r-   ÚrandomÚdefault_rngÚstandard_normalr0   r   r2   r   Úfrom_tuplesr   Úcopyr   ÚpytestÚraisesÚ
ValueError)
r   r9   r   ÚdfÚresultZmidxZcol_aliasesÚrsÚxpÚmsgr   r   r   Útest_to_csv_from_csv2J   s6    ý

ý

z(TestDataFrameToCSV.test_to_csv_from_csv2c                 C   s¾   t  d¡� }ttj d¡ d¡ƒ}ttj d¡ d¡ƒ}| |¡ |j|ddd� t 	||g¡}t
|dd�}d	d
„ |jD ƒ|_dd
„ |jD ƒ|_t  ||¡ W d   ƒ n1 s°0    Y  d S )NZ__tmp_to_csv_from_csv3__r(   )r%   r$   r@   F)Úmoder   r   ©r   c                 S   s   g | ]}t |ƒ‘qS r   ©Úint©Ú.0Úlabelr   r   r   Ú
<listcomp>w   ó    z<TestDataFrameToCSV.test_to_csv_from_csv3.<locals>.<listcomp>c                 S   s   g | ]}t |ƒ‘qS r   r_   ra   r   r   r   rd   x   re   )r+   r,   r   r-   rO   rP   rQ   r0   ÚpdÚconcatr   r   r2   )r   r   Zdf1Údf2rZ   rY   r   r   r   Útest_to_csv_from_csv3n   s    
z(TestDataFrameToCSV.test_to_csv_from_csv3c                    s¼   t  d¡�ž}tjdd�‰ td‡ fdd„tdƒD ƒit‡ fdd„tdƒD ƒd	d
�d�}| |¡ t|d	d�}t 	|j
¡|_
t 	|d ¡|d< t j||dd� W d   ƒ n1 s®0    Y  d S )NZ__tmp_to_csv_from_csv4__r$   )ÚsecondsZdt_datac                    s   g | ]}|ˆ  ‘qS r   r   ©rb   Úi©Údtr   r   rd   €   re   z<TestDataFrameToCSV.test_to_csv_from_csv4.<locals>.<listcomp>r%   c                    s   g | ]}|ˆ  ‘qS r   r   rk   rm   r   r   rd   �   re   Údt_index©Únamer   r^   T)Zcheck_index_type)r+   r,   rf   Ú	Timedeltar   r6   r   r0   r   Zto_timedeltar    r2   ©r   r   rW   rX   r   rm   r   Útest_to_csv_from_csv4{   s    þ
z(TestDataFrameToCSV.test_to_csv_from_csv4c                    sz   t  d¡�\}ˆ |¡ t|ddgd�‰ ‡ ‡fdd„}|dƒˆ d< |dƒˆ d< t  ˆ ˆ¡ W d   ƒ n1 sl0    Y  d S )	NZ__tmp_to_csv_from_csv5__r   r   r#   c                    s$   t ˆ |  ƒj d¡j ˆ|  jj¡S )NÚUTC)r   rn   Ú
tz_convertÚtz)Úc©rX   Útimezone_framer   r   Ú<lambda>’   s   ÿ
þz:TestDataFrameToCSV.test_to_csv_from_csv5.<locals>.<lambda>r   ÚC)r+   r,   r0   r   r2   )r   rz   r   Ú	converterr   ry   r   Útest_to_csv_from_csv5‹   s    
ÿz(TestDataFrameToCSV.test_to_csv_from_csv5c                 C   sÆ   d}t |d ƒ}tt |df¡tdd„ t|ƒD ƒdd�tdd„ tdƒD ƒdd�d	�}|j}|d
 |d g}t ¡ �,}|j	|||d� t
|dd�}W d   ƒ n1 s¤0    Y  tj|| |dd� d S )Nr   ç      @r%   c                 S   s   g | ]}d |› �‘qS ©zi-r   rk   r   r   r   rd   ¡   re   zBTestDataFrameToCSV.test_to_csv_cols_reordering.<locals>.<listcomp>r@   rp   c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   ¢   re   rE   r(   r   ©r   Ú	chunksizer^   FrH   )r`   r   r-   Úonesr   r6   r   r+   r,   r0   r   r2   )r   r‚   ÚNrW   ÚcsÚcolsr   Úrs_cr   r   r   Útest_to_csv_cols_reorderingš   s    ý
*z.TestDataFrameToCSV.test_to_csv_cols_reorderingr†   NrA   r@   c                 C   s  d}t |d ƒ}tt |df¡tdd„ t|ƒD ƒdd�g d¢d	�}t ¡ �¾}|j|||d
� t	|dd�}|d urâ|j
jr€||_
n|j
 |¡\}}|j
 |¡|_
|D ]<}	||	 }
||	 }t|
tƒrÎt |
|¡ q¢tj|
|dd� q¢n|j
|_
tj||dd� W d   ƒ n1 �s0    Y  d S )Nr   r   r%   c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   µ   re   z@TestDataFrameToCSV.test_to_csv_new_dupe_cols.<locals>.<listcomp>r@   rp   r?   rE   r�   r   r^   FrH   )r`   r   r-   rƒ   r   r6   r+   r,   r0   r   r   Z	is_uniqueZget_indexer_non_uniqueZtakeÚ
isinstancer   Zassert_series_equalr2   )r   r†   r‚   r„   rW   r   r‡   ZindexerÚmissingrx   Zobj_dfZobj_rsr   r   r   Útest_to_csv_new_dupe_cols­   s.    ý

z,TestDataFrameToCSV.test_to_csv_new_dupe_colsc                 C   s’   ddd„}d}||d ƒ}||d dƒ}t  d¡�L}t||dœƒ}|j||d� |  |¡ t¡}t j||d	d
� W d   ƒ n1 s„0    Y  d S )Nc                 S   sz   |d u rt | d ƒ}ttdd| d�ƒ}|rvtj d¡ dt|ƒ|¡D ]}t||< qDtj d¡ d¡}t|| < t||< |S )Ngš™™™™™¹?Ú2000Z5min)ÚfreqÚperiodsr(   r   éd   )	r`   Úlistr
   r-   rO   rP   Úintegersr3   r   )ÚnZnnatÚsrl   r   r   r   Úmake_dtnat_arrÕ   s    

z<TestDataFrameToCSV.test_to_csv_dtnat.<locals>.make_dtnat_arréè  r   r   z1.csv©r@   rA   ©r‚   FrH   )N)r+   r,   r   r0   r   Úapplyr   r2   )r   r”   r‚   r)   r*   ÚpthrW   r;   r   r   r   Útest_to_csv_dtnatÒ   s    
z$TestDataFrameToCSV.test_to_csv_dtnatFc                    s¤  ddi}|r‚|d ur$t t|ƒƒ|d< t t|ƒƒ|d< t d¡�2}	|j|	d|d� | j|	fi |¤Ž‰W d   ƒ qÖ1 sv0    Y  nTd|d< t d¡�2}	|j|	d|d� | j|	fi |¤Ž‰W d   ƒ n1 sÌ0    Y  d	d
„ ‰ |rê|jˆ_|�rF|�sF‡fdd„t|d ƒD ƒ}
t t ˆj	ƒg|
 ¡}|ˆ_	ˆj
d d …|d d …f ‰dddddddœ}|�rx|dk�r®d}tj‡ fdd„ˆj	D ƒ|d�ˆ_	tj‡ fdd„|j	D ƒ|d�|_	nÊ|dk�röd}tjdd„ ˆj	D ƒ|d�ˆ_	tjdd„ |j	D ƒ|d�|_	n‚|dk�rJd}tˆj	ƒ}tjdd„ |D ƒ|d�ˆ_	tjt tt|j	 ¡ ƒƒ|d�|_	n.| |¡}tjˆj	|d�ˆ_	tj|j	|d�|_	|�rœ|dk�rÎd}tj‡ fdd„ˆjD ƒ|d�ˆ_tj‡ fdd„|jD ƒ|d�|_nÎ|dk�rd}tjdd„ ˆjD ƒ|d�ˆ_tjdd„ |jD ƒ|d�|_n†|dk�rnd}tˆjƒ}tjdd„ |D ƒ|d�ˆ_|j ¡ }tjd d„ |D ƒ|d�|_n.| |¡}tjˆj|d�ˆ_tj|j|d�|_|ˆfS )!Nr!   Fr   r   Z__tmp_to_csv_moar__Úutf8)Úencodingr‚   r   c                 S   s   t | tƒs|  d¡S | S )Nr›   )r‰   ÚstrÚdecode©rB   r   r   r   Ú_to_uni  s    

z;TestDataFrameToCSV._return_result_expected.<locals>._to_unic                    s    g | ]}ˆ j d d …|f j‘qS )N)r/   r5   rk   )r;   r   r   rd     re   z>TestDataFrameToCSV._return_result_expected.<locals>.<listcomp>r$   rl   ÚfÚO)rl   r¡   r“   Úurn   Úpr£   c                    s   g | ]}ˆ |ƒ‘qS r   r   ra   ©r    r   r   rd     re   r&   c                    s   g | ]}ˆ |ƒ‘qS r   r   ra   r¥   r   r   rd     re   rn   c                 S   s   g | ]}t |ƒ‘qS r   ©r	   ra   r   r   r   rd   "  re   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   %  re   r¤   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   +  re   c                    s   g | ]}ˆ |ƒ‘qS r   r   ra   r¥   r   r   rd   8  re   c                    s   g | ]}ˆ |ƒ‘qS r   r   ra   r¥   r   r   rd   ;  re   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   @  re   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   C  re   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   I  re   c                 S   s   g | ]}t |ƒ‘qS r   r¦   ra   r   r   r   rd   M  re   )r�   r6   r+   r,   r0   r   r   r   Úfrom_arraysr    r/   r-   Úarrayr   Úmapr	   Zto_timestampÚget)r   rW   r‚   Zr_dtypeZc_dtypeÚrnlvlÚcnlvlÚdupe_colr   r   Z	delta_lvlÚixZtype_mapZidx_listZcol_listr   )r    r;   r   Ú_return_result_expectedì   s¢    
20
ÿÿ

ÿÿ


ÿÿ


ÿÿ

ÿÿ


ÿ
ÿ

z*TestDataFrameToCSV._return_result_expectedÚnrows)r(   é
   éc   r�   ée   éf   éÆ   éÇ   éÈ   éÉ   éÊ   éù   éú   éû   c                 C   sT   t t |df¡td|d�ttdƒtd�d�}|  |ddd	¡\}}tj	||d
d� d S )Né   ú
2020-01-01©rŽ   Úabcdr&   rE   r•   rn   r“   FrH   )
r   r-   rƒ   r
   r   r�   Úobjectr¯   r+   r2   )r   r°   rW   rX   Úexpectedr   r   r   Útest_to_csv_nrowsU  s    
ýz$TestDataFrameToCSV.test_to_csv_nrowszr_idx_type, c_idx_type))rl   rl   )r“   r“   )r“   rn   )r¤   r¤   Úncols©r$   r(   r%   r½   z3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc           	      C   sn   dd„ dd„ dd„ dd„ dœ}t t ||f¡|| |ƒ|| |ƒd�}|  |d||¡\}}tj||d	d
� d S )Nc                 S   s   t t | ¡tjd�S )Nr&   )r   r-   r7   r8   ©r’   r   r   r   r{   m  re   z:TestDataFrameToCSV.test_to_csv_idx_types.<locals>.<lambda>c                 S   s   t dd„ tdd|  ƒD ƒƒS )Nc                 S   s   g | ]}|› d t |ƒ› �‘qS )Ú_)Úchrrk   r   r   r   rd   n  re   zNTestDataFrameToCSV.test_to_csv_idx_types.<locals>.<lambda>.<locals>.<listcomp>éa   )r   r6   rÆ   r   r   r   r{   n  re   c                 S   s   t d| d�S )Nr¾   r¿   )r
   rÆ   r   r   r   r{   o  re   c                 S   s   t d| dd�S )Nr¾   ÚD)rŽ   r�   )r   rÆ   r   r   r   r{   p  re   )rl   r“   rn   r¤   rE   r•   FrH   )r   r-   rƒ   r¯   r+   r2   )	r   r°   Z
r_idx_typeZ
c_idx_typerÄ   ZaxesrW   rX   rÂ   r   r   r   Útest_to_csv_idx_typesb  s"    ü

ýüz(TestDataFrameToCSV.test_to_csv_idx_types)r±   éb   r²   r�   r³   r´   rµ   r¶   r·   r¸   r¹   rº   r»   r¼   c                 C   sh   t t ||f¡tdd„ t|ƒD ƒdd�tdd„ t|ƒD ƒdd�d�}|  |d¡\}}tj||dd	� d S )
Nc                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   ‡  re   z<TestDataFrameToCSV.test_to_csv_idx_ncols.<locals>.<listcomp>r@   rp   c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   ˆ  re   rE   r•   FrH   )r   r-   rƒ   r   r6   r¯   r+   r2   )r   r°   rÄ   rW   rX   rÂ   r   r   r   Útest_to_csv_idx_ncols  s    ýz(TestDataFrameToCSV.test_to_csv_idx_ncols)r±   rÌ   r²   r�   r³   r´   c                 C   sÌ   t t |df¡tdd„ t|ƒD ƒdd�tdd„ tdƒD ƒdd�d�}t|jƒ}ddg|d d	…< ddg|d
d …< t|jƒ}ddg|d d	…< ddg|d
d …< ||_||_| j|ddd�\}}t	j
||dd� d S )Nr%   c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   ’  re   z;TestDataFrameToCSV.test_to_csv_dup_cols.<locals>.<listcomp>r@   rp   c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   “  re   rE   Zduper(   éþÿÿÿZrduper•   T)r­   FrH   )r   r-   rƒ   r   r6   r�   r   r    r¯   r+   r2   )r   r°   rW   r†   r®   rX   rÂ   r   r   r   Útest_to_csv_dup_cols�  s    ý

z'TestDataFrameToCSV.test_to_csv_dup_colsc                 C   s:   t tjdtjd�d�}|  |d¡\}}tj||dd� d S )Nr±   r&   r   r•   F)Zcheck_column_type)r   r-   r7   r8   r¯   r+   r2   )r   rW   rX   rÂ   r   r   r   Útest_to_csv_empty¡  s    z$TestDataFrameToCSV.test_to_csv_emptyc                    sp   d}|d d ‰ t t ˆ df¡ttdƒƒt ‡ fdd„tdƒD ƒ¡d�}| j||dd�\}}t	j
||d	d
� d S )Nr•   r(   r$   Úabc                    s   g | ]}t ˆ ƒ‘qS r   ©r6   ©rb   rÇ   ©Úrowsr   r   rd   ®  re   z<TestDataFrameToCSV.test_to_csv_chunksize.<locals>.<listcomp>©r   r    )r«   FrH   )r   r-   rƒ   r   r�   r   r§   r6   r¯   r+   r2   )r   r‚   rW   rX   rÂ   r   rÔ   r   Útest_to_csv_chunksize§  s    
ýz(TestDataFrameToCSV.test_to_csv_chunksize)r(   r%   r½   zdf_params, func_paramsÚr_idx_nlevelsr(   r«   Úc_idx_nlevelsr¬   )rØ   rÙ   )r«   r¬   c           
         s¶   |  d¡r,t ‡fdd„t|d ƒD ƒ¡}nd }|  d¡r\t ‡ fdd„t|d ƒD ƒ¡}ntdd„ tˆ ƒD ƒƒ}tt ˆˆ f¡||d�}| j|d	fi |¤Ž\}}	t	j
||	d
d� d S )NrØ   c                 3   s    | ]}d d„ t ˆ ƒD ƒV  qdS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   Ã  re   úCTestDataFrameToCSV.test_to_csv_params.<locals>.<genexpr>.<listcomp>NrÒ   rÓ   )r°   r   r   Ú	<genexpr>Â  s   ÿz8TestDataFrameToCSV.test_to_csv_params.<locals>.<genexpr>rÙ   c                 3   s    | ]}d d„ t ˆ ƒD ƒV  qdS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   Ë  re   rÚ   NrÒ   rÓ   )rÄ   r   r   rÛ   Ê  s   ÿc                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   Ï  re   z9TestDataFrameToCSV.test_to_csv_params.<locals>.<listcomp>rE   r•   FrH   )rª   r   r§   r6   r   r   r-   rƒ   r¯   r+   r2   )
r   r°   Z	df_paramsZfunc_paramsrÄ   r    r   rW   rX   rÂ   r   )rÄ   r°   r   Útest_to_csv_params³  s    

þ


þ
z%TestDataFrameToCSV.test_to_csv_paramsc                 C   s†   t j|d< dd„ }|j |¡|d< t ¡ �H}| |¡ |  |¡}t ||¡ t t  	|¡t  	|¡¡ W d   ƒ n1 sx0    Y  d S )NÚGc                 S   s    t jt jgt j d¡ ¡ dk  S )Nr(   ç      à?)r-   Úinfr.   rO   rP   rŸ   r   r   r   r{   ×  re   zETestDataFrameToCSV.test_to_csv_from_csv_w_some_infs.<locals>.<lambda>Úh)
r-   r.   r    r©   r+   r,   r0   r   r2   Úisinf)r   r9   r¡   r   r;   r   r   r   Ú test_to_csv_from_csv_w_some_infsÔ  s    



z3TestDataFrameToCSV.test_to_csv_from_csv_w_some_infsc                 C   sz   t j|d< t j |d< t ¡ �H}| |¡ |  |¡}t ||¡ t t  |¡t  |¡¡ W d   ƒ n1 sl0    Y  d S )NÚEÚF)r-   rß   r+   r,   r0   r   r2   rá   )r   r9   r   r;   r   r   r   Útest_to_csv_from_csv_w_all_infsá  s    



z2TestDataFrameToCSV.test_to_csv_from_csv_w_all_infsc                 C   sœ   t  d¡�~}tg d¢g d¢dœƒ}|j|dd� t|ƒ}t  ||¡ tg d¢dd	�|d
< |j|dd� t|ƒ}t  ||¡ W d   ƒ n1 sŽ0    Y  d S )NZ__tmp_to_csv_no_index__©r$   r(   r%   ©r½   r   é   )Úc1Úc2Fr   )é   é   é	   r8   r&   Úc3)r+   r,   r   r0   r   r2   r   rs   r   r   r   Útest_to_csv_no_indexí  s    z'TestDataFrameToCSV.test_to_csv_no_indexc                 C   s>   t g d¢g d¢dœƒ}d|d< | ¡ |jg d¢d�ks:J ‚d S )N©r@   rA   rx   )ÚaaZbbÚcc)r   r$   ÚtxtÚtest)r   r$   rô   r   )r   r0   )r   rW   r   r   r   Útest_to_csv_with_mix_columnsù  s    z/TestDataFrameToCSV.test_to_csv_with_mix_columnsc                 C   sÐ   t ddgddggddgd�}t ddgddggdd	gd�}t d
¡�z}|j|dd	gd� |  |¡}t ||¡ |j|ddd	gd� |  |¡}|jdd�}|d u s¢J ‚t ||¡ W d   ƒ n1 sÂ0    Y  d S )Nr$   r(   r%   r½   r   r   r   rJ   rK   Z__tmp_to_csv_headers__r   F)r    r   T)Zinplace)r   r+   r,   r0   r   r2   Zreset_index)r   Zfrom_dfZto_dfr   r;   Zreturn_valuer   r   r   Útest_to_csv_headers  s    

z&TestDataFrameToCSV.test_to_csv_headersc              
   C   sl  |}|j }tjt|ƒd tjd� dd¡}tj|ddgd�}||_ t 	d¡��t}|j
|dd	� |j
|d
dgd� | 
|¡ | j|ddgdd�}tj||dd� |j j|j jks²J ‚||_ |}	|	j }|tjt|ƒtjd�g}t |¡|	_ |	j
|ddgd� tjtdd��$ | j|ddgdd�}
W d   ƒ n1 �s20    Y  tj|	|
dd� |	 
|¡ | j|d d�}
t|
jƒt|	jƒd k�s‚J ‚|	j
|dd� | j|d d�}
t |
j|j¡ ||_ W d   ƒ n1 �sÊ0    Y  t 	d¡��ú}d0dd„}tt d¡tjdd„ tdƒD ƒtdƒd�tjd d„ tdƒD ƒtd!ƒd�d"�}| 
|¡ t|g d#¢ddgd$�}t ||¡ tt d¡tjd%d„ tdƒD ƒtdƒd�d�}| 
|¡ t|g d#¢dd$�}t ||¡ tt d¡tjd&d„ tdƒD ƒtdƒd�tjd'd„ td(ƒD ƒtd)ƒd�d"�}| 
|¡ t|g d#¢g d*¢d$�}t ||¡ |ƒ }|j
|dd� t|ddgd	�}t ||¡ |dƒ}|j
|dd� t|ddgd	�}tj|jjŽ �sœJ ‚|jj|j_t ||¡ |ƒ }| 
|¡ t|ddgdgd$�}t ||¡ |dƒ}| 
|¡ t|ddgdgd$�}t ||¡ |dƒ}| 
|¡ d+D ]X}d,|› d-�}tjt|d��& t|tt|ƒƒdd$� W d   ƒ n1 �sx0    Y  �q,d.}tjt|d��" |j
|dd/gd� W d   ƒ n1 �sÂ0    Y  W d   ƒ n1 �sâ0    Y  t 	d¡�`}|	d d…  
|¡ |  |¡}
|	d d… }g |_ t |
j|j¡ t|
ƒdk�sHJ ‚W d   ƒ n1 �s^0    Y  d S )1Nr(   r&   éÿÿÿÿÚfirstÚsecond©ÚnamesZ__tmp_to_csv_multiindex__Fr   r   r   r   r   r$   r#   rH   ÚtimeÚfoor"   zCould not infer formatrM   Tr^   r   c                 S   s@   | du rddg} t tj d¡jdddd�tjg d	¢| d
�dd�S )NTrø   rù   r(   r   r±   r>   )Úsize))Úbahrý   )rÿ   Úbar)ZbanÚbazrú   r8   ©r   r'   )r   r-   rO   rP   r‘   r   rR   rú   r   r   r   Ú_make_frameI  s    ÿûz>TestDataFrameToCSV.test_to_csv_multiindex.<locals>._make_frame©r   r%   c                 S   s   g | ]}d d„ t dƒD ƒ‘qS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   X  re   úHTestDataFrameToCSV.test_to_csv_multiindex.<locals>.<listcomp>.<listcomp>r%   rÒ   rÓ   r   r   r   rd   X  re   z=TestDataFrameToCSV.test_to_csv_multiindex.<locals>.<listcomp>r½   rÀ   c                 S   s   g | ]}d d„ t dƒD ƒ‘qS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   [  re   r  r   rÒ   rÓ   r   r   r   rd   [  re   rÑ   rÖ   )r   r$   r(   r%   )r   r   c                 S   s   g | ]}d d„ t dƒD ƒ‘qS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   f  re   r  r%   rÒ   rÓ   r   r   r   rd   f  re   c                 S   s   g | ]}d d„ t dƒD ƒ‘qS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   q  re   r  r%   rÒ   rÓ   r   r   r   rd   q  re   c                 S   s   g | ]}d d„ t dƒD ƒ‘qS )c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   t  re   r  r   rÒ   rÓ   r   r   r   rd   t  re   r%   ÚabcrG   )rè   rë   zlen of z, but only 5 lines in filez%cannot specify cols with a MultiIndexr   )N)r    r-   r7   r3   r8   Zreshaper   r§   r+   r,   r0   r   r2   rû   Zassert_produces_warningÚUserWarningr   r4   r5   r   rƒ   r6   r�   ÚcomZall_nonerT   rU   r   Ú	TypeErrorZassert_index_equal)r   r9   r:   ÚframeZ	old_indexZarraysZ	new_indexr   rW   Ztsframer;   r  rX   rl   r[   Úexpr   r   r   Útest_to_csv_multiindex  sÆ     
ÿ4
&
ÿÿû	
ÿþ
ÿÿû	



:R
z)TestDataFrameToCSV.test_to_csv_multiindexc                 C   sŠ   t tdƒtdƒdœt dd¡d�}t d¡�J}| |¡ | j|dd�}| 	¡ }|j
 d¡|_
t ||¡ W d   ƒ n1 s|0    Y  d S )	Nr  r%   ©r   r   r   r   z!__tmp_to_csv_interval_index__.csvr^   r�   )r   r�   r6   rf   Zinterval_ranger+   r,   r0   r   rS   r    Úastyper2   )r   Zusing_infer_stringrW   r   rX   rÂ   r   r   r   Útest_to_csv_interval_index­  s    "
z-TestDataFrameToCSV.test_to_csv_interval_indexc              	   C   s²   t tj d¡ d¡ tj¡ƒ}tj|d< t 	d¡�l}|j
|dd� t|dd��2}| ¡ }|d  d	¡d d
ksrJ ‚W d   ƒ n1 s†0    Y  W d   ƒ n1 s¤0    Y  d S )Nr(   )r$   r½   r$   z!__tmp_to_csv_float32_nanrep__.csviç  )Úna_repúutf-8©rœ   ú,Z999)r   r-   rO   rP   rQ   r  Zfloat32r.   r+   r,   r0   ÚopenÚ	readlinesÚsplit)r   rW   r   r¡   Úlinesr   r   r   Útest_to_csv_float32_nanrep»  s    ÿ
z-TestDataFrameToCSV.test_to_csv_float32_nanrepc                 C   sd   t g d¢g d¢dœƒ}t d¡�0}| |¡ |  |¡}t ||¡ W d   ƒ n1 sV0    Y  d S )Nræ   )z5,6z7,8z9,0r  z__tmp_to_csv_withcommas__.csv©r   r+   r,   r0   r   r2   ©r   rW   r   rh   r   r   r   Útest_to_csv_withcommasÈ  s
    

z)TestDataFrameToCSV.test_to_csv_withcommasc                 C   s€  dd„ }t tj d¡ d¡d|dƒd�}t tj d¡ d¡ d¡d|d	ƒd�}t d
|j|dƒd�}t d|j|dƒdd�}t tdƒ d¡|j|dƒd�}tj	|j
dd…dd…f< tj	|j
dd…dd…f< tj|||||gdd�}i }dtjfd	tjfdtjfdtffD ]"\}	}
||	ƒD ]}|
||< �q�qt ¡ �:}| |¡ t|d||dƒd�}t ||¡ W d   ƒ n1 �sr0    Y  d S )Nc                    s   ‡ fdd„t dƒD ƒS )Nc                    s   g | ]}ˆ › |d ›�‘qS )Z03dr   rk   rp   r   r   rd   Ó  re   zMTestDataFrameToCSV.test_to_csv_mixed.<locals>.create_cols.<locals>.<listcomp>r   rÒ   rp   r   rp   r   Úcreate_colsÒ  s    z9TestDataFrameToCSV.test_to_csv_mixed.<locals>.create_colsr(   )r�   r   Úfloat64Úfloat)r'   r   r8   r`   TÚboolrE   rý   rÁ   )r    r   r'   Ú20010101ÚnsÚdateé   é2   r$   r%   )Úaxisr   )r   r'   r!   )r   r-   rO   rP   rQ   r  r    r	   Úas_unitr.   r/   rf   rg   r  r8   Zbool_rÁ   r+   r,   r0   r   r2   )r   r  Údf_floatÚdf_intÚdf_boolÚ	df_objectÚdf_dtrW   Zdtypesr’   r'   rx   ÚfilenamerY   r   r   r   Útest_to_csv_mixedÑ  sJ    ýýÿýü

ÿz$TestDataFrameToCSV.test_to_csv_mixedc           
      C   sš  t tj d¡ d¡ttdƒƒttdƒƒ dd�}t ¡ �:}| 	|¡ t
|dd�}|j|_t ||¡ W d   ƒ n1 sx0    Y  t tj d¡ d¡dd	�}t tj d¡ d¡ƒ d
¡}t d|jtdƒd�}t d|jtdƒd�}t tdƒ d¡|jtdƒd�}tj|||||gddd�}g d¢d |_t ¡ �V}| 	|¡ t
|dd�}dD ]}	t||	 ƒ||	< �qJ|j|_t ||¡ W d   ƒ n1 �sŒ0    Y  d S )Nr(   )r•   r#  é   r  r  r   r^   )r•   r%   r&   r8   Tr%   rE   rý   r   r!  r$   )r%  Zignore_indexrG   r   )z0.4z1.4z2.4)r   r-   rO   rP   rQ   r�   r6   r+   r,   r0   r   r   r2   r  r    r	   r&  rf   rg   r   )
r   rW   r,  rX   r'  r(  r)  r*  r+  rl   r   r   r   Útest_to_csv_dups_cols  s@    ý

*ÿÿÿÿ

z(TestDataFrameToCSV.test_to_csv_dups_colsc                 C   s�   t t d¡tdd„ tdƒD ƒdd�tg d¢ƒd�}t ¡ �B}| |¡ t|d	d
�}|j	ddid�}t 
||¡ W d   ƒ n1 s‚0    Y  d S )Nr  c                 S   s   g | ]}d |› �‘qS r€   r   rk   r   r   r   rd   .  re   z=TestDataFrameToCSV.test_to_csv_dups_cols2.<locals>.<listcomp>r   rý   rp   r?   rE   r   r^   za.1r@   r   )r   r-   rƒ   r   r6   r+   r,   r0   r   Úrenamer2   )r   rW   r,  rX   r   r   r   Útest_to_csv_dups_cols2*  s    
ý

z)TestDataFrameToCSV.test_to_csv_dups_cols2r‚   )i'  iPÃ  é † c                 C   sŒ   t dtdƒiƒ}|jd |d< |jd |d< |jd |d< t ¡ �6}|j||d	� t|d
d�}t ||¡ W d   ƒ n1 s~0    Y  d S )Nr   r2  ç      ð?r   g       @r|   g      @rÊ   r—   r   r^   )r   r6   r   r+   r,   r0   r   r2   )r   r‚   rñ   r,  rY   r   r   r   Útest_to_csv_chunking:  s    
z'TestDataFrameToCSV.test_to_csv_chunkingc              	   C   s°   d}t tj d¡ d|d f¡d d d�}t ¡ �`}| ¡ �,}| d|¡ |j	|ddd� W d   ƒ n1 sl0    Y  t
|d d	�}W d   ƒ n1 s–0    Y  t ||¡ d S )
Nr�   r(   r$   r±   rÖ   z/pandas.io.formats.csvs._DEFAULT_CHUNKSIZE_CELLSF)r   r    r   )r   r-   rO   rP   rQ   r+   r,   ÚcontextÚsetattrr0   r   r2   )r   Zmonkeypatchr‚   rW   r,  ÚmrY   r   r   r   Ú!test_to_csv_wide_frame_formattingF  s    ý

.*z4TestDataFrameToCSV.test_to_csv_wide_frame_formattingc                 C   s~   t dƒ}| j|d d�}td||jd  iƒ}t ¡ �6}| |¡ t|dd�}tj||dd� W d   ƒ n1 sp0    Y  d S )Nza,1.0
b,2.0r   Útr   r^   FrH   )r   r   r   r   r+   r,   r0   r2   )r   Úf1rW   Znewdfr   r;   r   r   r   Útest_to_csv_bugV  s    

z"TestDataFrameToCSV.test_to_csv_bugc                 C   sŽ   t dg d¢iƒ}t ¡ �b}|j|dd� t|ddd�}t ||¡ |j|ddd� t|d dd�}t ||¡ W d   ƒ n1 s€0    Y  d S )	Nu   c/Ïƒræ   úUTF-8r  r   ©r   rœ   F©rœ   r    r  r  r   r   r   Útest_to_csv_unicodeb  s    
z&TestDataFrameToCSV.test_to_csv_unicodec                 C   s`   t dƒ}tg d¢g d¢gg d¢ddgd�}|j|dd	� | d
¡ t|d
dd�}t ||¡ d S )NÚ )õ   ×�Zd2Zd3Zd4)Za1Za2Úa3Za4)rA  õ   ×‘u   ×’u   ×“rA  rC  rÖ   r<  r  r   r=  )r   r   r0   Úseekr   r+   r2   )r   ÚbufrW   rh   r   r   r   Útest_to_csv_unicode_index_colm  s    ý
z0TestDataFrameToCSV.test_to_csv_unicode_index_colc                 C   s6   t ƒ }| |¡ | d¡ t|dd�}t ||¡ d S )Nr   r^   )r   r0   rD  r   r+   r2   )r   r9   rE  r;   r   r   r   Útest_to_csv_stringio{  s
    

z'TestDataFrameToCSV.test_to_csv_stringioc                 C   s–   t g d¢g d¢gddgg d¢d�}t ¡ �X}|j|dd� t|d	d
�}t g d¢g d¢gddgg d¢d�}t ||¡ W d   ƒ n1 sˆ0    Y  d S )N©g¿¶~úÏš¿?g9DÜœJÎ?g>éD‚)â?©gÜ.4×i¤(@ç33333þ@çÍÌÌÌ¤œAr   r   ©rJ   rK   rL   rE   z%.2f)Úfloat_formatr   r^   )g¸…ëQ¸¾?gq=
×£pÍ?g=
×£p=â?)g¤p=
×£(@rJ  rK  r  )r   rW   r,  rY   rZ   r   r   r   Útest_to_csv_float_format‚  s    ý
ýz+TestDataFrameToCSV.test_to_csv_float_formatc                 C   sF   t dddgiƒ}|jddd„ dd�}g d	¢}t |¡}||ksBJ ‚d S )
Nr@   rÞ   r3  r  c                 S   s   t j| dd�S )Nú-)Ztrim)r-   Zformat_float_positionalrŸ   r   r   r   r{   ™  re   zJTestDataFrameToCSV.test_to_csv_float_format_over_decimal.<locals>.<lambda>F)ÚdecimalrM  r    )r@   z0.5Ú1)r   r0   r+   Úconvert_rows_list_to_csv_str©r   rW   rX   Úexpected_rowsrÂ   r   r   r   Ú%test_to_csv_float_format_over_decimal”  s    ý
z8TestDataFrameToCSV.test_to_csv_float_format_over_decimalc                 C   sZ   t g d¢g d¢dœƒ}tƒ }|j|dtjdd� | ¡ }g d¢}t |¡}||ksVJ ‚d S )Nræ   )rý   r   r  r  Fr  )r    Úquotingrœ   )z"A","B"z1,"foo"z2,"bar"z3,"baz")r   r   r0   ÚcsvÚQUOTE_NONNUMERICÚgetvaluer+   rR  )r   rW   rE  rX   rT  rÂ   r   r   r   Ú!test_to_csv_unicodewriter_quoting   s    
z4TestDataFrameToCSV.test_to_csv_unicodewriter_quotingrœ   r  c                 C   sT   t dddgiƒ}tƒ }|j|tj|dd� | ¡ }g d¢}t |¡}||ksPJ ‚d S )Nr   Úhelloú	{"hello"}F)rV  rœ   r    )r   r[  r\  )r   r   r0   rW  Ú
QUOTE_NONErY  r+   rR  )r   rœ   rW   rE  rX   rT  rÂ   r   r   r   Útest_to_csv_quote_none«  s    
z)TestDataFrameToCSV.test_to_csv_quote_nonec                 C   sX   t g d¢g d¢dœg d¢d�}tƒ }|j|dd� g d¢}t |¡}| ¡ |ksTJ ‚d S )	Nræ   rç   r  ©ÚoneÚtwoÚthreer   Fr"   )zA,Bzone,1,4ztwo,2,5z	three,3,6)r   r   r0   r+   rR  rY  )r   rW   rE  rT  rÂ   r   r   r   Ú"test_to_csv_index_no_leading_comma·  s    
z5TestDataFrameToCSV.test_to_csv_index_no_leading_commac              	   C   s°  t g d¢g d¢dœg d¢d�}t ¡ �^}|j|dd� d}t|d	d
�� }| ¡ |ksXJ ‚W d   ƒ n1 sl0    Y  W d   ƒ n1 sŠ0    Y  t ¡ �^}|j|dd� d}t|d	d
�� }| ¡ |ksÎJ ‚W d   ƒ n1 sâ0    Y  W d   ƒ n1 �s0    Y  t ¡ �†}| |¡ tj d¡}d| d | d | d | }t|d	d
��"}| ¡ |k�slJ ‚W d   ƒ n1 �s‚0    Y  W d   ƒ n1 �s¢0    Y  d S )Nræ   rç   r  r_  r   ú
©Úlineterminators#   ,A,B
one,1,4
two,2,5
three,3,6
Úrb)r]   Ú
s   ,A,B
one,1,4
two,2,5
three,3,6
r  s   ,A,Bs   one,1,4s   two,2,5s	   three,3,6)	r   r+   r,   r0   r  ÚreadÚosÚlinesepÚencode)r   rW   r   rÂ   r¡   Z
os_linesepr   r   r   Útest_to_csv_lineterminatorsÁ  s@    
L
N

ÿþýüûúùÿz.TestDataFrameToCSV.test_to_csv_lineterminatorsc                 C   sª   t t g d¢¡ƒ}t g d¢ƒ}tƒ }|j|dd� tƒ }|j|dd� | ¡ | ¡ ksZJ ‚td|iƒ}td|iƒ}tƒ }| |¡ tƒ }| |¡ | ¡ | ¡ ks¦J ‚d S )N)r@   rA   rA   r@   r@   rx   rx   rx   Fr   r“   )r   rf   ZCategoricalr   r0   rY  r   )r   r“   r*   Úresr  rW   rh   r   r   r   Ú test_to_csv_from_csv_categoricalç  s    

z3TestDataFrameToCSV.test_to_csv_from_csv_categoricalc                 C   s:   |j d d�}t|tƒsJ ‚tt|ƒdd�}t ||¡ d S )N)Zpath_or_bufr   r^   )r0   r‰   r�   r   r   r+   r2   )r   r9   Zcsv_strr;   r   r   r   Útest_to_csv_path_is_noneÿ  s    z+TestDataFrameToCSV.test_to_csv_path_is_nonezdf,encodingrH  rI  r   r   rL  rE   )r  ÚdefZghir   Úasciir   )é{   u   ä½ å¥½u   ä¸–ç•ŒÚgb2312)rs  u   Î“ÎµÎ¹Î¬ ÏƒÎ¿Ï…u
   ÎšÏŒÏƒÎ¼ÎµZcp737c           
   
   C   sd  t  ¡ ��D}|j|||d� t||d|d�}t  ||¡ t|d||d��,}|j|j|d� |jjrfJ ‚W d   ƒ n1 sz0    Y  t|||dd� d¡}t  ||¡ t  	||¡�:}| 
¡  |pÂd¡}|jD ]}	|	|v sÌJ ‚qÌW d   ƒ n1 sò0    Y  t  	||¡�&}t  |t|d|d	�¡ W d   ƒ n1 �s60    Y  W d   ƒ n1 �sV0    Y  d S )
N)Úcompressionrœ   r   )ru  r   rœ   Úwr  )ru  rœ   r   r   r›   r=  )r+   r,   r0   r   r2   r   ÚhandleÚclosedZsqueezeÚdecompress_fileri  rž   r   )
r   rW   rœ   ru  r,  rX   ZhandlesÚfhÚtextÚcolr   r   r   Útest_to_csv_compression  s6    ÿÿ*üû
,z*TestDataFrameToCSV.test_to_csv_compressionc           
      C   sz  t  d¡��X}|j}t|| d¡dœ|d�}|j|dd� t|dd�}| d	d
„ ¡}|j dd
„ ¡|_t  ||¡ |j|dd� t|dd�}| dd
„ ¡}|j dd
„ ¡|_t  ||¡ |j	}|j|dd� t|dd�}| dd
„ ¡}|j
 dd
„ ¡|_
t  ||¡ tdgd g d¢ ƒ}td|i|d�}	|	j|dd� t|ddgdd�}t  ||	¡ W d   ƒ n1 �sl0    Y  d S )NZ__tmp_to_csv_date_format__r$   r  r   ú%Y%m%d©Údate_formatr   r^   c                 S   s   t |  d¡ƒS ©Nr~  ©r`   ÚstrftimerŸ   r   r   r   r{   K  re   z<TestDataFrameToCSV.test_to_csv_date_format.<locals>.<lambda>c                 S   s   t |  d¡ƒS r�  r‚  rŸ   r   r   r   r{   M  re   ú%Y-%m-%dc                 S   s
   |   d¡S ©Nr„  ©rƒ  rŸ   r   r   r   r{   V  re   c                 S   s
   |   d¡S r…  r†  rŸ   r   r   r   r{   X  re   c                 S   s   t |  d¡ƒS r�  r‚  rŸ   r   r   r   r{   d  re   c                 S   s
   |   d¡S r�  r†  rŸ   r   r   r   r{   h  re   r   r±   )ú
2000-01-01r‡  r‡  r   )r!   r   )r+   r,   r    r   Úshiftr0   r   r©   r2   ÚTr   r   )
r   r:   r   ro   rô   Zdatetime_frame_intZdatetime_frame_strZdatetime_frame_columnsZ	nat_indexZ	nat_framer   r   r   Útest_to_csv_date_format@  sH    ÿÿÿÿÿÿz*TestDataFrameToCSV.test_to_csv_date_formatÚtdr   Z10sc                 C   s´   t  d¡�–}tdddddd�}|| }| d ¡}tjtt|ƒƒdd	�}td
|i|d�}|j	|dd� t
|dd�}t|jdd� d¡|_t  ||¡ W d   ƒ n1 s¦0    Y  d S )NÚcsv_date_format_with_dstz2013-10-26 23:00z2013-10-27 01:00zEurope/Londonrà   Zinfer)rw   r�   Z	ambiguousr8   r&   r   r   Tr   r^   ©Úutc)r+   r,   r
   r1   r-   r¨   r6   r3   r   r0   r   r   r    rv   r2   )r   r‹  r   Útimesrl   Z
time_rangerW   rX   r   r   r   Ú test_to_csv_with_dst_transitionsx  s$    û
ÿz3TestDataFrameToCSV.test_to_csv_with_dst_transitionsc                 C   s  t ddddd�}| d ¡}d |j_td|dœ|d�}t d	¡�f}|j|d
d� t|dd�}t	|j
d
d� d¡|_
t	|d d
d� d¡|d< t ||¡ W d   ƒ n1 sª0    Y  | t¡ t d	¡�0}| |¡ t |¡}t ||¡ W d   ƒ n1 sþ0    Y  d S )Nz
2015-01-01z
2015-12-31rà   zEurope/Paris)r�   rw   r$   )r5   Úidxr   rŒ  Tr   r^   r�  r‘  zdatetime64[ns, Europe/Paris])r
   r1   Ú_dataZ_freqr   r+   r,   r0   r   r   r    rv   r  r2   r�   Z	to_picklerf   Zread_pickle)r   r‘  rW   r   rX   r   r   r   Ú,test_to_csv_with_dst_transitions_with_pickle�  s&    
ÿÿ*


z?TestDataFrameToCSV.test_to_csv_with_dst_transitions_with_picklec           	      C   sj  t ddgddgdtjgddgdœƒ}g d	¢}t |¡}| ¡ }||ksJJ ‚|jd d
�}||ksbJ ‚g d	¢}t |¡}|jtjd
�}||ksŽJ ‚g d¢}t |¡}|jtjd
�}||ksºJ ‚g d¢}t |¡}|jtj	d
�}||ksæJ ‚d}t
jtj|d�� |jtjd
� W d   ƒ n1 �s 0    Y  t
jtj|d��  |jtjd d� W d   ƒ n1 �sb0    Y  g d¢}t |¡}|jtjdd�}||k�sœJ ‚g d¢}t |¡}|jtjdd�}||k�sÌJ ‚ddg}t |¡}tt|ƒƒ}tƒ }|j|ddd� | ¡ |k�sJ ‚t ddgddgddgdœƒ}| ddg¡}g d ¢}t |¡}|jtjd
�|k�sfJ ‚d S )!NTFr3  gš™™™™™	@é*   r@   zb,c)Zc_boolZc_floatZc_intZc_string)ú,c_bool,c_float,c_int,c_stringú0,True,1.0,42.0,az1,False,3.2,,"b,c")rV  )ú("","c_bool","c_float","c_int","c_string"z"0","True","1.0","42.0","a"z"1","False","3.2","","b,c")r—  z0,True,1.0,42.0,"a"z1,False,3.2,"","b,c"z%need to escape, but no escapechar setrM   )rV  Ú
escapechar)r•  r–  z1,False,3.2,,b!,cú!)z,c_bool,c_ffloat,c_int,c_stringr–  z1,False,3.2,,bf,cr¡   za,b,cz1,"test 
",3r  r>  r$   r(   r%   r½   r   rè   rð   rA   )z"a","b","c"z"1","3","5"z"2","4","6")r   r-   r.   r+   rR  r0   rW  ÚQUOTE_MINIMALÚ	QUOTE_ALLrX  rT   rU   ÚErrorr]  r   r   rY  Z	set_index)	r   rW   rT  rÂ   rX   r[   Z	text_rowsr{  rE  r   r   r   Útest_to_csv_quoting©  sb    üÿ	



.0



z&TestDataFrameToCSV.test_to_csv_quotingc                 C   sÌ   g d¢}t j|dd�}tg d¢|d�}| ¡ }g d¢}t |¡}||ksLJ ‚d}|j|d�}g d	¢}t |¡}||kszJ ‚d
tdg}t j|dd�}tg d¢|d�}| ¡ }g d¢}t |¡}||ksÈJ ‚d S )N)ú
1990-01-01r‡  ú
3005-01-01rÊ   )r�   rç   r   )ú,0ú1990-01-01,4z2000-01-01,5ú3005-01-01,6z%m-%d-%Yr  )r   z01-01-1990,4z01-01-2000,5z01-01-3005,6rž  rŸ  )r   r¡  z,5r¢  )rf   ZPeriodIndexr   r0   r+   rR  r   )r   Údatesr    rW   rX   rT  rÂ   r€  r   r   r   Útest_period_index_date_overflow  s&    



z2TestDataFrameToCSV.test_period_index_date_overflowc                 C   s^   t  g d¢¡}tg d¢g d¢gƒ}||_g d¢}|j|d�}g d¢}t |¡}||ksZJ ‚d S )N))r@   r$   )r@   r(   )rA   r$   )rA   r(   rÅ   )r   rè   rë   rì   )r@   rA   rx   Údr   )z,a,b,c,dz	0,1,2,3,4z	1,5,6,7,8)r   rR   r   r   r0   r+   rR  )r   r   rW   r   rX   rT  rÂ   r   r   r   Útest_multi_index_header*  s    
z*TestDataFrameToCSV.test_multi_index_headerc                 C   sN   t g d¢ƒ}tg d¢g|d�}|jddgd�}d}|jdd�}t ||¡ d S )	N)©r$   )r(   ©r%   ræ   r   r§  r¨  z,1,3
0,1,3
rh  re  )r   r   Zreindexr0   r+   r4   )r   r    rW   rÂ   rX   r   r   r   Ú$test_to_csv_single_level_multi_index7  s    z7TestDataFrameToCSV.test_to_csv_single_level_multi_indexc              	   C   s¦   t dddgiƒ}g d¢}t |¡}t d¡�Z}|j|dd� tj|dd	��}| ¡  d
¡}W d   ƒ n1 sn0    Y  W d   ƒ n1 sŒ0    Y  ||ks¢J ‚d S )Nr@   r$   r(   )r@   rQ  Ú2z__test_gz_lineend.csv.gzFr   Úgzip)ru  r  )r   r+   rR  r,   r0   ry  ri  rž   )r   rW   rT  rÂ   r   r¡   rX   r   r   r   Útest_gz_lineend@  s    
Jz"TestDataFrameToCSV.test_gz_lineendc                 C   s<   t dtddd�iƒ}tƒ }| |¡ | ¡ }d|v s8J ‚d S )Nr@   z1/1/2000r±   r¿   r‡  )r   r
   r   r0   rY  )r   r
  rE  rX   r   r   r   Útest_to_csv_numpy_16_bugL  s
    
z+TestDataFrameToCSV.test_to_csv_numpy_16_bugc                 C   s6   t d d gƒjd dddd� dd¡}d}||ks2J ‚d S )NFr@  )r   r    r  rd  rh  z""
""
)r   r0   Úreplace)r   rX   rÂ   r   r   r   Útest_to_csv_na_quotingU  s    ÿþÿz)TestDataFrameToCSV.test_to_csv_na_quotingc                 C   sb   t ddtjgdœƒ}|d  d¡|d< |d  d¡|d< | ¡ }g d¢}t |¡}||ks^J ‚d S )NrB   r$   r–   rA   ZInt16Úcategory)z,a,bz0,x,1z1,x,)r   rf   ZNAr  r0   r+   rR  rS  r   r   r   Útest_to_csv_categorical_and_ea`  s    
z1TestDataFrameToCSV.test_to_csv_categorical_and_eac                 C   s^   t dtjtdƒtdƒdd�giƒ}|d  d¡|d< | ¡ }ddg}t |¡}||ksZJ ‚d S )	Nr@   r¾   z
2020-01-02Zboth)rx  r°  z,az.0,"[2020-01-01 00:00:00, 2020-01-02 00:00:00]")r   rf   ZIntervalr	   r  r0   r+   rR  rS  r   r   r   Ú$test_to_csv_categorical_and_intervalj  s    ýÿÿÿ
z7TestDataFrameToCSV.test_to_csv_categorical_and_interval)NNNNF)CÚ__name__Ú
__module__Ú__qualname__r   r=   r\   ri   rt   r~   rˆ   rT   ÚmarkZparametrizer‹   Zslowrš   r¯   rÃ   ÚfilterwarningsrË   rÍ   rÏ   rÐ   r×   rÜ   râ   rå   rï   rõ   rö   r  r  r  r  r-  r/  r1  r4  r8  r;  r?  rF  rG  rN  rU  rZ  r^  rc  rm  ro  rp  r   r}  rŠ  rf   rr   r�  r“  r�  r¤  r¦  r©  r¬  r­  r¯  r±  r²  r   r   r   r   r      sò   &$
$
     ø
iÿ	ÿÿ
ÿ	

ÿýþ 	0)



&	ýú	þûôþ
!8
b		
r   )rW  Úior   rj  Únumpyr-   rT   Zpandas.errorsr   Zpandasrf   r   r   r   r   r   r	   r
   r   r   r   Zpandas._testingZ_testingr+   Zpandas.core.commonÚcoreÚcommonr  Zpandas.io.commonr   r   r   r   r   r   Ú<module>   s   0