o[we)UdZddlmZddlmZmZmZmZmZddl m Z ddl m Z m Z ddlmZddlmZddlmZdd lZdd lZdd lmZdd lmZmZmZmZmZmZdd lm Z dd l!Z"dd l#m$Z$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0ddl1m2Z2ddl3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9ddl:m;Z;mm?Z?m@Z@ddlAmBZBmCZCmDZDddlEmFZFddlGmHZHdd lImJcmKZLddlMmNZNddlOmPZPmQZQmRZRmSZSddlTmUZUddlVmWZWddlXmYZYddlZm[Z[m\Z\ddl]m^Z^er"ddl_m`Z`maZambZbmcZcmdZdmeZemfZfmgZgmhZhmiZimjZjdd lkmlZlmmZmd!Znd"eod#<d$Zpd%Zqd"eod&<Gd'd(ZrGd)d*ZsGd+d,ZtGd-d.etZudd0Zvdd2Zwdd3ZxGd4d5ZyGd6d7Zz ddd>Z{e ddd@Z| dddWZ}GdXdYZ~GdZd[e~ZGd\d]e~ZGd^d_e~ZGd`dae~ZdddZddgZdddlZ dddnZ dddqZddsZGdtdueZGdvdwe~Z ddd|Z dddZdddZddZ dddZddZGddZdddZ dddZddZd S)z Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations) GeneratorHashableIterableMappingSequence)contextmanager) QUOTE_NONEQUOTE_NONNUMERIC)Decimal)partial)StringION)get_terminal_size)IO TYPE_CHECKINGAnyCallableFinalcast)east_asian_width) get_option set_option)lib)NA)NaT Timedelta Timestampget_unit_from_dtypeiNaTperiods_per_day)NaTType)is_complex_dtypeis_float is_integer is_list_likeis_numeric_dtype is_scalar)CategoricalDtypeDatetimeTZDtypeExtensionDtype)isnanotna) Categorical DatetimeArrayTimedeltaArray) StringDtype) PandasObject) extract_array)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)check_parent_directorystringify_path)printing) ArrayLikeAxesColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelStorageOptions WriteBuffer) DataFrameSeriesa Parameters ---------- buf : str, Path or StringIO-like, optional, default None Buffer to write to. If None, the output is returned as a string. columns : array-like, optional, default None The subset of columns to write. Writes all columns by default. col_space : %(col_space_type)s, optional %(col_space)s. header : %(header_type)s, optional %(header)s. index : bool, optional, default True Whether to print index (row) labels. na_rep : str, optional, default 'NaN' String representation of ``NaN`` to use. formatters : list, tuple or dict of one-param. functions, optional Formatter functions to apply to columns' elements by position or name. The result of each function must be a unicode string. List/tuple must be of length equal to the number of columns. float_format : one-parameter function, optional, default None Formatter function to apply to columns' elements if they are floats. This function must return a unicode string and will be applied only to the non-``NaN`` elements, with ``NaN`` being handled by ``na_rep``. .. versionchanged:: 1.2.0 sparsify : bool, optional, default True Set to False for a DataFrame with a hierarchical index to print every multiindex key at each row. index_names : bool, optional, default True Prints the names of the indexes. justify : str, default None How to justify the column labels. If None uses the option from the print configuration (controlled by set_option), 'right' out of the box. Valid values are * left * right * center * justify * justify-all * start * end * inherit * match-parent * initial * unset. max_rows : int, optional Maximum number of rows to display in the console. max_cols : int, optional Maximum number of columns to display in the console. show_dimensions : bool, default False Display DataFrame dimensions (number of rows by number of columns). decimal : str, default '.' Character recognized as decimal separator, e.g. ',' in Europe. rcommon_docstring) leftrightcenterjustifyz justify-allstartendinheritz match-parentinitialunsetz Returns ------- str or None If buf is None, returns the result as a string. Otherwise returns None. return_docstringc8eZdZ dddZddZddZddZdS)CategoricalFormatterNTNaN categoricalr-bufIO[str] | Nonelengthboolna_repstrfooterreturnNonec||_||ntd|_||_||_||_t |_dSN)rXrrYr]r[r_r quoting)selfrXrYr[r]r_s 8lib/python3.11/site-packages/pandas/io/formats/format.py__init__zCategoricalFormatter.__init__sA'/33x||   ' cd}|jr!|r|dz }|dt|jz }|j}|r|dz }||z }t |S)Nrd, Length:  )r[lenrX_repr_categories_infor^)rfr_ level_infos rg _get_footerz CategoricalFormatter._get_footers} ; 9 $ 8T%5!6!688 8F%;;==    dNF*6{{ri list[str]clt|jdd|j|jS)N) float_formatr]re) format_arrayrX_internal_get_valuesr]rerfs rg_get_formatted_valuesz*CategoricalFormatter._get_formatted_valuess;   1 1 3 3 ;L     ric|j}t|dkr|jr|SdS|}d|D}d|}d|zdzg}|jr+|}|r||td|S)Nrrdc6g|]}|S)strip.0is rg z2CategoricalFormatter.to_string..s 444Aaggii444rirk[]rm)rXrnr_rqrxjoinappendr^)rfrX fmt_valuesvaluesresultr_s rg to_stringzCategoricalFormatter.to_strings& {  q { '')))r//11 44444 :&&,$% ; &%%''F & f%%%499V$$%%%ri)NTrWT) rXr-rYrZr[r\r]r^r_r\r`rar`r^r`rr)__name__ __module__ __qualname__rhrqrxrr{rirgrVrVsw# ( ( ( ( ("    &&&&&&rirVcTeZdZ d!d"dZd#dZd$dZd%dZd&dZd$d ZdS)'SeriesFormatterNTrWFseriesrIrYrZr[ bool | strheaderr\indexr]r^namert str | Nonedtypemax_rows int | Nonemin_rowsr`rac 0||_||n t|_||_||_||_||_||_| |_| |_ |td}||_ | |_ t|_|dS)Ndisplay.float_format)rrrYrr]rr[rrrrrtrget_adjustmentadj _chk_truncate) rfrrYr[rrr]rrtrrrs rgrhzSeriesFormatter.__init__ s /33xzz          %&<==L( !## ric||j}|j}|ot|j|k}|j}|rxt t |}|rt ||}|dkr|}|jd|}n1|dz}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rrrnrrintminilocr9 tr_row_num tr_seriesis_truncated_vertically)rfrrrrrow_nums rgrzSeriesFormatter._chk_truncate)s #==#+"LDK0@0@80K " #C**H 3x221}}"YhY/"a-XgX!6 WHII8N OPP%DOO"DO'>$$$ric|jj}d}t|jjddEt |jjt t tfsJ|d|jjjz }|jdur'|%|r|dz }tj |d}|d|z }|j d us|j d kr(|j r!|r|dz }|d t|jz }|jdurE|j>t|jjd d}|r!|r|dz }|d tj |z }t |jjt r*|jj}|r|dz }||z }t'|S)NrdfreqzFreq: Frk  rm) escape_charszName: Ttruncaterlrzdtype: rm)rrgetattrr isinstancer7r5r8freqstrr< pprint_thingr[rrnrrr(_valuesror^)rfrr_ series_name dtype_namerps rgrqzSeriesFormatter._get_footerDs{ 4;$fd 3 3 ? !M;#O    :t{08:: :F 9E ! !d&6 $"/CUVVVK ,{,, ,F ;$   K: % %$*F % $ 3T[!1!133 3F :U " "tz'= !5vtDDJ H#dNFGH$9*$E$EGGG dn*,< = = !/EEGGJ $ j F6{{rituple[list[str], bool]c|jj}t|tr5t d|jD}|d}n|jdu}|d}||fS)Nc3K|]}|VdSNr{r~rs rg z7SeriesFormatter._get_formatted_index..qs";;td;;;;;;riT)names)r)rrrr4anyrformatr)rfr have_header fmt_indexs rg_get_formatted_indexz$SeriesFormatter._get_formatted_indexms{$ eZ ( ( 0;;u{;;;;;K 4 00II*D0K $ //I+%%rirrc\t|jjd|j|j|jS)N)rtr] leading_space)rurrrtr]rrws rgrxz%SeriesFormatter._get_formatted_valuesxs4 N " *;*     ricJ|j}|}t|dkrt|jjd|dS|\}}|}|jrd}|j }tt|}|j ||dz }|dkrd} nd} |j | g|d d} |||z| ||dzd |jr|j jdg|dd|gR} n|j d|} |jr|r|dd z| z} |r| d |zz } t%d | S) Nrz([], )r...z..rMmoderdrm)rrqrntyperrrrxrrrrrrNinsertradjoinrr^r) rfrr_rrr n_header_rowsrwidthdot_strrs rgrzSeriesFormatter.to_strings!!## v;;!  4;''0@@v@@@ @!%!:!:!.sR  MNDM  .q1143G H H      ri)rr^rnsumrs` rgrnzEastAsianTextAdjustment.lens[$$$ t99     RV      rirLr Iterable[str]rrrrcfd|dkrfd|DS|dkrfd|DSfd|DS)NcT|z t|zSrr)trrfs rg_get_padz1EastAsianTextAdjustment.justify.._get_pads#TXXa[[(3q661 1rirKcLg|] }||!Sr{)ljustr~xrs rgrz3EastAsianTextAdjustment.justify..-888QAGGHHQKK((888rirMcLg|] }||!Sr{)rMrs rgrz3EastAsianTextAdjustment.justify..s-999aAHHXXa[[))999ricLg|] }||!Sr{)rjustrs rgrz3EastAsianTextAdjustment.justify..rrir{)rfrrrrs` ` @rgrNzEastAsianTextAdjustment.justifys 2 2 2 2 2 2 6>>8888%888 8 X  99995999 98888%888 8rirrr)rrrrrr^r`rr)rrrrhrnrN __classcell__rs@rgrrsv B B B B B B     ?F 9 9 9 9 9 9 9 9 9rirr`c\td}|rtStS)Nz display.unicode.east_asian_width)rrr)use_east_asian_widths rgrrs1%&HII &(((ridict[str, Any]cddlm}tdr|\}}nd}tdtdtdtdtd |d S) aGet the parameters used to repr(dataFrame) calls using DataFrame.to_string. Supplying these parameters to DataFrame.to_string is equivalent to calling ``repr(DataFrame)``. This is useful if you want to adjust the repr output. .. versionadded:: 1.4.0 Example ------- >>> import pandas as pd >>> >>> df = pd.DataFrame([[1, 2], [3, 4]]) >>> repr_params = pd.io.formats.format.get_dataframe_repr_params() >>> repr(df) == df.to_string(**repr_params) True r)consolezdisplay.expand_frame_reprNdisplay.max_rowsdisplay.min_rowszdisplay.max_columnsdisplay.max_colwidthdisplay.show_dimensions)rrmax_cols max_colwidthshow_dimensions line_width)pandas.io.formatsr rget_console_size)r r_s rgget_dataframe_repr_paramsrs"*)))))-..0022 AA 122122455"#9::%&?@@   rict\}}tddkr|ntd}tddkr|ntd}dd||tddS)aGet the parameters used to repr(Series) calls using Series.to_string. Supplying these parameters to Series.to_string is equivalent to calling ``repr(series)``. This is useful if you want to adjust the series repr output. .. versionadded:: 1.4.0 Example ------- >>> import pandas as pd >>> >>> ser = pd.Series([1, 2, 3, 4]) >>> repr_params = pd.io.formats.format.get_series_repr_params() >>> repr(ser) == ser.to_string(**repr_params) True r rr Tr )rrrrr[)rr)rheightrrs rgget_series_repr_paramsrs"&''ME6 ( ) )Q . .  * + +  ( ) )Q . .  * + + 677   riceZdZdZerendZeeezz Z dSdTd(ZdUd*ZedVd+Z edVd,Z edVd-Z edVd.Z edWd/Z edVd0ZedVd1ZedVd2ZedVd3ZedXd5ZdYd6ZdZd8Zd[d9Zd\d;Zd]d=Zd^d>Zd^d?Zd_d@ZdVdAZdVdBZdVdCZdXdDZd`dEZd`dFZ d`dGZ!dUdHZ"dadKZ#dbdNZ$dcdOZ%dddPZ&dedRZ'dS)fDataFrameFormatterz;Class for processing dataframe formatting options and data.rdNTrWF.framerHcolumns Axes | None col_spaceColspaceArgType | Nonerbool | list[str]rr\r]r^ formattersFormattersType | NonerNrrtFloatFormatType | Nonesparsify bool | None index_namesrrrrrrdecimal bold_rowsescaper`rac||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t;|_dSr)r_initialize_columnsr_initialize_colspacerrrr]_initialize_formattersr"_initialize_justifyrNrt_initialize_sparsifyr%show_index_namesr(r)r*rrrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerrr)rfrrrrrr]r"rNrtr%r'rrrrr(r)r*s rgrhzDataFrameFormatter.__init__4s* //88 229==   55jAA//88 (11(;; + "       .#99;;#99;;   !##rilist[list[str]]c|}|jr0||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrrr6r)rfstrcols str_indexs rg get_strcolszDataFrameFormatter.get_strcolscsM1133 : )11$-@@I NN1i ( ( (ric8|jdup|jdko|jS)NTr)r is_truncatedrws rgshould_show_dimensionsz)DataFrameFormatter.should_show_dimensionsos*#t+  J . D43D ric8t|jp|jSr)r\is_truncated_horizontallyrrws rgr>zDataFrameFormatter.is_truncatedusD2Rd6RSSSricdt|jot|j|jkSr)r\r3rnrrws rgrAz,DataFrameFormatter.is_truncated_horizontallyys*D(Wc$,.?.?$BV.VXXXricdt|jot|j|jkSr)r\r5rnrrws rgrz*DataFrameFormatter.is_truncated_vertically}s(D(Uc$*oo@T.TVVVricfdt|jdt|jjdS)Nz [z rows x z columns])rnrrrws rgdimensions_infoz"DataFrameFormatter.dimensions_infos0Rs4:RRDJ4F0G0GRRRRric4t|jjSr) _has_namesrrrws rghas_index_namesz"DataFrameFormatter.has_index_namess$**+++ric4t|jjSr)rGrrrws rghas_column_namesz#DataFrameFormatter.has_column_namess$*,---ricDt|j|j|jfSr)allrHrr1rws rgshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namessD($*d6KLMMMricDt|j|j|jfSr)rLrJr1rrws rgshow_col_idx_namesz%DataFrameFormatter.show_col_idx_namessD)4+@$+NOOOrircxt|jpt|jt|jSr)rrrnrrws rgmax_rows_displayedz%DataFrameFormatter.max_rows_displayeds)4=3C OOS__EEEric(|tdS|S)Nzdisplay.multi_sparser)rfr%s rgr0z'DataFrameFormatter._initialize_sparsifys  455 5rirDc|iSt|jjt|kst|tr|St dt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rnrrrdict ValueError)rfr"s rgr.z)DataFrameFormatter._initialize_formatterss  I # $ $J 7 7:jRV;W;W 7 JS__JJ/24:3E/F/FJJJ ric(|tdS|S)Nzdisplay.colheader_justifyrS)rfrNs rgr/z&DataFrameFormatter._initialize_justifys ?9:: :Nrir3cd|#t|}|j||_|S|jjSr)r6rr)rfrcolss rgr,z&DataFrameFormatter._initialize_columnss3  ((DD)DJK:% %rir@cli}n,tttfr0di}|fd|jjDntt r@D](}||jjvr|dkrtd|)}nt|jjtkr:tdtdt|jjdtt|jj}|S)Nrdci|]}|Sr{r{)r~columnrs rg z;DataFrameFormatter._initialize_colspace..sNNN69NNNriz,Col_space is defined for an unknown column: zCol_space length(rUr) rrr^updaterrrkeysrWrnrVzip)rfrrr]s ` rgr-z'DataFrameFormatter._initialize_colspacesY  FF  C: . . >)_F MMNNNN4:;MNNN O O O O  7 + + >#..**  !333" $OvOOFF4:%&&#i..88 NINN36tz7I3J3JNNN#dj0)<<==F ric|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr_is_screen_narrow)rfrrs rgr2z(DataFrameFormatter._calc_max_cols_fittedsP##%% != $&&q  ! !% ( ( !L= ric|rSt\}}|jdkr||z S||r|}n|j}n|j}||S)z,Number of rows with data fitting the screen.r)rcrr_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rfrrrs rgr4z(DataFrameFormatter._calc_max_rows_fitteds    ! ! %)++IAv}!! B B D DDD$$V,, )!=}H$$X...ricr|r4t|j|kr|jrt|j|}|S)zAdjust max_rows using display logic. See description here: https://pandas.pydata.org/docs/dev/user_guide/options.html#frequently-used-options GH #37359 )rnrrr)rfrs rgrhz#DataFrameFormatter._adjust_max_rowss<  8DJ(** *t}h77ricHt|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)r\rrrws rgrcz"DataFrameFormatter._is_in_terminals#DMQ&<$-1*<===riclt|jdkot|jj|kSNr)r\rrnrr)rf max_widths rgrdz$DataFrameFormatter._is_screen_narrows.DMQ&N3tz/A+B+BY+NOOOricbt|jdkot|j|kSrl)r\rrnr)rf max_heights rgrgz#DataFrameFormatter._is_screen_shorts)DMQ&G3tz??Z+GHHHricd}d}||z}|jr)|t|jz }|jr|dz }|S)z?Get number of rows occupied by prompt, dots and dimension info.r)rrnrE splitlinesr)rfdot_row prompt_rownum_rowss rgrfz0DataFrameFormatter._get_number_of_auxiliary_rowssZ Z'   ? D0;;==>> >H ;  MHricv|jr||jr|dSdS)zY Check whether the frame should be truncated. If so, slice the frame up. N)rA_truncate_horizontallyr_truncate_verticallyrws rgrzDataFrameFormatter.truncatesN  ) *  ' ' ) ) )  ' (  % % ' ' ' ' ' ( (ric|jJ|jdz}|dkr|jjddd|f}|jjdd| df}t||fd|_t |jt tfr&g|jd||j| d|_n7tt|j }|jjddd|f|_||_ dS)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num Nrraxis) r3r6rr9rr"listtuplerrr tr_col_num)rfcol_numrKrLs rgrvz)DataFrameFormatter._truncate_horizontallys#///&!+ a<<=%aaa'k2DM&qqq7())|4E"D%=q999DM$/D%=99 #_XgX.#_gXYY/# 3 ..G M.qqq(7({;DM!ricD|jJ|jdz}|dkrH|jjd|ddf}|jj| dddf}t||f|_n7t t |j}|jjd|ddf|_||_dS)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrr)r5r6rr9rrrr)rfrheadtails rgrwz'DataFrameFormatter._truncate_vertically9s#///&!+ a<<=%hwhk2D=%whiil3D"D$<00DMM3 ..G M.xx{;DM!ric g}tjsjstjD]r\}}|}t |jtj |dj }| |s|Stjrtttj_tjtjkr:t#dtjdtjddjD}nj}jr|D]}| dtjD]\}}||}t)tj |dgfd|DR}|}t |j|j }t)gfd |D|R} j || j }| ||z|S) Nr)stringsrNminimumrzWriting z cols but got z aliasescg|]}|gSr{r{)r~labels rgrzADataFrameFormatter._get_strcols_without_index..bs<<.ms/0R0RQa0R0R0R0R0R0Rri)rrc3LK|]}j|VdSrrrs rgrz@DataFrameFormatter._get_strcols_without_index..ts/@@DHLLOO@@@@@@rir)r%r enumerater6 format_col_make_fixed_widthrNrrrrrrr{r^rnrrW_get_formatted_column_labelsrMmax) rfr:rrr str_columnsrcheaderheader_colwidthrs ` rgr9z-DataFrameFormatter._get_strcols_without_indexKs#%DK((  !$-00 + +1!__Q// .& L 2 21a 8 899  z****N  $ $ KtCy$+66DK4;3t|#4#444 :s4<00::"4;//:::=< <<.s%%T%TEe&7%T%T%T%T%T%Tric8|jvr|rsd|zS|S)N )r")ry need_leadsprestrict_formattingrfs rg space_formatzEDataFrameFormatter._get_formatted_column_labels..space_formats4T_,,#A-/-7Nric38K|]fdDVdS)c(g|]}|Sr{r{)r~rrrs rgrzMDataFrameFormatter._get_formatted_column_labels...s%555a||Aq))555riNr{)r~rrs @rgrzBDataFrameFormatter._get_formatted_column_labels..s<KK!555551555KKKKKKric,g|]}t|Sr{)r{r~rs rgrzCDataFrameFormatter._get_formatted_column_labels..s>>>q477>>>ric`g|]*\}}|s |rd|zn|g+S)r)r)r~rrrrfs rgrzCDataFrameFormatter._get_formatted_column_labels..sTAq!% 3 3A 6 6P;q>PqqQri)pandas.core.indexes.multirrrr4rr{rardtypesrrlevelsrVmapr&r%rnr) rfrrr fmt_columnsrrrrrs ` @@@rgrz/DataFrameFormatter._get_formatted_column_labelss======- gz * * !..%.FFKsK011KZ&.F#&%T%TW^%T%T%T"T"T s;4Df0M0MNNOOK       KKKK{KKKLK} ;[!1!1 ;-ok:: >>C,=>>>KK!..**KZ&Fs;4Df0M0MNNOOK%k22K ric&djD|j}|j}d}t |t r$|jdj |}n|j |g}fd|D}j j dg|R d}j rd D}n d g|jz}jr||zS|S) Nc@i|]\}}|tt|Sr{)rr)r~kvs rgr^z;DataFrameFormatter._get_formatted_index..s&HHHAQS! HHHri __index__F)r%rrr)rrc g|]H}ttt|dddjIS)rKrdr)rNrr)r|rr{rr)r~rrrfs rgrz;DataFrameFormatter._get_formatted_index..sf    !GGVY]]2q5I5Itx     rirrmc,g|]}t|Sr{r^rs rgrz;DataFrameFormatter._get_formatted_index..sGGGQ#a&&GGGrird)ritemsrrrrr4rr%rMrrsplitrO_get_column_name_listnlevelsr) rfrrrfmtradjoined col_headerrs ` @rgrz'DataFrameFormatter._get_formatted_indexsTIH1E1E1G1GHHH  -!!+.. eZ ( ( T - %II4+BcRRSI         #48?11y11177==  " 0GG$*D*D*F*FGGGJJ/J ; ( (Orilist[Hashable]cg}|jj}t|tr%|d|jDn#||jdn|j|S)Nc3"K|] }|dn|V dSrcr{rs rgrz;DataFrameFormatter._get_column_name_list..s*PP$t|PPPPPPrird)rrrr4extendrrr)rfrrs rgrz(DataFrameFormatter._get_column_name_listsn "*$ gz * * G LLPP'-PPP P P P P LLw|3 F F F ri)NNTTrWNNNNTNNNFrFT)&rrHrrrr rr!rr\r]r^r"r#rNrrtr$r%r&r'r\rrrrrrrrr(r^r)r\r*r\r`ra)r`r7r`r\r)r`r)r%r&r`r\)r"r#r`rD)rNrr`r^)rrr`r3)rr r`r@)r`r)rrr`rr)rrr`rr)rrr`r)rrHr`r7)rrHr`rr)r`r)(rrr__doc__rJrTrhr<propertyr?r>rArrErHrJrMrOrQr0r.r/r,r-r2r4rhrcrdrgrfrrvrwr9rrrrrr{rirgrr.sEE (ggbG "222G $,0#',0"/3 $ ###&+'-$-$-$-$-$^       X TTTXTYYYXYWWWXWSSSXS,,,X,...X.NNNXNPPPXPFFFXF     &&&&0 ! ! ! !////&    >>>>PPPPIIII    ((((""""4""""$----^      0 0 0 0''''R&&&&PrircleZdZdZd5dZ d6d7dZ d8d9dZ d:d;d4ZdS)<DataFrameRendereraJClass for creating dataframe output in multiple formats. Called in pandas.core.generic.NDFrame: - to_csv - to_latex Called in pandas.core.frame.DataFrame: - to_html - to_string Parameters ---------- fmt : DataFrameFormatter Formatter with the formatting options. rrr`rac||_dSr)r)rfrs rgrhzDataFrameRenderer.__init__s riNFrY"FilePath | WriteBuffer[str] | Nonerrclassesstr | list | tuple | Nonenotebookr\borderint | bool | Nonetable_id render_linkscddlm}m} |r| n|} | |j||||} | } t | ||S)uJ Render a DataFrame to a html table. Parameters ---------- buf : str, path object, file-like object, or None, default None String, path object (implementing ``os.PathLike[str]``), or file-like object implementing a string ``write()`` function. If None, the result is returned as a string. encoding : str, default “utf-8” Set character encoding. classes : str or list-like classes to include in the `class` attribute of the opening ```` tag, in addition to the default "dataframe". notebook : {True, False}, optional, default False Whether the generated HTML is for IPython Notebook. border : int A ``border=border`` attribute is included in the opening ``
`` tag. Default ``pd.options.display.html.border``. table_id : str, optional A css id is included in the opening `
` tag if specified. render_links : bool, default False Convert URLs to HTML links. r) HTMLFormatterNotebookFormatter)rrrrrYr)pandas.io.formats.htmlrrrrsave_to_buffer) rfrYrrrrrrrrKlasshtml_formatterstrings rgto_htmlzDataFrameRenderer.to_htmlsD        &.@!!= H%     ))++f#AAAArirrc~ddlm}||j|}|}t |||S)u% Render a DataFrame to a console-friendly tabular output. Parameters ---------- buf : str, path object, file-like object, or None, default None String, path object (implementing ``os.PathLike[str]``), or file-like object implementing a string ``write()`` function. If None, the result is returned as a string. encoding: str, default “utf-8” Set character encoding. line_width : int, optional Width to wrap a line in characters. r)StringFormatter)rr)pandas.io.formats.stringrrrr)rfrYrrrstring_formatterrs rgrzDataFrameRenderer.to_string5sS( =<<<<<*?48 KKK!++--f#AAAAri,winfer"Tstrict path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Nonesepr^rSequence[Hashable] | None index_labelIndexLabel | Noner compressionrAre quotecharlineterminator chunksize date_format doublequote escapecharerrorsstorage_optionsStorageOptions | Nonecfddlm}|d}t}nd}|did|d| d|d |d |d |d |d |d|d|d| d| d| d| d|d|d|j}||rAt |tsJ|}||SdS)z; Render dataframe as comma-separated file. r) CSVFormatterNTFrrrrrrrerZrrrrrrrrrr{)pandas.io.formats.csvsrrrsavergetvalueclose)rfrrrrrrrrerrrrrrrrrcreated_buffer csv_formattercontents rgto_csvzDataFrameRenderer.to_csvOsp, 877777  !N"**KK"N$    #  )>  X  6  $  G  $    i  i $  $  "z ,O! "hh# &   k844 4 4 4!**,,G      Ntri)rrr`ra)NNNFNNF)rYrrrrrrr\rrrrrr\r`r)NNN)rYrrrrrr`r)NNrNNrrNrNNNTNrN)"rrrrrr^rrrrrr^rrArerrr^rrrrrrrr\rrrr^rrr`r)rrrrrhrrrr{rirgrrs  37#-1$(#"1B1B1B1B1Bj37#!% BBBBB8PT#-1)-*1"%) $"& !%15#9999999rirrr^rYrrrct||5}||| |cdddS ddddS#1swxYwYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) get_bufferwriter)rrYrfs rgrrs C( + + +q  ;::<<   s+A AAAIGenerator[WriteBuffer[str], None, None] | Generator[StringIO, None, None]c#K|t|}nt}|d}n$t|tst dt |dr|VdSt|trNt t|t|d|d5}|VddddS#1swxYwYdStd) z Context manager to open, yield and close buffer for filenames or Path-like objects, otherwise yield buf unchanged. Nzutf-8z1buf is not a file name and encoding is specified.rrrd)rnewlinez1buf is not a file name and it has no write method) r;rrr^rWhasattrr:open TypeError)rYrrs rgrrs1 S!!jj S ! !NLMMMsG M C   Ms3xx((( #sXr : : : a GGG                   KLLLs&B88B<?B<rWrLrTrrrrrtr$r]digitsrrstr | int | NonerNr(rr&refallback_formatterrrc Htj|jdrt} nt |jt rt } ntj|jdrt} nmt |jtrt} nKtj|jdrt} n)tj|jdrt} nt} |d}|td}|td}| |||||||||| | } | S) a{ Format an array for printing. Parameters ---------- values formatter float_format na_rep digits space justify decimal leading_space : bool, optional, default True Whether the array should be formatted with a leading space. When an array as a column of a Series or DataFrame, we do want the leading space to pad between columns. When formatting an Index subclass (e.g. IntervalIndex._format_native_types), we don't want the leading space since it should be left-aligned. fallback_formatter Returns ------- List[str] MmfciuN rdisplay.precision) rr]rtrrrNr(rrer)r is_np_dtyperDatetime64Formatterrr)Datetime64TZFormatterTimedelta64Formatterr*ExtensionArrayFormatterFloatArrayFormatterIntArrayFormatterGenericArrayFormatterr get_result) rrrtr]rrrNr(rrer fmt_klassfmt_objs rgrurus0R v|S)) *' FL/ 2 2 *) s + + *( FL. 1 1*+ t , ,*' t , ,*% )  }!"899  ~/00i!#-   G     ric>eZdZ d#d$dZd%d!Zd%d"ZdS)&rNrWrrLrTrrrrrrr]r^rrrtr$rNr(rer fixed_widthr\rr&rr`rac ||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rrr]rrrtrNr(rerrr) rfrrrr]rrtrNr(rerrrs rgrhzGenericArrayFormatter.__init__sb    "(   &*"4rirrcT|}t||jSr)_format_stringsrrN)rfrs rgrz GenericArrayFormatter.get_result0s%))++  T\:::ric  j&td}|td fd}nj}jj nDjj n5jduojt k}t tjd| fd}tj d}t|tj std tj|t"}|tjt'|t)t+d t-|j z}j}||}g}t5|D]\} } || rj$|r"|d || 8|| r||| _|d urd} nd} || || |S)Nrrc0t|dddS)Nz .dr)_trim_zeros_single_float)r precisions rgz7GenericArrayFormatter._format_strings..9s))A+I+++++**rir)r quote_stringscj~t|rot|r` |dS|turt tS|t ust j|rdSn#ttf$rYnwxYwjSt|trt |St|trt|St |S)Nrar)r]r'r+rr^rnpisnatrrWrr1r0repr)rrrfs rg_formatz6GenericArrayFormatter._format_strings.._formatKs{&9Q<<&DGG& y%vb"2wwcRXa[[$u"!:.D{"A|,, )1vv A{++ )Aww99Q<<(((sA)A) A))A=<A=T extract_numpyz %II  $ 0/II L4S9SM%/+I  ) ) ) ) ) ).T[===$ ++ N =x00 fU4[[uU1c$*oo-F-F'G'GHHH I  *  )--//M dOO < eZdZdfd Z ddd Zdd ZddZxZS)rr`ractj|i||j7|j2d|_t |jr|j|_d|_dSdSdSdSNF)rrhrtrrcallable)rfargsrrs rgrhzFloatArrayFormatter.__init__s|$)&)))   (T^-C$D )** )!%!2$(!!! ) (-C-C ) )riNrtr$ threshold float | Nonerc|jrfdnfdjdkrfdnSfd}|S)z;Returns a function to be applied on each value to format itNcPJt|r |njS)N)value)r,r])rrtrfs rgbase_formatterz.base_formatters;#/// Qxx%LLq))))ricNt|rt|njSr)r,r^r])rrfs rgrAz.base_formatters !&q:s1vvvt{:rircN|djdS)Nrr)replacer()rrArfs rgdecimal_formatterz?FloatArrayFormatter._value_formatter..decimal_formatters'%~a((00dlAFFFrict|r)t|kr |SdSjS)Ng)r,absr])r@rErfr<s rgrz7FloatArrayFormatter._value_formatter..formattersLU|| #u:: )),,U333,,S111{"ri)rtr()rfrtr<rrArEs``` @@rg_value_formatterz$FloatArrayFormatter._value_formatters  ,L  ;        ; ; ; ; ; <3   G G G G G G G!/   $ $ # # # # # # #ri np.ndarrayc dd dd j jjjSjrt d  nd fd }j9jr*jd urd }nd}t|jj }n j}nfd}||}js|St|dkr(td|D}|j dzk}nd}tj j}|dk}|dj zk|dkz} | s|r6|r4jd urd}nd}t|jj }||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array rr=rrr]r^ct|}tjfdt||D|j}|S)Nc4g|]\}}|s |nSr{r{)r~valr rr]s rgrzWFloatArrayFormatter.get_result_as_array..format_with_na_rep..s>Q+,7IIcNNNri)r+r)arrayraravelreshaper2)rrr]mask formatteds `` rgformat_with_na_repzCFloatArrayFormatter.get_result_as_array..format_with_na_reps<.format_complex_with_na_reps'&////11K'&////11K#' #4#4d;6G6GyIM=@  >> @ @9Xx' @w @!((38888 @!((IIh,?,?)K)K&)K)K)KLLLL @%.Yx%8%8%>%>%@%@N%0055L%,,-I-I-I-IJJJJ%,,-J-J-J-J-JKKKK!((F)>)>V)>)>)>????8M**226<@@ @riNzdisplay.chop_thresholdcf| }jdkr djznj}j}t |}|r|||}n |||}jrC|rt |j}nt|j}tj |dS|S)NrKrobjectr) rHrNr]rr"r_trim_zeros_complexr(_trim_zeros_floatr)asarray) rtrr]r is_complexrrerSrfr<s rgformat_values_withzCFloatArrayFormatter.get_result_as_array..format_values_withs--lIFFI+/,&*@*@S4;&&dkF[F)&11J G33FIvNN++FIvFF :E0FFFF.vt|DDFz&9999MriTz{value: .{digits:d}f}z{value:.{digits:d}f})rcj|zSr)rt)r@rfs rgr&z9FloatArrayFormatter.get_result_as_array..&s):U)Brirc34K|]}t|VdSrrrs rgrz:FloatArrayFormatter.get_result_as_array..2s(::AQ::::::riFg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr=rrr]r^)rrr]rrrtrr rrrnrr)rGr) rfrmfmt_strrtformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrerSr<s ` @@@rgget_result_as_arrayz'FloatArrayFormatter.get_result_as_arrays      A A A A: > %%%dk4>4;OO O   "#;<$+FFFL11,?? rirrcDt|Sr)r{ryrws rgr z#FloatArrayFormatter._format_stringsHsD,,..///rirNN)rtr$r<r=r`r)r`rIr)rrrrhrHryr rrs@rgrrs ) ) ) ) ) )04"&66666p~ ~ ~ ~ @00000000rirceZdZddZdS)rr`rrc`|jdurd}nd}|jp|fd|jD}|S)NFc2|d|S)Nr#rrrs rgr&z3IntArrayFormatter._format_strings..Oshhooo&:&:ric2|d|S)Nz drrrs rgr&z3IntArrayFormatter._format_strings..Qsii&6&6&6&;&;ric&g|] }|Sr{r{r~rrs rgrz5IntArrayFormatter._format_strings..Ss!888qiill888ri)rrr)rf formatter_strrrs @rgr z!IntArrayFormatter._format_stringsMsP   & &::MM;;MN3m 8888DK888 riNrrrrr r{rirgrrLs(rirc.eZdZ d dfd Zdd ZxZS)rrNr3np.ndarray | Series | DatetimeIndex | DatetimeArraynat_repr^rrar`c Xtj|fi|||_||_dSr)rrhrr)rfrrrrrs rgrhzDatetime64Formatter.__init__Xs9 **6*** &rirrc j}t|tst|}j"t jrfd|DS|jjj}| S)z&we by definition have DO NOT have a TZNc:g|]}|Sr{)rrs rgrz7Datetime64Formatter._format_strings..ks%666!DNN1%%666ri)r]r) rrr7rr:_data_format_native_typesrrtolist)rfrrs` rgr z#Datetime64Formatter._format_stringscs&-00 +"6**F > %(4>*B*B %6666v666 6\66!>  fk * * '//11EEJv&&E!  *;;*LL,L1    riNrrr{rirgrrss(rir percentilesnp.ndarray | Sequence[float]c tj|}t|r0tj|dkrtj|dkst dd|z}|t}tj||}tj|r&|t}d|DStj |}|ddkr|dnd}|ddkr d|dz nd}tj tj tj tj|||t }td|}tj|t" }||tt||<|||t||<d |DS) a Outputs rounded and formatted percentiles. Parameters ---------- percentiles : list-like, containing floats from interval [0,1] Returns ------- formatted : list of strings Notes ----- Rounding precision is chosen so that: (1) if any two elements of ``percentiles`` differ, they remain different after rounding (2) no entry is *rounded* to 0% or 100%. Any non-integer is always rounded to at least 1 decimal place. Examples -------- Keeps all entries different after rounding: >>> format_percentiles([0.01999, 0.02001, 0.5, 0.666666, 0.9999]) ['1.999%', '2.001%', '50%', '66.667%', '99.99%'] No element is rounded to 0% or 100% (unless already equal to it). Duplicates are allowed: >>> format_percentiles([0, 0.5, 0.02001, 0.5, 0.666666, 0.9999]) ['0%', '50%', '2.0%', '50%', '66.67%', '99.99%'] rrz/percentiles should all be in the interval [0,1]dcg|]}|dzS%r{r}s rgrz&format_percentiles..s%%%AC%%%riN)to_beginto_endrhcg|]}|dzSrr{r}s rgrz&format_percentiles..s ! ! !AG ! ! !ri)r)rkr&rLrWroundastyperiscloser^uniquefloorlog10rediff1dr empty_likerg)rpercentiles_round_typeint_idxout unique_pctsrrprecs rgformat_percentilesrsD*[))K [ ) )LvkQ&''LvkQ&''L JKKK #K(..0077<<j/==G vg&$++C00%%%%%%)K((K!,Q!!3!3{1~~H&1"o&;&;S;r? " "F H  ;&QQQRRSS   fSkk D q$<.s4 wK   ric&t|S)N)r)rrs rgr&z'get_format_datetime64..s+Aw???rir{)rrrs ``rgget_format_datetime64rs? @      @????ri*np.ndarray | DatetimeArray | DatetimeIndexct|tjr|jdkr|}t |}|r|pdS|S)z6given values and a date_format, return a string formatrz%Y-%m-%d)rr)r/ndimrOr)rridos rg!get_format_datetime64_from_valuesrsW&"*%% &+//   C )(j( riceZdZddZdS)rr`rrct|j}|jt}|jpt ||jfd|D}|S)zwe by definition have a TZ)rc&g|] }|Sr{r{rs rgrz9Datetime64TZFormatter._format_strings...s!333qiill333ri)rrrrgrrr)rfrrrrs @rgr z%Datetime64TZFormatter._format_strings'snDK((##F++N &; T-' ' ' 4333F333 riNrrr{rirgrr&s(      rirc.eZdZ ddfd Zdd ZxZS)rrFrnp.ndarray | TimedeltaIndexrr^boxr\r`rac Xtj|fi|||_||_dSr)rrhrr)rfrrrrrs rgrhzTimedelta64Formatter.__init__4s6 **6*** rirrcz|jp t|j|j|jfd|jDS)N)rrc&g|] }|Sr{r{rs rgrz8Timedelta64Formatter._format_strings..Cs!222 ! 222ri)rget_format_timedelta64rrr)rfrs @rgr z$Timedelta64Formatter._format_strings?sLN &< K48' ' ' 3222dk2222rirF)rrrr^rr\r`rarrrs@rgrr3s^       33333333rirF,np.ndarray | TimedeltaIndex | TimedeltaArray str | floatrc |tj}|tk}d}||zdk}tj||}|dk}|rd nd  fd} | S)z Return a formatter function for a range of timedeltas. These will all have the same format argument If box, then show the return in quotes l"R:rNlongc|t|rt|rSt|tst|}|}rd|d}|S)Nr')r'r+rr _repr_base)rrrrrs rgrz*get_format_timedelta64.._formatteresm 919$q''9N!Y'' ! AV,,  #"]]]F ri)viewr)int64rrr) rrrrr one_day_nanos not_midnightbothrrrs `` @rgrrFsRX&&J D(O!M -2L >/< 8 8D aI        rirrrTextAdjustment | NonecRt|dks|dkr|S|tn|tfd|D|t|tdkrd fd fd |D}|| }|S) NrrLc3BK|]}|VdSrr)r~r adjustments rgrz$_make_fixed_width..s/55*..##555555rir rr^r`cl0dk|kzr|ddz dz}|S)Nrrr)rrconf_maxrs rgjustz_make_fixed_width..justsG  1 !2!2W!<= -m! m$u,ric&g|] }|Sr{r{)r~rrs rgrz%_make_fixed_width..s!(((1ttAww(((rir)rr^r`r^)rnrrrrN) rrNrrrrrrrs @@@@rgrrus  7||qGu,, {#%%  5555W55555Ggw''011H( 2 2 )((((((G   w  ? ?F Mri str_complexesrIc gg}}|D]w}tjd|}|d|dd|d|ddxt |}t ||z|}t |dkrgSt d|Ddz fd t|d|||dD}|S) z Separates the real and imaginary parts from the complex number, and executes the _trim_zeros_float method on each of those. z([j+-])rdNrc34K|]}t|VdSrr)r~parts rgrz&_trim_zeros_complex..s(;;dD ;;;;;;rircRg|]#\}}||dz|dddzdz$S)rrN>rVr{)r~real_ptimag_pt padded_lengths rgrz'_trim_zeros_complex..sc GW  !*  QRR[ += + + + ,  ri)rerrrrnrjrra) rr( real_part imag_partrtrimmedn padded_partspaddedrs @rgriris, ryI 22 (:q))"..///B001111 MA$Y%:GDDL <A ;;l;;;;;a?M !$L!$4l1226F G G F Mri str_floatcd|d}|dr|dz }|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)rs rgr$r$s=   %%I#S ri str_floatsnp.ndarray | list[str]c|}tjddd fd d fd }||rfd |D}||fd |D}|S) z Trims the maximum number of trailing zeros equally from all numbers containing decimals, leaving just one if necessary. z^\s*[\+-]?[0-9]+\z[0-9]*$r`r\c2tj|duSr)rmatch)r number_regexs rgis_number_with_decimalz1_trim_zeros_float..is_number_with_decimalsx a((44rirrcxfd|D}t|dkotd|DS)z Determine if an array of strings should be trimmed. Returns True if all numbers containing decimals (defined by the above regular expression) within the array end in a zero, otherwise returns False. c*g|]}| |Sr{r{r~rrs rgrz:_trim_zeros_float..should_trim..s*BBB(>(>q(A(AB1BBBrirc3@K|]}|dVdS)rNrrs rgrz9_trim_zeros_float..should_trim..s,'I'IA 3'I'I'I'I'I'Iri)rnrL)rnumbersrs rg should_trimz&_trim_zeros_float..should_trimsLCBBBfBBB7||aIC'I'I'I'I'I$I$IIric>g|]}|r |ddn|S)Nrr{r s rgrz%_trim_zeros_float..s6OOO!33A66=1SbS66AOOOric^g|])}|r|r|dzn|*S)rr )r~rr(rs rgrz%_trim_zeros_float..sR *)!,,KG1D1DKC!rir)rrr`r\)rcompile)rr(rrrrrs ` @@rgrjrjsG:C7CCCDDL555555 J J J J J J +g  POOOOwOOO +g  PF Mrirr3cdt|trtj|jS|jduSr)rr4com any_not_nonerr)rs rgrGrGs1%$$&--z%%riceZdZdZidddddddd d d d d ddddddddddddddddddd d!d"d#Z d1d2d,Zd3d0Zd$S)4 EngFormatterzl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter iriziairipiriur rrdrrrpr  GrTPEZYNFaccuracyruse_eng_prefixr\r`rac"||_||_dSrr'r()rfr'r(s rgrhzEngFormatter.__init__ s! ,rinumfloatr^c,tt|}tj|rdStj|rdSd}|dkrd}| }|dkrGtt t j|dz dz}ntd}|t|j }| t|j }t |}|j r|j |}n|dkrd| d}nd |d}||zd |zz }|j d }n d |j dd}|||} | S)a Formats a number in engineering notation, appending a letter representing the power of 1000 of the original number. Some examples: >>> format_eng = EngFormatter(accuracy=0, use_eng_prefix=True) >>> format_eng(0) ' 0' >>> format_eng = EngFormatter(accuracy=1, use_eng_prefix=True) >>> format_eng(1_000_000) ' 1.0M' >>> format_eng = EngFormatter(accuracy=2, use_eng_prefix=False) >>> format_eng("-1e-6") '-1.00E-06' @param num: the value to represent @type num: either a numeric value or a string that can be converted to a numeric value (as per decimal.Decimal constructor) @return: engineering formatted string rWinfrrrrzE-02dzE+rqNz{mant: g}{prefix}z{mant: .r#z f}{prefix})mantprefix)r r^is_nan is_infinitermathrrrr ENG_PREFIXESr`r(r'r) rfr+dnumsignpow10 int_pow10r1r0 format_strrRs rg__call__zEngFormatter.__call__s(s3xx   >$   5  t $ $ 5 !88D5D 199C 4::<>> df = pd.DataFrame([1e-9, 1e-3, 1, 1e3, 1e6]) >>> df 0 0 1.000000e-09 1 1.000000e-03 2 1.000000e+00 3 1.000000e+03 4 1.000000e+06 >>> pd.set_eng_float_format(accuracy=1) >>> df 0 0 1.0E-09 1 1.0E-03 2 1.0E+00 3 1.0E+03 4 1.0E+06 >>> pd.set_eng_float_format(use_eng_prefix=True) >>> df 0 0 1.000n 1 1.000m 2 1.000 3 1.000k 4 1.000M >>> pd.set_eng_float_format(accuracy=1, use_eng_prefix=True) >>> df 0 0 1.0n 1 1.0m 2 1.0 3 1.0k 4 1.0M >>> pd.set_option("display.float_format", None) # unset option rN)rrr*s rgset_eng_float_formatr=Os&n%|Hn'M'MNNNNNrirdrsentinelbool | object | strlist[dict[int, int]]c2t|dkrgSdgt|dz}g}|D]c}d}i}t|D]#\}}||r||krd||<||z ||<|}$t||z ||<||d|S)a For each index in each level the function returns lengths of indexes. Parameters ---------- levels : list of lists List of values on for level. sentinel : string, optional Value which states that no new index starts on there. Returns ------- Returns list of maps. For each level returns map of indexes (key is index in row and value is length of index). rTF)rnrr) rr>controlrr last_indexlengthsrkeys rgget_level_lengthsrFs$ 6{{a fs6!9~~%G F &&  FAsqz cXoo" &'*n # !%jj:5  g MriWriteBuffer[str]linesctd|Dr d|D}|d|dS)z Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. c3@K|]}t|tVdSr)rr^rs rgrz#buffer_put_lines..s, - -!:a   - - - - - -ric,g|]}t|Sr{rrs rgrz$buffer_put_lines..s'''AQ'''rirmN)rrr)rYrHs rgbuffer_put_linesrLsZ - -u - - ---('''''IIdiiri)r`r)r`rr{)rr^rYrrrr`rr)rYrrrr`r) NrWNNrLrTNN)rrrrrtr$r]r^rrrrrNr^r(r^rr&rerrrr`rr)rrr`rr)rrr`r\)r)rrrr^r`r^r)rrrr^rrr`r^)rr\rr^rrr`r)rrrrr`rr)rrrrrr\r`r)rLNN) rrrrNr^rrrrr`rr)r)rrIr(r^r`rr)rr^r`r^)rrr(r^r`rr)rr3r`r\)rF)r'rr(r\r`ra)rd)rrr>r?r`r@)rYrGrHrrr`ra)r __future__rcollections.abcrrrrr contextlibr csvr r r(r functoolsr iorr4rshutilrtypingrrrrrr unicodedatarnumpyr)pandas._config.configrr pandas._libsrpandas._libs.missingrpandas._libs.tslibsrrrrrr pandas._libs.tslibs.nattyper!pandas.core.dtypes.commonr"r#r$r%r&r'pandas.core.dtypes.dtypesr(r)r*pandas.core.dtypes.missingr+r,pandas.core.arraysr-r.r/pandas.core.arrays.string_r0pandas.core.baser1pandas.core.commoncorecommonrpandas.core.constructionr2pandas.core.indexes.apir3r4r5r6pandas.core.indexes.datetimesr7pandas.core.indexes.timedeltasr8pandas.core.reshape.concatr9pandas.io.commonr:r;rr<pandas._typingr=r>r?r@rArBrCrDrErFrGpandasrHrIrJ__annotations___VALID_JUSTIFY_PARAMETERSrTrVrrrrrrrrrrrurrrrrrrrrrrrrrrrir$rjrGrr=rFrLr{rirgros #"""""&%%%%% $$$$$$)((((( ######0/////   322222)))))) 222222 877777999999------'&&&&&                           99999v =&=&=&=&=&=&=&=&@]$]$]$]$]$]$]$]$@         $9$9$9$9$9n$9$9$9N    B####L}}}}}}}}@ZZZZZZZZ~/3      DHMMMMMP,0"!%*.O O O O O dmmmmmmmm`F0F0F0F0F0/F0F0F0R-#####/###83>B"B"B"B"J2"      KO @ @ @ @ @         /   333330333*!,,,,,b!% DB    8;!!!!!H&&&&]]]]]]]]@7O7O7O7O7Ov24(((((V       ri