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
Ë
oñúhAnãóÆ —ddlZddlZddlZddlmZmZmZmZm    Z    m
Z
ddl m Z d„Zejj!dddg«d„«Zejj!ddd    g«d
„«Zejj!dddg«d „«Zejj!dddg«ejj!d ed ddej(gdœ«eddgied gd¬«¬«fed ej(gdœe¬«eddgied gd¬«¬«fg«d„««Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d „Z!ejj!d!d"ge    d#d$¬%«d&gd'œd"ge    d#d$¬%«d&gd'œd"ge    d#d$¬%«d&gd'œfgd(¢e    d)d*¬%«e    d#d$¬%«e    d+d,¬%«ggd-¢d'œd"d.ge    d)d*¬%«e    d#d$¬%«gd&d/gd'œd"d.ge    d+d,¬%«e    d#d$¬%«gd0d/gd'œfg«d1„«Z"ejj!d2de    d3d4¬%«d gde    d5d4¬%«d6gg«d7„«Z#ejj!d8ejHd9d:gd;¬«ejHd&d/gd<¬«ejJd=d>g«ejLd&d/gd?¬@«g«ejj!dAgdB¢«dC„««Z'dD„Z(ejj!dEdFd    dgfdFdgfdFd&dd/gfdFdGgdH¢fdId    d&gfdIdgfdId&d&d/gfdIdGgdH¢fg«ejj!dJdgd"gd.gd"d.gg«ejj!dKd9d:g«dL„«««Z)ejj!dMdFd    dgfdFdgfdFd&dd/gfdFdGgdH¢fdId    d&gfdIdgfdId&d&d/gfdIdGgdH¢fg«dN„«Z*dO„Z+dP„Z,dQ„Z-ejj!dRgdS¢«dT„«Z.ejj!dRgdS¢«dU„«Z/dV„Z0dW„Z1ejj!dgdX¢«dY„«Z2ejj!dZe3dd0d/«gd[¢ge3dd\«gd]¢ge3dd/«e3d\d«ggd^¢gdd&e3d\d«ggd^¢gg«d_„«Z4d`„Z5da„Z6db„Z7dc„Z8dd„Z9de„Z:ejj!dfddgdg¢e;dh«fdd&dd0ge;di«fddjgdg¢e;dh«fdd    gdk¢e;dl«fd&dgdm¢e;dn«fd&d    d&ge;d.«fd    dd/doge;dp«fd    d/doge;dq«fg«ejj!ddrdg«ds„««Z<ejj{dt«du„«Z>dv„Z?ejj!dwd6d6gd6dxgf«ejj!dRgdy¢«dz„««Z@ejj!d{e    d|«e    d}«fd~g«d„«ZAy)€éN)Ú    DataFrameÚIndexÚ
MultiIndexÚSeriesÚ    TimestampÚisnacó—|jd«}|j«}|jddggd¢f}tddgd¬«|_|j «}t j||«|jd«}|jddg}t j||«|j«}|jdd    ggd¢f}tddgd¬«|_t j||«|jd
«}|jdd    g}t j||«|jd«}|jd d g}t j||«|d j«|d j«|d jd«|j«}tj|j|ddk(d f<|jd«}t|d j«d«sJ‚t|d j«d«sJ‚t|d jd«jd«sJ‚tdtjgddgddggdd g¬«}|jd«}|j«}|jdd gj!d«}t j||«|jdd g}|jdd¬«}t j||«y)NÚAér)ÚBÚCÚDÚbarÚfoo©Únameéééÿÿÿÿéér éé©ÚcolumnsÚany©Údropna)ÚgroupbyÚfirstÚlocrÚindexÚ
sort_indexÚtmÚassert_frame_equalÚnthÚlastÚilocÚcopyÚnpÚnanrrÚ    set_index)ÚdfÚgroupedr Úexpectedr&r'ÚgÚresults        úXH:\Change_password\venv_build\Lib\site-packages\pandas/tests/groupby/methods/test_nth.pyÚtest_first_last_nthr3s£€àj‰j˜‹o€GØ M‰M‹O€E؏v‰vq˜!fšoÐ-Ñ.€HܘE 5˜>°Ô4€H„NØ×"Ñ"Ó$€HÜ×ј% Ô*à
+‰+a‹.€C؏v‰vq˜!f‰~€HÜ×ј#˜xÔ(à <‰<‹>€D؏v‰vq˜!fšoÐ-Ñ.€HܘE 5˜>°Ô4€H„NÜ×ј$ Ô)à
+‰+b‹/€C؏w‰w˜˜1v‰€HÜ×ј#˜xÔ(à
+‰+a‹.€C؏w‰w˜˜1v‰€HÜ×ј#˜xÔ(ð ˆCL×ÑÔØ ˆCL×ÑÔØ ˆCL×ѐQÔà     ‰‹€BÜ$&§F¡F€B‡FFˆ2ˆc‰7eÑ ˜SÐ  Ñ!؏j‰j˜‹o€GÜ ˜‘ ×"Ñ"Ó$ UÑ+Ô ,Ð,Ð ,Ü ˜‘ ×!Ñ!Ó# EÑ*Ô +Ð+Ð +Ü ˜‘ × Ñ  Ó#×(Ñ(¨Ñ+Ô ,Ð,Ð ,ô
QœŸ™K ! Q ¨!¨Q¨Ð0¸3À¸*Ô    E€BØ

