zmc
2023-08-08 e792e9a60d958b93aef96050644f369feb25d61b
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
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
U
­ý°deÆã    @sdZddlmZddlmZmZmZmZddlZddlm    Z    ddl
Z ddl Z ddl mZddlmmZddlZddlmZmZmZmZmZmZmZmZmZmZmZm Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&ddl'm(Z)ddl*m+Z+m,Z,dd    l-m.Z.dd
l/m0Z0e j1 2d e j3e j3d gd e j3e j3gdddgge j3d gd e j3gddggg¡dd„ƒZ4Gdd„dƒZ5Gdd„dƒZ6Gdd„dƒZ7Gdd„dƒZ8Gdd„dƒZ9Gdd„dƒZ:Gdd„dƒZ;Gd d!„d!ƒZ<Gd"d#„d#ƒZ=Gd$d%„d%ƒZ>Gd&d'„d'ƒZ?e j1 2d(d)d*d+gd)d*gdd,gfd)d*d-gd)d*gdd,gfd)d*d-gd)d-gdd.gfg¡d/d0„ƒZ@d1d2„ZAd3d4„ZBd5d6„ZCd7d8„ZDd9d:„ZEd;d<„ZFd=d>„ZGd?d@„ZHdAdB„ZIdCdD„ZJdEdF„ZKe j1 2dGdHe  LdH¡e  MdH¡g¡dIdJ„ƒZNe j1 2dKe"dLƒdMfe"dNdOdPdQfg¡dRdS„ƒZOdTdU„ZPdVdW„ZQGdXdY„dYƒZRdS)Zz$ test label based indexing with loc é)Ú
namedtuple)ÚdateÚdatetimeÚtimeÚ    timedeltaN)Úgettz)Ú IndexingError)Ú CategoricalÚCategoricalDtypeÚCategoricalIndexÚ    DataFrameÚ DatetimeIndexÚIndexÚ
IndexSliceÚ
MultiIndexÚPeriodÚ PeriodIndexÚSeriesÚ SparseDtypeÚ    TimedeltaÚ    TimestampÚ
date_rangeÚtimedelta_rangeÚ to_datetimeÚ to_timedelta)Ú is_bool_dtypeÚ    is_scalar)Ú_one_ellipsis_message)Ú"check_indexing_smoketest_or_raisesz series, new_series, expected_serÚbÚaFTcCsPtd|iƒ}||jdd…df<td|iƒ}t | ¡|¡t | ¡|¡dS©NÚA)r ÚlocÚtmÚassert_frame_equalÚisnaZnotna)ÚseriesZ
new_seriesZ expected_serÚdfÚexpected©r*úUd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/indexing/test_loc.pyÚtest_not_change_nan_loc0s
      r,c @sÚeZdZej dddg¡dd„ƒZej dddg¡dd„ƒZej dd    d
d d d dgdgd    dgdgdd
d d gdgdd gdgddgdgddgdgg¡ej dddg¡dd„ƒƒZej ddddgd
d dggdddgd
d dggg¡ej dddg¡dd„ƒƒZ    ej ddddgdgdgdddgd
d dgdgddd gd
d dgdgd!d"d#gd$gdgg¡ej dddg¡d%d&„ƒƒZ
ej d'd
d g¡ej dddg¡d(d)„ƒƒZ d*d+„Z ej dddg¡d,d-„ƒZ ej d.eddƒd d dddgdeged/d0ƒdgdegedd1ƒd gdegedd1ƒd gdegedd2dƒd gdegg¡ej dddg¡d3d4„ƒƒZd5d6„Zd7d8„Zej d9edgged:gƒd;edd…d:fedgd:d<fedged:gƒd=d:dgfedgged:gƒd=d:edgd:d<fg¡d>d?„ƒZdS)@ÚTestLocÚkindr'ÚframecCs$| |›d¡}t|ddtddS)NZ_labelsr#é©Úfails©ÚgetfixturevaluerÚKeyError©Úselfr.ÚrequestÚobjr*r*r+Útest_loc_getitem_intAszTestLoc.test_loc_getitem_intcCs$| |›d¡}t|ddtddS)NÚ_emptyr#Úcr1r3r6r*r*r+Útest_loc_getitem_labelGszTestLoc.test_loc_getitem_labelzkey, typs, axesÚfÚintsZuintsÚlabelsÚmixedÚtsNZfloatsércCs4|D]*}| |›d|›¡}t|d||tdqdS©NÚ_r#©Úaxesr2r3©r7ÚkeyÚtypsrGr.r8Útypr9r*r*r+Ú#test_loc_getitem_label_out_of_rangeMs ÿz+TestLoc.test_loc_getitem_label_out_of_rangez    key, typsér0ç@r"cCs2|D](}| |›d|›¡}t|d|tdqdS)NrEr#r1r3)r7rIrJr.r8rKr9r*r*r+Útest_loc_getitem_label_listas    z#TestLoc.test_loc_getitem_label_listÚemptyé
ééé)rMrR)rMé)r0éZmulticCs4|D]*}| |›d|›¡}t|d||tdqdSrDr3rHr*r*r+Ú(test_loc_getitem_label_list_with_missingos ÿz0TestLoc.test_loc_getitem_label_list_with_missingrJcCs0| |›d|›¡}t|ddddgdtddS)NrEr#rCéé(rMrFr3)r7rJr.r8r9r*r*r+Ú!test_loc_getitem_label_list_failssÿz)TestLoc.test_loc_getitem_label_list_failscCsdS©Nr*©r7r*r*r+Ú!test_loc_getitem_label_array_likeŠsz)TestLoc.test_loc_getitem_label_array_likecCs0| |›d¡}ddddg}t|d|tddS)Nr;TFr#r1)r4rÚ
IndexError)r7r.r8r9rr*r*r+Útest_loc_getitem_bools zTestLoc.test_loc_getitem_boolzslc, typs, axes, failsZ20130102Z20130104érUc    Cs4|D]*}| |›d|›¡}t|d|||dqdSrD)r4r)    r7ZslcrJrGr2r.r8rKr9r*r*r+Útest_loc_getitem_label_slice—sûz$TestLoc.test_loc_getitem_label_slicecCsttddgddgddggddgdddgd}t d    ¡|jd
<tddgd dgddggddgdddgd}t ||¡dS) NrCr éÈÚcol1Úcol2rQrM©ÚcolumnsÚindexr0)rMrcr)r ÚnpÚaranger#r$r%©r7r(r)r*r*r+Ú test_setitem_from_duplicate_axis·sýÿz(TestLoc.test_setitem_from_duplicate_axiscCs¤tdddgdtjdgtdƒtjtdƒgdœd    }td
gtdƒgd œd    }|j|j|d  ¡d d gf<tdddgdd
dgtdƒtdƒtdƒgdœd    }t     
||¡dS)NrMr0rRzString 1zString 2z2019-06-11 11:00:00z2019-06-11 12:00:00)Zchannelr"ÚB)ÚdatazString 3©r"rlr"rl) r rhÚNaNrÚpdÚNaTÚvaluesr#r&r$r%)r7r(Údf2r)r*r*r+Útest_column_types_consistentÄs.
ýýÿ ÿýýÿ z$TestLoc.test_column_types_consistentz obj, key, expF©rf©Úname©rgcCs6|j|}t|ttfƒr&t ||¡n ||ks2t‚dSr[)r#Ú
isinstancer rr$Ú assert_equalÚAssertionError)r7r9rIÚexpÚresr*r*r+Ú#test_loc_getitem_single_boolean_argãs
z+TestLoc.test_loc_getitem_single_boolean_arg)Ú__name__Ú
__module__Ú __qualname__ÚpytestÚmarkÚ parametrizer:r=rLrOrWrZr]r_ÚsliceÚ    TypeErrorr5rarkrtr rrrr~r*r*r*r+r-@sˆ
 
 
 
 
 
úþ  þþ ûþ
 
 üöþ   ý$ùþ r-c@sPeZdZdd„Zej ddedƒddffdedƒd    dffd
