+
    xȇiG                         ^ RI t ^ RIHt ^ RIt^ RIt^ RIt^ RIHt ^ RI	t
^ RI	HtHtHtHtHtHtHtHtHtHt ^ RIHt ^ RIHu Ht ^ RIHt  ! R R4      tR# )    N)StringIO)ParserError)
	DataFrameIndex
MultiIndexNaTSeries	Timestamp
date_rangeperiod_rangeread_csvto_datetime)
get_handlec                     a  ] tR t^t o R tR tR tR tR tR t	R t
R tR	 t]P                  P                  R
RRR..4      R 4       t]P                  P"                  R 4       tR`R lt]P                  P"                  ]P                  P                  R. RaO4      R 4       4       t]P                  P"                  ]P                  P                  R. RaO4      ]P                  P                  R. RbO4      ]P                  P                  R. RcO4      ]P                  P+                  R4      R 4       4       4       4       4       t]P                  P"                  ]P                  P                  R. RdO4      ]P                  P                  R. RcO4      R 4       4       4       t]P                  P"                  ]P                  P                  R. ReO4      R 4       4       t]P                  P"                  R 4       t]P                  P"                  R 4       t]P                  P"                  ]P                  P                  R. RaO4      ]P                  P                  R. RfO4      ]P                  P                  RR^/R^/.R^/R^/.R^R^/R^R^/..4      R  4       4       4       4       tR! tR" tR# tR$ tR% t R& t!R' t"R( t#R) t$R* t%R+ t&R, t']P                  P                  R-. RgO4      R. 4       t(]P                  P"                  R/ 4       t)R0 t*R1 t+R2 t,R3 t-R4 t.R5 t/R6 t0]P                  P                  R7RR8.4      R9 4       t1R: t2R; t3R< t4R= t5R> t6R? t7]P                  P                  R@]8! . RhO. RiO.RARB.. RjORC7      R3]8! . RkO.. RjORD7      RE3]8! ^. RlO.,          . RjORD7      RF3]8! ^. RmO.,          . RjORD7      RG3.4      RH 4       t9RI t:]P                  P                  RJ];Px                  ! ^ 4      P{                  RK4      ];Px                  ! RL4      .4      RM 4       t>]P                  P                  RNRORP.RQRR..4      RS 4       t?RT t@RU tARV tBRW tCRX tDRY tERZ tFR[ tGR\ tHR] tIR^ tJR_tKV tLR# )nTestDataFrameToCSVc                F    R ^ /pVP                   ! R/ VB  \        V3/ VB # )	index_col )updater   )selfpathkwargsparamss   &&, v/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/frame/methods/test_to_csv.pyr   TestDataFrameToCSV.read_csv   s+    q!'''    c                $   \        V4      p\        P                  VP                  R VP                  P                  R4      3&   VP                  V4       VP                  VRR.R7       VP                  VRR7       VP                  VRR7       R# ):N   NABcolumnsFheaderindexN)strnpnanilocr"   get_locto_csv)r   	temp_filefloat_framer   s   &&& r   test_to_csv_from_csv1(TestDataFrameToCSV.test_to_csv_from_csv1$   s    9~AC[0088==>4 4#s44.4u-r   c                   \        V4      pVP                  P                  R 4      Vn        VP                  V4       V P	                  VRR7      pVP                  4       pVP                  P                  R4      Vn        \        P                  ! WT4       VP                  VRR7       V P	                  VR RR7      p\        VP                  4      \        VP                  4      ^,           8X  g   Q hVP                  VRR7       V P	                  VR RR7      p\        P                  ! VP                  VP                  4       R # )	NT)parse_datesusr&   index_labelr   r2   Fr%   )r'   r&   
_with_freqr,   r   copyas_unittmassert_frame_equallenr"   assert_almost_equalvalues)r   r-   datetime_framer   reconsexpecteds   &&&   r   test_to_csv_from_csv1_datetime1TestDataFrameToCSV.test_to_csv_from_csv1_datetime-   s	   9~  .33>>tDd#t6!&&(!//5
h/d8ttF6>>"c.*@*@&AA&EEEE 	d%0ttF
~44fmmDr   c                   \        V4      p\        R \        \        ^4      \        P
                  ! ^\        P                  R7      R7      R\        \        ^4      \        P
                  ! ^\        P                  R7      R7      /4      pVP                  V4       V P                  V4      p\        P                  ! W44       R# )s1dtyper%   s2N)r'   r   r	   ranger(   arangeint64r,   r   r:   r;   )r   r-   r   dmr@   s   &&   r   !test_to_csv_from_csv1_corner_case4TestDataFrameToCSV.test_to_csv_from_csv1_corner_caseB   s    9~fU1XRYYq-IJfU1XRYYq-IJ
 			$t$
b)r   c                   \        V4      p\        \        P                  P	                  ^4      P                  R4      . RO. ROR7      pVP                  V4       V P                  V4      p\        P                  ! WT4       \        P                  ! . RO4      p\        \        P                  P	                  ^4      P                  R4      V. ROR7      pVP                  V4       V P                  V. RORR7      p\        P                  ! WTRR7       \        . RO4      pVP                  W7R7       V P                  V4      pVP                  4       p	Wyn        \        P                  ! W4       Rp
\        P                   ! \"        V
R	7      ;_uu_ 4        VP                  VRR.R7       R
R
R
4       R
#   + '       g   i     R
# ; i)   r&   r"   Fr6   check_namesAAXr#   z Writing 4 cols but got 2 aliasesmatchN   rY   ar[   b)xyz)r      rP   r`   )r    ra   rP   r   ra   rP   )rT   rU   YZ)r'   r   r(   randomdefault_rngstandard_normalr,   r   r:   r;   r   from_tuplesr   r8   r"   pytestraises
ValueError)r   r-   r.   r   dfresultmidxcol_aliasesrsxpmsgs   &&&        r   test_to_csv_from_csv2(TestDataFrameToCSV.test_to_csv_from_csv2O   sY   9~II!!!$44V<!#

 			$t$
f)%%&MNII!!!$44V<#
 			$tyeL
fe< 1244]]4  

b%0]]:S11tT3K8 2111s   F77G	c                r   \        V4      p\        \        P                  P	                  ^4      P                  R4      4      p\        \        P                  P	                  ^4      P                  R4      4      pVP                  V4       VP                  VRRR7       \        P                  ! W4.4      p\        V^ R7      pVP                   Uu. uF  p\        V4      NK  	  upVn
        VP                   Uu. uF  p\        V4      NK  	  upVn
        \        P                  ! WV4       R# u upi u upi )rP   r[   F)moder$   r   N)rY   ra   )r'   r   r(   re   rf   rg   r,   pdconcatr   r"   intr:   r;   )r   r-   r   df1df2rq   rp   labels   &&      r   test_to_csv_from_csv3(TestDataFrameToCSV.test_to_csv_from_csv3s   s    9~		--a0@@HI		--a0@@HI

4

4c%
0YYz"da(.0jj9jUc%jj9
.0jj9jUc%jj9

b% :9s   D/;D4c           
     "   \        V4      p\        P                  ! ^R7      P                  R4      p\	        R\        ^4       Uu. uF  qDV,          NK  	  up/\        \        ^4       Uu. uF  qDV,          NK  	  upRR7      R7      pVP                  V4       \        VRR7      p\        P                  ! VP                  4      Vn
        \        P                  ! VR,          4      VR&   \        P                  ! WVRR	7       R
# u upi u upi )ra   )secondsr3   dt_datadt_indexnamer%   rw   T)check_index_typeN)r'   rx   	Timedeltar9   r   rI   r   r,   r   to_timedeltar&   r:   r;   )r   r-   r   dtirl   rm   s   &&     r   test_to_csv_from_csv4(TestDataFrameToCSV.test_to_csv_from_csv4   s    9~\\!$,,T2q2AR23q2AR2D
 			$$*5v||4OOF9,=>y
