2iFUdZddlmZddlmZmZmZmZmZddl m Z ddl m Z ddl mZddlmZddlmZdd lZdd lZdd lmZdd lmZmZmZmZdd lZdd lmZm Z dd l!m"Z"ddl#m$Z$ddl%m&Z&m'Z'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3ddl4m5Z5m6Z6m7Z7ddl8m9Z9m:Z:ddl;mZ>m?Z?ddl@mAZAdd lBmCcmDZEddlFmGZGmHZHmIZImJZJddlKmLZLddlMmNZNddlOmPZPmQZQddlRmSZSer$ddlTmUZUmVZVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`ddlambZbmcZcdZddeed <d!Zfd"Zgdeed#<Gd$d%ZhdNd&ZidNd'ZjGd(d)ZkGd*d+Zl dO dPd,Zme dQ dRd-Zn dS dTd.ZoGd/d0ZpGd1d2epZqGd3d4epZrGd5d6epZsGd7d8epZt dUd9ZudVd:ZvdWdXd;Zw dY dZd<Zx dY d[d=ZyGd>d?esZzGd@dAepZ{ d\ d]dBZ| d^ d_dCZ}d`dadDZ~dbdEZ d` dcdFZdddGZGdHdIZe,dJdedfdKZ dg dhdLZdidMZy )jz Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations)Callable GeneratorHashableMappingSequence)contextmanager) QUOTE_NONE)Decimal)partial)StringION)get_terminal_size) TYPE_CHECKINGAnyFinalcast) get_option set_option)lib)NA)NaT Timedelta Timestamp)NaTType) set_module)is_complex_dtypeis_float is_integer is_list_likeis_numeric_dtype is_scalar)CategoricalDtypeDatetimeTZDtypeExtensionDtype)isnanotna) Categorical DatetimeArrayExtensionArrayTimedeltaArray) PandasObject)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)check_parent_directorystringify_path)printing) ArrayLikeAxesColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelSequenceNotStrStorageOptions 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``. 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_docstringc xeZdZdZdddddddddd d dZd dZdd Zdd Zdd Zy)SeriesFormatterz\ Implement the main logic of Series.to_string, which underlies Series.__repr__. TNaNFN) lengthheaderindexna_repname float_formatdtypemax_rowsmin_rowsc ||_t|_||_||_||_||_||_| |_| |_ | td}||_ ||_ tj|_|j!y)Ndisplay.float_format)seriesr bufrUrTrRrQrSrXrYrrVrWr4get_adjustmentadj _chk_truncate) selfr\rQrRrSrTrUrVrWrXrYs O/var/www/html/acx/venv/lib/python3.12/site-packages/pandas/io/formats/format.py__init__zSeriesFormatter.__init__s :          %&<=L( **, c||j}|j}|xrt|j|kD}|j}|rt t |}|r t ||}|dk(r|}|jd|}n`|dz}t|}tjtj|tj||z |g}|j|}||_ nd|_ ||_ ||_ y)N)rYrXlenr\rintminilocnphstackarange tr_row_num tr_seriesis_truncated_vertically)rarYrXrqr\row_num_len_slices rbr`zSeriesFormatter._chk_truncates ====#+"LDKK0@80K "C*Hx21}"Yh/"a-6{YYw'4'>4)HI V,%DO"DO'>$rdcN|jj}d}|jj}t|tt t fr|j|d|jz }|jdur(|&|r|dz }tj|d}|d|z }|jdus|jd k(r.|jr"|r|dz }|d t|jz }|jdurQ|jEt|j jd d}|r"|r|dz }|d tj|z }t|j jt"r0|j j$j'}|r|d z }||z }t)|S)NzFreq: Fz,    ) escape_charszName: TtruncatezLength: rUzdtype: rz)r\rUrS isinstancer0r.r1freqfreqstrr4 pprint_thingrQrqrhrWgetattrrpr"_values_get_repr_footerstr)rarUfooterrS series_name dtype_name level_infos rb _get_footerzSeriesFormatter._get_footers{{ !! u}k>J K & u}}o. .F 99E !d&6$"//CUVK {m, ,F ;;$  KK: %$*F*F$ T[[!1 23 3F ::U "tzz'= !5!5vtDJdNFGH$9$9*$E#FGG dnn**,< =//@@BJ$ j F6{rdct|jjd|j|j|j S)N)rVrT leading_space) format_arrayrprrVrTrSras rb_get_formatted_valuesz%SeriesFormatter._get_formatted_values,s6 NN " " **;;**   rdc|j}|j}t|dk(r%t|jj d|dS|j }t|}t|trJ|jdd}tj}|jdg|jd}n|jd}|j!}|j"rd}|j$} t't(| } |j*j|| d z } | d kDrd } nd } |j*j-| g| d d} |j/| |z| |j/| d zd|j r#|j*jd g|d d|g} n|j*jd |} |j0r |r |ddz| z} |r| d|zz } t3dj5| S)Nrz([], )T) include_namessparsifyrgrz include_namerf...z..rFmoderv)rprrhtyper\__name__rS _has_namesr}r- _format_multir4r^adjoinsplit _format_flatrrqrorrir_rGinsertrRrjoin) rar\rrS have_header fmt_indexr_ fmt_values n_header_rowsrrwidthdot_strresults rb to_stringzSeriesFormatter.to_string5s!!# v;! 4;;'001vha@ @  ' eZ (++$+NI))+C" 11y177=I***=I//1  ' 'MooG3(GHHLLGaK!89Eqyhh&&y%h&GJG   g 5w ?   Wq[" - ::$TXX__QE)AB-)DEFXX__Q 3F ;;;q\D(61F  dVm #F2776?##rd)r\rBrQ bool | strrRboolrSrrTrrUrrV str | NonerWrrX int | NonerYrreturnNonerrrrr list[str]) r __module__ __qualname____doc__rcr`rrrrdrbrOrOs"#'##     ! @?>(T +$rdrOcddlm}tdr|j\}}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. 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)rXrYmax_cols max_colwidthshow_dimensions line_width)pandas.io.formatsrrget_console_size)rr_s rbget_dataframe_repr_paramsrcsa*-.002 A 121245"#9:%&?@  rdct\}}td}|dk(r|n|}|dk(r|n td}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. 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 rrrTr)rUrWrYrXrQ)rr)rheight max_rows_optrXrYs rbget_series_repr_paramsrs^&'ME601L%*v H%*v ;M0NH67  rdceZdZdZerendZeeezz Z d& d'dZd(dZed)dZ ed)dZ ed)dZ ed)d Z ed*d Z ed)d Zed)d Zed)d Zed)dZed+dZd,dZ d-dZd.dZd/dZd0dZd1dZd1dZd2dZd)dZd)dZd)dZd+dZd3dZd3dZ d3dZ!d(dZ"d4d Z#d5d!Z$d6d"Z%d7d#Z&d8d$Z' d9d%Z(y):DataFrameFormatterz Class for processing dataframe formatting options and data. Used by DataFrame.to_string, which backs DataFrame.__repr__. rvNc|||_|j||_|j||_||_||_||_|j||_ |j||_ |j| |_ |j| |_| |_||_||_||_| |_| |_||_||_|j1|_|j5|_|j|_|j;t=j>|_ yN)!frame_initialize_columnscolumns_initialize_colspace col_spacerRrSrT_initialize_formatters formatters_initialize_justifyrG_validate_float_formatrV_initialize_sparsifyrshow_index_namesdecimal bold_rowsescaperXrYrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framer|r4r^r_)rarrrrRrSrTrrGrVr index_namesrXrYrrrrrs rbrczDataFrameFormatter.__init__s * //8 229=   55jA//8  77 E11(; + "       .#99;#99;   **,rdc|j}|jr-|j|j}|j d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrS_get_formatted_indexrr)rastrcols str_indexs rb get_strcolszDataFrameFormatter.get_strcolss@113 ::11$--@I NN1i (rdc\|jduxs|jdk(xr |jS)NTr|)r is_truncatedrs rbshould_show_dimensionsz)DataFrameFormatter.should_show_dimensionss3##t+  J . D43D3D rdcHt|jxs |jSr)ris_truncated_horizontallyrqrs rbrzDataFrameFormatter.is_truncatedsD22Rd6R6RSSrdctt|jxr"t|j|jkDSr)rrrhrrs rbrz,DataFrameFormatter.is_truncated_horizontallys,D((Wc$,,.?$BVBV.VXXrdctt|jxr"t|j|jkDSr)rrrhrrs rbrqz*DataFrameFormatter.is_truncated_verticallys+D((Uc$**o@T@T.TVVrdctdt|jdt|jjdS)Nz [z rows x z columns])rhrrrs rbdimensions_infoz"DataFrameFormatter.dimensions_infos0s4::'xDJJ4F4F0G/H RRrdc@t|jjSr)rrrSrs rbhas_index_namesz"DataFrameFormatter.has_index_namess$****++rdc@t|jjSr)rrrrs rbhas_column_namesz#DataFrameFormatter.has_column_namess$**,,--rdcZt|j|j|jfSr)allrrSrrs rbshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namess$D(($**d6K6KLMMrdcZt|j|j|jfSr)rrrrRrs rbshow_col_idx_namesz%DataFrameFormatter.show_col_idx_namess$D))4+@+@$++NOOrdct|jxst|jt|jSr)rjrXrhrrs rbmax_rows_displayedz%DataFrameFormatter.max_rows_displayed s(4==3C OS_EErdc | tdS|S)Nzdisplay.multi_sparser)rars rbrz'DataFrameFormatter._initialize_sparsifys  45 5rdc|iSt|jjt|k(st|tr|St dt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rhrrr}dict ValueError)rars rbrz)DataFrameFormatter._initialize_formatterssu  I ## $J 7:jRV;W $S_$56//24::3E3E/F.GqJ rdc | tdS|S)Nzdisplay.colheader_justifyr)rarGs rbrz&DataFrameFormatter._initialize_justify s ?9: :Nrdct|!t|}|j||_|S|jjSr)r/rr)rarcolss rbrz&DataFrameFormatter._initialize_columns&s7  (DD)DJK::%% %rdc|i}|St|ttfr?d|i}|jtj |j j||St|trE|jD].}||j jvs|dk7s"td||}|St|j jt|k7r8tdt|dt|j jdt t|j j|d}|S)Nrvz,Col_space is defined for an unknown column: zCol_space length(rrTstrict) r}rirupdaterfromkeysrrrkeysrrhzip)rarrcolumns rbrz'DataFrameFormatter._initialize_colspace.s2  F$ # C: .)_F MM$-- (:(:IF G  7 +#..* !3!33" $FvhO  F 4::%%&#i.8 'I'78336tzz7I7I3J2K1N#djj00)DIJF rdc|js |jSt\}}|j|r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr_is_screen_narrow)rarrs rbrz(DataFrameFormatter._calc_max_cols_fittedFsA##%== $&q  ! !% (L== rdc|jrPt\}}|jdk(r||jz S|j |r|}n|j}n |j}|j |S)z,Number of rows with data fitting the screen.r)rrrX_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rarrrXs rbrz(DataFrameFormatter._calc_max_rows_fittedQsr    !)+IAv}}! B B DDD$$V,!==}}H$$X..rdc~|r:t|j|kDr"|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 )rhrrYrj)rarXs rbrz#DataFrameFormatter._adjust_max_rowsds2 DJJ(* t}}h7rdcTt|jdk(xs|jdk(S)z/Check if the output is to be shown in terminal.r)rrrXrs rbrz"DataFrameFormatter._is_in_terminalrs$DMMQ&<$--1*<==rdczt|jdk(xr"t|jj|kDSNr)rrrhrr)ra max_widths rbrz$DataFrameFormatter._is_screen_narrowvs/DMMQ&N3tzz/A/A+BY+NOOrdcft|jdk(xrt|j|kDSr)rrXrhr)ra max_heights rbrz#DataFrameFormatter._is_screen_shortys(DMMQ&G3tzz?Z+GHHrdcd}d}||z}|jr&|t|jjz }|jr|dz }|S)z?Get number of rows occupied by prompt, dots and dimension info.rf)rrhr splitlinesrR)radot_row prompt_rownum_rowss rbrz0DataFrameFormatter._get_number_of_auxiliary_rows|sR Z'    D00;;=> >H ;; MHrdcv|jr|j|jr|jyy)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyrq_truncate_verticallyrs rbr|zDataFrameFormatter.truncates3  ) )  ' ' )  ' '  % % ' (rdcr|jJ|jdz}|dk\rt|jj}t j t j |t j ||z |g}|jjdd|f|_t|jttfrlg|jd||j| d|_ ||_ytt|j}|jjddd|f|_||_y)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num Nrgrf)rrhrrrlrmrnrkr}rlisttuplerrir tr_col_num)racol_numrsrts rbr!z)DataFrameFormatter._truncate_horizontallys ##///&&!+ a<t}},,-DYY ' 2BIIdWnd4STUF MM..q&y9DM$//D%=9#__Xg.#__gXY/# '3 .G MM..q(7({;DM&rdc|jJ|jdz}|dk\r|t|j}tjtj |tj ||z |g}|jj ||_||_ ytt|j}|jj d|ddf|_||_ y)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrgrf) rrhrrlrmrnrkrrirXro)rarrrsrts rbr"z'DataFrameFormatter._truncate_verticallys##///&&!+ a<t}}%DYY ' 2BIIdWnd4STUF MM..v6DM"3 .G MM..xx{;DM!rdc g}tjsjstjD]m\}}j |}t |j tjj|dj}|j|o|Stjrtttj_tjtj k7r8t#dtj dtjdjDcgc]}|g}}nj%j}j&r|D]}|jdtjD]\}}||}t)tjj|dgfd|D} j |}t |j | j}t)gfd |D| } jj || j }|j||z|Scc}w) Nr)stringsrGminimumr_zWriting z cols but got z aliasesrvc3TK|]}jj|!ywrr_rh.0xras rb z@DataFrameFormatter._get_strcols_without_index..s0RQa0R%()r+r_c3TK|]}jj|!ywrr-r.s rbr1z@DataFrameFormatter._get_strcols_without_index..s@DHHLLO@r2r)rrR enumerater format_col_make_fixed_widthrGrirgetr_appendrr$rrhrr_get_formatted_column_labelsrmax) raricrlabel str_columnsr0cheaderheader_colwidthmax_lens ` rbrz-DataFrameFormatter._get_strcols_without_indexs,#%DKK(!$--0 +1!__Q/ .& LL 2 21a 89  z* +N  $tCy$++6DK4;;3t||#44 s4<<012"4;;/0:15 r;rWs rbr9z/DataFrameFormatter._get_formatted_column_labelss=-- gz *!//e/TK}}[!1-k: ,/,JT,JKq47KKK"..E.BK&/ TZZ%6%6uE&   "Az5 ..q16Fu6M!G K L s "C091C5c ,|jjDcic]\}}|tt|}}}|j}|j }|j d}t|tr)|j|j|j|}n|j|j|g}|D cgc]=} ttt| d|j!dd|j"?}} |j"j$dg|j'd } |j(r'|j+D cgc] } t-| } } ndg|j.z} |j0r| | zS| Scc}}wcc} wcc} w) N __index__)rrrE)rrErDrvr)rGr+r_rfrz)ritemsrrirSrrDr}r-rrrrr%r6r$r7r_rrr_get_column_name_listrnlevelsrR) rarkvrrSrfmtrr0adjoined col_headers rbrz'DataFrameFormatter._get_formatted_index!s}261E1E1GHAQS! _H H --!!+. eZ (++"55,I""0G0GSV"WI   !GVY]]2q5Itxx   #488??11y177=  " "*.*D*D*FGQ#a&GJG/J ;;( (OII  HsFAF Fcg}|jj}t|tr$|j d|j D|S|j |jdn |j|S)Nc3(K|] }|dn| yw)Nrvr)r/rUs rbr1z;DataFrameFormatter._get_column_name_list..NsP$t|5Psrv)rrr}r-extendnamesr8rU)rarZrs rbrPz(DataFrameFormatter._get_column_name_listJs_ "**$$ gz * LLP'--P P  LLw||3 F rdc| t|r|St|tr$d|vr|S |jd}|jSt d#tt t f$r}t d||d}~wwxYw)z| Validates and processes the float_format argument. Converts new-style format strings to callables. N%g?z Invalid new-style format string z)float_format must be a string or callable)callabler}rformatrKeyError IndexError)rarTres rbrz)DataFrameFormatter._validate_float_formatSs ;(3-J c3 cz X 3A::%DEE#Hj9X$'Gw%OPVWWXsAA7#A22A7)NNTTrPNNNNTNNNF.FT)&rrAr Axes | NonerColspaceArgType | NonerRzbool | SequenceNotStr[str]rSrrTrrFormattersType | NonerGrrVFloatFormatType | Noner bool | NonerrrXrrYrrrrrrrrrrrrr)rlist[list[str]]rrr)rri)rrgrr)rrerr<)rGrrr)rrcrr,)rrdrr8)rr)rXrrrr)r;rirr)r; str | intrCallable | None)rrArrh)rrArr)rzlist[Hashable])rTrfrrf))rrrrrCrMrcrpropertyrrrrqrrrrrrrrrrrrrrrrrrr|r!r"rr5rDr9rrPrrrdrbrrs !gbG "222G $,0-1,0"/3 $ ###&+'------* -- + --  ----*----------------- $!--"#--$%--&'--( )--^   TTYYWWSS,,..NNPPFF /    &0 !/& >PI ('4"$-^   02'RF)F FrdrceZdZdZddZ d d dZ d d dZ d d dZy)DataFrameRenderera?Class for creating dataframe output in multiple formats. Called in pandas.core.generic.NDFrame: - to_csv - to_latex Called in pandas.DataFrame: - to_html - to_string Parameters ---------- fmt : DataFrameFormatter Formatter with the formatting options. c||_yr)rT)rarTs rbrczDataFrameRenderer.__init__|s rdNcddlm}m} |r| n|} | |j||||} | j } t | ||S)uC Render a DataFrame to an 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 or bool When an integer value is provided, it sets the border attribute in the opening tag, specifying the thickness of the border. If ``False`` or ``0`` is passed, the border attribute will not be present in the ``
`` tag. The default value for this parameter is governed by ``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)classesbordertable_id render_linksr]encoding)pandas.io.formats.htmlrqrrrTrsave_to_buffer) rar]rxrsnotebookrtrurvrqrrKlasshtml_formatterstrings rbto_htmlzDataFrameRenderer.to_htmlsPL &.!= HH%   ))+f#AArdcrddlm}||j|}|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)rrw)pandas.io.formats.stringrrTrrz)rar]rxrrstring_formatterr~s rbrzDataFrameRenderer.to_strings5( =*488 K!++-f#AArdcDddlm}| d}t}nd}|did|d| d|d |d |d |d |d |d|d|d| d| d| d| d|d|d|j}|j |r4t |tsJ|j }|j|Sy)z; Render dataframe as comma-separated file. r) CSVFormatterNTF path_or_buflineterminatorseprxerrors compressionquotingr index_labelr chunksize quotechar date_format doublequote escapecharstorage_optionsrEr)pandas.io.formats.csvsrr rTsaver}getvalueclose)rarrxrrrrrrrrrrrrrrrcreated_buffer csv_formattercontents rbto_csvzDataFrameRenderer.to_csvs, 8  !N"*K"N$ # )      $    $      $ $ " ,! "hh# &  k84 44!**,G    Nrd)rTrrr)NNNFNNF)r]"FilePath | WriteBuffer[str] | Nonerxrrszstr | list | tuple | Noner{rrtzint | bool | Nonerurrvrrr)NNN)r]rrxrrrrr)NN,NNwinferN"NNNTNrN)"rz7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | NonerxrrrrzSequence[Hashable] | NonerzIndexLabel | Nonerrrr9rrrrrrrrrrrrrrrrrzStorageOptions | Nonerr)rrrrrcrrrrrdrbrnrnks  37#-1$(#"5B /5B5B+ 5B  5B " 5B5B5B 5Br37#!% B /BB B  B8PT#-1)-*1"%) $"& !%15#9L99 9 + 9 ' 99(999#99 999 !9"/#9$ %9rdrnct||5}|j|||jcdddS dddy#1swYyxYw)zQ Perform serialization. Write to buf or return as string if buf is None. )rxN) _get_bufferwriter)r~r]rxfds rbrzrz sN S8 ,  ;;;=   s#AAAc#LK| t|}n t}|d}nt|ts t dt |dr|yt|tr1t t|t|d|d5}|dddytd#1swYyxYww) 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.rrrv)rxnewlinez1buf is not a file name and it has no write method) r3r r}rrhasattrr2open TypeError)r]rxfs rbrrs S!j S !LMMsG C s3x( #sXr : a G   KLL  sA=B$?BB$B!B$c tj|jdrt} t t |}nt |jtrt} t t |}ntj|jdrt} t t|}nut |jtrt} nTtj|jdrt} n-tj|jdrt} nt} |d}| t!d}| t!d}| |||||||||| |  } | j#S) a Format an array for printing. Parameters ---------- values : np.ndarray or ExtensionArray 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._get_values_for_csv), we don't want the leading space since it should be left-aligned. fallback_formatter Returns ------- List[str] Mmfciu r[display.precision) digitsrTrVrErCrGrrrfallback_formatter)r is_np_dtyperW_Datetime64Formatterrr(r}r#_Datetime64TZFormatter_Timedelta64Formatterr*r$_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) valuesrErVrTrrCrGrrrr fmt_klassfmt_objs rbrrBsR v||S)( mV, FLL/ 2* mV, s +) nf- FLL. 1, t ,' t ,& *  }!"89  ~/0!#- G    rdcneZdZ d ddZddZddZy)rNc ||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ yr) rrrTrCrErVrGrr fixed_widthrr) rarrrErTrCrVrGrrrrrs rbrcz_GenericArrayFormatter.__init__s\    "(   &*"4rdcN|j}t||jSr)_format_stringsr6rG)rars rbrz!_GenericArrayFormatter.get_results!))+  T\\::rdc  jtd}|td fd}n j}j j nXj j n?jduxrjt k7}t tjd| fd}j}t|tjs tdtj|t }|tj"t%|t't)dt+|j, z}j.}||j1}g}t3|D]\} } || r j|r|j5d || 4|| r|j5|| Q|d urd } nd } |j5| j7|| |S)Nr[rc(t|dddS)Nz .dr)_trim_zeros_single_float)r0 precisions rbz8_GenericArrayFormatter._format_strings..s )AIa=)**rdrw)r{ quote_stringscRjot|rdt|rY|y|turt tS|t us*t |tjtjfryjSt |tr t |St |S)Nrr) rTr!r%rrrr}rl datetime64 timedelta64r+)r0rEras rb_formatz7_GenericArrayFormatter._format_strings.._formats{{&9Q> %I  $ $ 0//I LL4S9SM%%/+I ){{$ +O ==x0 ffU4[uU1c$**o-F'GH I  **  )--/M dO .base_formatters5#/// Qx!q)rdcHt|r t|SjSr)r&rrT)rSras rbrz.base_formatter+s!&qs1v:t{{:rdrbcJ|jdjdS)Nrbrf)replacer)rSrras rbdecimal_formatterz?FloatArrayFormatter._value_formatter..decimal_formatter0s!%a(00dllAFFrdcnt|rt|kDr|SdSjS)Ng)r&absrT)rrra thresholds rbrEz7FloatArrayFormatter._value_formatter..formatter9s6U|u: ),U33,S11{{"rd)rVr)rarVrrErrs``` @@rb_value_formatterz$FloatArrayFormatter._value_formatter sZ  ,,L   ; <<3  G!/   $ $ #rdct dd dd j( jjjSjr t d nd fd}j Njr5j durd}nd}t|jj }nj }nfd }||}js|St|d kDr%td |D}|jd zkD}nd}tjj}|dkDj}|dj zk|d kDzj} | s|r>|r<j durd}nd}t|jj }||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array c t|}tjt|j |j dDcgc]\}}|s||n|c}}j |j }|Scc}}w)NTr)r%rlarrayr ravelreshaper)rrErTmaskvalr formatteds rbformat_with_na_repzCFloatArrayFormatter.get_result_as_array..format_with_na_repJsw.format_complex_with_na_repVsS''&///1K''&///1K#' #4d;6GyIM=@  > @9Xx'w!((38 !((Ih,?+@&)KL %.x%8%>%>%@N%005%,,x7Gq-IJ%,,xq8H-JK!((F81VHA)>?) @*88M*226<<@ @rdNzdisplay.chop_thresholdcj| }jdk(rdjzn j}j}t |}|r |||}n |||}j rF|rt |j}nt|j}tj|dS|S)NrDrIobjectrW) rrGrTrrr_trim_zeros_complexr_trim_zeros_floatrlasarray) rVrErTr is_complexrrrrars rbformat_values_withzCFloatArrayFormatter.get_result_as_array..format_values_with}s--lIFI+/,,&*@S4;;&dkkF[[F)&1J3FIvN+FIvF0FF.vt||DFzz&99MrdTz{value: .{digits:d}f}z{value:.{digits:d}f})rc"j|zSr)rV)rras rbrz9FloatArrayFormatter.get_result_as_array..s):):U)Brdrc32K|]}t|ywrrhr/r0s rbr1z:FloatArrayFormatter.get_result_as_array..s:AQ:Fg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr5rErrTrr np.ndarray)rErrTrrrVrr r^rrhr:rlrr) rarfmt_strrVformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrrrs ` @@@rbget_result_as_arrayz'FloatArrayFormatter.get_result_as_arrayDs  *2 > %%dkk4>>4;;O O   "#;>$++FL1,? rdc4t|jSr)r$r rs rbrz#FloatArrayFormatter._format_stringssD,,.//rdrNN)rVrfrz float | Nonerr)rrr)rrrrcrr r __classcell__rs@rbrrs> )04"&6,6 6  6pA F0rdrceZdZddZy)rc|jdurd}nd}|jxs|}|jDcgc] }|| }}|Scc}w)NFc*|dj|S)Nrr0r^r(s rbrz4_IntArrayFormatter._format_strings..s1ooo&:rdc*|dj|S)Nz dr(r)r(s rbrz4_IntArrayFormatter._format_strings..s2&6&6&6&;rd)rrEr)ra formatter_strrEr0rs rbrz"_IntArrayFormatter._format_stringssN    &:M;MNN3m ,0KK8qil8 89sANr)rrrrrrdrbrrsrdrcHeZdZUded< d dfd ZddZxZS)rr(rc Bt||fi|||_||_yr)rrcnat_repr)rarr.rrrs rbrcz_Datetime64Formatter.__init__s& *6* &rdc|j}|j|Dcgc]}|j|c}S|j|j|j}|j Scc}w)z&we by definition have DO NOT have a TZ)rTr)rrE_format_native_typesr.rtolist)rarr0rs rbrz$_Datetime64Formatter._format_stringssi >> %/56!DNN1%6 600<  fk *//1EJJvV4E!  **;;;;**LLLL,,LL1  rdNrrrrr4rrrdrbrrs rdrcft|dk(rgStj|}t|r0tj|dk\rtj|dks t dd|z}t |}|j|jt}tj||}tj|r(|jt}|Dcgc]}|dz c}Stj|}t |}tj|t}||jjtjt||<||j|jt||<|Dcgc]}|dz c}Scc}wcc}w)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%'] rrfz/percentiles should all be in the interval [0,1]dr\r )rhrlrr rr get_precisionroundastyperiiscloserunique empty_liker ) percentilesprecpercentiles_round_typeint_idxoutr; unique_pctss rbformat_percentilesrIsjD ;1 **[)K [ )vvkQ&'vvkQ&'JKK #K  %D(..t4;;C@jj/=G vvg$++C0!$%AC%%))K(K  %D -- 6 2Cw'--/66s;BB3GCL)//5<D t9D HHRXXbffTl+ , 3 3C 8 8D q$.}s4 wK rdct|S)N)r.)rTrSs rbrz'get_format_datetime64..s+Aw?rdr) is_dates_onlyr.rs ``rbget_format_datetime64r]vs   @?rdc eZdZUded<ddZy)rr(rc|jj}|jjt}|jxst ||j }|Dcgc] }|| }}|Scc}w)zwe by definition have a TZ)r)r_is_dates_onlyr?r rEr]r)raidorrEr0rs rbrz&_Datetime64TZFormatter._format_stringssjkk((##F+NN &; T--' -33qil3 34sA2Nrr:rrdrbrrs  rdrcBeZdZUded< d dfd ZddZxZS)rr*rc 4t||fi|||_yr)rrcr.)rarr.rrs rbrcz_Timedelta64Formatter.__init__s *6* rdc|jxs"t|j|jd}|jDcgc] }|| c}Scc}w)NF)r.box)rEget_format_timedelta64rr.)rarEr0s rbrz%_Timedelta64Formatter._format_stringssENN &< KK5' '+kk2 ! 222sAr)rr*r.rrrrr3r$s@rbrrs4    3rdrc@|j}|rdndfd}|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 Nlongc|t|r t|rSt|ts t|}|j }rd|d}|S)Nr)')r!r%r}r _repr_base)r0rrer^r.s rbr8z*get_format_timedelta64.._formattersS 91$q'N!Y'! AV, ]F rd)r`)rr.re even_daysr8r^s `` @rbrfrfs*%%I  rdc@ t|dk(s|dk(r|S|tjn|tfd|D | t|  t d kDr d fd }|Dcgc] }|| }}j | |}|Scc}w)Nrrc3@K|]}j|ywrr)r/r0 adjustments rbr1z$_make_fixed_width..s5*..#5srcV%dkDj|kDzr |ddz dz}|S)Nrrr)r0rpconf_maxrAs rbjustz_make_fixed_width..justs=  1 !2W!<=m! $u,rdr)r0rrr)rhr4r^r:rrG) r*rGr+r_rsr0rrprrrAs @@@rbr6r6s  7|qGu, {,,.  5W55Ggw'01H( 2 !((1tAw(G(   w  ?F M)s4Bc gg}}|D]^}tjd|}|jdj|dd|jdj|dd`t |}t ||z|}t |dk(rgSt d|Ddz }t|d|||dd D cgc]\} } | | dz| ddd |dzd z} } } | Scc} } w) z Separates the real and imaginary parts from the complex number, and executes the _trim_zeros_float method on each of those. z (?.s;dD ;rrfTr>r)rerr8rrhr r:r ) str_complexesr real_part imag_partr0trimmedn padded_parts padded_lengthreal_ptimag_ptpaddeds rbr r s' ryI 2 ((+Q/"./B012 MA$Y%:GDL <A ;l;;a?M !$L!$4l126Ft T  GW  !*  QR[=/) * ,  F Ms>!C$cT|jd}|jdr|dz }|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0rb)rstripendswith) str_floats rbrr s2   %I#S rdc |}tjd|ddfd d fd }||r%|Dcgc]}|r|ddn|}}||r%|Dcgc]"}|r|j|r|dzn|$}}|Scc}wcc}w) 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]*$c4tj|duSr)rzmatch)r0 number_regexs rbis_number_with_decimalz1_trim_zeros_float..is_number_with_decimal#sxx a(44rdc|Dcgc] }|s |}}t|dkDxrtd|DScc}w)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. rc3>K|]}|jdyw)rN)rrs rbr1z9_trim_zeros_float..should_trim../s'IA 3'Is)rhr)rr0numbersrs rb should_trimz&_trim_zeros_float..should_trim&sE%B(>q(A1BB7|aIC'I'I$IICs <<NrKrri)rArrayLike | list[str]rr)rzcompiler) str_floatsrr~rr0rrrs @@rbr r sG::!27)7CDL5 J g GNO!3A61Sb6A=OO g   *!,G1DC!KF MPs B'B cvt|trtj|jS|j duSr)r}r-com any_not_nonerZrU)rSs rbrr<s0%$--zz%%rdceZdZdZidddddddd d d d d ddddddddddddddddddd d!d"d#Z d' d(d%Zd)d&Zy$)* EngFormatterzl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter iyiziairipiriurrrvrrRrr GrTPEZYNc ||_||_yraccuracyuse_eng_prefix)rarrs rbrczEngFormatter.__init___s! ,rdctt|}tj|rytj|ryd}|dkrd}| }|dk7r>> 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 rPinfrfrrKrzE-02dzE+rz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r ris_nan is_infiniterimathrOrPrjr: ENG_PREFIXESr rrr^) ranumdnumsignpow10 int_pow10rr format_strrs rb__call__zEngFormatter.__call__es_(s3x  >>$    t $ !8D5D 19C 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 r[N)rrrs rbset_eng_float_formatrsD%|Hn'MNrdct|dk(rgSdgt|dz}g}|D]U}d}i}t|D]\}}||r||k(rd||<||z ||<|}!t||z ||<|j|W|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)rhr4r8) levelssentinelcontrolrlevel last_indexlengthsr;keys rbget_level_lengthsrs$ 6{a fs6!9~%G F & FAsqzcXo" &'*n #  "%j:5  g Mrdctd|Dr|Dcgc] }t|}}|jdj|ycc}w)z Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. c3<K|]}t|tywr)r}rrs rbr1z#buffer_put_lines..s -!:a  -srzN)rrrr)r]linesr0s rbbuffer_put_linesrsC -u --!&'AQ''IIdii(sA )rzdict[str, Any]r")r~rr]rrxrrrr)r]rrxrrz1Generator[WriteBuffer[str]] | Generator[StringIO]) NrPNNrErbTNN)rr5rErkrVrfrTrrrrCzstr | int | NonerGrrrrrgrrrrkrr)rCnp.ndarray | Sequence[float]rr)rrrrirg)r0NaTType | Timestampr.rrrr2)r0rr.rrrrr)r\rr.rrrrr)rF)rr*r.z str | floatrerrr)rENN) r*rrGrr+rr_zprinting._TextAdjustment | Nonerr)rb)r{r5rrrr)rrrr)rrrrrr)rSr,rr)rF)rrirrrr)rv)rrrzbool | object | strrzlist[dict[int, int]])r]zWriteBuffer[str]rrrr)r __future__rcollections.abcrrrrr contextlibr csvr rr functoolsr ior rrzshutilrtypingrrrrnumpyrlpandas._config.configrr pandas._libsrpandas._libs.missingrpandas._libs.tslibsrrrpandas._libs.tslibs.nattyperpandas.util._decoratorsrpandas.core.dtypes.commonrrrrr r!pandas.core.dtypes.dtypesr"r#r$pandas.core.dtypes.missingr%r&pandas.core.arraysr'r(r)r*pandas.core.baser+pandas.core.commoncorecommonrpandas.core.indexes.apir,r-r.r/pandas.core.indexes.datetimesr0pandas.core.indexes.timedeltasr1pandas.io.commonr2r3rr4pandas._typingr5r6r7r8r9r:r;r<r=r>r?r@rrArBrCr4VALID_JUSTIFY_PARAMETERSrMrOrrrrnrzrrrrrrrrIr=rTrXr]rrrfr6r rr rrrrrrrdrbrs #& $ # 0.   *  89'     6%6p %c$c$L>:IFIFX^^F/3    +    DHM +M7AM6MMP,0"!%*.R R R )R   R  R  R R R R R (R R jeePI00I0X/#1#65B?"-?"?"D"       JN @ @"% @