edƒdd ffd ed ƒedƒdffded ƒdd    ffdedƒdedƒffdedƒd dffg¡dd„ƒZdd„Z    dd„Z
dd„Z dd„Z dd„Z d d!„Zd"d#„Zej d$d%d&gd%d&d%d&gg¡d'd(„ƒZd)d*„Zd+d,„Zd-d.„Zd/d0„Zd1d2„Zd3d4„Zd5d6„Zejd7d8„ƒZej d9d:ejd:ejd;ejd:d:d:d:d:gejd;g¡d<d=„ƒZd>d?„Zd@dA„ZdBdC„Z dDdE„Z!dFdG„Z"ej dHdIdJdKdLdMdNdOdPg¡dQdR„ƒZ#dSdT„Z$dUdV„Z%dWdX„Z&dYdZ„Z'd[d\„Z(d]d^„Z)d_d`„Z*dadb„Z+dcdd„Z,ej dedfge-dgdfdgƒe dfg¡g¡ej dhdige dig¡g¡djdk„ƒƒZ.ej dld:dmgdfdndodKgfdpe/dpdpdpdpgdqdrej0ej0gdpdpdpdpggdfdndodKgdsfdtdodKgfdpduge/dtdmej0ej0gdqdrdpdugdvdwej0ej0ggdfdndodKgdsfdtdfdndogfejdpdudxgejd;e/dtdmej0gdpdudxgdvdwej0ggdfdndogdsfe-dtdqdgƒdndodKgfdpdudxgdydzd{gge/dtdmej0ej0gdqdpdudxgdvdydzd{ggdfdndodKgdsfe-dtdqdgƒdodfdKgfejdpdudxgdydzd{ggejd;e/dtdmej0ej0gdudrdpdxgdzdwdyd{ggdfdndodKgdsfe-dgdgdgƒdfdogfe/dpdugdxdygdzd{ggdfdogdse/dpdmdugdxdrdygdzdwd{ggdfdndogdsfg¡d|d}„ƒZ1d~d„Z2d€d„Z3d‚dƒ„Z4d„d…„Z5d†d‡„Z6ejj7ej dˆd‰dŠgd‹dŒgg¡ddŽ„ƒƒZ8dd„Z9d‘d’„Z:d“d”„Z;d•d–„Z<d—d˜„Z=d™dš„Z>d›dœ„Z?ddž„Z@dŸd „ZAd¡d¢„ZBd£d¤„ZCd¥d¦„ZDd§d¨„ZEd©dª„ZFd«d¬„ZGej d­d®d¯d°g¡ej d±ejejHeIg¡eJjKd²d³„ƒƒƒZLd´dµ„ZMeJjKd¶d·„ƒZNd¸d¹„ZOej dedºd»g¡d¼d½„ƒZPej d¾eQejeReSg¡d¿dÀ„ƒZTdÁd„ZUej dÃdÄeRdtgƒfdÅeRdmgƒfg¡dÆdDŽƒZVdÈdɄZWej dÊd:dËdtdmdqdrdvdwdpdudxg
fe-drduƒd:dtdmdqdËdËdËdËdudxg
fdqdvgd:dtdmdËdrdËdwdpdudxg
fg¡dÌd̈́ƒZXdÎdτZYdÐdфZZdÒdӄZ[ej dÔdÕdÕgg¡dÖdׄƒZ\dØdلZ]ej dÚdfdfgdfe-dgƒfg¡dÛd܄ƒZ^dÝdބZ_dßdà„Z`dádâ„Zadãdä„Zbdådæ„Zcej dçdèdég¡dêd넃Zddìdí„Zedîdï„Zfdðdñ„Zgdòdó„Zhdôdõ„ZidgS)öÚTestLocBaseIndependentcCsHttddƒd}|jt dg¡dd…}|jdd…}t ||¡dS)NZ2021Ú2022rxz2021/6/1ré—)r rr#rhÚarrayÚilocr$r%©r7r(Úresultr)r*r*r+Útest_loc_npstrúsz%TestLocBaseIndependent.test_loc_npstrzmsg, keyz'Period\('2019', 'A-DEC'\), 'foo', 'bar'éãÚfooÚbarz&Period\('2019', 'A-DEC'\), 'y1', 'bar'Úy1z&Period\('2019', 'A-DEC'\), 'foo', 'z1'Úz1z;Period\('2018', 'A-DEC'\), Period\('2016', 'A-DEC'\), 'bar'éâéàz&Period\('2018', 'A-DEC'\), 'foo', 'y1'z;Period\('2017', 'A-DEC'\), 'foo', Period\('2015', 'A-DEC'\)éáéßz&Period\('2017', 'A-DEC'\), 'z1', 'bar'c    Cszttdƒddgtdƒtdƒdgtdƒdtd    ƒgd
d d gd ddgdœƒ dddg¡}tjt|d|j|W5QRXdS)a(
        parse_datetime_string_with_reso return parameter if type not matched.
        PeriodIndex.get_loc takes returned value from parse_datetime_string_with_reso
        as a tuple.
        If first argument is Period and a tuple has 3 items,
        process go on not raise exception
        rÚx1Zx2r”r•r’r–r“r—rMr0rRrQrCrX)r"rlÚCZV1ZV2r"rlr™©ÚmatchN)r rÚ    set_indexr‚Úraisesr5r#)r7ÚmsgrIr(r*r*r+Ú;test_contains_raise_error_if_period_index_is_in_multi_indexs ûÿø    zRTestLocBaseIndependent.test_contains_raise_error_if_period_index_is_in_multi_indexc    Cs>tddgiƒ}tjtdd|jdd…dfW5QRXdS)Nr rMuאrš)r r‚rr5r#©r7r(r*r*r+Ú$test_loc_getitem_missing_unicode_key(sz;TestLocBaseIndependent.test_loc_getitem_missing_unicode_keycCsTttj d¡dd„tdƒDƒd}|jd}|jdd…dfjd}t ||¡dS)    N)rCrVcSsg|]}d|d‘qS)ZABCDErVr*©Ú.0Úxr*r*r+Ú
<listcomp>1sz@TestLocBaseIndependent.test_loc_getitem_dups.<locals>.<listcomp>rCrx)r"rrr")r rhÚrandomZ random_sampleÚranger#r$Úassert_series_equal©r7r(r)rr*r*r+Útest_loc_getitem_dups-s
ÿ
z,TestLocBaseIndependent.test_loc_getitem_dupscCs€tddddtdƒggdddddgdgd}tddddtdƒgdddddgdd}|jd    }t ||¡|jd}t ||¡dS)
NrMr0rr‘Ú20130101r re©rgrwr)r rrr‹r$r¨r#r©r*r*r+Útest_loc_getitem_dups27s ý ý
 
z-TestLocBaseIndependent.test_loc_getitem_dups2cCsttdƒtdƒtjdddddtjdddddd    œƒ d
¡}d d d gf}| ¡}|j|d9<t |j|d|j|¡d}| ¡}|j|d9<|j|d|j|ksÀt    ‚dd d gf}| ¡}|j|d9<t 
|j|d|j|¡dS)NZrtttiZaaaderVÚfloat64©Údtypegq=
×£põ?r0gÃõ(\ÂÕ¿)Úmerr‘Úbar2r±Úrr‘r²ç@)r³r‘Út) r ÚlistrhrirœÚcopyr#r$r¨r{r%)r7Údf_origÚindexerr(r*r*r+Útest_loc_setitem_dupsKs2üÿù
þþz,TestLocBaseIndependent.test_loc_setitem_dupscCsðtdddgtdddgdddœƒ}|d    dk}|j|d
fd}||j|d
f<tdddgtdd d gdddœƒ}t ||¡tdddgdddgdœd d}|d    dk}|j|d
f}||j|d
f<tdddgdddgdœd d}t ||¡dS)NrrMédrbé,Zuint32r¯©r rr réÉi-Úuint64)r rr#r$r%)r7Zdf1ÚixZnewb1r)rsZnewb2r*r*r+Útest_loc_setitem_slicens" ÿ  z-TestLocBaseIndependent.test_loc_setitem_slicecCs’tdgdgdgdgdœƒ}dddg}|jdd…|f d    ¡|jdd…|f<tdgtjdgd
d tjdgd
d tjdgd
d dœƒ}t ||¡dS) Nr"ç333333ó?çgÀ)Úidr rr<r rr<Úfloat32r®r¯)r r#ÚastyperhrŠr$r%)r7r(Úcolsr)r*r*r+Útest_loc_setitem_dtypeƒs
&üÿ    z-TestLocBaseIndependent.test_loc_setitem_dtypec    Csrttdƒdddgd}tjtdd|ddgW5QRXttdƒƒ}tjtdd|d    dgW5QRXdS)
NrRr rr<rxú not in indexršÚdr)rr§r‚rr5)r7Úsr*r*r+Ú$test_getitem_label_list_with_missing–s  z;TestLocBaseIndependent.test_getitem_label_list_with_missingrgTFc    CsNtdddgƒ}dt|ƒ›dt|ƒ›}tjt|d|j|W5QRXdS)NrMr0rRz Boolean index has wrong length: z  instead of rš)rÚlenr‚rr^r#)r7rgrËržr*r*r+Útest_loc_getitem_bool_diff_len¡sz5TestLocBaseIndependent.test_loc_getitem_bool_diff_lencCsdSr[r*r\r*r*r+Útest_loc_getitem_int_slice©sz1TestLocBaseIndependent.test_loc_getitem_int_slicec    Cshttj d¡dddgdddgd}d    t ¡j›d
}tjt|d |jd d gd d gfW5QRXdS)N)rRrRr rr<Úer>Úg©rgrfz$\"None of \[Index\(\[1, 2\], dtype='ú'\)\] are in the \[index\]\"ršrMr0)    r rhr¦Úint_r°r‚rr5r#©r7r(ržr*r*r+Útest_loc_to_fail­s
ÿÿz'TestLocBaseIndependent.test_loc_to_failc    CsHttd}d|jd<d|jd<tjtdd|jdW5QRXdt ¡j›d    }tjt|d|jdd
gW5QRXd }tjt|d|jd gW5QRXd |jd<tjtdd|jdd
gW5QRXd|d<dt ¡j›d    }tjt|d|jd
gW5QRX|d=tjt|dd|jd
g<W5QRXdS)Nr¯rMr0r z^-1$ršéÿÿÿÿz&\"None of \[Index\(\[-1, -2\], dtype='rÓéþÿÿÿzE\"None of \[Index\(\['4'\], dtype='object'\)\] are in the \[index\]\"Ú4rRrÉz"\"None of \[Index\(\[-2\], dtype='r)    rÚobjectr#r‚rr5rhrÔr°©r7rËržr*r*r+Útest_loc_to_fail2ºs.
 
 
ÿ
ÿz(TestLocBaseIndependent.test_loc_to_fail2c    Cs†tdgdggddgdgd}dt ¡j›d}tjt|d    |jd
gdd…fW5QRXtjt|d    |jd
gW5QRXdS) Nr rrMr0ÚvaluerÒz!\"None of \[Index\(\[3\], dtype='rÓršrR)r rhrÔr°r‚rr5r#rÕr*r*r+Útest_loc_to_fail3ásÿz(TestLocBaseIndependent.test_loc_to_fail3c    Cs„tdddgƒ}|jdgdt ¡j›d}tjtt     |¡d|jdgW5QRXtjtdd|jddgW5QRXdS)NrMr0rRz"None of [Index([3], dtype='z')] are in the [index]ršrÉ)
rr#rhrÔr°r‚rr5ÚreÚescaperÛr*r*r+Útest_loc_getitem_list_with_failðs z6TestLocBaseIndependent.test_loc_getitem_list_with_failcCs’ttjjdddddddgd}|j d    d
„¡}|jt |¡}|j|}t ||¡|j|j    }t ||¡|jt
j|d d }t ||¡dS) N)rVrQ©ÚsizeZalpha_0Zalpha_1Zalpha_2Zbeta_0Zbeta_1rxcSsd|kS)NÚalphar*©r¤r*r*r+Ú<lambda>    óz7TestLocBaseIndependent.test_loc_index.<locals>.<lambda>Úbooleanr¯) r rhr¦rgÚmapr#rŠr$r%rrrp)r7r(Úmaskr)rr*r*r+Útest_loc_indexs  þ
   z%TestLocBaseIndependent.test_loc_indexcCsÐttj dd¡ddddgddddgd}|jdd…dd…fjdd…dd…f}|jddgk ¡sft‚|j    ddgk ¡s|t‚tt
d    ƒgd
gd œƒjd}t t
d    ƒd
gd d gdd}t   ||¡|jtksÌt‚dS)NrUr"rlr™ÚDrerr0r«rMr½r rr¬)r rhr¦Úrandr#r‹rfÚallr{rgrrr$r¨r°rÚrŒr*r*r+Útest_loc_generals 
 
ý( z'TestLocBaseIndependent.test_loc_generalcCs"ttddƒttdƒtjddœƒS)Nú
2000-01-01ú    2000-01-5rVr¯©rÚval)r rrr§rhÚint64r\r*r*r+Úframe_for_consistency's
þÿz,TestLocBaseIndependent.frame_for_consistencyrórr¯cCsVttdtdƒtjdttdƒtjddœƒ}| ¡}||jdd…df<t ||¡dS)NrrV©rgr°r¯ròr©    r rr§rhrôr·r#r$r%)r7rõrór)r(r*r*r+Útest_loc_setitem_consistency0sþÿz3TestLocBaseIndependent.test_loc_setitem_consistencycCsRttdtdƒdttdƒtjddœƒ}| ¡}d|jdd…df<t ||¡dS)NrrVrxr¯ròrr÷©r7rõr)r(r*r*r+Ú(test_loc_setitem_consistency_dt64_to_strAsþÿz?TestLocBaseIndependent.test_loc_setitem_consistency_dt64_to_strcCsRttdtdƒdttdƒtjddœƒ}| ¡}d|jdd…df<t ||¡dS)Nçð?rVrxr¯ròrr÷rùr*r*r+Ú*test_loc_setitem_consistency_dt64_to_floatOsþÿzATestLocBaseIndependent.test_loc_setitem_consistency_dt64_to_floatcCsJtdttdƒgƒiƒ}d|jdd…df<tdtdgƒiƒ}t ||¡dS)NrZ20180101Ústring)r rrr#r$r%rjr*r*r+Ú'test_loc_setitem_consistency_single_row\sz>TestLocBaseIndependent.test_loc_setitem_consistency_single_rowc    CsŠtddgd}tddgd}t d¡d|jdd…df<W5QRXt ||¡tddgd}d|d<|d tj¡|d<t ||¡dS)Nr¤ÚyrurM)r r$Zassert_produces_warningr#r%rÆrhrô©r7r)r(r*r*r+Ú"test_loc_setitem_consistency_emptyds  z9TestLocBaseIndependent.test_loc_setitem_consistency_emptycCs‚dgdddddgddddgg}tj|d    d
d gd }d d d ddgdddddgg}tj|ddgd }ddddtjgdddddgddddtjgddddd gg}t|||d!}t|jdd…d"fƒ|jdd…d"f<t|jdd…d#fƒ|jdd…d#f<|jd$d%}|jdd…d#f|jdd…d"f|jdd…d&f<|jdd…d&ftd'ƒ|jdd…d&f<t    d(d)d*d+g|j
d&d,}t   |d&|¡dS)-NZRegion_1rUZSite_1ZSite_2lðBP[l _ˆZlq=.ZlÑ<.ZZRegionZSiteZ RespondentID©ÚnamesÚ
RespondentZOtherCatZ    SomethingÚ    StartDateÚEndDatezYes/NoZ SomethingElseZLevel_0ZLevel_1r"z5/25/2015 10:59z5/25/2015 11:22ZYesz5/21/2015 9:40z5/21/2015 9:52z5/20/2015 8:27z5/20/2015 8:41z5/20/2015 8:33z5/20/2015 9:09ZNorÒ)rr)rrF)r·)rZDurationlXŽp7g7@ç(@g,@gB@r¬) rÚ from_arraysrhÚnanr rr#Z infer_objectsrrrgr$r¨)r7ÚlevelsÚmiZclevelsrÇrrr(r)r*r*r+Ú-test_loc_setitem_consistency_slice_column_lentsJ
 
ý  þ  üÿÿ ÿÿ
ÿþ
ÿzDTestLocBaseIndependent.test_loc_setitem_consistency_slice_column_lenÚunitÚYÚMrìÚhÚmrËÚmsÚuscCsªtdt d¡t d¡giƒ}|jdd…dfj d|›d¡|jdd…|f<|jdd…dfj d|›d¡|d<t|jdd…df|d}t |jdd…|f|¡dS)NÚ    timestampz2017-02-11 12:41:29z1991-11-07 04:22:37z datetime64[ú]r)rv)    r rhÚ
datetime64r#rrrÆrr$r¨)r7r r(r)r*r*r+Útest_loc_assign_non_ns_datetime¥sþÿÿ    0&z6TestLocBaseIndependent.test_loc_assign_non_ns_datetimecCsÈt dddddgi¡}t|dddd|d    <|jdd…d    f|jdd…d
f<|jd d gd    f|jd d gd
f<tdd d gdddgdddgdddggdd    d
gd}d    d
g}|| t¡||<t ||¡dS)NrlçCO!glös~!gl4    8šlA{ï?šrT)r ÚcacheZdate_dtZ
date_dt_cpr0rRz2017-01-24 13:26:12.711z2017-01-24 13:52:05.110z2018-10-22 13:44:05.888z2018-10-23 08:08:41.025ru)r Ú    from_dictrr#Úapplyr$r%)r7r(r)rfr*r*r+Útest_loc_modify_datetime·s"ÿ  üù
z/TestLocBaseIndependent.test_loc_modify_datetimecCsptdddgdgtd}tjdddgdd    |jdddgdf<tdddgdddgtd
}td|iƒ}t ||¡dS) NrRrVrUr"©rgrfr°rMr0rôr¯rö)r ÚfloatrhrŠr#rr$r%©r7r(Úserr)r*r*r+Ú#test_loc_setitem_frame_with_reindexÑs
$ z:TestLocBaseIndependent.test_loc_setitem_frame_with_reindexcCsˆtdddgddgtd}d|d<tjdd    dgd
d |jdddgdf<td    ddgdddgd
d }td| t¡iƒ}d|d<t ||¡dS) NrRrVrUr"rlrrýrMr0rôr¯rö)    r rrhrŠr#rrÆr$r%rr*r*r+Ú)test_loc_setitem_frame_with_reindex_mixedÜs$z@TestLocBaseIndependent.test_loc_setitem_frame_with_reindex_mixedcCsttdddgddgtd}d|d<tjdddgdd    |jtdd
d ƒdf<td d dgddœdddgd}t ||¡dS)NrMr0rRr"rlrrýrôr¯rr×rNr´rûrnrx)r rrhrŠr#r…r$r%rjr*r*r+Ú*test_loc_setitem_frame_with_inverted_sliceès
&zATestLocBaseIndependent.test_loc_setitem_frame_with_inverted_slicec
CsÎdd„tdƒDƒ}tjddd}dd„tdƒDƒ}tjddd}tt|ƒ |¡ƒ}t|d}tj|d    <||j|d    f<tj|d
<||j|d
f<t    ||tj
d }t    ||d}t||d œƒj |d}    t   ||    ¡dS) NcSsg|]}dt|ƒ‘qS©ú@©Ústr©r£Úir*r*r+r¥ôszGTestLocBaseIndependent.test_loc_setitem_empty_frame.<locals>.<listcomp>rVrôr¯cSsg|]}dt|ƒ‘qSr#r%r'r*r*r+r¥÷srUrxr"rlrörn)r§rhrir¶ÚsetÚunionr r    r#rr®Úreindexr$r%)
r7Zkeys1Zval1Úkeys2Zval2rgr(ZseraZserbr)r*r*r+Útest_loc_setitem_empty_frameòs
 
 
 z3TestLocBaseIndependent.test_loc_setitem_empty_framecCs²ttj dd¡tdƒtdƒd}|jd}d|jd<|jd}|dksJt‚|jd}|dks`t‚d|jdd…d    d