b4@ 32s   D
+Dc                  aa \        V4      pSP                  V4       \        V^ R.R7      oVV3R lpV! R4      SR&   V! R4      SR&   SR,          P                  P	                  R4      SR&   \
        P                  ! SS4       R# )r   r   r6   c                    < \        SV ,          4      P                  P                  R 4      P                  P                  SV ,          P                  P                  4      P                  P	                  R4      # )UTCns)r   r   
tz_converttzr9   )crm   timezone_frames   &r   <lambda>:TestDataFrameToCSV.test_to_csv_from_csv5.<locals>.<lambda>   sM    k&),R

5!R

>!,//223Rr   r    Cr   N)r'   r,   r   r   r9   r:   r;   )r   r-   r   r   	converterrm   s   &&f  @r   test_to_csv_from_csv5(TestDataFrameToCSV.test_to_csv_from_csv5   s|    9~d#$!#? 	  nsnsSknn,,T2s
fn5r   c                   ^p\        VR,          4      p\        \        P                  ! V^34      \	        \        V4       Uu. uF  pRV 2NK
  	  upRR7      \	        \        ^4       Uu. uF  pRV 2NK
  	  upRR7      R7      pVP                  pV^,          V^ ,          .p\        V4      pVP                  WVR7       \        V^ R7      p	\        P                  ! WW,          V	RR	7       R
# u upi u upi )r         @i-r[   r   rQ   r"   	chunksizerw   FrR   N)rz   r   r(   onesr   rI   r"   r'   r,   r   r:   r;   )
r   r-   r   Nr   rl   cscolsr   rs_cs
   &&        r   test_to_csv_cols_reordering.TestDataFrameToCSV.test_to_csv_cols_reordering   s    		C GGQFO5848a2aS843?U1X6XRs8X6SA

 ZZ1r!u~9~
		$		:*
bh%@ 56s   C1+C6r   Nr\   r[   c           
        ^p\        VR,          4      p\        \        P                  ! V^34      \	        \        V4       Uu. uF  pRV 2NK
  	  upRR7      . ROR7      p\        V4      pVP                  WrVR7       \        V^ R7      pVe   VP                  P                  '       d   W(n	        M=VP                  P                  V4      w  rVP                  P                  V	4      Vn	        V FY  pWk,          pW,          p\        V\        4      '       d   \        P                   ! W4       KA  \        P"                  ! WR	R
7       K[  	  R# VP                  Vn	        \        P"                  ! WhR	R
7       R# u upi )r   r   r   r[   r   rQ   r   rw   NFrR   rZ   )rz   r   r(   r   r   rI   r'   r,   r   r"   	is_uniqueget_indexer_non_uniquetake
isinstancer	   r:   assert_series_equalr;   )r   r-   r   r   r   r   rl   r   r   indexermissingr   obj_dfobj_rss   &&&           r   test_to_csv_new_dupe_cols,TestDataFrameToCSV.test_to_csv_new_dupe_cols   s*   		C  GGQFO5848a2aS843?#

 9~
		$		:* zz#####%::#D#DT#J !zzw7ff--**6:))&eL  ::DL!!">7 5s   E=c                   R
R lpRpV! V^,           4      pV! V^,           ^ 4      p\        V4      p\        RVRV/4      pVP                  WcR7       V P                  V4      P	                  \
        4      pVR,          p	V	R,          P                  R4      V	R&   V	R,          P                  R4      V	R&   \        P                  ! WRR	7       R # )Nc                 ~   Vf   \        V R,          4      p\        \        RRV R7      4      pV'       d   \        P                  P                  ^4      P                  ^ \        V4      V4       F  p\        W#&   K  	  \        P                  P                  ^4      P                  ^d4      p\        W#) &   \        W#&   V# )Ng?20005min)freqperiods)	rz   listr   r(   re   rf   integersr<   r   )nnnatsr   s   &&  r   make_dtnat_arr<TestDataFrameToCSV.test_to_csv_dtnat.<locals>.make_dtnat_arr   s    |1s7|ZVQ?@A..q1::1c!fdKAAD LII))!,55c:"Hr     r[   r\   r   NNNM8[us]FrR   N)	r'   r   r,   r   applyr   astyper:   r;   )
r   r-   r   r   rE   rH   r   rl   rm   rA   s
   &&        r   test_to_csv_dtnat$TestDataFrameToCSV.test_to_csv_dtnat   s    
	 	IM*IM1-9~Rb)*
		$	,t$**;7a5 ,,X6 ,,X6
fEBr   c	                   R R/p	V'       d[   Ve   \        \        V4      4      V	R&   \        \        V4      4      V	R&   VP                  VRVR7       V P                  ! V3/ V	B p
M,^ V	R&   VP                  VRVR7       V P                  ! V3/ V	B p
R pV'       d   VP                  V
n        V'       d   V'       g   \        V^,
          4       Uu. uF!  qP
                  RV3,          P                  NK#  	  pp\        P                  ! \        V
P                  4      .VO4      pWn	        V
P
                  RV^,
          R13,          p
