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
Ë
oñúhú,ãó—dZddlmZddlZddlZddlmZmZm    Z    ddl
m Z ejjd«Zejj!d«Zejj!d«Zejj'dd    d
g«d „«Zd „Zd „Zed„«Zeejj'dddgd¢ifd
dgd¢ifdddgegd¬«dœfdddgegd¬«dœfdddgegd¬«dœfdddgegd¬«dœfddgdge    j0ggdzddg¬«dœfddgdge    j0ggdzddg¬«dœfddgdge    j0ggdzddg¬«dœfddgdge    j0ggdzddg¬«dœfg
«d„««Zed„«Zejj'dddgddgddgddgd d!gg«d"„«Zed#„«Zed$„«Zed%„«Zejj>d&„«Z ed'„«Z!ed(„«Z"ed)„«Z#ed*„«Z$ed+„«Z%ejj'd,e&d-fd.g«d/„«Z'ed0„«Z(y)1z—
Tests that the specified index column (a.k.a "index_col")
is properly handled or inferred during parsing for all of
the parsers defined in parsers.py
é)ÚStringION)Ú    DataFrameÚIndexÚ
MultiIndexz=ignore:Passing a BlockManager to DataFrame:DeprecationWarningÚ pyarrow_xfailÚ pyarrow_skipÚ with_headerTFcóz—|}d}d}|rc||z}|jt|«d¬«}|jt|«d¬«jd«}tj||«y|}d}t j t|¬«5|jt|«d¬«ddd«y#1swYyxYw)    NaÑKORD1,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD2,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD3,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD4,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD5,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
KORD6,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000zBID,date,NominalTime,ActualTime,TDew,TAir,Windspeed,Precip,WindDir
ÚID©Ú    index_colr©ÚheaderzIndex ID invalid©Úmatch)Úread_csvrÚ    set_indexÚtmÚassert_frame_equalÚpytestÚraisesÚ
ValueError)    Ú all_parsersr    ÚparserÚ    no_headerrÚdataÚresultÚexpectedÚmsgs             úXH:\Change_password\venv_build\Lib\site-packages\pandas/tests/io/parser/test_index_col.pyÚtest_index_col_namedr!s¬€à €FðQ€IðS€FáØ˜    Ñ!ˆà—‘¤¨$£¸4Ó@ˆØ—?‘?¤8¨D£>¸!?Ó<×FÑFÀtÓLˆÜ
×јf hÕ/àˆØ ˆä ]‰]œ:¨SÔ 1ñ    <Ø O‰OœH T›N°dˆOÔ ;÷    <÷    <ñ    <ús  B1Â1B:cóʗ|}d}tgd¢gd¢gd¢gd¢dœtgd¢d¬    «¬
«}gd ¢}|jt|«|dg¬ «}t    j
||«y) Nz+1,2,3,4,hello
5,6,7,8,world
9,10,11,12,foo
)ééé    )ééé
)ééé )ééé )ÚaÚbÚcÚd)ÚhelloÚworldÚfooÚmessage©Úname©Úindex)r/r0r1r2r6)Únamesr )rrrrrr)rrrrr;rs      r Útest_index_col_named2r<4sb€Ø €Fð €Dô ÚšjªzÂ
ÑKÜÒ-°IÔ>ô€Hò ,€Eà _‰_œX d›^°5ÀYÀKˆ_Ó P€FÜ×ј& (Õ+ócó¨—d}|}d}tjt|¬«5|jt    |«d¬«ddd«y#1swYyxYw)Nza,b
1,2z)The value of index_col couldn't be 'True'rTr )rrrrr)rrrrs    r Útest_index_col_is_truer?FsH€à €DØ €Fà
5€CÜ    ‰”z¨Ô    -ñ8؏‰œ ›°$ˆÔ7÷8÷8ñ8ús ¢AÁAcó¢—d}|}|jt|««}tgd¢gd¢gd¢ggd¢gd¢¬«}tj||«y)Nz$A,B,C
foo,1,2,3
bar,4,5,6
baz,7,8,9
)r#r&r))r,r$r')r*r-r%)r5ÚbarÚbaz)ÚAÚBÚC©r:Úcolumns©rrrrr©rrrrrs     r Útest_infer_index_colrJPsN€ð €Dð
€FØ _‰_œX d›^Ó ,€FäÚ    ’IšyÐ)Ú#Úô€Hô
×ј& (Õ+r=zindex_col,kwargsrG©ÚxÚyÚzrMrNrLr7©rGr:r#r&©r;có†—d}|}|jt|«|¬«}tdi|¤Ž}tj||«y)Nzx,y,zr ©rH)rr Úkwargsrrrrs       r Útest_index_col_empty_datarTbsB€ðR €DØ €FØ _‰_œX d›^°yˆ_Ó A€FäÑ"˜6Ñ"€HÜ×ј& (Õ+r=cóŒ—d}|}|jt|«d¬«}tddg¬«}tj||«y)Nzx,yFr rLrM©rGrHrIs     r Útest_empty_with_index_col_falserW“sB€ð €DØ €FØ _‰_œX d›^°uˆ_Ó =€Fä # s Ô,€HÜ×ј& (Õ+r=Ú index_namesÚr5rAÚNotReallyUnnamedz
Unnamed: 0cóÆ—|}|jdk(r5d|vr1tjjd¬«}|j    |«dj |dgz«}|j t|«ddg¬    «}td
gd ¢itjd d gddgg«¬«}|Dcgc]}|r|nd‘Œ
c}|j_ tj||«ycc}w)NÚpyarrowrYz!One case raises, others are wrong©Úreasonú,zcol
a,c,1
a,d,2
b,c,3
b,d,4rr#r Úcol©r#r&r)r,r/r0r1r2r9)ÚenginerÚmarkÚxfailÚ applymarkerÚjoinrrrrÚ from_productr:r;rr)    rrXÚrequestrrcrrrr8s             r Útest_multi_index_namingrižsڀð€Fà ‡}}˜    Ò! b¨KÑ&7܏{‰{× Ñ Ð(KРÓLˆØ×јDÔ!ð 8‰8KÐ#DÐ"EÑEÓ F€DØ _‰_œX d›^¸¸1°vˆ_Ó >€F䨠   ’ ФZ×%<Ñ%<¸sÀC¸jÈ3ÐPSÈ*Ð=UÓ%Vô€Hð@KÖK°t¡D™D¨dÑ2ÒK€H‡NNÔÜ×ј& (Õ+ùòLsÂ( Cc    óė|}d}|jt|«ddg¬«}tdgd¢itddggd    ¢ggd
¢gd ¢g¬ «¬ «}t    j
||«y)Nz$,Unnamed: 2,
a,c,1
a,d,2
b,c,3
b,d,4rr&r z
Unnamed: 2)r1r2r1r2r/r0ra)rrr#r#)rr#r&r))ÚlevelsÚcodesr9)rrrrrr)rrrrrs     r Ú,test_multi_index_naming_not_all_at_beginningrmºsf€à €FØ 5€DØ _‰_œX d›^¸¸1°vˆ_Ó >€F䨠   Ò+Ð,ÜØ˜#J¢ Ð-²lÂLÐ5Qô
ô€Hô ×ј& (Õ+r=cóx—|}tjgd¢«}ttjj d«j d«|gd¢¬«}tj«5}|j|«|j|gd¢¬«}ddd«tj|«y#1swYŒ xYw)N)©rCr#r&ro)rDr#r&r&)r)r)rKrF)rr#r&r ) rÚ from_tuplesrÚnpÚrandomÚ default_rngÚstandard_normalrÚ ensure_cleanÚto_csvrr)rrÚmidxrÚpathrs      r Ú%test_no_multi_index_level_names_emptyryÉsš€ð€FÜ × !Ñ !Ò"IÓ J€DÜÜ
    ‰    ×јaÓ ×0Ñ0°Ó8ØÚô€Hô
 