…f<|jdd…d    d
…f}|jdd…dd…f}t     ||¡dS) NrUZabcdÚABCDrÒ©rrrM)r r"rrlrì)
r rhr¦Úrandnr¶r‹r#r{r$r%rŒr*r*r+Útest_loc_setitem_frame    s 
 
 
 
 z-TestLocBaseIndependent.test_loc_setitem_framecCsTtdddgtjdœƒ}|j|j|j|jkdf<tdddgtjdœƒ}t ||¡dS)NrMr0rRrnrl)r rhr    r"r#rlr$r%rjr*r*r+Ú/test_loc_setitem_frame_nan_int_coercion_invalidszFTestLocBaseIndependent.test_loc_setitem_frame_nan_int_coercion_invalidcCsœtddgddgddgdœƒ}|jdddgf}tddgtddgtd    tdd
}t ||¡td dgd dgddgdœƒ}d d g|jdddgf<t ||¡dS) NrMr0rRrUr r)rMr0r rr¯©rgr°rwrVrS)r r#rrrÚr$r¨r%rŒr*r*r+Ú#test_loc_setitem_frame_mixed_labels"sÿ z:TestLocBaseIndependent.test_loc_setitem_frame_mixed_labelscCstdddgttdƒtjddœƒ}|jdd…}|jd    d…|_||jd    d…<tdddgtdddgtjddœƒ}t ||¡tt    d
d ƒttd ƒtjdd œƒ}tt
dƒt
dƒt
dƒt
dƒt
dƒgtd    dd    ddgtjdd œƒ}|jd    d…}|jdd …|_||jdd…<t ||¡dS)Nrr‘ÚbazrRr¯rnrMr0rrðrñrVròZ20000101Z20000102Z20000103rU) r rr§rhrôr#rgr$r%rr)r7r(Úrhsr)r*r*r+Ú test_loc_setitem_frame_multiples1s:ÿÿ þÿûøÿ z7TestLocBaseIndependent.test_loc_setitem_frame_multiplesr¹r"NrÝÚZcCsLtddgddggddgd}||jd|f<|jd    }t|ƒrD|d
ksHt‚dS) NrMr0rRrUr"rlrur)rr"r8)r r#rr{)r7r¹rÝr(rr*r*r+Ú"test_loc_setitem_with_scalar_indexVs    
z9TestLocBaseIndependent.test_loc_setitem_with_scalar_indexzindex,box,expectedr0rlr™rTrRrUrurMr`rVrSé    rQé é cCs<tddgddgddggddgd    }||j|<t ||¡dS)
NrMr0rRrUrVrSr"rlru©r r#r$r%)r7rgÚboxr)r(r*r*r+Ú test_loc_setitem_missing_columnses5"
z7TestLocBaseIndependent.test_loc_setitem_missing_columnscCsZtdtdƒ d¡tjgiƒ}|j}|jdg}t |j|¡|jdg}t |j|¡dS)Nrr«ÚUTCrrM)    r rÚ tz_localizerprqÚdtypesr‹r$r¨r©r*r*r+Útest_loc_coercionŸs   z(TestLocBaseIndependent.test_loc_coercioncCs^tdtdddƒtdddƒgiƒ}|j}|jdg}t |j|¡|jdg}t |j|¡dS)NréÜrMiôr0r)r rrBr‹r$r¨r©r*r*r+Útest_loc_coercion2ªs    z)TestLocBaseIndependent.test_loc_coercion2cCsZtddgdgdiƒ}|j}|jdd…}t |j|¡|jdd…}t |j|¡dS)NÚtextz
some wordsr:rr0rR)r rBr‹r$r¨r©r*r*r+Útest_loc_coercion3µs z)TestLocBaseIndependent.test_loc_coercion3cCsftdƒ d¡tdƒ d¡g}t|ddgd}ttd}|d||ƒd<|d    ||ƒd<t ||¡dS)
Né*r@išrr‘rxr¯rrM)rrArrÚr$r¨)r7Z
indexer_slÚvalsr)rr*r*r+Útest_setitem_new_key_tzÀs  þ
z.TestLocBaseIndependent.test_setitem_new_key_tzc    Cs˜tddddddgddddddgd    œd
dd
dddgd }d }tjt|d |jdd…W5QRXd}tjt|d |jd
d…W5QRXd }tjt|d |jdd…W5QRXtddddddgddddddgd    œd
dd
dddgd jd
d}|jdd…}tddddgddddgd    œddddgd }t ||¡|jd
d…}t ||¡|jdd…}tdddgdddgd    œdddgd }t ||¡dS)NrMr0rRrUrVrSrTr`rnrrxz5'Cannot get left slice bound for non-unique label: 1'ršz5'Cannot get left slice bound for non-unique label: 0'©Úaxis)r r‚rr5r#Ú
sort_indexr$r%)r7r(ržrr)r*r*r+Útest_loc_non_uniqueÎs6 ÿ ÿþ*  $z*TestLocBaseIndependent.test_loc_non_uniquez
length, l2é„r»i » 順c    CsÒtdƒ}t ttj |t|ƒ¡t |¡|dtt     |t|ƒf¡dg||dg¡}|j
j dksbt ‚t |¡}|j |}t | dg¡tt     t|ƒt|ƒf¡dgt|ƒ|d| |dd…¡g¡}t ||¡dS)NZABCDEFGrÒrFrM)r¶rpÚconcatr rhr¦r0rÍriÚonesrgZ    is_uniquer{r#Útaker$r%)r7ÚlengthÚl2rfr(rêrr)r*r*r+Ú test_loc_non_unique_memory_errorðs0ý úÿ 
 
 
 ýùÿ z7TestLocBaseIndependent.test_loc_non_unique_memory_errorcCs\tddgddggƒ}d|j_|jddgjj}|dks:t‚|jddgjj}|dksXt‚dS)NrMZ