R	R	R
R
RRRRRRRR/pV'       Ed   VR8X  d   Rp\        P                  ! V
P                   Uu. uF  pV! V4      NK  	  upVR7      V
n	        \        P                  ! VP                   Uu. uF  pV! V4      NK  	  upVR7      Vn	        EMVR8X  d   Rp\        P                  ! V
P                   Uu. uF  p\        V4      NK  	  upVR7      V
n	        \        P                  ! VP                   Uu. uF  p\        V4      NK  	  upVR7      Vn	        EM VR8X  d   Rp\        V
P                  4      p\        P                  ! V Uu. uF  p\        V4      NK  	  upVR7      V
n	        \        P                  ! \        \        \        VP                  P                  4       4      4      VR7      Vn	        M_VP!                  V4      p\        P                  ! V
P                  VR7      V
n	        \        P                  ! VP                  VR7      Vn	        V'       Ed   VR8X  d   Rp\        P                  ! V
P                   Uu. uF  pV! V4      NK  	  upVR7      V
n        \        P                  ! VP                   Uu. uF  pV! V4      NK  	  upVR7      Vn        W3# VR8X  d   Rp\        P                  ! V
P                   Uu. uF  p\        V4      NK  	  upVR7      V
n        \        P                  ! VP                   Uu. uF  p\        V4      NK  	  upVR7      Vn        W3# VR8X  d   Rp\        V
P                  4      p\        P                  ! V Uu. uF  p\        V4      NK  	  upVR7      V
n        VP                  P                  4       p\        P                  ! V Uu. uF  p\        V4      NK  	  upVR7      Vn        W3# VP!                  V4      p\        P                  ! V
P                  VR7      V
n        \        P                  ! VP                  VR7      Vn        W3# u upi u upi u upi u upi u upi u upi u upi u upi u upi u upi u upi u upi )r2   FNr   r$   utf8)encodingr   c                 T    \        V \        4      '       g   V P                  R 4      # V # )r   )r   r'   decoder]   s   &r   _to_uni;TestDataFrameToCSV._return_result_expected.<locals>._to_uni  s#    a%%xx''Hr   r   r   fr   Our   prF   )r   rI   r,   r   r"   r*   r>   r   from_arraysr&   r(   arrayr
   r   mapto_timestampget)r   rl   r   r-   r_dtypec_dtypernlvlcnlvldupe_colr   r@   r   r   	delta_lvlixtype_mapr}   idx_listcol_lists   &&&&&&&&&          r   _return_result_expected*TestDataFrameToCSV._return_result_expected   s     ' &*5<&8{##E%L1F8IIi&IIF]]977F F8IIi&IIF]]977F	
   ZZFN;@;KL;KaQT*11;KIL''fll);(Hi(HIBL[[EAIK0Fc3S#sD#sCP7#~!xx17>WU^>g  8813:WU^:' D!xx39<<@<%Yu%<@  883588<8%Yu%8<G C&v||4!xx3;<8%Yu%8<G  88Y(=(=(?@A #,,w/!xxGD88BHHG<7#~!#17@WU^@"  XX13<WU^<G
2 z- D!#39>>B>%Yu%>B'"  XX35::>:%Yu%:>g
" z C&v~~6!#3;<8%Yu%8<G" ::224XX3;<8%Yu%8<G
 z #,,w/!#&..!HXXbjj@
zG M ? ;
 A = = A =
 C ? = =sH   'V
VV!V&V+%V0#V5 V:)V?)W W	Wnrowsc           	     2   \        \        P                  ! V^34      \        RVR7      \	        \        R4      \        R7      R7      pV P                  VRVRR4      w  rEVP                  P                  R	4      Vn        \        P                  ! WER
R7       R# )   
2020-01-01r   abcdrF   rQ   r   r   r   r   FrR   N)r   r(   r   r   r   r   objectr   r&   r   r:   r;   )r   r   r-   rl   rm   rA   s   &&&   r   test_to_csv_nrows$TestDataFrameToCSV.test_to_csv_nrows_  sz    
 GGUAJ\59$v,f5

  77D)TSVW!..x8
fEBr   zr_idx_type, c_idx_typencolsz3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc                2   R R RR RR RR /p\        \        P                  ! W34      Wb,          ! V4      Wc,          ! V4      R7      pV P                  VR	VVV4      w  rVR8X  d"   V	P                  P                  R
4      V	n        M'VR8X  d!   V	P                  P                  R
4      V	n        VR8X  d"   V	P                  P                  R
4      V	n        M'VR8X  d!   V	P                  P                  R
4      V	n        \        P                  ! WRR7       R# )r   c                 `    \        \        P                  ! V 4      \        P                  R 7      # )rF   )r   r(   rJ   rK   r   s   &r   r   :TestDataFrameToCSV.test_to_csv_idx_types.<locals>.<lambda>x  s    51RXX>r   r   c           
      ~    \        \        ^a^aV ,           4       Uu. uF  q R\        V4       2NK  	  up4      # u upi )a   _)r   rI   chr)r   r   s   & r   r   r   y  s4    55R!V;L!M;LaCqQ/;L!MN!Ms   :r   c                     \        R V R7      # )r   r   )r   r   s   &r   r   r   z  s    J|Q?r   r   c                     \        R V RR7      # )r   D)r   r   )r   r   s   &r   r   r   {  s    <acJr   rQ   r   r   FrR   N)	r   r(   r   r   r&   r   r"   r:   r;   )
r   r   
r_idx_type
c_idx_typer   r-   axesrl   rm   rA   s
   &&&&&&    r   test_to_csv_idx_types(TestDataFrameToCSV.test_to_csv_idx_typesm  s    >N?J	
 GGUN#"5)$U+

  77
 %^^228<HN3%^^228<HN'//66x@H3'//66x@H
fEBr   c                V   \        \        P                  ! W34      \        \	        V4       Uu. uF  pR V 2NK
  	  upRR7      \        \	        V4       Uu. uF  pR V 2NK
  	  upRR7      R7      pV P                  VRV4      w  rg\        P                  ! WgRR7       R# u upi u upi )r   r[   r   rQ   r   FrR   N)r   r(   r   r   rI   r   r:   r;   )r   r   r   r-   r   rl   rm   rA   s   &&&&    r   test_to_csv_idx_ncols(TestDataFrameToCSV.test_to_csv_idx_ncols  s     GGUN#5<8<a2aS<8sCU5\:\Rs8\:E

  77D)L
fEB	 9:s   B!B&c                    \        \        P                  ! V^34      \        \	        V4       Uu. uF  pRV 2NK
  	  upRR7      \        \	        ^4       Uu. uF  pRV 2NK
  	  upRR7      R7      p\        VP                  4      pRR.VR&   RR.VRR% \        VP                  4      pRR.VR&   RR.VRR% Wdn        WTn        V P                  VR	VR
R7      w  rx\        P                  ! WxRR7       R# u upi u upi )rY   r   r[   r   rQ   dupe:NrP   NNrduper   T)r   FrR   )r   r(   r   r   rI   r   r"   r&   r   r:   r;   )	r   r   r-   r   rl   r   r   rm   rA   s	   &&&      r   test_to_csv_dup_cols'TestDataFrameToCSV.test_to_csv_dup_cols  s    GGUAJ5<8<a2aS<8sCU1X6XRs8X6SA
 BJJF#RV$RS	"((^7#2G$23
77i$ 8 
 	fEB 96s   C6C;c                    \        \        P                  ! ^
\        P                  R7      R7      pV P	                  VRV4      w  r4\
        P                  ! W4RR7       R# )
   rF   r%   r   F)check_column_typeN)r   r(   rJ   rK   r   r:   r;   )r   r-   rl   rm   rA   s   &&   r   test_to_csv_empty$TestDataFrameToCSV.test_to_csv_empty  sB    RYYr:;77D)L
f%Hr   c                h   R pV^,          ^,           p\        \        P                  ! V^34      \        \	        R4      4      \
        P                  ! \        ^4       Uu. uF  p\        V4      NK  	  up4      R7      pV P                  WRV^R7      w  rg\        P                  ! WgRR7       R# u upi )r   abr"   r&   )r   FrR   N)r   r(   r   r   r   r   r   rI   r   r:   r;   )r   r-   r   rowsr   rl   rm   rA   s   &&      r   test_to_csv_chunksize(TestDataFrameToCSV.test_to_csv_chunksize  s    	A~!GGT1I$t*%((uQx)Hx!%+x)HI

  779A 8 
 	fEB *Is   B/zdf_params, func_paramsr_idx_nlevelsr   c_idx_nlevelsr   c                *  aa VP                  R 4      '       d2   \        P                  ! V3R l\        VR ,          4       4       4      pMRpVP                  R4      '       d2   \        P                  ! V3R l\        VR,          4       4       4      pM'\	        \        S4       Uu. uF  pRV 2NK
  	  up4      p\        \        P                  ! SS34      WgR7      p	V P                  ! V	RV3/ VB w  r\        P                  ! WRR	7       R# u upi )
r  c              3   j   <"   T F#  p\        S4       Uu. uF  pR V 2NK
  	  upx  K%  	  R# u upi 5ir   NrI   ).0r   r   r   s   &  r   	<genexpr>8TestDataFrameToCSV.test_to_csv_params.<locals>.<genexpr>  s6      +:A $)<0<a2aS<0: 1   3.3Nr  c              3   j   <"   T F#  p\        S4       Uu. uF  pR V 2NK
  	  upx  K%  	  R# u upi 5ir  r  )r  r   r   r   s   &  r   r  r    s6      -:A $)<0<a2aS<0: 1r  r   rQ   r   FrR   )r   r   r   rI   r   r   r(   r   r   r:   r;   )r   r   	df_paramsfunc_paramsr   r-   r&   r"   r   rl   rm   rA   s   &f&&f&      r   test_to_csv_params%TestDataFrameToCSV.test_to_csv_params  s     ==))** +y9:+ E
 E==)) ,, -y9:- G
 uU|<|!r!X|<=Grwwu~.eM77i
#.
 	fEB =s   'Dc                r   \         P                  VR &   R pVP                  P                  V4      VR&   \	        V4      pVP                  V4       V P                  V4      p\        P                  ! W%4       \        P                  ! \         P                  ! V4      \         P                  ! V4      4       R# )Gc                     \         P                  \         P                  .\         P                  P	                  ^4      P                  4       R8  ,          # )rP         ?)r(   infr)   re   rf   r   s   &r   r   ETestDataFrameToCSV.test_to_csv_from_csv_w_some_infs.<locals>.<lambda>  s3    rvvrvv&ryy'<'<Q'?'F'F'H3'NOr   hN)
r(   r)   r&   r   r'   r,   r   r:   r;   isinf)r   r-   r.   r   r   r@   s   &&&   r    test_to_csv_from_csv_w_some_infs3TestDataFrameToCSV.test_to_csv_from_csv_w_some_infs  s    66CO&,,003C9~4 t$
k2
bhh{3RXXf5EFr   c                X   \         P                  VR &   \         P                  ) VR&   \        V4      pVP                  V4       V P	                  V4      p\
        P                  ! W$4       \
        P                  ! \         P                  ! V4      \         P                  ! V4      4       R# )EFN)r(   r'  r'   r,   r   r:   r;   r*  )r   r-   r.   r   r@   s   &&&  r   test_to_csv_from_csv_w_all_infs2TestDataFrameToCSV.test_to_csv_from_csv_w_all_infs  su    66CFF7C9~4 t$
