1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
Ë
oñúh•kãó’—ddlZddlZddlZddlmZddlmZddlZddl    Z    ddl
Z ddl
m Z m Z mZddlmZGd„d«Zd„Zd„Zd    „Zy)
éN)ÚZipFile)ÚError)Ú    DataFrameÚIndexÚcompatc
ó@—eZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z    d„Z
d    „Z d
„Z d „Z d „Zd „Zd„Zd„Zd„Zej(j+dej.dggdggdg¬«dfej.dgdggdgdggddg¬«dfg«d„«Zd„Zd„Zd„Zd„Zd„Zej(j=ej@«d ¬!«d"„«Z!d#„Z"ej(j+d$d%d&g«ej(j+d'd%d&g«d(„««Z#d)„Z$d*„Z%ej(j+d+d,d-g«ej(j+d.d/d0g«d1„««Z&ej(j+d2gd3¢«d4„«Z'ej(j+d5d6g«d7„«Z(d8„Z)d9„Z*ej(j+d:gd;¢«d<„«Z+ej(j+d=d>d?g«d@„«Z,ej(j+d=d>d?g«dA„«Z-yB)CÚ    TestToCSVcó—tddg«}d}tjd«5}|j|dd¬«t    |d¬«5}|j «|k(sJ‚    ddd«ddd«tddg«}d}tjd«5}|j|dd¬«t    |d¬«5}|j «|k(sJ‚    ddd«ddd«y#1swYŒxYw#1swYŒƒxYw#1swYŒ*xYw#1swYyxYw)Néz""
1.0
útest.csv©ÚheaderÚindexúutf-8©Úencodingz1.0
""
©rÚtmÚ ensure_cleanÚto_csvÚopenÚread)ÚselfÚdf1Ú    expected1ÚpathÚfÚdf2Ú    expected2s       úVH:\Change_password\venv_build\Lib\site-packages\pandas/tests/io/formats/test_to_csv.pyÚtest_to_csv_with_single_columnz(TestToCSV.test_to_csv_with_single_columns €ô˜˜q˜    Ó"ˆðˆ    ô_‰_˜ZÓ (ð    -¨DØ J‰Jt D°ˆJÔ 5ܐd WÔ-ð -°Ø—v‘v“x 9Ò,Ð,Ñ,÷ -÷    -ô
˜˜D˜    Ó"ˆðˆ    ô_‰_˜ZÓ (ð    -¨DØ J‰Jt D°ˆJÔ 5ܐd WÔ-ð -°Ø—v‘v“x 9Ò,Ð,Ñ,÷ -÷    -ð    -÷ -ð -ú÷    -ð    -ú÷ -ð -ú÷    -ð    -úsG¥"C(ÁCÁC(Â"DÂ4C4à DÃC%    Ã!C(Ã(C1Ã4C=    Ã9DÄD    cóî—tdgd¢i«}tjd«5}|j|«tjt j |d¬«|«ddd«y#1swYyxYw)NÚcol)ÚAAAAAu
ÄÄÄÄÄu
ßßßßßu聞聞聞聞聞r r©Ú    index_col)rrrrÚassert_frame_equalÚpdÚread_csv)rÚdfrs   r Útest_to_csv_default_encodingz&TestToCSV.test_to_csv_default_encoding0s_€ä ˜ÒWÐXÓ Yˆä _‰_˜ZÓ (ð    F¨Dà I‰IdŒOÜ × !Ñ !¤"§+¡+¨d¸aÔ"@À"Ô E÷    F÷    Fñ    Fús ¥=A+Á+A4cóÜ—tdddgi«}d}tjd«5}|j|d¬«t    |d¬«5}|j «|k(sJ‚    ddd«ddd«d    }tjd«5}|j|dd
¬ «t    |d¬«5}|j «|k(sJ‚    ddd«ddd«tjd«5}t jtd ¬ «5|j|dd¬ «ddd«ddd«y#1swYŒÈxYw#1swYŒÌxYw#1swYŒ€xYw#1swYŒ„xYw#1swYŒBxYw#1swYyxYw)Nr#r éz"","col"
"0","1"
"1","2"
r )Úquotingrrz$$,$col$
$0$,$1$
$1$,$2$
ú$)r.Ú    quotecharr0©Úmatch)    rrrrrrÚpytestÚraisesÚ    TypeError©rr*Úexpectedrrs     r Útest_to_csv_quotecharzTestToCSV.test_to_csv_quotechar9sW€Ü ˜  1˜vÓ 'ˆðˆô _‰_˜ZÓ (ð    ,¨DØ I‰Id AˆIÔ &ܐd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷    ,ð
ˆô _‰_˜ZÓ (ð    ,¨DØ I‰Id A°ˆIÔ 5ܐd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷    ,ô
_‰_˜ZÓ (ð    ;¨DÜ—‘œy° Ô<ñ ;Ø—    ‘    ˜$¨°T    Ô:÷ ;÷    ;ð    ;÷ ,ð ,ú÷    ,ð    ,ú÷ ,ð ,ú÷    ,ð    ,ú÷  ;ð ;ú÷    ;ð    ;úsk§!D2ÁD&ÁD2Â"E
Â(D>Â?E
Ã$E"ÄEÄE"Ä&D/    Ä+D2Ä2D;Ä>E    ÅE
EÅE    ÅE"Å"E+cóì—tdddgi«}d}tjd«5}|j|dd¬«t    |d    ¬
«5}|j «|k(sJ‚    ddd«ddd«tjd«5}t jtd ¬ «5|j|d ¬«ddd«ddd«y#1swYŒgxYw#1swYŒkxYw#1swYŒ*xYw#1swYyxYw)Nr#úa"aú"bb"z!"","col"
"0","a""a"
"1","""bb"""
r r T)r.Ú doublequoterrÚ
escapecharr1F)r<)    rrrrrrr3r4rr6s     r Útest_to_csv_doublequotez!TestToCSV.test_to_csv_doublequoteUså€Ü ˜  v˜Ð/Ó 0ˆðˆô _‰_˜ZÓ (ð    ,¨DØ I‰Id A°4ˆIÔ 8ܐd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷    ,ô
_‰_˜ZÓ (ð    3¨DÜ—‘œu¨LÔ9ñ 3Ø—    ‘    ˜$¨E    Ô2÷ 3÷    3ð    3÷ ,ð ,ú÷    ,ð    ,ú÷  3ð 3ú÷    3ð    3úsG§"CÁ    CÁ CÂC*Â!CÂ5C*ÃC    Ã CÃCÃC'    Ã#C*Ã*C3có"—tdddgi«}d}tjd«5}|j|ddd¬    «t    |d
¬ «5}|j «|k(sJ‚    ddd«ddd«tdd d gi«}d}tjd«5}|j|dd¬«t    |d
¬ «5}|j «|k(sJ‚    ddd«ddd«y#1swYŒxYw#1swYŒ…xYw#1swYŒ*xYw#1swYyxYw)Nr#r:r;z!"","col"
"0","a\"a"
"1","\"bb\""
r r Fú\)r.r<r=rrza,az,bb,z,col
0,a\,a
1,\,bb\,
é)r.r=rr6s     r Útest_to_csv_escapecharz TestToCSV.test_to_csv_escapecharfs€Ü ˜  v˜Ð/Ó 0ˆðˆô _‰_˜ZÓ (ð    ,¨DØ I‰Id A°5ÀTˆIÔ Jܐd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷    ,ô
˜  v˜Ð/Ó 0ˆðˆô _‰_˜ZÓ (ð    ,¨DØ I‰Id A°$ˆIÔ 7ܐd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷    ,ð    ,÷ ,ð ,ú÷    ,ð    ,ú÷ ,ð ,ú÷    ,ð    ,úsG§#C-Á
C!Á!C-Â"DÂ9C9ÃDÃ!C*    Ã&C-Ã-C6Ã9D    Ã>DÄDcó~—tdddgi«}gd¢}tj|«}|j«|k(sJ‚y)Nr#r r-)z,colú0,1z1,2)rrÚconvert_rows_list_to_csv_strr©rr*Ú expected_rowsr7s    r Útest_csv_to_stringzTestToCSV.test_csv_to_strings=€Ü ˜  1˜vÓ 'ˆÚ.ˆ Ü×2Ñ2°=ÓAˆØy‰y‹{˜hÒ&Ð&Ñ&ócóΗtdgdgdgdœ«}ddg}tj|«}|j«|k(sJ‚ddg}tj|«}|jd    d
¬ «|k(sJ‚dd g}tj|«}|jd ¬«|k(sJ‚ddg}tj|«}|jd    d
d ¬«|k(sJ‚tddgddgddœ«}gd¢}tj|«}|jdd¬«|k(sJ‚|j    d«jd¬«|k(sJ‚|j    ddg«jd¬«|k(sJ‚y)Nr Úag333333$@)Úcol1Úcol2Úcol3z,col1,col2,col3z
0,1,a,10.1z;col1;col2;col3z
0;1;a;10,1ú,ú;)ÚdecimalÚsepz 0,1,a,10.10ú%.2f©Ú float_formatz 0;1;a;10,10)rQrRrUr皙™™™™ñ?皙™™™™@çffffff
@©rKÚbÚc)úa,b,cz    0^0,2^2,1z    1^1,3^3,1Fú^)rrQ)rQrZ)rrrErÚ    set_index)rr*rGÚexpected_defaultÚexpected_european_excelÚexpected_float_format_defaultÚexpected_float_formatr7s        r Útest_to_csv_decimalzTestToCSV.test_to_csv_decimal…s‘€ä   ¨c¨U¸T¸FÑCÓ Dˆà*¨LÐ9ˆ Ü×:Ñ:¸=ÓIÐØy‰y‹{Ð.Ò.Ð.Ð.à*¨LÐ9ˆ Ü"$×"AÑ"AÀ-Ó"PÐØy‰y ¨#ˆyÓ.Ð2IÒIÐIÐIà*¨MÐ:ˆ Ü(*×(GÑ(GÈ Ó(VÐ%؏y‰y fˆyÓ-Ð1NÒNÐNÐNà*¨MÐ:ˆ Ü "× ?Ñ ?À Ó NÐà I‰I˜c s¸ˆIÓ @Ø$ò %ð    
ð %ô
˜a ˜X¨S°#¨J¸QÑ?Ó @ˆâ;ˆ Ü×2Ñ2°=ÓAˆØy‰y˜u¨cˆyÓ2°hÒ>Ð>Ð>ð|‰|˜CÓ ×'Ñ'°Ð'Ó4¸Ò@Ð@Ð@ð|‰|˜S #˜JÓ'×.Ñ.°sÐ.Ó;¸xÒGÐGÑGrIcóø—tddgddgddœ«}gd¢}tj|«}|jd«j    d¬    «|k(sJ‚|jdd
g«j    d¬    «|k(sJ‚y) Nrr rWrXrY)r\z0,2.20,1z1,3.30,1rKrSrTrZ)rrrEr^rrFs    r Útest_to_csv_float_formatz"TestToCSV.test_to_csv_float_format©s‚€ô˜a ˜V¨3°¨*¸1Ñ=Ó >ˆâ9ˆ Ü×2Ñ2°=ÓAˆØ|‰|˜CÓ ×'Ñ'°VÐ'Ó<ÀÒHÐHÐHð|‰|˜S #˜JÓ'×.Ñ.¸FÐ.ÓCÀxÒOÐOÑOrIcóÄ—tdtjgddgddgdœ«}gd¢}tj|«}|j d«j d¬    «|k(sJ‚|j dd
g«j d¬    «|k(sJ‚ttjddgddgdœ«}gd ¢}tj|«}|j d«j d¬    «|k(sJ‚|j dd
g«j d¬    «|k(sJ‚tdddgddgdœ«}gd ¢}tj|«}|j d«j d¬    «|k(sJ‚|j dd
g«j d¬    «|k(sJ‚tjdtjd g«j d¬    «}tjgd¢«}||k(sJ‚y)Nrr r-rArY)r\z0.0,0,2ú_,1,3rKÚ_©Úna_reprZ)r\z_,0,2rg)r\z0,0,2z0,1,3r[ÚZZZZZ©ú,0z0,az1,ZZZZZz2,c)
rÚnpÚnanrrEr^rr(ÚSeriesÚNA)rr*rGr7Úcsvs     r Útest_to_csv_na_repzTestToCSV.test_to_csv_na_repµsÌ€ô˜a¤§¡˜[°°1¨v¸QÀ¸FÑCÓ DˆÚ5ˆ Ü×2Ñ2°=ÓAˆà|‰|˜CÓ ×'Ñ'¨sÐ'Ó3°xÒ?Ð?Ð?؏|‰|˜S #˜JÓ'×.Ñ.°cÐ.Ó:¸hÒFÐFÐFôœRŸV™V¨1¨a¨&¸¸1°vÑ>Ó ?ˆÚ3ˆ Ü×2Ñ2°=ÓAˆà|‰|˜CÓ ×'Ñ'¨sÐ'Ó3°xÒ?Ð?Ð?؏|‰|˜S #˜JÓ'×.Ñ.°cÐ.Ó:¸hÒFÐFÐFô˜Q a¨ V°1°a°&Ñ9Ó :ˆÚ3ˆ Ü×2Ñ2°=ÓAˆà|‰|˜CÓ ×'Ñ'¨sÐ'Ó3°xÒ?Ð?Ð?؏|‰|˜S #˜JÓ'×.Ñ.°cÐ.Ó:¸hÒFÐFÐFäi‰i˜œbŸe™e SÐ)Ó*×1Ñ1¸Ð1ÓAˆÜ×2Ñ2Ò3RÓSˆØ˜3ŠÐ‰rIcó°—tjgd¢«}tjdtjdg|¬«j d¬«}||k(sJ‚y)NrlrKr[©Údtyperkri)rrEr(rprqr)rÚnullable_string_dtyper7rrs    r Ú"test_to_csv_na_rep_nullable_stringz,TestToCSV.test_to_csv_na_rep_nullable_stringÔsS€ô×2Ñ2Ò3RÓSˆÜi‰i˜œbŸe™e SÐ)Ð1FÔG×NÑNØðOó
ˆð˜3ŠÐ‰rIcó—tdtjddd¬«i«}tdtjddd¬«i«}gd¢}tj|«}|j «|k(sJ‚gd¢}tj|«}|j d    ¬
«|k(sJ‚gd ¢}tj|«}|j d ¬
«|k(sJ‚gd ¢}tj|«}|j «|k(sJ‚|j d ¬
«|k(sJ‚d|d<d|d<ddg}tj|«}|j tjdd¬«dg«}|j«j d ¬
«|k(sJ‚y)NÚAÚ20130101éÚs©ÚperiodsÚfreqÚd)ú,Aú0,2013-01-01 00:00:00z1,2013-01-01 00:00:01z2,2013-01-01 00:00:02z3,2013-01-01 00:00:03z4,2013-01-01 00:00:04)r‚rƒz1,2013-01-02 00:00:00z2,2013-01-03 00:00:00z3,2013-01-04 00:00:00z4,2013-01-05 00:00:00z%Y-%m-%d %H:%M:%S)Ú date_format)r‚ú 0,2013-01-01z 1,2013-01-01z 2,2013-01-01z 3,2013-01-01z 4,2013-01-01ú%Y-%m-%d)r‚r…z 1,2013-01-02z 2,2013-01-03z 3,2013-01-04z 4,2013-01-05rÚBr ÚCzA,B,Cz2013-01-01,0,1.0Ú1h)Úkeyr€)    rr(Ú
date_rangerrErÚgroupbyÚGrouperÚmean)    rÚdf_secÚdf_dayrGÚexpected_default_secÚexpected_ymdhms_dayÚexpected_ymd_secÚexpected_default_dayÚdf_sec_groupeds             r Útest_to_csv_date_formatz!TestToCSV.test_to_csv_date_formatÝs€ä˜C¤§¡¨zÀ1È3Ô!OÐPÓQˆÜ˜C¤§¡¨zÀ1È3Ô!OÐPÓQˆò
ˆ ô "×>Ñ>¸}ÓMÐØ}‰}‹Ð"6Ò6Ð6Ð6ò
ˆ ô!×=Ñ=¸mÓLÐØ}‰}Ð)<ˆ}Ó=ÐATÒTÐTÐTò
ˆ ô×:Ñ:¸=ÓIÐØ}‰}¨ˆ}Ó4Ð8HÒHÐHÐHò
ˆ ô "×>Ñ>¸}ÓMÐØ}‰}‹Ð"6Ò6Ð6Ð6؏}‰}¨ˆ}Ó4Ð8LÒLÐLÐL𠈈s‰ ؈ˆs‰ à Ð"4Ð5ˆ Ü×:Ñ:¸=ÓIÐàŸ™¬¯©¸À$Ô)GÈÐ(MÓNˆØ×"Ñ"Ó$×+Ñ+¸
Ð+ÓCÐGWÒWÐWÑWrIcóҗttjd«tjddd¬«dœ«}gd¢}t    j
|«}|j d¬«|k(sJ‚y)    Nz
1970-01-01r-Úhr~)ÚdateÚdatetime)z date,datetimez1970-01-01,1970-01-01 00:00:00z1970-01-01,1970-01-01 01:00:00F©r)rr(Ú to_datetimer‹rrErrFs    r Ú&test_to_csv_different_datetime_formatsz0TestToCSV.test_to_csv_different_datetime_formatss_€ä 䟙 |Ó4ÜŸM™M¨,ÀÈÔLñ ó
ˆò 
ˆ ô
×2Ñ2°=ÓAˆØy‰y˜uˆyÓ%¨Ò1Ð1Ñ1rIcó—tjtjdtjgd¬««}|j    d«}t j gd¢«}|jd¬«|k(sJ‚tjtjddd    d
¬ «jtjtjg«««}|j    d«}|jdd¬ «|k(sJ‚y) Nú
2021-03-27r†)ÚformatÚcategory)Ú0rŸz""Fr›ÚDr z Europe/Berlin)Ústartr€rÚtz)rr„) r(rprœÚNaTÚastyperrErr‹ÚappendÚ DatetimeIndex)rÚserr7s   r Ú&test_to_csv_date_format_in_categoricalz0TestToCSV.test_to_csv_date_format_in_categorical,sŀäi‰iœŸ™¨ ´b·f±fÐ'=ÀjÔQÓRˆØj‰j˜Ó$ˆÜ×2Ñ2Ò3LÓMˆØz‰z ˆzÓ&¨(Ò2Ð2Ð2äi‰iÜ M‰MØ"¨°a¸Oô ç‰f”R×%Ñ%¤r§v¡v hÓ/Ó0ó
ˆð
j‰j˜Ó$ˆØz‰z °:ˆzÓ>À(ÒJÐJÑJrIcóԗtddtjdgddœ«}|djd«|d<|j    dd    ¬
«}t j gd ¢«}||k(sJ‚y) NrVç)\Âõ(@ç7§’@r[©rKrZrKÚFloat64Fz%.5f)rrU)úa,bz    1.10000,cz    2.02000,cú,cz    6.00001,c©rr(rqr§rrrE©rr*Úresultr7s    r Ú!test_to_csv_float_ea_float_formatz+TestToCSV.test_to_csv_float_ea_float_format;si€ä ˜c 4¬¯©°Ð9ÀÑDÓ EˆØS‘'—.‘. Ó+ˆˆ3‰Ø—‘ °VÓ<ˆÜ×2Ñ2Ú @ó
ˆð˜Ò!Ð!Ñ!rIcóҗtddtjdgddœ«}|djd«|d<|j    d¬    «}t j gd
¢«}||k(sJ‚y) NrVr­r®r[r¯rKr°Fr›)r±z1.1,cz2.02,cr²z
6.000006,cr³r´s    r Ú$test_to_csv_float_ea_no_float_formatz.TestToCSV.test_to_csv_float_ea_no_float_formatEsg€ä ˜c 4¬¯©°Ð9ÀÑDÓ EˆØS‘'—.‘. Ó+ˆˆ3‰Ø—‘ Ó'ˆÜ×2Ñ2Ú :ó
ˆð˜Ò!Ð!Ñ!rIcó–—tdgtjjdgdgg«¬«}gd¢}t    j
|«}|j «|k(sJ‚gd¢}t    j
|«}|j d¬«|k(sJ‚tdgtjjdgdgg«tjjdgdgg«¬«}gd    ¢}t    j
|«}|j «|k(sJ‚gd¢}t    j
|«}|j d¬«|k(sJ‚tdgtjjd
gd gg«¬«}gd ¢}t    j
|«}|j «|k(sJ‚gd ¢}t    j
|«}|j d¬«|k(sJ‚y)Nr r-©Úcolumns)z,1z,2rD)Ú1Ú2r¼Fr›©r»r)z,,1z,,2z1,2,1ÚfooÚbar)z,fooz,barrD)r¿rÀr¼)rr(Ú
MultiIndexÚ from_arraysrrEr)rr*Úexp_rowsÚexps    r Útest_to_csv_multi_indexz!TestToCSV.test_to_csv_multi_indexOs—€ä ˜s¤B§M¡M×$=Ñ$=À¸sÀQÀC¸jÓ$IÔ Jˆâ&ˆÜ×-Ñ-¨hÓ7ˆØy‰y‹{˜cÒ!Ð!Ð!â"ˆÜ×-Ñ-¨hÓ7ˆØy‰y˜uˆyÓ%¨Ò,Ð,Ð,ä Ø ˆCÜ—M‘M×-Ñ-°¨s°Q°C¨jÓ9Ü—-‘-×+Ñ+¨a¨S°1°#¨JÓ7ô
ˆò +ˆÜ×-Ñ-¨hÓ7ˆØy‰y‹{˜cÒ!Ð!Ð!â"ˆÜ×-Ñ-¨hÓ7ˆØy‰y˜uˆyÓ%¨Ò,Ð,Ð,ä ˜s¤B§M¡M×$=Ñ$=À¸wÈÈÐ>PÓ$QÔ Rˆâ*ˆÜ×-Ñ-¨hÓ7ˆØy‰y‹{˜cÒ!Ð!Ð!â&ˆÜ×-Ñ-¨hÓ7ˆØy‰y˜uˆyÓ%¨Ò,Ð,Ñ,rIz ind,expectedgð?rÚx)ÚlevelsÚcodesÚnamesz x,data
1.0,1
g@Úyzx,y,data
1.0,2.0,1
cóv—|tjdg|d¬««}|jdd¬«}||k(sJ‚y)Nr Údata)Únameú
T)Úlineterminatorr)r(rpr)rÚindr7Úframe_or_seriesÚobjrµs      r Ú$test_to_csv_single_level_multi_indexz.TestToCSV.test_to_csv_single_level_multi_indexss=€ñ"œbŸi™i¨¨¨S°vÔ>Ó?ˆà—‘¨4¸Ó=ˆØ˜Ò!Ð!Ñ!rIcó —dddgidddgig}t|«}d}tjd«5}|j|d¬    «t    |d
¬    «5}|j «|k(sJ‚    ddd«ddd«y#1swYŒxYw#1swYyxYw) NrÉr¿rÀÚbazÚquxú-,names
0,"['foo', 'bar']"
1,"['baz', 'qux']"
z str_test.csvÚasciirrr)rÚ    str_arrayr*Úexpected_asciirrs      r Útest_to_csv_string_array_asciiz(TestToCSV.test_to_csv_string_array_ascii‰sž€à  u˜~Ð.°¸5À%¸.Ð0IÐJˆ    Ü yÓ !ˆðˆô
_‰_˜^Ó ,ð    2°Ø I‰Id WˆIÔ -ܐd WÔ-ð 2°Ø—v‘v“x >Ò1Ð1Ñ1÷ 2÷    2ð    2÷ 2ð 2ú÷    2ð    2úó#¯!BÁA8Á'BÁ8B    Á=BÂB có —dddgidddgig}t|«}d}tjd«5}|j|d¬    «t    |d¬    «5}|j «|k(sJ‚    ddd«ddd«y#1swYŒxYw#1swYyxYw)
NrÉr¿rÀrÕrÖr×zunicode_test.csvrrr)rrÙr*Ú expected_utf8rrs      r Útest_to_csv_string_array_utf8z'TestToCSV.test_to_csv_string_array_utf8—sŸ€à  u˜~Ð.°¸5À%¸.Ð0IÐJˆ    Ü yÓ !ˆðˆ ô
_‰_Ð/Ó 0ð    1°DØ I‰Id WˆIÔ -ܐd WÔ-ð 1°Ø—v‘v“x =Ò0Ð0Ñ0÷ 1÷    1ð    1÷ 1ð 1ú÷    1ð    1úrÜcó\—gd¢gd¢dœ}t|«}tjd«5}tjj d«}d|zdz|zdz|zd    z|z}|j |d
¬ «t|d «5}|j«|k(sJ‚    ddd«ddd«tjd«5}d }|j |dd
¬«t|d «5}|j«|k(sJ‚    ddd«ddd«tjd«5}d}|j |dd
¬«t|d «5}|j«|k(sJ‚    ddd«ddd«y#1swYŒÐxYw#1swYŒÔxYw#1swYŒ‰xYw#1swYŒxYw#1swYŒBxYw#1swYyxYw)N©r r-rA)Úabczd
efzg
h
 
i)ÚintÚstr_lfz lf_test.csvrs
int,str_lfó1,abcs2,"d
ef"s
3,"g
h
 