index_namer)r rgrwr‹r{r#©r7r(rr*r*r+Ú test_loc_names  z$TestLocBaseIndependent.test_loc_namecCsžt dd¡}tj|jdd…gf|jdd…dd…fdddtj|jgdd…f|jdd…dd…fdddtj|jg|jdd…dd…fddddS)NrVr0rT)Úcheck_index_typeÚcheck_column_type)r$ZmakeCustomDataframer%r#r‹r r*r*r+Ú!test_loc_empty_list_indexer_is_oks& ÿÿÿz8TestLocBaseIndependent.test_loc_empty_list_indexer_is_okcCsÀtddddgiƒ}|jdd…}||k    s,t‚|dd…|k    s@t‚|jdd…dd…f|k    s^t‚t |dj|dj¡szt‚dddg|jdd…df<|r²|ddddgk ¡sÆt‚n|ddk ¡sÆt‚ttj dd¡ƒ}|rü|d|jdd…dfk    sút‚n |d|jdd…dfkst‚t    dddddd    gƒ}|jdd…}||k    sLt‚|dd…|k    sbt‚d
d d g|dd…<|rœt|dd…dddgkƒs¼t‚n t|dd…d
d d gkƒs¼t‚dS) Nr rMr0rRrUrQrrVrSrTr`r:)
r r#r{rhZ shares_memoryÚ_valuesrîr¦r0r)r7Úusing_copy_on_writeZ original_dfZ    sliced_dfr(Zoriginal_seriesZ sliced_seriesr*r*r+Ú&test_identity_slice_returns_new_object-s,   "z=TestLocBaseIndependent.test_identity_slice_returns_new_objectcCsš|stjjdd}|j |¡tttdƒtdƒƒddgd}| ¡}|j    dd…df}|d7}t
  ||¡| ¡}|j    |j df}|d7}t
  ||¡dS)Nz!accidental fix reverted - GH37497)ÚreasonrRr rrur0) r‚rƒZxfailÚnodeZ
add_markerr Úzipr§r·r#r$r%rg)r7r8r]rƒr¤rÿÚqÚzr*r*r+Útest_loc_copy_vs_viewTs  z,TestLocBaseIndependent.test_loc_copy_vs_viewcCs’t d¡j}tddg|d|gd}|j|d}|jd}||ksHt‚|j|dg}|jdg}t ||¡|j|d|g}t ||¡dS)Nr¿rMr0rxr)    rhÚiinfoÚmaxrr#r‹r{r$r¨)r7Úumaxrrr)r*r*r+Útest_loc_uint64hs 
   z&TestLocBaseIndependent.test_loc_uint64c    Csrt d¡j}tddg|d|gd}tjtdd|jdW5QRXtjtdd|jdgW5QRXdS)Nr¿rMr0rxz-1ršr×)rhrerfrr‚rr5r#)r7rgrr*r*r+Ú!test_loc_uint64_disallow_negativeys  z8TestLocBaseIndependent.test_loc_uint64_disallow_negativecCsRdddg}t|dgt|ƒdœƒ}tddgd}||jdd…df<t ||¡dS©NrMr0rR©r¤rÿr¤rÿru)r rÍr#r$r%©r7rmr)r(r*r*r+Ú*test_loc_setitem_empty_append_expands_rows†s
 
zATestLocBaseIndependent.test_loc_setitem_empty_append_expands_rowscCsfdddg}t|dgt|ƒdœƒ}tddgd}|d tj¡|d<||jdd…df<t ||¡dSrj)r rÍrÆrhrôr#r$r%rlr*r*r+Ú6test_loc_setitem_empty_append_expands_rows_mixed_dtype‘s 
zMTestLocBaseIndependent.test_loc_setitem_empty_append_expands_rows_mixed_dtypecCsDtdgtjgdœƒ}tddgtd}|jd|jd<t ||¡dS)Nrûrkr¤rÿ©rfr°)rr¤)r rhr    rr#r$r%rr*r*r+Ú*test_loc_setitem_empty_append_single_valueœszATestLocBaseIndependent.test_loc_setitem_empty_append_single_valuec    Cs¤ddg}tddgd}|j tj¡|_dt ¡j›d}tjt    |d||j
d    dgdf<W5QRXd
  d d d g¡}tjt |d||j
d    d…df<W5QRXdS)NrMr0r¤rÿruz"None of \[Index\(\[0, 1\], dtype='z'\)\] are in the \[index\]ršrú|z?cannot copy sequence with size 2 to array axis with dimension 0zCcould not broadcast input array from shape \(2,\) into shape \(0,\)z@Must have equal len keys and value when setting with an iterable) r rgrÆrhrôrÔr°r‚rr5r#ÚjoinÚ
ValueError)r7rmr(ržr*r*r+Ú$test_loc_setitem_empty_append_raises£sÿýÿz;TestLocBaseIndependent.test_loc_setitem_empty_append_raisescCsDtddgddggƒ}|jt d¡}tddgdd}t ||¡dS)NrMr0rRrUrrv)r r#rhrŠrr$r¨)r7r(rrËr*r*r+Útest_indexing_zerodim_np_arrayºsz5TestLocBaseIndependent.test_indexing_zerodim_np_arraycCs,tddgƒ}|jt d¡}|dks(t‚dS)NrMr0r)rr#rhrŠr{)r7rËrr*r*r+Ú%test_series_indexing_zerodim_np_arrayÁs z<TestLocBaseIndependent.test_series_indexing_zerodim_np_arraycCslddddddgdgd}t|tddƒd    }ttddƒtjd
}ddddddg|jd dd …<t ||¡dS) NrMr0rRrUrVrSiÚiärxrör—r×)rr§rhr®r#r$r¨)r7rmr)rr*r*r+Útest_loc_reverse_assignmentÇs
z2TestLocBaseIndependent.test_loc_reverse_assignmentcCs¶tj d¡dd„tdƒDƒ}t|dgd}t|dgtd}t ||¡dd„|Dƒ|j|j    df<t|dgt
d  t¡}t ||¡d    d„|Dƒ|d<t|dgt
d}t ||¡dS)
Né cSsg|]}ttj ¡dƒ‘qS)gê-™—q=)r&rhr¦)r£rEr*r*r+r¥Ôsz^TestLocBaseIndependent.test_loc_setitem_str_to_small_float_conversion_type.<locals>.<listcomp>rVr"rurocSsg|] }t|ƒ‘qSr*©rr¢r*r*r+r¥ÛscSsg|] }t|ƒ‘qSr*ryr¢r*r*r+r¥ás) rhr¦Úseedr§r rÚr$r%r#rgrrÆ)r7Zcol_datarr)r*r*r+Ú3test_loc_setitem_str_to_small_float_conversion_typeÑs   zJTestLocBaseIndependent.test_loc_setitem_str_to_small_float_conversion_typec    CsÄtdddd}|jdk|jdk@}ttj t|ƒd¡|d}t     ||¡}|j
t ddƒ}|j
|}t  ||¡|j
d    d…}|j
t ddƒ}|d
d…}|j  d¡|_ |j  d¡|_ t  ||¡dS) Nú1/1/2000z1/5/2000Z5min©Úfreqr:rXrRrxz1/4/2000r×)rÚhourÚminuter rhr¦r0rÍr$Úget_objr#rrzrgÚ
_with_freq)    r7Úframe_or_seriesÚrngrêr9rr|Úchunkr)r*r*r+Útest_loc_getitem_time_objectås 
  z3TestLocBaseIndependent.test_loc_getitem_time_objectÚ
spmatrix_tZ
coo_matrixZ
csc_matrixZ
csr_matrixr°c Cs ddl}t|j|ƒ}d\}}|tj|||d|d}tj |¡}td|ƒ}|j|j    }    | 
¡|}
t   |    |
¡|j|j j    }    t |t|dd¡}
t   |    |
¡dS)Nr)rVrTr¯r0)Z
fill_value)Ú scipy.sparseÚgetattrÚsparserhÚeyer Ú from_spmatrixr§r#rrZtoarrayr$Zassert_numpy_array_equalrBÚfullr) r7r‡r°ZscipyÚrowsrÇZspmatrixr(Zitr_idxrr)r*r*r+Ú$test_loc_getitem_range_from_spmatrixùs  
   z;TestLocBaseIndependent.test_loc_getitem_range_from_spmatrixcCs<tdtjddgtdƒdiƒ}|jddg}t ||¡dS)Nr"rrôr¯rM)r rprŠrr#r$r%rWr*r*r+Ú,test_loc_getitem_listlike_all_retains_sparseszCTestLocBaseIndependent.test_loc_getitem_listlike_all_retains_sparsecCs¦ddlm}tj |dƒ¡}|jtdƒ}tdddddgdddddggtddƒd}t     ||¡|jtdƒjtd    ƒ}tdddddggtddƒd}t     ||¡dS)
Nr)r‹rVr0rûrÃr®r¯rM)
rˆr‹r rŠrŒr#r§rr$r%)r7r‹r(rr)r*r*r+Útest_loc_getitem_sparse_frames þ ÿz4TestLocBaseIndependent.test_loc_getitem_sparse_framecCsŠtdddddgtddƒd}|jtdƒ}tddgtddƒd}t ||¡|jtdƒjtdƒ}tddgtddƒd}t ||¡dS)NrûrÃr®r¯r0rR)rrr#r§r$r¨)r7rËrr)r*r*r+Útest_loc_getitem_sparse_series+s z5TestLocBaseIndependent.test_loc_getitem_sparse_seriesr#r‹cCsVtdddgdddggttƒd}t||ƒd}tdddgttƒdd}t ||¡dS)NrûrÃçø?r´r¯r)r°rw)r rrr‰rr$r¨)r7r¹r(rr)r*r*r+Ú!test_getitem_single_row_sparse_df7s z8TestLocBaseIndependent.test_getitem_single_row_sparse_dfÚkey_typecCsH|dddgƒ}|jdd…|f}|jdd…dddgf}t ||¡dS)Nr"rlr™)r#r$r%)r7Ú float_framer•Úidxrr)r*r*r+Útest_loc_getitem_iterable?sz0TestLocBaseIndependent.test_loc_getitem_iterablecCsbttjjddƒ}tdddd|_|jtdƒd…dd…f}|jdd…dd…f}t     ||¡dS)N©rQrUrâZ0srQrË©ÚstartÚperiodsr~)
r rhr¦Únormalrrgr#rr$r%r©r*r*r+Ú#test_loc_getitem_timedelta_0secondsFs
z:TestLocBaseIndependent.test_loc_getitem_timedelta_0secondsú val,expectedìÿÿÿÿìcCs4tddgddgd}|j|}||_t ||¡dS)NrMr0r r¡rx)r r#rwr$r¨)r7rór)r(rr*r*r+Útest_loc_getitem_uint64_scalarNs
z5TestLocBaseIndependent.test_loc_getitem_uint64_scalarcCsP|}tdddgtdddg|dd}| ¡}d    |jd<d    |jd
<t ||¡dS) Nr rr<rçà?rMr¯rxZzoor0)rrr·r#r‹r$r¨)r7Úfloat_numpy_dtyper°rr)r*r*r+Ú+test_loc_setitem_int_label_with_float_indexYs  
 
zBTestLocBaseIndependent.test_loc_setitem_int_label_with_float_indexzindexer, expectedrCcCs\ttdƒdd}tdtdƒid|d}d|j|j|df<t||dgdd}t ||¡dS)    NrQrË©r r¤rô©r°rgrCr)rr§r r#rgr$r%)r7r¹r)Útdir(r*r*r+Ú/test_loc_setitem_listlike_with_timedelta64indexds üzFTestLocBaseIndependent.test_loc_setitem_listlike_with_timedelta64indexcCsŒtdddddgtdƒdœƒ}tdddddgtdƒdœƒ}tddgddgd|jdd…df<tddgddgd|jdd    …df<t ||¡dS)
NrMZaaaaar½rZaabbar ©Ú
categoriesr0rR)r r¶r    r#r$r%)r7r(r|r*r*r+Ú8test_loc_setitem_categorical_values_partial_column_slice~s
""zOTestLocBaseIndependent.test_loc_setitem_categorical_values_partial_column_slicecCsˆtdgdgdœƒ}t|ddddgd}||jdd…df<|d}t||jdd t¡}t ||¡||d<t |dt|dd    ¡dS)
Nr r)ÚAlphaZNumericr­rr<rªr¬rv)    r r    r#rrgrÆrÚr$r¨)r7r(r«rr)r*r*r+Ú'test_loc_setitem_single_row_categorical‡s z>TestLocBaseIndependent.test_loc_setitem_single_row_categoricalcCsŠtdtdƒgdiƒ}t d¡|jdd…df<tdƒ|jdksDt‚tdƒ|jdksZt‚td    d
d
ƒ|jd <td ƒ ¡|jd ks†t‚dS) Nr<z
2010-10-01rRz
2008-08-08rrM)rr<)rMr<iÕrV)r0r<z
2005-05-05)r rrhrr#r{rr r*r*r+Ú"test_loc_setitem_datetime_coercion˜s z9TestLocBaseIndependent.test_loc_setitem_datetime_coercionÚidxerÚvarcCsX|}tddd|d}td|dgd}t|dgtjd}||jdd…|f<t ||¡dS)    Nz
2015-07-12rRÚH)r›rœr~ÚtzrÂr±rÒr)rr rhr®r#r$r%)r7r°Ztz_naive_fixturer³r—r)rr*r*r+Ú!test_loc_setitem_datetimeindex_tz¡s z8TestLocBaseIndependent.test_loc_setitem_datetimeindex_tzc
Cs|tdddd}ttj t|ƒd¡|d}tdddƒ}ttd    ddƒtd
ddƒƒ}d d d dg}ddddddddddddg }| ¡}d|j    |<|j    |}|j    | ¡}    d|    j    dd…<|r¼|     
t ¡}    t   ||    ¡| ¡}d|j    |<|j||j    |<t   ||¡| ¡}d|j    |<|j    |}|j    | ¡}    d|    j    dd…<|r>|     
t ¡}    t   ||    ¡| ¡}d|j    |<|j||j    |<t   ||¡dS)Nz
2012-01-01z
2012-01-05Z30minr}rVrxr<rrxéééHéxé¨ééééJéKéLézé{é|éªé«é¬)rr rhr¦r0rÍrr…r·r#rÆrr$r%r‹)
r7Zusing_array_managerrgr(ZakeyZbkeyZaindsZbindsrr)r*r*r+Útest_loc_setitem_time_key­s<  
 
 
 
 
 
 
 
z0TestLocBaseIndependent.test_loc_setitem_time_keyrIcCs¼t dddg¡}tdddgddd    gg|d
}| ¡}tjd d d |jdd…|f<tdddgdddgg|d
}t ||¡|j    dd}tjd d d |jdd…|f<|j    dd}t ||¡dS)N)r"rU)rlÚ3)r"Ú2rMr0rRrUrVrSru)r0r0rôr¯rrK)
rÚ from_tuplesr r·rhÚzerosr#r$r%rM)r7rIr r(r9r)r*r*r+Ú,test_loc_setitem_unsorted_multiindex_columnsÓs   zCTestLocBaseIndependent.test_loc_setitem_unsorted_multiindex_columnscCs>tdddg|d}d|jd<tdddg|d}t ||¡dS)NrMr0rRr¯rUr©rr#r$r¨)r7Zany_int_numpy_dtyper'r)r*r*r+Útest_loc_setitem_uint_dropâs
z1TestLocBaseIndependent.test_loc_setitem_uint_dropcCsptdt dd¡gƒ}t dd¡|jdddg<tdt dd¡gƒ}tt dd¡ƒ|jdddg<t ||¡dS)NrQrrCrMr0rR)rrhÚ timedelta64r#rr$r¨)r7rr)r*r*r+Útest_loc_setitem_td64_non_nanoês
z5TestLocBaseIndependent.test_loc_setitem_td64_non_nanoc    Cs€tj dd¡}ttdƒƒ}d ddg¡}tjt|d||j    tdƒ<W5QRXd}tjt|d||j    dd…<W5QRXdS)Nr0rqz,shape mismatch: value array of shape \(2,2\)z0cannot reshape array of size 4 into shape \(2,\)ršzEcould not broadcast input array from shape \(2,2\) into shape \(2,?\))
rhr¦r0rr§rrr‚rrsr#)r7rmrržr*r*r+Ú test_loc_setitem_2d_to_1d_raisesòs þÿz7TestLocBaseIndependent.test_loc_setitem_2d_to_1d_raisescCsXtjddd}tdddgdddgd    d
d gg|d d dgd}d}|jd}t ||¡dS)NrrR)r›rœrMr0rUrVrSrTr`r:r"rlr™rÒ)r£r")rpÚinterval_ranger r#r$Úassert_almost_equal)r7rgr(r)rr*r*r+Útest_loc_getitem_interval_indexsÿ
z6TestLocBaseIndependent.test_loc_getitem_interval_indexcCsztjdddd}tdddgddd    gd
d d gg|d ddgd}tjddddd}tddg|d d}|jd}t ||¡dS)NrrRZboth)r›rœÚclosedrMr0rUrVrSrTr`r:r"rlr™rÒ)r›rœr~rÔr¬©rMr")rprÑr rr#r$r¨)r7rgr(Z    index_expr)rr*r*r+Ú test_loc_getitem_interval_index2sÿ
z7TestLocBaseIndependent.test_loc_getitem_interval_index2Útpl©rM©rMr0cCsRtddgddd}t|d}|j|g}t|gddd}t|d}t ||¡dS)NrØrÙr"F©rwZ tupleize_colsrx)rr r#r$r%)r7r×r—r(rr)r*r*r+Ú+test_loc_getitem_index_single_double_tuplessý
 
zBTestLocBaseIndependent.test_loc_getitem_index_single_double_tuplescCsntdddgƒ}|ddƒ}|ddƒ}t||gdd    d
}td d g|d dgd}|j|ddƒd }|dksjt‚dS)NÚ    IndexTyper rrr‘r5ZbofZcomposite_indexFrÚrÙ)rRrUr"rlrÒrM)rrr r#r{)r7rÜZidx1Zidx2rgr(rr*r*r+Ú!test_loc_getitem_index_namedtuple)s
 
z8TestLocBaseIndependent.test_loc_getitem_index_namedtuplecCs€ttj dd¡dddddgdd    d
gd }d |d <tj|j|jddd…d f<tjtjd tjd tjgtd}t     
|d j |¡dS)NrVrRr rr<rÊrÐrr‘r5rÒÚquxr&r0r¯) r rhr¦r0r    r#rgrŠrÚr$rÒrrrjr*r*r+Ú$test_loc_setitem_single_column_mixed3s  ýz;TestLocBaseIndependent.test_loc_setitem_single_column_mixedcCspttj dd¡tdƒd}tj|d<d|jd<|j}tt     d¡gdt     d    ¡gd
d d dgd }t
  ||¡dS)NrXrRÚABCruÚeventr)rQrár®rÚr"rlr™rx) r rhr¦ríÚtupler    r#rBrr°r$r¨rŒr*r*r+Útest_loc_setitem_cast2>s
 
 
þz-TestLocBaseIndependent.test_loc_setitem_cast2cCsbtdtjdtjdiƒ}d|jd<|jjt tj¡ks:t‚t d¡|_|jjt tj¡ks^t‚dS)NÚonerSr¯)rMrärT)    r rhriZint8r#rBrär°r{r r*r*r+Útest_loc_setitem_cast3Ks
 
 z-TestLocBaseIndependent.test_loc_setitem_cast3cCst|tdƒdddddgd}dd    d
g}|jdkr>dgd    gd
gg}||jtdƒ<|ddd    dd
g|jd}t ||¡dS) NrVrRrUrMrr0rxr:rQr;)r§Úndimr#rgr$rz)r7rƒr9rrr)r*r*r+Útest_loc_setitem_range_keySs
 
z1TestLocBaseIndependent.test_loc_setitem_range_key)jrr€rrŽr‚rƒr„rrŸr¡rªr­rºrÁrÈrÌrÎrÏrÖrÜrÞrárërïÚfixturerõrhrŠrôrørúrürþrr rrr r!r"r-r1r2r4r7r…r9r r    r?rCrErGrJrNZarm_slowrVrXr[r^rdrhrirmrnrprtrurvrwr{r†r®ÚcomplexÚtdZskip_if_no_scipyrrr‘r’r”Úiterrrr˜ržr¢r¥r©r¬r®r¯r´rÆrËrÍrÏrÐrÓrÖrÛrÝrßrãrårçr*r*r*r+r‡øsfþþóþ
 
# 
 '
*þ
 1
 
%ÿ $
þý    
(
þý     ÿý$
þý    $
þý     ÿýØþ3
   " "
'   
 
 
 
ÿ
  ûþ
 
        
&
 
 
  r‡c@sNeZdZejejejgddd„ƒZejdd„ƒZ    dd„Z
dd    „Z d
d „Z d S) ÚTestLocWithEllipsis)ÚparamscCs|jSr[)Úparam)r7r8r*r*r+r¹bszTestLocWithEllipsis.indexercCs|}|tk    r| ¡}|Sr[)rÚto_frame)r7Úseries_with_simple_indexrƒr9r*r*r+r9gszTestLocWithEllipsis.objcCs||ƒd}t ||¡dS)N.)r$rz)r7r9r¹rr*r*r+Útest_loc_iloc_getitem_ellipsisns z2TestLocWithEllipsis.test_loc_iloc_getitem_ellipsisc
    Cs|}|tjkst|ƒdkrdn|jd}|tjkr@t|jƒr@dS|tjkrˆt|jtƒrˆd}tj    t
|d||ƒd|gf}W5QRXn8t|ƒdkrÀ||ƒd|gf}||ƒ|g}t  ||¡|tjkrÎdn|j }|  ¡}    ||    ƒd|gf}||    ƒdd…|gf}t ||¡dS)Nrz2MultiIndex does not support indexing with Ellipsisrš.)r$r‹rÍrgr#rryrr‚rÚNotImplementedErrorr¨rwrïr%)
r7rðr¹r9rIržrr)Úkey2r(r*r*r+Ú&test_loc_iloc_getitem_leading_ellipsesrs"$  z:TestLocWithEllipsis.test_loc_iloc_getitem_leading_ellipsesc    CsÔ|tjkst|ƒdkrdn|jd}tjttd||ƒdW5QRXtjttd||ƒd|gdfW5QRXtjttd||ƒdd|fW5QRXtjtdd||ƒ|ddfW5QRXdS)Nrrš)...úToo many indexers)r$r‹rÍrgr‚rrr)r7r9r¹rIr*r*r+Ú0test_loc_iloc_getitem_ellipses_only_one_ellipsisŠs$zDTestLocWithEllipsis.test_loc_iloc_getitem_ellipses_only_one_ellipsisN) rr€rr‚rèr$r#r‹r¹r9rñrôrör*r*r*r+rìas
 
rìc@sÐeZdZej dddgddddgddddggfddgddddgddddggfddgddgfddddgddddggfddgddgfddddgddddggfddgddgfddddgddddggfddgddgfddddgddddggfddgddgfdddgdddggfg¡ej ddd    g¡d
d „ƒƒZd d „Zdd„Zdd„Z    dd„Z
dd„Z dd„Z dd„Z dd„Zdd„Zdd„Zej d ejejd!ejf¡d"d#„ƒZd$d%„Zej d&d'd(g¡d)d*„ƒZd+d,„Zd-d.„Zd!S)/ÚTestLocWithMultiIndexzkeys, expectedrr rMr0r<ÚdimrgrfcCsš|dddddgdddddggi}tt d¡ dd¡f|Ž}t |¡}|dkrn|j|dd…f}t |j    |¡n(|d    kr–|jdd…|f}t |j
|¡dS)
Nr<r rrMr0érVrgrf) r rhriÚreshaperrr#r$Úassert_index_equalrgrf)r7røÚkeysr)Úkwargsr(Ú    exp_indexr}r*r*r+Ú'test_loc_getitem_multilevel_index_orderžs 
z=TestLocWithMultiIndex.test_loc_getitem_multilevel_index_ordercCs |}|jd}|djd}|jj|jjdd…ks8t‚|jj|jjdd…ksTt‚|jd}|djd}|jj|jjdks„t‚|jj|jjdksœt‚dS)NéÐr"rM)rr0r0)r#rgrr{rw)r7Z/multiindex_year_month_day_dataframe_random_dataZymdrÚresult2r*r*r+Útest_loc_preserve_names¸s
 
z-TestLocWithMultiIndex.test_loc_preserve_namescCsft dgddgg¡}td|d}|jg}|dd…}t ||¡|j|jdd…}t ||¡dS)NrrMrx)rÚ from_productrr#r$r¨r‹)r7r rr}r)Zres2r*r*r+Ú.test_loc_getitem_multiindex_nonunique_len_zeroÅs 
  zDTestLocWithMultiIndex.test_loc_getitem_multiindex_nonunique_len_zerocCs¤tdgt dgdgg¡ƒ}|jd}|dks0t‚t dgddgg¡}tdgt|ƒt|d}|jd}|dksrt‚tdgt|ƒt|d}|jd}|dks t‚dS)    NÚLevel1ÚLevel2)rrÚLevel2_aZLevel2_br§)rrrM)rrrr#r{rrÍrÚ)r7rrZmidxr*r*r+Ú0test_loc_getitem_access_none_value_in_multiindexÒs
 
 
zFTestLocWithMultiIndex.test_loc_getitem_access_none_value_in_multiindexc CsŽtjtddddddddgddddddddgƒddgd    }td
d
d
d
d
d
d
d
g|d }d |jd d…<td
d
d d d d d
d
g|d }t ||¡dS)Nr‘r5rrÞräÚtwoÚfirstÚsecondrrMrxr»)r5rä)rr    )rrÉrarr#r$r¨)r7rgrr)r*r*r+Ú!test_loc_setitem_multiindex_sliceãsþûz7TestLocWithMultiIndex.test_loc_setitem_multiindex_slicecCsJtdddd}ttdƒ|ƒ}|jtdddƒtdddƒ…}t ||¡dS)NrðZ10minrP©r~rœilrMi4)rrr§r#rr$r¨)r7Útimesrrr*r*r+Ú7test_loc_getitem_slice_datetime_objs_with_datetimeindexõszMTestLocWithMultiIndex.test_loc_getitem_slice_datetime_objs_with_datetimeindexcCshttdƒtdƒdœtddƒd}|jddgddgf}td    d
gd    d
gdœtddgƒd}t ||¡dS) NrQr½z
2010-01-01z
2010-01-10rxz
2010-01-05r rrrU)r r§rr#r r$r%rŒr*r*r+Ú3test_loc_getitem_datetime_string_with_datetimeindexûsþ
þzITestLocWithMultiIndex.test_loc_getitem_datetime_string_with_datetimeindexcCsªtjddddddgddgd}tddgdd    gd
d gd d gddgddgg|ddgd}|jdd}tddgdd    gddggddg| ddd g¡d}|jd}t ||¡dS)N)rr‘)ZbahZbamr"rlrrûrMr´r0rNrRç@rUç@rVç@rSr™rìrÒr)Úlevelre)rrÉr rMrSr#r$r%)r7r r(r)rr*r*r+Ú3test_loc_getitem_sorted_index_level_with_duplicatess:ú÷ úö ÿ
zITestLocWithMultiIndex.test_loc_getitem_sorted_index_level_with_duplicatescCs@tdddgdd}d|jd<tddddgdd}t ||¡dS)    Nr rr<Úcategoryr¯rrRrÚrÌ©r7rr)r*r*r+Ú1test_additional_element_to_categorical_series_loc*s
zGTestLocWithMultiIndex.test_additional_element_to_categorical_series_loccCs@tdddgdd}d|jd<tddddgdd}t ||¡dS©Nr rr<rr¯rRrÌrr*r*r+Ú'test_additional_categorical_element_loc1s
z=TestLocWithMultiIndex.test_additional_categorical_element_loccCsªtdddgttdddg|dƒd}tj|jd<tdddtjgttdddg|dƒd}t ||¡tj|jd<tdtjdtjgttdddg|dƒd}t ||¡dS)NrMr0rRr¯)rr
rrhr    r#r$r¨)r7Zany_numeric_ea_dtypeZsrsr)r*r*r+Ú&test_loc_set_nan_in_categorical_series8s þ  þ  þz<TestLocWithMultiIndex.test_loc_set_nan_in_categorical_seriesÚnaNcCsjtdddgdd}||jd<tddddgdd}||jd<t ||¡tddd|gdd}t ||¡dSrrÌ)r7rZ srs_enlargeZ srs_setintor)r*r*r+Ú,test_loc_consistency_series_enlarge_set_intoMs
 
 zBTestLocWithMultiIndex.test_loc_consistency_series_enlarge_set_intocCs¢tt ddd¡ttddgƒtdƒgdgddgdtdƒgd    d
gd d }tddgddgd d    dd}|jjd}t     ||¡|j
dgjjd}t     ||¡dS)Nr0ér rrQrrVrMZIndex1ZIndex2)r
Úcodesr)rmrgFr)r«Úorderedrwr°) r rhrirr r§rgr
r$rûr#r©r*r*r+Ú5test_loc_getitem_preserves_index_level_category_dtypeZs& ýþ    û  zKTestLocWithMultiIndex.test_loc_getitem_preserves_index_level_category_dtypeÚlt_valuerXrQc    Csptdddddgitdƒddd    d
ggd }tjtd d 0|j|d|kdd…fjdgdd…fW5QRXdS)Nr r<éé"é-ÚaabbrrMr0rRrxz\['b'\] not in indexršr)r r¶r‚rr5r#)r7r"r(r*r*r+Ú>test_loc_multiindex_levels_contain_values_not_in_index_anymoress(zTTestLocWithMultiIndex.test_loc_multiindex_levels_contain_values_not_in_index_anymorecCslt tjtjg¡}ddg}t ||g¡}tddg|d}|jdd…df}tdgtjgd}t ||¡dS)Nr‘r5rrMrx)    rhrŠr    rrrr#r$r¨)r7Úlev1Úlev2r rrr)r*r*r+Ú'test_loc_multiindex_null_slice_na_levelzsz=TestLocWithMultiIndex.test_loc_multiindex_null_slice_na_levelcCsttjtdƒtdƒddggdddgd}ttdƒ|d}|jd    dd…dd…f}|j d
¡dd …}t     |j|¡dS) NÚabZxyrMr0Únumrr`rxr rrU)
rrr¶rr§r#rgZ    droplevelr$rû)r7r rZ
loc_resultr)r*r*r+Útest_loc_drops_level†sÿz*TestLocWithMultiIndex.test_loc_drops_level)rr€rr‚rƒr„rÿrrrr rrrrrrrhr    rpZNArqrr!r'r*r-r*r*r*r+r÷s<&&&&"ùþ     "
 
 r÷c    @sÌeZdZejjdd„ƒZdd„Zdd„Zdd„Z    d    d
