!hOTUdZddlmZddlmZmZmZmZddlm 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&Zjdd)Zkdd*ZlGd+d,ZmGd-d.Zn ddd5Zoe ddd7Zp dddNZqGdOdPZrGdQdRerZsGdSdTerZtGdUdVerZuGdWdXerZvdd[Zwdd^ZxdddcZy dddeZz dddiZ{GdjdkeuZ|GdldmerZ} dddrZ~ dddwZdddyZdd{Z ddd~ZddZGddZdddZ dddZddZd S)z 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 PeZdZdZdddddddddd ddZd dZd!dZd"dZd!dZdS)#SeriesFormatterz\ Implement the main logic of Series.to_string, which underlies Series.__repr__. TNaNFN) lengthheaderindexna_repname float_formatdtypemax_rowsmin_rowsseriesrCrR bool | strrSboolrTrUstrrVrW str | NonerXrY int | NonerZreturnNonec 2||_t|_||_||_||_||_||_| |_| |_ |td}||_ ||_ tj|_|dS)Ndisplay.float_format)r[r bufrVrUrSrRrTrYrZrrWrXr5get_adjustmentadj _chk_truncate) selfr[rRrSrTrUrVrWrXrYrZs Rc:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\pandas/io/formats/format.py__init__zSeriesFormatter.__init__s ::          %&<==L( *,, c||j}|j}|ot|j|k}|j}|rxt t |}|rt ||}|dkr|}|jd|}n1|dz}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rZrYlenr[rintminilocr2 tr_row_num tr_seriesis_truncated_vertically)rirZrYrvr[row_nums rjrhzSeriesFormatter._chk_truncates #==#+"LDK0@0@80K " #C**H 3x221}}"YhY/"a-XgX!6 WHII8N OPP%DOO"DO'>$$$rlc|jj}d}|jj}t|tt t fr|j |d|jz }|jdur'|%|r|dz }tj |d}|d|z }|j dus|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|d z }||z }t)|S)NzFreq: Fz,    ) escape_charszName: TtruncatezLength: rVzdtype: r})r[rVrT isinstancer0r.r1freqfreqstrr5 pprint_thingrRrvrprXgetattrrur!_values_get_repr_footerr^)rirVfooterrT series_name dtype_name level_infos rj _get_footerzSeriesFormatter._get_footers{ ! u}k>J K K / & .u}.. .F 9E ! !d&6 $"/CUVVVK ,{,, ,F ;$   K: % %$*F % $ 3T[!1!133 3F :U " "tz'= !5vtDDJ H#dNFGH$9*$E$EGGG dn*,< = = !/@@BBJ $ j F6{{rl list[str]c\t|jjd|j|j|jS)N)rWrU leading_space) format_arrayrurrWrUrTris rj_get_formatted_valuesz%SeriesFormatter._get_formatted_values(s4 N " *;*     rlc6|j}|}t|dkrt|jjd|dS|j}t|}t|trL| dd}tj }|j dg|Rd}n|d}|}|jrd}|j} t't(| } |j|| d z } | d krd } nd } |j| g| d d} || |z| || d zd|jr|jj d g|d d|gR} n|j d |} |jr|r|ddz| z} |r| d|zz } t3d| S)Nrz([], )T) include_namessparsifyror} include_namern...z..rGmodery)rurrptyper[__name__rT _has_namesrr- _format_multir5rfadjoinsplit _format_flatrrvrtrrqrgrHinsertrSr^join) rir[rrT have_header fmt_indexrg fmt_values n_header_rowsrwwidthdot_strresults rj to_stringzSeriesFormatter.to_string1s7!!## v;;!  4;''0@@v@@@ @  '' eZ ( ( >++$+NNI)++C" 11y11177==II***==I//11  ' .MoG3((GHLLGaK!899Eqyyh&&y%h&GGJG   g 5w ? ? ?   Wq[" - - - : 4$TX_QE)ABB-)DEEEFFX__Q 33F ; 2; 2q\D(61F  $ dVm #F2776??###rl)r[rCrRr\rSr]rTr]rUr^rVr]rWr_rXr]rYr`rZr`rarbrarbrar^rar) r __module__ __qualname____doc__rkrhrrrrlrjrPrPs"#'##@????6((((T    +$+$+$+$+$+$rlrPradict[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)rYrZmax_cols max_colwidthshow_dimensions line_width)pandas.io.formatsrrget_console_size)rr_s rjget_dataframe_repr_paramsr_s"*)))))-..0022 AA 122122455"#9::%&?@@   rlct\}}td}|dkr|n|}|dkr|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 rrrTr)rVrXrZrYrR)r r)rheight max_rows_optrYrZs rjget_series_repr_paramsrsy"&''ME6011L%**vv H%**vv ;M0N0NH677   rlceZdZdZerendZeeezz 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. Used by DataFrame.to_string, which backs DataFrame.__repr__. ryNTrQF.framerBcolumns Axes | None col_spaceColspaceArgType | NonerSbool | SequenceNotStr[str]rTr]rUr^ formattersFormattersType | NonerHr_rWFloatFormatType | Noner bool | None index_namesrYr`rZrrr\decimal bold_rowsescaperarbc||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t;j|_dSN) r_initialize_columnsr_initialize_colspacerrSrTrU_initialize_formattersr_initialize_justifyrHrW_initialize_sparsifyrshow_index_namesrrrrYrZrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerr5rfrg)rirrrrSrTrUrrHrWrrrYrZrrrrrs rjrkzDataFrameFormatter.__init__s* //88 229==   55jAA//88 (11(;; + "       .#99;;#99;;   *,,rllist[list[str]]c|}|jr0||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrT_get_formatted_indexrr)ristrcols str_indexs rj get_strcolszDataFrameFormatter.get_strcolssM1133 : )11$-@@I NN1i ( ( (rlc8|jdup|jdko|jS)NTr)r is_truncatedrs rjshould_show_dimensionsz)DataFrameFormatter.should_show_dimensionss*#t+  J . D43D rlc8t|jp|jSr)r]is_truncated_horizontallyrvrs rjrzDataFrameFormatter.is_truncatedsD2Rd6RSSSrlcdt|jot|j|jkSr)r]rrprrs rjrz,DataFrameFormatter.is_truncated_horizontallys*D(Wc$,.?.?$BV.VXXXrlcdt|jot|j|jkSr)r]rrprrs rjrvz*DataFrameFormatter.is_truncated_verticallys(D(Uc$*oo@T.TVVVrlcfdt|jdt|jjdS)Nz [z rows x z columns])rprrrs rjdimensions_infoz"DataFrameFormatter.dimensions_infos0Rs4:RRDJ4F0G0GRRRRrlc4t|jjSr)rrrTrs rjhas_index_namesz"DataFrameFormatter.has_index_namess$**+++rlc4t|jjSr)rrrrs rjhas_column_namesz#DataFrameFormatter.has_column_namess$*,---rlcDt|j|j|jfSr)allrrTrrs rjshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namessD($*d6KLMMMrlcDt|j|j|jfSr)rrrrSrs rjshow_col_idx_namesz%DataFrameFormatter.show_col_idx_namessD)4+@$+NOOOrlrqcxt|jpt|jt|jSr)rrrYrprrs rjmax_rows_displayedz%DataFrameFormatter.max_rows_displayed s)4=3C OOS__EEErlc(|tdS|S)Nzdisplay.multi_sparser)rirs rjrz'DataFrameFormatter._initialize_sparsifys  455 5rlr=c|iSt|jjt|kst|tr|St dt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rprrrdict ValueError)rirs rjrz)DataFrameFormatter._initialize_formatterss  I # $ $J 7 7:jRV;W;W 7 JS__JJ/24:3E/F/FJJJ rlc(|tdS|S)Nzdisplay.colheader_justifyr)rirHs rjrz&DataFrameFormatter._initialize_justify s ?9:: :Nrlr,cd|#t|}|j||_|S|jjSr)r/rr)rircolss rjrz&DataFrameFormatter._initialize_columns&s3  ((DD)DJK:% %rlr9cli}n,tttfr0di}|fd|jjDntt r@D](}||jjvr|dkrtd|)}nt|jjtkr:tdtdt|jjdtt|jj}|S)Nryci|]}|Srr).0columnrs rj z;DataFrameFormatter._initialize_colspace..5sNNN69NNNrlz,Col_space is defined for an unknown column: zCol_space length(rr) rrqr^updaterrrkeysrrprzip)rirrr s ` rjrz'DataFrameFormatter._initialize_colspace.sY  FF  C: . . >)_F MMNNNN4:;MNNN O O O O  7 + + >#..**  !333" $OvOOFF4:%&&#i..88 NINN36tz7I3J3JNNN#dj0)<<==F rlc|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr _is_screen_narrow)rirrs rjrz(DataFrameFormatter._calc_max_cols_fittedFsP##%% != $&&q  ! !% ( ( !L= rlc|rSt\}}|jdkr||z S||r|}n|j}n|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)rirrrYs rjrz(DataFrameFormatter._calc_max_rows_fittedQs    ! ! %)++IAv}!! B B D DDD$$V,, )!=}H$$X...rlcr|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 )rprrZrr)rirYs rjrz#DataFrameFormatter._adjust_max_rowsds<  8DJ(** *t}h77rlcHt|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)r]rrYrs rjrz"DataFrameFormatter._is_in_terminalrs#DMQ&<$-1*<===rlclt|jdkot|jj|kSNr)r]rrprr)ri max_widths rjrz$DataFrameFormatter._is_screen_narrowvs.DMQ&N3tz/A+B+BY+NOOOrlcbt|jdkot|j|kSr)r]rYrpr)ri max_heights rjrz#DataFrameFormatter._is_screen_shortys)DMQ&G3tz??Z+GHHHrlcd}d}||z}|jr)|t|jz }|jr|dz }|S)z?Get number of rows occupied by prompt, dots and dimension info.rn)rrpr splitlinesrS)ridot_row prompt_rownum_rowss rjrz0DataFrameFormatter._get_number_of_auxiliary_rows|sZ Z'   ? D0;;==>> >H ;  MHrlcv|jr||jr|dSdS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyrv_truncate_verticallyrs rjrzDataFrameFormatter.truncatesN  ) *  ' ' ) ) )  ' (  % % ' ' ' ' ' ( (rlc|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 Nrornaxis) rrrsr2rrlisttuplerrqr tr_col_num)ricol_numrErFs rjr%z)DataFrameFormatter._truncate_horizontallys#///&!+ a<<=%aaa'k2DM&qqq7())|4E"D%=q999DM$/D%=99 #_XgX.#_gXYY/# 3 ..G M.qqq(7({;DM!rlc|jJ|jdz}|dkrjt|j}tjtj|tj||z |g}|jj||_n7tt|j }|jjd|ddf|_||_ dS)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrorn) rrprnphstackarangersrrqrYrt)rirw_len_slices rjr&z'DataFrameFormatter._truncate_verticallys#///&!+ a<<t}%%DY ' 2 2BIdWnd4S4STUUF M.v6DMM3 ..G M.xx{;DM!rlc 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)stringsrHminimumrgzWriting z cols but got z aliasescg|]}|gSrr)r labels rj zADataFrameFormatter._get_strcols_without_index..s<<z@DataFrameFormatter._get_strcols_without_index..s/0R0RQa0R0R0R0R0R0Rrl)r6rgc3LK|]}j|VdSrr;r<s rjr>z@DataFrameFormatter._get_strcols_without_index..s/@@DHLLOO@@@@@@rlr)rrS enumerater format_col_make_fixed_widthrHrqrgetrgappendrr*r^rprr_get_formatted_column_labelsrmax) riricr str_columnsr=cheaderheader_colwidthmax_lens ` rjrz-DataFrameFormatter._get_strcols_without_indexs#%DK((  !$-00 + +1!__Q// .& L 2 21a 8 899  z****N  $ $ KtCy$+66DK4;3t|#4#444 :s4<00::"4;//:::=< <<zBDataFrameFormatter._get_formatted_column_labels..s%%T%TEe&7%T%T%T%T%T%Trlc8|jvr|rsd|zS|S)N )r)r=y need_leadsprestrict_formattingris rj space_formatzEDataFrameFormatter._get_formatted_column_labels..space_formats4T_,,#A-/-7Nrlc38K|]fdDVdS)c(g|]}|Srr)r r[r^r=s rjr9zMDataFrameFormatter._get_formatted_column_labels... s%555a||Aq))555rlNr)r r=r^s @rjr>zBDataFrameFormatter._get_formatted_column_labels.. s<KK!555551555KKKKKKrlc,g|]}t|Sr)r*r r=s rjr9zCDataFrameFormatter._get_formatted_column_labels..%sDDDq477DDDrlrc`g|]*\}}|s |rd|zn|g+S)rZ)rO)r rGr=r\ris rjr9zCDataFrameFormatter._get_formatted_column_labels..*sTAq!% 3 3A 6 6P;q>PqqQrl)pandas.core.indexes.multirUrrr-rr*rrdtypesranylevelsrmaprrrprr@) rirrUr fmt_columnsrestr_columns_tuplerIr\r]r^s ` @@@rjrEz/DataFrameFormatter._get_formatted_column_labelss======- gz * * !//e/TTKsK011KZ&.F#&%T%TW^%T%T%T"T"T s;4Df0M0MNNOOK       !%KKKK{KKKL!! } G%6!7!7 G$3O4E$F$F!DDC1B,CDDDKK!..E.BBKZ&Fs;4Df0M0MNNOOK%k22K rlc$djD|j}|j}d}t |t r#|jj |}n| j |g}fd|D}j j dg|R d}jrdD}n d g|jz}jr||zS|S) Nc@i|]\}}|tt|Sr)rrq)r kvs rjr z;DataFrameFormatter._get_formatted_index..4s&HHHAQS! HHHrl __index__)rrrP)rrPc g|]H}ttt|dddjIS)rEryr)rHr6rg)r+rBr*rCrg)r r=rris rjr9z;DataFrameFormatter._get_formatted_index..Dsf    !GGVY]]2q5I5Itx     rlrnr}c,g|]}t|Srr^rbs rjr9z;DataFrameFormatter._get_formatted_index..QsGGGQ#a&&GGGrlry)ritemsrTrrOrr-rrrrrgrrr_get_column_name_listnlevelsrS) rirrTrfmtradjoined col_headerrs ` @rjrz'DataFrameFormatter._get_formatted_index1sXIH1E1E1G1GHHH  -!!+.. eZ ( ( ++"5,II""0GSV"WWI         #48?11y11177==  " 0GG$*D*D*F*FGGGJJ/J ; ( (Orllist[Hashable]cg}|jj}t|tr%|d|jDn#||jdn|j|S)Nc3"K|] }|dn|V dS)Nryr)r rVs rjr>z;DataFrameFormatter._get_column_name_list..^s*PP$t|PPPPPPrlry)rrrr-extendnamesrDrV)rir}rs rjrtz(DataFrameFormatter._get_column_name_listZsn "*$ gz * * G LLPP'-PPP P P P P LLw|3 F F F rl)NNTTrQNNNNTNNNFrFT)&rrBrrrrrSrrTr]rUr^rrrHr_rWrrrrr]rYr`rZr`rr`rr\rr^rr]rr]rarb)rarrar]r)rarq)rrrar])rrrar=)rHr_rar^)rrrar,)rrrar9)rar`)rYr`rar`r)rGrqrar)rGrQrarR)rrBrar)rrBrar)rary)(rrrrrDrNrkrpropertyrrrrvrrrrrrrrrrrrrrrrrrrr%r&rrArOrErrtrrlrjrrs !(ggbG "222G $,0-1,0"/3 $ ###&+'----------^       X TTTXTYYYXYWWWXWSSSXS,,,X,...X.NNNXNPPPXPFFFXF     &&&&0 ! ! ! !////&    >>>>PPPPIIII    ((((""""4""""$----^      0 0 0 0''''R''''RrlrcleZdZdZd5dZ 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. rvrrarbc||_dSr)rv)rirvs rjrkzDataFrameRenderer.__init__us rlNFre"FilePath | WriteBuffer[str] | Noneencodingr_classesstr | 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)rrrrrer)pandas.io.formats.htmlrrrvrsave_to_buffer) rirerrrrrrrrKlasshtml_formatterstrings rjto_htmlzDataFrameRenderer.to_htmlxsD        &.@!!= H%     ))++f#AAAArlrr`c~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.stringrrvrr)rirerrrstring_formatterrs rjrzDataFrameRenderer.to_stringsS( =<<<<<*?48 KKK!++--f#AAAArl,winfer"Tstrict path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Nonesepr^rSequence[Hashable] | None index_labelIndexLabel | Noner compressionr:quoting 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) CSVFormatterNTFrrrrrrrrrrrrrrrrrPr)pandas.io.formats.csvsrr rvsavergetvalueclose)rirrrrrrrrrrrrrrrrrcreated_buffer csv_formattercontents rjto_csvzDataFrameRenderer.to_csvsp, 877777  !N"**KK"N$    #  )>  X  6  $  G  $    i  i $  $  "z ,O! "hh# &   k844 4 44!**,,G      Ntrl)rvrrarb)NNNFNNF)rerrr_rrrr]rrrr_rr]rar_)NNN)rerrr_rr`rar_)NNrNNrrNrNNNTNrN)"rrrr_rr^rrrrrr^rr:rr`rr^rr_rr`rr_rr]rr_rr^rrrar_)rrrrrkrrrrrlrjrrds  37#-1$(#"1B1B1B1B1Bj37#!% BBBBB8PT#-1)-*1"%) $"& !%15#9999999rlrrr^rerrr_ct||5}||| |cdddS ddddS#1swxYwYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) _get_bufferwriter)rrerfds rjrrs S8 , , ,  ;;;==   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.rrry)rnewlinez1buf is not a file name and it has no write method) r4r rr^rhasattrr3open TypeError)rerfs rjrrs1 S!!jj S ! !NLMMMsG M C   Ms3xx((( #sXr : : : a GGG                   KLLLs&B88B<?B<rQrFrTvaluesr6rPrRrWrrUdigitsr`rNstr | int | NonerHrrrrfallback_formatterrc tj|jdrt} t t |}nt |jtrt} t t |}ntj|jdrt} t t|}nmt |jtrt} nKtj|jdrt} n)tj|jdrt} nt} |d}|t!d}|t!d}| |||||||||| | } | 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] MmfciuN rddisplay.precision) rrUrWrPrNrHrrrr)r is_np_dtyperX_Datetime64Formatterrr'rr"_Datetime64TZFormatter_Timedelta64Formatterr)r#_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) rrPrWrUrrNrHrrrr fmt_klassfmt_objs rjrr7s]R v|S))+( mV,, FL/ 2 2 +* mV,, s + + +) nf-- FL. 1 1+, t , ,+' t , ,+& *  }!"899  ~/00i!#-   G     rlc>eZdZ d#d$dZd%d!Zd%d"ZdS)&rNrQrrFrTrr6rrqrPrRrUr^rNrQrWrrHrrr` fixed_widthr]rrrrarbc ||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rrrUrNrPrWrHrrrrr) rirrrPrUrNrWrHrrrrrs rjrkz_GenericArrayFormatter.__init__sb    "(   &*"4rlrcT|}t||jSr)_format_stringsrBrH)rirs rjrz!_GenericArrayFormatter.get_results%))++  T\:::rlc  j&td}|td fd}nj}jj nDjj n5jduojt k}t tjd| fd}j }t|tj stdtj|t }|tjt%|t't)dt+|j z}j}||}g}t3|D]\} } || rj$|r"|d || 8|| r||| _|d urd } nd } || || |S)Nrdrc0t|dddS)Nz .dr)_trim_zeros_single_float)r= precisions rjz8_GenericArrayFormatter._format_strings..s))A+I+++++**rlrz)r~ quote_stringsc.jt|rt|r|dS|turt tSt j|r#tj|rt |S|tus&t|tj tj frdSjSt|trt |St|trt|St |S)Nrbr)rUr r$rr^rrr/isinfrr datetime64 timedelta64r+r*repr)r=rPris rj_formatz7_GenericArrayFormatter._format_strings.._formats{&9Q<<&DGG&9!6"WWr77N\!__!!!q66M#XXA r~/N!O!OX 5{"A|,, )1vv A{++ )Aww99Q<<(((rlz=ExtensionArray formatting should use _ExtensionArrayFormatterrnr(rZFz{v}z {v})rn)rWrrPrrr r r5rrrr/ndarrayrr map_inferrrr%r+rangerpshaperrfr@rDformat)rirWrrvalsinferred is_float_typerrrGrntplrPrs` @@rjrz&_GenericArrayFormatter._format_stringssH   $%&<==L#&':;;       ,L > %II  $ 0/II L4S9SM%/+I  ) ) ) ) ) )*{$ ++ O =x00 fU4[[uU1c$*oo-F-F'G'GHHH I  *  )--//M dOO < eZdZdfd Z ddd Zdd ZddZxZS)rrarbctj|i||j7|j2d|_t |jr|j|_d|_dSdSdSdSNF)superrkrWrPrcallable)riargskwargs __class__s rjrkzFloatArrayFormatter.__init__s|$)&)))   (T^-C$D )** )!%!2$(!!! ) (-C-C ) )rlNrWr threshold float | Nonerc|jrfdnfdjdkrfdnSfd}|S)z;Returns a function to be applied on each value to format itNcPJt|r |njS)N)value)r%rU)rnrWris rjbase_formatterz.base_formatters;#/// Qxx%LLq))))rlcNt|rt|njSr)r%r^rU)rnris rjrz.base_formatter&s !&q:s1vvvt{:rlrcN|djdS)Nrrn)replacer)rnrris rjdecimal_formatterz?FloatArrayFormatter._value_formatter..decimal_formatter+s'%~a((00dlAFFFrlct|r)t|kr |SdSjS)Ng)r%absrU)rrrirs rjrPz7FloatArrayFormatter._value_formatter..formatter4sLU|| #u:: )),,U333,,S111{"rl)rWr)rirWrrPrrs``` @@rj_value_formatterz$FloatArrayFormatter._value_formatters  ,L  ;        ; ; ; ; ; <3   G G G G G G G!/   $ $ # # # # # # #rl 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 rr6rPrrUr^ct|}tjfdt||D|j}|S)Nc4g|]\}}|s |nSrr)r valrrPrUs rjr9zWFloatArrayFormatter.get_result_as_array..format_with_na_rep..Hs>Q+,7IIcNNNrl)r$r/arrayrravelreshaper)rrPrUmask formatteds `` rjformat_with_na_repzCFloatArrayFormatter.get_result_as_array..format_with_na_repEs<.format_complex_with_na_repOs'&////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<@@ @rlNzdisplay.chop_thresholdcf| }jdkr djznj}j}t |}|r|||}n |||}jrC|rt |j}nt|j}tj |dS|S)NrErZobjectrX) r rHrUrrr_trim_zeros_complexr_trim_zeros_floatr/asarray) rWrPrUr is_complexrr)rrirs rjformat_values_withzCFloatArrayFormatter.get_result_as_array..format_values_withus--lIFFI+/,&*@*@S4;&&dkF[F)&11J G33FIvNN++FIvFF :E0FFFF.vt|DDFz&9999MrlTz{value: .{digits:d}f}z{value:.{digits:d}f})rcj|zSr)rW)rris rjrz9FloatArrayFormatter.get_result_as_array..s):U)Brlrc34K|]}t|VdSrrprbs rjr>z:FloatArrayFormatter.get_result_as_array..s(::AQ::::::rlFg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr6rPrrUr^)rPrrUrrrWrr rrrprFr/r rf) rir1fmt_strrWformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesr)rrs ` @@@rjget_result_as_arrayz'FloatArrayFormatter.get_result_as_array?s      A A A A: > %%%dk4>4;OO O   "#;<$+FFFL11,?? rlrcDt|Sr)r*r>rs rjrz#FloatArrayFormatter._format_stringssD,,..///rlrNN)rWrrrrar)rar r)rrrrkr r>r __classcell__rs@rjrrs ) ) ) ) ) )04"&66666p~ ~ ~ ~ @00000000rlrceZdZddZdS)rrarc`|jdurd}nd}|jp|fd|jD}|S)NFc2|d|S)Nrr=rrFs rjrz4_IntArrayFormatter._format_strings..shhooo&:&:rlc2|d|S)Nz drFrGrFs rjrz4_IntArrayFormatter._format_strings..sii&6&6&6&;&;rlc&g|] }|Srrr r=rPs rjr9z6_IntArrayFormatter._format_strings..s!888qiill888rl)rrPr)ri formatter_strrrPs @rjrz"_IntArrayFormatter._format_stringssP   & &::MM;;MN3m 8888DK888 rlNr)rrrrrrlrjrrs(rlrc:eZdZUded< d dfd Zdd ZxZS)rr'rrNnat_repr^rrbrac Xtj|fi|||_||_dSr)rrkrMr)rirrMrrrs rjrkz_Datetime64Formatter.__init__s9 **6*** &rlrcj}jfd|DS|jj}|S)z&we by definition have DO NOT have a TZNc:g|]}|Sr)rPr<s rjr9z8_Datetime64Formatter._format_strings..s%666!DNN1%%666rl)rUr)rrP_format_native_typesrMrtolist)rirrs` rjrz$_Datetime64Formatter._format_stringssd > %6666v666 600!>  fk * * 5//11EEJvV444E!  *;;*LL,L1    rlNrrrrrUrrrlrjrrs6rlr percentilesnp.ndarray | Sequence[float]ctj|}t|r0tj|dkrtj|dkst dd|z}t |}||t}tj ||}tj|r&|t}d|DStj |}t |}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%'] rrnz/percentiles should all be in the interval [0,1]dcg|]}|dzS%rr rGs rjr9z&format_percentiles..>s%%%AC%%%rlr,cg|]}|dzSrarrcs rjr9z&format_percentiles..Fs ! ! !AG ! ! !rl)r/r/rrr get_precisionroundastyperqiscloser^unique empty_liker+)r\precpercentiles_round_typeint_idxout unique_pctss rjformat_percentilesrp sD*[))K [ ) )LvkQ&''LvkQ&''L JKKK #K  % %D(..t44;;C@@j/==G vg&$++C00%%%%%%)K((K  % %D - 6 2 2 2Cw'--//66s;;BB3GGCL)//55< > >D t99D HRXbfTll++ , , 3 3C 8 8 8D q$<.rs4 wK   rlc&t|S)N)rM)r|r{s rjrz'get_format_datetime64..vs+Aw???rlr)rrMrs ``rjget_format_datetime64rks? @      @????rlc"eZdZUded<ddZdS)rr'rrarc|jj}|jt}|jpt ||jfd|D}|S)zwe by definition have a TZ)rc&g|] }|SrrrJs rjr9z:_Datetime64TZFormatter._format_strings..s!333qiill333rl)r_is_dates_onlyrgr+rPrr)riidorrrPs @rjrz&_Datetime64TZFormatter._format_strings|sik(##F++N &; T-' ' ' 4333F333 rlNrr[rrlrjrrys6      rlrc8eZdZUded< d d fd Zd d ZxZS)rr)rrrMr^rarbc Jtj|fi|||_dSr)rrkrM)rirrMrrs rjrkz_Timedelta64Formatter.__init__s/ **6*** rlrcp|jpt|j|jdfd|jDS)NF)rMboxc&g|] }|SrrrJs rjr9z9_Timedelta64Formatter._format_strings..s!222 ! 222rl)rPget_format_timedelta64rrM)rirPs @rjrz%_Timedelta64Formatter._format_stringssJN &< K5' ' ' 3222dk2222rlr)rr)rMr^rarbrrTrBs@rjrrsi 33333333rlrFr) str | floatrc6|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|rt|rSt|tst|}|}rd|d}|S)NrG')r r$rr _repr_base)r=rrrrMs rjrYz*get_format_timedelta64.._formattersm 919$q''9N!Y'' ! AV,,  #"]]]F rl)r)rrMr even_daysrYrs `` @rjrrsN%I        rlr5r6rgprinting._TextAdjustment | Nonec\t|dks|dkr|S|tjn|tfd|D|t|t dkrd fd fd |D}|| }|S) Nrrc3BK|]}|VdSrr4)r r= adjustments rjr>z$_make_fixed_width..s/55*..##555555rlrr=r^racl0dk|kzr|ddz dz}|S)Nrrr4)r=rconf_maxrLs rjjustz_make_fixed_width..justsG  1 !2!2W!<= -m! m$u,rlc&g|] }|Srr)r r=rs rjr9z%_make_fixed_width..s!(((1ttAww(((rlr)r=r^rar^)rpr5rfrFrrH) r5rHr6rgrrrrrLs @@@@rjrBrBs  7||qGu,, {,..  5555W55555Ggw''011H( 2 2 )((((((G   w  ? ?F Mrl str_complexesc 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+-])ryNrc34K|]}t|VdSrr4)r parts rjr>z&_trim_zeros_complex..s(;;dD ;;;;;;rlrncRg|]#\}}||dz|dddzdz$S)rrnN>rr)r real_ptimag_pt padded_lengths rjr9z'_trim_zeros_complex..sc GW  !*  QRR[ += + + + ,  rl)rerrDrrpr.rFr) rr real_part imag_partr=trimmedn padded_partspaddedrs @rjr-r-s, ryI 22 (:q))"..///B001111 MA$Y%:GDDL <A ;;l;;;;;a?M !$L!$4l1226F G G F Mrl str_floatcd|d}|dr|dz }|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)rs rjrrs=   %%I#S rl str_floatsArrayLike | 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]*$rar]c2tj|duSr)rmatch)r= number_regexs rjis_number_with_decimalz1_trim_zeros_float..is_number_with_decimalsx a((44rlrrcxfd|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|]}| |Srrr r=rs rjr9z:_trim_zeros_float..should_trim..#s*BBB(>(>q(A(AB1BBBrlrc3@K|]}|dVdS)rNrrbs rjr>z9_trim_zeros_float..should_trim..$s,'I'IA 3'I'I'I'I'I'Irl)rpr)rnumbersrs rj should_trimz&_trim_zeros_float..should_trimsLCBBBfBBB7||aIC'I'I'I'I'I$I$IIrlc>g|]}|r |ddn|S)Nrrrrs rjr9z%_trim_zeros_float..'s6OOO!33A66=1SbS66AOOOrlc^g|])}|r|r|dzn|*S)rr)r r=rrs rjr9z%_trim_zeros_float..*sR *)!,,KG1D1DKC!rlr~)rrrar])rcompile)rrrrrrrs ` @@rjr.r. sG:C7CCCDDL555555 J J J J J J +g  POOOOwOOO +g  PF MrlrTr,cdt|trtj|jS|jduSr)rr-com any_not_noner}rV)rTs rjrr1s1%$$&--z%%rlceZdZdZidddddddd 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 ir[iziairipiriurrryrrmr5r GrTPEZYNFaccuracyr`use_eng_prefixr]rarbc"||_||_dSrrr)rirrs rjrkzEngFormatter.__init__Ts! ,rlnumfloatr^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 rQinfrnrrrrzE-02dzE+r6Nz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r r^is_nan is_infiniterqmathrvrwrrrF ENG_PREFIXESrrrr) rirdnumsignpow10 int_pow10rr format_strrs rj__call__zEngFormatter.__call__Zs(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 rdN)rrrs rjset_eng_float_formatrs&n%|Hn'M'MNNNNNrlryrgrsentinelbool | 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)rpr@rD) rgrcontrolrrX last_indexlengthsrGkeys rjget_level_lengthsrs$ 6{{a fs6!9~~%G F &&  FAsqz cXoo" &'*n # !%jj:5  g MrlWriteBuffer[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^rbs rjr>z#buffer_put_lines..s, - -!:a   - - - - - -rlc,g|]}t|Srrrrbs rjr9z$buffer_put_lines.. s'''AQ'''rlr}N)rfrr)rers rjbuffer_put_linesrsZ - -u - - ---('''''IIdiirl)rarr@)rr^rerrr_rar_r)rerrr_rar) NrQNNrFrTNN)rr6rPrRrWrrUr^rr`rNrrHr^rr^rrrr`rrRrar)r\r]rar)rr]rarqr)r=ryrMr^rar^rS)r=ryrMr^rr_rar^)rr]rMr^rr_rar)rF)rr)rMrrr]rar)rFNN) r5rrHr^r6r`rgrrar)r)rr6rr^rar)rr^rar^)rrrr^rar)rTr,rar])rF)rrqrr]rarb)ry)rgrrrrar)rerrrrarb)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@rApandasrBrCrDrUVALID_JUSTIFY_PARAMETERSrNrPrrrrrrrrrrrrrprer|rrrrrrBr-rr.rrrrrrrlrjr#s#""""" &%%%%% $$$$$$ ###### 0/////   322222))))))  877777999999------'&&&&&                             66666p _$_$_$_$_$_$_$_$DB>BBBBBBBBJZZZZZZZZ~/3      DHMMMMMP,0"!%*.R R R R R jkkkkkkkk\F0F0F0F0F00F0F0F0R/#####1###65B<"<"<"<"~"      JN @ @ @ @ @     1   333332333,!H+/ DB    7:!!!!!H&&&&]]]]]]]]@7O7O7O7O7Ov24(((((V       rl