i"Fr›Úrbs%int,str_lf
1,abc
2,"d
ef"
3,"g
h
 
i"
rΩrÏrs)int,str_lf
1,abc
2,"d
ef"
3,"g
h
 
i"
ú
©    rrrÚosÚlinesepÚencoderrr©    rrÌr*rÚ
os_linesepÚexpected_noargrÚ expected_lfÚ expected_crlfs             r Útest_to_csv_string_with_lfz$TestToCSV.test_to_csv_string_with_lf¥sÈ€â Ò,IÑJˆÜ t‹_ˆÜ _‰_˜]Ó +ð    2¨t䟙×*Ñ*¨7Ó3ˆJàØñàñðñðñ    ð
ñ ð #ñ #ðñð ð I‰Id %ˆIÔ (ܐd˜DÓ!ð 2 QØ—v‘v“x >Ò1Ð1Ñ1÷ 2÷    2ô _‰_˜]Ó +ð    /¨tàJˆKØ I‰Id¨4°uˆIÔ =ܐd˜DÓ!ð / QØ—v‘v“x ;Ò.Ð.Ñ.÷ /÷        /ô _‰_˜]Ó +ð    1¨tðUˆMØ I‰Id¨6¸ˆIÔ ?ܐd˜DÓ!ð 1 QØ—v‘v“x =Ò0Ð0Ñ0÷ 1÷     1ð    1÷ 2ð 2ú÷    2ð    2ú÷( /ð /ú÷        /ð    /ú÷ 1ð 1ú÷     1ð    1úólªAE2ÂE&ÂE2Â<#F
ÃE>Ã6F
Ä#F"Ä>FÅF"Å&E/    Å+E2Å2E;Å>F    ÆF
FÆF    ÆF"Æ"F+có\—gd¢gd¢dœ}t|«}tjd«5}tjj d«}d|zdz|zdz|zd    z|z}|j |d
¬ «t|d «5}|j«|k(sJ‚    ddd«ddd«tjd«5}d }|j |dd
¬«t|d «5}|j«|k(sJ‚    ddd«ddd«tjd«5}d}|j |dd
¬«t|d «5}|j«|k(sJ‚    ddd«ddd«y#1swYŒÐxYw#1swYŒÔxYw#1swYŒ‰xYw#1swYŒxYw#1swYŒBxYw#1swYyxYw)Nrá)râzd
efz    g
h
 
i)rãÚstr_crlfz crlf_test.csvrs int,str_crlfrås    2,"d
ef"s 3,"g
h
 