„Z
ejj d d d „dd „dd „dd „gddddgddd„ƒZ dd„Z dd„Zdd„Zdd„Zej d ¡d!d"„ƒZej  d#d$d%d&d'd(d)g¡d*d+„ƒZd,S)-ÚTestLocSetitemWithExpansioncCsNtdtdƒidd}t|ƒd|jt|ƒ<tdtdƒidd}t ||¡dS)Nr¤i@Brôr¯rMiAB)r r§rÍr#r$r%rr*r*r+Ú/test_loc_setitem_with_expansion_large_dataframe”szKTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_large_dataframecCsVttd}d|jd<t |tdgdgd¡d|jd<t |tddgddgd¡dS)Nr¯rMrxrR©rrÚr#r$r¨©r7rr*r*r+Útest_loc_setitem_empty_seriesœs
 
 
 
z9TestLocSetitemWithExpansion.test_loc_setitem_empty_seriescCsVttd}d|jd<t |tdgdgd¡d|jd<t |tddgddgd¡dS)Nr¯rûrMrxrNrRr0r1r*r*r+Ú#test_loc_setitem_empty_series_float¦s
 
 
 
z?TestLocSetitemWithExpansion.test_loc_setitem_empty_series_floatcCs€ttd}d|jd<t |tdgdgd¡d|jd<t |tddgddgd¡d|jd<t |tdddgdddgd¡dS)Nr¯rMrrxrRr‘rUr0r1r*r*r+Ú%test_loc_setitem_empty_series_str_idx°s
 
 
 
zATestLocSetitemWithExpansion.test_loc_setitem_empty_series_str_idxcsntdddtdƒd‰‡fdd„tdƒDƒ}td    g|d    gd
}|D]}d|j|<qBtd|d
}t ||¡dS) Nr—r;rMú
US/Pacific)Útzinfocsg|]}ˆt|dd‘qS)rO)Úseconds)rr'©Úbaser*r+r¥¿szUTestLocSetitemWithExpansion.test_loc_setitem_incremental_with_dst.<locals>.<listcomp>érrx)rrr§rr#r$r¨)r7ZidxsrrBr)r*r8r+Ú%test_loc_setitem_incremental_with_dst¼s  zATestLocSetitemWithExpansion.test_loc_setitem_incremental_with_dstÚconvcCs|Sr[r*rår*r*r+ræÉrçz$TestLocSetitemWithExpansion.<lambda>cCs| ¡Sr[)Ú to_datetime64rår*r*r+ræÊrçcCs| ¡Sr[)Ú to_pydatetimerår*r*r+ræËrçcCs
t |¡Sr[)rhrrår*r*r+ræÌrçr7r=r>z np.datetime64)ÚidscCsbtdƒ}tdƒ}tƒ}d|j||ƒdf<d|j||ƒdf<tdddgi||gd}t ||¡dS)    Nz20130101 09:00:00z20130101 10:00:00r»rärbgY@gi@rx)rr r#r$r%)r7r<Zdt1Zdt2r(r)r*r*r+Ú#test_loc_setitem_datetime_keys_castÆs z?TestLocSetitemWithExpansion.test_loc_setitem_datetime_keys_castcCsTtddgiƒ}tdg|d|jdd…df<tdgtdg|ddœƒ}t ||¡dS)Nr"rMr)r rlrn)r r    r#r$r%)r7r rr)r*r*r+Ú1test_loc_setitem_categorical_column_retains_dtypeÛszMTestLocSetitemWithExpansion.test_loc_setitem_categorical_column_retains_dtypecCsœtddd}tddd}tddd}t||ddd}||ks@t‚t|d    gd
}d |j|d    f<ttjgt|ƒd g| t    |gƒ¡d    gt
d }t   ||¡dS) Nz2017-10-29 00:00:00+0200z Europe/Madrid©r³z2017-10-29 03:00:00+0100z2016-10-10 03:00:00Úleftr²)Z    inclusiver~rÝrÒr<r) rrr{r r#rhr    rÍÚappendr rÚr$r%)r7r›ÚendrBr—rr)r*r*r+Ú0test_loc_setitem_with_expansion_and_existing_dstâs    üzLTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_and_existing_dstcCsìttddgƒdgd}ddg|d<| d¡j d¡|_||jdk d¡j d    ¡}| ¡}||j    |jdkdf<t
|d
 d¡|j    d gdd }t   |j|¡|j    |jdkdft d ƒ}||j    |jdkdf<t   |j    |jdkdf|¡dS)Nz2015-03-30 20:12:32z2015-03-12 00:11:11r)rmrfÚnewÚoldÚnew_colr@r5r)rMrrvZ1s)r rrœrgrArrIZ
