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
270
271
272
273
274
275
Ë
oñúhؓã ó”—ddlZddlZddlZddlmZddlmcmZ    ddl
Z ddl
m Z m Z mZmZmZmZmZmZmZmZddlmZd-d„ZGd„d«Zd.d„Zd    „Zd
„Zd „Zd/d „Zd „Z ejBjEddddgfdddgfg«d„«Z#d„Z$ejBjEdddggd¢fddggd¢fddggd¢fed«ed «ged«ed «ed «gfg«d!„«Z%ejBjEd"gd#¢«d$„«Z&d%„Z'ejBjEd&d'gd(¢fd)gd(¢fdgd(¢fd*gd+¢fg«d,„«Z(y)0éN)Úusing_string_dtype)
Ú CategoricalÚ    DataFrameÚIndexÚ
MultiIndexÚSeriesÚ    TimestampÚ bdate_rangeÚconcatÚmergeÚoption_contextc    ó^—tt|««}tjtj|||z««}t |«|kr0tjt|«|d|t |«z
z«}tj jd«j|«|S)Né)    ÚlistÚrangeÚnpÚasarrayÚtileÚlenÚrandomÚ default_rngÚshuffle)ÚngroupsÚnÚ unique_groupsÚarrs    úWH:\Change_password\venv_build\Lib\site-packages\pandas/tests/reshape/merge/test_join.pyÚ get_test_datars€€Üœ˜w›Ó(€MÜ
*‰*”R—W‘W˜]¨A°©LÓ9Ó
:€Cä
ˆ3ƒx!‚|܏j‰jœ˜c› ]°>°Q¼¸S»±\Ð%BÑBÓCˆä‡II×ј!Ó×$Ñ$ SÔ)Ø €Jóc
ó—eZdZejd„«Zejd„«Zejd„«Zd„Zd„Z    d„Z
d„Z d„Z d    „Z ejjd
d ej d ej$d «¬«g«d„«Zd„Zd„Zd„Zejjddddej0ddg«g«d„«Zd„Zd„Zd„Zd„Zd„Zd„Zd „Z d!„Z!ejjEe#«d"¬#«d$„«Z$d%„Z%d&„Z&d'„Z'd(„Z(d)„Z)d*„Z*ejjd
d ej d ej$d «¬«g«d+„«Z+d,„Z,d-„Z-d.„Z.d/„Z/d0„Z0d1„Z1d2„Z2d3„Z3d4„Z4d5„Z5y)6ÚTestJoincó —tt«t«tjj    d«j d«tjj    d«j d«dœ«}||ddkD}|S)Nré2)Úkey1Úkey2Údata1Údata2r%é©rrrrrÚstandard_normal)ÚselfÚdfs  rr,z TestJoin.df'sn€ä ä%›Ü%›ÜŸ™×.Ñ.¨qÓ1×AÑAÀ"ÓEÜŸ™×.Ñ.¨qÓ1×AÑAÀ"ÓEñ     ó
ˆð6‘
˜Q‘Ñ ˆØˆ    rcó¢—ttd¬«tdd¬«tjj    d«j d«dœ«S)Né
)ré)rrr)r$r%Úvaluer))r+s rÚdf2z TestJoin.df26sC€ää%¨Ô+Ü%¨a°2Ô6ÜŸ™×.Ñ.¨qÓ1×AÑAÀ"ÓEñ ó
ð    
rcó¨—gd¢gd¢gd¢tdd¬«dœ}t|tgd¢t¬    «¬
«}t|d |d d œ|d¬
«}||fS)N)ççð?g@g@g@)r3r4r3r4r3)Úfoo1Úfoo2Úfoo3Úfoo4Úfoo5z1/1/2009é)Úperiods©ÚAÚBÚCÚD)ÚaÚbÚcÚdÚe©Údtype©Úindexr=r@)ÚMergedAÚMergedDr?)r
rrÚobject)r+ÚdataÚtargetÚsources    rÚ target_sourcezTestJoin.target_source@sb€ò+Ú*Ú9ܘZ°Ô3ñ    
ˆô ˜4¤uÒ-FÌfÔ'UÔVˆôؘS™    ¨d°3©iÑ 8ÀÀSÁ    ô
ˆðvˆ~Ðrcó~—t||d¬«}t|||dgd¬«t||«}t|||ddgd¬«y)Nr%©ÚonÚleft©Úhowr$©r Ú _check_join©r+r,r1Ú joined_key2Ú joined_boths     rÚtest_left_outer_joinzTestJoin.test_left_outer_joinQsB€Ü˜B ¨Ô/ˆ ܐB˜˜[¨6¨(¸Õ?ä˜B “nˆ ܐB˜˜[¨6°6Ð*:ÀÖGrcó„—t||dd¬«}t|||dgd¬«t||d¬«}t|||ddgd¬«y)Nr%Úright©rSrVrUr$rWrYs     rÚtest_right_outer_joinzTestJoin.test_right_outer_joinXóG€Ü˜B ¨°GÔ<ˆ ܐB˜˜[¨6¨(¸Õ@ä˜B ¨Ô1ˆ ܐB˜˜[¨6°6Ð*:ÀÖHrcó„—t||dd¬«}t|||dgd¬«t||d¬«}t|||ddgd¬«y)Nr%Úouterr_rUr$rWrYs     rÚtest_full_outer_joinzTestJoin.test_full_outer_join_rarcó„—t||dd¬«}t|||dgd¬«t||d¬«}t|||ddgd¬«y)Nr%Úinnerr_rUr$rWrYs     rÚtest_inner_joinzTestJoin.test_inner_joinfrarcó:—t||dd¬«}d|vsJ‚d|vsJ‚y)Nr%©z.fooz.bar)rSÚsuffixesúkey1.foozkey1.bar©r ©r+r,r1Újoineds    rÚtest_handle_overlapzTestJoin.test_handle_overlapms/€Ür˜3 6Ð4DÔEˆà˜VÑ#Ð#Ð#ؘVÑ#Ð#Ñ#rcó<—t||ddd¬«}d|vsJ‚d|vsJ‚y)Nr%r$ri)Úleft_onÚright_onrjrkzkey2.barrlrms    rÚ!test_handle_overlap_arbitrary_keyz*TestJoin.test_handle_overlap_arbitrary_keyss9€ÜØ Ø ØØØ%ô 
ˆð˜VÑ#Ð#Ð#ؘVÑ#Ð#Ñ#rÚ infer_stringFTÚpyarrow)ÚmarkscóØ—|\}}|j|d¬«}tj|d|dd¬«tj|d|dd¬«td    gd
¢i«}td gd ¢igd ¢¬«}|j|d    ¬«}tgd
¢gd¢dœ«}    tj||    «tdgdgdgggd ¢dg¬«}
tdgdggddgdg¬«} tdgdggddgdg¬«} |
j| d¬«}|j| d¬«}t j |dd«sJ‚t j |dd«sJ‚tjtd¬«5|j|d¬«ddd«|j«} d}tjt|¬«5|j| d¬«ddd«y#1swYŒSxYw#1swYyxYw)Nr?rRrJr=F)Ú check_namesrKr@Úkey©rArArBrBrCr0©rr(r©rArBrCrH)rrr(r(r©ryr0r(réÚone©rIÚcolumnsÚfooÚbarÚtwoÚthreerCz^'E'$©ÚmatchÚEzvYou are trying to merge on float64 and object|str columns for key 'A'. If you wish to proceed you should use pd.concat) ÚjoinÚtmÚassert_series_equalrÚassert_frame_equalrÚisnanÚpytestÚraisesÚKeyErrorÚcopyÚ
ValueError)r+rPrtrNrOÚmergedr,r1rnÚexpectedÚdf_aÚdf_bÚdf_cÚ source_copyÚmsgs               rÚ test_join_onzTestJoin.test_join_on~sæ€ð'‰ˆà—‘˜V¨Ó,ˆÜ
×јv iÑ0°&¸±+È5ÕQÜ
×јv iÑ0°&¸±+È5ÕQô˜Ò8Ð9Ó :ˆÜ˜¢)Ð,²OÔDˆØ—‘˜ Ó'ˆÜÚ-ºÑ Hó
ˆô     ×јf hÔ/ô˜1˜# ˜s Q C˜²È%ÈÔQˆÜ˜5˜' E 7Ð+°A°q°6ÀEÀ7ÔKˆÜ˜1˜# ˜s˜¨A¨q¨6¸G¸9ÔEˆØ—‘˜4 EÓ*ˆØ—‘˜T eÓ,ˆÜx‰x˜˜u™  cÑ*Ô+Ð+Ð+܏x‰x˜˜w™¨Ñ,Ô-Ð-Ð-ô]‰]œ8¨7Ô 3ñ    (Ø K‰K˜ 3ˆKÔ '÷    (ð—k‘k“mˆ ð Cð     ô]‰]œ:¨SÔ 1ñ    -Ø K‰K˜ ¨ˆKÔ ,÷    -ð    -÷    (ð    (ú÷    -ð    -úsÅ.GÆ7G ÇGÇ G)cór—ttjjd«j    ddgd¬«tjjd«j d«dœ«}ttjjd«j    ddgd¬«tjjd«j d«dœt jtd«d    d
gg«¬ «}d }tjt|¬ «5t||dd¬«ddd«y#1swYyxYw)NrÚmÚfr~©Úsize©rArBr.r:r=r>rHúFlen\(left_on\) must equal the number of levels in the index of "right"r†rAT©rqÚ right_index© rrrrÚchoicer*rÚ from_productrrŽrr’r ©r+r,r1r™s    rÚ-test_join_on_fails_with_different_right_indexz6TestJoin.test_join_on_fails_with_different_right_index§sþ€Ü ä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀaÐ4ÓHÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñ ó
ˆô ä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀbÐ4ÓIÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAñ ô×)Ñ)¬5°«8°c¸3°ZÐ*@ÓAô 
ˆðXˆÜ ]‰]œ:¨SÔ 1ñ    :Ü "c 3°DÕ 9÷    :÷    :ñ    :ús ÄD-Ä-D6c    ó€—ttjjd«j    ddgd¬«tjjd«j d«dœt jtd«td«g«¬«}ttjjd«j    ddgd    ¬«tjjd«j d    «dœ«}d
}tjt|¬ «5t||d d ¬«ddd«y#1swYyxYw)Nrrœrr~ržr ÚabcrHr.zFlen\(right_on\) must equal the number of levels in the index of "left"r†rBT)rrÚ
left_index)rrrrr¥r*rÚ from_arraysrrrŽrr’r r§s    rÚ,test_join_on_fails_with_different_left_indexz5TestJoin.test_join_on_fails_with_different_left_index¹sþ€Ü ä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀaÐ4ÓHÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñ ô×(Ñ(¬%°«(´D¸³KÐ)@ÓAô 
ˆôä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀbÐ4ÓIÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAñ ó
ˆð XˆÜ ]‰]œ:¨SÔ 1ñ    :Ü "c C°DÕ 9÷    :÷    :ñ    :ús ÄD4Ä4D=cóv—ttjjd«j    ddgd¬«tjjd«j d«dœ«}ttjjd«j    ddgd¬«tjjd«j d«dœt jtd«d    d
gg«¬ «}d }tjt|¬ «5t||dddg¬«ddd«y#1swYyxYw)Nrrœrr~ržr r.r:r=r>rHz)len\(right_on\) must equal len\(left_on\)r†rArB)rrrqr¤r§s    rÚ/test_join_on_fails_with_different_column_countsz8TestJoin.test_join_on_fails_with_different_column_countsËs€Ü ä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀaÐ4ÓHÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñ ó
ˆô ä—Y‘Y×*Ñ*¨1Ó-×4Ñ4°c¸3°ZÀbÐ4ÓIÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAñ ô×)Ñ)¬5°«8°c¸3°ZÐ*@ÓAô 
ˆð;ˆÜ ]‰]œ:¨SÔ 1ñ    =Ü "c C°#°s°Õ <÷    =÷    =ñ    =ús ÄD/Ä/D8Ú
wrong_typerÚstrNrr(có<—tdddgi«}dt|«›d}tjt|¬«5t ||dd¬«ddd«tjt|¬«5t ||dd¬«ddd«y#1swYŒ=xYw#1swYyxYw)NrAr(z.Can only merge Series or DataFrame objects, a z  was passedr†)rqrr)rÚtyperŽrÚ    TypeErrorr )r+r°r,r™s    rÚ)test_join_on_fails_with_wrong_object_typez2TestJoin.test_join_on_fails_with_wrong_object_typeÝs›€ô˜˜a ˜V}Ó %ˆð ܐjÓ!Ð" +ð /ð     ô]‰]œ9¨CÔ 0ñ    =Ü *˜b¨#¸Õ <÷    =ä ]‰]œ9¨CÔ 0ñ    =Ü "j¨#¸Õ <÷    =ð    =÷    =ð    =ú÷    =ð    =úsºBÁ-BÂBÂBcóޗ|\}}|j|d¬«}|jddi¬«}|gd¢}|jd«}|j||¬«}tj||«y)Nr?rRÚkey_0©r)r·r=r>r@rJrK)r‰ÚrenameÚpoprŠrŒ)r+rPrNrOr”Újoin_colÚresults       rÚtest_join_on_pass_vectorz!TestJoin.test_join_on_pass_vectorîsk€Ø&‰ˆØ—;‘;˜v¨#;Ó.ˆØ—?‘?¨C°¨>?Ó:ˆØÒJÑKˆà—:‘:˜c“?ˆØ—‘˜V¨Ó1ˆÜ
×јf hÕ/rcól—|\}}|j|jg«d¬«}|D]+}||vsJ‚||j«j«rŒ+J‚|j|jg«dd¬«}t    j
|j |j «t|«dk(sJ‚y)Nr?rRrfr_r)r‰ÚreindexÚisnaÚallrŠÚassert_index_equalrr)r+rPrNrOr“ÚcolÚmerged2s       rÚtest_join_with_len0zTestJoin.test_join_with_len0øs©€à&‰ˆØ—‘˜VŸ^™^¨BÓ/°CÓ8ˆØò    ,ˆCؘ&‘=Ð  =ؘ#‘;×#Ñ#Ó%×)Ñ)Õ+Ð +Ð+ð    ,ð—+‘+˜fŸn™n¨RÓ0°S¸g+ÓFˆÜ
×јgŸo™o¨v¯~©~Ô>ܐ7‹|˜qҠРѠrcóŠ—tdgd¢i«}tdddgiddg¬«}|j|dd    ¬
«}|j|d¬ «}||dj«}tj|d|d«tj|d|dd ¬ «tj
|j |j «y)Nry)rArArDrBrBrCr0rr(rArBrHrfr_rRF)Ú check_dtype)rr‰ÚnotnarŠr‹rÂrI©r+r,r1rnr”s     rÚtest_join_on_innerzTestJoin.test_join_on_inners´€Ü ˜Ò=Ð>Ó ?ˆÜ˜ 1 a &Ð)°#°s°Ô<ˆà—‘˜ ¨GÓ4ˆà—7‘7˜3 57Ó)ˆØ˜H WÑ-×3Ñ3Ó5Ñ6ˆÜ
×јv e™}¨h°u©oÔ>Ü
×јv g™°¸Ñ0AÈuÕUÜ
×јfŸl™l¨H¯N©NÕ;rcó—tdgd¢i«}tdgd¢igd¢¬«}|j|dg¬«}|j|d¬«}tj||«y)Nryrzr0r{r|rHrR©rr‰rŠrŒrÉs     rÚtest_join_on_singlekey_listz$TestJoin.test_join_on_singlekey_lists[€Ü ˜Ò8Ð9Ó :ˆÜ˜¢)Ð,²OÔDˆð—‘˜ % Ó)ˆØ—7‘7˜3 57Ó)ˆä
×јf hÕ/rcó”—|\}}|j|dd¬«}|j|dgd¬«}tj||«y)NrJr?rR)r‰rŠrŒ)r+rPrNrOr¼r”s      rÚtest_join_on_serieszTestJoin.test_join_on_seriessK€Ø&‰ˆØ—‘˜V IÑ.°3Ó7ˆØ—;‘;˜v y kÑ2°s;Ó;ˆÜ
×јf hÕ/rcóЗtdddgi«}tdgdgd¬«}|j|d¬«}tddgddgdœ|j¬«}t    j
||«y)    NrAr(rrB©rIÚnamerRr rH)rrr‰rIrŠrŒ)r+r,Údsr¼r”s     rÚtest_join_on_series_bugletz#TestJoin.test_join_on_series_buglet se€ä ˜˜a ˜V}Ó %ˆÜ QC ˜s¨Ô -ˆØ—‘˜ Ó$ˆÜ A q 6°°A°Ñ7¸r¿x¹xÔHˆÜ
×јf hÕ/rcó†—ttjd«¬«}d|d<d|d<ttjdd«¬«}d    |d
<d |d <|j||¬ «}t    |||¬ «}t j ||«|j||¬ «}t    |||¬ «}t j ||«y)Nr.rHTÚboolr‚Ústringr:ér(Úintr4ÚfloatrU)rrÚaranger‰Ú _join_by_handrŠrŒ)r+Ú    join_typeÚdf1r1rnr”s      rÚtest_join_index_mixedzTestJoin.test_join_index_mixed(s­€äœbŸi™i¨›mÔ,ˆØˆˆF‰ ؈ˆH‰ äœbŸi™i¨¨2Ó.Ô/ˆØˆˆE‰
؈ˆG‰ à—‘˜# 9Ó-ˆÜ   c¨yÔ9ˆÜ
×јf hÔ/à—‘˜# 9Ó-ˆÜ   c¨yÔ9ˆÜ
×јf hÕ/rcóÌ—tdddddœtjd«gd¢¬«}|djtjk(sJ‚|d    jtj
k(sJ‚tdddddœtjd
dd«gd¢¬«}|j |d d ¬ «}gd¢}|dd|_|dd|_t||«}tj||«y)Nr4rr‚Tr<r.r€r>r@rÚ_oneÚ_two©ÚlsuffixÚrsuffix)ÚA_oneÚB_oneÚC_oneÚD_oneÚA_twoÚB_twoÚC_twoÚD_twor/) rrrÛrGÚint64Úbool_r‰rrÜrŠrŒ)r+rÞr1rnÚexpected_columnsr”s      rÚtest_join_index_mixed_overlapz&TestJoin.test_join_index_mixed_overlap:s݀ÜØ˜A E°Ñ 5Ü—)‘)˜B“-Ú(ô
ˆð
3‰x~‰~¤§¡Ò)Ð)Ð)ؐ3‰x~‰~¤§¡Ò)Ð)Ð)äØ˜A E°Ñ 5Ü—)‘)˜A˜r 1Ó%Ú(ô
ˆð—‘˜# v°vÓ>ˆò    
Ðð' r¨Ð*ˆŒ Ø& q rÐ*ˆŒ Ü   cÓ*ˆÜ
×јf hÕ/rzTODO(infer_string))Úreasoncó\—t«}|jtdgdgdg¬«d¬«y)Nr~rr=r€rcrU)rr‰)r+Úxs  rÚtest_join_empty_bugzTestJoin.test_join_empty_bug[s*€ô ‹KˆØ    ‰Œy˜!˜ Q C°#°Ô7¸WˆÕErcóª—ttjjd«j    d«ddg¬«}t tjjd«j    d««}||d<ttjjd«j    d«d    g¬«}|j |«|j |«y)
Nr)érrArBr¸r÷rC)r÷r(Úq)rrrrr*rr‰)r+rArCrDs    rÚtest_join_unconsolidatedz!TestJoin.test_join_unconsolidatedas €ä Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =ÈÈSÀzô
ˆô ”2—9‘9×(Ñ(¨Ó+×;Ñ;¸BÓ?Ó @ˆØˆˆ#‰Ü ”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸wÓGÐRUÐQVÔ Wˆð    
‰ˆqŒ    Ø    ‰ˆq    rcóX—tjgd¢gd¢gddg¬«}tjgd¢gd¢gddg¬«}ttjj d«j d«|d    g¬
«}ttjj d«j d«|d g¬
«}|jd ¬ «}|jd ¬ «}|j|d¬«}t|j«jt|j««}|j|«j|j|««}|j|j_ tj ||«|jj|jk(sJ‚|jd¬ «}|jd¬ «}|j|d¬«jd ¬ «}t|j«jt|j««}|j|«j|j|««}|j|j_ tj ||«|jj|jk(sJ‚y)N)rArArArBrBrB)r(rr~r(rr~ÚfirstÚsecond©Únames)rBrBrBrCrCrCrézvar X)rMrIrzvar Yr)ÚlevelrcrUr()rr¬rrrrr*Ú
sort_indexr‰rÚvaluesÚunionr¿rþrIrŠrŒ)r+Úindex1Úindex2rÞr1rnÚex_indexr”s        rÚtest_join_multiindexzTestJoin.test_join_multiindexns€Ü×'Ñ'Ú +Ò-?Ð @ؘHÐ%ô
ˆô
×'Ñ'Ú +Ò-?Ð @ؘHÐ%ô
ˆô
Ü—‘×&Ñ& qÓ)×9Ñ9¸!Ó<ØØIô
ˆô
Ü—‘×&Ñ& qÓ)×9Ñ9¸!Ó<ØØIô
ˆð n‰n 1ˆnÓ%ˆØn‰n 1ˆnÓ%ˆà—‘˜# 7Ó+ˆÜ˜Ÿ™Ó'×-Ñ-¬e°F·M±MÓ.BÓCˆØ—;‘;˜xÓ(×-Ñ-¨c¯k©k¸(Ó.CÓDˆØ%Ÿ|™|ˆ‰ÔÜ
×јf hÔ/؏|‰|×!Ñ! V§\¡\Ò1Ð1Ð1àn‰n 1ˆnÓ%ˆØn‰n 1ˆnÓ%ˆà—‘˜# 7Ó+×6Ñ6¸QÐ6Ó?ˆÜ˜Ÿ™Ó'×-Ñ-¬e°F·M±MÓ.BÓCˆØ—;‘;˜xÓ(×-Ñ-¨c¯k©k¸(Ó.CÓDˆØ%Ÿ|™|ˆ‰Ôä
×јf hÔ/؏|‰|×!Ñ! V§\¡\Ò1Ð1Ñ1rcóÌ—gd¢}gd¢}tjjd«jt    |««}t |||dœ«}|}t tjjd«jd«|gd¢¬«}|j |dd    gd
¬ «}t||j«dd    gd d gd
d¬«}t||dd    gdd
d¬«}    tj||    j|««t||dd    gdd
d¬«}    |jd d gd¬«}|j|_ |jjsJ‚tj||«y)N)
rƒrƒrƒr‚r‚Úbazr    Úquxr
Úsnap)
r„rr…rr„rr„r„r…rr)r$r%rM)r.r~)Új_oneÚj_twoÚj_threer€r$r%rfr_rûrüF)rqrrrVÚsortT)rrr«rVrr(©Úaxis)rrrr*rrr‰r Ú reset_indexrŠrŒÚ reindex_likeÚdroprIÚis_monotonic_increasing)
r+Ú%lexsorted_two_level_string_multiindexr$r%rMrIÚto_joinrnr”Ú    expected2s
          rÚtest_join_inner_multiindexz#TestJoin.test_join_inner_multiindex™sh€ÚVˆò 