‰Ó    ð<˜d؏‰˜ÔØ—‘ ²Ó;ˆ÷<ô×ј& (Õ+÷<ð<ús Á*'B0Â0B9có¬—|}d}tjddgddg¬«}tdg«}tdd    gg||¬
«}|j    t |«d d dg¬ «}t j||«td dg«}tddgd¬«}tddgddgg||¬
«}|j    t |«dd ¬ «}t j||«y)Nz
I11,A,A
I12,B,B
I2,1,3
)rCrD)rCzB.1ÚI11ÚI12rPÚI2r#r)rFr)r rrCzA.1r7rDÚ1Ú3)rrprrrrrr)rrrrwÚidxrrÚcol_idxs        r Útest_header_with_index_colr‚Ùsـð€Fð €Dô
× !Ñ ! :¨|Ð"<ÀUÈEÀNÔ S€DÜ
‹-€Cܘ1˜a˜&˜¨°dÔ;€Hà _‰_œX d›^°qÀ!ÀQÀˆ_Ó H€FÜ×ј& (Ô+äS˜%LÓ!€GÜ
˜  EÔ
*€Cܘ3 ˜* s¨C jÐ1¸ÀgÔN€Hà _‰_œX d›^°uÀQˆ_Ó G€FÜ×ј& (Õ+r=cóö—|}d}tt|dz«tjj    d«j |dz«dœ«}t j«5}|j|d¬«|j«5}|jd|«|j|dg¬    «}ddd«ddd«t j|jd
««y#1swYŒ7xYw#1swYŒ;xYw) Nédr#r&©r/r0Fr9z,pandas.core.algorithms._MINIMUM_COMP_ARR_LENrr r/)rÚrangerqrrrsrtrrurvÚcontextÚsetattrrrr)rÚ monkeypatchrÚARR_LENÚdfrxÚmrs        r Útest_index_col_large_csvrñsހð€Fà€GÜ    äw ‘{Ó#Ü—‘×&Ñ& qÓ)×9Ñ9¸'ÀA¹+ÓFñ    
ó
€Bô
‰Ó    ð:˜dØ
    ‰    $˜eˆ    Ô$Ø ×  Ñ  Ó "ð    : aØ I‰IÐDÀgÔ NØ—_‘_ T°a°S_Ó9ˆF÷    :÷:ô ×ј& "§,¡,¨sÓ"3Õ4÷        :ð    :ú÷:ð:ús$Á"$C/Â'C#Â-C/Ã#C,    Ã(C/Ã/C8c    óڗ|}|jtd«ddgd¬«}tgtg«t    j