tz_convertr·r#rr$r¨r)r7r(Úvrsr)r*r*r+Útest_setitem_with_expansionôs
þ  z7TestLocSetitemWithExpansion.test_setitem_with_expansioncCsVtƒ}d|jd<d|jd<d|jdtjf<|j}tddtjgtjd}t ||¡dS)NrMr/r0)rMrMrRrr¯)    r r#rhÚinfrfrr®r$rûrŒr*r*r+Ú0test_loc_setitem_with_expansion_inf_upcast_empty
s
 
zLTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_inf_upcast_emptyz"ignore:indexing past lexsort depthc Cs`t|ƒs dS| d¡}t|ƒ}t |¡ tj¡}t||dgd}d}||ksPt‚| t|ƒ|¡}t    |t
ƒr€|dd|kst‚n|d|kst‚t |d¡ tj ¡}t||dgd}|  ¡}    ||    j |df<t |    |¡|  ¡d}
||
j |<|d tj¡}t |
|¡|  ¡}    ||    j |df<tt|ƒtjgtjg|t|ƒgdœ|d}t |    |¡dS)    Nr0rrÒZkapowr×rM©rrMrx)rÍÚrepeatrhrirÆrôr r{Úinsertryrr®r·r#r$r%r¨r¶r    r) r7rgÚNÚarrÚorigrIrþZexp_datar)r(rr*r*r+Ú/test_loc_setitem_with_expansion_nonunique_indexs8
 
 
 &þzKTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_nonunique_indexr°ZInt32ÚInt64ZUInt32ZUInt64ZFloat32ZFloat64cCsvtddddg|d}td|iƒ}t|jd}||j|jdf<t ||¡t|jd}|j|j|jdf<t ||¡dS)NrrMr0rRr¯rmrx)rr rgr#r$r%r\)r7r°rr(rr*r*r+Ú6test_loc_setitem_with_expansion_preserves_nullable_intCs    zRTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_preserves_nullable_intN)rr€rr‚rƒZslowr/r2r3r4r;r„r@rArFrKrMÚfilterwarningsrTrVr*r*r*r+r.“s6
 
 
 
ü
ø
 
 
 
-ÿr.c@s,eZdZdd„Zdd„Zdd„Zdd„Zd    S)
ÚTestLocCallablecCs„tddddgtdƒddddgdœƒ}|jdd„}t ||j|jdk¡|jd    d„dd…f}t ||j|jd
kdd…f¡|jd d„d d„f}t ||j|jdkd dd gf¡|jdd„dd„f}t ||j|jdkdf¡|jdd„dd„f}t ||j|jdkddgf¡|jdd„dd„f}t ||j|jdkddgf¡|jdd„dd„f}||jdks€t‚dS)NrMr0rRrUr&©r"rlr™cSs
|jdkS©Nr0©r"rår*r*r+ræ\rçzATestLocCallable.test_frame_loc_getitem_callable.<locals>.<lambda>cSs
|jdkS)Nr)rlrår*r*r+ræ_rçrcSs
|jdkSrZr[rår*r*r+ræbrçcSs
|jdkS©Nrlrurår*r*r+ræbrçFTcSs
|jdkSrZr[rår*r*r+ræerçcSsdSr\r*rår*r*r+ræerçrlcSs
|jdkSrZr[rår*r*r+ræhrçcSsddgS©Nr"rlr*rår*r*r+ræhrçr"cSs
|jdkSrZr[rår*r*r+rækrçcSsddgSr]r*rår*r*r+rækrçcSsdS)NrMr*rår*r*r+ræorçcSsdSr!r*rår*r*r+ræorçrÕ)    r r¶r#r$r%r"rlr¨r{©r7r(r}r*r*r+Útest_frame_loc_getitem_callableVs$ "  z/TestLocCallable.test_frame_loc_getitem_callablecCs¾tddddgtdƒddddgdœƒ}|jdd„d    d
gf}t ||j|jdkd    d
gf¡|jddgd d„f}t ||jddgd    d
gf¡|jdd d„f}t ||jdd    d
gf¡dS) NrMr0rRrUr&rYcSs
|jdkSrZr[rår*r*r+rævrçzITestLocCallable.test_frame_loc_getitem_callable_mixture.<locals>.<lambda>r"rlcSsddgSr]r*rår*r*r+ræyrçcSsddgSr]r*rår*r*r+ræ|rç)r r¶r#r$r%r"r¨r^r*r*r+Ú'test_frame_loc_getitem_callable_mixturers$ z7TestLocCallable.test_frame_loc_getitem_callable_mixturecCsžtddddgtdƒdœtdƒd}|jd    d
„}t ||jd d g¡|jd d
„dd…f}t ||jd d gdd…f¡|jdd
„dd
„f}t ||jd d gdf¡|jdd
„dd
„f}t ||jd d gdgf¡|jd d gdd
„f}t ||jd d gdf¡|jd d gdd
„f}t ||jd d gdgf¡|jdd
„df}t ||jd d gdf¡|jdd
„dgf}t ||jd d gdgf¡dS)NrMr0rRrUr&©ÚXrr.rxcSsddgS©Nr"r™r*rår*r*r+ræ„rçzHTestLocCallable.test_frame_loc_getitem_callable_labels.<locals>.<lambda>r"r™cSsddgSrcr*rår*r*r+ræ‡rçcSsddgSrcr*rår*r*r+ræŠrçcSsdS©Nrbr*rår*r*r+ræŠrçrbcSsddgSrcr*rår*r*r+rærçcSsdgSrdr*rår*r*r+rærçcSsdSrdr*rår*r*r+ræ‘rçcSsdgSrdr*rår*r*r+ræ”rçcSsddgSrcr*rår*r*r+ræ—rçcSsddgSrcr*rår*r*r+ræšrç)r r¶r#r$r%r¨r^r*r*r+Ú&test_frame_loc_getitem_callable_labelss""z6TestLocCallable.test_frame_loc_getitem_callable_labelscCsZtddddgtdƒdœtdƒd}| ¡}d    |jd
d „<| ¡}d    |jd d g<t ||¡| ¡}d|jdd „dd…f<| ¡}d|jd d gdd…f<t ||¡| ¡}d|jdd „dd „f<| ¡}d|jd d gdf<t ||¡| ¡}ddg|jdd „dd „f<| ¡}ddg|jd d gdgf<t ||¡| ¡}t ddg¡|jd d gdd „f<| ¡}t ddg¡|jd d gdf<t ||¡| ¡}d|jd d gdd „f<| ¡}d|jd d gdgf<t ||¡| ¡}d|jdd „df<| ¡}d|jd d gdf<t ||¡| ¡}d|jdd „dgf<| ¡}d|jd d gdgf<t ||¡dS)NrMr0rRrUr&rar.rxiìÿÿÿcSsddgSrcr*rår*r*r+ræ£rçzATestLocCallable.test_frame_loc_setitem_callable.<locals>.<lambda>r"r™rCcSsddgSrcr*rår*r*r+ræ©rçr×cSsddgSrcr*rår*r*r+ræ¯rçcSsdSrdr*rår*r*r+ræ¯rçrbrVrQcSsddgSrcr*rår*r*r+ræµrçcSsdgSrdr*rår*r*r+ræµrçrØcSsdSrdr*rår*r*r+ræ¼rçcSsdgSrdr*rår*r*r+ræÂrçcSsddgSrcr*rår*r*r+ræÈrçéüÿÿÿcSsddgSrcr*rår*r*r+ræÎrç)r r¶r·r#r$r%rhrŠ)r7r(r}r|r*r*r+Útest_frame_loc_setitem_callablesR"        z/TestLocCallable.test_frame_loc_setitem_callableN)rr€rr_r`rergr*r*r*r+rXUs rXc@sFeZdZdd„Zdd„Zdd„Zdd„Zej     d    d
d g¡d d „ƒZ
d
S)ÚTestPartialStringSlicingcCsdtdddgdddgdœtdd    d
gƒd }tddgddgdœtdd
gƒd }|jd }t ||¡dS) Nr rr<rMr0rR)rcrdz
2020-08-01z
2020-07-02z
2020-08-05rxz2020-08)r rr#r$r%r©r*r*r+Ú5test_loc_getitem_partial_string_slicing_datetimeindexÕs þ
þ
zNTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_datetimeindexcCsDtjdddd}| ¡}|jdd…}|jdd…}t ||¡dS)Nú
2017-01-01ú
2018-01-01r©r›rEr~z2017-12r×)rpÚ period_rangeÚ    to_seriesr#r‹r$r¨)r7Úpirrr)r*r*r+Ú8test_loc_getitem_partial_string_slicing_with_periodindexâs
zQTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_with_periodindexcCsBtdddd}| ¡}|jdd…}|jdd…}t ||¡dS)Nú1 dayú2 daysÚ1Hrlz1 daysr×)rrnr#r‹r$r¨)r7rÀrrr)r*r*r+Ú;test_loc_getitem_partial_string_slicing_with_timedeltaindexês
zTTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_with_timedeltaindexcCsDtdtdƒittdƒddd}|jd}|jd}t ||¡dS)Nr¤rRÚdaysr¦rxrú0 days)r r§rr‹r#r$r¨)r7r(r)Zslicedr*r*r+Ú#test_loc_getitem_str_timedeltaindexòs 
 
z<TestPartialStringSlicing.test_loc_getitem_str_timedeltaindexÚ indexer_endNú2020-01-02 23:59:59.999999999c    Cs–|dgdttdƒtdƒtdƒtdƒtdƒg|dd    }|dgd
ttdƒtdƒg|dd    }td|ƒ}||}t ||¡|j|}t ||¡dS) NrMrVz
2019-12-30z
2020-01-01z
2019-12-25ryz
2019-12-19rBrxr0)r rr…r$rzr#)r7Ztz_aware_fixturerxrƒr9r)r¹rr*r*r+Ú/test_loc_getitem_partial_slice_non_monotonicityùs4ûøþ þûþ
 
 
zHTestPartialStringSlicing.test_loc_getitem_partial_slice_non_monotonicity) rr€rrirprtrwr‚rƒr„rzr*r*r*r+rhÔs  rhc
@søeZdZdd„Zdd„Zej dej    dddd    e
d
d d d    g¡d d„ƒZ dd„Z dd„Z ej de dd¡deddƒge dd¡e dd¡eddƒgde dd¡eddƒgg¡dd„ƒZej d d!d"g¡d#d$„ƒZej d%dd&g¡d'd(„ƒZd)d*„ZdS)+ÚTestLabelSlicingcCsttjddddd„dDƒd}ttjdddd    d„d
Dƒd}||fD]Æ}|jtd d d d ƒd…}t ||¡|jdtd d dd ƒ…}t ||¡|jtd d d d ƒtd d dd ƒ…}t ||¡|jtd d d dƒd…}|jd d…}t ||¡|jdd…}t ||¡qHdS)Nrr®r¯cSsg|]}tdd|ddƒ‘qS©éÑrMrQr©rr'r*r*r+r¥%    szMTestLabelSlicing.test_loc_getitem_slicing_datetimes_frame.<locals>.<listcomp>)rMr0rRrUrxrcSsg|]}tdd|ddƒ‘qSr|r~r'r*r*r+r¥+    s)rMr0r0rRrUr}rMrQrUr;z 20010101 11)r rhrir#rr$r%r‹)r7Z    df_uniqueZdf_dupsr(rr)r*r*r+Ú(test_loc_getitem_slicing_datetimes_frame    s(  þ  þ   "  z9TestLabelSlicing.test_loc_getitem_slicing_datetimes_framecCsŒtddddd}tdddd    d
g|d }td dd }tddd }|j||…}tdd    g|dd
…d }t ||¡||}d}||ksˆt‚dS)Nz2017-10-29 01:30:00z Europe/BerlinrVz30 min)r³rœr~rrMr0rRrUrxz2017-10-29 02:30:00+02:00rBz2017-10-29 02:00:00+01:00)rrrr#r$r¨r{)r7r—Zseries2Zt_1Zt_2rr)r*r*r+Ú'test_loc_getitem_label_slice_across_dst<    sÿ   z8TestLabelSlicing.test_loc_getitem_label_slice_across_dstrgrjrkrrlrqrrrscCs8| ¡}|jd|d…}|jdd…}t ||¡dS)NrØr×)rnr#r‹r$r¨)r7rgrrr)r*r*r+Ú-test_loc_getitem_label_slice_period_timedeltaM    sz>TestLabelSlicing.test_loc_getitem_label_slice_period_timedeltacCs~dddg}ttj dd¡|d}|jdd…}t|ƒdks>t‚|jdd    …}t|ƒdks\t‚|jdd
…}t|ƒdkszt‚dS) Ngæx"p|é@g\Va³‰|é@g‹ßÖË|é@rRr0rxg3333c|é@g|é@g3333“|é@gÍÌÌÌÜ|é@)r rhr¦rír#rÍr{)r7rgr(Ús1r*r*r+Ú%test_loc_getitem_slice_floats_inexact[    s
z6TestLabelSlicing.test_loc_getitem_slice_floats_inexactcCs®|}ttj d¡tjdd|dd}t|jdd…ƒdks>t‚t|jdd…ƒdksXt‚tjdd|d}d    |d
<||_t|jdd…ƒdkst‚t|jdd…ƒdksªt‚dS) NrQrCr¯rxrr`g)@rTgffffff(@r0)    rrhr¦rírirÍr#r{rg)r7r¤r°rr—r*r*r+Ú'test_loc_getitem_float_slice_floatindexh    s z8TestLabelSlicing.test_loc_getitem_float_slice_floatindexzstart,stop, expected_slicerÚnsNr;rMrìrSrTrUrVcCs>ttdƒtddƒƒ}|jt||ƒ}|j|}t ||¡dS)Nr;rvz10 days)rr§rr#r…r‹r$r¨)r7r›ÚstopZexpected_slicerrr)r*r*r+Ú$test_loc_getitem_slice_label_td64obju    s
 