ˆôy‰y×$Ñ$ QÓ'×7Ñ7¼¸D»    ÓBˆÜ $°¸dÑCÓDˆà5ˆÜÜ I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =ØÚ1ô
ˆð —‘˜7¨°Ð'7¸WÓEˆÜØ Ø × Ñ Ó !ؘVÐ$ؘxÐ(ØØô 
ˆôØ Ø Ø˜fÐ%ØØØô 
ˆ    ô     ×јf i×&<Ñ&<¸VÓ&DÔEäØ Ø Ø˜fÐ%ØØØô 
ˆ    ð—=‘= '¨8Ð!4¸1=Ó=ˆØŸ™ˆŒà|‰|×3Ò3Ð3Ð3Ü
×јf hÕ/rcó^—tddggd¢¬«}|jdg«jdddgi«}tdd    ggd
¢¬«}|jdd ¬ «t    j
t jjd ¬«5t||d d ¬«ddd«y#1swYyxYw)N)r(rr~)r/r:rÿr|r¸rArBÚmeanÚsum)ér.rÿ©rArBrDT)Úinplacez-Not allowed to merge between different levelsr†©r«r£)
rÚgroupbyÚaggÚ    set_indexrŽrÚpdÚerrorsÚ
MergeErrorr )r+r,Únew_dfÚother_dfs    rÚ#test_join_hierarchical_mixed_raisesz,TestJoin.test_join_hierarchical_mixed_raises×s¢€ô˜     9Ð-²Ô GˆØ—‘˜S˜EÓ"×&Ñ&¨¨f°e¨_Ð'=Ó>ˆÜ˜i¨Ð4ºoÔNˆØ×ј3¨ÐÔ-ä ]‰]Ü I‰I×  Ñ  Ð(Wô
ñ    Gô &˜(¨tÀÕ F÷    G÷    Gñ    Gús Â
B#Â#B,có —ttjjd«j    d«ddgtj
¬«}ttjjd«j    d«dgtj ¬«}|j|«}|jddk(sJ‚|jddk(sJ‚|jdd    k(sJ‚tjjd«jd
d d «jd «}tjjd«jd «jd«}tjjd«jd «jd    «}t|||dœ«}t|||dœ«}ttjjd«jd «jd    «dg¬«}|j|dd¬«}|jdd k(sJ‚|jddk(sJ‚|jdd    k(sJ‚|jdd    k(sJ‚|j|dd¬«}    tj||    «y)Nr)r.rrArB©rrG)r.r(rCÚfloat64Úfloat32rr:édrîr|Úmdr¸Tr¢)rrrrr*r,r-r‰ÚdtypesÚintegersÚastyper rŠrŒ)
r+rArBrnrCr,ÚxpdfÚsÚrsÚxps
          rÚtest_join_float64_float32z"TestJoin.test_join_float64_float32äs,€Ü Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =ؘ#JÜ—*‘*ô