i"Fr›ræs+int,str_crlf
1,abc
2,"d
ef"
3,"g
h
 
i"
rÎrçs/int,str_crlf
1,abc
2,"d
ef"
3,"g
h
 
i"
rèrérís             r Útest_to_csv_string_with_crlfz&TestToCSV.test_to_csv_string_with_crlfÇsÌ€â Ò.SÑTˆÜ t‹_ˆÜ _‰_˜_Ó -ð    2°äŸ™×*Ñ*¨7Ó3ˆJàØñàñðñð!ñ    !ð
ñ ð )ñ )ðñð ð I‰Id %ˆIÔ (ܐd˜DÓ!ð 2 QØ—v‘v“x >Ò1Ð1Ñ1÷ 2÷    2ô _‰_˜_Ó -ð    /°àTˆKØ I‰Id¨4°uˆIÔ =ܐd˜DÓ!ð / QØ—v‘v“x ;Ò.Ð.Ñ.÷ /÷        /ô _‰_˜_Ó -ð     1°ð+ð ð I‰Id¨6¸ˆIÔ ?ܐd˜DÓ!ð 1 QØ—v‘v“x =Ò0Ð0Ñ0÷ 1÷     1ð     1÷ 2ð 2ú÷    2ð    2ú÷( /ð /ú÷        /ð    /ú÷  1ð 1ú÷     1ð     1úrócó—tddgddggddg¬«}gd¢}tj|«}|jtj
d    ¬
«|j «}|j|k(sJ‚tj
jrJ‚y) Nr¿rÀrÕrÖÚname_1Úname_2rº)z,name_1,name_2z    0,foo,barz    1,baz,quxrØr)    rrrErÚsysÚstdoutÚ
readouterrÚoutÚclosed)rÚcapsysr*rGrÚÚcaptureds      r Útest_to_csv_stdout_filez!TestToCSV.test_to_csv_stdout_fileîs€ä ˜ ˜¨°¨Ð7À(ÈHÐAUÔ VˆÚDˆ Ü×8Ñ8¸ÓGˆà
    ‰    ”#—*‘* wˆ    Ô/Ø×$Ñ$Ó&ˆà|‰|˜~Ò-Ð-Ð-Ü—:‘:×$Ò$Ð$Ð$Ð$rIz–Especially in Windows, file stream should not be passedto csv writer without newline='' option.(https://docs.python.org/3/library/csv.html#csv.writer))Úreasoncóz—tdgd¢i«}d}tjd«5}t|dd¬«5}|j    d«|j |dd¬    «ddd«t|d¬«5}|j «|k(sJ‚    ddd«ddd«y#1swYŒ>xYw#1swYŒxYw#1swYyxYw)
NrK©rÆrÊÚzzmanual header
x
y
z
útest.txtÚwrrúmanual header
r )rrrrÚwriterrr6s     r Útest_to_csv_write_to_open_filez(TestToCSV.test_to_csv_write_to_open_fileús½€ô˜š_Ð-Ó .ˆðˆô _‰_˜ZÓ (ð    ,¨Dܐd˜C¨'Ô2ð 6°aØ—‘Ð)Ô*Ø—    ‘    ˜! D°    Ô5÷ 6ôd WÔ-ð ,°Ø—v‘v“x 8Ò+Ð+Ñ+÷ ,÷        ,ð    ,÷ 6ð 6ú÷ ,ð ,ú÷        ,ð    ,ús:§B1¶&BÁB1Á1B%ÂB1ÂB"    ÂB1Â%B.    Â*B1Â1B:có—tdgd¢i«}gd¢}dtj|«z}tjd«5}t    |ddd¬«5}|j d«|j |dd¬    «ddd«t    |d
«5}|j«t|d«k(sJ‚    ddd«ddd«y#1swYŒGxYw#1swYŒxYw#1swYyxYw) NrKrrrrÚr)Únewlinerr ræ)    rrrErrr    rrÚbytes)rr*rGr7rrs      r Ú/test_to_csv_write_to_open_file_with_newline_py3z9TestToCSV.test_to_csv_write_to_open_file_with_newline_py3s׀ô˜š_Ð-Ó .ˆÚ'ˆ Ø$¤r×'FÑ'FÀ}Ó'UÑUˆÜ _‰_˜ZÓ (ð    <¨Dܐd˜C¨°gÔ>ð 6À!Ø—‘Ð)Ô*Ø—    ‘    ˜! D°    Ô5÷ 6ôd˜DÓ!ð < QØ—v‘v“x¤5¨°7Ó#;Ò;Ð;Ñ;÷ <÷     <ð    <÷ 6ð 6ú÷ <ð <ú÷     <ð    <ús<ÁCÁ&B=Á7C  C    Â,CÂ=C    ÃCà   C    ÃCÃCÚto_inferTFÚ
read_infercó&—|}d}|||z }tddgi«}|rdn|}|rdn|}    tj|«5}
|j|
|¬«t    j
|
d|    ¬«} tj | |«ddd«y#1swYyxYw)Nztest.rzr Úinfer©Ú compressionr)r&r)rrrrr(r)r') rÚcompression_onlyrrÚcompression_to_extensionrÚfilenamer*Úto_compressionÚread_compressionrrµs             r Útest_to_csv_compressionz!TestToCSV.test_to_csv_compression s™€ð 'ˆ ðˆØÐ,¨[Ñ9Ñ9ˆä ˜˜a˜SzÓ "ˆá$,™°+ˆÙ&0™7°kÐä _‰_˜XÓ &ð    .¨$Ø I‰Id¨ˆIÔ 7Ü—[‘[ °Ð@PÔQˆFÜ × !Ñ ! &¨"Ô -÷    .÷    .ñ    .ús ¼ABÂBcó4—|}tddgi«}d}dddœj||«}||z }tj|«5}|j    |d|i¬«t j |d    ¬
«}tj||«ddd«y#1swYyxYw) NÚABCr zto_csv_compress_as_dict.ÚgzÚzst)ÚgzipÚzstdÚmethodrrr%)rÚgetrrrr(r)r')rrr"r*rÚ    extensionrÚread_dfs        r Útest_to_csv_compression_dictz&TestToCSV.test_to_csv_compression_dict6sž€à!ˆÜ ˜ ˜s|Ó $ˆØ-ˆàØñ
÷ ‰#ˆffÓ
ð    ð    IÑˆÜ _‰_˜XÓ &ð    /¨$Ø I‰Id¨°6Ð(:ˆIÔ ;Ü—k‘k $°!Ô4ˆGÜ × !Ñ ! '¨2Ô .÷    /÷    /ñ    /ús ÁABÂBcó—tddgi«}ddi}d}tjd«5}tjt
|¬«5|j ||¬«ddd«ddd«y#1swYŒxYw#1swYyxYw)    Nrr Ú some_optionTzmust have key 'method'zout.zipr1r)rrrr3r4Ú
ValueErrorr)rr*rÚmsgrs     r Ú-test_to_csv_compression_dict_no_method_raisesz7TestToCSV.test_to_csv_compression_dict_no_method_raisesEs|€ä ˜ ˜s|Ó $ˆØ$ dÐ+ˆ Ø&ˆä _‰_˜YÓ 'ð    9¨4Ü—‘œz°Ô5ñ 9Ø—    ‘    ˜$¨K    Ô8÷ 9÷    9ð    9÷ 9ð 9ú÷    9ð    9ús#ªA7ÁA+ÁA7Á+A4    Á0A7Á7BrÚziprÚ archive_nameztest_to_csv.csvztest_to_csv.zipcóV—tddgi«}tjd«5}|j|||dœ¬«t    |«5}t |j «dk(sJ‚|j dj}||k(sJ‚    ddd«ddd«y#1swYŒxYw#1swYyxYw)Nrr zto_csv_archive_name.zip)r"r-rr)rrrrrÚlenÚfilelistr)rrr-r*rÚzpÚ archived_files       r Útest_to_csv_zip_argumentsz#TestToCSV.test_to_csv_zip_argumentsOs°€ô˜ ˜s|Ó $ˆÜ _‰_Ð6Ó 7ð    5¸4Ø I‰Iب[È,Ñ"Wð ô ô˜“ð 5 "ܘ2Ÿ;™;Ó'¨1Ò,Ð,Ð,Ø "§ ¡ ¨A¡× 7Ñ 7 Ø$¨ Ò4Ð4Ñ4÷ 5÷        5ð    5÷ 5ð 5ú÷        5ð    5ús#¤"BÁ;BÂBÂB    ÂBÂB(zfilename,expected_arcname))ú archive.csvr4)ú archive.tsvr5)zarchive.csv.zipr4)zarchive.tsv.zipr5)z archive.zipÚarchivecó—tddgi«}||z }|j|d¬«t|«5}t|j«dk(sJ‚|jdj
}||k(sJ‚    ddd«y#1swYyxYw)Nrr r,rr)rrrr/r0r)rÚtmp_pathrÚexpected_arcnamer*rr1r2s        r Útest_to_csv_zip_infer_namez$TestToCSV.test_to_csv_zip_infer_name]s…€ô˜ ˜s|Ó $ˆØ˜(Ñ"ˆØ
    ‰    $ Eˆ    Ô*Ü T‹]ð    5˜bܐr—{‘{Ó# qÒ(Ð (Ð(ØŸK™K¨™N×3Ñ3ˆMØ Ð$4Ò4Ð 4Ñ4÷    5÷    5ñ    5ús ²;A7Á7BÚ df_new_typeÚInt64có—tdtd«gdzi«}|j|«}gd¢}tj|«}|j ddd¬«}||k(sJ‚y)    Nr[rorA)r[Úmynullr>r>Fr>rØ)rrjr)rÚfloatr§rrEr)rr;r*rGr7rµs      r Útest_to_csv_na_rep_long_stringz(TestToCSV.test_to_csv_na_rep_long_stringqsc€ô˜œe E›l˜^¨aÑ/Ð0Ó 1ˆØ Y‰Y{Ó #ˆÚ;ˆ Ü×2Ñ2°=ÓAˆà—‘ ¨xÀ'ÓJˆà˜6Ò!Ð!Ñ!rIcóú—tjddg«jd«}tj«}|j |«|j «}gd¢}tj|«}||k(sJ‚y)Nr ztimedelta64[ns])rmz0,0 days 00:00:00.000000001z1,0 days 00:00:00.000000001)    r(rpr§ÚioÚStringIOrÚgetvaluerrE)rr}ÚbufrµrGr7s      r Útest_to_csv_timedelta_precisionz)TestToCSV.test_to_csv_timedelta_precision}sh€ä I‰Iq˜!fÓ × $Ñ $Ð%6Ó 7ˆÜk‰k‹mˆØ    ‰Œ Ø—‘“ˆò
ˆ ô
×2Ñ2°=ÓAˆØ˜Ò!Ð!Ñ!rIcó²—tjtdd««jd¬«}t    j
gd¢«}||k(sJ‚tjddg«jd¬«}t    j
gd    ¢«}||k(sJ‚tjd
d g«jd ¬«}t    j
gd ¢«}||k(sJ‚y)Néé ú-ri)rmz0,8z1,9z2,10z3,11TFro)rmz0,Truez1,FalserVrWú.)rmz0,1.1z1,2.2)r(rpÚrangerrrE)rrµr7s   r Útest_na_rep_truncatedzTestToCSV.test_na_rep_truncated‹sÁ€ä—‘œ5  B›<Ó(×/Ñ/°sÐ/Ó;ˆÜ×2Ñ2Ò3WÓXˆØ˜Ò!Ð!Ð!ä—‘˜D %˜=Ó)×0Ñ0¸Ð0Ó>ˆÜ×2Ñ2Ò3NÓOˆØ˜Ò!Ð!Ð!ä—‘˜C ˜:Ó&×-Ñ-°SÐ-Ó9ˆÜ×2Ñ2Ò3KÓLˆØ˜Ò!Ð!Ñ!rIÚerrors)Ú surrogatepassÚignoreÚreplacecóڗdg}tj|t|t¬«t¬«}t    j
d«5}|j ||¬«ddd«y#1swYyxYw)Nuí €fooru)rrvr )rN)r(rprÚobjectrrr)rrNrÌrªrs     r Útest_to_csv_errorszTestToCSV.test_to_csv_errors™sW€ðˆ}ˆÜi‰i˜¤E¨$´fÔ$=ÄVÔLˆÜ _‰_˜ZÓ (ð    ,¨DØ J‰Jt FˆJÔ +÷    ,÷    ,ñ    ,ús ÁA!Á!A*ÚmodeÚwbrc óð—tdtjd«jd«zt    t d««t    t d«Dcgc]}d|›‘Œ    c}«¬«}tj«5}t|d¬    «5}|j||¬    «d
d
d
«tj|tj|d ¬ ««d
d
d
«y
cc}w#1swYŒBxYw#1swYy
xYw) z•
        Binary file objects should work (if 'mode' contains a 'b') or even without
        it in most cases.
 
        GH 35058 and GH 19827
        rVéx©ééÚABCDrZúi-r¾úw+b)rUNrr%)rrnÚarangeÚreshaperÚlistrLrrrrr'r(r))rrUÚir*rÚhandles      r Útest_to_csv_binary_handlez#TestToCSV.test_to_csv_binary_handle£sЀôØ ”"—)‘)˜C“.×(Ñ(¨Ó1Ñ 1Üœ$˜v›,Ó'ܬ5°«9Ö5 a˜2˜a˜SšÒ5Ó6ô