‰
3‹€AØ W‰W‹Y€F؏w‰w˜˜1v‰×(Ñ(¨Ó-€HÜ×ј& (Ô+àw‰w˜˜1v‰€HØ U‰U1˜UˆUÓ #€FÜ×ј& (Õ+óÚmethodr r'có8—tgd¢ddd|gdœ«jd«}t||««}|dk(rddg}nddg}tj||dj
¬    «}t ddgd¬
«}td|i|¬ «}tj||«y) N©r r rrr rr©ÚaÚbr9r r:©Údtyper©r")    rrÚgetattrr*Úarrayr<rr$r%)r5Ú nulls_fixtureÚgroupsr1ÚvaluesÚidxr/s       r2Útest_first_last_with_na_objectrDBs€ôš\°°A°q¸-Ð0HÑIÓ J× RÑ RÐSVÓ W€FØ $ŒWV˜VÓ $Ó &€Fà ÒØQ‰àQˆä X‰Xf F¨3¡K×$5Ñ$5Ô 6€FÜ
A˜SÔ
!€Cܘ#˜v˜¨cÔ2€Hä×ј& (Õ+r4r"rcóê—tgd¢ddd|gdœ«}|jd«}|j|«}|dk(r|jddgn|jddg}t    j
||«y)Nr7r rrr8r9r©rrr&r(r$r%)r"r@r-rAr1r/s      r2Útest_nth_with_na_objectrGTsl€ô
š¨Q°°1°mÐ,DÑEÓ    F€BØ Z‰Z˜‹_€FØ Z‰Z˜Ó €FØ"'¨1¢*ˆrw‰w˜˜1vа"·'±'¸1¸a¸&±/€HÜ×ј& (Õ+r4có¬—tjdgdgdœ«}|jdd¬«}t||««}t    j
||«y)Nr9©ÚidÚvaluerJF©Úas_index)rÚ    from_dictrr>r$r%)r5r-rAr1s    r2Útest_first_last_with_NonerO^sP€ô
×    Ñ     S E°T°FÑ;Ó    <€BØ Z‰Z˜ uˆZÓ -€FØ $ŒWV˜VÓ $Ó &€Fä×ј& "Õ%r4z df, expectedr9rrIrKrJrr=r;cóp—t|jd«|««}tj||«y)NrJ)r>rr$r%)r5r-r/r1s    r2Ú"test_first_last_with_None_expandedrQis.€ð /ŒWR—Z‘Z Ó% vÓ .Ó 0€FÜ×ј& (Õ+r4c
ó(—tgd¢gd¢tjjd«j    d«tj
tjjd«j    d«d¬«dœ«}d|d    <d
|d <|j d «}|j«}|jd
d ggd¢f}tddgd ¬«|_
|j«}tj||«|j«}|jddggd¢f}tddgd ¬«|_
|j«}tj||«|jd
«}|j ddg}tj||«y)N)rrrrrrrr)ÚonerSÚtwoÚthreerTrTrSrUréÚfloat32r;©r
r r rTÚEr ÚFr
r)r r rrYrZrrrrrr)rr*ÚrandomÚ default_rngÚstandard_normalr?rr r!rr"r#r$r%r'r&r()r-r.r r/r'r&s      r2Útest_first_last_nth_dtypesr^}sS€Ü    âIÚMÜ—‘×&Ñ& qÓ)×9Ñ9¸!Ó<Ü—‘œ"Ÿ)™)×/Ñ/°Ó2×BÑBÀ1ÓEÈYÔWñ        
ó
€Bð€B€sGØ€B€sGðj‰j˜‹o€GØ M‰M‹O€E؏v‰vq˜!fÒ7Ð7Ñ8€HܘE 5˜>°Ô4€H„NØ×"Ñ"Ó$€HÜ×ј% Ô*à <‰<‹>€D؏v‰vq˜!fÒ7Ð7Ñ8€HܘE 5˜>°Ô4€H„NØ×"Ñ"Ó$€HÜ×ј$ Ô)à
+‰+a‹.€C؏w‰w˜˜1v‰€HÜ×ј#˜xÕ(r4có—ttd««}|jd«ttd«|d¬«}|jdk(sJ‚|j d¬«j «}|jdk(sJ‚y)    Né
é    é ÚIntCol)Údatar"rÚint64r©Úlevel)ÚlistÚrangeÚappendrr<rr )rCÚserÚfs   r2Útest_first_last_nth_dtypes2rmœsi€ä
ŒuR‹y‹/€C؇JJˆq„MÜ
”e˜B“i s°Ô
:€CØ 9‰9˜Ò ÐÐ Ø  ‰ ˜!ˆ Ó×"Ñ"Ó$€AØ 7‰7gÒ ÐÑ r4có&—tdgtdgt¬«dœ«}|jd«}|j    d«j
}t j|j
j«|«t j|j
j«|«|j
}t j|j
jd«|«t j|j
jd«|«y)Nr
r;)rdÚnansrdrr) rrÚobjectrr,ror$Úassert_series_equalr r'r&)r-r.r/s   r2Útest_first_last_nth_nan_dtyperr¦s¿€ä    ˜S˜E¬6°4°&ÄÔ+GÑHÓ    I€B؏j‰j˜Ó €Gà|‰|˜FÓ#×(Ñ(€HÜ×ј7Ÿ<™<×-Ñ-Ó/°Ô:Ü×ј7Ÿ<™<×,Ñ,Ó.°Ô9àw‰w€HÜ×ј7Ÿ<™<×+Ñ+¨BÓ/°Ô:Ü×ј7Ÿ<™<×+Ñ+¨AÓ.°Õ9r4c ó>—ttd«ddgtd«ddgdddgd    d
d gi«}|jd«j«}tgd ¢gt    td «td«d    g«t    dgd¬«¬«}t j ||«y)Nz2012-01-01 00:00:00r9r:z2012-01-02 00:00:00ÚcÚdrÚeÚaaaarlr0)r9rtrlz
2012-01-01z
2012-01-02r©rr")rrrr rr$r%)Útestr1r/s   r2Útest_first_strings_timestampsrz´s¡€ä ä Ð+Ó ,¨s°C¨jÜ Ð+Ó ,¨s°C¨jØ S˜#JØ S˜#Jð        
ó €Dð\‰\˜&Ó !× 'Ñ 'Ó )€FÜÚ    ÐÜ”y Ó.´    ¸,Ó0GÈÐPÓQܐSE Ô'ô€Hô
×ј& (Õ+r4có—tdtjgddgddggddg¬«}|jd«}t    j
|j d«|jdd    g«t    j
|j d«|jdg«t    j
|j d    «|jg«t    j
|j d
«|jdd    g«t    j
|j d «|jdg«t    j
|j d «|jg«t    j|jj d«|jjdd    g«t    j|jj d«|jjdg«t    j
|dgj d«|dgjdd    g«t    j
|j dd ¬«|jdd    g«t    j
|j d
d ¬«|jdd    g«t    j
|j dd ¬«|jdd«t    j
|j d    d ¬«|jdd«y)Nr rrrr
r rrrréþÿÿÿéýÿÿÿrrr) rr*r+rr$r%r&r(r!rqr ©r-Úgbs  r2Útest_nthr€Çs+€Ü    QœŸ™K ! Q ¨!¨Q¨Ð0¸3À¸*Ô    E€BØ     ‰C‹€Bä×ј"Ÿ&™& ›) R§W¡W¨a°¨V¡_Ô5Ü×ј"Ÿ&™& ›) R§W¡W¨a¨S¡\Ô2Ü×ј"Ÿ&™& ›) R§V¡V¨B¡ZÔ0Ü×ј"Ÿ&™& ›* b§g¡g¨q°!¨f¡oÔ6Ü×ј"Ÿ&™& ›* b§g¡g¨q¨c¡lÔ3Ü×ј"Ÿ&™& ›* b§f¡f¨R¡jÔ1Ü×ј2Ÿ4™4Ÿ8™8 A›;¨¯©¯    ©    °1°a°&Ñ(9Ô:Ü×ј2Ÿ4™4Ÿ8™8 A›;¨¯©¯    ©    °1°#©Ô7Ü×ј"˜c˜U™)Ÿ-™-¨Ó*¨B°¨u©I¯N©N¸A¸q¸6Ñ,BÔCä×ј"Ÿ&™& ¨5˜&Ó1°2·7±7¸A¸q¸6±?ÔCÜ×ј"Ÿ&™& ¨E˜&Ó2°B·G±G¸QÀ¸F±OÔDä×ј"Ÿ&™& ¨5˜&Ó1°2·7±7¸2¸A°;Ô?Ü×ј"Ÿ&™& ¨5˜&Ó1°2·7±7¸2¸A°;Õ?r4c ó”—tddddddœddddddœddd    d
d dœd d ddddœdœ«jddg«}|jdd¬«jd«}|jdg}t j ||«|jdd¬«jd«}|jg}t j ||«y)NÚgreenÚred©rr rrrÚhamÚeggsÚporkgþI|î»ø?gçoB!²¿gHk :!4Àgn‹2d’Ý?gC8fٓÀà?g£W”†â?gV¿Òùð,ï¿gN'ÙêrŠð?gÃGĔH"é¿gû­(    ‰æ?)ÚcolorÚfoodrTrSrˆr‰rF)rgrMrrr)rr,rr&r(r$r%r!©r-r1r/s   r2Ú    test_nth2r‹Üså€ô
à  W°¸5ÀUÑKØ &¨V¸À&ÑIà%Ø(Ø&Ø&Ø&ñ ð'Ø&ØØ'Ø&ñ ñ    
ó
÷&i˜&Ð!Ó"ð'ð*Z‰Z˜a¨%ˆZÓ 0× 4Ñ 4°QÓ 7€F؏w‰w˜t‰}€HÜ×ј& (Ô+à Z‰Z˜a¨%ˆZÓ 0× 4Ñ 4°QÓ 7€F؏v‰vb‰z€HÜ×ј& (Õ+r4có¤—ttjjd«j    ddd«d¬«}|d}|d}|j |«j «}|j |«jd„«}tj||d    ¬
«|jdk(sJ‚|jdk(sJ‚||dk(jd}|jd|k(sJ‚|jd|k(sJ‚tjtd ¬ «5|j |d    ¬ «jdd¬«ddd«y#1swYyxYw)Nrr r`)édrrer;rcó —|jdS)Nr)r()Úxs r2ú<lambda>ztest_nth3.<locals>.<lambda>s€°·±°q±    €r4F)Ú check_nameszFor a DataFrame©Úmatch)ÚsortTr)rr*r[r\Úintegersrr Úapplyr$rqrr(ÚpytestÚraisesÚ
ValueErrorr&)r-rkrr/Ú    expected2Úvs      r2Ú    test_nth3rœýs1€ô
”2—9‘9×(Ñ(¨Ó+×4Ñ4°Q¸¸HÓEÈWÔ    U€BØ
ˆQ‰%€CØ     ˆA‰€B؏{‰{˜2‹×$Ñ$Ó&€HØ— ‘ ˜B“×%Ñ%Ñ&9Ó:€IÜ×ј9 h¸EÕBØ =‰=˜AÒ ÐÐ Ø >‰>˜QÒ ÐÐ ð     ˆB!‰G‰ ×ј!Ñ€AØ =‰=˜Ñ ˜qÒ  Ð Ð  Ø >‰>˜!Ñ  Ò !Ð!Ð !ä    ‰”zÐ):Ô    ;ñ8Ø  ‰ B˜Uˆ Ó#×'Ñ'¨°$Ð'Ô7÷8÷8ñ8ús Ä%EÅEcó—tdtjgddgddggddg¬«}|jd«}|jj dd    ¬
«}|jj dd g}tj||«y) Nr rrrr
r rrÚallrr)    rr*r+rr r&r(r$rq)r-rr1r/s    r2Ú    test_nth4rŸsr€ä    QœŸ™K ! Q ¨!¨Q¨Ð0¸3À¸*Ô    E€BØ     ‰C‹€BØ T‰TX‰Xa ˆXÓ &€F؏t‰ty‰y˜!˜Q˜Ñ €HÜ×ј6 8Õ,r4cóЗtdtjgddgddgddgddggddg¬    «}|jd«}t    j
|j d
«|jd
dg«t    j
|j d
g«|jd
dg«t    j
|j d
dg«|jgd ¢«t    j
|j d
d g«|jgd ¢«t    j
|j gd¢«|jgd¢«t    j
|j gd¢«|jgd¢«t    j
|j dg«|jdg«t    j
|j ddg«|jg«y)Nr rrrrrr
r rr)rr rrr)rrrr©rr rr„)rr rr)    rr*r+rr$r%r&r(r!r~s  r2Ú    test_nth5r¢sc€ä    QœŸ™K ! Q ¨!¨Q¨°!°Q°¸!¸Q¸Ð@È3ÐPSÈ*Ô    U€BØ     ‰C‹€Bä×ј"Ÿ&™& ›) R§W¡W¨a°¨V¡_Ô5Ü×ј"Ÿ&™& ! ›+ r§w¡w°°1¨v¡Ô7Ü×ј"Ÿ&™& ! Q ›.¨"¯'©'²,Ñ*?Ô@Ü×ј"Ÿ&™& ! R ›/¨2¯7©7²<Ñ+@ÔAÜ×ј"Ÿ&™&¢Ó+¨R¯W©W²_Ñ-EÔFÜ×ј"Ÿ&™&¢Ó,¨b¯g©g²oÑ.FÔGÜ×ј"Ÿ&™& ! ›+ r§w¡w°¨s¡|Ô4Ü×ј"Ÿ&™& ! Q ›.¨"¯&©&°©*Õ5r4cóŽ—tjddd|¬«}td|ddg¬«}|jj|jj
g}|j |d    ¬
«jgd ¢«}tjgd ¢«j|«}tdddg|¬ «}tj||«y)Nz4/1/2014z    6/30/2014r )ÚstartÚendÚfreqÚunitr r9r:©r"rFrL)rrr|r) z2014/4/1z2014/4/4z    2014/4/29z    2014/4/30z2014/5/1z2014/5/6z    2014/5/29z    2014/5/30z2014/6/2z2014/6/5z    2014/6/27z    2014/6/30rx) ÚpdÚ
date_rangerr"ÚyearÚmonthrr&Ú to_datetimeÚas_unitr$r%)r§Úbusiness_datesr-Úkeyr1Úexpected_datesr/s       r2Útest_nth_bdaysr²*s©€Ü—]‘]ؘk°¸$ô€Nô
1˜N°S¸#°JÔ    ?€Bà 8‰8=‰=˜"Ÿ(™(Ÿ.™.Ð
)€CØ Z‰Z˜ eˆZÓ ,× 0Ñ 0²Ó @€FÜ—^‘^ò     
ó÷gˆdƒmðô ˜ S¨# J°nÔE€HÜ×ј& (Õ+r4cóš—|jddg«}|jd«}|jgd¢}tj||«y)Nr
r r©rrrr)rr&r(r$r%©Ú three_groupr.r1r/s    r2Útest_nth_multi_grouperr·FsE€ð×!Ñ! 3¨ *Ó-€GØ [‰[˜‹^€FØ×Ñ¢ Ñ-€HÜ×ј& (Õ+r4z#data, expected_first, expected_lastr
z2012-02-01 14:00:00z
US/Central©Útzr ©rJÚtimer)r
r r
z2012-01-01 13:00:00zAmerica/New_Yorkz2012-03-01 12:00:00z Europe/London©r rrr rrcóF—t|«}|jdd¬«j«}t|«}gd¢}tj||||«|jdd¬«dj«}tj||ddg«|jdd¬«j «}t|«}gd¢}tj||||«|jdd¬«dj «}tj||ddg«y)NrJFrLrºr»)rrr r$r%r')rdÚexpected_firstÚ expected_lastr-r1r/Úcolss       r2Útest_first_last_tzrÁOs€ôl
4‹€Bà Z‰Z˜ uˆZÓ -× 3Ñ 3Ó 5€FܘÓ(€HÚ  €DÜ×ј& ™,¨°©Ô7à Z‰Z˜ uˆZÓ -¨fÑ 5× ;Ñ ;Ó =€FÜ×ј& (¨D°&¨>Ñ":Ô;à Z‰Z˜ uˆZÓ -× 2Ñ 2Ó 4€FܘÓ'€HÚ  €DÜ×ј& ™,¨°©Ô7à Z‰Z˜ uˆZÓ -¨fÑ 5× :Ñ :Ó <€FÜ×ј& (¨D°&¨>Ñ":Õ;r4zmethod, ts, alphaz
2013-01-01ú
US/Easternz
2013-01-02r:cóâ—ttd««jd«}tjddd|¬«}t gd¢||dœ«}t |jd    «|««}t tj|d
g|j¬ «|td d¬ «gdœtddgd    ¬«¬«}|djj|«|d<tj||«y)NÚabcÚcategoryÚ20130101rrÂ)Úperiodsr¹r§©r r r)ÚgroupÚcategory_stringÚ
datetimetzrÉrtr;z
2013-01-03r¸)rÊrËr rrr=rË)rrhÚastyper©rªrr>rÚ Categoricalr<rrÚdtr®r$r%)    r5ÚtsÚalphar§rÊÚdtir-r1r/s             r2Útest_first_last_tz_multi_columnrҘsâ€ôœT %›[Ó)×0Ñ0°Ó<€OÜ
-‰-˜
¨A°,ÀTÔ
J€CÜ    âØ.Øñ    
ó
€Bð2ŒWR—Z‘Z Ó(¨&Ó 1Ó 3€FÜä!Ÿ~™~ؘ  O×$9Ñ$9ô ðœy¨¸,ÔGÐHñ        
ô Q˜F Ô)ô€Hð& lÑ3×6Ñ6×>Ñ>¸tÓD€Hˆ\ÑÜ×ј& (Õ+r4rBTFÚbooleanÚInt64z
2020-01-01z
2020-02-01r)r§Úfunction)r r'ÚminÚmaxcóD—tddg|dœ«}|jd«}tddgd¬«}t|d|¬«}td|i|¬«}t    |d|««}t j ||«|jd|i«}t j||«y)    Nr rr8r9rr:)rr"r=)    rrrrr>r$rqÚaggr%)    rBrÕr-r.rCÚexpected_seriesÚexpected_frameÚ result_seriesÚ result_frames             r2Ú+test_first_last_extension_array_keeps_dtyperÞ¸s™€ô
˜!˜Q˜ fÑ-Ó    .€B؏j‰j˜‹o€GÜ
A˜SÔ
!€CܘV¨#°SÔ9€OÜ  V˜}°CÔ8€Nà3”G˜G C™L¨(Ó3Ó5€MÜ×ј=¨/Ô:à—;‘;  X˜Ó/€LÜ×ј,¨Õ7r4cóėtgd¢gd¢gd¢dœ«}|jddg«}|jd«}|jgd¢}t    j
||«y)    N) rrrrrrrrrrr) rSrSrSrTrSrSrSrTrTrTrS) ÚdullràÚshinyràràráráràrárárá©r
r r r
r rr´rFrµs    r2Ú test_nth_multi_index_as_expectedrãÒsf€ôò ò ò ñ7(    
ó*€KðV×!Ñ! 3¨ *Ó-€GØ [‰[˜‹^€FØ×Ñ¢ Ñ-€HÜ×ј& (Õ+r4zop, n, expected_rowsÚheadrr¡ÚtailrrMcóà—tddgddgddggddg¬«}|jd|¬    «}|j|}|
||}||}t||«|«}t    j
||«y)
Nr rrrrr
r rrL)rrr(r>r$r%)    ÚopÚnÚ expected_rowsrrMr-r0r/r1s             r2Útest_groupby_head_tailrês‚€ô 
Q˜F˜Q ˜F Q¨ FÐ+°c¸3°ZÔ    @€BØ