ˆô
Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =ؐEÜ—*‘*ô
ˆð
—‘˜“ˆØ}‰}˜SÑ! YÒ.Ð.Ð.؏}‰}˜SÑ! YÒ.Ð.Ð.؏}‰}˜SÑ! YÒ.Ð.Ð.ä I‰I× !Ñ ! !Ó $× -Ñ -¨a°°CÓ 8× ?Ñ ?ÀÓ HˆÜ I‰I× !Ñ ! !Ó $× +Ñ +¨CÓ 0× 7Ñ 7¸    Ó BˆÜ I‰I× !Ñ ! !Ó $× +Ñ +¨CÓ 0× 7Ñ 7¸    Ó BˆÜ ˜Q Q¨QÑ/Ó 0ˆÜ˜q q¨qÑ1Ó2ˆÜ Ü I‰I× !Ñ ! !Ó $× +Ñ +¨AÓ .× 5Ñ 5°iÓ @È4È&ô
ˆðX‰Xa °$ˆXÓ 7ˆØy‰y˜‰~ Ò(Ð(Ð(؏y‰y˜‰~ Ò*Ð*Ð*؏y‰y˜‰~ Ò*Ð*Ð*؏y‰y˜‰ )Ò+Ð+Ð+à Z‰Z˜ 3°DˆZÓ 9ˆÜ
×јb "Õ%rcóЗtddgddgddgdœ«}tddgddgddgdœ«}tddgddgd    d
gd œ«}|jd d g«}|jd d g«}|jd d g«}|j||gd¬«}t||d d gd¬«}t||d d gd¬«}    |j    «}|    |j
}    |    j jd«|    d <|    jjd«|    d <tj||    «tgd¢gd¢gd¢dœ«}tgd¢gd¢gd¢dœ«}tgd¢gd¢gd¢d œ«}|jd d g«}|jd d g«}|jd d g«}|j||gd¬«}t||d d gd¬«}t||d d gd¬«}    |j    «}tj||    jdd…|j
f«tgd¢gd¢tjjd«jd«tjjd«jd«dœ«}
t!tj"tj$d«d«tj"tj$d«d«d¬«} |
j| d¬«} |
j| d¬«} |
j| d¬«}|
j| d¬«}tj| | «tj| |«tj| |«y) Nr(r.ér|rr.éÈréèéÐ)rArBrErArBrcrUr_rî)r(r(r()r.r9r÷)r(r(r)r.r:i,)r;r<i¸ rf)r‚rƒr‚rƒr‚rƒr‚r‚)rrr„r…r„r„rr…ér<ÚTESTrÑrTr^)rr#r‰r rrrAr2rBrŠrŒÚlocrrrr*rÚrepeatrÛ)r+rÞr1Údf3Úidf1Úidf2Úidf3r¼Údf_partially_mergedr”r,r4rfrcrTr^s                rÚtest_join_many_non_unique_indexz(TestJoin.test_join_many_non_unique_indexs    €Ü˜q !˜f¨A¨q¨6¸¸R¸ÑAÓBˆÜ˜q !˜f¨A¨q¨6¸¸c¸
ÑCÓDˆÜ˜q !˜f¨A¨q¨6¸¸t¸ ÑEÓFˆØ}‰}˜c 3˜ZÓ(ˆØ}‰}˜c 3˜ZÓ(ˆØ}‰}˜c 3˜ZÓ(ˆà—‘˜D $˜<¨WÓ5ˆä# C¨°#°s°ÀÔIÐÜÐ,¨c°s¸C°jÀgÔNˆà×#Ñ#Ó%ˆØ˜FŸN™NÑ+ˆØ Ÿ
™
×)Ñ)¨'Ó2ˆ‰ Ø Ÿ
™
×)Ñ)¨'Ó2ˆ‰ Ü
×јf hÔ/äšiªiºlÑKÓLˆÜšiªiºoÑNÓOˆÜšiªiÒ>PÑQÓRˆØ}‰}˜c 3˜ZÓ(ˆØ}‰}˜c 3˜ZÓ(ˆØ}‰}˜c 3˜ZÓ(ˆØ—‘˜D $˜<¨WÓ5ˆä# C¨°#°s°ÀÔIÐÜÐ,¨c°s¸C°jÀgÔNˆà×#Ñ#Ó%ˆä
×јf h§l¡l²1°f·n±nÐ3DÑ&EÔFôâMÚQÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñ     ó
ˆô Ü I‰I”b—i‘i “l AÓ &¬b¯i©i¼¿    ¹    À!» ÀaÓ.HÈvô
ˆð—‘˜˜wÓ'ˆØ—‘˜˜wÓ'ˆØw‰wq˜fˆwÓ%ˆØ—‘˜˜wÓ'ˆÜ
×јe UÔ+Ü
×јe TÔ*Ü
×јe UÕ+rc    ó¦—td|«5tgd¢gd¢dœ«}tdgd¢igd¢¬«}|j|d    d
¬ «}tgd ¢gd ¢gd¢dœgd¢¬«}tj||«|j|d    d¬ «}tj
|j ttd««d
¬«ddd«y#1swYyxYw)Nzfuture.infer_string)r‚rƒr    r‚©r(rr~r/r}Úvalue2r|)rƒr    r‚rHryT)rSr)rƒr    r‚r‚)rr~r(r/)rArBrCrC)ryr0rI)r(rrr~Fr/)Úexact)    r rr‰rŠrŒrÂrIrr)r+rtrTr^rnr”s      rÚtest_join_sortzTestJoin.test_join_sort;sŀôÐ1°<Ó @ñ    MÜÚ4º|ÑLóˆDô˜xªÐ9ÒAVÔWˆEà—Y‘Y˜u¨°TYÓ:ˆFÜ â7Ú)Ú2ñò
#ô ˆHô × !Ñ ! &¨(Ô 3ð—Y‘Y˜u¨°UYÓ;ˆFÜ × !Ñ ! &§,¡,´´e¸A³h³ÀtÕ L÷'    M÷    Mñ    Mús B1CÃCcóî—tdgd¢igd¢¬«}tdgd¢igd¢¬«}|j|«}tgd¢d    tjd
d tjgd œgd ¢¬«}t    j
||«tdgd¢igd¢¬«}tdgd¢igd¢¬«}|j|«}tgd¢d    d
d
tjgd œgd¢¬«}t    j
||«y)NrArH)r(rr~rArHrB)r:rÿrr=)r(r~r~r/)r(rr~r~r/r:rÿrr )r(rr~r~rA)r(rrrA)rr‰rÚnanrŠrŒ)r+rÞr1r¼r”rAÚdf4s       rÚ test_join_mixed_non_unique_indexz)TestJoin.test_join_mixed_non_unique_indexTs̀䘚lÐ+²>ÔBˆÜ˜šlÐ+²<Ô@ˆØ—‘˜#“ˆÜÚ!¨¬B¯F©F°A°q¼"¿&¹&Ð(AÑ BÚ#ô
ˆô     ×јf hÔ/䘚lÐ+²>ÔBˆÜ˜šlÐ+²<Ô@ˆØ—‘˜#“ˆÜÚ a¨¨A¬r¯v©vÐ%6Ñ 7º~ô
ˆô     ×јf hÕ/rc    óò—tjddd¬«}ttt    t |«««|dg¬«}t ||g«}|j|dd¬    «}ttjtjdtj¬
«jd «jd d «d «ddg|j«j¬«}t!j"||«y)Nz
2016-01-01éÚM)r;ÚfreqÚpnumr€rfÚ_df2)rVrårFréÿÿÿÿr(Úpnum_df2©rrI)r$Ú period_rangerrrrr r‰rrrÛrîr@ÚreshaperrIrŠrŒ)r+rIr,r1r¼r”s      rÚ!test_join_non_unique_period_indexz*TestJoin.test_join_non_unique_period_indexgs½€ä—‘  °b¸sÔCˆÜ ”tœE¤# e£*Ó-Ó.°eÀfÀXÔ NˆÜb˜"Xӈؗ‘˜ '°6Ó:ˆÜÜ G‰G”B—I‘I˜b¬¯©Ô1×8Ñ8¸Ó;×CÑCÀBÈÓJÈAÓ NؘZÐ(Ø—.‘.Ó"×(Ñ(ô
ˆô
     ×јf hÕ/rcó—ttjjd«j    d«gd¢¬«}|j ddd«|j ddd    «|j d«}tjd
