hyb
2026-01-30 15bc7727b58bf9ca0c8f21702fa893daac232b8d
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
266
267
268
269
Ë
oñúh÷ãóð—dZddlZddlZddlmZmZmZmZm    Z    m
Z
m Z m Z m Z ddlmZddlmZd„Zd„Zej*j,ej*j/ddd    g«ej*j/d
d d g«ej*j/d ddg«ej*j/dddddgge¬«ej*j/ddddgge¬«ej*j/ddd    g«ej*j/dddg«ej*j/ddd    g«ej*j/ddd    g«ej*j/ddd    g«d„«««««««««««Zej*j/ddd    g«d„«Zej*j/dd d!ggd"¢g«d#„«Zej*j/dd d!ggd"¢g«d$„«Zd%„Zd&„Zej>d'„«Z d(„Z!d)„Z"d*„Z#d+„Z$ej*j/d,gd-¢«ej*j/dddg«ej*j/d.gd/¢«ej*j/d0dd    g«ej*j/d1dd    g«d2„«««««Z%ej*j/d3dd    g«ej*j/d4d    dgd5¢gd6¢gd7¢fdd    gd8¢gd9¢gd:¢fddgd;¢gd<¢gd=¢fg«d>„««Z&ej>d?„«Z'ej*j/d@d    dd    dAgdB¢gdC¢fddd    dAgdD¢gdE¢fdd    d    dAgdF¢gdG¢fdd    ddHgdI¢gdG¢fg«dJ„«Z(ej>dK„«Z)ej*j/dLd    d    gdM¢gdN¢fd    dgdO¢gdP¢fdd    gdQ¢gdR¢fddgdS¢gdT¢fg«dU„«Z*ej>dV„«Z+ej*j/dWddXdXge
jXgdY¢gdZ¢¬[«fd    gd\¢e
e    dXg«e    gd]¢«e    d^d_ejZg«ggd`¢gda¢gdb¢ggdZ¢¬c«fg«ej*j/dddg«dd„««Z.ej*j/d0d    dg«ej*j/ded    dg«ej*j/dfd    dAej^gdg¢ej`¬h«fddHej^gdi¢«fg«dj„«««Z1dk„Z2ej*j/d0dd    g«ej*j/dfd    dAej^gdg¢ej`¬h«fddHej^gdi¢«fg«dl„««Z3ej*j/d0dd    g«ej*j/dfd    dAej^gdm¢ej`¬h«fddHej^gdn¢«fg«do„««Z4ej*j/d0dd    g«ej*j/dpd    gdq¢fdgdr¢fg«ej*j/dfd    dAej^gds¢ej`¬h«fddHej^gdt¢«fg«du„«««Z5ej*j/d0d    dg«ej*j/ded    dg«ej*j/dfd    dAej^gdg¢ej`¬h«fddHej^gdi¢«fg«dv„«««Z6ej*j/dwd    dAgdx¢fddHgdT¢fg«dy„«Z7ej*j/dzd{e8d|«gd}¢fd~e8d«d€gzgd¢fg«ej*j/d0d    dg«d‚„««Z9ej*j/dƒddg«d„„«Z:d…„Z;d†„Z<d‡„Z=dˆ„Z>d‰„Z?ej*j/ddd    g«dŠ„«Z@d‹„ZAej*j/dŒdd    g«ej*j/d3dd    g«d„««ZBej*j/dŒdd    g«ej*j/d3dd    g«dŽ„««ZCy)z­
these are systematically testing all of the args to value_counts
with different size combinations. This is to ensure stability of the sorting
and proper parameter handling
éN)    Ú CategoricalÚCategoricalIndexÚ    DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚ
date_rangeÚ to_datetime)ÚVersioncó\—tdgdgdœ«}|djd«|d<|jd«dj«}tddggddg¬«}|djd«|d<t    j
|«}t dg|d    ¬
«}tj||«y) NÚfemaleÚUS)ÚgenderÚcountryrÚcategoryr©ÚcolumnséÚcount©ÚindexÚname)    rÚastypeÚgroupbyÚ value_countsrÚ
from_framer    ÚtmÚassert_series_equal)ÚdfÚresultÚdf_mi_expectedÚ mi_expectedÚexpecteds     úaH:\Change_password\venv_build\Lib\site-packages\pandas/tests/groupby/methods/test_value_counts.pyÚ.tests_value_counts_index_names_category_columnr&s¶€ä    àjؐvñ    
ó
€Bð h‘<×&Ñ& zÓ2€B€xLØ Z‰Z˜    Ó " 8Ñ ,× 9Ñ 9Ó ;€Fô  xР0Ð1¸IÀxÐ;PÔQ€NØ-¨hÑ7×>Ñ>¸zÓJ€N8ÑÜ×'Ñ'¨Ó7€Kܐqc °7Ô;€Hä×ј6 8Õ,óc    óì—tdd¬«}ttjj    d«j t d«|«tjj    d«j ||«tjj    d«jd|dz|«dœ«}|rÁ|djd    «|d<tj|jddd
…d f<tj|jd dd …df<tj|jddd…df<tj|jddd…df<tj|jddd…df<|S)Nz
2015-08-24é
)ÚperiodséÚabcdr)Ú1stÚ2ndÚ3rdr/Úfloaté r-éér.éééé    ) r
rÚnpÚrandomÚ default_rngÚchoiceÚlistÚintegersrÚnanÚloc)Ú    seed_nansÚnÚmÚdaysÚframes     r%Úseed_dfrE.s2€Ü l¨BÔ /€Dä ä—9‘9×(Ñ(¨Ó+×2Ñ2´4¸³<ÀÓCÜ—9‘9×(Ñ(¨Ó+×2Ñ2°4¸Ó;Ü—9‘9×(Ñ(¨Ó+×4Ñ4°Q¸¸A¹¸qÓAñ    
ó €Eñà˜U‘|×*Ñ*¨7Ó3ˆˆe‰ Ü"$§&¡&ˆ    ‰    !%R%˜,ÑÜ"$§&¡&ˆ    ‰    !%R%˜,ÑÜ"$§&¡&ˆ    ‰    !%R%˜,ÑÜ"$§&¡&ˆ    ‰    !%R%˜,ÑÜ"$§&¡&ˆ    ‰    !%R%˜,Ñà €Lr'r@TFÚnum_rowsr)é2Úmax_intééÚkeysr-r.)ÚidsÚbinsÚisortznormalize, name)TÚ
proportion)FrÚsortÚ    ascendingÚdropnac óò—t|||«} d„} |||    |
|dœ} | j||¬«}|djdi| ¤Ž}| j||¬«}|djtjfi| ¤Ž}|j
j dddgz|j
_|j|«}t| ||f«\}}tj|j«|j««y)Ncóò—tt|jjt    |jj
«««}t j||jj¬«|_|S)N©Únames)    r<ÚmaprÚget_level_valuesÚrangeÚnlevelsrÚ from_arraysrV)r Úarrs  r%Ú rebuild_indexz7test_series_groupby_value_counts.<locals>.rebuild_index_sM€Ü”3r—x‘x×0Ñ0´%¸¿¹×8HÑ8HÓ2IÓJÓKˆÜ×)Ñ)¨#°R·X±X·^±^ÔDˆŒØˆ    r')Ú    normalizerPrQrRrM©rPr/éÿÿÿÿ©) rErrÚapplyr    rrVÚrenamerWrrÚ
sort_index)r@rFrHrKrMrNr^rrPrQrRr r]ÚkwargsÚgrÚleftÚrights                 r%Ú test_series_groupby_value_countsriEsõ€ô0
˜H gÓ    .€Bòð ØØØØñ €Fð
‰D˜uˆÓ    %€BØ !ˆ2ˆe‰9× !Ñ !Ñ + FÑ +€Dà     ‰D˜uˆÓ    %€BØ ˆBˆu‰IO‰OœF×/Ñ/Ñ :°6Ñ :€EØŸ ™ ×)Ñ)¨#¨2Ð.°%°Ñ8€E‡KKÔà L‰L˜Ó €Eôm d¨E ]Ó3K€Dˆ%Ü×ј4Ÿ?™?Ó,¨e×.>Ñ.>Ó.@ÕAr'Úutccóâ—tgd¢gd¢dœ«jdg«}t|d|d¬«|d<|jt    d    d¬
««}|d j «j «}|d jtj
«j «}|jj|j_
|jd «}tj||«y) N©i©GI]i)™J]i™J]i©êK]i)<M]iU=M]i©N]©ÚapplernÚbananaroÚorangerpÚpear©Ú    TimestampÚFoodr2rsÚs©rjÚunitÚDatetimeÚ1D©ÚfreqÚkeyrtr)rÚdropr rrrrdrbr    rrVrcrr)rjr Údfgr!r$s     r%Ú-test_series_groupby_value_counts_with_grouperrzsπô
òòWñ     
ó
÷ dˆAˆ3ƒiðô!  K¡°cÀÔD€B€zNØ
*‰*”W $¨JÔ7Ó
8€Cð‰[× %Ñ %Ó '× 2Ñ 2Ó 4€Fؐ6‰{× Ñ ¤×!4Ñ!4Ó5×@Ñ@ÓB€HØ!Ÿ<™<×-Ñ-€H‡NNÔà‰˜wÓ'€Hä×ј6 8Õ,r'rÚAÚB)r€rÚCcó—t|¬«}|j|dd«}||dj«}tg|jd¬«}t j ggt|«z|¬«|_tj||«y)Nrr`r)ÚdtyperrU) rrrr    r„rr[Úlenrrr©rr r~r!r$s     r%Ú&test_series_groupby_value_counts_emptyr‡™sz€ô
˜7Ô    #€BØ
*‰*W˜S˜b\Ó
"€Cà ˜‘Ñ × *Ñ *Ó ,€Fܐb § ¡ °7Ô;€HÜ×+Ñ+¨R¨D´3°w³<Ñ,?ÀwÔO€H„Nä×ј6 8Õ,r'cóä—ttt|««g|¬«}|j|dd«}||dj    «}|j    «}t j ||«y)N)Údatarr`)rrYr…rrrrr†s     r%Ú(test_series_groupby_value_counts_one_rowrЦsc€ô
œœs 7›|Ó,Ð-°wÔ    ?€BØ
*‰*W˜S˜b\Ó
"€Cà ˜‘Ñ × *Ñ *Ó ,€F؏‰Ó €Hä×ј6 8Õ,r'c ó8—ttdgddg¬««}|jdg«j«}tddgt    j
t jddg«tddgddgdd¬«g«d    ¬
«}tj||«y) NÚaÚb)Ú
categoriesrrFr)rŽÚorderedr„r©r‰rr) r    rrrrr[r8Úarrayrrr)rur!r$s   r%Ú/test_series_groupby_value_counts_on_categoricalr’²s—€ô    Œ{˜C˜5¨c°3¨ZÔ8Ó9€AØ Y‰Y˜s‹^× (Ñ (Ó *€F䨐ˆVÜ×$Ñ$ä—‘˜!˜Q˜Ó Ü Ø˜#J¨C°¨:¸uÈJôð ó
ðô €Hô$×ј6 8Õ,r'có—tgd¢gd¢gd¢dœ«}|jddgd¬«d    }|jd¬«}td
d gd d ggd¢ggd¢gd¢gd¢ggd¢¬«}t    gd¢|d¬«}t j ||«y)N©Úmaler•rr•rr•©ÚlowÚmediumÚhighr—r™r—©rÚFRrr›r›r›©rÚ    educationrrrFr_rrr›r•r)r—r˜r™)rrrrr)rrrrr)rrr+rr+©rrr©ÚlevelsÚcodesrV©rrrr+rrr)rrrrr    rr)r Úgbr!rr$s     r%Ú(test_series_groupby_value_counts_no_sortr¤Ís“€ä    âJÚHÚ;ñ    
ó
€Bð
‰Y Ð)°ˆÓ    6°{Ñ    C€BØ _‰_ %ˆ_Ó (€FÜ Øt ˜v xÐ0Ò2KÐLÚ¢²ÐAÚ0ô €Eô
’o¨U¸ÔA€HÜ×ј6 8Õ,r'có,—tgd¢gd¢gd¢dœ«S)Nr”r–ršrœ©rrar'r%Ú education_dfr§ás€ä âJÚHÚ;ñ    
ó ðr'có—d}tjt|¬«5|jdd¬«}ddd«t    j
t d¬«5j«ddd«y#1swYŒ>xYw#1swYyxYw)Nz+DataFrame.groupby with axis=1 is deprecated©Úmatchrr©Úaxisr¬)rÚassert_produces_warningÚ FutureWarningrÚpytestÚraisesÚNotImplementedErrorr)r§ÚmsgÚgps   r%Ú    test_axisr´ìst€Ø
7€CÜ     ×    #Ñ    #¤M¸Ô    =ñ5Ø × !Ñ ! )°!Ð !Ó 4ˆ÷5ä    ‰Ô*°&Ô    9ñØ
‰Ô÷ð÷5ð5ú÷ðúsžA/ÁA;Á/A8Á;Bcó¬—|jd«}tjtd¬«5|j    dg¬«ddd«y#1swYyxYw)NrÚsubsetr©©r¶)rr¯r°Ú
ValueErrorr)r§r³s  r%Útest_bad_subsetr¹ôsE€Ø    ×    Ñ    ˜iÓ    (€BÜ    ‰”z¨Ô    2ñ,Ø
‰     ˜{ˆÔ+÷,÷,ñ,ús ­A
Acóx—ttj«td«k\r0|jtj
j dd¬««|jd«ddgjd¬    «}tgd
¢tjgd ¢gd ¢¬ «d¬«}tj||«y)Nú1.25úYpandas default unstable sorting of duplicatesissue with numpy>=1.25 with AVX instructionsF©ÚreasonÚstrictrrrT©r^)çà?çÐ?rÂrÁrÁ)©r›r•r—©r›rr™©r›r•r˜©rrr™©rr•r—ržrUrOr)r r8Ú __version__Ú applymarkerr¯ÚmarkÚxfailrrr    rÚ from_tuplesrr)r§Úrequestr!r$s    r%Ú
test_basicrÎúsµ€äŒr~‰~Ó¤'¨&£/Ò1Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ð× !Ñ ! )Ó ,¨h¸ Ð-DÑ E× RÑ RØðSó€FôÚ (Ü×$Ñ$ò ò5ô    
ðô €Hô×ј6 8Õ,r'có0—||j|||¬«S)N©r^rPrQ)r)r rKr^rPrQs     r%Ú_frame_value_countsrÑs€Ø ˆd‰8×  Ñ  ¨9¸4È9Ð  Ó UÐUr'r©Úcolumnr‘Úfunctionzsort, ascending))FN)TT)TFÚas_indexrDc
󞇗ttj«td«k\r6|r4|r2|r0|jtj
j dd¬««d‰djˆfd„dœ|}
‰j|
|¬«} | d    d
gj|||¬ «} |r    |d k(rtnd} d }tj| |¬«5| jtd    d
g|||«}ddd«|rtj| «y|rdnd}j!«j#d|id¬«}|d k(r3|j#ddid¬«}tj$|ddd«|d<n.|dk(r |ddk(|d<ntj$|ddd«|d<tj&| |«y‰d    dz‰d
z‰d<| dj|||¬ «}||_|r"|j*j-d¬«}|dj.j1d«j.j3d«|d    <|dj.j1d«j.j3d«|d
<|d=|j#ddid¬«}t5j6|«|_|j8j;«dr,dg|j*j<ddz|j*_tj| |«y|j?dd    |dj.j1d«j.j3d««|j?dd
|dj.j1d«j.j3d««|    r|jAdddœ«}|d=tj&| |«y#1swYŒÝxYw)Nr»r¼Fr½rcó•—‰d|dk(S)Nrrra)Úxr§s €r%ú<lambda>z6test_against_frame_and_seriesgroupby.<locals>.<lambda>Ksø€˜l¨9Ñ5°aÑ8¸DÑ@€r'rÒ)ÚbyrÕrrrÐrÓz7DataFrameGroupBy.apply operated on the grouping columnsr©rOrrrr«Úlevel_0rr›rÔú-Úboth©rr+Ústr)rr)!r r8rÈrÉr¯rÊrËÚvaluesrrr®rr­rbrÑrÚ reset_indexrcÚwhereÚassert_frame_equalrrÚto_framerßÚsplitÚgetrrrÚisnarVÚinsertr)r§rr^rrPrQrÕrDrÍÚusing_infer_stringrÚr³r!Úwarnr²r$Ú index_frameÚ index_frame2s`                 r%Ú$test_against_frame_and_seriesgroupbyrís¸ø€ô@Œr~‰~Ó¤'¨&£/Ò1±eÁÉØ×ÑÜ K‰K× Ñ ðCðð ó ô    
ðؘiÑ(×/Ñ/Û@ñ
ðñ    
€Bð
×    Ñ     ¨hР   Ó    7€BØ ˜;Ð'Ñ (× 5Ñ 5Ø $°)ð6ó€Fò à '¨8Ò 3}¸ˆØGˆÜ × 'Ñ '¨°CÔ 8ñ    Ø—x‘xÜ# h° Ð%<¸iÈÈyóˆH÷    ñ
Ü × "Ñ " 6¨8Õ 4á#,‘<°'ˆDØ×+Ñ+Ó-×4Ñ4°a¸°YÀQÐ4ÓGˆHؘ(Ò"Ø#Ÿ?™?¨I°yÐ+AȘ?ÓJÜ&(§h¡h¨x¸    Ñ/BÀDÈ$Ó&O˜Ò#ؘJÒ&Ø&.¨yÑ&9¸QÑ&>˜Ò#ä&(§h¡h¨x¸    Ñ/BÀDÈ$Ó&O˜Ñ#Ü × !Ñ ! &¨(Õ 3ð ,¨HÑ5¸Ñ;¸lÈ;Ñ>WÑWˆ VÑØf‘:×*Ñ*Ø d°ið+ó
ˆðˆŒ Ú Ø"Ÿ.™.×1Ñ1¸Ð1Ó>ˆKØ$/°Ñ$7×$;Ñ$;×$AÑ$AÀ#Ó$F×$JÑ$J×$NÑ$NÈqÓ$QˆK˜Ñ !Ø'2°6Ñ':×'>Ñ'>×'DÑ'DÀSÓ'I×'MÑ'M×'QÑ'QÐRSÓ'TˆK˜ Ñ $ؘFÐ#Ø&×-Ñ-¨q°$¨i¸aÐ-Ó@ˆLÜ'×2Ñ2°<Ó@ˆHŒNà×#Ñ#×(Ñ(Ó*¨1Ò-ð)- v°·±×0DÑ0DÀQÀRÐ0HÑ'H—‘Ô$Ü × "Ñ " 6¨8Õ 4à O‰O˜A˜x¨°&Ñ)9×)=Ñ)=×)CÑ)CÀCÓ)H×)LÑ)L×)PÑ)PÐQRÓ)SÔ TØ O‰O˜A˜{¨H°VÑ,<×,@Ñ,@×,FÑ,FÀsÓ,K×,OÑ,O×,SÑ,SÐTUÓ,VÔ WÙ!Ø#Ÿ?™?°eÈ%Ñ+PÓQØ˜Ð Ü × !Ñ ! &¨(Õ 3÷[    ñ    ús à OÏO r^zCsort, ascending, expected_rows, expected_count, expected_group_size)rrr+r2ér¢)rr2rr2r)r2rrr+rî)r+rrrr)r2rr2rr)rrr+rîr2)rrrrr+)rr2rrr2c    ó—|}    |j|    «}|jj|    «|_|jddgdd¬«}
|
dj|||¬«} t    «} dD]L} |Dcgc]
}|| |‘Œ c}| | <| j|    «} | jj|    «| _ŒN|r.|| d<| dxx|zcc<|    d    k(r7| dj «| d<n || d
<|    d    k(r| d
j «| d
<|r|    t k(r| jd d d dœ«} tj| | «ycc}w) NrrF©rÕrPrrÐržrOzstring[pyarrow]rrß)    rrrrrÚconvert_dtypesÚobjectrrã)r§r^rPrQÚ expected_rowsÚexpected_countÚexpected_group_sizeÚany_string_dtyperér„r³r!r$rÓÚrows               r%Ú test_compoundrø†sq€ð( €EØ×&Ñ& uÓ-€LØ'×/Ñ/×6Ñ6°uÓ=€LÔà    ×    Ñ    ˜y¨(Ð3¸eÈ%Р   Ó    P€BØ  ‰_× )Ñ )Ø $°)ð*ó€Fô‹{€HØ4ò:ˆØANÖO¸#˜L¨Ñ0°Ó5ÒOˆÑØ—?‘? 5Ó)ˆØ#×+Ñ+×2Ñ2°5Ó9ˆÕð:ñØ!/ˆÑؐÓÐ"5Ñ5ÓØ Ð%Ò %à%-¨lÑ%;×%JÑ%JÓ%LˆH\Ò "à*ˆÑØ Ð%Ò %Ø (¨Ñ 1× @Ñ @Ó BˆHWÑ Ù˜e¤všoØ—?‘?ب¸UÑ Có
ˆô×ј& (Õ+ùò%PsÁ4Ecó4—tgd¢gd¢gd¢dœgd¢¬«S)N©rrrr)r+rîrîé)r+rrr©r|Únum_legsÚ    num_wings)ÚfalconÚdogÚcatÚantrÞr¦rar'r%Ú
animals_dfr¹s€ä Úª,Â\ÑRÚ-ô ðr'z?sort, ascending, normalize, name, expected_data, expected_indexr©rr+r)©rrr)r+rîrû©r+rr©rrr+)r)r+rûrîr©r+rr)r)rîr+rû)rr+rrO)rÁrÂrÂcó—|j|||¬«}t|tj|gd¢¬«|¬«}t    j
||«|j d«j|||¬«}    t    j
|    |«y)N)rPrQr^rürUrr|)rr    rr[rrr)
rrPrQr^rÚ expected_dataÚexpected_indexÚ result_framer$Úresult_frame_groupbys
          r%Útest_data_frame_value_countsrÁs–€ð*×*Ñ*Ø ˜Y°)ð+ó€LôØ Ü×$Ñ$Ø Ò"Bô