k2
bhh{3RXXf5EFr   c                6   \        V4      p\        R . ROR. R	O/4      pVP                  VRR7       \        V4      p\        P
                  ! W44       \        . R
ORR7      VR&   VP                  VRR7       \        V4      p\        P
                  ! W44       R# )c1c2Fr%   rK   rF   c3Nra   rP   rY   r   r      )      	   )r'   r   r,   r   r:   r;   r	   )r   r-   r   rl   rm   s   &&   r   test_to_csv_no_index'TestDataFrameToCSV.test_to_csv_no_index  s|    9~iy9:
		$e	$$
b))734
		$e	$$
b)r   c                    \        ^ . RO^. RO/4      pRVR&   VP                  4       VP                  . ROR7      8X  g   Q hR# )r   txttestr!   N)r[   r\   r   )aabbcc)r   ra   r@  )r   r,   )r   rl   s   & r   test_to_csv_with_mix_columns/TestDataFrameToCSV.test_to_csv_with_mix_columns  s@     ?A/ABC6
yy{biii????r   c                   \        ^^.^^..RR.R7      p\        ^^.^^..RR.R7      p\        V4      pVP                  VRR.R7       V P                  V4      p\        P
                  ! W54       VP                  VRRR.R7       V P                  V4      pVP                  R	R
7      pVe   Q h\        P
                  ! W54       R# )ra   r   r    r!   rU   rc   r#   F)r&   r$   T)inplaceN)r   r'   r,   r   r:   r;   reset_index)r   r-   from_dfto_dfr   r@   return_values   &&     r   test_to_csv_headers&TestDataFrameToCSV.test_to_csv_headers  s     aVaV,sCjAAq6Aq6*S#J?9~tS#J/t$
e,t5#s<t$))$)7###
e,r   c                8   TpVP                   p\        P                  ! \        V4      ^,          \        P                  R7      P                  ^R"4      p\        P                  ! VRR.R7      pWtn         \        V4      pVP                  VRR7       VP                  VRR.R	7       VP                  V4       V P                  V^ ^.RR
7      p	\        P                  ! WIRR7       VP                   P                  V	P                   P                  8X  g   Q hWRn         Tp
V
P                   pV\        P                  ! \        V4      \        P                  R7      .p\        P                  ! V4      V
n         V
P                  VRR.R7       \        P                  ! \        RR7      ;_uu_ 4        V P                  V^ ^.RR
7      pRRR4       V
P!                  4       p\        P                  ! VP#                  R4      V^,          .4      Vn         \        P                  ! XVRR7       V
P                  V4       V P                  VRR7      p\        VP$                  4      \        V
P$                  4      ^,           8X  g   Q hV
P                  VRR7       V P                  VRR7      p\        P&                  ! VP(                  VP(                  4       WSn         R#R lp\+        \        P,                  ! R$4      \        P                  ! \/        ^4       UUu. uF!  p\/        ^4       Uu. uF  pRV 2NK
  	  upNK#  	  upp\1        R4      R7      \        P                  ! \/        ^4       UUu. uF!  p\/        ^4       Uu. uF  pRV 2NK
  	  upNK#  	  upp\1        R4      R7      R7      p	V	P                  V4       \        V. R%O^ ^.R7      p\        P                  ! V	V4       \+        \        P,                  ! R$4      \        P                  ! \/        ^4       UUu. uF!  p\/        ^4       Uu. uF  pRV 2NK
  	  upNK#  	  upp\1        R4      R7      R	7      p	V	P                  V4       \        V. R%O^ R7      p\        P                  ! V	V4       \+        \        P,                  ! R$4      \        P                  ! \/        ^4       UUu. uF!  p\/        ^4       Uu. uF  pRV 2NK
  	  upNK#  	  upp\1        R4      R7      \        P                  ! \/        ^4       UUu. uF!  p\/        ^4       Uu. uF  pRV 2NK
  	  upNK#  	  upp\1        R4      R7      R7      p	V	P                  V4       \        V. R%O. R&OR7      p\        P                  ! V	V4       V! 4       p	V	P                  VRR7       \        V^ ^.R7      p\        P                  ! V	V4       V! R4      p	V	P                  VRR7       \        V^ ^.R7      p\2        P4                  ! VP$                  P                  !  '       g   Q hV	P$                  P                  VP$                  n        \        P                  ! V	V4       V! 4       p	V	P                  V4       \        V^ ^.^ .R7      p\        P                  ! V	V4       V! R4      p	V	P                  V4       \        V^ ^.^ .R7      p\        P                  ! V	V4       V! R4      p	V	P                  V4       R' FV  pRV R2p\6        P8                  ! \:        VR7      ;_uu_ 4        \        V\1        \/        V4      4      ^ R7       RRR4       KX  	  Rp\6        P8                  ! \<        VR7      ;_uu_ 4        V	P                  VRR .R	7       RRR4       V
R!,          P                  V4       V P                  V4      pV
R!,          p. Vn         \        P>                  ! VP$                  VP$                  4       \        V4      ^ 8X  g   Q hR#   + '       g   i     ELj; iu upi u uppi u upi u uppi u upi u uppi u upi u uppi u upi u uppi   + '       g   i     EKs  ; i  + '       g   i     L; i)(rP   rF   firstsecondnamesFr#   r   r    r!   r6   rR   timefoor4   zCould not infer formatrV   TNr3   rw   r%   c                     V R J d   RR.p \        \        P                  P                  ^4      P	                  ^ ^
RR7      \
        P                  ! . ROV R7      RR7      # )	TrO  rP  )sizerQ  rK   r"   rG   rX   ))bahrT  )rX  bar)banbaz)r   r(   re   rf   r   r   rh   rQ  s   &r   _make_frame>TestDataFrameToCSV.test_to_csv_multiindex.<locals>._make_frame`  s\    } (+		%%a(11!Rf1E"..DE  r   r   r   r  r  )r$   r   abczlen of z, but only 5 lines in filez%cannot specify cols with a MultiIndexrY  :Nr   Nr   r   rY   )r   ra   rP   rY   rb   )r8  r9  ) r&   r(   rJ   r<   rK   reshaper   r   r'   r,   r   r:   r;   rR  assert_produces_warningUserWarningr8   r9   r"   r=   r>   r   r   rI   r   comall_noneri   rj   r   	TypeErrorassert_index_equal)r   r-   r.   r?   frame	old_indexarrays	new_indexr   rl   tsframer@   rA   r\  r   r   rm   rr   exps   &&&&               r   test_to_csv_multiindex)TestDataFrameToCSV.test_to_csv_multiindex-  s   KK	3y>A-RXX>FFq"M**6'89LM	9~T%(TC:. 	T]]4Aq6u]E 	eU;{{  BHHNN222 & !MM			#i. IJ	"..y9t&%9'';STT]]4Aq6t]LF U <<>#//1B1B41H)TU,0WX
fhEB 	ttt46>>"c'//&:Q&>>>> 	t5)tt4
v}}n.C.CD  )		 GGFO**7<Qx@x!E!H-HqBqc(H-x@V ((7<Qx@x!E!H-HqBqc(H-x@T

 			))LQFK
b&) GGFO**7<Qx@x!E!H-HqBqc(H-x@V
 			))LAF
b&) GGFO**7<Qx@x!E!H-HqBqc(H-x@V ((7<Qx@x!E!H-HqBqc(H-x@U
 			))LIN
b&) ]
		)5	))QF3
b&) 
		)5	))QF3||V^^112222!zz//
b&) ]
		))QFqcB
b&)
		))QFqcB
