!h@ddlmZddlmZddlZddlZddlmZmZm Z m Z m Z m Z ddl Z ddlZddlZddlmZmZmZddlmZmZmZddlmZmZddlmZdd lm Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+dd l,m-Z-dd l.m/Z/dd l0m1Z1dd l2m3Z3ddl4m5Z5m6Z6ddl7m8Z8m9Z9m:Z:m;Z;mm?Z?m@Z@mAZAmBZBmCZCmDZDddlEmFZFmGZGmHZHmIZImJZJddlKmLZLmMZMmNZNmOZOddlPmQZQmRZRmSZSddlTmUZUddlVmWcmXZYddlZm[Z[m\Z\m]Z]m^Z^m_Z_ddl`maZaddlbmcZcmdZdmeZeddlfmgZgddlhmiZimjZjmkZkmlZlmmZmmnZnmoZoddlpmqZqddlrmWcmsZtddlumvZvddlwmxZxmyZyddlzm{Z{ddl|m}Z}erddl~mZmZdd lmZdd!lmZejd"Zd#Zd$ZdUd(ZGd)d*eqejZGd+d,eZGd-d.eZGd/d0eZGd1d2eZGd3d4eZGd5d6eZGd7d8eZGd9d:eZdVd=ZdWdAZ dXdYdFZddGdZdJZd[dLZd\dOZdXd]dQZd^d_dSZdVdTZdS)`) annotations)wrapsN) TYPE_CHECKINGAnyCallableLiteralcastfinal) get_optionusing_copy_on_writewarn_copy_on_write)NaT internalslib)BlockPlacementBlockValuesRefs)NA) ArrayLikeAxisInt DtypeBackendDtypeObjF FillnaOptions IgnoreRaiseInterpolateOptionsQuantileInterpolationSelfShapenptAbstractMethodError)cache_readonly)find_stack_level)validate_bool_kwarg)astype_array_safeastype_is_view)LossySetitemErrorcan_hold_elementconvert_dtypesfind_result_typemaybe_downcast_to_dtypenp_can_hold_element)is_1d_only_ea_dtypeis_float_dtypeis_integer_dtype is_list_like is_scalaris_string_dtype)DatetimeTZDtypeExtensionDtype IntervalDtype NumpyEADtype PeriodDtype) ABCDataFrameABCIndexABCNumpyExtensionArray ABCSeries)is_valid_na_for_dtypeisnana_value_for_dtype)missing)extract_bool_arrayputmask_inplaceputmask_without_repeatsetitem_datetimelike_compatvalidate_putmask)quantile_compat)compare_or_regex_search replace_regexshould_use_regex)shift) Categorical DatetimeArrayExtensionArray IntervalArrayNumpyExtensionArray PeriodArrayTimedeltaArray) PandasObject) expressions)ensure_wrapped_if_datetimelike extract_array)check_setitem_lengths)get_values_for_csv)IterableSequence)Index)NDArrayBackedExtensionArrayobjectaOSetting a value on a view: behaviour will change in pandas 3.0. You are mutating a Series or DataFrame object, and currently this mutation will also have effect on other Series or DataFrame objects that share data with this object. In pandas 3.0 (with Copy-on-Write), updating one Series or DataFrame object will never modify another. a Setting a value on a view: behaviour will change in pandas 3.0. Currently, the mutation will also have effect on the object that shares data with this object. For example, when setting a value in a Series that was extracted from a column of a DataFrame, that DataFrame will also be updated: ser = df["col"] ser[0] = 0 <--- in pandas 2, this also updates `df` In pandas 3.0 (with Copy-on-Write), updating one Series/DataFrame will never modify another, and thus in the example above, `df` will not be changed. methrreturncdtdfd }tt|S)zp If we have a multi-column block, split and operate block-wise. Otherwise use the original method. r] list[Block]cv|jdks|jddkr |g|Ri|S|jg|Ri|S)Nr)ndimshapesplit_and_operate)selfargskwargsr\s Vc:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\pandas/core/internals/blocks.pynewfunczmaybe_split..newfuncsc 9>>TZ]a//4.t...v.. .*4)$@@@@@@ @r]r_)rr r)r\ris` rh maybe_splitrlsK  4[[AAAAA[A 7  rjc eZdZUdZded<ded<ded<ded <d Zd ZeeddZ eeddZ eeddZ eeddZ eedZ eeddZeeddZedZeedZedZeddZejddZe ddd!Ze ddd#Zedd%Zedd&Zedd)Zedd,Ze ddd/Zedd2Zedd5Zedd7Zedd8Z edd:Z!edd;Z"edd<Z#eddd>Z$eddBZ%ee&dddCZ'edDd dEddGZ( dddPZ)eeddRZ*e dddXZ+edYddZdd\Z,eddd^Z-edd`Z.eddaZ/e ddddZ0e dddeZ1e dddkZ2e dddmZ3ddpZ4dqZ5eddsZ6ddvZ7ddxZ8dddyZ9ede:j;fdd}Z dddZ? dddZ@ dddZAdd dddd ddddZBed ddddd ddddZCeddZDdddZEe dddZFedddZGddZHeddZIeddZJdddZKdS)Blockz Canonical n-dimensional unit of homogeneous dtype contained in a pandas data structure Index-ignorant; let the container take care of that znp.ndarray | ExtensionArrayvaluesintrbrrefsr__init__Fr]boolcf|j}t|t pt|tS)z We validate dimension for blocks that can hold 2D values, which for now means numpy dtypes or DatetimeTZDtype. )dtype isinstancer4r3rervs rh_validate_ndimzBlock._validate_ndims6 e^444 ?9 9  rjc,|jjtkSN)rorv _dtype_objres rh is_objectzBlock.is_objects{ J..rjc@tj|jj Sr{)r is_np_dtyperorvr}s rh is_extensionzBlock.is_extensions?4;#45555rjc|j Sr{)rr}s rh_can_consolidatezBlock._can_consolidates$$$rjc(|j|jjfSr{)rrvnamer}s rh_consolidate_keyzBlock._consolidate_keys$djo55rjcd|j}t|tjr |jdvS|jS)z7 Can we store NA values in this Block? iub)rvrwnpkind _can_hold_narxs rhrzBlock._can_hold_nas5   eRX & & +:U* *!!rjcP|jjtjtkS)z^ We can be bool if a) we are bool dtype or b) object dtype with bool objects. )rorvrrtr}s rhis_boolz Block.is_bools { BHTNN22rjc*t|jSr{)external_valuesror}s rhrzBlock.external_valuesst{+++rjc.t|jdS)NF)compat)r>rvr}s rh fill_valuezBlock.fill_values"$*U;;;;rjc^|jtkrt||jr|j}|Sr{)rvr|r<rrevalues rh_standardize_fill_valuezBlock._standardize_fill_values/ : # #(=eTZ(P(P #OE rjrc|jSr{ _mgr_locsr}s rhmgr_locszBlock.mgr_locs s ~rj new_mgr_locsNonec||_dSr{r)rers rhrzBlock.mgr_locss %rjN placementBlockPlacement | NoneBlockValuesRefs | Nonec~||j}|jrt||j}t |||j|S)zm Create a new block, with type inference propagate any values that are not specified Nrbrrbrq)rrensure_block_shaperb new_blockrerorrqs rh make_blockzBlock.make_blocksJ  I   @'TY???F9494PPPPrjrcV||j}t||||j|S)z2Wrap given values in a block of same type as self.Nr)rtyperbrs rhmake_block_same_classzBlock.make_block_same_class$s4  ItDzz&IDIDQQQQrjstrct|j}|jdkr|dt|d|j}n@dd|jD}|d|jjd|d|j}|S)Nraz: z dtype: z x c,g|]}t|Srs)r).0ss rh z"Block.__repr__..;s;;;1A;;;rjz, z , dtype: ) r__name__rblenrvjoinrcrindexer)rerresultrcs rh__repr__zBlock.__repr__4sDzz" 9>>??D ??4:??FFJJ;; ;;;< dk,,V,,$V,,$$V,,,rjc|jdksJ||j}|jjdkr|}n|dd}||}|gS)Nra)rbroreshaper)rerr res_valuesnbs rhreducez Block.reducesfyA~~~~dk"" ; q JJA..J __Z ( (t rjrc|jdkrt|jtrg}t |jD]j\}}t |js|||dz}n||}t|}|||}| |k|S||}|gS)Nra)ror) rbrwrvr4 enumeraterr-rrappend) rernbsilocvalsbpblockrs rhrzBlock._split_op_results ;??z&,GG?C#DN33 " "3*6<88%!!a!e),DD!!9D#C((trBB 5!!!!J __V $ $t rjc|jdksJg}t|jD]h\}}|jt ||dz}t |}t |||d|j}||i|S)zD Split a block into a list of single-column blocks. rrar) rbrrrorrrrqr)re new_blocksrref_locrrrs rh_splitz Block._splits yA~~~~ #DN33 " "JAw;uQA/D((BdDBQTYGGGB   b ! ! ! !rjc|jdkr|jddksJg}|D]#}||g|Ri|}||$|S)z Split the block and apply func column-by-column. Parameters ---------- func : Block method *args **kwargs Returns ------- List[Block] rrra)rbrcrextend)rerrfrg res_blocksrrbss rhrdzBlock.split_and_operates}yA~~$*Q-1"4"4"44 ++-- # #B$r+D+++F++C   c " " " "rjwarn_on_upcastc8t|jj|}||jkrtdt |rnt |jjrUt |rF|tur=t|tj tj frtj |sd}nht|tj rN|jdkrCt |jjr*t|jrt!j|rd}|r9t%jd|d|jjdt(t+|jj|kr td|d |jjd ||d S) z coerce the current block to a dtype compat for other we will return a block, possibly object, and not raise we can also safely try to coerce to the same dtype and will receive the same block z\Something has gone wrong, please report a bug at https://github.com/pandas-dev/pandas/issuesFrazrSetting an item of incompatible dtype is deprecated and will raise an error in a future version of pandas. Value 'z' has dtype incompatible with z5, please explicitly cast to a compatible dtype first. stacklevelzDid not expect new dtype z to equal self.dtype zE. Please report a bug at https://github.com/pandas-dev/pandas/issues.copy)r*rorvAssertionErrorr1r/r=rrwr datetime64 timedelta64isnatndarrayrbr.rhas_only_ints_or_nanwarningswarn FutureWarningr#astype)reotherr new_dtypes rhcoerce_to_target_dtypezBlock.coerce_to_target_dtypes%T[%6>>  " " >  e   # !233 #U  #S  52="."ABB!GIxPU! #NN ubj ) ) # a !233 u{++ (// #N   MFFF?C{?PFFF+--      ;  ) ) ?I??;$???  {{95{111rjblocks using_cowcallercdur|S|jtkr|dkrtdr|Stfd|D}|dkrot |t |ks't dt ||Ds(tjdtt|S|S|dkrtdd ur|Stfd |D}|dkrot |t |ks'td t ||Dr(tjd tt|S) NFfillnafuture.no_silent_downcastingc@g|]}| S))rr)convert)rblkrs rhrz)Block._maybe_downcast..+s+XXX#y9}EEXXXrjc3<K|]\}}|j|jkVdSr{r)rxys rh z(Block._maybe_downcast...s@66+/1aAGqw&666666rjzDowncasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`rwhereTc<g|]}|Srs) _downcast_2d)rbdowncastrs rhrz)Block._maybe_downcast..Ds' U U U)!D!D U U Urjc3<K|]\}}|j|jkVdSr{r)rleftrights rhrz(Block._maybe_downcast..Ms@...9dE ek)......rja|Downcasting behavior in Series and DataFrame methods 'where', 'mask', and 'clip' is deprecated. In a future version this will not infer object dtypes or cast all-round floats to integers. Instead call result.infer_objects(copy=False) for object inference, or cast round floats explicitly. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`) rvr|r extend_blocksrallziprrrr#any)rerrrrrs `` rh_maybe_downcastzBlock._maybe_downcasts u  M : # #!!j1O&P&P! XXXXQWXXXC!!s88s6{{**#6636sF3C3C66633*MP #5#5    J  M w  :.L#M#MQU#U#UM U U U U Uf U U UVVC W  6{{c#hh&&#..=@=M=M...++&  L"/11     rjct|j|}t|}||jur|jnd}|||gS)zs downcast specialized to 2D case post-validation. Refactored to allow use of maybe_split. rNr)r+rorrqr)rervrrrqs rhrzBlock._downcast_2dasU-T[FFF (44 &$+55tyy4 6677rjTrrrc|js5|s|r|dgS|r|gn|gS|jdkr|jddkrp|t j||}td|Dr3|r|dgS|r|gn|gS|S|j}|jdkr|d}tj |d }d }|r||ur|}n ||ur|j }t||j}t|}||| gS) zz Attempt to coerce any object types to better types. Return a copy of the block (if copy = True). Fdeeprarrc36K|]}|jjdkVdS)ONrvr)rr s rhrz Block.convert..s+;;S39>S(;;;;;;rjrT)convert_non_numericNr)r~rrbrcrdrnr rrormaybe_convert_objectsrqrrr)rerrrrorrqs rhr z Block.convertns~ 5 /I / u --..$(4DIIKK==tf 4 9>>djmq00++ DI,F;;F;;;;; 93 II5I1122(,8 }}4&8M ;!  AYF.  $     J&((JJ 6 ! !9D' DI>> (44  6677rjnumpy_nullable infer_objectsconvert_stringconvert_integerconvert_booleanconvert_floating dtype_backendrc Xrjrd|} ng} tgsfd| DSg} | D]} | jdksjddkr| gn| } fd| D} t fd| Dr*| | t| | D]9\}}| | ||jdk :| S) NFrc<g|]}|S)rr)rrrs rhrz(Block.convert_dtypes..s'444!AFFF%%444rjrarc Dg|]}t|jSrs)r)ro)rrr*r+r)r(r,r's rhrz(Block.convert_dtypes..sL   H"##$!!   rjc3.K|]}|jkVdSr{r)rrvres rhrz'Block.convert_dtypes..s*;;55DJ&;;;;;;rjr)rvrsqueeze) r~r rrbrcrrrrrr)rerrr'r(r)r*r+r,blksrr sub_blksdtypesrvrs`` `````` rhr)zBlock.convert_dtypess  T^ < float_format date_formatdecimal)rVror)rer@rArBr=r>rs rhrVzBlock.get_values_for_csvs@ $ K%#    v&&&rjr c|j}|r|}d}n|j}t|||j|j|S)zcopy constructorNr)rorrqrrrb)rer rorqs rhrz Block.copysR  [[]]FDD9DtDzz&DNQUVVVVrjinplacec|r2|r0|j}||}n|r|n|}|S)Nr)rqrr)rerrDr r s rh _maybe_copyzBlock._maybe_copy%sT  3 39**,,D)))&&CC!2$$tyy{{C rjcbd}| }|r%|r|jrd}n|j}||fS)NT)rqr)rerrDrqrs rh_get_refs_and_copyzBlock._get_refs_and_copy.sK{  ! !TY4466 !yTzrjmasknpt.NDArray[np.bool_] | Nonec j|j}t|trK|||}t t|j}|||d|gS||s3|r|dgS|r|gn|gS|tj ||}| s3|r|dgS|r|gn|gS||r|||}t|j|||rdtrV|T|j sM|jr4t!jt$t&t)d|_ |jr|~t-ddur|g} nl|d|} t1| d ks| d j|jkr(t!jd t&t)n|g} | S|jd ks|jd d krf| |t8ur-|t=jt>}n| |}|!||d| Sg} tE|#D]K\} } | $tK|!| ||d|| | d z| L| S)z replace the to_replace value with value, possible to create new blocks here this is just a call to putmask. T to_replacerrDFrNrrrrarDowncasting behavior in `replace` is deprecated and will be removed in a future version. To retain the old behavior, explicitly call `result.infer_objects(copy=False)`. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`)rMrrDrIrMrrDrIr)&rorwrJrFr _replacerrr? mask_missingrrAr warned_alreadyrqrrrCOW_WARNING_GENERAL_MSGrr#r~r r rrvrbrcrrrr[rreplacerrrr) rerMrrDrIralready_warnedror rrrs rhrTz Block.replace<su& fk * * ""9g66C+sz22F OOzO M M M5L%%j11 <  < u --..!(;vvtyy{{m; <' ;;DxxzzM  < u --..!(;vvtyy{{m;  # #E * *E ""9g66C CJe 4 4 4 9&(( 9#.&5/9**,,9M/%#3#5#5 59N1N u}<==EE!UFF [[ey[IIF6{{Q&)/SY*F*F T*'7'9'9    M Y!^^tz!}11} kk"(6"2"23311%88;;%  F"4;;==11  2 JJ&&#-# $!!a!e)_"+ '    Mrjc||s3|r|dgS|r|gn|gStj|}|||}t |j||||rdtrV|T|jsM|j r4tj tttd|_|d|} t#d} t%| dks| d j|jkr*| s(tj d tt| S) aA Replace elements by the given value. Parameters ---------- to_replace : object or pattern Scalar to replace or regular expression to match. value : object Replacement object. inplace : bool, default False Perform inplace modification. mask : array-like of bool, optional True indicate corresponding element is ignored. using_cow: bool, default False Specifying if copy on write is enabled. Returns ------- List[Block] FrNrTrrrarrN)rrrecompilerFrGror rRrqrrrrSrr#r r rrv) rerMrrDrIrrUrxrropts rh_replace_regexzBlock._replace_regexs<%%j11 8 / u --..$7D66499;;- 7 Z # #  G44elBt444  5"$$ 5*"1+y&&(( 5 +!/11 15-mm)m<<788 HHqLLCFLEK777 MH +--     rjsrc_list Iterable[Any] dest_list Sequence[Any]regexc  jttrK||}t t|j||d|gSfdt ||D}t|s3|rdgS|rgngSt|dz } tj r!tfd|D} nfd|D} |rt| } |rg} n|rng} |rdtrV|T|jsMjr4t#jt&t(t+ d|_t-d } t/t || D]\} \\}}}| | k}g}t/| D]z\}}t| dkr|}n&|}t|t0rJ|||dz}|||||| }|r[| | krU|D]R}t5j|}|jj|jj|S| s|r|jrtAd |Dsg}|D]}|!| |}t|dks|dj |j kr(t#jdt(t+ |"||}|"|||} | S)z: See BlockManager.replace_list docstring. TrLcHg|]\}}|||fSrs)r)rr r res rhrz&Block.replace_list..sE   q!4;Q;QRS;T;T F   rjFrrac 3K|]=}tttt|dV>dS)r)r`rIN)r@r rrF)rrna_maskr`ros rhrz%Block.replace_list..$sr 6 6#!/"AaDG 6 6 6 6 6 6rjc3NK|]}tj|dV dS)rN)r?rQ)rrros rhrz%Block.replace_list..1s4GGAW)&!A$77GGGGGGrjNrr)rMrrIrDr`rc3K|]}|duV dSr{rsrr s rhrz%Block.replace_list..vs&==aT ======rjrrrN)#rorwrJrFr rPrrrr2rvr=listr rRrqrrrrSrr#r rrt_replace_coerceweakrefrefreferenced_blockspopindexr~rr r)rer\r^rDr`rrUr pairssrc_lenmasksrbrZrsrcdestrIr new_rbblk_nummmibrrrkrres_blk convertedrdros` ` @@rh replace_listzBlock.replace_listsc fk * * ""9g66C+sz22F OOxy$O O O O5L    "8Y77   5zz 8 / u --..$7D66499;;- 7e**q. 6< ( ( HF||mG 6 6 6 6 6 6 6 6 6EEHGGGGGGE  KKE  4BB!2$$tyy{{3B  5"$$ 5*"1+y&&(( 5 +!/11 15-788&/E50A0A&B&BA A  "A" dT7lG"$F !*" 9 &9 & r77a<<AAC)#t44444Ggk12A ,,"#' -g$%k!nn044F4::3?? !! ! ==9===== !C#)..$+OO.7-9%4%% y>>A--11Cw}1T1T$M!X!.+;+=+=     9---- F f%%%%BB rjnpt.NDArray[np.bool_]cTt||r|||||S||r|j}|t jtd|}||us|r|s| }n3|r1|r/|jr|r| }t|j |||gS|r|gS|r|gn| gS| |||||S)ai Replace value corresponding to the given boolean array with another value. Parameters ---------- to_replace : object or pattern Scalar to replace or regular expression to match. value : object Replacement object. mask : np.ndarray[bool] True indicate corresponding element is ignored. inplace : bool, default True Perform inplace modification. regex : bool, default False If true, perform regular expression substitution. Returns ------- List[Block] )rDrINFrrO) rHr[rrqrrrrvr[rrArorT) rerMrrIrDr`rhas_refrs rhrizBlock._replace_coercesQ> E: . . && ' }88::  "i5577GRXf%5%5EYWWBd i  WWYY 'W'1F1F1H1H'Y'WWYY#BItU;;;4K" 6M!(;vvtyy{{m;<<%#   rjarg np.ndarrayc|SzA For compatibility with 1D-only ExtensionArrays. rsrers rh_maybe_squeeze_argzBlock._maybe_squeeze_args  rjc|Srrs)rers rh_unwrap_setitem_indexerzBlock._unwrap_setitem_indexers rjrc|jjSr{)rorcr}s rhrcz Block.shapes {  rjr)int | tuple[int, int] | tuple[slice, int]c|j|Sr{ro)rers rhigetz Block.igets{1~rj4slice | npt.NDArray[np.bool_] | npt.NDArray[np.intp]c|j|S)zreturn a slice of my valuesr)rers rhrz Block._slices {6""rjcZ|r|j|_||j|<dS)a Modify block values in-place with new item value. If copy=True, first copy the underlying values in place before modifying (for Copy-on-Write). Notes ----- `set_inplace` never creates a new array or new Block, whereas `setitem` _may_ create a new array and always creates a new Block. Caller is responsible for checking values.dtype == self.dtype. Nrorrelocsrors rh set_inplacezBlock.set_inplaces3  -+**,,DK" Drjraxisrc\|j}|tjur |j}d}nd}t j|||||}t |tr|jdkr|J|dkr|J||j }|j |j kr| ||S| ||S)zN Take values according to indexer and return them as a block. FT)r allow_fillrraNr) ror no_defaultralgostake_ndrwExtensionBlockrbrrvrr)rerrrrrorrs rhrz Block.take_nds  ' 'JJJJ] G$:*   dN + + A Q<+?+?@AII,"6"67  >L  tz ) )??:|<< <--j,GG Grj new_placement needs_maskingc||jj|\}}|d}|j|}||}t |}t ||g}||fS)a  Return a list of unstacked blocks of self Parameters ---------- unstacker : reshape._Unstacker fill_value : int Only used in ExtensionBlock._unstack new_placement : np.ndarray[np.intp] allow_fill : bool needs_masking : np.ndarray[bool] Returns ------- blocks : list of Block New blocks of unstacked values. mask : array-like of bool The mask of columns of `blocks` we should keep. rrr)get_new_valuesroTrr new_block_2d) re unstackerrrrrrIrrs rh_unstackzBlock._unstack/s4%33 KMj4   Dxx{{ \$' %d+ M * *zR8889t|rjc||}ttj|j}|jdkr|j}t||||jtkrt|d} t|j|}|jtkr:||}tj |rt|t||}||d}ttj|jj}t#|tjr&|jdkrt|dkr|d} |||<nv#t$t&f$r%}t|rt'd|d}~wwxYw#t($r0||d }|||cYSwxYw|S) a Attempt self.values[indexer] = value, possibly creating a new array. Parameters ---------- indexer : tuple, list-like, array-like, slice, int The subset of self.values to set value : object The value being set using_cow: bool, default False Signaling if CoW is used. Returns ------- Block Notes ----- `indexer` is a direct slice/positional indexer. `value` must be a compatible shape. rTrrDra)r.z)setting an array element with a sequence.Nr)rr rrrorbrrUrvr|rTr,rr0rCrrFrwr:r9r'rsetitem) rerrrrocastedvierrrs rhrz Block.setitem]s.,,U33bj$+.. 9>>XF guf555 : # #!%t<<t@f$r |jdks|jddkrH|!|} | |||}|"|||d cYSt|tjtFf}g}|$}tK|D]Y\}}|}|r|d d ||dzf}|d d ||dzf}||||| }|&|Z|cYSwxYw|r| j } |'| gS) a evaluate the block; return result block(s) from the result Parameters ---------- other : a ndarray/object cond : np.ndarray[bool], SparseArray[bool], or BooleanArray _downcast : str or None, default "infer" Private because we only specify it when calling from fillna. Returns ------- List[Block] rFrzThis should not be reached; call to np.where above is expected to raise ValueError. Please report a bug at github.com/pandas-dev/pandasrrarrrrrrN)rr)(rbrwr9r;r8r@r rrrorrDrrrrrr,rvrCsumr0rrNotImplementedErrorrrcarrayrrRr9r:r'rrrLrrrr)rercondrr transposero orig_othericondrraltrrrrrrrrothrrs rhrz Block.wheres"yDI%%%%eh <%HIIIIIIN !$''bj$+..  XF&vu55 t  ! / u --..IIKK= CN " "OE,,U33D B)u==FFE-feiikk5IIC%&&3u::F +C+CHeVVU333-7   65#.... !''B&ubj99BE djn44 HUOO33FLAAE %*E665AAI'89 " " "yA~~A!!3!333E::ZKK++Y)G,&ebj.-IJJ kkmm&s^^ + +EArC2#AAAq1q5yL1"111a!a%i<0G((W Y#C%%c****!!!!? "F  XF''((s*H55A:M1B"MMlimit int | Nonec:t|d}|jsd}n,t|j}t |j|\}}|rQ|rr|dgS|gS| } | | gd} | S|$d|||jdz |k<|r| |j || } n| ||j d } tfd | DS) z fillna on the block with the value. If we fail, then convert to block to hold objects instead and try again rDTFrrrNra)rrU)rcDg|]}||gdS)rr)r)rr rrs rhrz Block.fillna..sK   ##EH ($   rj) r$rr=rorDrrcumsumrbrrrr) rerrrDrrrUrrIrrs `` rhrz Block.fillnaksx&gy99  =DD $$D)$+t<,,>CC **UTVGu*==C             rjrrrDr limit_arearrrUmethodrr#Literal['inside', 'outside'] | NonerLiteral['infer'] | Nonec|js3|r|dgS|r|gn|gS|||\} } tt|j} |dkr| j} | |||| } | sdtrV|T|j sM|j r4tj ttt!d|_ |dkr| j} t#| d} || | }||g||d S) NFrra)rrrrrTrrrr)rrrHr rN array_valuesr_pad_or_backfillr rRrqrrrrSrr#rTrr)rerrrDrrrrrUrrqrrdatars rhpad_or_backfillzBlock.pad_or_backfills{  8 / u --..$7D66499;;- 7,,Y@@ d'):;; 1996D**! +   5"$$ 5*"1+y&&(( 5 +!/11 15- 199#JZt<<<  ' '4 ' 8 8!!2$)H!MMMrjforward)rDrlimit_directionrrrrUrrnrYr&Literal['forward', 'backward', 'both']c t|d}|dkrtj||js3|r|dgS|r|gn|gS|jt kr3|r|dgS|r|gn|gS|||\} } |jj d ||j dz ||||| d| } t| d}| sdtrV| T| j sM|jr4t!jt$t&t) d| _ ||| }||g||d S)NrDasfreqFrra)rrrnrrrrTrrr interpolaterrs)r$r?clean_fill_methodrrrvr|rHrrrbrTr rRrqrrrrSrr#rr)rerrnrDrrrrrrUrgrrqrrrs rhrzBlock.interpolates&gy99 X    %f - - -  8 / u --..$7D66499;;- 7 : # # / u --..$7D66499;;- 7,,Y@@ d3T&2  Q+!      Zt<<< 5"$$ 5*"1+y&&(( 5 +!/11 15-  ' '4 ' 8 8!!2$)M!RRRrjrc|tj|jj|dj}||gS)z'return block for the diff of the valuesrrr)rdiffrorr)rerrs rhrz Block.diff"s8 Z qq999; z2233rjperiodsrc|jdz }tj|s|jtkrt d||} t|j|}ttj |j }t||||}| |gS#t$r/||}| ||cYSwxYw)z+shift the block by periods, possibly upcastrazfill_value must be a scalarr)rbrr1rvr|r9rr,r rrrorIrr'r)rerrrrrorrs rhrIz Block.shift*sy1} }Z(( >"*dk22FYvs++F~,,S11HDJJv JJJK K 6#;;$++A. . . ncDK$5a$8#9:;;~. "$  !I3355?tyy4  ClQ&&&\A%5%;QQQ%>?#L1$4s$:;T$ZZnT&:&:QU!!"%%%LLrjc t|)(return a boolean if I am possibly a viewr r}s rhis_viewz Block.is_views"$'''rjrLc t|)zP The array that Series.array returns. Always an ExtensionArray. r r}s rhrzBlock.array_values "$'''rjDtypeObj | Nonec t|)z return an internal format, currently just the ndarray this is often overridden to handle to_dense like operations r rxs rh get_valueszBlock.get_valuesrrjr]rt)r]r)rrr]r)NN)rrrqrr]rn)rrrqrr]r)r]r)r]rp)rrr]r)rrr]rF)rrrrrrtr]r)rrr]rt)rrr]rtrk)rrr]r_)rrtr]rn)rr_rrtrrr]r_rrtr]r_)rrtrrtr]r_)TTTTTr&)rrtrrtr'rtr(rtr)rtr*rtr+rtr,rr]r_)r]r)Fr6FF) rvrrrtr7rrrtr1rtr]rn)r=rr]rn)T)r rtr]r)rrtrDrtr]r)rrtrDrt)FNFN)rDrtrIrJrrtr]r_)rDrtrrtr]r_)FFFN) r\r]r^r_rDrtr`rtrrtr]r_)TFF) rIr|rDrtr`rtrrtr]r_)rrr]rr]r)rrr]r)rrr]rrorrrtr]r)rrrrrrr]rnrrrr|)rrtr]rnFNrFrrrrtr]r_NFNFNrrrDrtrrtr]r_rrrrrDrtrrrrrrrrtr]r_)rrrnrYrDrtrrrrrrrrrrtr]r_)rrpr]r_r{rrprrr]r_)r)rrYrrr]rn)rrprrtr]rr]rLrvrr]r)Lr __module__ __qualname____doc____annotations__ __slots__rr r"ryr~rrrrpropertyrrrrrsetterrrrrrrrrrrrrrrdrrrlrr r)rvrrVrrFrHrTr[r{rirrrcrrrrrrrrrrrrrrrIrrrrrrrsrjrhrnrns (''' IIIIJ    ^ U  ///^ U/ 666^ U6 %%%^ U% 66^ U6 """^ U"  333X U3  ,, U, <<^ U<  U X_&&&_& ,0'+ QQQQ UQ" ,0'+ R R R R U R     U      U  JJJ UJ  J J J U J RW J J J J U J 666 U6   ) ) ) U )" --- U-     U   U*     U   U2 42424242 U42l III UIV  8 8 8 8[ U 8  ,8,8,8,8,8 U,8d## $ $!%&6,,,,,b !!!^ U! % 1111 U1f CHRV ' ' ' ' ' U '  W W W W U W  U  U -1uuuu Uun  FFFF UFP QQQQ UQf ;;;; U;B !!!X!#########$ /3> %H%H%H%H U%HN****\?????DBFT"T"T"T"T"nOTu)u)u)u)u)t!= = = = = F :>,02N2N2N2N2N2Nh  BK:>,0ASASASASAS UASF 444 U4<<<<>>> U>:  = = = = U =J....`(((X((((X( (((((((rjrnc eZdZUdZded<ed)d*d Zed+d,dZe d-d.dZe d/d0dZ ed1fd Z ee d2dZ ed)d3dZ edd dddd ddd4d(ZxZS)5 EABackedBlockz> Mixin for Block subclasses backed by ExtensionArray. rLroNrrprrr]r_cz|jj||j}||gS)z Shift the block by `periods`. Dispatches to underlying ExtensionArray and re-boxes in an ExtensionBlock. )rr)rorrIr)rerrrs rhrIzEABackedBlock.shifts:[]((Z(PPR **:6677rjFrrtc|}|}||}||}|j}|jdkr|j}t ||| |||<|S#t tf$rt|j tr/| |d}| ||cYSt|tr/| |d}| ||cYSwxYw)a Attempt self.values[indexer] = value, possibly creating a new array. This differs from Block.setitem by not allowing setitem to change the dtype of the Block. Parameters ---------- indexer : tuple, list-like, array-like, slice, int The subset of self.values to set value : object The value being set using_cow: bool, default False Signaling if CoW is used. Returns ------- Block Notes ----- `indexer` is a direct slice/positional indexer. `value` must be a compatible shape. rTr)rrrorbrrUr9r:rwrvr5rrNDArrayBackedExtensionBlock)rerrr orig_indexer orig_valuerors rhrzEABackedBlock.setitems*4  ..w77''.. ;!  XFguf555 #F7OKI&   $*m44 00D0QQzz, ;;;;;D"=>> 00D0QQzz, ;;;;; sA!!AD;AD?Drrrc|jj}t|}|}|}||}||}|tjur|j}t||\}} | r.|r|dgS|gS | ||j} n#ttf$r|j dks|j ddkrt|jt rH||} | |||} || ||dcYSt|t(rH||} | |||} || ||dcYSt|t*jt.f} g}|} t3| D]X\}}|}| r|dd||dzf}|dd||dzf}||||}||Y|cYSwxYw|| }|gS)NFrrarrrr)rorr@rrrrrDr_wherer9r:rbrcrwrvr5rrrrrrrLrrrr)rerrrrarrr orig_condrrrr rrrrrrrrs rhrzEABackedBlock.where s km!$''  ''..&&t,, CN " "OE&sTE22 t  ! / u --..IIKK= ' "D%002JJI&% "% "% "yA~~A!!3!3dj-8855jAAC))J Y)OOC//i9W0 &ABB 55jAAC))J Y)OOC//i9W0 &j2:~2NOO kkmm&s^^++EAr"A5&qqq!a!e)|4'1q1u9 5G((1g(CCC%%c****!!!!K% "N ' ' 3 3t s!$CBIAI.B"IIc(t|}|tjur|j}|}|}||}||}|s|r|dgS|gStrV|T|jsM|j r4tj tttd|_||d}|j}|jdkr|j} |||na#t*t,f$rL|jdks|jd dkrt1|jt4r/||d }|||cYSt1|t:r/||d }|||cYSt1|t<jt@f} g} |!} tE| D]V\} } |}| r|dd| | dzf}|dd| | dzf}| ||}| #|W| cYSwxYw|gS) z+ See Block.putmask.__doc__ FrNrTrrrarr)$r@rrrrrrr rRrqrrrrSrr#rFrorbr_putmaskr:r9rcrwrvr5rrrrrrLrrr)rerIrrrUorig_newrror rrrrrrrrs rhrzEABackedBlock.putmaskes"$'' #. /C %%c**&&t,,xxzz  / u --..6M   5*"1+y&&(( 5 +!/11 15- 488 ;!  XF# " OOD# & & & &:& " " "yA~~A!!3!3dj-88 55ht5TTC;;y(;;;;;&ABB55ht5TTC;;y(;;;;;&h^0LMM kkmm&s^^++EAr A3$QQQAE \2'1q1u9 5G**Wa00C%%c****!!!!A "Dv s!D00A5J'AJ+B J Jc*|jdkrU|j|}|j|}t ||||jgS|jjdkrgSt |S)Nrar)rbrorrrsuper)rerror __class__s rhrzEABackedBlock.deletes 9>>['',,F~,,S11HDJJv JJJK K [  " "Iww~~c"""rjc|jSr{rr}s rhrzEABackedBlock.array_valuess {rjrvrrc|j}|tkr|t}t j||jS)zS return object dtype as boxed values, such as Timestamps/Timedelta )ror|rr[rrrrc)rervros rhrzEABackedBlock.get_valuessG !K J  ]]6**Fz&!!))$*555rjrrrrrrrDrrrrrrcJ|j} ||d} dtj| jjvr|| d<n&|$t t | jd| jdkr|dkr| j jdi| j } n | jdi| } | | gS)N)rrrz does not implement limit_area (added in pandas 2.2). 3rd-party ExtnsionArray authors need to add this argument to _pad_or_backfill.rrars) roinspect signaturer parametersrrrrbrr) rerrrDrrrrrUrorgrs rhrzEABackedBlock.pad_or_backfills,2U!C!C 7,V-DEEP P P#-F<  #%<<(AAA  ;!   22<JJ00::6::J**:6677rjr{rr)rrtrrrrrkr r r)rr r r rr rIrrrrr"rrr __classcell__r"s@rhrrs  8 8 8 8 U 8 6666 U6p NSBBBB UBH AEKKKK UKZ  # # # # # U # ^ U 6666 U6  :>,088888 U88888rjrceZdZUdZded< d&d'fd Zed(dZd)dZd*d+dZ dZ dZ e d,dZ ed,dZd-dZed.d Zd/d%ZxZS)0rz Block for holding extension types. Notes ----- This holds all 3rd-party extension array types. It's also the immediate parent class for our internal extension types' blocks. ExtensionArrays are limited to 1-D. rLroNFrrrDrtrr]r_cTt|jtr't||||||S|r#|jr|jjs|j}|j}n| ||\} } |j|d|| }| sdtrV|T|j sM|j r4tjtt t#d|_ nr#t$$red}|j|d|}tjdt'|jjdt*t#YnwxYw|||} | | g||d S) N)rrrDrrrU)rrrrrT)rrrzExtensionArray.fillna added a 'copy' keyword in pandas 2.1.0. In a future version, ExtensionArray subclasses will need to implement this keyword or an exception will be raised. In the interim, the keyword is ignored by .rr)rr)rwrvr5r!rrro_hasnarqrHr rRrrrrSrr#r:rrDeprecationWarningrr) rerrrDrrrUrqrrrr"s rhrzExtensionBlock.fillnas dj- 0 0 77>>!#- "  ' =*' =4;3E' =9DJJ00GDDJD$! =![//E0 * =*,, ='2*93y..00= 3)'7'9'9 9=5;   ![//eDPU/VV  5DK((1 555 '/11        > ' '  ' > >!!2$Ih!WWWsDA,E65E6rc|jdkrt|jfSt|jt|jfS)Nra)rbrrorr}s rhrczExtensionBlock.shape= sA 9>> $$& &4>""C $4$444rjrrcnt|tr|\}}tj|s|dkrt |dt|t r/|dkr|t |jz }|j||dzS|j|S|dkrt |d|jS)Nrz only contains one itemra)rwtuplecom is_null_slicerrrro)rercolrs rhrzExtensionBlock.igetD s a   HC$S)) CcQhh D!A!A!ABBB#u%% 2773t{+++C{3q=11;s# #Avv D!A!A!ABBB; rjrrrc^|r|j|_||jdd<dSr{rrs rhrzExtensionBlock.set_inplace` s4  -+**,,DK AAArjc@t|tjtfr8|j|jjdzkr |jddksJ|dddf}nDt|tr/|jddksJ|ddj }|S)z@ If necessary, squeeze a (N, 1) ndarray to (N,) raNrr) rwrrrLrbrorcr8_ixsrrs rhrz!ExtensionBlock._maybe_squeeze_argg s sRZ8 9 9 .DK,q0009Q<1$$$$aaad)CC \ * * .9Q<1$$$$((11(%%-C rjcVt|trt|dkrtd|DrU|\}}|jdkr)|dkr|jddkst d|dddf}ntj|dr|ddkr |d}nbtj |dr |d}n?t|dr|dddkr |d}nt d|S)zw Adapt a 2D-indexer to our 1D values. This is intended for 'setitem', not 'iget' or '_slice'. rc3`K|])}t|tjo |jdkV*dS)rN)rwrrrbrgs rhrz9ExtensionBlock._unwrap_setitem_indexer.. s9NN:a,,<1NNNNNNrjrarzPThis should not be reached. Please report a bug at github.com/pandas-dev/pandas/N) rwr2rrsizercrr is_integerr3r4r0)rerfirstseconds rhrz&ExtensionBlock._unwrap_setitem_indexer} sO gu % % #g,,!*;*; NNgNNNNN  ' vK1$$&A+):):)<)<$QSTATAT-8 1+ ++  a!!*"71:.. !!*gaj)) gajmq.@.@!!**4rjcdS)z,Extension arrays are never treated as views.Frsr}s rhrzExtensionBlock.is_view s urjc$|jjjSr{)rorv _is_numericr}s rhrzExtensionBlock.is_numeric s{ ,,rjrrc|jdkrht|tstd|t d|}t |std|td}|j|S)z Return a slice of my values. Parameters ---------- slicer : slice, ndarray[int], or ndarray[bool] Valid (non-reducing) indexer for self.values. Returns ------- ExtensionArray rz+invalid slicing for a 1-ndim ExtensionArrayraN)rbrwrrrangerro)rernew_locss rhrzExtensionBlock._slice s& 9>>fe,, $A6Qxx'Hx== $A64[[F{6""rjrrcr|j|}t|||j|j|jS)zN Perform __getitem__-like specialized to slicing along index. )rbrq)rorrrbrq)rerrs rhslice_block_rowszExtensionBlock.slice_block_rows s5[( tDzz*dn4949UUUUrjrrrr|c|j\}}|j|}||}fdtt||D}||fS)Nc g|]Q\}\}}tj||t|dRS))rrrr)rrotaker)rrrplacerrres rhrz+ExtensionBlock._unstack.. s    $#GU DJJ    a(8Z!u%%        rj) arange_resultrrr)rerrrrrrIrs` ` ` rhrzExtensionBlock._unstack s~%2 D  \$' %d+       (1Z1O1O'P'P    t|rjrrr)rrrrr)rrr]rL)rrr]rr)rr r r rrr"rcrrrrrrrrr rFrr)r*s@rhrrsn   !=X=X=X=X=X=X=X~555^5 8     ,(((TX ---^-&#&#&#&#P VVV UV''''''''rjrcpeZdZUded<dZeddZeddZddd Ze dd Z d S) NumpyBlockrrorsr]rtc|jjduSrN)robaser}s rhrzNumpyBlock.is_view s{t++rjrLc*t|jSr{)rNror}s rhrzNumpyBlock.array_values s"4;///rjNrvrcd|tkr|jtS|jSr{)r|rorrxs rhrzNumpyBlock.get_values s+ J  ;%%j11 1{rjc0|jj}|j}|dvS)Nfciub)rorvr)rervrs rhrzNumpyBlock.is_numeric s !zwrjrr r{r ) rr r rrrrrrr"rrsrjrhrMrM sI ,,,X,000X0 ^rjrMceZdZdZdS) NumericBlockrsNrr r rrsrjrhrVrV' IIIrjrVceZdZdZdS) ObjectBlockrsNrWrsrjrhrZrZ- rXrjrZc6eZdZUdZded<eddZdS) rz8 Block backed by an NDArrayBackedExtensionArray rZror]rtc(|jjjduSrO)ro_ndarrayrPr}s rhrz#NDArrayBackedExtensionBlock.is_view: s{#(44rjNr)rr r r rrrrsrjrhrr3 sL(''' 555X555rjrc&eZdZUdZdZdZded<dS)DatetimeLikeBlockz*Block for datetime64[ns], timedelta64[ns].rsFzDatetimeArray | TimedeltaArrayroN)rr r r rrrrsrjrhr_r_A s.44IJ******rjr_c"eZdZUdZded<dZdS)DatetimeTZBlockz0implement a datetime64 block with a tz attributerKrorsN)rr r r rrrsrjrhraraI s'::IIIrjrarorc<t|tjrIt|}t |jjtrtj|t}t|ttfr|j | d}|S)a: Input validation for values passed to __init__. Ensure that any datetime64/timedelta64 dtypes are in nanoseconds. Ensure that we do not have string dtypes. Parameters ---------- values : np.ndarray or ExtensionArray Returns ------- values : np.ndarray or ExtensionArray rN)rwrrrS issubclassrvrrrr[rKrPfreq _with_freqrs rhrrU s &"*%%4/77 fl' - - 4XfF333F&=.9::)v{?V""4(( Mrjrvr type[Block]ct|trtSt|trtSt|t rt S|j}|dvrtStS)z Find the appropriate Block subclass to use for the given values and dtype. Parameters ---------- dtype : numpy or pandas dtype Returns ------- cls : class, subclass of Block Mm) rwr3rar7rr4rrr_rMr#s rhget_block_typerir sj%)) E; ' '** E> * * :D t||  rjrrrqrcft|j}t|}||d||S)Nrrbrrq)rirvr)rorrqklasss rhrr s9 6< ( (E  ( (F 5a94 @ @ @@rjrrbrpcHt|j}|||||S)Nrk)rirv)rorrbrqrls rhrr s, 6< ( (E 5did C C CCrjrc|j|krtd|jd|dt|jsw|j|krtd|jd|dt |t |kr/tdt |dt |d S|dkr"t |d krtd d Sd S) aV ndim inference and validation. Validates that values.ndim and ndim are consistent. Validates that len(values) and len(placement) are consistent. Parameters ---------- values : array-like placement : BlockPlacement ndim : int Raises ------ ValueError : the number of dimensions do not match z0Wrong number of dimensions. values.ndim > ndim [z > ]z1Wrong number of dimensions. values.ndim != ndim [z != zWrong number of items passed z, placement implies rraz need to splitN)rbr9r-rvr)rorrbs rh check_ndimrp s;${T ;#); ; ;37 ; ; ;   v| , ,* ;$  A(. AA9=AAA  y>>S[[ ( (6F 66%(^^66  ) ( s9~~**))) **rjr!tuple[ArrayLike, DtypeObj | None]ct|tr0|}|r|dkrtj|}t|t r|j}||fS)zU Ensure that we don't allow NumpyExtensionArray / NumpyEADtype in internals. ra)rwr:to_numpyr atleast_2dr6 numpy_dtype)rorvrbs rhextract_pandas_arrayrv si&011+""  +D1HH]6**F%&&"! 5=rjr_cF|g}t|trF|D]B}t|tr||-||CnAt|tsJt ||||S)z.return a new extended blocks, given the result)rwrhrrrnr)rrrs rhrr s ~&$ ! !A!T"" ! a     a     ! &%((66$v,,66( f Mrjrac|j|kr:t|js&td|}|dd}|S)z: Reshape if possible to have values.ndim == ndim. z+np.ndarray | DatetimeArray | TimedeltaArrayrar)rbr-rvr r)rorbs rhrr sM {T"6<00 +GPPF^^Ar**F MrjcHt|ttfr|tSt|t t fr|j}t|tj r.tr | }d|j _ |S)a+ The array that Series.values returns (public attribute). This has some historical constraints, and is overridden in block subclasses to return the correct array (e.g. period returns object ndarray and datetimetz a datetime64[ns] ndarray instead of proper extension array). F)rwrOrMrr[rKrPr]rrr viewflags writeablers rhrr s&; 677!}}V$$$ F]N; < <!&"*%%'*=*?*?'!&  Mrj)r\rr]r)rorr]r)rvrr]rfr{)rorrrrqr)rrrbrprqrr]rn)rrrbrpr]r)rorrvrrbrpr]rqrk)ra)rorrbrpr]r) __future__r functoolsrr&rWtypingrrrrr r rrjnumpyrpandas._configr r r pandas._libsrr libinternalsrpandas._libs.internalsrrpandas._libs.missingrpandas._typingrrrrrrrrrrrr pandas.errorsr!pandas.util._decoratorsr"pandas.util._exceptionsr#pandas.util._validatorsr$pandas.core.dtypes.astyper%r&pandas.core.dtypes.castr'r(r)r*r+r,pandas.core.dtypes.commonr-r.r/r0r1r2pandas.core.dtypes.dtypesr3r4r5r6r7pandas.core.dtypes.genericr8r9r:r;pandas.core.dtypes.missingr<r=r> pandas.corer?pandas.core.algorithmscore algorithmsrpandas.core.array_algos.putmaskr@rArBrCrD pandas.core.array_algos.quantilerEpandas.core.array_algos.replacerFrGrH"pandas.core.array_algos.transformsrIpandas.core.arraysrJrKrLrMrNrOrPpandas.core.baserQpandas.core.commoncommonr3pandas.core.computationrRpandas.core.constructionrSrTpandas.core.indexersrUpandas.core.indexes.baserVcollections.abcrWrXpandas.core.apirYpandas.core.arrays._mixinsrZrvr|rSCOW_WARNING_SETITEM_MSGrlrnrrrMrVrZrr_rarrirrrprvrrrrsrjrhrsn""""""   $#####                            .-----222222444444777777   &&&&&&&&&=<<<<< 544444*))))) //////766666777777G &%%%%%FFFFFFRXh    "[([([([([(L,,[([([(|8Z8Z8Z8Z8Z8EZ8Z8Z8zZZZZZ]ZZZz4: * 5 5 5 5 5- 5 5 5+++++3+++':<RV A A A A A$$( D D D D D D'*'*'*'*T,           rj