‰
3 ˆ
Ó*€A؏w‰w}Ñ%€HØÐØ ˆg‰JˆØ˜GÑ$ˆØ ŒWQ˜‹^˜AÓ €FÜ×ј& (Õ+r4zop, n, expected_colscó>—tgd¢gd¢gd¢gd¢ggd¢¬«}d}tjt|¬«5|j    gd    ¢d
¬ «}ddd«|j
dd…|f}t |«|«}tj||«y#1swYŒExYw) Nr¼)r rr)rrr)rrVrarârú+DataFrame.groupby with axis=1 is deprecatedr’©rrr r ©Úaxis)rr$Úassert_produces_warningÚ FutureWarningrr(r>r%)rçrèÚ expected_colsr-Úmsgr0r/r1s        r2Útest_groupby_head_tail_axis_1rô s€ô
Ú    ’Išyª)Ð4ºoô
€Bð 8€CÜ     ×    #Ñ    #¤M¸Ô    =ñ*Ø J‰J’y qˆJÓ )ˆ÷*àw‰w’q˜-Ð'Ñ(€HØ ŒWQ˜‹^˜AÓ €FÜ×ј& (Õ+÷    *ð*ús ¹BÂBcóV—tddgddgddggddg¬«}|jd    dg}|jd«}|jd¬
«}|j    d    «}t j ||«t j ||«|jd«}|jd¬
«}|j    d    «}t j ||«t j ||«|jd«}|j    d    «}|jd¬
«}t j ||«t j ||«|jd«}|j    d    «}|jd¬
«}t j ||«t j ||«y) Nr rrrrr
r rr©rè)rr(rrär&r$r%rå)r-r/r0Úresult1Úresult2s     r2Útest_group_selection_cacherù:sZ€ä    Q˜F˜Q ˜F Q¨ FÐ+°c¸3°ZÔ    @€B؏w‰w˜˜1v‰€Hà