b&) 
		)AA389C{#664a>QG 76  6]]9C00IIi%I8 1 	9%y)bk	
fnnckk:6{am UTTH .@ .@ .@ .@ .@L 766
 10s   1`)a,`=:a1aaa"a4aaa##a1a#(a.:a)a. !a4b	)`:	=aaaa#)a.4b	b	c                `   \        R \        R4      R\        ^4      /\        P                  ! ^ ^4      R7      p\        V4      pVP                  V4       V P                  V^ R7      pVP                  4       pVP                  P                  R4      Vn	        \        P                  ! WV4       R# )r   r^  r    r%   rw   r'   N)r   r   rI   rx   interval_ranger'   r,   r   r8   r&   r   r:   r;   )r   r-   using_infer_stringrl   r   rm   rA   s   &&&    r   test_to_csv_interval_index-TestDataFrameToCSV.test_to_csv_interval_index  s    T%[#uQx8@Q@QRSUV@WX9~
		$tq1 779!..u5
f/r   c                   \        \        P                  P                  ^4      P	                  R4      P                  \        P                  4      4      p\        P                  V^&   \        V4      pVP                  VRR7       \        VRR7      ;_uu_ 4       pVP                  4       pV^,          P                  R4      ^,          R8X  g   Q h RRR4       R#   + '       g   i     R# ; i)	rP   i  )na_reputf-8r   ,999N)ra   r   )r   r(   re   rf   rg   r   float32r)   r'   r,   open	readlinessplit)r   r-   rl   r   r   liness   &&    r   test_to_csv_float32_nanrep-TestDataFrameToCSV.test_to_csv_float32_nanrep  s    II!!!$44V<CCBJJO
 19~
		$s	#$))QKKME8>>#&q)U222 *)))s   7CC.	c                    \        R . ROR. RO/4      p\        V4      pVP                  V4       V P                  V4      p\        P
                  ! WB4       R# )r   r    Nr6  )z5,6z7,8z9,0r   r'   r,   r   r:   r;   r   r-   rl   r   r|   s   &&   r   test_to_csv_withcommas)TestDataFrameToCSV.test_to_csv_withcommas  sF    Y-BCD9~
		$mmD!
c&r   c                   R  p\        \        P                  P                  ^4      P	                  R4      RV! R4      R7      p\        \        P                  P                  ^4      P	                  R4      P                  R4      RV! R4      R7      p\        RVP                  V! R4      R7      p\        R	VP                  V! R
4      R
R7      p\        \        R4      VP                  V! R4      R7      p\        P                  VP                  R&   \        P                  VP                  R&   \        P                  ! W4WVV.^R7      p/ p	R\        P                  3R\        P                  3R\        P                  3R
\        33 F  w  rV! V
4       F  pWV&   K	  	  K  	  \!        V4      pVP#                  V4       \%        V^ W! R4      R7      p\&        P(                  ! W4       R# )c                 J    \        ^4       Uu. uF	  q VR 2NK  	  up# u upi )r   03dr  )r   r   s   & r   create_cols9TestDataFrameToCSV.test_to_csv_mixed.<locals>.create_cols  s'    .3Ah7hfQsG$h777s    float64float)rG   r"   rK   rz   TboolrQ   rT  r   )r&   r"   rG   20010101date)axis)r   rG   r2   N)d   r   ):   2   N:ra   rY   N)r   r(   re   rf   rg   r   r&   r
   r)   r*   rx   ry   r  rK   bool_r   r'   r,   r   r:   r;   )r   r-   r  df_floatdf_intdf_bool	df_objectdf_dtrl   dtypesr   rG   r   r   rp   s   &&             r   test_to_csv_mixed$TestDataFrameToCSV.test_to_csv_mixed  s   	8 II!!!$44X>(

 II!!!$44X>EEgN&

 DF@STX1Fh
	 j!..'
 %'FFj!!#

:YY'eD1M bjj!BHHRXXv	
HA !^!q	 $
 9~
		$dav;vCVW
b%r   c           	     `   \        \        P                  P                  ^4      P	                  R4      \        \        ^4      4      \        \        ^4      4      ,           RR7      p\        V4      pVP                  V4       \        V^ R7      pVP                  Vn
        \        P                  ! WB4       \        \        P                  P                  ^4      P	                  R4      RR7      p\        \        P                  P                  ^4      P	                  R4      4      P                  R4      p\        RVP                  \        ^4      R7      p\        RVP                  \        ^4      R7      p\        \        R	4      VP                  \        ^4      R7      p	\         P"                  ! WVWxV	.^RR
7      p. RO^,          Vn
        VP                  V4       \        V^ R7      pR F  p
\%        WJ,          4      WJ&   K  	  VP                  Vn
        \        P                  ! WB4       R# )rP   r  rW  rw   rF   rK   TrQ   rT  r  )r  ignore_indexN)r   r  )r   rY   rb   )z0.4z1.4z2.4)r   r(   re   rf   rg   r   rI   r'   r,   r   r"   r:   r;   r   r&   r
   rx   ry   r   )r   r-   rl   r   rm   r  r  r  r  r  r   s   &&         r   test_to_csv_dups_cols(TestDataFrameToCSV.test_to_csv_dups_cols  s   II!!!$44Z@rOd59o5
 9~
		$$!,
f)II!!!$44Y?y
 299003CCINOVV
 DaIe8>>58L	)J/x~~uUVxXYYw59PT
 ]

		))q1 'A#FI.FI ' 
f)r   c           
     ^   \        \        P                  ! R
4      \        \	        ^4       Uu. uF  pRV 2NK
  	  upRR7      \        . RO4      R7      p\        V4      pVP                  V4       \        V^ R7      pVP                  RR/R7      p\        P                  ! WS4       R	# u upi )r   r   rT  r   r[   rQ   rw   za.1r!   Nr`  rZ   )r   r(   r   r   rI   r'   r,   r   renamer:   r;   )r   r-   r   rl   r   rm   s   &&    r   test_to_csv_dups_cols2)TestDataFrameToCSV.test_to_csv_dups_cols2;  s    GGFO5848a2aS845A/*
 9~
		$ $!,s|4
f) 5s   B*r   c                6   \        R \        ^
4      /4      pVP                  R,           VR&   VP                  R,           VR&   VP                  R,           VR&   \        V4      pVP	                  WAR7       \        V^ R7      p\        P                  ! WS4       R	# )
r         ?r    g       @r   g      @r   r   rw   N)r   rI   r   r'   r,   r   r:   r;   )r   r   r-   rA  r   rp   s   &&&   r   test_to_csv_chunking'TestDataFrameToCSV.test_to_csv_chunkingK  sy    U2Y'($$*3$$*3$$*39~
		$	,da(
b%r   c                   ^dp\        \        P                  P                  ^4      P	                  ^V^
,           34      RRR7      p\        V4      pVP                  4       ;_uu_ 4       pVP                  RV4       VP                  VRRR7       RRR4       \        VRR7      p\        P                  ! Wt4       R#   + '       g   i     L5; i)r  Nr  z/pandas.io.formats.csvs._DEFAULT_CHUNKSIZE_CELLSF)r$   r&   r#   )r   r(   re   rf   rg   r'   contextsetattrr,   r   r:   r;   )r   r-   monkeypatchr   rl   r   mrp   s   &&&     r   !test_to_csv_wide_frame_formatting4TestDataFrameToCSV.test_to_csv_wide_frame_formattingW  s     	II!!!$44aR5HI

 9~  ""aIIGSIId5I6 # d4(
b%	 #"s   )'B==C	c                   \        R 4      pV P                  VRR7      p\        RW3P                  ^ ,          ,          /4      p\	        V4      pVP                  V4       \        V^ R7      p\        P                  ! WdRR7       R# )za,1.0
b,2.0Nr#   trw   FrR   )r   r   r   r"   r'   r,   r:   r;   )r   r-   f1rl   newdfr   r@   s   &&     r   test_to_csv_bug"TestDataFrameToCSV.test_to_csv_bugg  si    n%]]2d]+3::a= 1239~T$!,
f?r   c                   \        R . RO/4      p\        V4      pVP                  VRR7       \        V^ RR7      p\        P
                  ! W$4       VP                  VRRR7       \        VRRR7      p\        P
                  ! W$4       R# )u   c/σUTF-8rx  r   r   Fr   r&   Nr6  r  r  s   &&   r   test_to_csv_unicode&TestDataFrameToCSV.test_to_csv_unicodes  st    
I./9~
		$	)tq7;
