OwgOUdZddlmZddlmZmZmZmZddlm Z ddl m Z ddl m Z ddlmZddlmZdd lZdd lZdd lmZdd lmZmZmZmZmZdd lZdd lmZm Z dd l!m"Z"ddl#m$Z$ddl%m&Z&m'Z'm(Z(ddl)m*Z*ddl+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1ddl2m3Z3m4Z4m5Z5ddl6m7Z7m8Z8ddl9m:Z:m;Z;mm?Z?ddl@mAZAdd lBmCcmDZEddlFmGZGmHZHmIZImJZJddlKmLZLddlMmNZNddlOmPZPddlQmRZRmSZSddlTmUZUer$ddlVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZambZbddlcmdZdmeZedZfd egd!<d"Zhd#Zid egd$<Gd%d&ZjdNd'ZkdNd(ZlGd)d*ZmGd+d,Zn dO dPd-Zoe dQ dRd.Zp dS dTd/ZqGd0d1ZrGd2d3erZsGd4d5erZtGd6d7erZuGd8d9erZv dUd:ZwdVd;ZxdWdXd<Zy dY dZd=Zz dY d[d>Z{Gd?d@euZ|GdAdBerZ} d\ d]dCZ~ d^ d_dDZd`dadEZdbdFZ d` dcdGZdddHZGdIdJZdedfdKZ dg dhdLZdidMZy )jz Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations) GeneratorHashableMappingSequence)contextmanager) QUOTE_NONE)Decimal)partial)StringION)get_terminal_size) TYPE_CHECKINGAnyCallableFinalcast) get_option set_option)lib)NA)NaT Timedelta Timestamp)NaTType)is_complex_dtypeis_float is_integer is_list_likeis_numeric_dtype is_scalar)CategoricalDtypeDatetimeTZDtypeExtensionDtype)isnanotna) Categorical DatetimeArrayExtensionArrayTimedeltaArray) StringDtype) PandasObject)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)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 bufrVrUrSrRrTrYrZrrWrXr5get_adjustmentadj _chk_truncate) selfr]rRrSrTrUrVrWrXrYrZs O/var/www/horilla/myenv/lib/python3.12/site-packages/pandas/io/formats/format.py__init__zSeriesFormatter.__init__s :          %&<=L( **, c||j}|j}|xrt|j|kD}|j}|rjt t |}|r t ||}|dk(r|}|jd|}n-|dz}t|jd||j| df}||_ nd|_ ||_ ||_ y)N) rZrYlenr]rintminilocr2 tr_row_num tr_seriesis_truncated_vertically)rbrZrYror]row_nums rcrazSeriesFormatter._chk_truncates ====#+"LDKK0@80K "C*Hx21}"Yh/"a-Xg!6 WHI8N OP%DO"DO'>$recN|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: rVzdtype: rv)r]rVrT isinstancer0r.r1freqfreqstrr5 pprint_thingrRrorirXgetattrrnr!_values_get_repr_footerstr)rbrVfooterrT series_name dtype_name level_infos rc _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{rect|jjd|j|j|j S)N)rWrU leading_space) format_arrayrnr~rWrUrTrbs rc_get_formatted_valuesz%SeriesFormatter._get_formatted_values(s6 NN " " **;;**   rec|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_namessparsifyrhrv include_namerg...z..rGmoderr)rnrrityper]__name__rT _has_namesryr- _format_multir5r_adjoinsplit _format_flatrrormrrjr`rHinsertrSrjoin) rbr]rrT have_header fmt_indexr` fmt_values n_header_rowsrpwidthdot_strresults rc to_stringzSeriesFormatter.to_string1s!!# 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?##re)r]rCrR bool | strrSboolrTrrUrrVrrW str | NonerXrrY int | NonerZrreturnNonerrrrr list[str]) r __module__ __qualname____doc__rdrarrrrercrPrPs"#'##     ! @?6(T +$rerPcddlm}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. .. 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)rYrZmax_cols max_colwidthshow_dimensions line_width)pandas.io.formatsrrget_console_size)rr_s rcget_dataframe_repr_paramsr_sa"*-.002 A 121245"#9:%&?@  rect\}}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. .. 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 rrrTr)rVrXrZrYrR)r r)rheight max_rows_optrYrZs rcget_series_repr_paramsrs^"&'ME601L%*v H%*v ;M0NH67  receZdZdZerendZeeezz 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.dZd/dZd0dZd0dZd1dZd(dZd(dZd(dZd*dZd2dZd2dZ d2dZ!d'dZ"d3d Z#d4d!Z$d5d"Z%d6d#Z&d7d$Z'y)8DataFrameFormatterz Class for processing dataframe formatting options and data. Used by DataFrame.to_string, which backs DataFrame.__repr__. rrNc^||_|j||_|j||_||_||_||_|j||_ |j||_ | |_ |j| |_| |_||_||_||_| |_| |_||_||_|j/|_|j3|_|j|_|j9t;j<|_yN) frame_initialize_columnscolumns_initialize_colspace col_spacerSrTrU_initialize_formatters formatters_initialize_justifyrHrW_initialize_sparsifyrshow_index_namesdecimal bold_rowsescaperYrZrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerxr5r_r`)rbrrrrSrTrUrrHrWr index_namesrYrZrrrrrs rcrdzDataFrameFormatter.__init__s* //8 229=   55jA//8 (11(; + "       .#99;#99;   **,rec|j}|jr-|j|j}|j d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrT_get_formatted_indexrr)rbstrcols str_indexs rc get_strcolszDataFrameFormatter.get_strcolss@113 ::11$--@I NN1i (rec\|jduxs|jdk(xr |jS)NTrx)r is_truncatedrs rcshould_show_dimensionsz)DataFrameFormatter.should_show_dimensionss3##t+  J . D43D3D recHt|jxs |jSr)ris_truncated_horizontallyrors rcrzDataFrameFormatter.is_truncatedsD22Rd6R6RSSrectt|jxr"t|j|jkDSr)rrrirrs rcrz,DataFrameFormatter.is_truncated_horizontallys,D((Wc$,,.?$BVBV.VXXrectt|jxr"t|j|jkDSr)rrrirrs rcroz*DataFrameFormatter.is_truncated_verticallys+D((Uc$**o@T@T.TVVrectdt|jdt|jjdS)Nz [z rows x z columns])rirrrs rcdimensions_infoz"DataFrameFormatter.dimensions_infos0s4::'xDJJ4F4F0G/H RRrec@t|jjSr)rrrTrs rchas_index_namesz"DataFrameFormatter.has_index_namess$****++rec@t|jjSr)rrrrs rchas_column_namesz#DataFrameFormatter.has_column_namess$**,,--recZt|j|j|jfSr)allrrTrrs rcshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namess$D(($**d6K6KLMMrecZt|j|j|jfSr)rrrrSrs rcshow_col_idx_namesz%DataFrameFormatter.show_col_idx_namess$D))4+@+@$++NOOrect|jxst|jt|jSr)rkrYrirrs rcmax_rows_displayedz%DataFrameFormatter.max_rows_displayed s(4==3C OS_EErec | tdS|S)Nzdisplay.multi_sparser)rbrs rcrz'DataFrameFormatter._initialize_sparsifys  45 5rec|iSt|jjt|k(st|tr|St dt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rirrrydict ValueError)rbrs rcrz)DataFrameFormatter._initialize_formatterssu  I ## $J 7:jRV;W $S_$56//24::3E3E/F.GqJ rec | tdS|S)Nzdisplay.colheader_justifyr)rbrHs rcrz&DataFrameFormatter._initialize_justify s ?9: :Nrect|!t|}|j||_|S|jjSr)r/rr)rbrcolss rcrz&DataFrameFormatter._initialize_columns&s7  (DD)DJK::%% %rec~|i}|St|ttfr:d|i}|j|jj Dcic]}||c}|St|t rE|jD].}||jj vs|dk7s"td||}|St|jj t|k7r8tdt|dt|jj dtt|jj |}|Scc}w)Nrrz,Col_space is defined for an unknown column: zCol_space length(rr) ryrjrupdaterrrkeysrrirzip)rbrrcolumns rcrz'DataFrameFormatter._initialize_colspace.s;  F$ # C: .)_F MM4::;M;MN69,N O  7 +#..* !3!33" $FvhO  F 4::%%&#i.8 'I'78336tzz7I7I3J2K1N#djj00)<=F Os D:c|js |jSt\}}|j|r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr _is_screen_narrow)rbrrs rcrz(DataFrameFormatter._calc_max_cols_fittedFsA##%== $&q  ! !% (L== rec|jrPt\}}|jdk(r||jz S|j |r|}n|j}n |j}|j |S)z,Number of rows with data fitting the screen.r)rr rY_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rbrrrYs rcrz(DataFrameFormatter._calc_max_rows_fittedQsr    !)+IAv}}! B B DDD$$V,!==}}H$$X..rec~|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 )rirrZrk)rbrYs rcr z#DataFrameFormatter._adjust_max_rowsds2 DJJ(* t}}h7recTt|jdk(xs|jdk(S)z/Check if the output is to be shown in terminal.r)rrrYrs rcrz"DataFrameFormatter._is_in_terminalrs$DMMQ&<$--1*<==reczt|jdk(xr"t|jj|kDSNr)rrrirr)rb max_widths rcrz$DataFrameFormatter._is_screen_narrowvs/DMMQ&N3tzz/A/A+BY+NOOrecft|jdk(xrt|j|kDSr)rrYrir)rb max_heights rcr z#DataFrameFormatter._is_screen_shortys(DMMQ&G3tzz?Z+GHHrecd}d}||z}|jr&|t|jjz }|jr|dz }|S)z?Get number of rows occupied by prompt, dots and dimension info.rg)rrir splitlinesrS)rbdot_row prompt_rownum_rowss rcr z0DataFrameFormatter._get_number_of_auxiliary_rows|sR Z'    D00;;=> >H ;; MHrecv|jr|j|jr|jyy)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyro_truncate_verticallyrs rcrxzDataFrameFormatter.truncates3  ) )  ' ' )  ' '  % % ' (rec|jJ|jdz}|dk\r|jjddd|f}|jjdd| df}t||fd|_t |j t tfrlg|j d||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 Nrhrgaxis) rrrlr2ryrlisttuplerrjr tr_col_num)rbcol_numrErFs rcrz)DataFrameFormatter._truncate_horizontallys##///&&!+ a<==%%a'k2DMM&&q7()|4E"D%=q9DM$//D%=9#__Xg.#__gXY/#"3 .G MM..q(7({;DM!rec|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 Nrhrg) rrirnphstackarangerlrrjrYrm)rbrp_len_slices rcrz'DataFrameFormatter._truncate_verticallys##///&&!+ a<t}}%DYY ' 2BIIdWnd4STUF MM..v6DM"3 .G MM..xx{;DM!rec 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)stringsrHminimumr`zWriting z cols but got z aliasesrrc3TK|]}jj|!ywrr`ri.0xrbs rc z@DataFrameFormatter._get_strcols_without_index..s0RQa0R%()r*r`c3TK|]}jj|!ywrr,r-s rcr0z@DataFrameFormatter._get_strcols_without_index..s@DHHLLO@r1r)rrS enumerater format_col_make_fixed_widthrHrjrgetr`appendrrrrirr_get_formatted_column_labelsrmax) rbricrlabel str_columnsr/cheaderheader_colwidthmax_lens ` rcrz-DataFrameFormatter._get_strcols_without_indexs,#%DKK(!$--0 +1!__Q/ .& LL 2 21a 89  z* +N  $tCy$++6DK4;;3t||#44 s4<<012"4;;/0:15 .s%TEe&7&7%Tsc<|jvr |rsd|zS|S)N )r)r/y need_leadsprestrict_formattingrbs rc space_formatzEDataFrameFormatter._get_formatted_column_labels..space_formats'T__,#A/7Nrec3VK|]}|Dcgc] }|| c}ycc}wwrr)r.r/rMrPs rcr0zBDataFrameFormatter._get_formatted_column_labels.. s&K!15a|Aq)5K5s )$ )rrL)pandas.core.indexes.multirGrryr-rrrrdtypesr~anylevelsrmaprrrirr3rC) rbrrGr fmt_columnsrSstr_columns_tupler/r=r:rNrOrPs ` @@@rcr8z/DataFrameFormatter._get_formatted_column_labelssx=-- gz *!//e/TKsK01KZZ&&..F#&%TW^^%T"T s;4Df0MNOK !%K{KL! }}%6!7$34E$F!,/1B,CDq47DKD"..E.BKZZ&&Fs;4Df0MNOK&k2Aq!% 3 3A 6;q>qqQK E s 4F#(Fc ,|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__)rrrD)rrDrErrr)rHr*r`rgrv)ritemsrrjrTrrCryr-rrrrrr5rr6r`rrr_get_column_name_listrnlevelsrS) rbrkvrrTrfmtrr/adjoined col_headers rcrz'DataFrameFormatter._get_formatted_index1s}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)Nrrr)r.rVs rcr0z;DataFrameFormatter._get_column_name_list..^sP$t|5Psrr)rrryr-extendnamesr7rV)rbrfrs rcr\z(DataFrameFormatter._get_column_name_listZs_ "**$$ gz * LLP'--P P  LLw||3 F re)NNTTrQNNNNTNNNF.FT)&rrBr Axes | NonerColspaceArgType | NonerSzbool | SequenceNotStr[str]rTrrUrrFormattersType | NonerHrrWFloatFormatType | Noner bool | NonerrrYrrZrrrrrrrrrrrrr)rlist[list[str]]rrr)rrj)rrlrr)rrjrr=)rHrrr)rrhrr,)rrirr9)rr)rYrrrr)r:rjrr)r: str | intrCallable | None)rrBrrm)rrBrr)rzlist[Hashable])(rrrrrDrNrdrpropertyrrrrorrrrrrrrrrrrrr rrr r rxrrrr4rCr8rr\rrercrrss !gbG "222G $,0-1,0"/3 $ ###&+'------* -- + --  ----*----------------- $!--"#--$%--&'--( )--^   TTYYWWSS,,..NNPPFF /    &0 !/& >PI ("4"$-^   0'R'RrerceZdZdZddZ d d dZ d d dZ d d dZy)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. c||_yr)r`)rbr`s rcrdzDataFrameRenderer.__init__us reNcddlm}m} |r| n|} | |j||||} | 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)classesbordertable_id render_linksr^encoding)pandas.io.formats.htmlrvrwr`rsave_to_buffer) rbr^r}rxnotebookryrzr{rvrwKlasshtml_formatterstrings rcto_htmlzDataFrameRenderer.to_htmlxsPD &.!= HH%   ))+f#AArecrddlm}||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)rr|)pandas.io.formats.stringrr`rr)rbr^r}rrstring_formatterrs rcrzDataFrameRenderer.to_strings5( =*488 K!++-f#AArecDddlm}| 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_buflineterminatorsepr}errors compressionquotingr index_labelr chunksize quotechar date_format doublequote escapecharstorage_optionsrDr)pandas.io.formats.csvsrr r`saverygetvalueclose)rbrr}rrrrrrrrrrrrrrrcreated_buffer csv_formattercontents rcto_csvzDataFrameRenderer.to_csvs, 8  !N"*K"N$ # )      $    $      $ $ " ,! "hh# &  k84 44!**,G    Nre)r`rrr)NNNFNNF)r^"FilePath | WriteBuffer[str] | Noner}rrxzstr | list | tuple | Nonerrryzint | bool | Nonerzrr{rrr)NNN)r^rr}rrrrr)NN,NNwinferN"NNNTNstrictN)"rz7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Noner}rrrrzSequence[Hashable] | NonerzIndexLabel | Nonerrrr:rrrrrrrrrrrrrrrrrzStorageOptions | Nonerr)rrrrrdrrrrrercrsrsds  37#-1$(#"1B /1B1B+ 1B  1B " 1B1B1B 1Bj37#!% B /BB B  B8PT#-1)-*1"%) $"& !%15#9L99 9 + 9 ' 99(999#99 999 !9"/#9$ %9rersct||5}|j|||jcdddS dddy#1swYyxYw)zQ Perform serialization. Write to buf or return as string if buf is None. )r}N) _get_bufferwriter)rr^r}fds rcrrsN 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.rrrr)r}newlinez1buf is not a file name and it has no write method) r4r ryrrhasattrr3open TypeError)r^r}fs rcrrs 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) digitsrUrWrDrBrHrrrfallback_formatter)r is_np_dtyperX_Datetime64Formatterrr'ryr"_Datetime64TZFormatter_Timedelta64Formatterr)r#_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) valuesrDrWrUrrBrHrrrr fmt_klassfmt_objs rcrr7sR v||S)( mV, FLL/ 2* mV, s +) nf- FLL. 1, t ,' t ,& *  }!"89  ~/0!#- G    recneZdZ d ddZddZddZy)rNc ||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ yr) rrrUrBrDrWrHrr fixed_widthrr) rbrrrDrUrBrWrHrrrrrs rcrdz_GenericArrayFormatter.__init__s\    "(   &*"4recN|j}t||jSr)_format_stringsr5rH)rbrs rcrz!_GenericArrayFormatter.get_results!))+  T\\::rec  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)r/ precisions rcz8_GenericArrayFormatter._format_strings..s )AIa=)**rers)rw quote_stringscjt|rt|r|y|turt tSt j |r tj|r t |S|tus*t|tjtjfryjSt|tr t |St|tr t|St |S)Nrr)rUr r$rrrrr#isinfrry datetime64 timedelta64r+r*repr)r/rDrbs rc_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)recHt|r t|SjSr)r%rrU)r_rbs rcrz.base_formatter&s!&qs1v:t{{:rergcJ|jdjdS)Nrgrg)replacer)r_rrbs rcdecimal_formatterz?FloatArrayFormatter._value_formatter..decimal_formatter+s!%a(00dllAFFrecnt|rt|kDr|SdSjS)Ng)r%absrU)rrrb thresholds rcrDz7FloatArrayFormatter._value_formatter..formatter4s6U|u: ),U33,S11{{"re)rWr)rbrWrrDrrs``` @@rc_value_formatterz$FloatArrayFormatter._value_formattersZ  ,,L   ; <<3  G!/   $ $ #rec` 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 Dcgc]\}}|s||n|c}}j |j }|Scc}}wr)r$r#arrayrravelreshaper)rrDrUmaskvalr formatteds rcformat_with_na_repzCFloatArrayFormatter.get_result_as_array..format_with_na_repEss.format_complex_with_na_repOsP''&///1K''&///1K#' #4d;6GyIM=@  > @9Xx'w!((38 !((Ih,?+@&)KL %.x%8%>%>%@N%005%,,x7Gq-IJ%,,xq8H-JK!((F81VHA)>?' @(88M*226<<@ @reNzdisplay.chop_thresholdcj| }jdk(rdjzn j}j}t |}|r |||}n |||}j rF|rt |j}nt|j}tj|dS|S)NrErLobjectrX) rrHrUrrr_trim_zeros_complexr_trim_zeros_floatr#asarray) rWrDrUr is_complexrrrrbrs rcformat_values_withzCFloatArrayFormatter.get_result_as_array..format_values_withus--lIFI+/,,&*@S4;;&dkkF[[F)&1J3FIvN+FIvF0FF.vt||DFzz&99MreTz{value: .{digits:d}f}z{value:.{digits:d}f})rc"j|zSr)rW)rrbs rcrz9FloatArrayFormatter.get_result_as_array..s):):U)Brerc32K|]}t|ywrrir.r/s rcr0z:FloatArrayFormatter.get_result_as_array..s:AQ:Fg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr6rDrrUr)rDrrUrrrWrr rrrir9r#rrT) rbrfmt_strrWformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrrrs ` @@@rcget_result_as_arrayz'FloatArrayFormatter.get_result_as_array?s   A A*2 A> %%dkk4>>4;;O O   "#;>$++FL1,? rec4t|jSr)rr'rs rcrz#FloatArrayFormatter._format_stringssD,,.//rerNN)rWrkrz float | Nonerr)rz np.ndarrayr)rrrrdrr'r __classcell__rs@rcrrs> )04"&6,6 6  6p~ @0rerceZdZddZy)rc|jdurd}nd}|jxs|}|jDcgc] }|| }}|Scc}w)NFc*|dj|S)Nrr/rr/s rcrz4_IntArrayFormatter._format_strings..s1ooo&:rec*|dj|S)Nz dr/r0r/s rcrz4_IntArrayFormatter._format_strings..s2&6&6&6&;re)rrDr)rb formatter_strrDr/rs rcrz"_IntArrayFormatter._format_stringssN    &:M;MNN3m ,0KK8qil8 89sANr)rrrrrrercrrsrercHeZdZUded< d dfd ZddZxZS)rr'rc Bt||fi|||_||_yr)rrdnat_repr)rbrr5rrrs rcrdz_Datetime64Formatter.__init__s& *6* &rec|j}|j|Dcgc]}|j|c}S|j|j|j}|j Scc}w)z&we by definition have DO NOT have a TZ)rUr)rrD_format_native_typesr5rtolist)rbrr/rs rcrz$_Datetime64Formatter._format_stringssi >> %/56!DNN1%6 600<  fk *//1EJJvV4E!  **;;;;**LLLL,,LL1  reNrrrrr;rrrercrrs rercFtj|}t|r0tj|dk\rtj|dks t dd|z}t |}|j |jt}tj||}tj|r(|jt}|Dcgc]}|dz c}Stj|}t |}tj|t}||j jtjt||<||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%'] rrgz/percentiles should all be in the interval [0,1]d%r)r#rrrr get_precisionroundastyperjiscloserunique empty_liker) percentilesprecpercentiles_round_typeint_idxoutr: unique_pctss rcformat_percentilesrQ sXD**[)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$.rs4 wK rect|S)N)r5)r\r[s rcrz'get_format_datetime64..vs+Aw?rer) is_dates_onlyr5rs ``rcget_format_datetime64reks   @?rec eZdZUded<ddZy)rr'rc|jj}|jjt}|jxst ||j }|Dcgc] }|| }}|Scc}w)zwe by definition have a TZ)r)r_is_dates_onlyrGrrDrer)rbidorrDr/rs rcrz&_Datetime64TZFormatter._format_strings|sjkk((##F+NN &; T--' -33qil3 34sA2NrrArrercrrys  rercBeZdZUded< d dfd ZddZxZS)rr)rc 4t||fi|||_yr)rrdr5)rbrr5rrs rcrdz_Timedelta64Formatter.__init__s *6* rec|jxs"t|j|jd}|jDcgc] }|| c}Scc}w)NF)r5box)rDget_format_timedelta64rr5)rbrDr/s rcrz%_Timedelta64Formatter._format_stringssENN &< KK5' '+kk2 ! 222sAr)rr)r5rrrrr:r+s@rcrrs4    3rerc@|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)Nr0')r r$ryr _repr_base)r/rrmrr5s rcr?z*get_format_timedelta64.._formattersS 91$q'N!Y'! AV, ]F re)rh)rr5rm even_daysr?rs `` @rcrnrns*%%I  rec@ t|dk(s|dk(r|S|tjn|tfd|D | t|  t d kDr d fd }|Dcgc] }|| }}j | |}|Scc}w)Nrrc3@K|]}j|ywrr)r.r/ adjustments rcr0z$_make_fixed_width..s5*..#5srcV%dkDj|kDzr |ddz dz}|S)Nrrr)r/rxconf_maxr@s rcjustz_make_fixed_width..justs=  1 !2W!<=m! $u,rer)r/rrr)rir5r_r9rrH) r)rHr*r`r{r/rrxrzr@s @@@rcr5r5s  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 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([j+-])rrNrc32K|]}t|ywrr)r.parts rcr0z&_trim_zeros_complex..s;dD ;rrg>r)rerr7rrirr9r) str_complexesr real_part imag_partr/trimmedn padded_parts padded_lengthreal_ptimag_ptpaddeds rcrrs$ ryI 2 ((:q)"./B012 MA$Y%:GDL <A ;l;;a?M !$L!$4l126F G  GW  !*  QR[=/) * ,  F Ms.is_number_with_decimalsxx a(44rec|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 rcr0z9_trim_zeros_float..should_trim..$s'IA 3'Is)rir)rr/numbersrs rc should_trimz&_trim_zeros_float..should_trimsE%B(>q(A1BB7|aIC'I'I$IICs <<NrSrrn)rArrayLike | list[str]rr)rcompiler) str_floatsrrrr/rrrs @@rcrr sG::!27)7CDL5 J g GNO!3A61Sb6A=OO g   *!,G1DC!KF MPs B'B cvt|trtj|jS|j duSr)ryr-com any_not_nonerfrV)rTs rcrr1s0%$--zz%%receZdZdZidddddddd 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 irMiziairipiriurrrrrr^rr GrTPEZYNc ||_||_yraccuracyuse_eng_prefix)rbrrs rcrdzEngFormatter.__init__Ts! ,rectt|}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 rQinfrgrrSrzE-02dzE+rz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r ris_nan is_infiniterjmathrWrXrkr9 ENG_PREFIXESrrrr) rbnumdnumsignpow10 int_pow10rr format_strrs rc__call__zEngFormatter.__call__Zs_(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 rcset_eng_float_formatrsn%|Hn'MNrect|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)rir3r7) rUsentinelcontrolrrJ last_indexlengthsr:keys rcget_level_lengthsrs$ 6{a fs6!9~%G F & FAsqzcXo" &'*n #  "%j:5  g Mrectd|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)ryrrs rcr0z#buffer_put_lines..s -!:a  -srvN)rTrrr)r^linesr/s rcbuffer_put_linesrsC -u --!&'AQ''IIdii(sA )rzdict[str, Any]r))rrr^rr}rrrr)r^rr}rrzIGenerator[WriteBuffer[str], None, None] | Generator[StringIO, None, None]) NrQNNrFrgTNN)rr6rDrprWrkrUrrrrBzstr | int | NonerHrrrrrlrrrrprr)rKnp.ndarray | Sequence[float]rr)rrrrjro)r/NaTType | Timestampr5rrrr9)r/rr5rrrrr)rdrr5rrrrr)rF)rr)r5z str | floatrmrrr)rFNN) r)rrHrr*rr`zprinting._TextAdjustment | Nonerr)rg)rr6rrrr)rrrr)rrrrrr)rTr,rr)rF)rrjrrrr)rr)rUrrzbool | object | strrzlist[dict[int, int]])r^zWriteBuffer[str]rrrr)r __future__rcollections.abcrrrr contextlibrcsvr rr functoolsr ior rrshutilr typingrrrrrnumpyr#pandas._config.configrr pandas._libsrpandas._libs.missingrpandas._libs.tslibsrrrpandas._libs.tslibs.nattyperpandas.core.dtypes.commonrrrrrr pandas.core.dtypes.dtypesr!r"r#pandas.core.dtypes.missingr$r%pandas.core.arraysr&r'r(r)pandas.core.arrays.string_r*pandas.core.baser+pandas.core.commoncorecommonrpandas.core.indexes.apir,r-r.r/pandas.core.indexes.datetimesr0pandas.core.indexes.timedeltasr1pandas.core.reshape.concatr2pandas.io.commonr3r4rr5pandas._typingr6r7r8r9r:r;r<r=r>r?r@rApandasrBrCrDr;VALID_JUSTIFY_PARAMETERSrNrPrrrrsrrrrrrrrrQrEr\r`rerrrnr5rrrrrrrrrrercrs# & $ # 0   3)  89-'     6%6p %_$_$DB>BBJZZ~/3    +    DHM +M7AMNMMP,0"!%*.R R R )R   R  R  R R R R R (R R jkk\F00F0R/#1#65B<".<"<"~"       JN @ @"% @