z5TestLabelSlicing.test_loc_getitem_slice_label_td64objr›Z2018Z2020c    CsP|dddgtdƒtdƒtdƒgd}tjtdd    |j|d
…W5QRXdS) NrMr0rRZ2016Z2019Z2017rxz,Value based partial slicing on non-monotonicršrˆ)rr‚rr5r#)r7rƒr›r9r*r*r+Ú)test_loc_getitem_slice_unordered_dt_index„    sþÿz:TestLabelSlicing.test_loc_getitem_slice_unordered_dt_indexrÝr“cCsN|tdƒ|dddgd}|j|d…}|tdƒ|dddgd}t ||¡dS)NrUr
r0Úthirdrx)r§r#r$rz)r7rƒrÝr9rr)r*r*r+Ú1test_loc_getitem_slice_labels_int_in_object_index    szBTestLabelSlicing.test_loc_getitem_slice_labels_int_in_object_indexcCsZtddddœdgd}tddggdgtddgtdd}t |jdd…dd…f|¡dS)    NrMr0rR)ÚtestrMr0rrxr¯)rmrgrf)r rrÚr$r%r#rjr*r*r+Ú*test_loc_getitem_slice_columns_mixed_dtype—    sÿz;TestLabelSlicing.test_loc_getitem_slice_columns_mixed_dtype)rr€rrr€r‚rƒr„rprmrrrƒr„rhrÎr…r‡rˆrŠrŒr*r*r*r+r{    s0 þþ
  ýþ
 
 
 
r{c@sHeZdZej dddg¡dd„ƒZej dddg¡dd„ƒZdd    „Zd
S) ÚTestLocBooleanLabelsAndSlicesÚ
bool_valueTFc    CsH|›d}|jdkrD||dd}tjt|d|j|W5QRXdS)Nz7: boolean label can not be used without a boolean indexrèrÚrörš)Z inferred_typer‚rr5r#)r7rgrƒrŽÚmessager9r*r*r+Ú'test_loc_bool_incompatible_index_raises¡    s
 
 
 zETestLocBooleanLabelsAndSlices.test_loc_bool_incompatible_index_raisescCs&|tddgdddd}|j|dS)NTFrèr¯rÚrö)rr#)r7rƒrŽr9r*r*r+Útest_loc_bool_should_not_raise¬    s
ÿz<TestLocBooleanLabelsAndSlices.test_loc_bool_should_not_raisec    Cs<d}||dd}tjt|d|jdd…W5QRXdS)NzEslice\(True, False, None\): boolean values can not be used in a slicerÚröršTF)r‚rr†r#)r7rgrƒrr9r*r*r+Útest_loc_bool_slice_raises³    s
ÿ z8TestLocBooleanLabelsAndSlices.test_loc_bool_slice_raisesN)    rr€rr‚rƒr„rr‘r’r*r*r*r+r     s
 
 
 
rc@sdeZdZdd„Zej dddg¡dd„ƒZdd    „Zd
d „Z    e
j d d „ƒZ dd„Z dd„Zdd„ZdS)ÚTestLocBooleanMaskc Csâtdtdƒiƒ}ttdƒdd|_|ddk|ddk|ddkg}ddddddddddg
ddddd    d
d d d dg
ddddd    d
d d d dg
g}t||ƒD]H\}}| ¡}d|j|df<t|ttdƒdddgdd}t ||¡q”dS)Nr¤rQrËr¦rRrrMr0rUrVrSrTr`r:rôr)    r r§rrgrar·r#r$r%)r7r(Z
conditionsÚ expected_dataZcondrmrr)r*r*r+Ú)test_loc_setitem_bool_mask_timedeltaindex¾    s""ýüz<TestLocBooleanMask.test_loc_setitem_bool_mask_timedeltaindexr³Nr@cCs˜t ddddg¡}tdd|d}tdt d¡i|d d¡}| ¡}|j|dd…f|j|dd…f<t     ||¡| ¡}|j||j|<t     ||¡dS)    NTFZ20010101rU©rœr³r rxr®)
rhrŠrr rirÆr·r#r$r%)r7r³rêr—r(rr*r*r+Ú+test_loc_setitem_mask_with_datetimeindex_tzÔ    s  z>TestLocBooleanMask.test_loc_setitem_mask_with_datetimeindex_tzcCs~tt d¡ dd¡tdƒtddddd}| ¡}|jd    gtj    tj    g|d
<|j
d k}|j |j|j |d
f<t   ||¡dS) NrrRr0ZABr|rs)rœr~rerr™rM)r rhrirúr¶rr·rgrprqr"r#r$r%)r7r(r)rêr*r*r+Ú2test_loc_setitem_mask_and_label_with_datetimeindexå    s ý
zETestLocBooleanMask.test_loc_setitem_mask_and_label_with_datetimeindexcCs€tdƒ}tdƒ}tdt||gƒiƒ}| ¡}t|gƒ}|djdj}||jddg<|djdj}||kspt‚t     ||¡dS)Nrl ,GsO1ÚcolrMTF)
rr rr·r‹Ú_valuer#r{r$r%)r7Ztd1Ztd2r(Zdf_copyrr)rr*r*r+Ú'test_loc_setitem_mask_td64_series_valueô    s
 z:TestLocBooleanMask.test_loc_setitem_mask_td64_series_valuecCs\| ¡}|ddk}d|j|df<|j ¡}d||jdf<t||j|jd}t ||¡dS)Nr"rrlrMrÒ)r·r#rrr rgrfr$r%)r7r–r)rêrrr*r*r+Ú#test_loc_setitem_boolean_and_column
s 
z6TestLocBooleanMask.test_loc_setitem_boolean_and_columncCs~tdddgdddgdœƒ}tdd    d
d giddd gd |jdddgdgf<tddd    gdddgdœƒ}t ||¡tdddgdddgdœƒ}td    ddgddd gd |jdddgdgf<t ||¡tdddgdddgdœƒ}td    ddgddd gd |jdddgdf<t ||¡tdddgdddgdœƒ}| ¡}|d}td    ddgddd gd |jdddg<|rnt ||¡n t ||¡dS)NrMr0rRrUrVrSr½r rQrCrXrrxFTr;r<)r r#r$r%rr·)r7r]r(r)r¸rr*r*r+Ú)test_loc_setitem_ndframe_values_alignment
s( ÿ * ( $z<TestLocBooleanMask.test_loc_setitem_ndframe_values_alignmentcCsJtggdœtd}| ¡}|d|jtjgtjddgf<t ||¡dS)Nr½r¯r ©    r rÚr·r#rhrŠZbool_r$r%rjr*r*r+Ú test_loc_indexer_empty_broadcast,
s z3TestLocBooleanMask.test_loc_indexer_empty_broadcastcCsPtdgdgdœtd}| ¡}|d|jtjdgtjddgf<t ||¡dS)Nr¤rÿr½r¯rFr ržrjr*r*r+Ú$test_loc_indexer_all_false_broadcast3
s"z7TestLocBooleanMask.test_loc_indexer_all_false_broadcast)rr€rr•r‚rƒr„r—r˜r›rêÚskip_array_manager_invalid_testrœrrŸr r*r*r*r+r“½    s
 
r“c@s`eZdZej ddd„ejeg¡dd„ƒZ    dd„Z
dd    „Z ej d
d d g¡d d„ƒZ dd„Z dS)ÚTestLocListliker>cCs|Sr[r*rår*r*r+ræ<
rçzTestLocListlike.<lambda>c    Cstddtjgƒ}ttdƒ|d}|j||ƒ}t ||¡|||ƒ}t ||¡| ¡j||ƒ}t     || ¡¡|dd…}|dd…}d}t
j t |d|j||ƒW5QRXt
j t |d|||ƒW5QRXt
j t |d| ¡j||ƒW5QRXdS)    Nr"rlrRrxr×rMrÉrš) r rhr    rr§r#r$r¨rïr%r‚rr5)r7r>ÚcirrZser2Zci2ržr*r*r+Ú8test_loc_getitem_list_of_labels_categoricalindex_with_na<
s"     zHTestLocListlike.test_loc_getitem_list_of_labels_categoricalindex_with_nac    CsZtjddddgdd}tdddd    gtd
d d d ƒ}tjtdd|j|W5QRXdS)Nz
2001-01-04z
2001-01-02z
2001-01-14rr¯r0rVr`r;z
2001-01-01rìrUr rÉrš)rhrŠrrr‚rr5r#)r7rIrr*r*r+Ú1test_loc_getitem_series_label_list_missing_valuesX
s
ÿzATestLocListlike.test_loc_getitem_series_label_list_missing_valuesc    CsRtt ddg¡t ddg¡d}tjtdd|jt ddg¡W5QRXdS)NlPF
AHlUBÿeNlP2ˆ$Þ$én©rgrmrÉršlNZ4FçG)rrhrŠr‚rr5r#r1r*r*r+Ú9test_loc_getitem_series_label_list_missing_integer_valuesa
s   þzITestLocListlike.test_loc_getitem_series_label_list_missing_integer_valuesÚ    to_periodTFc    CsDtddddd}|r| d¡}tddg|dd    }tdƒtdƒg}|rRd
d „|Dƒ}|j|}tddg|dd    }|s€|j d¡|_tj||d d tdƒtdƒtdƒg}|r¸dd „|Dƒ}tdddgt    |d|j
ddd    }|j|}tj||d d tdƒtdƒtdƒg}|rdd „|Dƒ}t j t dd|j|W5QRXdS)Nú
2011-01-01z
2011-01-02rìr—)r~rwgš™™™™™¹?gš™™™™™É?rËr¬cSsg|]}| d¡‘qS©rì©r¨r¢r*r*r+r¥u
szRTestLocListlike.test_loc_getitem_listlike_of_datetimelike_keys.<locals>.<listcomp>T)rYcSsg|]}| d¡‘qSrªr«r¢r*r*r+r¥‚
s)rwr°ú
2011-01-03cSsg|]}| d¡‘qSrªr«r¢r*r*r+r¥
srÉrš)rr¨rrr#rgr‚r$r¨rr°r‚rr5)r7r¨r—rrürr|r*r*r+Ú.test_loc_getitem_listlike_of_datetimelike_keysj
sB
 
ýÿ
ýz>TestLocListlike.test_loc_getitem_listlike_of_datetimelike_keyscCsftddgddgddggddd    gd
d gd }|jdd…}d |j_|jtddgd d}t ||¡dS)NrMr0rUrVrTr`ZcobraZviperZ
sidewinderZ    max_speedZshieldrÒrrv)r r‹rgrwr#rr$r%r©r*r*r+Útest_loc_named_index”
sýz$TestLocListlike.test_loc_named_indexN)rr€rr‚rƒr„rhZasarrayr¶r¤r¥r§r­r®r*r*r*r+r¢;
s
        
)r¢z%columns, column_key, expected_columnsiÛrDiÝrMZAllr0cCsVttj dd¡|tdƒd}|jdd…|f}|jdddg|f}tj||dddS)    NrRràrer"rlr™T)rZ)    r rhr¦rír¶r‹r#r$r%)rfZ
column_keyZexpected_columnsr(r)rr*r*r+Ú*test_loc_getitem_label_list_integer_labels¡
s
r¯cCsœtj dd¡}t|ƒ}tj|jdd…df<t |t tjgd¡ dd¡f¡}t|dddddgd    }t     
||¡t|ƒ}tj|jdd…df<t     
||¡dS)
Nr`rUr£rMrÃrûr´rNru) rhr¦r0r r    r#ZhstackrŠrúr$r%)Z    rand_datarr”r)r*r*r+Útest_loc_setitem_float_intindex²
s$ r°c    Csvdd„dDƒ}tt d¡tdƒt |¡d}|jddd    d
…}tt d ¡tdƒt d    d d d
g¡d}t ||¡dS)NcSsg|]}dD] }||f‘q qS))rTr`r:rQr*)r£Úyrrr*r*r+r¥Â
sz)test_loc_axis_1_slice.<locals>.<listcomp>)éÞr—)rQr`Z
ABCDEFGHIJrÒrMrK)r²r:)r—r`r™)r²rQ)r—rT)    r rhrRrârrÉr#r$r%)rÇr(rr)r*r*r+Útest_loc_axis_1_sliceÀ
sýýr³cCsXtdtdƒt tdƒtdƒg¡d}| ¡}|jddgf|jddgf<t ||¡dS)Nr r0rÒrrN)r r§rrr·r#r$r%)r)rr*r*r+Ú!test_loc_set_dataframe_multiindexÑ
sÿr´cCs4ttdƒtddgtdƒ}|jd}|dks0t‚dS)Nr0rMr´r¯r)rr§rrÚr#r{)rrr*r*r+Útest_loc_mixed_int_floatÛ
s
rµc    CsDttdƒddddgd}tjtddd    |jdd
…<W5QRXdS) NrUr"rlr™rìrxú$Slicing a positional slice with .locršr0rR)rr§r‚rr†r#)rr*r*r+Ú%test_loc_with_positional_slice_raisesã
sr·c
Csætddd}ttj d¡|d}|d}d}||fD]T}tjt|d|jd    d…W5QRXtjtd
dd    |jd    d…<W5QRXq4tjt|d|jd    d…d    fW5QRXtjtd
dd |jd    d…d    f<W5QRXdS) Nz
2016-01-01rR©rœ)rRr0rxrzOcannot do slice indexing on DatetimeIndex with these indexers \[1\] of type intršrMr¶r0)rr rhr¦r‚rr†r#)Údtir(rržr9r*r*r+Ú#test_loc_slice_disallows_positionalë
s ÿ rºc    Cs¤ttj dd¡dddgtddddd    }|jd
d d dg ¡}|j}t     |j
¡}d }t j t |d |j|W5QRXt j t |d |dj|W5QRXdS)NrVrRr rr<Z2012r²r rerr0z/None of \[TimedeltaIndex.* are in the \[index\]rš)r rhr¦r0rr‹r·rgrpZTimedeltaIndexZasi8r‚rr5r#)r(r¹r¨ržr*r*r+Ú'test_loc_datetimelike_mismatched_dtypes s  ý r»cCs¢tjdddd}ttj dd¡|d}t ||j|¡t ||jt    |ƒ¡t ||jt    |ƒ¡t |j
dd    …|j|dd    …¡t ||jt    |ƒ¡dS)
Nz2002-01z2003-12rr}r¶rQrxrrV) rprmr rhr¦r0r$r%r#r¶r‹)r—r(r*r*r+Ú"test_loc_with_period_index_indexer s$r¼cCs~tj dd¡}tddd}ddddd    d
g}t|||d }tj|j|jd d f<tj|d dd…<t|||d }t     ||¡dS)Nr`rSr|r¸r"rlr™rìÚEÚFrÒrMrnrr0)
rhr¦r0rr r    r#rgr$r%)rIr—rÇr|r}r*r*r+Ú%test_loc_setitem_multiindex_timestamp( s r¿c Cs:dddg}ddg}ddg}tj|||gdd    d
gd }td td ƒ|d}|jdd…|d|d|dff}|jdd…dd…f}t ||¡|j|d|d|dfdddgdd}t ||¡|jd}|jdd…}    |j|d|d|dfdddgdd}
t     |
|    ¡|j|d|d|df} | d ks6t
‚dS)Nr rr<rN)rMrrrMr¤rÿrcrrSrVrÒr0)rrL) rrr r§r#r‹r$r%Úxsr¨r{) r(r)Zlev3rÇr(rr)ZaltrZ    expected2Zalt2rr*r*r+Ú'test_loc_getitem_multiindex_tuple_level4 s 
$ ( 
( rÁc    Cs¬tt ddddgddddgddtjtjgg¡jd    d
d gd d }| d ¡}|jjd ksXt‚|j    d}t
ddg|j d dd}t   ||¡|j t¡|_|j    d}t   ||¡dS)NrMr0rRrUrVrSrTr`r rr<rU)rmrfr°r3)r rhrŠr    ÚTrœrgr°r{r#rrfr$r¨rÆrÚ)r(rsr}r)r*r*r+Ú/test_loc_getitem_nullable_index_with_duplicatesR s,ý
 
 
rÃrÝr¼cCsJtddddgdgdd}||jd<tddd    dgdgd
d}t ||¡dS) NrMr0rRrUrcZuint8ro)r0rcr¼Úuint16r=)rÝr(r)r*r*r+Útest_loc_setitem_uint8_upcastf s
rÅzfill_val,exp_dtypez
2022-01-06zdatetime64[ns]z
2022-01-07ú
US/EasternrBzdatetime64[ns, US/Eastern]cCsnddd| ¡g}t||j|d}tddddgd    g|d
}d |jd <| d ¡t||d}tj|j|dddS)Nz
2022-01-02z
2022-01-03z
2022-01-04)r³r°rQr;r<rµr rerx)ú
2022-01-08r rÇr¯T)Úexact)    rr r³r r#rDr$rûrg)Zfill_valZ    exp_dtypermrgr(Zexpected_indexr*r*r+Ú0test_loc_setitem_using_datetimelike_str_as_indexq s
 
 rÉcCsJttdƒgƒ}d|jdd…df<tdgdgdgdgdœƒ}t ||¡dS)NÚabcrVrcr rr<)rrMr0rc)r r¶r#r$r%)r(r)r*r*r+Útest_loc_set_int_dtype„ srËcCs€tddddgddd}tddd    gdd
