ttjFjUdZddlmZddlmZmZmZmZmZddl 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%Zhdd(Zidd)ZjGd*d+ZkGd,d-Zl ddd4Zme ddd6Zn dddMZoGdNdOZpGdPdQepZqGdRdSepZrGdTdUepZsGdVdWepZtddZZudd]ZvdddbZw ddddZx dddhZyGdidjesZzGdkdlepZ{ dddqZ| dddvZ}dddxZ~ddzZ ddd}ZddZGddZe,ddddZ dddZddZd S)z 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 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_rowsseriesrBrQ bool | strrRboolrSrTstrrUrV str | NonerWrX int | NonerYreturnNonec 2||_t|_||_||_||_||_||_| |_| |_ |td}||_ ||_ tj|_|dS)Ndisplay.float_format)rZr bufrUrTrRrQrSrXrYrrVrWr4get_adjustmentadj _chk_truncate) selfrZrQrRrSrTrUrVrWrXrYs V/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/pandas/io/formats/format.py__init__zSeriesFormatter.__init__s ::          %&<==L( *,, c||j}|j}|ot|j|k}|j}|rt t |}|rt ||}|dkr|}|jd|}n_|dz}t|}tj tj |tj ||z |g}|j|}||_ nd|_ ||_ ||_ dS)N)rYrXlenrZrintminilocnphstackarange tr_row_num tr_seriesis_truncated_vertically)rhrYrXrxrZrow_num_len_slices rirgzSeriesFormatter._chk_truncates #==#+"LDK0@0@80K " #C**H 3x221}}"YhY/"a-6{{Yw''4'>4)H)HI V,%DOO"DO'>$$$rkc|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: rUzdtype: r)rZrUrS isinstancer0r.r1freqfreqstrr4 pprint_thingrQrxrorWgetattrrwr"_values_get_repr_footerr])rhrUfooterrS series_name dtype_name level_infos ri _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{{rk list[str]c\t|jjd|j|j|jS)N)rVrT leading_space) format_arrayrwrrVrTrSrhs ri_get_formatted_valuesz%SeriesFormatter._get_formatted_values,s4 N " *;*     rkc6|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_namessparsifyrnr include_namerm...z..rFmoder})rwrrotyperZ__name__rS _has_namesrr- _format_multir4readjoinsplit _format_flatrrxrvrrprfrGinsertrRr]join) rhrZrrS have_header fmt_indexrf fmt_values n_header_rowsrywidthdot_strresults ri to_stringzSeriesFormatter.to_string5s7!!## 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??###rk)rZrBrQr[rRr\rSr\rTr]rUr\rVr^rWr\rXr_rYr_r`rar`rar`r]r`r) r __module__ __qualname____doc__rjrgrrrrkrirOrOs"#'##@????>((((T    +$+$+$+$+$+$rkrOr`dict[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. 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 riget_dataframe_repr_paramsrcs*)))))-..0022 AA 122122455"#9::%&?@@   rkct\}}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. 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 riget_series_repr_paramsrsy&''ME6011L%**vv H%**vv ;M0N0NH677   rkceZdZdZerendZeeezz Z dUdVd(ZdWd*ZedXd+Z edXd,Z edXd-Z edXd.Z edYd/Z edXd0ZedXd1ZedXd2ZedXd3ZedZd5Zd[d6Zd\d8Zd]d9Zd^d;Zd_d=Zd`d>Zd`d?Zdad@ZdXdAZdXdBZdXdCZdZdDZdbdEZdbdFZ dbdGZ!dWdHZ"dcdKZ#dddNZ$dedOZ%dfdPZ&dgdRZ'dhdTZ(dS)iDataFrameFormatterz Class for processing dataframe formatting options and data. Used by DataFrame.to_string, which backs DataFrame.__repr__. r}NTrPF.framerAcolumns Axes | None col_spaceColspaceArgType | NonerRbool | SequenceNotStr[str]rSr\rTr] formattersFormattersType | NonerGr^rVFloatFormatType | Noner bool | None index_namesrXr_rYrrr[decimal bold_rowsescaper`rac||_|||_|||_||_||_||_|||_ | ||_ | | |_ || |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t=j|_ dSN)!r_initialize_columnsr_initialize_colspacerrRrSrT_initialize_formattersr_initialize_justifyrG_validate_float_formatrV_initialize_sparsifyrshow_index_namesrrrrXrYrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerr4rerf)rhrrrrRrSrTrrGrVrrrXrYrrrrrs rirjzDataFrameFormatter.__init__s+* //88 229==   55jAA//88  77 EE11(;; + "       .#99;;#99;;   *,,rklist[list[str]]c|}|jr0||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrS_get_formatted_indexrr)rhstrcols str_indexs ri get_strcolszDataFrameFormatter.get_strcolssM1133 : )11$-@@I NN1i ( ( (rkc8|jdup|jdko|jS)NTr)r is_truncatedrs rishould_show_dimensionsz)DataFrameFormatter.should_show_dimensionss*#t+  J . D43D rkc8t|jp|jSr)r\is_truncated_horizontallyrxrs rirzDataFrameFormatter.is_truncatedsD2Rd6RSSSrkcdt|jot|j|jkSr)r\rrorrs rirz,DataFrameFormatter.is_truncated_horizontallys*D(Wc$,.?.?$BV.VXXXrkcdt|jot|j|jkSr)r\rrorrs rirxz*DataFrameFormatter.is_truncated_verticallys(D(Uc$*oo@T.TVVVrkcfdt|jdt|jjdS)Nz [z rows x z columns])rorrrs ridimensions_infoz"DataFrameFormatter.dimensions_infos0Rs4:RRDJ4F0G0GRRRRrkc4t|jjSr)rrrSrs rihas_index_namesz"DataFrameFormatter.has_index_namess$**+++rkc4t|jjSr)rrrrs rihas_column_namesz#DataFrameFormatter.has_column_namess$*,---rkcDt|j|j|jfSr)allrrSrrs rishow_row_idx_namesz%DataFrameFormatter.show_row_idx_namessD($*d6KLMMMrkcDt|j|j|jfSr)rrrrRrs rishow_col_idx_namesz%DataFrameFormatter.show_col_idx_namessD)4+@$+NOOOrkrpcxt|jpt|jt|jSr)rqrXrorrs rimax_rows_displayedz%DataFrameFormatter.max_rows_displayed s)4=3C OOS__EEErkc(|tdS|S)Nzdisplay.multi_sparser)rhrs rirz'DataFrameFormatter._initialize_sparsifys  455 5rkr<c|iSt|jjt|kst|tr|St dt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rorrrdict ValueError)rhrs rirz)DataFrameFormatter._initialize_formatterss  I # $ $J 7 7:jRV;W;W 7 JS__JJ/24:3E/F/FJJJ rkc(|tdS|S)Nzdisplay.colheader_justifyr)rhrGs rirz&DataFrameFormatter._initialize_justify s ?9:: :Nrkr,cd|#t|}|j||_|S|jjSr)r/rr)rhrcolss rirz&DataFrameFormatter._initialize_columns&s3  ((DD)DJK:% %rkr8c|i}n;t|ttfr=d|i}|t|jj|nt|tr@| D](}||jjvr|dkrtd|)|}nt|jjt|kr:tdt|dt|jjdt t|jj|d}|S)Nr}z,Col_space is defined for an unknown column: zCol_space length(rrTstrict) rrpr]updater fromkeysrrrkeysr rozip)rhrrcolumns rirz'DataFrameFormatter._initialize_colspace.sX  FF  C: . . K)_F MM$-- (:IFF G G G G  7 + + K#..**  !333" $OvOOFF4:%&&#i..88 NINN36tz7I3J3JNNN#dj0)DIIIJJF rkc|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr_is_screen_narrow)rhrrs rirz(DataFrameFormatter._calc_max_cols_fittedFsP##%% != $&&q  ! !% ( ( !L= rkc|rSt\}}|jdkr||z S||r|}n|j}n|j}||S)z,Number of rows with data fitting the screen.r)rrrX_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rhrrrXs rirz(DataFrameFormatter._calc_max_rows_fittedQs    ! ! %)++IAv}!! B B D DDD$$V,, )!=}H$$X...rkcr|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 )rorrYrq)rhrXs rirz#DataFrameFormatter._adjust_max_rowsds<  8DJ(** *t}h77rkcHt|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)r\rrXrs rirz"DataFrameFormatter._is_in_terminalrs#DMQ&<$-1*<===rkclt|jdkot|jj|kSNr)r\rrorr)rh max_widths rirz$DataFrameFormatter._is_screen_narrowvs.DMQ&N3tz/A+B+BY+NOOOrkcbt|jdkot|j|kSr )r\rXror)rh max_heights rirz#DataFrameFormatter._is_screen_shortys)DMQ&G3tz??Z+GHHHrkcd}d}||z}|jr)|t|jz }|jr|dz }|S)z?Get number of rows occupied by prompt, dots and dimension info.rm)rror splitlinesrR)rhdot_row prompt_rownum_rowss rirz0DataFrameFormatter._get_number_of_auxiliary_rows|sZ Z'   ? D0;;==>> >H ;  MHrkcv|jr||jr|dSdS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyrx_truncate_verticallyrs rirzDataFrameFormatter.truncatesN  ) *  ' ' ) ) )  ' (  % % ' ' ' ' ' ( (rkc(|jJ|jdz}|dkrt|jj}t jt j|t j||z |g}|jjdd|f|_t|j ttfr&g|j d||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 Nrnrm)rrorrrsrtrurrrrlisttuplerrpr tr_col_num)rhcol_numrzr{s rir*z)DataFrameFormatter._truncate_horizontallys #///&!+ a<<t},--DY ' 2 2BIdWnd4S4STUUF M.qqq&y9DM$/D%=99 #_XgX.#_gXYY/# 3 ..G M.qqq(7({;DM&rkc|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 Nrnrm) rrorrsrtrurrrrprXrv)rhryrzr{s rir+z'DataFrameFormatter._truncate_verticallys#///&!+ a<<t}%%DY ' 2 2BIdWnd4S4STUUF M.v6DMM3 ..G M.xx{;DM!rkc 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)stringsrGminimumrfzWriting z cols but got z aliasescg|]}|gSrr).0labels ri zADataFrameFormatter._get_strcols_without_index..s<<z@DataFrameFormatter._get_strcols_without_index..s/0R0RQa0R0R0R0R0R0Rrk)r4rfc3LK|]}j|VdSrr:r;s rir=z@DataFrameFormatter._get_strcols_without_index..s/@@DHLLOO@@@@@@rkr)rrR enumerater format_col_make_fixed_widthrGrprgetrfappendrr-r]rorr _get_formatted_column_labelsrmax) rhricr str_columnsr<cheaderheader_colwidthmax_lens ` rirz-DataFrameFormatter._get_strcols_without_indexs#%DK((  !$-00 + +1!__Q// .& L 2 21a 8 899  z****N  $ $ KtCy$+66DK4;3t|#4#444 :s4<00::"4;//:::=< <<.sKKKq477KKKrkrTrctg|]4\}\}}|st|rd|zn|g5S) )rNr )r6rFr<rWrhs rir8zCDataFrameFormatter._get_formatted_column_labels..sf    "Az5 ..q116Fu6M6MC!GG   rkr) pandas.core.indexes.multirTrrr-rrrorrr?rdtypes)rhrrTr fmt_columnsrHs` rirDz/DataFrameFormatter._get_formatted_column_labelss======- gz * * !//e/TTK} ;[!1!1 ;-ok:: KKC,JT,J,JKKKKK!..E.BBK     &/ TZ%6uEEE&&   Krkc$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)rrp)r6kvs ri z;DataFrameFormatter._get_formatted_index..$s&HHHAQS! HHHrk __index__)rrrO)rrOc g|]H}ttt|dddjIS)rDr}r)rGr4rf)r.rAr-rBrf)r6r<rrhs rir8z;DataFrameFormatter._get_formatted_index..4sf    !GGVY]]2q5I5Itx     rkrmrc,g|]}t|Srr]rVs rir8z;DataFrameFormatter._get_formatted_index..AsGGGQ#a&&GGGrkr})ritemsrSrrNrr-rrrrrfrrr_get_column_name_listnlevelsrR) rhrrSrfmtradjoined col_headerrs ` @rirz'DataFrameFormatter._get_formatted_index!sXIH1E1E1G1GHHH  -!!+.. eZ ( ( ++"5,II""0GSV"WWI         #48?11y11177==  " 0GG$*D*D*F*FGGGJJ/J ; ( (Orklist[Hashable]cg}|jj}t|tr%|d|jDn#||jdn|j|S)Nc3"K|] }|dn|V dS)Nr}r)r6rUs rir=z;DataFrameFormatter._get_column_name_list..Ns*PP$t|PPPPPPrkr})rrrr-extendnamesrCrU)rhrors rirfz(DataFrameFormatter._get_column_name_listJsn "*$ gz * * G LLPP'-PPP P P P P LLw|3 F F F rkrhc|t|r|St|trUd|vr|S |d}|jS#tt t f$r}t d||d}~wwxYwt d)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)callablerr]formatr KeyError IndexError)rhrhres rirz)DataFrameFormatter._validate_float_formatSs ;(3--;J c3   Xczz X 3A:%"Hj9XXX$%O%O%OPPVWWXDEEEsA A;#A66A;)NNTTrPNNNNTNNNFrFT)&rrArrrrrRrrSr\rTr]rrrGr^rVrrrrr\rXr_rYr_rr_rr[rr]rr\rr\r`ra)r`rr`r\r)r`rp)rrr`r\)rrr`r<)rGr^r`r])rrr`r,)rrr`r8)r`r_)rXr_r`r_r)rFrpr`r)rFrPr`rQ)rrAr`r)rrAr`r)r`rk)rhrr`r))rrrrrCrMrjrpropertyrrrrxrrrrrrrrrrrrrrrrrrrr*r+rr@rNrDrrfrrrkrirrs !(ggbG "222G $,0-1,0"/3 $ ###&+'----------^       X TTTXTYYYXYWWWXWSSSXS,,,X,...X.NNNXNPPPXPFFFXF     &&&&0 ! ! ! !////&    >>>>PPPPIIII    ((((''''4""""$----^      0 0 0 02''''RFFFFFFrkrcleZdZdZd5dZ d6d7dZ d8d9dZ d:d;d4ZdS)<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. rhrr`rac||_dSr)rh)rhrhs rirjzDataFrameRenderer.__init__|s rkNFrd"FilePath | WriteBuffer[str] | Noneencodingr^classesstr | list | tuple | Nonenotebookr\borderint | bool | Nonetable_id render_linkscddlm}m} |r| n|} | |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)r~rrrrdr})pandas.io.formats.htmlrrrhrsave_to_buffer) rhrdr}r~rrrrrrKlasshtml_formatterstrings rito_htmlzDataFrameRenderer.to_htmlsL        &.@!!= H%     ))++f#AAAArkrr_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.stringrrhrr)rhrdr}rrstring_formatterrs rirzDataFrameRenderer.to_stringsS( =<<<<<*?48 KKK!++--f#AAAArk,winfer"Tr path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Nonesepr]rSequence[Hashable] | None index_labelIndexLabel | Noner compressionr9quoting 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) CSVFormatterNTFrrrr}rrrr rrrrrrrrrOr)pandas.io.formats.csvsrr rhsavergetvalueclose)rhrr}rrrrrrrrrrrrrrrcreated_buffer csv_formattercontents rito_csvzDataFrameRenderer.to_csvsp, 877777  !N"**KK"N$    #  )>  X  6  $  G  $    i  i $  $  "z ,O! "hh# &   k844 4 44!**,,G      Ntrk)rhrr`ra)NNNFNNF)rdr|r}r^r~rrr\rrrr^rr\r`r^)NNN)rdr|r}r^rr_r`r^)NNrNNrrNrNNNTNrN)"rrr}r^rr]rrrrrr]rr9rr_rr]rr^rr_rr^rr\rr^rr]rrr`r^)rrrrrjrrrrrkrirzrzks  37#-1$(#"5B5B5B5B5Br37#!% BBBBB8PT#-1)-*1"%) $"& !%15#9999999rkrzrr]rdr|r}r^ct||5}||| |cdddS ddddS#1swxYwYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )r}N) _get_bufferwriter)rrdr}fds rirr s S8 , , ,  ;;;==   s+A AAA1Generator[WriteBuffer[str]] | Generator[StringIO]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.rrr})r}newlinez1buf is not a file name and it has no write method) r3r rr]r hasattrr2open TypeError)rdr}fs rirrs1 S!!jj S ! !NLMMMsG M C   Ms3xx((( #sXr : : : a GGG                   KLLLs&B88B<?B<rPrErTvaluesr5rOrQrVrrTdigitsr_rMstr | int | NonerGrrrrfallback_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 rcdisplay.precision) rrTrVrOrMrGrrrr)r is_np_dtyperW_Datetime64Formatterrr(rr#_Datetime64TZFormatter_Timedelta64Formatterr*r$_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) rrOrVrTrrMrGrrrr fmt_klassfmt_objs rirrBs]R v|S))+( mV,, FL/ 2 2 +* mV,, s + + +) nf-- FL. 1 1+, t , ,+' t , ,+& *  }!"899  ~/00i!#-   G     rkc>eZdZ d#d$dZd%d!Zd%d"ZdS)&rNrPrrErTrr5rrprOrQrTr]rMrPrVrrGrrr_ fixed_widthr\rrrr`rac ||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rrrTrMrOrVrGrrrrr) rhrrrOrTrMrVrGrrrrrs rirjz_GenericArrayFormatter.__init__sb    "(   &*"4rkrcT|}t||jSr)_format_stringsrArG)rhrs rirz!_GenericArrayFormatter.get_results%))++  T\:::rkc  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)Nrcrc0t|dddS)Nz .dr)_trim_zeros_single_float)r< precisions riz8_GenericArrayFormatter._format_strings..s))A+I+++++**rkr~)r quote_stringscxjwt|rht|rY|dS|turt tS|t us&t |tjtj frdSjSt |trt |St |S)Nrar) rTr!r%rr]rrrs datetime64 timedelta64r+)r<rOrhs ri_formatz7_GenericArrayFormatter._format_strings.._formats{&9Q<<&DGG&9!6"WWr77N#XXA r~/N!O!OX 5{"A|,, )1vv 99Q<<(((rkz=ExtensionArray formatting should use _ExtensionArrayFormatterrm)axisrXFz{v}z {v})r_)rVrrOrrr r r4rrrrsndarrayrr map_inferrrr&r.rangeroshaperanyr?rCrs)rhrVrrvalsinferred is_float_typerrrFr_tplrOrs` @@rirz&_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)rr`ractj|i||j7|j2d|_t |jr|j|_d|_dSdSdSdSNF)superrjrVrOrrr)rhargskwargs __class__s rirjzFloatArrayFormatter.__init__s|$)&)))   (T^-C$D )** )!%!2$(!!! ) (-C-C ) )rkNrVr threshold float | Nonerc|jrfdnfdjdkrfdnSfd}|S)z;Returns a function to be applied on each value to format itNcPJt|r |njS)N)value)r&rT)r_rVrhs ribase_formatterz.base_formatters;#/// Qxx%LLq))))rkcNt|rt|njSr)r&r]rT)r_rhs rirz.base_formatter+s !&q:s1vvvt{:rkrcN|djdS)Nrrm)replacer)r_rrhs ridecimal_formatterz?FloatArrayFormatter._value_formatter..decimal_formatter0s'%~a((00dlAFFFrkct|r)t|kr |SdSjS)Ng)r&absrT)rrrhrs rirOz7FloatArrayFormatter._value_formatter..formatter9sLU|| #u:: )),,U333,,S111{"rk)rVr)rhrVrrOrrs``` @@ri_value_formatterz$FloatArrayFormatter._value_formatter s  ,L  ;        ; ; ; ; ; <3   G G G G G G G!/   $ $ # # # # # # #rk np.ndarrayc dd  dd  j jjjSjrt d  nd fd }j9jr*jdurd}nd}t|jj }n j}nfd}||}js|St|dkr(td|D}|j dzk}nd}tj j}|dk}|dj zk|dkz} | s|r6|r4jdurd}nd}t|jj }||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array rr5rOrrTr]r`rct|}tjfdt||dD|j}|S)Nc4g|]\}}|s |nSrr)r6valrrOrTs rir8zWFloatArrayFormatter.get_result_as_array..format_with_na_rep..Os>Q+,7IIcNNNrkTr)r%rsarrayrravelreshaper)rrOrTmask formatteds `` riformat_with_na_repzCFloatArrayFormatter.get_result_as_array..format_with_na_repJs<.format_complex_with_na_repVs'&////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<@@ @rkNzdisplay.chop_thresholdcf| }jdkr djznj}j}t |}|r|||}n |||}jrC|rt |j}nt|j}tj |dS|S)NrDrXobjectrW) rrGrTrrr_trim_zeros_complexr_trim_zeros_floatrsasarray) rVrOrTr is_complexrrr rhrs riformat_values_withzCFloatArrayFormatter.get_result_as_array..format_values_with}s--lIFFI+/,&*@*@S4;&&dkF[F)&11J G33FIvNN++FIvFF :E0FFFF.vt|DDFz&9999MrkTz{value: .{digits:d}f}z{value:.{digits:d}f})rcj|zSr)rV)rrhs rirz9FloatArrayFormatter.get_result_as_array..s):U)Brkrc34K|]}t|VdSrrorVs rir=z:FloatArrayFormatter.get_result_as_array..s(::AQ::::::rkFg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr5rOrrTr]r`r)rOrrTrrrVrr rsrrorErsrr) rhr'fmt_strrVformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrr rs ` @@@riget_result_as_arrayz'FloatArrayFormatter.get_result_as_arrayDs     A A A A< > %%%dk4>4;OO O   "#;<$+FFFL11,?? rkrcDt|Sr)r-r4rs rirz#FloatArrayFormatter._format_stringssD,,..///rkrNN)rVrrrr`r)r`rr)rrrrjrr4r __classcell__rs@rirrs ) ) ) ) ) )04"&66666pA A A A F00000000rkrceZdZddZdS)rr`rc`|jdurd}nd}|jp|fd|jD}|S)NFc2|d|S)Nrr<rsr<s rirz4_IntArrayFormatter._format_strings..shhooo&:&:rkc2|d|S)Nz dr<r=r<s rirz4_IntArrayFormatter._format_strings..sii&6&6&6&;&;rkc&g|] }|Srrr6r<rOs rir8z6_IntArrayFormatter._format_strings..s!888qiill888rk)rrOr)rh formatter_strrrOs @rirz"_IntArrayFormatter._format_stringssP   & &::MM;;MN3m 8888DK888 rkNr)rrrrrrkrirrs(rkrc:eZdZUded< d dfd Zdd ZxZS)rr(rrNnat_repr]rrar`c Xtj|fi|||_||_dSr)rrjrCr)rhrrCrrrs rirjz_Datetime64Formatter.__init__s9 **6*** &rkrcj}jfd|DS|jj}|S)z&we by definition have DO NOT have a TZNc:g|]}|Sr)rOr;s rir8z8_Datetime64Formatter._format_strings..s%666!DNN1%%666rk)rTr)rrO_format_native_typesrCrtolist)rhrrs` rirz$_Datetime64Formatter._format_stringssd > %6666v666 600!>  fk * * 5//11EEJvV444E!  *;;*LL,L1    rkNrrrrrKrrrkrirrs6rkr percentilesnp.ndarray | Sequence[float]ct|dkrgStj|}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%'] rrmz/percentiles should all be in the interval [0,1]dcg|]}|dzSrqrr6rFs rir8z&format_percentiles..Is%%%AC%%%rkr"cg|]}|dzSrWrrXs rir8z&format_percentiles..Qs ! ! !AG ! ! !rk)rorsr%r rr  get_precisionroundastyperpiscloser]unique empty_liker!)rRprecpercentiles_round_typeint_idxout unique_pctss riformat_percentilesresD ;1 *[))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$<.}s4 wK   rkc&t|S)N)rC)rqrps rirz'get_format_datetime64..s+Aw???rkr)rvrCrs ``riget_format_datetime64rzvs? @      @????rkc"eZdZUded<ddZdS)rr(rr`rc|jj}|jt}|jpt ||jfd|D}|S)zwe by definition have a TZ)rc&g|] }|Srrr@s rir8z:_Datetime64TZFormatter._format_strings..s!333qiill333rk)r_is_dates_onlyr\r!rOrzr)rhidorrrOs @rirz&_Datetime64TZFormatter._format_stringssik(##F++N &; T-' ' ' 4333F333 rkNrrQrrkrirrs6      rkrc8eZdZUded< d d fd Zd d ZxZS)rr*rrrCr]r`rac Jtj|fi|||_dSr)rrjrC)rhrrCrrs rirjz_Timedelta64Formatter.__init__s/ **6*** rkrcp|jpt|j|jdfd|jDS)NF)rCboxc&g|] }|Srrr@s rir8z9_Timedelta64Formatter._format_strings..s!222 ! 222rk)rOget_format_timedelta64rrC)rhrOs @rirz%_Timedelta64Formatter._format_stringssJN &< K5' ' ' 3222dk2222rkr)rr*rCr]r`rarrJr8s@rirrsi 33333333rkrFr* 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)Nr=')r!r%rr _repr_base)r<rrrsrCs rirOz*get_format_timedelta64.._formattersm 919$q''9N!Y'' ! AV,,  #"]]]F rk)r~)rrCr even_daysrOrss `` @rirrsN%I        rkr3r4rfprinting._TextAdjustment | Nonec\t|dks|dkr|S|tjn|tfd|D|t|t dkrd fd fd |D}|| }|S) Nrrc3BK|]}|VdSrr*)r6r< adjustments rir=z$_make_fixed_width..s/55*..##555555rkrr<r]r`cl0dk|kzr|ddz dz}|S)Nrrr*)r<rconf_maxrKs rijustz_make_fixed_width..justsG  1 !2!2W!<= -m! m$u,rkc&g|] }|Srr)r6r<rs rir8z%_make_fixed_width..s!(((1ttAww(((rkr)r<r]r`r])ror4rerErrG) r3rGr4rfrrrrrKs @@@@rirArAs  7||qGu,, {,..  5555W55555Ggw''011H( 2 2 )((((((G   w  ? ?F Mrk str_complexesc gg}}|D]w}tjd|}|d|dd|d|ddxt |}t ||z|}t |dkrgSt d|Ddz fd t|d|||dd D}|S) 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 ;;;;;;rkrmcRg|]#\}}||dz|dddzdz$S)rrmN>rr)r6real_ptimag_pt padded_lengths rir8z'_trim_zeros_complex..sc GW  !*  QRR[ += + + + ,  rkTr)rerrCrror$rEr) rr real_part imag_partr<trimmedn padded_partspaddedrs @rir#r#s2 ryI 22 (+Q//"..///B001111 MA$Y%:GDDL <A ;;l;;;;;a?M !$L!$4l1226Ft T T T F Mrk str_floatcd|d}|dr|dz }|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)rs rirr s=   %%I#S rk 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]*$r`r\c2tj|duSr)rmatch)r< number_regexs riis_number_with_decimalz1_trim_zeros_float..is_number_with_decimal#sx a((44rkrrcxfd|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|]}| |Srrr6r<rs rir8z:_trim_zeros_float..should_trim...s*BBB(>(>q(A(AB1BBBrkrc3@K|]}|dVdS)rNrrVs rir=z9_trim_zeros_float..should_trim../s,'I'IA 3'I'I'I'I'I'Irk)ror)rnumbersrs ri should_trimz&_trim_zeros_float..should_trim&sLCBBBfBBB7||aIC'I'I'I'I'I$I$IIrkc>g|]}|r |ddn|S)Nrgrrs rir8z%_trim_zeros_float..2s6OOO!33A66=1SbS66AOOOrkc^g|])}|r|r|dzn|*S)rr)r6r<rrs rir8z%_trim_zeros_float..5sR *)!,,KG1D1DKC!rkrw)rrr`r\)rcompile)rrrrrrrs ` @@rir$r$sG:C7CCCDDL555555 J J J J J J +g  POOOOwOOO +g  PF MrkrSr,cdt|trtj|jS|jduSr)rr-com any_not_nonerorU)rSs rirr<s1%$$&--z%%rkceZdZdZidddddddd 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 iyiziairipiriurrr}rr^r+r GrTPEZYNFaccuracyr_use_eng_prefixr\r`rac"||_||_dSrrr)rhrrs rirjzEngFormatter.__init___s! ,rknumfloatr]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 rPinfrmrrgrzE-02dzE+r,Nz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r r]is_nan is_infiniterpmathrkrlrqrE ENG_PREFIXESrrrrs) rhrdnumsignpow10 int_pow10rr format_strr s ri__call__zEngFormatter.__call__es(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 rcN)rrrs riset_eng_float_formatrs&D%|Hn'M'MNNNNNrkr}levelsrsentinelbool | 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)ror?rC) rrcontrolrlevel last_indexlengthsrFkeys riget_level_lengthsrs$ 6{{a fs6!9~~%G F &&  FAsqz cXoo" &'*n # !%jj:5  g MrkWriteBuffer[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]rVs rir=z#buffer_put_lines..s, - -!:a   - - - - - -rkc,g|]}t|SrrdrVs rir8z$buffer_put_lines..s'''AQ'''rkrN)rrr)rdrs ribuffer_put_linesrsZ - -u - - ---('''''IIdiirk)r`rr6)rr]rdr|r}r^r`r^r)rdr|r}r^r`r) NrPNNrErTNN)rr5rOrQrVrrTr]rr_rMrrGr]rr]rrrr_rrQr`r)rRrSr`r)rrSr`rpr)r<rnrCr]r`r]rI)r<rnrCr]rr^r`r])rvr\rCr]rr^r`r)rF)rr*rCrrr\r`r)rENN) r3rrGr]r4r_rfrr`r)r)rr5rr]r`r)rr]r`r])rrrr]r`r)rSr,r`r\)rF)rrprr\r`ra)r})rrrrr`r)rdrrrr`ra)r __future__rcollections.abcrrrrr contextlibr csvr rr functoolsr ior rrshutilrtypingrrrrnumpyrspandas._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@rrArBrCrKVALID_JUSTIFY_PARAMETERSrMrOrrrrzrrrrrrrrrerZrqrurzrrrrAr#rr$rrrrrrrkrirs #"""""&%%%%% $$$$$$ ###### 0/////......   *)))))  877777999999'&&&&&                             66666p c$c$c$c$c$c$c$c$L>:IFIFIFIFIFIFIFIFX^^^^^^^^F/3      DHMMMMMP,0"!%*.R R R R R jeeeeeeeePI0I0I0I0I00I0I0I0X/#####1###65B?"?"?"?"D"      JN @ @ @ @ @     1   333332333,!H+/ DB    7:!!!!!H&&&&]]]]]]]]@ HAOAOAOAOAOJ24(((((V       rk