b&
		$	6ttg>
b&r   c                    \        R 4      p\        . RO. R	O.. R
ORR.R7      pVP                  VRR7       VP                  ^ 4       \	        V^ RR7      p\
        P                  ! W#4       R# )    א   בr  r  rx  r  N)r  d2d3d4)a1a2a3a4)r  r  u   גu   ד)r   r   r,   seekr   r:   r;   )r   bufrl   r|   s   &   r   test_to_csv_unicode_index_col0TestDataFrameToCSV.test_to_csv_unicode_index_col~  sb    rl)+CD<X&
 			#	(sa':
b&r   c                    \        4       pVP                  V4       VP                  ^ 4       \        V^ R7      p\        P
                  ! W14       R# )r   rw   N)r   r,   r  r   r:   r;   )r   r.   r  r@   s   &&  r   test_to_csv_stringio'TestDataFrameToCSV.test_to_csv_stringio  s<    j3#+
f2r   c                    \        . RO. R	O.RR.. R
OR7      p\        V4      pVP                  VRR7       \        V^ R7      p\        . RO. RO.RR.. R
OR7      p\        P
                  ! WE4       R# )翶~Ϛ?r   r    rQ   z%.2f)float_formatrw   Nr  g9DܜJ?g>D)?g.4i(@33333@̤ArU   rc   rd   )gQ?gq=
ףp?g=
ףp=?)gp=
ף(@r  r  r  )r   r-   rl   r   rp   rq   s   &&    r   test_to_csv_float_format+TestDataFrameToCSV.test_to_csv_float_format  ss    +-KL*#
 9~
		$V	,da(!>?*#

 	b%r   c                    \        R RR./4      pVP                  RR RR7      p. ROp\        P                  ! V4      pW$8X  g   Q hR# )	r[   r&  r  ry  c                 2    \         P                  ! V R R7      # )-)trim)r(   format_float_positionalr   s   &r   r   JTestDataFrameToCSV.test_to_csv_float_format_over_decimal.<locals>.<lambda>  s    2#=#=ac#Jr   F)decimalr  r&   N)r[   z0.51)r   r,   r:   convert_rows_list_to_csv_strr   rl   rm   expected_rowsrA   s   &    r   %test_to_csv_float_format_over_decimal8TestDataFrameToCSV.test_to_csv_float_format_over_decimal  sT    c3Z()J  

 *22=A!!!r   c                    \        R . ROR. RO/4      p\        4       pVP                  VR\        P                  RR7       VP                  4       p. ROp\        P                  ! V4      pW58X  g   Q hR# )	r   r    Frw  )r&   quotingr   Nr6  )rT  rY  r[  )z"A","B"z1,"foo"z2,"bar"z3,"baz")r   r   r,   csvQUOTE_NONNUMERICgetvaluer:   r  )r   rl   r  rm   r  rA   s   &     r   !test_to_csv_unicodewriter_quoting4TestDataFrameToCSV.test_to_csv_unicodewriter_quoting  sc    Y-BCDj
		#UC,@,@7	SD22=A!!!r   r   rw  c                    \        R RR./4      p\        4       pVP                  V\        P                  VRR7       VP                  4       p. ROp\        P                  ! V4      pWF8X  g   Q hR# )r   hello	{"hello"}F)r  r   r&   N)r   r  r  )r   r   r,   r  
QUOTE_NONEr  r:   r  )r   r   rl   r  rm   r  rA   s   &&     r   test_to_csv_quote_none)TestDataFrameToCSV.test_to_csv_quote_none  sc     g{345j
		#s~~	N322=A!!!r   c                    \        R . ROR. RO/. ROR7      p\        4       pVP                  VRR7       . R	Op\        P                  ! V4      pVP                  4       V8X  g   Q hR# )
r   r    r%   Fr4   Nr6  r7  onetwothree)zA,Bzone,1,4ztwo,2,5z	three,3,6)r   r   r,   r:   r  r  )r   rl   r  r  rA   s   &    r   "test_to_csv_index_no_leading_comma5TestDataFrameToCSV.test_to_csv_index_no_leading_comma  sX    YY7?VWj
		#5	)B22=A||~)))r   c                   \        R . R	OR. R
O/. ROR7      p\        V4      pVP                  VRR7       Rp\        VRR7      ;_uu_ 4       pVP	                  4       V8X  g   Q h RRR4       R#   + '       g   i     R# ; i)r   r    r%   
lineterminators#   ,A,B
one,1,4
two,2,5
three,3,6
rbrv   Nr6  r7  r  r   r'   r,   r|  readr   r-   rl   r   rA   r   s   &&    r   test_to_csv_lineterminators.TestDataFrameToCSV.test_to_csv_lineterminators  sh    YY7?VW9~
		$v	.A$T""a668x''' #"""   A00B	c                   \        R . R	OR. R
O/. ROR7      p\        V4      pVP                  VRR7       Rp\        VRR7      ;_uu_ 4       pVP	                  4       V8X  g   Q h RRR4       R#   + '       g   i     R# ; i)r   r    r%   
r  s   ,A,B
one,1,4
two,2,5
three,3,6
r  r  Nr6  r7  r  r   r  s   &&    r   test_to_csv_lineterminators2/TestDataFrameToCSV.test_to_csv_lineterminators2  sh    YY7?VW9~
		$t	,9$T""a668x''' #"""r  c                   \        R . ROR. RO/. ROR7      p\        V4      pVP                  V4       \        P                  P                  R4      pRV,           R,           V,           R,           V,           R,           V,           p\        VRR	7      ;_uu_ 4       pVP                  4       V8X  g   Q h R
R
R
4       R
#   + '       g   i     R
# ; i)r   r    r%   rw  s   ,A,Bs   one,1,4s   two,2,5s	   three,3,6r  r  Nr6  r7  r  )r   r'   r,   oslinesepencoder|  r  )r   r-   rl   r   
os_lineseprA   r   s   &&     r   test_to_csv_lineterminators3/TestDataFrameToCSV.test_to_csv_lineterminators3  s    YY7?VW9~
		$ZZ&&w/
  	
    	 $T""a668x''' #"""s   B>>C	c                
   \        \        P                  ! . RO4      4      p\        . RO4      p\        4       pVP	                  VRR7       \        4       pVP	                  VRR7       VP                  4       VP                  4       8X  g   Q h\        RV/4      p\        RV/4      p\        4       pVP	                  V4       \        4       pVP	                  V4       VP                  4       VP                  4       8X  g   Q hR# )r[   Fr#   r   N)r[   r\   r\   r[   r[   r   r   r   )r	   rx   Categoricalr   r,   r  r   )r   r   rH   resrm  rl   r|   s   &      r    test_to_csv_from_csv_categorical3TestDataFrameToCSV.test_to_csv_from_csv_categorical  s     2>>"JKL<=j	U#j
		#e	$||~///Qx b	"j
		#j

3||~///r   c                    VP                  R R7      p\        V\        4      '       g   Q h\        \	        V4      ^ R7      p\
        P                  ! W4       R # )N)path_or_bufrw   )r,   r   r'   r   r   r:   r;   )r   r.   csv_strr@   s   &&  r   test_to_csv_path_is_none+TestDataFrameToCSV.test_to_csv_path_is_none  sI     $$$6'3''''(7+q9
k2r   zdf,encodingr   r    rQ   r!   asciigb2312cp737c                   \        V4      pVP                  WTVR 7       \        WT^ VR7      p\        P                  ! W&4       \        VRWCR 7      ;_uu_ 4       pVP                  VP                  VR7       VP                  P                  '       d   Q h RRR4       \        VVV^ R7      P                  R4      p\        P                  ! W&4       \        P                  ! WT4      ;_uu_ 4       pVP                  4       P                  T;'       g    R4      p	VP                   F  p
W9   d   K  Q h	  RRR4       \        P                  ! WT4      ;_uu_ 4       p\        P                  ! V\        V^ VR7      4       RRR4       R#   + '       g   i     L; i  + '       g   i     Lo; i  + '       g   i     R# ; i)	)compressionr   )r  r   r   wrx  N)r  r   r   r"   r   r  )r'   r,   r   r:   r;   r   handleclosedsqueezedecompress_filer  r   r"   )r   r-   rl   r   r  r   rm   handlesfhtextcols   &&&&&      r   test_to_csv_compression*TestDataFrameToCSV.test_to_csv_compression   sa   0 9~
		$(	C$1xX
b) #;
 
