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
| Ë
| oñúhñ$ ã óð d Z ddlmZ ddlmZ ddlZddlZddlmZ ddl m
| Z
| m Z ddl m Z ej j! d« Zej j% d« Zeej j) d e ed
| « « d
| g« d « « Zed « Zed « Zej j) ddd dgi e
| g d¢g d¢gg d¢¬« fdddgd e
| g d¢gg d¢¬« fdddd gd e
| d d ggd d g¬« fg« ed! « « Zed" « Zej j) d#d$g d%¢g d&¢gfd'g d(¢g d)¢gfd*g d+¢g d,¢gfg« ed- « « Z eej j) d.g d/¢« d0 « « Z ed1 « Z eej j) d2i e
| d3d d4gi« fdd5gd6 e
| d5d d4gi« fg« d7 « « Z ed8 « Z ed9 « Z!ed: « Z"ed; « Z#ed< « Z$y)=zj
| Tests that skipped rows are properly handled during
| parsing for all of the parsers defined in parsers.py
| é )Údatetime)ÚStringION)ÚEmptyDataError)Ú DataFrameÚIndexÚ pyarrow_xfailz=ignore:Passing a BlockManager to DataFrame:DeprecationWarningÚskiprowsé c ó> | }d}|j t |« |d dd¬« }t t ddd« t ddd« t ddd« gd¬ « }t t j d
| d « j d « g d ¢|¬« }t j ||« y )Nzr#foo,a,b,c
| #foo,a,b,c
| #foo,a,b,c
| #foo,a,b,c
| #foo,a,b,c
| #foo,a,b,c
| 1/1/2000,1.,2.,3.
| 1/2/2000,4,5,6
| 1/3/2000,7,8,9
| r T©r ÚheaderÚ index_colÚ parse_dateséÐ é é é ©Únameç ð?ç $@©r r ©r r r ©ÚcolumnsÚindex©
| Úread_csvr r r r ÚnpÚarangeÚreshapeÚtmÚassert_frame_equal)Ú all_parsersr ÚparserÚtextÚresultr Úexpecteds úWH:\Change_password\venv_build\Lib\site-packages\pandas/tests/io/parser/test_skiprows.pyÚtest_skip_rows_bugr* s¤ ð Fð Dð __Ü °$À!ÐQUð ó Fô Ü $1Ó x¨¨a°Ó 3´X¸dÀAÀqÓ5IÐJÐQRô Eô Ü
| #tÓ ×$Ñ$ VÓ,²iÀuôHô ×Ñ& (Õ+ó c ó | }ddj t d« D cg c]7 }dj t |« t |dz « t |dz « g« 9 c}« z }ddj dD cg c]7 }dj t |« t |dz « t |dz « g« 9 c}« z }|j t |« dd g¬
| « }|j t |« « }t j ||« y c c}w c c}w ) Nza,b,c
| ú
| é
| ú,r r )r r r r é r
| é é r
| r1 ©r )ÚjoinÚrangeÚstrr r r" r# )r$ r% ÚiÚdataÚcondensed_datar' Úcondensed_results r) Útest_deep_skip_rowsr; 6 sê ð FØ tyyÜ=BÀ2»YÖG¸3q63q 1u:¤s¨1¨q©5£zÐ2Õ 3ÒGóñ D𠧡Ø=UÖV¸3q63q 1u:¤s¨1¨q©5£zÐ2Õ 3ÒVó"ñ Nð __X d^°q¸!°f_Ó =FØ ¤x°Ó'?Ó@ÐÜ×Ñ&Ð"2Õ3ùò Hùò Ws <D
| Á1<D
|
| c ó> | }d}|j t |« dd dd¬« }t t ddd« t ddd« t ddd « gd¬
| « }t t j d d « j d « g d¢|¬« }t j ||« y )Nz^#foo,a,b,c
| #foo,a,b,c
|
| #foo,a,b,c
| #foo,a,b,c
|
| 1/1/2000,1.,2.,3.
| 1/2/2000,4,5,6
| 1/3/2000,7,8,9
| r
| r Tr r r r r r r r r r r r )r$ r% r& r8 r r( s r) Útest_skip_rows_blankr= F s£ ð Fð Dð ??Ü ¨4¸1È$ð ó Dô Ü $1Ó x¨¨a°Ó 3´X¸dÀAÀqÓ5IÐJÐQRô Eô Ü
| #tÓ ×$Ñ$ VÓ,²iÀuôHô ×Ñ$ Õ)r+ zdata,kwargs,expectedzKid,text,num_lines
| 1,"line 11
| line 12",2
| 2,"line 21
| line 22",2
| 3,"line 31",1r )r zline 21
| line 22r )r zline 31r ©Úidr& Ú num_lines©r z+a,b,c
| ~a
| b~,~e
| d~,~f
| f~
| 1,2,~12
| 13
| 14~ú~r )Ú quotecharr )za
| bze
| dzf
| f)ÚaÚbÚczdText,url
| ~example
| sentence
| one~,url1
| ~example
| sentence
| two~,url2
| ~example
| sentence
| three~,url3r zexample
| sentence
| twoÚurl2ÚTextÚurlc ól | } |j t |« fi |¤}t j ||« y )N©r r r" r# )r$ r8 Úkwargsr( r% r' s r) Útest_skip_row_with_newlinerM a s3 ðH FØ V__X d^Ñ 6¨vÑ 6FÜ×Ñ& (Õ+r+ c ó | }d}g d¢g d¢g}t |g d¢¬« }|j t |« dg¬« }t j ||« y )NzYid,text,num_lines
| 1,"line '11' line 12",2
| 2,"line '21' line 22",2
| 3,"line '31' line 32",1)r zline '21' line 22r )r zline '31' line 32r r> rA r r3 ©r r r r" r# )r$ r% r8 Úexp_datar( r' s r) Útest_skip_row_with_quoterQ sR ð Fð Dò
| ,Ò-HÐIHÜÒ+FÔGHà __X d^°q°c_Ó :FÜ×Ñ& (Õ+r+ z data,exp_dataz\id,text,num_lines
| 1,"line
| '11' line 12",2
| 2,"line
| '21' line 22",2
| 3,"line
| '31' line 32",1)r zline
| '21' line 22r )r zline
| '31' line 32r z\id,text,num_lines
| 1,"line '11
| ' line 12",2
| 2,"line '21
| ' line 22",2
| 3,"line '31
| ' line 32",1)r zline '21
| ' line 22r )r zline '31
| ' line 32r zbid,text,num_lines
| 1,"line '11
| ' line 12",2
| 2,"line '21
| ' line 22",2
| 3,"line '31
| ' line 32",1)r zline '21
| ' line 22r )r zline '31
| ' line 32r c ó | }|j t |« dg¬« }t |g d¢¬« }t j ||« y )Nr r3 r> rA ©r r r r" r# )r$ r8 rP r% r' r( s r) Ú$test_skip_row_with_newline_and_quoterT s> ð: FØ __X d^°q°c_Ó :FäÒ+FÔGHÜ×Ñ& (Õ+r+ Úlineterminator)r- z
| ú c óÞ | }dj g d¢« }t g d¢g d¢g d¢gg d¢¬« }|j dk( r6|d k( r1t j j d
| ¬ « }|j |« |j d|« }d }t j t |d ¬« 5 |j t |« ddg d¢¬« }d d d « t j |« y # 1 sw Y xY w)Nr- )zSMOSMANIA ThetaProbe-ML2X z 2007/01/01 01:00 0.2140 U M z 2007/01/01 02:00 0.2141 M O z 2007/01/01 04:00 0.2142 D M )ú
| 2007/01/01z01:00g1¬ ZdË?ÚUÚM)rX z02:00gºk ù gË?rZ ÚO)rX z04:00gBÏfÕçjË?ÚDrZ )ÚdateÚtimeÚvarÚflagÚoflagrA ÚpythonrV z+'CR' not respect with the Python parser yet)Úreasonz;The 'delim_whitespace' keyword in pd.read_csv is deprecatedF)ÚmatchÚcheck_stacklevelr T)r Údelim_whitespaceÚnames)r4 r ÚengineÚpytestÚmarkÚxfailÚ applymarkerÚreplacer" Úassert_produces_warningÚ FutureWarningr r r# ) r$ rU Úrequestr% r8 r( rj Údepr_msgr' s r) Ú test_skiprows_lineterminatorrr ¾ sì ð FØ 99ò
| ó Dô â 5Ú 5Ú 5ð
| ò
| 9ô Hð }}Ò ^°tÒ%;Ü{{× Ñ Ð(UÐ ÓVØ×ÑDÔ!à <<nÓ -DàLHÜ × #Ñ #ÜX¸ô
| ñ
| ð Ü TNØØ !Ú:ð !ó
| ÷
| ô ×Ñ& (Õ+÷
| ð
| ús Â#!C#Ã#C,c ó | }d}t ddgi« }|j t |« d¬« }t j ||« y )Nz a"
| b"
| a
| 1rD r r r3 rO ©r$ r% r8 r( r' s r) Útest_skiprows_infield_quoteru é sD ð FØ DÜ# sÓ$Hà __X d^°a_Ó 8FÜ×Ñ& (Õ+r+ zkwargs,expectedÚ1é Úfoo)r rg c óv | }d} |j t |« fdd i|¤}t j ||« y )Nú a
| 1
| 2
| 3
| 4
| 5r c ó | dz dk( S )Nr r © ©Úxs r) ú<lambda>z)test_skip_rows_callable.<locals>.<lambda> s ÀÀAÁÈÁ
| r+ rK )r$ rL r( r% r8 r' s r) Útest_skip_rows_callabler ô s= ð FØ Dà V__X d^Ñ UÑ6JÐ UÈfÑ UFÜ×Ñ& (Õ+r+ c ó | }d}t ddgddgg« }|j t |« d d ¬« }t j ||« y )Nz0,a
| 1,b
| 2,c
| 3,d
| 4,er rE r Údc ó
| | dvS )N)r r r| r} s r) r z0test_skip_rows_callable_not_in.<locals>.<lambda> s
| ¸À¸ r+ )r r rO rt s r) Ú test_skip_rows_callable_not_inr sT à FØ $DÜ1c( Q¨ HÐ-Ó.Hà __ÜtÑ.Gð ó Fô ×Ñ& (Õ+r+ c óª | }d}d}t j t |¬« 5 |j t |« d ¬« d d d « y # 1 sw Y y xY w)Nrz z No columns to parse from file©rd c ó y)NTr| r} s r) r z)test_skip_rows_skip_all.<locals>.<lambda> s r+ r3 )ri Úraisesr r r )r$ r% r8 Úmsgs r) Útest_skip_rows_skip_allr sL à FØ DØ
| )Cä ~¨SÔ 1ñ AØ ± Ô@÷A÷ Añ Aúó ¢ A Á Ac óª d}| }d}t j t |¬« 5 |j t |« d ¬« d d d « y # 1 sw Y y xY w)Nzby zerorz r c ó ddz S )Nr r r| r} s r) r z-test_skip_rows_bad_callable.<locals>.<lambda>! s
| ¸1¸q¹5 r+ r3 )ri r ÚZeroDivisionErrorr r )r$ r r% r8 s r) Útest_skip_rows_bad_callabler sM à
| CØ FØ Dä Ô(°Ô 4ñ BØ ± ÔA÷B÷ Bñ Búr c ó d}| }|j t |« dg d¢¬« }t g d¢g d¢d« }t j ||« y )Nz$a,b
| 1,a
| 2,b
| 3,c
| 4,d
| 5,e
| 6,f
| 7,g
| 8,h
| rw )r r0 r
| )Únrowsr )r r rw é r1 )rD rF ÚeÚgÚh)rD rE rS )r$ r8 r% r' r( s r) Útest_skip_rows_and_n_rowsr $ sH ð Dð FØ __X d^°1ºy_Ó IFÜÒ5NÑOÓPHÜ×Ñ& (Õ+r+ c ó
| d}| }|j t |« |d d¬« }t |« }t |« }t j |t dg d¢i« « t j |t dg d¢ig d¢¬ « « y )
| Nz%col_a
| 10
| 20
| 30
| 40
| 50
| 60
| 70
| 80
| 90
| 100
| c ó
| | dv S )N)r r0 rw r| r} s r) r z,test_skip_rows_with_chunks.<locals>.<lambda>H s
| ¸!¸y¸. r+ r0 )rh r Ú chunksizeÚcol_a)é é é< éF )éP éZ éd )r0 rw r
| )r )r r Únextr" r# r )r$ r8 r% ÚreaderÚdf1Údf2s r) Útest_skip_rows_with_chunksr¦ 7 s} ð Dð FØ __ÜvÑ0HÐTUð ó Fô v,CÜ
| v,Cä×Ñ#y¨'Ò3CÐ)DÓ EÔFÜ×Ñ#y¨'²=Ð)AÊÔ SÕTr+ )%Ú__doc__r Úior Únumpyr ri Ú pandas.errorsr Úpandasr r Úpandas._testingÚ_testingr" rj Ú usefixturesÚ xfail_pyarrowÚfilterwarningsÚ
| pytestmarkÚ parametrizeÚlistr5 r* r; r= rM rQ rT rr ru r r r r r r¦ r| r+ r) ú<module>r´ s ðñõ
| Ý ã Û å (÷õ à ×'Ñ'¨Ó8 Ø [[× 'Ñ 'ØCó
| ð
| Ø×Ñ¡d©5°«8£n°aÐ%8Ó9ñ,ó :ó ð,ð4 ñ 4ó ð 4ð ñ*ó ð*ð4 ×ÑØð ð !Ð Ù Ú+Ò->Ð?Ú3ô ð
| ð AØ ¨A¨3Ñ /Ù Ò2Ð3º_Ô Mð
| ð3ð
| ¨A¨q¨6Ñ 2Ù Ð2°FÐ;Ð<ÀvÈuÀoÔ Vð
| ð' ó ðB ñ,ó óC ðD,ð ñ ,ó ð ,ð ×ÑØð ò +Ò,IÐ Jð
| ð ò +Ò,IÐ Jð
| ð !ò /Ò0QÐ Rð
| ð óð4 ñ,ó ó5ð6,ð Ø×ÑØÒ*óñ$,óó ð$,ðN ñ,ó ð,ð Ø×ÑØà Ya V}Ó %Ð&Ø Ñ (©)°U¸QÀ¸F°OÓ*DÐEðóñ,óó ð,ð ñ,ó ð,ð ñAó ðAð ñBó ðBð ñ,ó ð,ð$ ñUó ñUr+
|
|