ˆô
_‰_Ó ð    F $ܐd Ô'ð -¨6Ø—    ‘    ˜& t    Ô,÷ -ä × !Ñ ! "¤b§k¡k°$À!Ô&DÔ E÷    Fð    Fùò6÷ -ð -ú÷    Fð    Fús*Á CÁ=C, C Â3C,àC)    Ã%C,Ã,C5cóf—djd«}tj|«}tj|d¬«}tj«}|j ||dd¬«|j d«|j«j|«sJ‚tj«5}t|d«5}t«j ||d¬«|j d«|j«jd    «sJ‚    d
d
d
«d
d
d
«y
#1swYŒxYw#1swYy
xYw) z{
        Binary file objects should honor a specified encoding.
 
        GH 23854 and GH 13068 with binary handles
        u
a, b, ðŸŸz    utf-8-sigrF)rUrrrr^)rUrs""N)rìrBÚBytesIOr(r)rÚseekrDÚ
startswithrrrrr)rrUÚcontentÚbufferr*rrcs       r Ú"test_to_csv_encoding_binary_handlez,TestToCSV.test_to_csv_encoding_binary_handleµs€ð×%Ñ% kÓ2ˆÜ—‘˜GÓ$ˆÜ [‰[˜¨+Ô 6ˆä—‘“ˆØ
    ‰    &˜t¨kÀˆ    ÔG؏ ‰ AŒØ‰Ó ×+Ñ+¨GÔ4Ð4Ð4ô_‰_Ó ð    C $ܐd˜EÓ"ð C fÜ“ ×"Ñ" 6°¸{Ð"ÔKà— ‘ ˜A”Ø—{‘{“}×/Ñ/Ð0AÔBÐBÑB÷     C÷    Cð    C÷ Cð Cú÷    Cð    Cús%Â- D'Â:ADÄ
D'ÄD$    Ä D'Ä'D0N).Ú__name__Ú
__module__Ú __qualname__r!r+r8r>rBrHrcrersrxr–rr«r¶r¸rÅr3ÚmarkÚ parametrizer(rÁrÓrÛrßròrörÚxfailrÚis_platform_windowsr
rrr&r+r3r:r@rFrMrTrdrk©rIr r    r    s°„ò-ò8Fò;ò83ò",ò2'ò "HòH
Pòò>ò=Xò~2ò  Kò"ò"ò"-ðH ‡[[×ÑØð— ‘  s e W°a°S°EÀ#ÀÔGØ!ð ð
— ‘ Ø ˜E C 5˜>°1°#¸°s°ÀCÈÀ:ôð(ð     ð     
óñ"óð"ò 2ò 1ò 1òD%1òN
%ð ‡[[×ÑØ"ˆ×"Ñ"Ó$ð Fðóñ,óð,ò  <ð ‡[[×јZ¨$°¨Ó7Ø ‡[[×ј\¨D°%¨=Ó9ñ.ó:ó8ð.ò( /ò9ð ‡[[×ј]¨U°GÐ,<Ó=Ø ‡[[×ј^Ð.?ÐARÐ-SÓTñ
5óUó>ð
5ð ‡[[×ÑØ#ò    
ó    ñ5ó    ð5ð ‡[[×ј]¨W¨IÓ6ñ    "ó7ð    "ò "ò "ð ‡[[×јXÒ'MÓNñ,óOð,ð ‡[[×јV d¨C [Ó1ñFó2ðFð" ‡[[×јV d¨C [Ó1ñCó2ñCrIr    c ó°—tdtjd«jd«zt    t d««t    t d«Dcgc]}d|›‘Œ    c}«¬«}tj«5}|j||d¬    «tjtj||d
¬ «|«ddd«ycc}w#1swYyxYw© NrVrXrYr\rZr]r¾r )rÚ    chunksizer)rr&) rrnr_r`rrarLrrrr'r(r))rrbr*rs    r Ú&test_to_csv_iterative_compression_namerwÏs¯€ä    Ø Œbi‰i˜‹n×$Ñ$ WÓ-Ñ-Ü”d˜6“lÓ#ܤu¨R£yÖ1 !r˜!˜’XÒ1Ó2ô
€Bô
 
‰Ó    ð
˜dØ
    ‰    $ K¸1ˆ    Ô=Ü
×ÑÜ K‰K˜¨+ÀÔ CÀRô    
÷
ð
ùò2÷
ð
úsÁ CÁ=AC à Cc óð—tdtjd«jd«zt    t d««t    t d«Dcgc]}d|›‘Œ    c}«¬«}tj«5}|j||d¬    «|jd
«tjtj||d
¬ «|«|jrJ‚    ddd«ycc}w#1swYyxYwru)rrnr_r`rrarLrBrfrrgrr'r(r)rþ)rrbr*rjs    r Ú(test_to_csv_iterative_compression_bufferryÝsʀ䠠  Ø Œbi‰i˜‹n×$Ñ$ WÓ-Ñ-Ü”d˜6“lÓ#ܤu¨R£yÖ1 !r˜!˜’XÒ1Ó2ô
€Bô
 
‰‹ð!˜Ø
    ‰    & k¸Qˆ    Ô?؏ ‰ AŒÜ
×ÑÜ K‰K˜¨KÀ1Ô EÀrô    
ð—=’=РР=÷ !ð!ùò2÷!ð!úsÁ C'Á=A C,Ã,C5cóҗtdgd¢i«}d}tjt|¬«5t    j
«}|j |d«ddd«y#1swYyxYw)NrKráztStarting with pandas version 3.0 all arguments of to_csv except for the argument 'path_or_buf' will be keyword-only.r1rP)rrÚassert_produces_warningÚ FutureWarningrBrfr)r*r*rjs   r Ú test_to_csv_pos_args_deprecationr}ís[€ä    CšÐ#Ó    $€Bð    8ðô
×    #Ñ    #¤M¸Ô    =ñÜ—‘“ˆØ
    ‰    &˜#Ô÷÷ñús ­'AÁA&)rBrêrúÚzipfilerÚ_csvrÚnumpyrnr3Úpandasr(rrrÚpandas._testingÚ_testingrr    rwryr}rsrIr ú<module>r„sJðÛ    Û    Û
ÝåÛÛ ã÷ñõ
÷y
Cñy
Còx 
ò !ó     rI