«}|rd }tjt|¬ «5|j«ddd«|jd ¬«}|j«}|j|d¬«y#1swYŒ?xYw)Nr)r9rÿ)rArBrCrDrErr¸rÚidr:Údtr‚z&agg function failed [how->mean,dtype->z-dtype 'str' does not support operation 'mean'r†T)Ú numeric_onlyÚ_right©rå)rrrrr*Úinsertr!ÚreÚescaperŽrr´rÚcountr‰)r+Úusing_infer_stringr,Úgroupedr™ÚmnÚcns       rÚ test_mixed_type_join_with_suffixz)TestJoin.test_mixed_type_join_with_suffixts̀ä Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =Ú2ô
ˆð         ‰    !T˜1ÔØ
    ‰    !T˜5Ô!à—*‘*˜TÓ"ˆÜi‰iÐ@ÓAˆÙ ØAˆCÜ ]‰]œ9¨CÔ 0ñ    Ø L‰LŒN÷    à \‰\ tˆ\Ó ,ˆØ ]‰]‹_ˆð     ‰˜HˆÕ%÷     ð    ús Â'C6Ã6C?cóö—ttjjd«j    d«t d«¬«}|ddg|ddg|d    d
gg}|d j |d d«}tj||«|ddgdd |ddgdd|d    d
gd dg}d„}|d j |d dd¬«}||||j«|d j |d d«}||||d j«|d j |d dd¬«}||||jdd«d}tjt|¬«5|d j |d dd¬«ddd«y#1swYyxYw)Nr)r.rÿÚabcdefr¸rArBrCrDrErrr(éþÿÿÿé    có¤—|Dcgc]}|j|«‘Œ}}|dj|dd«}tj||«ycc}w)Nrr()r¿r‰rŠrŒ)Údf_listr¼Ú    exp_indexrôÚ    reindexedr”s      rÚ_check_diff_indexz2TestJoin.test_join_many.<locals>._check_diff_index”sN€Ø7>Ö?°!˜Ÿ™ 9Õ-Ð?ˆIÐ?Ø  ‘|×(Ñ(¨°1°2¨Ó7ˆHÜ × !Ñ ! &¨(Õ 3ùò@s…A rcrUrfr=z?Joining multiple DataFrames only supported for joining on indexr†rR) rrrrr*rr‰rŠrŒrIrŽrr’)r+r,rprnrsr™s      rÚtest_join_manyzTestJoin.test_join_many‰s‹€Ü Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°WÓ =ÄtÈHÃ~ô
ˆðs˜Cj‘> 2 s¨C j¡>°2°s¸C°j±>ÐBˆà˜‘—‘ ¨¨ Ó-ˆÜ
×јf bÔ)às˜Cj‘> # 2Ð&¨¨C°¨:©°q°rÐ(:¸BÀÀS¸z¹NÈ1ÈQÐ<OÐPˆò    4𠘑—‘ ¨¨ °'Ó:ˆÙ˜' 6¨2¯8©8Ô4à˜‘—‘ ¨¨ Ó-ˆÙ˜' 6¨7°1©:×+;Ñ+;Ô<à˜‘—‘ ¨¨ °'Ó:ˆÙ˜' 6¨2¯8©8°A°a¨=Ô9àOˆÜ ]‰]œ:¨SÔ 1ñ    1Ø A‰JO‰O˜G A B˜K¨CˆOÔ 0÷    1÷    1ñ    1ús Å E/Å/E8có\—ttjjd«j    d«gd¢¬«}ddgdz|d<|j
dd…d    d
gf}|j
dd…d d gf}|j
dd…dgf}|j ||g«}tj||«y) Nr)r=r/r<r¸r‚rƒr/ryr=r>r?r@)    rrrrr*r?r‰rŠrŒ)r+r,rÞr1rAr¼s      rÚtest_join_many_mixedzTestJoin.test_join_many_mixed§s¢€Ü Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°VÓ <Ú(ô
ˆð˜EN QÑ&ˆˆ5‰    Øf‰f’Q˜˜c˜
]Ñ#ˆØf‰f’Q˜˜c˜
]Ñ#ˆØf‰f’Q˜˜ZÑ ˆà—‘˜3 ˜*Ó%ˆÜ
×јf bÕ)rc
ó”—tttjj    d«j d«gd¢¬«ttjj    d«j ddd¬«jdd«d    d
g¬«gd ¬ «}t||gd ¬ «}|j|d ¬«}|j|_    tj||«ttjj    d«j d«ddg¬«}ttjj    d«j d«ddg¬«}ttjj    d«j d«ddg¬«}ttjj    d«j d«ddg¬«}|j|dd¬«j|ddd¬«}tjtj j"d¬«5|j|dd¬«ddd«y#1swYyxYw)Nr)r.r/)r=r=r>r>r¸rr.r9ržr=r?r(rÚ_2ra)r/rrôÚyTr rc)r«r£rVz0Passing 'suffixes' which cause duplicate columnsr†)r rrrrr*r1rZr‰rrŠrŒr rŽrr$r%r&)    r+r,r”r¼ÚwrôryÚzÚdtas             rÚtest_join_dupszTestJoin.test_join_dups´sõ€ä äÜ—I‘I×)Ñ)¨!Ó,×<Ñ<¸WÓEÚ0ôôÜ—I‘I×)Ñ)¨!Ó,×5Ñ5°a¸À"Ð5ÓE×MÑMÈbÐRSÓTØ  #˜Jôð      ðô 
ˆô˜2˜r˜(¨Ô+ˆØ—‘˜ TÓ*ˆØ!×)Ñ)ˆŒÜ
×јf hÔ/ô Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°VÓ <ÀsÈCÀjô
ˆô Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°VÓ <ÀsÈCÀjô
ˆô Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°VÓ <ÀsÈCÀjô
ˆô Ü I‰I× !Ñ ! !Ó $× 4Ñ 4°VÓ <ÀsÈCÀjô
ˆðg‰ga D°dˆgÓ;×AÑAØ ˜$¨D°gðBó
ˆô]‰]Ü I‰I×  Ñ  ØDô
ñ    <ð I‰Ia D°dˆIÔ ;÷        <÷    <ñ    <ús È H>È>IcóB—tjtd«td«ddgggd¢¬«}tdt    d«i|¬    «}tjtd«td«gddg¬«}td
t    dd «Dcgc]}d |z‘Œ    c}i|¬    «}|j |ddg|¬ «}|j «j|j «ddg|¬ «jgd¢«}tj||«d}    tjt|    ¬«5|j |d|¬ «ddd«tjt|    ¬«5|j |ddg|¬ «ddd«ycc}w#1swYŒIxYw#1swYyxYw)NrªÚxyr(r)rªrÚnumrýÚv1é rHÚv2rr.r_r¡r†)rr¦rrrr‰rr r#rŠrŒrŽrr’)
r+rÝÚ    leftindexrTÚ
rightindexÚir^r¼r”r™s
          rÚtest_join_multi_to_multiz!TestJoin.test_join_multi_to_multiáss€ä×+Ñ+Ü %‹[œ$˜t›* q¨! fÐ -Ò5Iô
ˆ    ô˜$¤ b£    Ð*°)Ô<ˆä×,Ñ,Ü %‹[œ$˜t›*Ð %¨e°T¨]ô
ˆ
ô˜4´5¸¸A³;Ö!?¨a #¨£'Ò!?Ð@È
ÔSˆà—‘˜5 e¨T ]¸    ÓBˆà × Ñ Ó ß ‰U5×$Ñ$Ó&¨E°4¨=¸iˆUÓ Hß ‰YÒ+Ó ,ð    ô
     ×јh¨Ô/àWˆÜ ]‰]œ:¨SÔ 1ñ    5Ø I‰Ie ¨)ˆIÔ 4÷    5ô]‰]œ:¨SÔ 1ñ    >Ø J‰Jt ¨  °9ˆJÔ =÷    >ð    >ùò"@÷    5ð    5ú÷    >ð    >úsÂ