ðô €Hô×ј<¨Ô2à%×-Ñ-¨eÓ4×AÑAØ ˜Y°)ðBóÐô×ÑÐ/°Õ:r'cóŠ—tj}tdd|d|ddddg    ddd||ddddg    dddddd|d|g    ddddddd||g    d    œ«S)
Nrrîrûr2r+rIr6r4)r€rr‚ÚD)r8r>r)rAs r%Únulls_dfrésu€ä
‰€AÜ àQ˜˜1˜a  A q¨!Ð,ؐQ˜˜1˜a  A q¨!Ð,ؐQ˜˜1˜a  A q¨!Ð,ؐQ˜˜1˜a  A q¨!Ð,ñ        
ó ðr'z:group_dropna, count_dropna, expected_rows, expected_values)    rrr2rIr4rûr6r+rî)    rÁrÁçð?rÂrÂrÂrÂrr)rrr2rIr+rî)rÁrÁrrrr)rrrIr4rûr6)rÁrÁrÂrÂrÂrÂ)rrrI)rÁrÁrcóè—ttj«td«k\r2|s0|jtj
j dd¬««|jddg|¬«}|jdd|¬    «}t«}|jD]}    |D
cgc]
}
||    |
‘Œ c}
||    <Œtj|«} t|| d
¬ «} tj|| «ycc}
w) Nr»r¼Fr½r€r)rRT)r^rPrRrOr)r r8rÈrÉr¯rÊrËrrrrrrr    rr) rÚ group_dropnaÚ count_dropnaróÚexpected_valuesrÍr³r!rrÓr÷rr$s              r%Útest_dropna_combinationsrösê€ô"Œr~‰~Ó¤'¨&£/Ò1¹,Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ð
×    Ñ    ˜3 ˜*¨\Р   Ó    :€BØ _‰_ t°$¸|ˆ_Ó L€FÜ‹k€GØ×"Ñ"òKˆØ<IÖJ°S˜8 FÑ+¨CÓ0ÒJˆŠðKä × !Ñ ! 'Ó *€Eܘ?°%¸lÔK€HÜ×ј6 8Õ,ùòKsÂC/có0—tgd¢gd¢d||dgdœ«S)Nrú)ÚJohnÚAnnerÚBethÚSmithÚLouise©r|Ú
first_nameÚ middle_namer¦)Ú nulls_fixtures r%Únames_with_nulls_dfr"s&€ä âÚ:Ø# ]°MÀ8ÐLñ    
ó ðr'z%dropna, expected_data, expected_indexr)©rr)rr)rrrrUrú)rrrrr)rrrr)rrr+r+)r+rrr+rŸcó—|j||¬«}t|||¬«}|r|tt|««z}t    j
||«|j d«j||¬«}t    j
||«y)N)rRr^rr|)rr    r0r…rrr)    r"rRr^rr
r r r$r s             r%Ú#test_data_frame_value_counts_dropnar%&s€ðB'×3Ñ3¸6ÈYÐ3ÓW€LÜØ ØØ ô€Hñ
Ø”Eœ#˜mÓ,Ó-Ñ-ˆä×ј<¨Ô2à.×6Ñ6°uÓ=×JÑJØ ðKóÐô×ÑÐ/°Õ:r'Úobservedznormalize, name, expected_data) r+rrrrrrrrrrr©r„) rÁrÂrÂçr(r(rÁrÁr(r(r(r(có˜—ttj«td«k\r0|jtj
j dd¬««|jd«jd||¬«}|j|¬«}tjgd    ¢gd
¢¬ «}    t||    |¬ «}
td «D]D} |
jjt!|
jj"| «| ¬«|
_ŒF|rt%j&||
«y|
j)|rdnd¬«} t%j*|| «y)Nr»r¼Fr½rr©rÕr&rÀ© rÃrÄrÅ©r›rr—©r›rr˜©r›r•r™rÆrÇ©rrr—©rrr˜©rr•r™©rr•r˜ržrUrr2©ÚlevelrOr©r)r r8rÈrÉr¯rÊrËrrrrrÌr    rYrÚ
set_levelsrr rrrárã© r§rÕr&r^rr
rÍr³r!r Úexpected_seriesÚir$s              r%Ú=test_categorical_single_grouper_with_only_observed_categoriesr:YsE€ô,Œr~‰~Ó¤'¨&£/Ò1Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ð
×    Ñ    ˜ZÓ    (×    0Ñ    0ؘH¨xð
1ó
€Bð_‰_ yˆ_Ó 1€Fä×+Ñ+ò     
ò1ô€Nô$Ø ØØ ô€Oô
1‹Xò
ˆØ /× 5Ñ 5× @Ñ @Ü ˜_×2Ñ2×9Ñ9¸!Ñ<Ó =ÀQð!Aó!
ˆÕð
ñ
Ü
×јv Õ7à"×.Ñ.Ù!*‘°ð/ó
ˆô     ×јf hÕ/r'có —|j«jd«}|djjdg«|d<|j    d||¬«}|j |¬«}t |tj|gd¢¬«|¬«}    td    «D]s}
t|    jj|
«} |
d
k(r(| j|djj«} |    jj| |
¬ «|    _ Œu|rt!j"||    «y|    j%|¬ «} t!j&|| «y) NrrÚASIAr*rÀržrUrr2rr3r5)ÚcopyrrÚadd_categoriesrrr    rrÌrYrrr Úset_categoriesrŽr6rrrárã) r§rÕr&r r^rr
r³r!r8r9Ú index_levelr$s              r%Ú!assert_categorical_single_grouperrA¤sD€ð ×$Ñ$Ó&×-Ñ-¨jÓ9€Lð+¨9Ñ5×9Ñ9×HÑHÈ&ÈÓR€LÑà    ×    Ñ    ˜i°(ÀXР   Ó    N€BØ _‰_ yˆ_Ó 1€FäØ Ü×$Ñ$Ø Ú4ô
ðô €Oô1‹XòWˆÜ& ×'<Ñ'<×'CÑ'CÀAÑ'FÓGˆ Ø Š6Ø%×4Ñ4ؘYÑ'×+Ñ+×6Ñ6óˆKð!0× 5Ñ 5× @Ñ @ÀÐTUР@Ó VˆÕð WñÜ
×јv Õ7à"×.Ñ.°DÐ.Ó9ˆÜ
×јf hÕ/r'c    óڗttj«td«k\r0|jtj
j dd¬««gd¢}t||d||||¬«y)Nr»r¼Fr½r+T©r§rÕr&r r^rr
©r r8rÈrÉr¯rÊrËrA©r§rÕr^rr
rÍr s       r%Ú-test_categorical_single_grouper_observed_truerFÇso€ô*Œr~‰~Ó¤'¨&£/Ò1Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ò €Nô&Ø!ØØØ%ØØ Ø#ör')r+rrrrrrrrrrrrrrrrr)rÁrÂrÂr(r(r(rÁrÁr(r(r(r(r(r(r(r(r(r(c    óڗttj«td«k\r0|jtj
j dd¬««gd¢}t||d||||¬«y)Nr»r¼Fr½)rÃrÄrÅr,r-r.rÆrÇr/r0r1r2)r<rr™)r<rr—)r<rr˜)r<r•r™)r<r•r—)r<r•r˜rCrDrEs       r%Ú.test_categorical_single_grouper_observed_falserHsp€ôXŒr~‰~Ó¤'¨&£/Ò1Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ò€Nô*&Ø!ØØØ%ØØ Ø#ör'zobserved, expected_index) ©r›r™r)r›r™r•©r›r—r•)r›r—r©r›r˜r•)r›r˜r©rr™r)rr™r•©rr—r•)rr—r)rr˜r)rr˜r•)rIrJrKrLrM) rrr+rrrrrrrrr) rr(rr(rr(rr(rr(r(r(có\—|j«}|djd«|d<|djd«|d<|jddg||¬«}|j|¬«}t    |r||dkDn|t j |gd¢¬«|¬    «}    td
«D]D}
|    jjt|    jj|
«|
¬ «|    _ŒF|rtj||    «y|    j|rd nd ¬«} tj|| «y)Nrrrr*rÀr()rrrrUrr+r3rOrr5)r=rrrr    rrÌrYrr6rr rrrárã) r§rÕr&r r^rr
r³r!r8r9r$s             r%Ú"test_categorical_multiple_groupersrOXs@€ðn ×$Ñ$Ó&€LØ*¨9Ñ5×<Ñ<¸ZÓH€LÑØ ,¨[Ñ 9× @Ñ @ÀÓ L€LÑà    ×    Ñ    Ø    KР¨8¸hð
ó
€Bð_‰_ yˆ_Ó 1€FäÙ3;ˆ]˜=¨3Ñ.Ò /ÀÜ×$Ñ$Ø Ú4ô
ðô €Oô1‹Xò
ˆØ /× 5Ñ 5× @Ñ @Ü ˜_×2Ñ2×9Ñ9¸!Ñ<Ó =ÀQð!Aó!
ˆÕð
ñ
Ü
×јv Õ7à"×.Ñ.Ù!*‘°ð/ó
ˆô     ×јf hÕ/r'cóø—ttj«td«k\r0|jtj
j dd¬««|j«}|djd«|d<|djd«|d<|jd||¬    «}|j|¬
«}gd ¢}    t|tj|    gd ¢¬ «|¬«}
tdd«D]D} |
jj!t#|
jj$| «| ¬«|
_ŒF|rt'j(||
«y|
j+|rdnd¬«} t'j,|| «y)Nr»r¼Fr½rrrrr*rÀr+ržrUrrr2r3rOrr5)r r8rÈrÉr¯rÊrËr=rrrr    rrÌrYrr6rr rrrárãr7s              r%Útest_categorical_non_groupersrQ®sw€ô0Œr~‰~Ó¤'¨&£/Ò1Ø×ÑÜ K‰K× Ñ ðCðð ó ô    
ð ×$Ñ$Ó&€LØ)¨(Ñ3×:Ñ:¸:ÓF€LÑØ ,¨[Ñ 9× @Ñ @ÀÓ L€LÑà    ×    Ñ    ˜i°(ÀXР   Ó    N€BØ _‰_ yˆ_Ó 1€Fò €NôØ Ü×$Ñ$Ø Ú4ô
ðô €Oô1a‹[ò
ˆØ /× 5Ñ 5× @Ñ @Ü ˜_×2Ñ2×9Ñ9¸!Ñ<Ó =ÀQð!Aó!
ˆÕð
ñ
Ü
×јv Õ7à"×.Ñ.Ù!*‘°ð/ó
ˆô     ×јf hÕ/r'z*normalize, expected_label, expected_valuesrc ó—tgd¢gd¢dœ«}|jgd¢dd„gd¬«}|jd    |¬
«}td tjgd ¢t
¬ «dgd¢dgd¢dgd¢||i«}t j||«y)Nr©rr+r2)r€r)rîrIrîr€có—|dk(rdSdS)Nrr4r6ra)r9s r%rÙz&test_mixed_groupings.<locals>.<lambda>s€°A¸²F¨q€À€r'F©rÕT©rPr^rÛ)rîrîrIr'rÚlevel_2)r6r6r4r)rr2r+)rrrr8r‘Úintrrã)r^Úexpected_labelrr r³r!r$s       r%Útest_mixed_groupingsrZüs„€ô
šªÑ3Ó    4€BØ     ‰’Y Ñ%AÐBÈUˆÓ    S€BØ _‰_ $°)ˆ_Ó <€FÜà ”r—x‘x¢    ´Ô5Ø ’Ø ’yØ ’Ø ˜Oð     
ó€Hô×ј& (Õ+r'ztest, columns, expected_namesÚrepeatÚabbde)rŒNÚdrrÚer4r,Úlevel_1)rŒNr]rÚcr_có
—tgd¢gd¢g|¬«}ddg}dtjddgtj¬    «d
g}|j    ||¬ «j «}|r:t d tj||¬ «d¬«}tj||«y|D    cgc]}    t|    «dgz‘Œ}}    t|«}
d|
d<|
jd«t||
¬«}tj||«ycc}    w)N)rr2rIr4r7)r+rîrûr6r)r)rrr4r2rIr7)r+rr6rîrûr)rŒrrr'r]rUr#rUrrr_)rr8r‘Úint64rrr    rrÌrrr<Úappendrã) ÚtestrÚexpected_namesrÕr r
rKr!r$r÷Úexpected_columnss            r%Útest_column_label_duplicatesrgsú€ô
’OÒ%5Ð6ÀÔ    H€BØ'Ð)<Ð=€MØ ”—‘˜1˜a˜&¬¯©Ô1°3Ð 7€DØ Z‰Z˜ xˆZÓ 0× =Ñ =Ó ?€FÙÜØÜ×(Ñ(ØØ$ôðô 
ˆô     ×јv xÕ0à4AÖB¨Sœ˜c› a S›ÐBˆ ÐBÜ Ó/ÐØ'Ð˜ÑØ×Ñ Ô(ܘ]Ð4DÔEˆÜ
×јf hÕ/ùò CsÂ#Dznormalize, expected_labelcóܗtgd¢gdd|g¬«jdd¬«}d|›d}tjt|¬    «5|j |¬
«ddd«y#1swYyxYw) NrSrŒrrFrUzColumn label 'z' is duplicate of result columnr©rÀ)rrr¯r°r¸r)r^rYr£r²s    r%Útest_result_label_duplicatesri6sr€ô
’I;¨¨c°>Ð(BÔ    C×    KÑ    KØ eð
Ló
€Bð ˜>Ð*Ð*IÐ
J€CÜ    ‰”z¨Ô    -ñ-Ø
‰ )ˆÔ,÷-÷-ñ-ús ÁA"Á"A+có,—tdddgi«}|jtjddgtj¬««}|j «}t dgtjddggddg¬«d¬«}tj||«y)NrŒrr'r+rUrr) rrr8r‘rbrr    rrÌrr)r r£r!r$s    r%Útest_ambiguous_groupingrkGs}€ä    C˜!˜Q˜=Ó    !€BØ     ‰”B—H‘H˜a ˜V¬2¯8©8Ô4Ó    5€BØ _‰_Ó €FÜØ    
ˆ”:×)Ñ)¨A¨q¨6¨(¸4À¸+ÔFÈWô€Hô×ј6 8Õ,r'cóؗtgd¢gd¢dœgd¢¬«}d}tjt|¬«5|j    d«j dg¬    «ddd«y#1swYyxYw)
N©rŒrr`©rØÚyro©Úc1Úc2©rrrrÞz;Keys {'c1'} in subset cannot be in the groupby column keys.r©rqr·©rr¯r°r¸rr©r r²s  r%Ú"test_subset_overlaps_gb_key_raisesrvRsW€ä    š/²ÑAÊÔ    S€BØ
G€CÜ    ‰”z¨Ô    -ñ5Ø

‰
4Ó×%Ñ%¨d¨VÐ%Ô4÷5÷5ñ5úó ´#A Á A)cóؗtgd¢gd¢dœgd¢¬«}d}tjt|¬«5|j    d«j d    g¬
«ddd«y#1swYyxYw) NrmrnrprsrÞz4Keys {'c3'} in subset do not exist in the DataFrame.r©rqÚc3r·rtrus  r%Ú!test_subset_doesnt_exist_in_framerzZsW€ä    š/²ÑAÊÔ    S€BØ
@€CÜ    ‰”z¨Ô    -ñ5Ø

‰
4Ó×%Ñ%¨d¨VÐ%Ô4÷5÷5ñ5úrwcóü—tgd¢gd¢dœgd¢¬«}|jd¬«jdg¬    «}td
d gt    j
dd
gd d ggddg¬«d¬«}t j||«y)NrmrnrprsrÞrr3rrr·rr+rØrorUrr©rrrr    rr[rr©r r!r$s   r%Ú test_subsetr~bsz€ä    š/²ÑAÊÔ    S€BØ Z‰Z˜aˆZÓ  × -Ñ -°d°VÐ -Ó <€FÜØ    
ˆAˆÜ×$Ñ$ q¨! f¨s°C¨jÐ%9À$ÈÀÔNØ ô€Hô
×ј6 8Õ,r'c    ó —tgd¢gd¢gd¢ggd¢gd¢¬«}|jd¬«jdg¬    «}td
d gt    j
dd
gd d gd d gggd¢¬«d¬«}t j||«y)N)rŒrØrØ)rrorors)rqrrrr)rrrr3rrr·rr+rØro)NrrrrrUrrr|r}s   r%Útest_subset_duplicate_columnsr€ns€ä    Ú    š/ª?Ð;ÚÚ"ô
€Bð
Z‰Z˜aˆZÓ  × -Ñ -°d°VÐ -Ó <€FÜØ    
ˆAˆÜ×$Ñ$ؐˆVc˜3Z # s Ð ,Ò4Fô
ðô €Hô×ј6 8Õ,r'cóî—tgd¢gd¢dœ«jdg«}t|d|d¬«jj    |«|d<|j t d    d¬
««}|j«}tgd ¢|¬ «j    |«}|dj«}t||gd ¢ggd¢td«gd¢ggd¢¬«}td|d¬«}tj||«y)Nrlrmrrr2rsrurvrxryrz)z
2019-08-06z
2019-08-07z
2019-08-09z
2019-08-10)rj)rnrorprq)rrrr+r+r2rû)rrrr+r+r2)rxrsrtrŸrrr)rr}r ÚdtÚas_unitrrrÚuniquerrYr    rr)    rjrwr r£r!ÚdatesÚ
timestampsrr$s             r%Útest_value_counts_time_grouperr‡€sï€ô
òòWñ     
ó
÷ dˆAˆ3ƒiðô!  K¡°cÀÔD×GÑG×OÑOÐPTÓU€B€zNØ     ‰”G ¨:Ô6Ó    7€BØ _‰_Ó €FÜ Ú@Àcô ç gˆdƒmð
ðK‘×'Ñ'Ó)€JÜ ØzÒ#HÐIÚ!¤5¨£8Ò-?Ð@Ú/ô €Eô
a˜u¨7Ô3€HÜ×ј6 8Õ,r'cóؗtgd¢gd¢gd¢dœ«}|jddgdd¬«}|d    j«}tgd¢gd¢gd¢dd
œ«}tj||«y) N)rŒrŒrŒ)rŒrŒr]rmrSrr+Frðr2)rr+r2r)rrrrrã)r r³r!r$s    r%Ú!test_value_counts_integer_columnsr‰¢se€ä    ’ª?ºÑOÓ    P€BØ     ‰Q˜F U°ˆÓ    7€BØ ‰U× Ñ Ó !€FÜÚ ¢²OÈaÑPó€Hô×ј& (Õ+r'Úvc_sortcór—tgd¢gd¢dœ«}|jd|¬«}|j||¬«}|rgd¢}ngd¢}td    d
gd d gggd ¢gd¢gddg¬«}t    |||rdnd¬«}|r|rgd¢}    n|r|sgd¢}    n |s|rgd¢}    ngd¢}    |j |    «}t j||«y)N©r+rrr©r2rîr2r2©rŒrrŒr_rV)çUUUUUUå?çUUUUUUÕ?rrrr+r2rî)rrr)rrrrrŸrOrr)rrr+)rr+r)r+rr)rrrrr    Útakerr)
rPrŠr^r r£r!ràrr$Útakers
          r%Útest_value_counts_sortr“­sÀ€ô
šª,Ñ7Ó    8€BØ     ‰C˜dˆÓ    #€BØ _‰_ '°Yˆ_Ó ?€FáÚ$‰âˆÜ ؐA˜˜A˜Ðª    ²9Ð'=ÀcÈ1ÀXô €Eôf EÁ    ± ÈwÔW€HÙ ‘Ú‰Ù     ‘gÚ‰Ù ‘gÚ‰âˆØ}‰}˜UÓ#€Hä×ј6 8Õ,r'c    óž—tgd¢gd¢dœd¬«}|jd|d¬«}|j||¬    «}|rgd
¢}ngd ¢}|rd nd }tdtgd¢«dtgd¢«||i«j    ddg«|}|r|rgd¢}    n|r|sgd¢}    n |s|rgd¢}    ngd¢}    |j |    «}t j||«y)NrŒrrŽrr'rŒT)rPr&rV)rrrr()r+rrrrOr)rrr+r+r)r2rîr2rî)rrr+r2)rr+rr2)r+r2rr)rrrrÚ    set_indexr‘rr)
rPrŠr^r r£r!ràrr$r’s
          r%Ú"test_value_counts_sort_categoricalr–ÊsӀô
šª,Ñ7¸zÔ    J€BØ     ‰C˜d¨TˆÓ    2€BØ _‰_ '°Yˆ_Ó ?€FáÚ)‰âˆÙ$‰<¨'€DÜà ”š\Ó*Ø Œ{š<Ó(Ø &ð    
ó÷ iaÓ˜$ñ  €Hñ ‘Ú‰Ù     ‘gÚ‰Ù ‘gÚ‰âˆØ}‰}˜UÓ#€Hä×ј6 8Õ,r')DÚ__doc__Únumpyr8r¯Úpandasrrrrrrr    r
r Úpandas._testingÚ_testingrÚpandas.util.versionr r&rErÊÚslowÚ parametrizeÚreprrirr‡rŠr’r¤Úfixturer§r´r¹rÎrÑrírørrrrr"r[r>r%r‘rbr:rArFrHrOrQrZr<rgrirkrvrzr~r€r‡r‰r“r–rar'r%ú<module>r¡s4
ðñóÛ ÷
÷
õ
õÝ'ò-ò(ð.‡×ÑØ‡×ј t¨U mÓ4؇×ј b¨" XÓ.؇×ј Q¨ GÓ,؇×ј %¨°¸°Ð!?ÀTÐÓJ؇×ј $¨¨A¨ °TÐÓ:؇×ј 4¨ -Ó0؇×ÑÐ*Ð-AÐCSÐ,TÓU؇×ј $¨ Ó/؇×ј t¨U mÓ4؇×ј D¨% =Ó1ñ'Bó2ó5ó0óVó1ó;óKó-ó/ó5óð'BðT‡×ј  u  Ó.ñ-ó/ð-ð<‡×ј c¨3 Z²Ð$AÓBñ    -óCð    -ð‡×ј c¨3 Z²Ð$AÓBñ-óCð-ò-ò6-ð(‡ñóðòò,ò -ò@Vð‡×јÒ$CÓD؇×ÑÐ*Ð-AÐCSÐ,TÓU؇×ÑØòóð‡×ј d¨E ]Ó3؇×ј 4¨ -Ó0ñY4ó1ó4óóVóEðY4ðx‡×ј t¨U mÓ4؇×ÑØIà    ’o¢ºÐHØ     ˆu’o¢ºÐHØ     ˆt’_¢o²ÐGðóñ',óó5ð',ðT‡ñóðð‡×ÑØEà    e˜W¢iÒ1RÐSØ     ˆtU˜G¢YÒ0QÐRØ     ˆue˜W¢iÒ1RÐSà Ø Ø Ø Ú Ú -ð     
ð     óñ ;ó!ð ;ð0‡ñ    óð    ð‡×ÑØ@ð Ø Ú 'Ú =ð        
ð
Ò(Ò*HÐIØ     ˆuÒ(Ò*LÐMØ     ˆt’Y¢Ð0ð
ó ñ-ó ð-ð.‡ñóðð‡×ÑØ+ð Ø ˆFØ "ˆJ× "Ñ "Ú?Ú:ô ð    
ð Ú Ù á˜1˜#“JÙÒ2Ó3Ù˜8 W¨b¯f©fÐ5Ó6ðò
$¢\²<Ð@Ú:ô ð     
ðóð4‡×ÑÐ*Ð-=Ð?SÐ,TÓUñ;óVó5ð6;ð0‡×ј e¨T ]Ó3؇×ј e¨T ]Ó3؇×ÑØ$ð Ø Ø ˆBH‰HÒ9ÀÇÁÔ Jð    
ð Ø Ø ˆBH‰HÒSÓ Tð    
ð óñ70óó4ó4ð"70òt 0ðF‡×ј d¨E ]Ó3؇×ÑØ$ð Ø Ø ˆBH‰HÒ9ÀÇÁÔ Jð    
ð Ø Ø ˆBH‰HÒSÓ Tð    
ð óñ'óó4ð 'ðT‡×ј d¨E ]Ó3؇×ÑØ$ð Ø Ø ˆBH‰HÚFÈbÏhÉhô ð    
ð Ø Ø ˆBH‰Hòó ð    
ð"ó%ñL-óM%ó4ðN-ð`‡×ј d¨E ]Ó3؇×ÑØð ò ð    
ð$ ò ð        
ð%óð@‡×ÑØ$ð Ø Ø ˆBH‰HÒ9ÀÇÁÔ Jð    
ð Ø à ˆBH‰HÒQÓ Rð        
ð óñ "0ó!óAó4ðb"0ðJ‡×ј e¨T ]Ó3؇×ј e¨T ]Ó3؇×ÑØ$ð Ø Ø ˆBH‰HÒ9ÀÇÁÔ Jð    
ð Ø à ˆBH‰HÒSÓ Tð        
ð óñ 90ó!ó4ó4ð$90ðx‡×ÑØ0à    šÐ#Ø     ˆ|š_Ð-ðóñ,óð,ð"‡×ÑØ#à    ‘4˜“=Ò"AÐBØ    ‘$v“, ) Ñ,Ò.SÐTðóð‡×ј e¨T ]Ó3ñ0ó4óð0ð4‡×ÑØàØðóñ-óð-ò-ò5ò5ò    -ò-ð$‡×ј  u  Ó.ñ-ó/ð-òB,ð‡×ј T¨5 MÓ2؇×ј t¨U mÓ4ñ-ó5ó3ð-ð6‡×ј T¨5 MÓ2؇×ј t¨U mÓ4ñ-ó5ó3ñ-r'