‰
3‹€A؏f‰fqˆf‹k€G؏e‰eA‹h€GÜ×ј' 2Ô&Ü×ј' 8Ô,à

‰
3‹€A؏f‰fqˆf‹k€G؏e‰eA‹h€GÜ×ј' 2Ô&Ü×ј' 8Ô,à

‰
3‹€A؏e‰eA‹h€G؏f‰fqˆf‹k€GÜ×ј' 8Ô,Ü×ј' 2Ô&à

‰
3‹€A؏e‰eA‹h€G؏f‰fqˆf‹k€GÜ×ј' 8Ô,Ü×ј' 2Õ&r4có<—tdggd¢¬«}|jd«jd«}|jdd}t    j
||«|jddg«jd«}|jdd}t    j
||«y)Nr©r9r:rtr¨r9r`r:rFrŠs   r2Útest_nth_emptyrüXsƒ€ä    ˜!˜¢oÔ    6€BØ Z‰Z˜‹_×  Ñ   Ó $€F؏w‰wr˜ˆ{€HÜ×ј& (Ô+à Z‰Z˜˜c˜
Ó #× 'Ñ '¨Ó +€F؏w‰wr˜ˆ{€HÜ×ј& (Õ+r4có~—tgd¢gd¢ddtjggd¢gd¢ggd¢¬«}|jd    «j    d
«}|j
d
d g}t j||«|jd    «j    d d ¬«}|j
ddg}t j||«y)N)r r:r)r r9é2r r9)rrtéÈ)rrué–)r
r r rr
rrrrrr©rr*r+rr&r(r$r%rŠs   r2Útest_nth_column_orderrds£€ô
Ú    š  q¨#¬r¯v©vÐ&6º Â}ÐUÚô
€BðZ‰Z˜‹_×  Ñ   Ó #€F؏w‰w˜˜1v‰€HÜ×ј& (Ô+à Z‰Z˜‹_×  Ñ   ¨EÐ  Ó 2€F؏w‰w˜˜1v‰€HÜ×ј& (Õ+r4r)Nrržcó—ttjdtjdtjggd¢gd¢dœ«}|jd«j    d|¬«}|j
dd    g}t j||«y)
Nr9r:©rrrrrV)r rrrrarûrrr rr©rr-r1r/s    r2Útest_nth_nan_in_grouperrtss€ô
ä—&‘&˜#œrŸv™v s¬B¯F©FÐ3Ú Ú ñ    
ó
€BðZ‰Z˜‹_×  Ñ   ¨6Ð  Ó 2€F؏w‰w˜˜1v‰€Hä×ј& (Õ+r4có —ttjdtjdtjggd¢dœ«}|jd«dj    d|¬«}|dj
ddg}t j||«y)    Nr9r:rr8rrr r)rr*r+rr&r(r$rqrs    r2Útest_nth_nan_in_grouper_seriesr„sz€ô
ä—&‘&˜#œrŸv™v s¬B¯F©FÐ3Ú ñ    
ó
€Bð Z‰Z˜‹_˜SÑ !× %Ñ % a°Ð %Ó 7€Fؐ#‰w|‰|˜Q ˜FÑ#€Hä×ј6 8Õ,r4c    ó¨—tgd¢dtjd«gztgd¢d¬«dœ«}|j    d«j «}td    tjd«gztgd
¢«j tjgd ¢««d œ«}tgd ¢d¬«|_
tj||«y)N)r r ÚsecondÚthirdr rÚNaT)r9r:rtr9r:rÅr;)rÉr»Ú
categoriesrÉr)r9rtr9rû)r»r )r r
r r) rr*Ú
datetime64rrr rÌr©ÚCategoricalDtyperr"r$r%rŠs   r2Ú,test_first_categorical_and_datetime_data_natr“s±€ä    âCØœŸ™ uÓ-Ð.Ñ.Ü Ò!:À*ÔMñ    
ó
€BðZ‰Z˜Ó  × &Ñ &Ó (€FÜàœŸ™ uÓ-Ð.Ñ.Ü ¢Ó1×8Ñ8Ü×#Ñ#¢OÓ4óñ    
ó€HôÒ7¸gÔF€H„NÜ×ј& (Õ+r4c    óˆ—tgd¢gd¢gd¢gd¢dœ«}|jddi«}|jdd    g¬
«j«}tgd ¢t    gd ¢«jt j gd ¢««dœ«}tjgd¢dd    g¬«|_    tj||«y)N)r r r rr)rrrÿrr)ÚappleÚorangeÚmangorr)ÚjupiterÚmercuryÚmarsÚvenusrrXrrÅr
r )Úby)rrr)rrr)rrrr)r r))r r)r rÿ)rr)Únames) rrÌrr rr©rrÚ from_tuplesr"r$r%rŠs   r2Ú(test_first_multi_key_groupby_categoricalr©s³€ä    â Ú*Ú@ÚAñ        
ó
€Bð
‰C˜Ð$Ó    %€BØ Z‰Z˜C ˜:ˆZÓ &× ,Ñ ,Ó .€FÜâ,ÜÒ4Ó5×<Ñ<Ü×#Ñ#Ò$KÓLóñ    
ó€Hô ×+Ñ+Ú&¨s°C¨jô€H„Nô×ј& (Õ+r4)r r'r&cóø—tdgt¬«}t|||d|ggd¢t¬«jd¬«}|dk(rt||«d«}nt||««}t    j
||«y)    NÚyr;)rrrrr)r"r<rrfr&r)rrprr>r$rq)r5r@r/rdr1s     r2Ú%test_groupby_last_first_nth_with_nonerÃs~€ôse¤6Ô*€HÜ Ø    ˜  }°c¸=ÐIÚÜô ÷gA€gÓð        ð ‚Ø&”˜˜vÓ& qÓ)‰à&”˜˜vÓ&Ó(ˆä×ј6 8Õ,r4zarg, expected_rows)rr rrr|)rrr©rr rrrrrcóº—|j|}|j|«}|j|}tj||«tj||«y©N)r&r(r$r%)Ú slice_test_dfÚslice_test_groupedÚargrér1Ú
equivalentr/s       r2Ú
test_slicer'ÕsT€ð × #Ñ # CÑ (€FØ#×'Ñ'¨Ó,€JØ×!Ñ! -Ñ0€Hä×ј& (Ô+Ü×ј* hÕ/r4cóâ—|jdddd…f}|jddtdd«g«}|jgd¢}tj||«tj||«y)Nrr r|r )r&Úslicer(r$r%)r#r$r1r&r/s     r2Útest_nth_indexedr*ésj€ð × #Ñ # A q¨"©# IÑ .€FØ#×'Ñ'¨¨A¬u°R¸«Ð(?Ó@€JØ×!Ñ!Ò"7Ñ8€Hä×ј& (Ô+Ü×ј* hÕ/r4có†—tjtd¬«5|jd«ddd«y#1swYyxYw)Nz Invalid indexr’g…ëQ¸    @)r—r˜Ú    TypeErrorr&©r$s r2Útest_invalid_argumentr.ôs5€ô
‰”y¨Ô    8ñ%Ø×јtÔ$÷%÷%ñ%ús    œ7·Acóœ—tjtd¬«5|jt    ddd««ddd«y#1swYyxYw)Nz Invalid stepr’r)r—r˜r™r&r)r-s r2Útest_negative_stepr0ûs>€ô
‰”z¨Ô    8ñ6Ø×Ñœu T¨4°Ó4Ô5÷6÷6ñ6ús œAÁA cóž—|jtjddg««}|jgd¢}t    j
||«y)Nrr r„)r&r*r?r(r$r%)r#r$r1r/s    r2Ú test_np_intsr2sA€ð × #Ñ #¤B§H¡H¨a°¨VÓ$4Ó 5€FØ×!Ñ!¢/Ñ2€HÜ×ј& (Õ+r4cóP—tgd¢gd¢gddggd¢¬«}d}tjt|¬«5|j    |j
d    d    ¬
«}ddd«j d «}|j
dd…d d gf}tj||«y#1swYŒFxYw) N)rrr)rVrVrÚzr)r r r
r¨rìr’r rîrr)rr$rðrñrr(r&r%)r-rórr1r/s     r2Ú!test_groupby_nth_with_column_axisr5
sœ€ä    â Ú ð    
ðCˆjÚô 
€Bð 8€CÜ     ×    #Ñ    #¤M¸Ô    =ñ,Ø Z‰Z˜Ÿ™ ™
¨ˆZÓ +ˆ÷,à V‰VA‹Y€F؏w‰w’q˜1˜a˜&yÑ!€HÜ×ј& (Õ+÷    ,ð,ús ¶!BÂB%c
ó—ttjtjdd«tjdd«g«tjtjdd«tjdd«g«ggd¢gd¢g«}t    dt t |««i|¬    «}|jddgd
¬ «jd«}gd ¢}ttjtjdd«tjdd«g«tjtjdd«tjdd«g«ggd ¢gd¢g«}t    ||dg¬«}tj||«y)Nrr rr`é)rrrr r )rr r rrÚcolr=F)rgÚobserved©rr rrí)rr rr¨) rr©ÚCategoricalIndexÚIntervalrriÚlenrr&r$r%)Ú
idx_resultÚ    df_resultr1Ú val_expectedÚ idx_expectedr/s      r2Útest_groupby_nth_intervalrBs@€ää × Ñ ¤§¡¨Q°Ó!2´B·K±KÀÀ1Ó4EРFÓ GÜ × Ñ ¤§¡¨Q°Ó!3´R·[±[ÀÀRÓ5HРIÓ Jð    
ò
Ò*Ð+ó €Jô˜5¤%¬¨J«Ó"8Ð9ÀÔL€IØ × Ñ  a¨ V°eÐ Ó <× @Ñ @ÀÓ C€FÚ€LÜä × Ñ ¤§¡¨Q°Ó!2´B·K±KÀÀ1Ó4EРFÓ GÜ × Ñ ¤§¡¨Q°Ó!3´R·[±[ÀÀRÓ5HРIÓ Jð    
ò
’IÐó €Lô˜¨\ÀEÀ7ÔK€HÜ×ј& (Õ+r4z.start, stop, expected_values, expected_columnsr„ÚABCDEÚADrar:ÚABD)r rrÚBCErÚCErYÚcallcóJ‡    —ttd«gtd«g¬«}d}tjt
|¬«5|j gd¢d¬«Š    ddd«ˆ    fd    „ˆ    fd
„d œ|||«}t|g|g¬«}tj||«y#1swYŒDxYw) NrrCrrìr’)rrrrrr rîcó:•—‰jt||««Sr")r&r)©r¤Ústoprs  €r2rz2test_nth_slices_with_column_axis.<locals>.<lambda>Isø€ B§F¡F¬5°¸Ó+=Ó$>€r4có"•—‰j||Sr")r&rKs  €r2rz2test_nth_slices_with_column_axis.<locals>.<lambda>Jsø€ R§V¡V¨E°$Ð%7€r4)rHr")rrirhr$rðrñrr%)
r¤rLÚexpected_valuesÚexpected_columnsr5r-rór1r/rs
         @r2Ú test_nth_slices_with_column_axisrP3s¦ø€ô"