d gd d dgdddgg|dddgd}|jddgddd}|j|dddfd    ks|t‚dS)Nz 20181101 1100z 20181101 1200z 20181102 1300z 20181102 1400rrl)rwr~r"rûr™r´r8ÚQrNÚWr¾rZONEZTWOZVALUESrÒT)rDr)rr rœr#r{)Zp_indexZ    mi_seriesr*r*r+Útest_loc_periodindex_3_levels s
ý"ýrÎc@seZdZej dddg¡dd„ƒZdd„Zdd    „Zd
d „Z    d d „Z
dd„Z dd„Z dd„Z dd„Zdd„Zej dejejeeg¡ej dddddg¡dd„ƒƒZej d ed!d"d"…fd!ed"ƒfg¡d#d$„ƒZd%d&„Zej d'd(d)g¡d*d+„ƒZejd,d-„ƒZd.d/„Zd0d1„Zd"S)2Ú TestLocSeriesrŸ)r rR)r¡rUcCs$tdddœƒ}|j||ks t‚dS)NrRrU)r r¡)rr#r{)r7rór)rr*r*r+rhž szTestLocSeries.test_loc_uint64c    CsÔ|jdddg}t |j|| |¡¡t |jddd…|ddd…¡|jddg\}}|j||…}| ||¡}t ||¡|| ¡k}t |j|||¡|j|||ksºt‚|j|||ksÐt‚dS)NrRrUrTrVr0é)    rgr$r¨r#r+r‹ÚtruncateÚmedianr{)    r7Ú string_seriesÚdatetime_seriesÚindsÚd1Úd2rr)rêr*r*r+Útest_loc_getitem¤ s"   zTestLocSeries.test_loc_getitemc    Cs‚|jddg\}}|ddd…dddg}d}tjt|d|j||…W5QRXtjt|dd|j||…<W5QRXdS)NrVrÐr0rMrz"Timestamp\('2000-01-10 00:00:00'\)rš)rgr‚rr5r#)r7rÔrÖr×Zts2ržr*r*r+Útest_loc_getitem_not_monotonic· sz,TestLocSeries.test_loc_getitem_not_monotonicc    Cs>ttj d¡ttdddƒƒd}| ¡}d|jdd…<|jdd…dk ¡sPt    ‚| ¡}d|jdd…<|jdd…dkj
 ¡s‚t    ‚|jdd    …}|j dd…}|  dd    d
dg¡}t  ||¡t  ||¡|jttd ƒƒttd dd ƒƒ}tjtdd|j dd…W5QRXtjtddd|j dd…<W5QRXdS)NrQrrCr0rxrUrRr;rSr`rVr:r×z^3$rš)rrhr¦r0r¶r§r·r‹rîr{rrr#r+r$r¨r‚rr5)r7rÚcprrr)Ús2r*r*r+Ú0test_loc_getitem_setitem_integer_slice_keyerrors s"   "z>TestLocSeries.test_loc_getitem_setitem_integer_slice_keyerrorscCs4t|jdd…ƒ}|j|}t ||dd…¡dS)NrQ)rërgr#r$r¨)r7rÓr—rr*r*r+Útest_loc_getitem_iteratorÝ s
z'TestLocSeries.test_loc_getitem_iteratorcCs:|| ¡k}| ¡}d|j|<|}d||<t ||¡dS)Nr)rÒr·r#r$r¨)r7rÓrêrr)r*r*r+Útest_loc_setitem_booleanâ s  
z&TestLocSeries.test_loc_setitem_booleanc    CsPt|jdddgƒ}d|j|<d}tjt|dd|j|dg<W5QRXdS)NrVr`r<z\['foo'\] not in indexršr)r¶rgr#r‚rr5)r7rÓrÕržr*r*r+Útest_loc_setitem_cornerë s
 
z%TestLocSeries.test_loc_setitem_cornercCsˆ|jdddg}| ¡}| ¡}d||<d|j|<t ||¡| ¡}| ¡}d||d|d…<d|j|d|d…<t ||¡dS)NrVrQrÐrr0)rgr·r#r$r¨)r7rÔÚindicesrÚr|r*r*r+Útest_basic_setitem_with_labelsò s
 z,TestLocSeries.test_basic_setitem_with_labelsc        Csttj d¡ttdddƒƒd}dddg}t dddg¡}| ¡}| ¡}d||<d|j|<t     
||¡| ¡}| ¡}d||<d|j|<t     
||¡ddddg}t ddddg¡}d    }t j t |d
d||<W5QRXt j t|d
d||<W5QRXdS) NrQrrCr0rxrUrSrVz\[5\] not in indexrš)rrhr¦r0r¶r§rŠr·r#r$r¨r‚rr5Ú    Exception)    r7rrÕZarr_indsrÚr|Z inds_notfoundZarr_inds_notfoundržr*r*r+Ú!test_loc_setitem_listlike_of_ints s( 
 
 
  z/TestLocSeries.test_loc_setitem_listlike_of_intscCs ttdddddddgd}| ¡}td    dd
}||jd<|jd}||ksPt‚| ¡}||jd <|jd }||ksxt‚| ¡}||d<|d}||ksœt‚dS) Nr©rRrÆr–r rr<rxr¬rBr)rrr·rr#r{r‹)r7rrÛr)rr*r*r+Útest_loc_setitem_dt64tz_values s" þ 
 
 
 
 z,TestLocSeries.test_loc_setitem_dt64tz_valuesÚarray_fnrãrrUrVrScCs~|dg|ƒ}t|ddddgtdƒtd}tdtdƒtd}||jd<t ||¡tdtdƒtd}||jd<t ||¡dS)NrZabcderör )rr¶rÚr#r$r¨r‹)r7rãrårRr)rr*r*r+Ú#test_loc_iloc_setitem_with_listlike1 s
 
z1TestLocSeries.test_loc_iloc_setitem_with_listliker¹r"Nc    Cs~tt dddg¡dddgd}d}tjt|d    |j|dd…fW5QRXtjt|d    d
|j|dd…f<W5QRXdS) N)r"Ú0)r"Ú1)rlrçérr#r¦rõršrM)rrrÉr‚rrr#)r7r¹rržr*r*r+Ú+test_loc_series_getitem_too_many_dimensionsC sþz9TestLocSeries.test_loc_series_getitem_too_many_dimensionscCsÚ|jdddg}| ¡}d|j|<| ¡}d|dddg<t ||¡d|jdd…<d|dd…<t ||¡|jddg\}}d|j||…<d|dd…<t ||¡d|j|<d|j|<||dksÆt‚||dksÖt‚dS)    NrRrUrTrVrQrÐrSr:)rgr·r#r$r¨r‹r{)r7rÓrÕrr)rÖr×r*r*r+Útest_loc_setitemQ s"
 
 
zTestLocSeries.test_loc_setitemr°rÚrýcCs\tddgddgdœ|d}dddœ|jd    dd…f<tddgddgdœ|d}t ||¡dS)
NrÊÚdefZghiZjklrnr¯ZnewAZnewBrr=)r7r°r(r)r*r*r+Útest_loc_assign_dict_to_rowk sz)TestLocSeries.test_loc_assign_dict_to_rowcCsptddgd}tdddddœ|jd    <tdddddœ|jd    <ttddddggddgd    gd
}t ||¡dS) NrrÝrurSrËr¦r)rrÝrMre)r rr#r$r%rr*r*r+Ú,test_loc_setitem_dict_timedelta_multiple_setu sÿz:TestLocSeries.test_loc_setitem_dict_timedelta_multiple_setcCsltddgdgd}ddg|jdddgf<tttjtjgd    d
dtjgdtjgd œddgd }t ||¡dS) NrMr0r rÒrSrTrr<rÚr¯)r rr<rx)r r#rrhr    r$r%rjr*r*r+Ú3test_loc_set_multiple_items_in_multiple_new_columns€ sýú    zATestLocSeries.test_loc_set_multiple_items_in_multiple_new_columnscCs6tjdddd}ttdƒ|d}|jddks2t‚dS)NÚ2000rCrlršrxz
2000-01-14r:)rprmrr§r#r{)r7rgr'r*r*r+Ú test_getitem_loc_str_periodindex sz.TestLocSeries.test_getitem_loc_str_periodindex) rr€rr‚rƒr„rhrØrÙrÜrÝrÞrßrárãrärhrŠrpr¶rârærr…rêrërírêr¡rîrïrñr*r*r*r+rϝ s.
      $
 
    
 
rÏ)SÚ__doc__Ú collectionsrrrrrrßZ dateutil.tzrÚnumpyrhr‚Z pandas.errorsrZpandas.util._test_decoratorsÚutilZ_test_decoratorsrêZpandasrpr    r
r r r rrrrrrrrrrrrrZpandas._testingZ_testingr$Zpandas.api.typesrrZpandas.core.indexingrZpandas.tests.indexing.commonrrƒr„r    r,r-r‡rìr÷r.rXrhr{rr“r¢r¯r°r³r´rµr·rºr»r¼r¿rÁrÃrÄÚint16rÅrÉrËrÎrÏr*r*r*r+Ú<module>sš   P   "þþ
    9s<wCJ~fýþ
    
 
 
 
þþ