F
Ä,F    Å$FÆ    FÆFcó —ttjddd¬«td«dœ«}ttjddd¬«td«d    œ«}|j    |j d
«d
¬ «}|j «}ttjgd ztd «z«|d<tj||«y)Nz
2018-01-01r:zAmerica/Chicago)Ústartr;ÚtzÚabcde)ÚdateÚvalsz
2018-01-03Útuvwx)rŒÚvals_2rŒrRrÚtuvr) rr$Ú
date_rangerr‰r#r‘rrrMrŠrŒ)r+rÞr1r¼r”s     rÚ#test_join_on_tz_aware_datetimeindexz,TestJoin.test_join_on_tz_aware_datetimeindexüs¶€ääŸ ™ Ø&°Ð6Gôô˜W› ñ     ó
ˆôäŸ ™ Ø&°Ð6Gôô˜w›-ñ     ó
ˆð—‘˜#Ÿ-™-¨Ó/°FÓ;ˆØ—8‘8“:ˆÜ#¤R§V¡V H¨q¡L´4¸³;Ñ$>Ó?ˆÑÜ
×јf hÕ/rcó—tgd¢gd¢gd¢gd¢ggd¢¬«}tj|d«jd«|d<tgd    ¢gd
¢ggd ¢d d g¬«}tj|d«jd«|d<|j    |j ddg«ddg¬«}tt d«dddgt d«dd dggd d ggd¢¬«}|djd«|d<tj||«y)N)ú
2012-08-02ÚLr.)r”ÚJrØ)ú
2013-04-06r•r9)r—r–é)rôryrAr¸rôzM8[ns])r”r–r()r—r•r)rôryr{rr/rXryrRz2012-08-02 00:00:00r–r(rØz2013-04-06 00:00:00r•r9)rôryr{rAr€)    rr$Ú to_datetimer2r‰r#r    rŠrŒ)r+ÚdfaÚdfbr¼r”s     rÚtest_join_datetime_stringz"TestJoin.test_join_datetime_strings€äâ'Ú'Ú'Ú'ð     ò $ô
ˆô—>‘> # c¡(Ó+×2Ñ2°8Ó<ˆˆC‰ÜÚ #Ò%;Ð <Ú#ؐa&ô
ˆô
—>‘> # c¡(Ó+×2Ñ2°8Ó<ˆˆC‰Ø—‘˜#Ÿ-™-¨¨c¨
Ó3¸¸c¸
ÓCˆÜäÐ0Ó1°3¸¸2Ð>ÜÐ0Ó1°3¸¸2Ð>ð ða&Ú(ô 
ˆð! ™ ×,Ñ,¨XÓ6ˆ‰ Ü
×јf hÕ/rcó‚—ddg}tj||¬«}tjt|«t|«¬«}td|i|¬«}tdt|«i|¬«}|j    |«}tddgddgdœtjddgddg¬«¬«}t j ||«y)NrArB©Ú
categoriesÚc1rHÚc2)r r¡)r$ÚCategoricalIndexÚreversedrr‰rŠrŒ)r+ÚixÚid1Úid2rÞr1r¼r”s        rÚ test_join_with_categorical_indexz)TestJoin.test_join_with_categorical_index2s­€à3ˆZˆÜ×!Ñ! "°Ô4ˆÜ×!Ñ!¤(¨2£,¼8ÀB»<ÔHˆä˜˜r˜
¨#Ô.ˆÜ˜œx¨›|Ð,°CÔ8ˆØ—‘˜#“ˆÜؘ: c¨3 ZÑ 0Ü×%Ñ% s¨C j¸cÀ3¸ZÔHô
ˆô     ×јf hÕ/r)6Ú__name__Ú
__module__Ú __qualname__rŽÚfixturer,r1rPr\r`rdrgrorsÚmarkÚ parametrizeÚparamÚtdÚ
skip_if_noršr¨r­r¯rÚarrayrµr½rÅrÊrÍrÏrÔrßrñÚxfailrrõrùrrr)r7rFrKrOr[rjrtrvr}r‡r’rœr§©rrr!r!%só„à ‡^^ñ óð ð ‡^^ñ
óð
ð ‡^^ñóðò HòIòIòIò$ò     $ð ‡[[×ÑØ˜   § ¡ ¨T¸¸¿¹ÀyÓ9QÔ RÐSóñ$-óð$-òL:ò$:ò$=ð$ ‡[[×ј\¨A¨u°d¸H¸B¿H¹HÀaÈÀVÓ<LÐ+MÓNñ=óOð=ò 0ò
!ò
<ò0ò0ò 0ò0ò$0ðB ‡[[×ÑÑ)Ó+Ð4HÐÓIñFóJðFò
ò)2òV:0ò| Gò&òB4,ðl ‡[[×ÑØ˜   § ¡ ¨T¸¸¿¹ÀyÓ9QÔ RÐSóñMóðMò,0ò& 0ò&ò*1ò< *ò+<òZ>ò60ò00ó< 0rr!rTcó¦—|D]%}||j«j«rŒ%J‚|j|«}|j|«}    |j|«D]o\}
} t| |j|«} t| |j|«}     |j |
«}t | |«    |    j |
«}t | |«Œqy#t$r5}|dvrtd|
›d«|‚t| |j|«Yd}~ŒZd}~wwxYw#t$r5}|dvrtd|
›d«|‚t| |j|«Yd}~Œíd}~wwxYw)N)rTrfzkey z! should not have been in the join)r^rf)
rÈrÁr!Ú_restrict_to_columnsrÚ    get_groupÚ_assert_same_contentsrÚAssertionErrorÚ_assert_all_na)rTr^r¼r»rVrärårCÚ left_groupedÚ right_groupedÚ    group_keyÚgroupÚl_joinedÚr_joinedÚlgroupÚerrÚrgroups                 rrXrXBsh€à ò'ˆØa‰y‰Ó ×$Ñ$Õ&Ð&Ð&ð'ð—<‘< Ó)€LØ—M‘M (Ó+€Mà"ŸN™N¨8Ó4ò4ш    5Ü'¨¨t¯|©|¸WÓEˆÜ'¨¨u¯}©}¸gÓFˆð
    4Ø!×+Ñ+¨IÓ6ˆFô " (¨FÔ 3ð
    4Ø"×,Ñ,¨YÓ7ˆFô " (¨FÕ 3ñ54øô ò    =ØÐ'Ñ'Ü$ؘ9˜+Ð%FÐGóàðô ˜8 T§\¡\°8× <Ñ <ûð     =ûôò    >ØÐ(Ñ(Ü$ؘ9˜+Ð%FÐGóàðô ˜8 U§]¡]°H× =Ñ =ûð     >ús0ÂCÂ1Dà   DÃ+D
DÄ    EÄ+E Å Ecó쇗|jDcgc]}||vs|j‰d«|vsŒ|‘Œ}}|jdd…|f}|jˆfd„¬«}|jdd…|f}|Scc}w)NÚcó(•—|j‰d«S)NrÄ)Úreplace)rôÚsuffixs €rú<lambda>z&_restrict_to_columns.<locals>.<lambda>psø€¨1¯9©9°V¸RÓ+@€rr¸)rrÆr?r¹)r½rrÇrCÚfounds  `  rrµrµgs~ø€à—=‘=ö Ø A¨¡L°A·I±I¸fÀbÓ4IÈWÒ4TŠð €Eð ð
I‰I’a˜hÑ €Eð L‰LÓ!@ˆLÓ A€Eð I‰I’a˜jÑ !€Eà €Lùò s
A1®A1cóH‡—d}|j|«j«j}|j|«j«j}|Dchc] }t|«’Œc}Št    ‰«t    |«k(sJ‚t ˆfd„|D««sJ‚ycc}w)Niy)íÿc3ó8•K—|]}t|«‰v–—Œy­w©N)Útuple)Ú.0ÚrowÚrowss  €rú    <genexpr>z(_assert_same_contents.<locals>.<genexpr>€søèø€Ò5 cŒuS‹z˜TÔ!Ñ5ùsƒ)ÚfillnaÚdrop_duplicatesrrÍrrÁ)Ú
join_chunkrOÚ NA_SENTINELÚjvaluesÚsvaluesrÏrÐs      @rr·r·xs‡ø€Ø€Kà×Ñ  Ó,×<Ñ<Ó>×EÑE€G؏m‰m˜KÓ(×8Ñ8Ó:×AÑA€Gà")Ö *˜3ŒE#JÒ *€DÜ ˆt‹9œ˜F› Ò #Ð#Ð #Ü Ó5¨WÔ5Ô 5Ð5Ñ 5ùò +sÁBcób—|D]*}||vrŒ||j«j«rŒ*J‚yrÌ)rÀrÁ)rÔÚsource_columnsr»rCs    rr¹r¹ƒs:€Ø ò*ˆØ ‰=Ø Ø˜!‰}×!Ñ!Ó#×'Ñ'Õ)Ð)Ð)ñ*rcó<—|jj|j|¬«}|j|«}|j|«}|jj    |j«}|j «D]
\}}|||<Œ |j|¬«S)NrUr¸)rIr‰r¿rÚappendÚitems)    rArBrVÚ
join_indexÚa_reÚb_reÚresult_columnsrÃr4s             rrÜr܊sƒ€Ø—‘—‘˜aŸg™g¨3Ó/€Jà 9‰9ZÓ  €DØ 9‰9ZÓ  €Dà—Y‘Y×%Ñ% a§i¡iÓ0€Nà—*‘*“,ò‰ˆˆQ؈ˆSŠ    ðà <‰< ˆ<Ó /Ð/rcó:—tdditjdgd¬«¬«}tdditjd    gd
¬«¬«}|j|d ¬ «}tdgdgd œtjdgd¬«¬«}t    j
||«y)NrEr:)r(rr/rrý©rMrIrrÿ)rr~)rBrCrfrU)rEr)r(rr/r~)rArBrDrCrH©rrÚ from_tuplesr‰rŠrŒ)rTr^r¼r”s    rÚ.test_join_inner_multiindex_deterministic_orderrå—s˜€ä ؐ1ˆXÜ×$Ñ$ i [¸ÔHô €Dô ؐ1ˆXœZ×3Ñ3°V°HÀJÔOô €EðY‰Yu 'ˆYÓ *€FÜØˆc˜˜ÑÜ×$Ñ$ l ^Ð;OÔPô€Hô×ј& (Õ+r)Ú    input_colÚ output_colsrBrAÚa_xÚa_ycóȗtdddgi«}t|ddgi«}|j|ddd¬«}t|d    gd
¢|dgd ¢i«}tj||«y) NrAr(r~r/ÚcrossÚ_xÚ_y)rVrärår)r(r(r~r~)r~r/r~r/rÌ)rærçrTr^r¼r”s      rÚtest_join_crossrî¨sj€ô
c˜A˜q˜6]Ó #€DÜ y 1 a &Ð)Ó *€EØ Y‰Yu '°4ÀˆYÓ F€Fܘ+ a™.ª,¸ ÀA¹Ê ÐUÓV€HÜ×ј& (Õ+rcóž—tdditjdgd¬«¬«}tdditjd    gd
¬«¬«}|j||¬ «}|d k(r+tdgdgd œtjdgddg¬«¬«}n*tdgdgd œtjdgddg¬«¬«}t    j
||«y)NrCr~)r(rr rýrârDr/)r)rBrUr^)rCrD)rr(rBrArHrã)rÝrTr^r¼r”s     rÚtest_join_multiindex_one_levelrð´s̀ä Ø1ˆXœZ×3Ñ3°V°HÀJÔOô €Dô ˜C ˜8¬:×+AÑ+AÀ4À&ÐPVÔ+WÔ X€EØ Y‰Yu )ˆYÓ ,€FؐGÒÜØ#˜Q˜CÑ  Ü×(Ñ(¨&¨¸#¸s¸ÔDô
‰ô
ؐ#˜Q˜CÑ  Ü×(Ñ(¨&¨¸#¸s¸ÔDô
ˆô×ј& (Õ+rzcategories, valuesÚYÚX)rñròròrr()rr(r(ç@çø?)rórôrôz
2020-12-31z
2019-12-31cóx—tddgt||¬«ddgdœ«jddg«}tgd¢t||¬«gd    ¢dœ«jddg«}|j|d
d ¬ «}tddgt||¬«ddgd dgdœ«jddg«}t    j
||«y)Nr=ržr(r)rûrür0rûrü)r=r=r>)r~r/r:Ú_leftr`rãr~r/)rûrüÚ
value_leftÚ value_right©rrr#r‰rŠrŒ)rŸrrTr^r¼r”s      rÚ1test_join_multiindex_not_alphabetical_categoricalrúÈsހô à˜3ZÜ! *¸ÔDؘVñ    
ó ÷ i˜(Ð#Ó$ð     ô â$Ü! &°ZÔ@Úñ    
ó ÷ i˜(Ð#Ó$ð 
ðY‰Yu g°xˆYÓ @€Fäà˜3ZÜ! *¸ÔDؘa˜&ؘq˜6ñ        
ó÷i˜(Ð#Ó$ð ô×ј& (Õ+rzleft_empty, how, exp)
)FrTrT)Fr^Úempty)Frfrû)FrcrT)Frërû)TrTrû)Tr^r^)Trfrû)Trcr^)Trërûcó¤—tddgddgdœd¬«jd«}tdgd    gd
œd¬«jd«}|r|jd «}n|jd «}|j||¬ «}|d k(rCtddgddgtj
tj
gdœ«}|jd«}na|dk(r2ttj
gdgd    gdœ«}|jd«}n*|dk(r%tddgd¬«}|dk7r|j d«}|dk(rj«}tj|«y)Nrr(r~r/)r=r>rîrFr=r:)r=r?rrUrT)r=r>r?r^)r>r=r?rûr>r?r+rërc)
rr#Úheadr‰rrMÚ rename_axisrrŠrŒ)Ú
left_emptyrVÚexprTr^r¼r”s       rÚtest_join_emptyrñs9€ô  ˜A˜q˜6¨¨A¨Ñ/°wÔ ?× IÑ IÈ#Ó N€DÜ ˜Q˜C q cÑ*°'Ô :× DÑ DÀSÓ I€EáØy‰y˜‹|‰à—
‘
˜1“ ˆà Y‰Yu #ˆYÓ &€Fà
ˆf‚}Ü A q 6°°A°¼b¿f¹fÄbÇfÁfÐ=MÑNÓOˆØ×%Ñ% cÓ*‰Ø     ŠÜ¤B§F¡F 8°1°#¸Q¸CÑ@ÓAˆØ×%Ñ% cÓ*‰Ø     ŠÜ c¨3 Z°wÔ?ˆØ 'Š>Ø×+Ñ+¨CÓ0ˆHØ
ˆg‚~Ø×&Ñ&Ó(ˆä×ј& (Õ+rcóB—t«}tdg¬«}tddg¬«}||z}tdg¬«}tj||«||z}tgd¢¬«}tj||«||z}tddg¬«}tj||«y)NÚtestr¸r‚©rƒr    )rr‚r)rrŠrŒ)rÞr1rAr¼r”s     rÚ$test_join_empty_uncomparable_columnsrs•€ä
‹+€CÜ
˜V˜HÔ
%€CÜ
˜U NÐ3Ô
4€Cà 3‰Y€FÜ & Ô*€HÜ×ј& (Ô+à 3‰Y€FÜÒ!@ÔA€HÜ×ј& (Ô+à 3‰Y€FÜ .°%Ð!8Ô9€HÜ×ј& (Õ+rz how, valuesrfr{rcr^©rrr(cóœ—ttgd¢«tgd¢«gd¢dœ«jddg«}ttgd¢«tgd¢«gd¢dœ«jddg«}tt|«t|«||dœ«jddg«}|j||¬«}t    j
||«y)    Nr{r|rArBrr)rArBrCrDrUrù)rVrrÞr1r”r¼s      rÚ3test_join_multiindex_categorical_output_index_dtyper.s΀ô äšYÓ'ÜšYÓ'Úñ    
ó ÷ ic
Óð ô äšYÓ'ÜšYÓ'Úñ    
ó ÷ ic
Óð ôä˜VÓ$ܘVÓ$ØØñ        
ó÷ic
Óð ðX‰Xc˜sˆXÓ #€FÜ×ј& (Õ+r)r=r#)rTrìrí)rT))rcÚnumpyrrŽÚpandas._configrÚpandas.util._test_decoratorsÚutilÚ_test_decoratorsr¯Úpandasr$rrrrrr    r
r r r Úpandas._testingÚ_testingrŠrr!rXrµr·r¹rÜrår¬r­rîrðrúrrrr³rrú<module>rsðÛ    ãÛ å-ç)Ð)ã÷ ÷ ÷ õó÷Z 0ñZ 0óz"4òJò"6ò*ó
0ò,ð"‡×ÑØ  C¨#¨s¨Ð#4°s¸UÀE¸NÐ6KÐ"Lóñ,óð,ò,ð(‡×ÑØà
ˆsˆ’_Ð%Ø
ˆQˆ’ÐØ
ˆsˆ’_Ð%á |Ó $¡i° Ó&=Ð >Ù |Ó $¡i° Ó&=¹yÈÓ?VÐ Wð    
ð    ó ñ,ó ð,ð:‡×ÑØò óñ,óð,ò6,ð&‡×ÑØà    ’)ÐØ    ’)ÐØ    ’ÐØ    ’)Ðð    óñ,óñ,r