”E˜!“H:¬¨W«  Ô    7€BØ
7€CÜ     ×    #Ñ    #¤M¸Ô    =ñ1Ø Z‰Zš¨aˆZÓ 0ˆ÷1ðÛ>Û7ñð ñðTó€Fô˜/Ð*Ð5EÐ4FÔG€HÜ×ј& (Õ+÷1ð1ús ÁBÂB"z<ignore:invalid value encountered in remainder:RuntimeWarningcó—tddgdtjgdtjgdtjggddg¬«}tddggddg¬«}|jddg«j    d¬    «}t j ||«|jddg«jd¬    «}t j ||«|jddg«jd
¬    «}t j ||«y) Nr9r4r:rtÚXÚYrr rör©    rr*r+rrär$r%rår&©r-r/r1s   r2Útest_head_tail_dropna_truerVPså€ô
 
ˆsˆcœ2Ÿ6™6] S¬"¯&©& M°C¼¿¹°=ÐAÈCÐQTÈ:ô
€Bô˜3 ˜*˜°°S¨zÔ:€Hà Z‰Z˜˜c˜
Ó #× (Ñ (¨1Ð (Ó -€FÜ×ј& (Ô+à Z‰Z˜˜c˜
Ó #× (Ñ (¨1Ð (Ó -€FÜ×ј& (Ô+à Z‰Z˜˜c˜
Ó #× 'Ñ '¨!Ð 'Ó ,€FÜ×ј& (Õ+r4có6—tddgdtjgdtjggddg¬«}tddgdtjgdtjggddg¬«}|jddgd¬    «j    d
¬ «}t j ||«|jddgd¬    «jd
¬ «}t j ||«|jddgd¬    «jd ¬ «}t j ||«y) Nr9r4r:rtrRrSrFrr rörrTrUs   r2Útest_head_tail_dropna_falserXdsõ€ä    S˜#J ¤b§f¡f  °´R·V±V¨}Ð=ÈÈSÀzÔ    R€Bܘ3 ˜* s¬B¯F©F m°c¼2¿6¹6°]ÐCÈcÐSVÈZÔX€Hà Z‰Z˜˜c˜
¨5ˆZÓ 1× 6Ñ 6¸Ð 6Ó ;€FÜ×ј& (Ô+à Z‰Z˜˜c˜
¨5ˆZÓ 1× 6Ñ 6¸Ð 6Ó ;€FÜ×ј& (Ô+à Z‰Z˜˜c˜
¨5ˆZÓ 1× 5Ñ 5¸Ð 5Ó :€FÜ×ј& (Õ+r4Ú    selectionrt)rržNcó—tgd¢tjddggd¢dœ«}|jd«|}|j    d|¬«}|d    k(s |d
k(r |d d gk7rd dg}nddg}|j
||f}t j||«y)NrÈrr)rrrrûr9rrrržr:rtr r)rr*r+rr&r!r$Ú assert_equal)rYrr-rr1Úlocsr/s       r2Útest_nth_after_selectionr]ss–€ô
âÜ—&‘&˜!˜QÚñ    
ó
€Bð
‰C‹˜Ñ    #€BØ V‰VA˜fˆVÓ %€FØ ‚˜6 Uš?¨y¸SÀ#¸JÒ/Fؐ1ˆv‰à1ˆvˆØv‰vd˜IoÑ&€H܇OOF˜HÕ%r4rdz2011-01-15 12:50:28.502376z2011-01-20 12:50:28.593448)l m;-L¼l m;-L¼có¸—tddg|dœ«}|jd«}|jd«}td|dgdœ«}tj||«y)Nr r8r9r)rrr&r$r%)rdr-r.r1r/s     r2Ú#test_groupby_nth_int_like_precisionr_ˆsV€ô
˜!˜Q˜ dÑ+Ó    ,€Bàj‰j˜‹o€GØ [‰[˜‹^€Fܘq¨¨Q© yÑ1Ó2€Hä×ј& (Õ+r4)BÚnumpyr*r—Úpandasr©rrrrrrÚpandas._testingÚ_testingr$r3ÚmarkÚ parametrizerDrGrOr+rprQr^rmrrrzr€r‹rœrŸr¢r²r·rÁrÒr?r­Ú to_timedeltarÞrãrêrôrùrürrrrrrr)r'r*r.r0r2r5rBrhrPÚfilterwarningsrVrXr]r_©r4r2ú<module>ris³ðÛÛ ã÷÷õò/,ðd‡×ј G¨VÐ#4Ó5ñ,ó6ð,ð"‡×ј 1 b 'Ó*ñ,ó+ð,ð‡×ј G¨VÐ#4Ó5ñ&ó6ð&ð‡×ј G¨VÐ#4Ó5؇×ÑØñ ˜S¨D°%¸¿¹Ð+@ÑAÓ BÙ w  Ð(±°s°eÀ$Ô0GÔ Hð    
ñ
˜S¨B¯F©F¨8Ñ4¸FÔ CÙ w  Ð'©u°c°UÀÔ/FÔ Gð    
ð     ó ñ,ó ó6ð,ò )ò>ò :ò,ò&@ò*,òB8ò*-ò 6ò,ò8,ð‡×ÑØ)ðeÙ!Ð"7¸LÔIؐsñ ð eÙ!Ð"7¸LÔIؐsñ ð eÙ!Ð"7¸LÔIؐsñ ð    
ò&&áÐ3Ð8JÔKÙÐ3¸ ÔEÙÐ3¸ÔHðò
!ñ ð˜CjáÐ3Ð8JÔKÙÐ3¸ ÔEðð˜1vñ  ð˜CjáÐ3¸ÔHÙÐ3¸ ÔEðð˜1vñ  ð%    
ð%-ó0ñb<óc0ðb<ð0‡×ÑØà    ‘)˜L¨\Ô:¸CÐ@Ø    ‘˜<¨LÔ9¸3Ð?ðóñ,óð,ð2‡×ÑØ àˆ‰$˜ iÔ0؈‰!Q˜wÔ'؈‰˜  lÐ3Ó4؈‰˜˜A˜ SÔ)ð    óð‡×јÒ%DÓEñ 8óFóð 8ò 1,ðh‡×ÑØà    aSÐØ    BˆØ    Q˜FÐØ    ’IÐØ    aSÐØ    BˆØ    Q˜FÐØ    ’IÐð    ó ð‡×ј T¨2°¨u°s°e¸cÀ3¸ZÐ$HÓI؇×ј d¨E ]Ó3ñ,ó4óJó ð,ð‡×ÑØà    aSÐØ    BˆØ    Q˜FÐØ    ’IÐØ    aSÐØ    BˆØ    Q˜FÐØ    ’IÐð    ó ñ
,ó ð
,ò'ò<    ,ò ,𠇁×јÒ#7Ó8ñ ,ó9ð ,ð‡×јÒ#7Ó8ñ -ó9ð -ò,ò,,ð4‡×јÒ#;Ó<ñ-ó=ð-ð"‡×ÑØá    ˆtQ˜Ó    šLÐ)Ù    ˆtR‹š)Ð$Ù
a‹.™%  D›/Р   *Ò,AÐBØ
ˆQ‘b˜$“Р    Ò"7Ð8ð    óñ0óð0ò0ò%ò6ò,ò,ò$,ð.‡×ÑØ4à     ˆt’_¡d¨7£mÐ4Ø     ˆq1a&™$˜t›*Ð%Ø     ˆq’/¡4¨£=Ð1Ø     ˆr’9™d 5›kÐ*Ø    
ˆD’)™T %›[Ð)Ø    
ˆB‘T˜#“YÐØ     ˆTAq6™4 ›:Ð&Ø     ˆQ‘T˜#“YÐð    ó ð‡×ј F¨GÐ#4Ó5ñ ,ó6ó ð ,ð‡×ÑØBóñ,óð,ò" ,ð‡×ј s¨S¨E°C¸°:Ð&>Ó?؇×јÒ#7Ó8ñ&ó9ó@ð&ð&‡×ÑØ
ñ Ð2Ó 3Ù Ð2Ó 3ð    
ð    /ð ó    ñ,ó    ñ,r4