IjSSKJr SSKrSSKJrJrJr SSKrSSKr SSK J r SSK J s Jr SSKJrJr SSKJr SSKJr SSKJrJr SS KJrJrJrJr SS KJ r SS K!J"r"J#r# SSK$J%s J&r' SS K$J(r(J)r) SS K*J+r+ SSK,J-r- SSK.J/r/ SSK0J1r1 SSK2J3r3J4r4J5r5 SSK6J7r7 SSK8J9r9 SSK:J;r;Jr>J?r? \(aSSK@JArAJBrBJCrC SSKDJErE SSKFJGrG "SS5rHS'S(SjjrI\S)S*Sjj5rJ\S)S+Sjj5rJS'S+SjjrJS'S,SjjrKS-SjrLS.S/S jjrMS0S1S!jjrNS2S"jrOS.S3S#jjrPS4S$jrQS5S%jrRS6S&jrSg)7) annotationsN) TYPE_CHECKINGcastoverload) get_option)Pandas4WarningPerformanceWarning)cache_readonly)find_stack_level)find_common_type maybe_promote)ensure_platform_intis_1d_only_ea_dtype is_integerneeds_i8_conversion)ExtensionDtype)isnanotna) factorizeunique)NDArrayBackedExtensionArray)factorize_from_iterable)ensure_wrapped_if_datetimelike) DataFrame)Index MultiIndex default_index)concat)Series)compress_group_indexdecons_obs_group_idsget_compressed_idsget_group_indexget_group_index_sorter) ArrayLikeLevelnpt)ExtensionArray) FrozenListc\rSrSrSrSSSjjr\SSj5r\SSj5rSSjr SSjr \SSj5r \SS j5r SS jr SS jrSS jr\SSj5r\SSj5rSrg ) _UnstackerJaX 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 ;UlUR=(a URnU(aSOSUl[URR5Ul [URR5Ul URRUR 5UlURRUR 5UlURUR UlSUlUR(d['URR UR 5nUR(a(US:HnXg)n[(R*"U5SUlUR R-U5UlUR"R-U5Ul[/S5(a[1SUR55nUR R2n X-n U [(R4"[(R65R0:a&[8R:"SU S3[<[?5S9 URA5 g) Nrperformance_warningsc38# UHoRv M g7fN)size).0 index_levels l/root/GenerationalWealth/GenerationalWealth/venv/lib/python3.13/site-packages/pandas/core/reshape/reshape.py &_Unstacker.__init__..sU?T ++?Tz%The following operation may generate z& cells in the resulting pandas object. stacklevel)! constructorsortremove_unused_levelsindex_get_level_numberlevelcodeshas_nanliftlistlevelsnew_index_levelsnamesnew_index_namespop removed_name removed_levelremoved_level_fullunique_nan_indexrnp flatnonzerotakermaxr3iinfoint32warningswarnr r _make_selectors) selfr?rAr<r= should_lift unique_codesnan_masknum_rows num_columns num_cellss r6__init___Unstacker.__init__ys' //1 ZZ11%8 TZZ--djj99 ll0tyy $A! !%TZZ%6%6 7#DJJ$4$45 0044TZZ@!2266tzzB"',,tzz":%'yy'-djj.>.>tzz.J'KL||'2-+I6 (*x(@(C%!%!3!3!8!8!FD &*&=&=&B&B<&PD # , - - Ut?T?TUUH,,11K!.I288BHH-111 ;I;G67&/1  cURn[URR5nUR(dUVs/sHn[ U5SPM nn[URR 5nUSUX!S-S-X!/-n[SUSUXAS-S-XA/-55n[XV5upx[U5n [Xy5n X4$s snf)Nrr/c38# UHn[U5v M g7fr2lenr4xs r6r72_Unstacker._indexer_and_to_sort..sK&Jc!ff&Jr9) rArEr?rBr=rrFtupler"rer$) rXvrBcodelevsto_sortsizes comp_indexobs_idsngroupsindexers r6_indexer_and_to_sort_Unstacker._indexer_and_to_sorts JJTZZ%%&yy49:EDYt_Q'EE:DJJ%%&)eEGn,z9Kd2Ah!eg&>$'&JKK0@ g,(=;sCcURupUR(a!UVs/sHo3RU5PM sn$U$s snfr2)rsr=rQ)rXrrrmlines r6 sorted_labels_Unstacker.sorted_labelss=44 993:;74IIg&7; ; rac>URnURSSn[SU55n[X#5upE[ U5n[ U5nUR RURUR-nXg4Ul URSXt--UR-n[R"[R"UR5[S9n U R!US5 U R#5[ UR 5:a [%S5eX@lXlUR*(a+UR-[R."U55Ulg[R*"[R2"USS9S5Ulg)Nr.c38# UHn[U5v M g7fr2rdrfs r6r7-_Unstacker._make_selectors..s7JqCFFJr9dtypeTz0Index contains duplicate entries, cannot reshape) return_indexr/)rGrwrir"rerr?levshaperArC full_shaperDrOzerosprodboolputsum ValueError group_indexmaskr= searchsortedarange compressorr) rX new_levelsremaining_labels level_sizesrorprqstrideselectorrs r6rW_Unstacker._make_selectorss8**  --cr27J77 01AO g,(4 $$TZZ04<<?!/%%b)F,??$))Kxx0= 4 88:DJJ 'OP P% 99(55bii6HIDO ggbii &Nq&QRDOracH[URR55$r2)rrall)rXs r6mask_all_Unstacker.mask_allsDIIMMO$$rac[R"[UR5[RS9nUR USS9up#X#R S54$)Nrr. fill_valuer)rOrrer?intpget_new_valuesany)rX dummy_arr new_valuesrs r6 arange_result_Unstacker.arange_resultsIIIc$**oRWW= ..yR.H 88A;&&racURnURS:XaUSS2[R4nUcURSS:wa [ S5eUR XC5upVURU5nURnURXXXuRSS9n [U[R5(aURURpOE[U[5(a,URRURRpOSupXLa%U R R#UR 5 U $)Nr/z-must pass column labels for multi-column dataF)r?columnsrcopy)r/)_valuesndimrOnewaxisshaperrget_new_columns new_indexr<r isinstancendarraybaser_ndarray_mgradd_references) rXobj value_columnsrr}rr~rr?resultrnew_bases r6 get_result_Unstacker.get_results  ;;! ArzzM*F  V\\!_%9LM M++F? &&}5!! WJ *1 ! $1%$D!% ~~U2 V*'7'9 "*-- V*'7'9 ,->?I# I>> 12iRW  Ns0F2cJ[UR5[UR5:waPURRUR5nUR(a[ R "USS5nU$[UR5UR-n[ R"U5UR- nUR(aPUR(d?URS:dS5eSXR'XRS-S===S-sss&U$)Nrr.z+`unique_nan_index` not properly initializedr/) rerMrL get_indexerrCrOrrrDr=rN)rXrrs r6r_Unstacker._repeaters t&& '3t/A/A+B B..::4;M;MNH||99Xq"5++,t||;Fyy(4994H||DII,,r1A135../..245:5rac~UR(aURSSnO8URn[URR 5nUSUX2S-S-nUVs/sHoDR UR5PM nn[UR5S:Xa}URSUSpvUS:HR5(a%UR[U5UR5nUR U5RURS5$[URUURSS9$s snf)Nr.r/rFr)r=rwrArEr?rBrQrrerGrrrrrIr)rXlabelsrjrBr result_codesrA level_codess r6r_Unstacker.new_indexs 99'',F A))*E2AY1uw/F=CDVc1V D t$$ % *!%!6!6q!9<?;r!&&(( SZA::k*11$2F2Fq2IJ J((&&"   Es$D:)rr<rrrCr?rArDrrGrIrLrMrKr=rN)T)r?rrAr&r=rreturnNone)rz-tuple[npt.NDArray[np.intp], list[np.ndarray]])rzlist[np.ndarray])r} np.ndarrayrr)rr)rr)rz2tuple[npt.NDArray[np.intp], npt.NDArray[np.bool_]])rrr2)rz Index | None)rr)rMultiIndex | Index)__name__ __module__ __qualname____firstlineno____doc__r_r rsrwrrWrrrrrrr__static_attributes__rar6r+r+Js,^JN77(-7BF7 7r    ,  S8%%''4]$~! F.  rar+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 [USSS9nO[/U QUP/U QUP/U QSPSS 9n[U[ 5(a.UR#SS 9nUUlUR%SX#S 9nUnU nUnGO2[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/UQnUR&R*/U QnTRS/nUR-U4S jU55 [UUUSS 9n[U[ 5(a UUlU$UUlU$s snfs snfs snfs snfs snfs snfs snfs snfs snf)Nrc38# UHn[U5v M g7fr2rdrfs r6r7$_unstack_multiple..s*'Q#a&&'r9F)r=xnullr=)r__placeholder__)rrrdeeprr=r/c3^># UH"oRTRS5v M$ g7f)r.N)rQrB)r4recunstcolss r6r7rs$N#(.."455s*-)rer?rrrHr@rangenlevelsrFrBrir#r r!rrrrrrrJrextend)dataclocsrr=r?irlocsclevelsccodescnamesrlevelsrcodesrnamesrrcomp_idsrp recons_codes dummy_indexdummy unstackedrrrrvalrjdummy_df new_columnsr s @r6_unstack_multipler!s~ 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*;%H  &W&g&%F%H%.F.-."  $ u %! MM"3 MV    dllJ / /Fiil J(;@@%Qa#g1q50%@%M99%9($$$ *%  i ( ( H ((H(J////ooa(373 \\&&00 ^^A&' NNN)eK)V$$%  (  _ 8 ?. , ,. , ,JAs<M 8 MMM/M M+M# M('M-2M2cgr2rrrArr=s r6rr,sPSracgr2rr#s r6rr0srac[U[[45(a[U5S:wa [ XX#S9$USn[ U5(d!US:XdUR RU5 [U[5(aC[UR [5(a [XX#S9$URR5$[UR [5(d"[S[UR 5S35e[UR 5(a [#XX#S9$[%UR XR&US9nUR)USUS 9$) Nr/rrrz'index must be a MultiIndex to unstack, z was passedrrAr<r=rr)rrirErer!rr?r@rr_unstack_frameTstackrtyperr_unstack_extension_seriesr+_constructor_expanddimr)rrArr= unstackers r6rr6s!%%'' u:?%SJR R!HE e  U.?%? ##E*#y!! cii , ,!#O O55;;=  : . .5d399o5Fk R   syy ) ),SO O IIU0J0JQU ##Ct #SSrac<[UR[5(de[URXRUS9nUR (d2UR RXBS9nURXURS9$URXRUS9$)Nr&r)axesr') rr?rr+ _constructor_can_fast_transposerr_constructor_from_mgrr0rr)rrArr=r.mgrs r6r(r(Zs cii , ,, , ,<,<4I  " "hhy@((88(<<## {{z$  racUR5nURXUS9nURRS/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. )rArr=r)to_framerr_drop_level_numbers)seriesrArr=dfrs r6r,r,ksC8  B ZZeZ FF^^77.stack_factorizes7 ??"))CJ// /3E:  ra) level_numdropnar=FrstrictTrr?)rrr@rr_stack_multi_columnsr?rErFrBrrrOrravelrHrzipmapr_is_homogeneous_typedtypesrrr_concat_same_typeitems"_reorder_for_extension_array_stackr_constructor_sliced)framerArAr=r>NKr@rrrclevclabrrrFilabrBrIrarrr~colrrs r6r*r*s! ;;DA //6I%--,,# v   EKK , ,%++,,- .3kk.?.?@.?sZZ].? @$U]]3 $)//12**+ ++,iRW  # ;; "> ? HL  t A 0 6 6 88;;##U]]%7%78"   ;;555ell**+q  e^ , ,,,.C..+0;;=9=C=9J# UHoTRR;v M g7fr2)rrH)r4rrNs r6r7!stack_multiple..s 7#%--%% %s%()rAr=c3B# UHn[U[5v M g7fr2)rint)r4rs r6r7rXs 3UcZS ! !Usrr/zTlevel should contain all level names or all level numbers, not a mixture of the two.)rr*rr@rJr)rNrArAr=rrrjs` r6stack_multipler[s 7 777C6vAF: M/ 3U 3 3 3BGG#005G))A,C6vAF8==u!s(QA-uE=e M  1  H>s %C Cc [UR5S::a)URSRURSS9$S[ URSSUR SSSS95n[ US S06nS [ R"U55n[ US S06n[R"[ X@RSSSS9VVs/sH upVSU;a[XVRS 9OUPM" snnURSSS 9$s snnf) zBCreates a MultiIndex from the first N-1 levels of this MultiIndex.rrrc3h# UH#upUVs/sHo3S:aXOSPM snv M% gs snf7f)rNr)r4rrBcs r6r7,_stack_multi_column_index.. s8 SJC.33U6t #U3S 4s 2-2Nr.T)rBrBc3*# UH upUv M g7fr2r)r4keyr~s r6r7r_sA'@VSS'@srrH) rerFrrHrFrB itertoolsgroupbyr from_arraysrr)rrltuples unique_tuplesnew_levsnew_levrs r6_stack_multi_column_indexrjs 7>>a~~a ((gmmA.>(?? gnnSb17=="3EdS D $ $t $FAy'8'8'@AMM/$/H  ! !!$HnnSb.A$ O !P 047/BE' + O O mmCR   s 'D c b 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-5RQUU5RRRQS5nUR%U5nO UR6nURTS:aURW5nUU 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`. rb)r@rs r6_convert_level_number3_stack_multi_columns.._convert_level_number&s#  %==+ +raFrr/r)rArzr.)rrr)r?rr)rzhow)r@rZrr)8rrrrr r  swaplevel _is_lexsorted sort_indexrrjrFrrBrOr=rrerQget_locKeyErrorrslicestopstartlocreindexr}ilocr rItolistrrrJrKrrrrrr)rrE differencer?rErHrrrrr1r7equalsrA))rNr@rAr=rmthismi_cols roll_columnsrlev1lev2 level_to_sortr new_data level_valsrlevel_vals_nanlevel_vals_usedlevsize drop_colsrarx slice_lenchunk value_slicesubsetrr~rgrOrPidxrrrr old_codes old_levelsrrdesired_columnss) r6rDrD#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%;>rB)..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!5RRS5nUR 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='[+U R>5-SS 9Ul[U5n[U5n[,R@"U5n[,R."UU-U5[,R<"[,R@"U5U5-nURCU5nURDS :XacURR[U5:Xa@[UR5S:Xa[GUR&S 9nOURHSS2S4nURDS:XaSUl%U$s snfs sn f) Nz8Columns with duplicate values are not supported in stackr/r.rF)orderrF)use_na_sentinelrrrC)&rnuniquerersetr7r r rrrHrblocksrrMrr stack_reshaperr?rFrErOrrBrargsort_reorder_ilevelsrdrop_duplicatesrrHrrQrrrzr)rNrA set_levelsk stack_colsrrratio index_levels index_codesrBuniquessorterordered_stack_colsordered_stack_cols_unique column_levels column_codeslen_df n_uniquesrridxss r6stack_v3rs| }}#emm"44STT u:: UJ22%--//!3R<T# UH!nUT;a [T5O [S5v M# g7fr2)nextru)r4rgenrs r6r7 stack_reshape..Ds+#5A*_S %+=5s),Nr) ignore_index)rr)rrrsortedrreriterrir r rxr7rrrrrrrrrr}) rNrArr drop_levnumsbufrrcolumn_indexerrr rrs ` @r6rrs0 emmZ 0 00 0%.L C  " u}}  "::5:)D5zQfs)C"#u}}445#N99Q./D u: -- -<<;;LIDL   1 $yyA~ ,S->?  4+#. 3x!|EKK$/ u: -- ---;;LIPPRK#K;mm6I6IJ 5zEMM)))--;;LIPPR~~$$_55,F Mra)NT)rSeries | DataFramer=r)..)rrr=rrr)rrr=rrr)rrr=rrr)r8rr=rrr)r.TT)rNrrArr=rrr)TT)rNrrArr=r)rrrr) rNrr@rZrArr=rrr)rTr(rrZrrZrr()rNrrA list[int]rr) rNrrArrzset[int]rrrr)T __future__rrctypingrrrrUnumpyrOpandas._config.configrpandas._libs.reshape_libsrr pandas.errorsrr pandas.util._decoratorsr pandas.util._exceptionsr pandas.core.dtypes.castr r pandas.core.dtypes.commonrrrrpandas.core.dtypes.dtypesrpandas.core.dtypes.missingrrpandas.core.algorithmscore algorithmsr{rrpandas.core.arrays._mixinsrpandas.core.arrays.categoricalrpandas.core.constructionrpandas.core.framerpandas.core.indexes.apirrrpandas.core.reshape.concatrpandas.core.seriesrpandas.core.sortingr r!r"r#r$pandas._typingr%r&r'pandas.core.arraysr(pandas.core.indexes.frozenr)r+r!rr(r,r*r[rjrDrLrrrrar6rsM" ,))34 5 '&CBC' .% 25~ ~ D DH^ ^<@^B S S AD :>  CG!T !T;?!T!TJ:>  26  "$ $-1$$PCGNB NB(,NB;?NBNBb"J8NRA A!$A37AFJAAH" "!$"14""JOdF F&F4<FJOFFra