MheJSSKJr SSKrSSKJrJr SSKrSSKrSSK J s J r SSK Jr SSKJr SSKJr SSKJrJr SSKJrJrJrJr SS KJr SS KJr SSKJ s J!r" SS KJ#r#J$r$ SS K%J&r& SS K'J(r( SSK)J*r* SSK+J,r,J-r-J.r. SSK/J0r0 SSK1J2r2 SSK3J4r4J5r5J6r6J7r7J8r8 \(aSSK9J:r:J;r;Jr> SSK?J@r@ "SS5rAS"S#SjjrBS"S$SjjrCS"S%SjjrDS&SjrES'S(SjjrFS)S(SjjrGS*SjrHS'S+SjjrIS,S jrJS-S!jrKg).) annotationsN) TYPE_CHECKINGcast)PerformanceWarning)cache_readonly)find_stack_level)find_common_type maybe_promote)ensure_platform_intis_1d_only_ea_dtype is_integerneeds_i8_conversion)ExtensionDtype)notna) factorizeunique)factorize_from_iterable)ensure_wrapped_if_datetimelike) DataFrame)Index MultiIndex RangeIndex)concat)Series)compress_group_indexdecons_obs_group_idsget_compressed_idsget_group_indexget_group_index_sorter) ArrayLikeLevelnpt)ExtensionArray) FrozenListc\rSrSrSrSSSjjr\SSj5r\SSj5rSSjr Sr \SSj5r \SS j5r SS jr SS jrSS jr\SSj5r\SSj5rSrg ) _Unstacker@aq Helper class to unstack data / pivot with multi-level index Parameters ---------- index : MultiIndex level : int or str, default last level Level to "unstack". Accepts a name for the level. fill_value : scalar, optional Default value to fill in missing values if subgroups do not have the same set of labels. By default, missing values will be replaced with the default fill value for that data type, NaN for float, NaT for datetimelike, etc. For integer types, by default data will converted to float and missing values will be set to NaN. constructor : object Pandas ``DataFrame`` or subclass used to create unstacked response. If None, DataFrame will be used. Examples -------- >>> index = pd.MultiIndex.from_tuples([('one', 'a'), ('one', 'b'), ... ('two', 'a'), ('two', 'b')]) >>> s = pd.Series(np.arange(1, 5, dtype=np.int64), index=index) >>> s one a 1 b 2 two a 3 b 4 dtype: int64 >>> s.unstack(level=-1) a b one 1 2 two 3 4 >>> s.unstack(level=0) one two a 1 3 b 2 4 Returns ------- unstacked : DataFrame cX0lX@lUR5UlURR U5UlSURR UR ;aSOSUl[URR5Ul [URR5Ul URRUR 5UlURRUR 5UlURUR UlUR(dl[#URR UR 5nURR%U5UlUR R%U5Ul[&R("URVs/sHofR*PM sn5nURR*nXx-n U [&R,"[&R.5R(:a&[0R2"SU S3[4[75S9 UR95 gs snf)Nrz%The following operation may generate z& cells in the resulting pandas object.) stacklevel) constructorsortremove_unused_levelsindex_get_level_numberlevelcodesliftlistlevelsnew_index_levelsnamesnew_index_namespop removed_name removed_levelremoved_level_fullrtakenpmaxsizeiinfoint32warningswarnrr_make_selectors) selfr/r1r,r- unique_codes index_levelnum_rows num_columns num_cellss M/var/www/html/env/lib/python3.13/site-packages/pandas/core/reshape/reshape.py__init___Unstacker.__init__ns' //1 ZZ11%8 tzz// ;;A !%TZZ%6%6 7#DJJ$4$45 0044TZZ@!2266tzzB"',,tzz":yy!$**"2"24::">?L!%!3!3!8!8!FD &*&=&=&B&B<&PD # 66t?T?TU?T ++?TUV((-- *  rxx)-- - MM7 {C23"+-   VsI&cNURn[URR5n[URR5nUSUX!S-S-X!/-n[ SUSUX1S-S-X1/-55n[ XE5upg[U5n[Xh5n X4$)Nr*c38# UHn[U5v M g7fNlen.0xs rL 2_Unstacker._indexer_and_to_sort..sK&Jc!ff&J) r1r4r/r2r5tuplerrSr) rFvr2levsto_sortsizes comp_indexobs_idsngroupsindexers rL_indexer_and_to_sort_Unstacker._indexer_and_to_sorts JJTZZ%%&DJJ%%&)eEGn,z9Kd2Ah!eg&>$'&JKK0@ g,(=cURupUR(a!UVs/sHo3RU5PM sn$U$s snfrQ)rcr-r=)rFrbr]lines rL sorted_labels_Unstacker.sorted_labelss=44 993:;74IIg&7; ;URnURSSn[SU55n[X#5upE[ U5n[ U5nUR RURUR-nXg4Ul URSXt--UR-n[R"[R"UR5[S9n U RUS5 U R!5[ UR 5:a [#S5eX@lXlUR((a+UR+[R,"U55Ulg[R("[R0"USS9S5Ulg)Nr)c38# UHn[U5v M g7frQrRrTs rLrW-_Unstacker._make_selectors..s7JqCFFJrYdtypeTz0Index contains duplicate entries, cannot reshape) return_indexr*)r6rhrZrrSr r/levshaper1r3 full_shaper>zerosprodboolputsum ValueError group_indexmaskr- searchsortedarange compressorr) rF new_levelsremaining_labels level_sizesr_r`rastrideselectorrs rLrE_Unstacker._make_selectorss8**  --cr27J77 01AO g,(4 $$TZZ0499<!/%%b)F,??$))Kxx0= 4 88:DJJ 'OP P% 99(55bii6HIDO ggbii &Nq&QRDOrecH[URR55$rQ)r}rall)rFs rLmask_all_Unstacker.mask_allsDIIMMO$$rec[R"[UR5[RS9nUR USS9up#X#R S54$)Nrvr) fill_valuer)r>rrSr/intpget_new_valuesany)rF dummy_arr new_valuesrs rL arange_result_Unstacker.arange_resultsIIIc$**oRWW= ..yR.H 88A;&&rec&URS:XaUSS2[R4nUcURSS:wa [ S5eUR X5upUR U5nURnURXXQRS9$)Nr*z-must pass column labels for multi-column data)r/columnsrw) ndimr>newaxisshaperrget_new_columns new_indexr,rw)rFrn value_columnsrrorr/s rL get_result_Unstacker.get_results ;;! ArzzM*F  V\\!_%9LM M''; &&}5     reNc URS:XaUSS2[R4nURU5nURupEUR SnXV-nXG4nUR n URn U (a][U5(aMURXEU5RSS5RU5n [R"U[S9n X4$URn U (a!URn [R"XS9n Ok[U [ 5(a$U R#5nUR%XS9n X+SS&O2['X5up[R"XS9n U R)U5 U R*n[R,"U[S9n [/UR5(a#UR1S5nU R1S5n OUR3USS9n[4R6"UU R1S5UUUU U R1S55 [/UR5(a7U R1S5n [9U 5n U R1UR5n X4$) Nr*rvi8Fcopyu1zM8[ns])rr>rrqrzrrrrSreshapeswapaxesonesr}rwempty isinstancerconstruct_array_type_emptyr fillnamer{rviewastype libreshapeunstackr)rFrnrrplengthwidthr result_width result_shaperrrnew_maskrwclsrs rLr_Unstacker.get_new_valuess ;;! ArzzM*F008  a~ - yy== F %%fV<!Q&  ww|48H' '  LLE,repeatrrrr5r<r7r2r=r _repeaterappendtile) rFrlevrr propagatorr new_nameslab new_codesrepeaters rLr_Unstacker.get_new_columnsEs  yyA~))11t7H7H1II$$++AD4F4F4P4P+QC::d//0 0T''(4994M"YYryy/8  mZ 0 0&--''1J&++t/@/@.BBI9F9L9LM9L#*-9LIMI''J'++T->->?I# I>> 12iRW  Ns/F1c[UR5[UR5:waPURRUR5nUR(a[ R "USS5nU$[UR5UR-n[ R"U5UR- nU$)Nrr))rSr<r; get_indexerr3r>rr)rFrrs rLr_Unstacker._repeaterks t&& '3t/A/A+B B..::4;M;MNHyy99Xq"5 ++,tyy8Fyy(4994HrecURSSVs/sHoRUR5PM nn[UR5S:Xa}URSUSpCUS:HR 5(a%UR [U5UR5nURU5RURS5$[URUURSS9$s snf)Nr)r*rFr) rhr=rrSr6rrrrr8r)rFr result_codesr1 level_codess rLr_Unstacker.new_indexzs>B=O=OPSQS=TU=Tc1=T U t$$ % *!%!6!6q!9<?;r!&&(( SZA::k*11$2F2Fq2IJ J((&&"   Vs$C.)rr,rzrr/r1r3rr6r8r;r<r:r-)T)r/rr1r!r-r}returnNone)rz-tuple[npt.NDArray[np.intp], list[np.ndarray]])rzlist[np.ndarray])rn np.ndarrayrr)rr})rz2tuple[npt.NDArray[np.intp], npt.NDArray[np.bool_]])rrrQ)rz Index | None)rr)rr)__name__ __module__ __qualname____firstlineno____doc__rMrrcrhrqrErrrrrrr__static_attributes__rerLr&r&@s+\JN,,(-,BF, ,\    & S8%%''  M$^$ L    rer&c^[U5S:XaU$URn[[U5nXR;aU/nUVs/sHoTR U5PM nn[ UR5Vs/sH oUU;dM UPM nnUVs/sHoTRUPM nnUVs/sHoTRUPM nnUVs/sHoTRUPM n nUVs/sHoTRUPM n nUVs/sHoTRUPM n nUVs/sHoTRUPM n n[SU55n [XSSS9n[USS9unn[UUXSS9nU(d [USS9nO[U U/-X/-U S/-SS 9n[U[ 5(a/UR#5nUUlUR%SX#S 9nUnU nUnGO4[UR&[5(aRUnU(aGUR)S5nUR%UX#S 9nUVs/sHnUU:aUOUS - PM nnU(aMGU$UR#SS 9nUUlUR%SX#S 9n[U[ 5(a URmO UR&m[T[5(deTRS/U-nUR&R*/U -nTRS/nUR-U4S jU55 [UUUSS 9n[U[ 5(a UUlU$UUlU$s snfs snfs snfs snfs snfs snfs snfs snfs snf)Nrc38# UHn[U5v M g7frQrRrTs rLrW$_unstack_multiple..s*'Q#a&&'rYF)r-xnullr-)r__placeholder__rrrr-r*deepc3^># UH"oRTRS5v M$ g7f)r)N)r=r2)rUrecunstcolss rLrWrs$N#(.."455s*-)rSr/rrr7r0rangenlevelsr5r2rZrrrrrrrrrr9rextend)dataclocsrr-r/irlocsclevelsccodescnamesrlevelsrcodesrnamesrrcomp_idsr` recons_codes dummy_indexdummy unstackedrrrresultvalr[dummy_df new_columnsrs @rL_unstack_multiplers` 5zQ  JJE U #E 16 7A $ $Q 'E 7emm, ?,1Q,E ?(-.1||AG.&+ ,ekk!neF ,&+ ,ekk!neF ,(-.1||AG.&+ ,ekk!neF ,&+ ,ekk!neF , *'* *E!&e5IK,[uEHg''5PUVL G*;<  gY&:%-.."  $ ! MM"3 MV    dllJ / /Fiil N:?@%Qa#g1q50%@% M99%9($$$ *%  i ( ( H ((H(J////ooa()G3 \\&&'&0 ^^A&' NNN)eK)V$$%  (  S 8 ?. , ,. , ,BAs<M 8 MMM/M M+M$ M)'M.1M3c[U[[45(a[U5S:wa [ XX#S9$USn[ U5(d!US:XdUR RU5 [U[5(aB[UR [5(a [XX#S9$URRSS9$[UR [5(d"[S[UR 5S35e[UR 5(a [#XX#S 9$[%UR XR&US 9nUR)UR*SUS 9$) Nr*rrrT) future_stackz'index must be a MultiIndex to unstack, z was passedrr1r,r-rr)rrZr4rSrr r/r0rr_unstack_frameTstackrtyper rw_unstack_extension_seriesr&_constructor_expanddimr_values)objr1rr- unstackers rLrrs/%%'' u:?%SJR R!HE e  U.?%? ##E*#y!! cii , ,!#O O55;;D;1 1  : . .5d399o5Fk R   syy ) ),SO O IIU0J0JQU ## KKt $  recR[UR[5(de[URXRUS9nUR (d2UR RXBS9nURXURS9$URURURUS9$)Nrr)axesr ) rr/rr& _constructor_can_fast_transpose_mgrr_constructor_from_mgrrrrr)rr1rr-rmgrs rLr r  s cii , ,, , ,<,<4I  " "hhy@((88(<<## KKs{{z$  recUR5nURXUS9nURRS/5UlU$)a Unstack an ExtensionArray-backed Series. The ExtensionDtype is preserved. Parameters ---------- series : Series A Series with an ExtensionArray for values level : Any The level name or number. fill_value : Any The user-level (not physical storage) fill value to use for missing values introduced by the reshape. Passed to ``series.values.take``. sort : bool Whether to sort the resulting MuliIndex levels Returns ------- DataFrame Each column of the DataFrame will have the same dtype as the input Series. )r1rr-r)to_framerr_drop_level_numbers)seriesr1rr-dfrs rLrrsA8  B ZZeZ FF^^77rrSr)r/r2 categoriess rLstack_factorizestack..stack_factorizeMs7 ??"))CJ// /3E:  re) level_numdropnar-Frrr/)rrr0rr_stack_multi_columnsr/r4r5r2rrr>rravelr7rzipmapr_is_homogeneous_typedtypesrrr_concat_same_typeitems"_reorder_for_extension_array_stackr_constructor_sliced)framer1r&r-r#NKr%rrrclevclabrrr5ilabr2r-rwarrrocolrrs rLr r Cs! ;;DA //6I%--,,# v   EKK , ,%++,,- .3kk.?.?@.?sZZ].? @$U]]3 $)//12**+ ++,iRW  #C++u}}9U$VW t A 0 6 6 88;;##U]]%7%78"   ;;555ell**+q  e^ , ,,,.C..+0;;=9=C=9J:s ,L L% c^[U4SjU55(aTnUH n[XEX#S9nM U$[SU55(avTnUVs/sHnTRRU5PM nnU(a@UR S5n[XEX#S9nUVs/sHofU::aUOUS- PM nnU(aM@U$[ S5es snfs snf)Nc3T># UHoTRR;v M g7frQ)rr7)rUrr2s rLrW!stack_multiple..s 7#%--%% %s%()r&r-c3B# UHn[U[5v M g7frQ)rint)rUrs rLrWr<s 3UcZS ! !Usrr*zTlevel should contain all level names or all level numbers, not a mixture of the two.)rr rr0r9r)r2r1r&r-rrr[s` rLstack_multipler?s 7 777C6vAF2 M+ 3U 3 3 3BGG#005G))A,C6vAF8==u!s(QA-uE= e M  1  H>s %C Cc v[UR5S::a)URSRURSS9$[ URSSUR SS5VVVs/sH!upUVs/sHo3S:aXOSPM snPM# nnnn[ U6nS[ R"U55n[ U6n[R"[ XpR5VVs/sH upSU;a[XRS9OUPM" snnURSSS9$s snfs snnnfs snnf) zBCreates a MultiIndex from the first N-1 levels of this MultiIndex.rrrNr)c3*# UH upUv M g7frQr)rUkeyros rLrW,_stack_multi_column_index..sA'@VSS'@srvr7) rSr5rr7r*r2 itertoolsgroupbyr from_arraysrrw) rrr2cr\tuples unique_tuplesnew_levsnew_levs rL_stack_multi_column_indexrMs1 7>>a~~a ((gmmA.>(??gnnSb17=="3EF FJC.33U6t #U3F   $ZFAy'8'8'@AMM"H  ! !!$Hnn = !> 047/BE' + O = mmCR   4  s- D.9D)D..'D5 )D.c ` SSjnURSS9nURn[U[5(deXRS- :waOUn[ XRS- 5H(nU"X5n U"US-U5n UR X5nM* U=UlnUR5(d,U(a%U"SU5n URU SS9nURn[[U5n[U5n 0n URSn[URS5nU(a[R"U5nUR![#U5S5n[R$"UU5n[#U5n/nU GHnURR'U5n[U[,5(d [#U5nOUR.UR0- nUU:wahUR2SS2URU4nUR%URRS5UlUR5US9R6nGOUR8SS2U4n[;UR<R?55n[U[@5(aURC5REURG5VVs/sH unnURHRKUSS 9PM" snn5nURLunn[RN"UU-5RQUU5RRRU5nUR%U5nO UR6nURVS:aURU5nUU U'GM [#U5S:aU RYU5n [#U5n[URZ[5(at[]URZR5n []URZR^5n!URZRV"s/sHn"U"RaU5PM n#n"OD[cURZ5un$n%U%/n U$RaU5/n#URZRd/n!U R+U5 U#R+[Rf"UU55 U!R+URR^U5 [U U#U!SS 9n&URiU U&U S 9n'URRS:aOURRkU/5R5n(U'RRmU(5(dU'U(n'U(aU'RoSS S 9n'U'$![(a UR+U5 GM%f=fs snnfs sn"f)NcBXR;aURU$U$)z Logic for converting the level number to something we can safely pass to swaplevel. If `level_num` matches a column name return the name from position `level_num`, otherwise return `level_num`. rD)r%rs rL_convert_level_number3_stack_multi_columns.._convert_level_numbers#  %==+ +reFrr*r)r1rkr))rrr)r/rr)rkhow)r%r>rr)8rrrrrr swaplevel _is_lexsorted sort_indexrrMr5rr2r>r-rrSr=get_locKeyErrorrslicestopstartlocreindexrnilocr r-tolistrrr.r/rrrrrr r)r differencer/r4r7rrrrrrequalsr&))r2r%r&r-rPthismi_cols roll_columnsrlev1lev2 level_to_sortrnew_data level_valsrlevel_vals_nanlevel_vals_usedlevsize drop_colsrBr[ slice_lenchunk value_slicesubsetrwrorVr3r4idxrrrr old_codes old_levelsrrdesired_columnss) rLr(r(s  ::5: !DllG gz * ** *OOa'' y//A"56A(9D(Q =D'11$=L 7 ".- w  " "t.a9 ];,,:w'G+G4KH#Jr*+K ggk* &&s:=Nggnk:O+GI ,,&&s+C#u%%CI399,I  HHQ S 112E*// 0C0CB0GHEM---@GGKYYq#v&F$V]]%9%9%;)..s3 $mm   a %++-K# OR 9~!,,Y7  D A$**j))$**++, ))* 48JJ4D4DE4DSSZZ(4D E 7 C : \ %%g./ ZZ__% j! RWW[!,- U]]((34)eI   ;  OF }}q --;;YKHOOQ~~$$_55O,FA51 MS    S !  0U,FsV;'V% "V+V"!V"c[R"X-5RX!5RR 5nUR U5$)a Re-orders the values when stacking multiple extension-arrays. The indirect stacking method used for EAs requires a followup take to get the order correct. Parameters ---------- arr : ExtensionArray n_rows, n_columns : int The number of rows and columns in the original DataFrame. Returns ------- taken : ExtensionArray The original `arr` with elements re-ordered appropriately Examples -------- >>> arr = np.array(['a', 'b', 'c', 'd', 'e', 'f']) >>> _reorder_for_extension_array_stack(arr, 2, 3) array(['a', 'c', 'e', 'b', 'd', 'f'], dtype='>> _reorder_for_extension_array_stack(arr, 3, 2) array(['a', 'd', 'b', 'e', 'c', 'f'], dtype='rrr r)r=)r8n_rows n_columnsrqs rLr0r0Ps>B ))F& ' / / B D D J J LC 88C=rec  ^^URR5[UR5:wa [S5e[ TSS9nURR [ URR5Vs/sH o3T;dM UPM snSSS25n[T5S:a([R"T5nURU5nOUnUR5nUR5n/n UGH1n [UR5S:XaUR5n Oc[T5S:XaU 4n [U 5m[UU4Sj[ URR555n URSS2U 4n [T5URR:a!U RR U5U lOKURS:Xa;U R S:XaSU lO#[%[U R55U lU R'U 5 GM4 [U 5S:a4UR((d#[+U 5n [U 5[U5-nOo[T5URR:a*URR U5R5nOS/n[-XR.R0S9n Sn[T5URR:aNURR U5R5nU RR3U5(dU Un [5UR6[85(aMUR6R:n[=[R>"UR6R@SU455nO<[CUR6S S 9unnU/n[=[R>"USU455n[5U[85(a'UR:nURE5R@nOUR5/n[CUS S 9S/nUVs/sH#n[RF"U[U55PM% nn[9UU-UU-UR6RH[=URH5-S S 9U l[U5n[U5n[RJ"U5n[R>"UU-U5[RF"[RJ"U5U5-nU RMU5n U R S :XacURR[T5:Xa@[U R5S:Xa[OU R6S 9n OU RPSS2S4n U R S:XaSU lU $s snfs snf)Nz8Columns with duplicate values are not supported in stackT)reverser)r*c3\># UH!nUT;a [T5O [S5v M# g7frQ)nextrX)rUkgenr1s rLrWstack_v3..s+#5A%ZS U4[85s),r)rrwF)use_na_sentinelrrr'))rnuniquerSrsortedrrrr>argsort_reorder_ilevelsrriterrZr[rrrrrrrrrwr`rr/rr5r4rr2rdrop_duplicatesrr7rr=rr])r2r1 drop_levnumsr| stack_colssorterordered_stack_colsstack_cols_uniqueordered_stack_cols_uniquebufrqrcolumn_indexerrratiorrt index_levels index_codesr2uniques column_levels column_codeslen_df n_uniquesrbidxsr}s ` @rLstack_v3rus }}#emm"44STT%.L22%--//0C0qUN0CDbDIJ 5zA~E"'88@'"))+ 2 9 9 ; C  u}}  "::JKlUBIIeSZ0lLKm+L(kk$'9'?'?"@@ FLZF-.Iii "G 776G#V ,ryy69JI/V VD [[ F{{aEMM11SZ? v~~ ! #&,,/F[[A&F {{a MC DRLs? W W*W)NT)rSeries | DataFramer-r})rrr-r})rrr-r}rr)rrr-r}rr)r)TT)r2rr&r}r-r})TT)rrrr) r2rr%r>r&r}r-r}rr)r8r#rvr>rwr>rr#)r2rr1z list[int]rr)L __future__rrEtypingrrrCnumpyr>pandas._libs.reshape_libsrr pandas.errorsrpandas.util._decoratorsrpandas.util._exceptionsrpandas.core.dtypes.castr r pandas.core.dtypes.commonr r r rpandas.core.dtypes.dtypesrpandas.core.dtypes.missingrpandas.core.algorithmscore algorithmsrlrrpandas.core.arrays.categoricalrpandas.core.constructionrpandas.core.framerpandas.core.indexes.apirrrpandas.core.reshape.concatrpandas.core.seriesrpandas.core.sortingrrrrrpandas._typingr r!r"pandas.core.arraysr#pandas.core.indexes.frozenr$r&rrr rr r?rMr(r0rrrerLrsu")),24 5,&&CC' .% 25K K ^ DHX X<@Xv! J:>  26  "" "-1""JJBZB8NRA A!$A37AFJAAH" "!$"14""Jhre