IIgnnxI8~~,,,,,,	
 #	

 ')
 	 	b) 22b779##H$6$67Dzz{"{ " 3
 22b!!"hrQ&RS 32)
 
 32
 322s*   <F	0<F1F$F/	F	F,	/G 	c                   \        V4      pVP                  p\        R VRVP                  ^4      /VR7      pVP	                  VRR7       \        V^ R7      pVP                  R 4      pVP                  P                  R 4      Vn        \        P                  ! WV4       VP	                  VRR7       \        V^ R7      pVP                  R	 4      pVP                  P                  R
 4      Vn        \        P                  ! WW4       VP                  pVP	                  VRR7       \        V^ R7      pVP                  R 4      pVP                  P                  R 4      Vn
        \        P                  ! WX4       \        R.^
,          . RO,           4      p	\        R V	/V	R7      p
V
P	                  VRR7       \        V^ ^.^ R7      p\        P                  ! WZ4       R# )r   r    r%   %Y%m%ddate_formatrw   c                 6    \        V P                  R 4      4      # r,  rz   strftimer   s   &r   r   <TestDataFrameToCSV.test_to_csv_date_format.<locals>.<lambda>a  s    #ajj>R:Sr   c                 6    \        V P                  R 4      4      # r0  r1  r   s   &r   r   r3  c      c!**X./r   %Y-%m-%dc                 $    V P                  R 4      # r6  r2  r   s   &r   r   r3  l  s    !**Z:Pr   c                 $    V P                  R 4      # r8  r9  r   s   &r   r   r3  n  s    ajj,r   c                 6    \        V P                  R 4      4      # r0  r1  r   s   &r   r   r3  z  r5  r   c                 $    V P                  R 4      # r0  r9  r   s   &r   r   r3  ~  s    ajj*r   r   )r2   r   N)
2000-01-01r=  r=  )r'   r&   r   shiftr,   r   r   r:   r;   Tr"   r   )r   r-   r?   r   r   r@  datetime_frame_intdatetime_frame_strdatetime_frame_columns	nat_index	nat_frames   &&&        r   test_to_csv_date_format*TestDataFrameToCSV.test_to_csv_date_formatV  s   9~!''"(C!238
 	d9 *+//0ST#5#;#;#?#?/$
  	d7d
; *+//0PQ#5#;#;#?#?,$
  	d7 "0!1!1%%d%A*!7!;!;/"
 *@)G)G)K)K**
& 	d;  GbLEE
	 sI.i@	:61a&A>
d.r   tdr3   10sc                   \        V4      p\        R RRRRR7      pWA,           pVP                  R4      p\        P                  ! \        \        V4      4      RR7      p\        R	V/VR
7      pVP                  VRR
7       \        V^ R7      p\        VP                  RR7      P                  R4      Vn        \        P                  ! W4       R# )z2013-10-26 23:00z2013-10-27 01:00zEurope/Londonr)  infer)r   r   	ambiguousNrK   rF   r   r%   Trw   utc)r'   r   r7   r(   r   rI   r<   r   r,   r   r   r&   r   r:   r;   )	r   rG  r-   r   timesr   
time_rangerl   rm   s	   &&&      r    test_to_csv_with_dst_transitions3TestDataFrameToCSV.test_to_csv_with_dst_transitions  s    9~
 JLLXXeCFm7;
Z(2
		$d	# $!,"6<<T:EEoV
f)r   z	start,endz
2015-03-29z
2015-03-30z
2015-10-25z
2015-10-26c                p   \        WR RRR7      pVP                  R4      pRVP                  n        \	        R^RV/VR7      pVP                  VRR7       \        V^ R	7      p\        VP                  RR
7      P                  R4      P                  R4      Vn        \        VR,          RR
7      P                  R4      VR&   \        P                  ! We4       VP                  \        4       \        V4      pVP                  V4       \         P"                  ! V4      p\        P                  ! We4       R# )r)  zEurope/Parisr   )r   r   unitNr>   idxr%   Trw   rL  zdatetime64[ns, Europe/Paris])r   r7   _data_freqr   r,   r   r   r&   r   r9   r   r:   r;   r'   	to_picklerx   read_pickle)r   startendr-   rT  rl   rm   r   s   &&&&    r   ,test_to_csv_with_dst_transitions_with_pickle?TestDataFrameToCSV.test_to_csv_with_dst_transitions_with_pickle  s     #.tLnnT"		!UC0<
		)4	()q1$/::>JRRSWX 	 $F5Mt<CC*
u 	f) 			#9~
T%
f)r   c                   \        R RR.RRR.R^*\        P                  .RRR	./4      p. ROp\        P                  ! V4      pVP                  4       pWC8X  g   Q hVP                  R
R7      pWC8X  g   Q h. ROp\        P                  ! V4      pVP                  \        P                  R7      pWC8X  g   Q h. ROp\        P                  ! V4      pVP                  \        P                  R7      pWC8X  g   Q h. ROp\        P                  ! V4      pVP                  \        P                  R7      pWC8X  g   Q hRp\        P                  ! \        P                  VR7      ;_uu_ 4        VP                  \        P                  R7       R
R
R
4       \        P                  ! \        P                  VR7      ;_uu_ 4        VP                  \        P                  R
R7       R
R
R
4       . ROp\        P                  ! V4      pVP                  \        P                  RR7      pWC8X  g   Q h. ROp\        P                  ! V4      pVP                  \        P                  RR7      pWC8X  g   Q hRR.p\        P                  ! V4      p\        \        V4      4      p\        4       pVP                  VRRR7       VP!                  4       V8X  g   Q h\        R^^.R^^.R^^./4      pVP#                  RR.4      p. ROp\        P                  ! V4      pVP                  \        P                  R7      V8X  g   Q hR
#   + '       g   i     EL; i  + '       g   i     EL{; i)c_boolTFc_floatr  g	@c_intc_stringr[   zb,cN)r  z%need to escape, but no escapechar setrV   )r  
escapechar!r   za,b,cz1,"test 
",3rw  r  r\   r   ),c_bool,c_float,c_int,c_string0,True,1.0,42.0,az1,False,3.2,,"b,c")("","c_bool","c_float","c_int","c_string"z"0","True","1.0","42.0","a"z"1","False","3.2","","b,c")rf  z0,True,1.0,42.0,"a"z1,False,3.2,"","b,c")rd  re  z1,False,3.2,,b!,c)z,c_bool,c_ffloat,c_int,c_stringre  z1,False,3.2,,bf,c)z"a","b","c"z"1","3","5"z"2","4","6")r   r(   r)   r:   r  r,   r  QUOTE_MINIMAL	QUOTE_ALLr  ri   rj   Errorr  r   r   r  	set_index)	r   rl   r  rA   rm   rr   	text_rowsr'  r  s	   &        r   test_to_csv_quoting&TestDataFrameToCSV.test_to_csv_quoting  s   4-C:"bffS%L	


 22=A!!!4(!!!

 22=A3#4#45!!!

 22=A3==1!!!

 22=A3#7#78!!!5]]399C00IIcnnI- 1 ]]399C00IIcnnI> 1

 22=A3>>cB!!!

 22=A3>>cB!!! /0	..y9htn%j
		#u	5||~%%% aVS1a&#1v>?\\3*%E22=Ayyy/8;;;S 100 100s   ,!M"MM	M(	c                   . ROp\         P                  ! VRR7      p\        . R	OVR7      pVP                  4       p. R
Op\        P
                  ! V4      pWF8X  g   Q hRpVP                  VR7      p. ROp\        P
                  ! V4      pWF8X  g   Q hR \        R.p\         P                  ! VRR7      p\        . R	OVR7      pVP                  4       p. ROp\        P
                  ! V4      pWF8X  g   Q hR# )
1990-01-01
3005-01-01r   )r   r%   z%m-%d-%Yr-  N)ro  r=  rp  r7  ),01990-01-01,4z2000-01-01,53005-01-01,6)rq  z01-01-1990,4z01-01-2000,5z01-01-3005,6)rq  rr  z,5rs  )rx   PeriodIndexr   r,   r:   r  r   )r   datesr&   rl   rm   r  rA   r.  s   &       r   test_period_index_date_overflow2TestDataFrameToCSV.test_period_index_date_overflow&  s     ;u3/y.N22=A!!! {3N22=A!!! sL1u3/y.D22=A!!!r   c                    \         P                  ! . RO4      p\        . RO. RO.4      pWn        . ROpVP	                  VR7      p. ROp\
        P                  ! V4      pWF8X  g   Q hR# )r[   r#   N))r[   ra   )r[   rP   )r\   ra   )r\   rP   ra   rP   rY   r   )r   r8  r9  r:  )r[   r\   r   d)z,a,b,c,dz	0,1,2,3,4z	1,5,6,7,8)r   rh   r   r"   r,   r:   r  )r   r"   rl   r$   rm   r  rA   s   &      r   test_multi_index_header*TestDataFrameToCSV.test_multi_index_headerE  s]    (()QRl34
%&)>22=A!!!r   c                    \        . RO4      p\        . R	O.VR7      pVP                  RR.R7      pRpVP                  RR7      p\        P
                  ! WC4       R# )