ddgddggd    d
g¬ «¬ «}t j||«y) Núa0,a1,a2
b0,b1,b2
rr#©rr Úa1Úa2Úb1Úb2Úa0Úb0rPrF)rrrrrÚ from_arraysrr©rrrrs    r Ú)test_index_col_multiindex_columns_no_datar™sy€ð€FØ _‰_ÜÐ'Ó(°!°Q°À1ðó€FôØ
ܐB‹iÜ×&Ñ&ؐDˆ\˜D $˜<Ð (°°t° ô
ô€Hô×ј& (Õ+r=có¦—|}|jtd«dgd¬«}tgddgtgd¬«¬«}t    j
||«y)    Nz    a0,a1,a2
rrr‘r’r•r7rO)rrrrrrr˜s    r Útest_index_col_header_no_datar›sT€ð€FØ _‰_œX lÓ3¸Q¸CÈ1ˆ_Ó M€FÜØ
ؐt ܐB˜TÔ"ô€Hô
×ј& (Õ+r=có¼—|}|jtd«ddg¬«}tgtjgd¢gd¢g«¬«}t j ||«y)Nrrr#r)r•r‘r’)r–r“r”rV)rrrrr—rrr˜s    r Útest_multiindex_columns_no_datar%sX€ð€FØ _‰_œXÐ&<Ó=ÀqÈ!Àfˆ_Ó M€FÜØ
”J×*Ñ*Ò,>Ò@RÐ+SÓTô€Hô×ј& (Õ+r=cóâ—|}|jtd«ddgd¬«}tddggtjddgdd    ggd
d g¬ «t dg«¬ «}t j||«y)Nz a0,a1,a2
b0,b1,b2
data,data,datarr#rrr‘r’r“r”r•r–rPrO)rrrrr—rrrr˜s    r Ú+test_multiindex_columns_index_col_with_datarŸ0s†€ð€FØ _‰_ÜÐ5Ó6ÀÀ1¸vÐQRðó€FôØ
&Р   ÐÜ×&Ñ&ؐDˆ\˜D $˜<Ð (°°t° ô
ôVH‹oô €Hô×ј& (Õ+r=có¾—|}|jtd«ddgdgddi¬«}tdgdgdœ¬    «jd«}t    j
||d
¬ «y) Nz0,1r/r0ÚUInt8)r;r Údtyperr#r…)rF)Úcheck_index_type)rrrrrrr˜s    r Útest_infer_types_boolean_sumr¤Asz€ð€FØ _‰_ܐ‹ØCˆjؐ%ؐGˆnð    ó€Fô ðððñ    
ô÷iƒnð ô×ј& (¸UÖCr=z
dtype, valÚ01)Úint64r#có>—d}|}|tk(r>|jdk(r/|jtjj d¬««|j t|«dd|i¬«}tddgit|gd|¬    «¬
«}tj||«y) Nza,b
01,2r\z0Cannot disable type-inference for pyarrow enginer]r/)r r¢r0r&)r8r¢r9) Úobjectrbrerrcrdrrrrrr)rr¢Úvalrhrrrrs        r Ú test_specify_dtype_for_index_colrªYs€ð €DØ €FØ ”‚˜6Ÿ=™=¨IÒ5Ø×ÑÜ K‰K× Ñ Ð%WÐ Ó Xô    
ð_‰_œX d›^°sÀ3ÈÀ,ˆ_Ó O€Fܘ# ˜s˜¬5°#°¸SÈÔ+NÔO€HÜ×ј& (Õ+r=cóЗ|}d}|jt|«ddgd¬«}tjgd¢ddg¬«}t    gd    ¢g|d
g¬ «}t j ||«y) Nza,b,c,d
e,f,g,h
x,y,1,2
rr#r))r/Úe)r1Úg)r2Úhr0ÚfrP)rLr#r&rMrO)rrrrprrr)rrrrÚcolsrs      r Ú-test_multiindex_columns_not_leading_index_colr±gsu€ð€Fð €Dð_‰_ܐ‹Ø1ˆvØðó€Fô
× !Ñ !Ú,°S¸#°Jô €Dôš+˜°¸S¸EÔB€HÜ×ј& (Õ+r=))Ú__doc__ÚiorÚnumpyrqrÚpandasrrrÚpandas._testingÚ_testingrrcÚfilterwarningsÚ
pytestmarkÚ usefixturesÚ xfail_pyarrowÚ skip_pyarrowÚ parametrizer!r<r?rJr—rTrWrirmryr‚Úslowrr™r›rrŸr¤r¨rªr±rRr=r ú<module>r¿sðñõ
ãÛ ÷ñõ
à [‰[× 'Ñ 'ØCó€
ð— ‘ ×'Ñ'¨Ó8€ ؏{‰{×&Ñ& ~Ó6€ ð‡×ј¨¨u¨ Ó6ñ<ó7ð<ò2,ò$8ðñ,óð,ð"؇×ÑØà         š?Ð+Ð,Ø    šOÐ,Ð-Ø    
˜˜c˜
©U°2¸CÔ-@Ñ AÐBØ    
˜˜c˜
©U°2¸CÔ-@Ñ AÐBØ     ˜3 ˜*©u°R¸cÔ/BÑCÐDØ     ˜3 ˜*©u°R¸cÔ/BÑCÐDà ˆFà˜5Ø/˜×/Ñ/°°°q±ÀÀcÀ
ÔKñ ð    
ð#ˆJà˜5Ø/˜×/Ñ/°°°q±ÀÀcÀ
ÔKñ ð    
ðˆFà˜5Ø/˜×/Ñ/°°°q±ÀÀcÀ
ÔKñ ð    
ð#ˆJà˜5Ø/˜×/Ñ/°°°q±ÀÀcÀ
ÔKñ ð    
ð9#ó&ñN,óO&óðP,ðñ,óð,ð‡×ÑØà     ˆRˆØ    ˆ Ø     ˆUˆ Ø    ˆØ    ˜\Ð*ð ó    ñ,ó    ð,ð$ñ ,óð ,ðñ ,óð ,ðñ,óð,ð.‡×Ññ5óð5ð*ñ ,óð ,ð ñ    ,óð    ,ðñ,óð,ðñ ,óð ,ð ñDóðDð.‡×ј¨°¨¸ Ð'EÓFñ
,óGð
,ðñ,óñ,r=