ra   r!   z,1,3
0,1,3
r  r  Nra   rY   )r~  )rP   r  r6  )r   r   reindexr,   r:   r=   )r   r&   rl   rA   rm   s   &    r   $test_to_csv_single_level_multi_index7TestDataFrameToCSV.test_to_csv_single_level_multi_indexR  sR    ()	{E2ZZtZ-"$/
v0r   c                   \        R ^^./4      p. ROp\        P                  ! V4      pVR,          pVP                  4        \	        V4      pVP                  VRR7       \        P                  ! VRR7      ;_uu_ 4       pVP                  4       P                  R4      pRRR4       XV8X  g   Q hR#   + '       g   i     L; i)	r[   z__test_gz_lineend.csv.gzFr%   gzip)r  rw  N)r[   r  2)	r   r:   r  touchr'   r,   r$  r  r   )	r   tmp_pathrl   r  rA   	file_pathr   r   rm   s	   &&       r   test_gz_lineend"TestDataFrameToCSV.test_gz_lineend[  s    aV}%'22=A99	9~
		$e	$&99QVVX__W-F : !!! :9s    B44C	c                    \        R \        R^
R7      /4      p\        4       pVP                  V4       VP	                  4       pRV9   g   Q hR# )r[   z1/1/2000r   r=  N)r   r   r   r,   r  )r   rh  r  rm   s   &   r   test_to_csv_numpy_16_bug+TestDataFrameToCSV.test_to_csv_numpy_16_bugi  sD    3
:r BCDjSv%%%r   c                z    \        R R .4      P                  R RRRR7      P                  RR4      pRpW8X  g   Q hR # )NFr  )r$   r&   rv  r  r  z""
""
)r   r,   replace)r   rm   rA   s   &  r   test_to_csv_na_quoting)TestDataFrameToCSV.test_to_csv_na_quotingr  sF     tTl#VDeBV?WVT" 	
 !!!r   c                   \        R RR^\        P                  ./4      pVR,          P                  R4      VR&   VR,          P                  R4      VR&   VP	                  4       p. ROp\
        P                  ! V4      pW$8X  g   Q hR# )r[   r]   r\   Int16categoryN)z,a,bz0,x,1z1,x,)r   rx   NAr   r,   r:   r  r  s   &    r   test_to_csv_categorical_and_ea1TestDataFrameToCSV.test_to_csv_categorical_and_ea}  su    S#255z23S'..)3S'..,3122=A!!!r   c           	        \        R \        P                  ! \        R4      \        R4      RR7      ./4      pVR ,          P	                  R4      VR &   VP                  4       pRR.p\        P                  ! V4      pW$8X  g   Q hR# )	r[   r   z
2020-01-02both)r"  r  z,az.0,"[2020-01-01 00:00:00, 2020-01-02 00:00:00]"N)r   rx   Intervalr
   r   r,   r:   r  r  s   &    r   $test_to_csv_categorical_and_interval7TestDataFrameToCSV.test_to_csv_categorical_and_interval  s    KK!,/!,/%

 S'..,3OP22=A!!!r   c                   \        R . RO/4      pRpVR,          pVR,          p\        P                  ! \        VRR7      ;_uu_ 4        VP	                  VR R7       RRR4       \        P                  ! \        VRR7      ;_uu_ 4        VP	                  VR R7       RRR4       R#   + '       g   i     LS; i  + '       g   i     R# ; i)	r[   zzip and tar do not support mode 'a' properly. This combination will result in multiple files with same name being added to the archiveztest.zipztest.tarF)rW   raise_on_extra_warningsr  Nr6  )r   r:   rb  RuntimeWarningr,   )r   r  rl   rr   zip_pathtar_paths   &&    r   -test_to_csv_warn_when_zip_tar_and_append_mode@TestDataFrameToCSV.test_to_csv_warn_when_zip_tar_and_append_mode  s    Y'(Q 	 j(j(''#u
 
 IIhSI)

 ''#u
 
 IIhSI)
 

 


 
 
s   	B(
B;(B8	;C	c           	         \        R RR.RRR.RRR./4      pVP                  R	R
\        P                  R7      p. ROp\        P
                  ! V4      pW$8X  g   Q hR# )col_ar[   r  col_bzb"cNcol_czde,f"z"c"\)	quotecharrb  r  )z,col_a,col_b,col_cz0,a,b\"c,de\,f\"z	1,a2,,\"c)r   r,   r  r  r:   r  r  s   &    r   test_to_csv_escape_quotechar/TestDataFrameToCSV.test_to_csv_escape_quotechar  sk    #t%'4
 ST3>>R

 22=A!!!r   r   )NNNNF)rP   r
  c   r  e   f                           ))r   r   )r   r   )r   r   )r   r   ry  )r
  b   r  r  r  r  r  r  r  r  r  r  r  r  )r
  r  r  r  r  r  )rP   rY   r   )ra   r   r
  r  r  r  )r^  defghi){   u   你好u   世界)r  u   Γειά σουu
   Κόσμε)M__name__
__module____qualname____firstlineno__r   r/   rB   rM   rs   r~   r   r   r   ri   markparametrizer   slowr   r   r   filterwarningsr   r  r  r  r  r!  r+  r0  r<  rD  rL  rn  rs  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   r)  rE  rx   r   r9   rP  r[  rl  rv  r{  r  r  r  r  r  r  r  r  __static_attributes____classdictcell__)__classdict__s   @r   r   r      s:    (.E**"9H&A 6"A& [[VdS#J%78"? 9"?H [[C C:fP [[[[SC C [[[[S [[ "S [[Wl3[[ VWC X 4 C: [[[[T [[Wl3C 4 
C [[[[W&ABC C C( [[I I
 [[C C [[[[S [[Wi0[[ q!GQ<0q!GQ<0q/15GQ7OP	
C 1 C,G
G
*@-$T l03',&\$*L*  [[[*5	& 6	& [[& &
@	''3&$
"	" [[Z$9	" :	"*
(
((*003 [[ 35ST*+
  -.H'Rq566PRZ[?@@+ 	
.T/.T>6/p [[TBLLO$;$;D$A2<<PUCV#WX* Y** [[<(<(	
**2`<D">"1"&	"""&*&" "r   r   )r  ior   r  numpyr(   ri   pandas.errorsr   pandasrx   r   r   r   r   r	   r
   r   r   r   r   pandas._testing_testingr:   pandas.core.commoncorecommonrd  pandas.io.commonr   r   r   r   r   <module>r     sC    
  	   %         'a" a"r   