a OfO@s`UdZddlmZddlmZmZmZmZddlm 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 lBmCmDZEddlFmGZGmHZHmIZImJZJddlKmLZLddlMmNZNddlOmPZPddlQmRZRmSZSddlTmUZUerddlVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZambZbddlcmdZdmeZedZfd egd!<d"Zhd#Zid egd$<Gd%d&d&Zjd'd(d)d*Zkd'd(d+d,ZlGd-d.d.ZmGd/d0d0Zndd1d2d3d3d4d5d6Zoe dd2d3d7d8d9d:Zpdd?d@dAd1dBdCd1d1dDdBd@dEdF dGdHZqGdIdJdJZrGdKdLdLerZsGdMdNdNerZtGdOdPdPerZuGdQdRdRerZvdSdEdTdUdVZwdSdWdXdYdZZxdd\d1d1d]d^d_Zydd\d1d3d1d`dadbZzddcd1d3dddedfdgZ{GdhdidieuZ|GdjdkdkerZ}ddmdndcdddodpdqZ~ddEd1dBdrdEdsdtduZdd?d1dEdvdwdxZd1d1dydzd{Zdd|d1dEd}d~dZddcdddZGdddZddWdcddddZdddddddZddEddddZd 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-parentinitialZunsetz Returns ------- str or None If buf is None, returns the result as a string. Otherwise returns None. return_docstringc @seZdZdZdddddddddd ddd d d d d d d d d d ddZd dddZd dddZddddZd dddZdS)SeriesFormatterz\ Implement the main logic of Series.to_string, which underlies Series.__repr__. TNaNFN) lengthheaderindexna_repname float_formatdtypemax_rowsmin_rowsrB bool | strboolstr str | None int | NoneNone) seriesrOrPrQrRrSrTrUrVrWreturnc Csj||_t|_||_||_||_||_||_| |_| |_ |durHt d}||_ ||_ t |_|dS)Ndisplay.float_format)r^r bufrSrRrPrOrQrVrWrrTrUr4get_adjustmentadj _chk_truncate) selfr^rOrPrQrRrSrTrUrVrWrfQ/var/www/ai-form-bot/venv/lib/python3.9/site-packages/pandas/io/formats/format.py__init__s zSeriesFormatter.__init__r_cCs||j}|j}|o t|j|k}|j}|rtt|}|rDt||}|dkr`|}|jd|}n*|d}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rWrVlenr^rintminilocr1 tr_row_num tr_seriesis_truncated_vertically)rerWrVrrr^row_numrfrfrgrds$  "zSeriesFormatter._chk_truncatecCs4|jj}d}|jj}t|tttfr>|jdur>|d|j7}|jdurx|durx|r\|d7}t j |dd}|d|7}|j dus|j d kr|j r|r|d7}|d t |j7}|jdur|jdurt|jjd d}|r|r|d7}|d t |7}t|jjtr,|jj}|r$|d 7}||7}t|S)NzFreq: Fz,    ) escape_charszName: TtruncatezLength: rSzdtype: rx)r^rSrQ isinstancer/r-r0freqZfreqstrr4 pprint_thingrOrrrlrUgetattrrqr _valuesZ_get_repr_footerrZ)rerSfooterrQZ series_nameZ dtype_nameZ level_inforfrfrg _get_footersB  zSeriesFormatter._get_footer list[str]cCst|jjd|j|j|jdS)N)rTrR leading_space) format_arrayrqrrTrRrQrerfrfrg_get_formatted_values(sz%SeriesFormatter._get_formatted_valuesc Cs~|j}|}t|dkr2t|jjd|dS|j}t|}t|t rz|j ddd}t }|j dg|Rd}n |jdd}|}|jrd}|j} tt| } |j|| d } | d krd } nd } |jj| g| d dd} || || || d d|jr2|jj d g|d d|gR} n|j d |} |jr^|r^|dd| } |rp| d|7} td| S)Nrz([], )T) include_namessparsifyrkrx include_namerj...z..rFmodert)rqrrltyper^__name__rQ _has_namesr{r, _format_multir4rbadjoinsplit _format_flatrrrrprrmrcrGinsertrPrZjoin) rer^rrQZ have_header fmt_indexrc fmt_valuesZ n_header_rowsrswidthZdot_strresultrfrfrg to_string1s>    " zSeriesFormatter.to_string) r __module__ __qualname____doc__rhrdrrrrfrfrfrgrMs & * rMzdict[str, Any]ricCsLddlm}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)rVrWmax_colsZ max_colwidthshow_dimensions line_width)pandas.io.formatsrrZget_console_size)rr_rfrfrgget_dataframe_repr_params_s rcCsJt\}}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)rSrUrWrVrO)r r)rheightZ max_rows_optrVrWrfrfrgget_series_repr_paramss rc@sXeZdZdZerendZeee7Zdjdd d d d d ddddd ddddd d d ddddZddddZed dddZ ed dddZ ed dd d!Z ed dd"d#Z ed dd$d%Z ed dd&d'Zed dd(d)Zed dd*d+Zed dd,d-Zed.dd/d0Zdd d1d2d3Zdd4d5d6d7Zdd d8d9d:Zd d;d<d=d>Zd d?d@dAdBZdddCdDZdddEdFZdddGdHdIZd ddJdKZd ddLdMZd ddNdOZd.ddPdQZdddRdSZdddTdUZ dddVdWZ!dddXdYZ"d.dZd[d\d]Z#d^d_d[d`daZ$dddbdcddZ%ddZdbdedfZ&dgddhdiZ'dS)kDataFrameFormatterz Class for processing dataframe formatting options and data. Used by DataFrame.to_string, which backs DataFrame.__repr__. rtNTrNF.rAz Axes | NonezColspaceArgType | Nonezbool | SequenceNotStr[str]rYrZzFormattersType | Noner[FloatFormatType | None bool | Noner\rXr])framecolumns col_spacerPrQrR formattersrGrTr index_namesrVrWrrdecimal bold_rowsescaper_cCs||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t|_dSN) r_initialize_columnsr_initialize_colspacerrPrQrR_initialize_formattersr_initialize_justifyrGrT_initialize_sparsifyrshow_index_namesrrrrVrWrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerzr4rbrc)rerrrrPrQrRrrGrTrrrVrWrrrrrrfrfrgrhs.       zDataFrameFormatter.__init__zlist[list[str]]ricCs*|}|jr&||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrQ_get_formatted_indexrr)restrcolsZ str_indexrfrfrg get_strcolss   zDataFrameFormatter.get_strcolscCs|jdup|jdko|jS)NTrz)r is_truncatedrrfrfrgshould_show_dimensionss z)DataFrameFormatter.should_show_dimensionscCst|jp |jSr)rYis_truncated_horizontallyrrrrfrfrgrszDataFrameFormatter.is_truncatedcCst|jot|j|jkSr)rYrrlrrrfrfrgrsz,DataFrameFormatter.is_truncated_horizontallycCst|jot|j|jkSr)rYrrlrrrfrfrgrrsz*DataFrameFormatter.is_truncated_verticallycCs dt|jdt|jjdS)Nz [z rows x z columns])rlrrrrfrfrgdimensions_infosz"DataFrameFormatter.dimensions_infocCs t|jjSr)rrrQrrfrfrghas_index_namessz"DataFrameFormatter.has_index_namescCs t|jjSr)rrrrrfrfrghas_column_namessz#DataFrameFormatter.has_column_namescCst|j|j|jfSr)allrrQrrrfrfrgshow_row_idx_namessz%DataFrameFormatter.show_row_idx_namescCst|j|j|jfSr)rrrrPrrfrfrgshow_col_idx_namessz%DataFrameFormatter.show_col_idx_namesrmcCst|jpt|jt|jSr)rnrVrlrrrfrfrgmax_rows_displayed sz%DataFrameFormatter.max_rows_displayed)rr_cCs|durtdS|S)Nzdisplay.multi_sparser)rerrfrfrgrsz'DataFrameFormatter._initialize_sparsifyr<)rr_cCsT|dur iSt|jjt|ks*t|tr.|Stdt|dt|jjddS)NzFormatters length(+) should match DataFrame number of columns(r)rlrrr{dict ValueError)rerrfrfrgrs  z)DataFrameFormatter._initialize_formatters)rGr_cCs|durtdS|SdS)Nzdisplay.colheader_justifyr)rerGrfrfrgr sz&DataFrameFormatter._initialize_justifyr+)rr_cCs,|dur t|}|j||_|S|jjSdSr)r.rr)rercolsrfrfrgr&s  z&DataFrameFormatter._initialize_columnsr8)rr_csduri}ntttfrBdi}|fdd|jjDnttrD]&}||jjvrT|dkrTtd|qT}nHt |jjt krtdt dt |jjdt t |jj}|S)Nrtcsi|] }|qSrfrf).0columnrrfrg 5z;DataFrameFormatter._initialize_colspace..z,Col_space is defined for an unknown column: zCol_space length(rr) r{rmrZupdaterrrkeysrrlrzip)rerrrrfrrgr.s(    z'DataFrameFormatter._initialize_colspacecCs0|s|jSt\}}||r&|S|jSdS)z%Number of columns fitting the screen.N)_is_in_terminalrr _is_screen_narrow)rerrrfrfrgrFs   z(DataFrameFormatter._calc_max_cols_fittedcCsP|r@t\}}|jdkr(||S||r8|}qF|j}n|j}||S)z,Number of rows with data fitting the screen.r)rr rV_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rerrrVrfrfrgrQs    z(DataFrameFormatter._calc_max_rows_fitted)rVr_cCs(|r$t|j|kr$|jr$t|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 )rlrrWrn)rerVrfrfrgrds z#DataFrameFormatter._adjust_max_rowscCst|jdkp|jdkS)z/Check if the output is to be shown in terminal.r)rYrrVrrfrfrgrrsz"DataFrameFormatter._is_in_terminalcCst|jdkot|jj|kSNr)rYrrlrr)re max_widthrfrfrgrvsz$DataFrameFormatter._is_screen_narrowcCst|jdkot|j|kSr)rYrVrlr)re max_heightrfrfrgrysz#DataFrameFormatter._is_screen_shortcCs:d}d}||}|jr(|t|j7}|jr6|d7}|S)z?Get number of rows occupied by prompt, dots and dimension info.rj)rrlr splitlinesrP)reZdot_rowZ prompt_rowZnum_rowsrfrfrgr|sz0DataFrameFormatter._get_number_of_auxiliary_rowscCs |jr||jr|dS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyrr_truncate_verticallyrrfrfrgrzszDataFrameFormatter.truncatecCs|jdusJ|jd}|dkr|jjddd|f}|jjdd| df}t||fdd|_t|jttfrg|jd||j| d|_n&tt |j }|jjddd|f|_||_ dS)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num NrkrjZaxis) rrror1r{rlisttuplerrmrZ tr_col_num)reZcol_numrDrErfrfrgrs   z)DataFrameFormatter._truncate_horizontallycCs|jdusJ|jd}|dkrZt|j}tt|t|||g}|jj||_n&tt|j }|jjd|ddf|_||_ dS)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrkrj) rrlrnpZhstackZarangerorrmrVrp)rers_lenZ_slicerfrfrgrs    z'DataFrameFormatter._truncate_verticallyc sg}tjsbjsbtjD]>\}}|}t|jtj |dj d}| |q|Stjrt t tj_tjtjkrtdtjdtjdddjD}n j}jr|D]}| dqtjD]\}}||}ttj |dgfd d |DR}|}t|j|j d }tgfd d |D|R} j j|| jd }| ||q|S)Nr)stringsrGminimumrczWriting z cols but got z aliasescSsg|] }|gqSrfrf)rlabelrfrfrg rzADataFrameFormatter._get_strcols_without_index..rtc3s|]}j|VqdSrrcrlrxrrfrg rz@DataFrameFormatter._get_strcols_without_index..)rrcc3s|]}j|VqdSrrrrrfrgrrr)rrP enumerater format_col_make_fixed_widthrGrmrgetrcappendrrrZrlrr_get_formatted_column_labelsrmax) rericr str_columnsrZcheaderZheader_colwidthmax_lenrfrrgrsP        z-DataFrameFormatter._get_strcols_without_indexr)rr_c CsL|j}||}t|jdd|fj||j|j|j|j ||j |j dS)N)rTrRspacerr) r_get_formatterrrorrTrRrrrrrQ)rerr formatterrfrfrgrs zDataFrameFormatter.format_col str | intCallable | NonecCs`t|jttfr2t|r,tt|}|j|SdSn*t|rN||jvrN|j|}|j|dSdSr) r{rrrrrrmrr)rerrfrfrgrs   z!DataFrameFormatter._get_formatter)rr_csddlm}|j}t|tr|jddd}tt|}jj j }t dd|j Dt t|tt|fddttfd d|D}jrt|r||}d d t|D}n@|jdd }jj }t t|tt|fd d t|D}|S)Nr)sparsify_labelsF)rrcss|] }|jVqdSr)Z is_floating)rlevelrfrfrgrrzBDataFrameFormatter._get_formatted_column_labels..cs"|jvr|rsd|S|S)N )r)ry) need_leadsprestrict_formattingrerfrg space_formatszEDataFrameFormatter._get_formatted_column_labels..space_formatc3s"|]fddDVqdS)csg|]}|qSrfrf)rr )rrrfrgr rzMDataFrameFormatter._get_formatted_column_labels...Nrf)r)rrrgr rcSsg|] }t|qSrf)rrrfrfrgr%rzCDataFrameFormatter._get_formatted_column_labels..rcs0g|](\}}|s&|r&d|n|gqS)r )r)rrr)r rerfrgr*s)Zpandas.core.indexes.multir rr{r,rrrrdtypesranylevelsrmaprrrlrr)rerr rZ fmt_columnsrZstr_columns_tuplerrf)r rrerrgrs,       z/DataFrameFormatter._get_formatted_column_labelscsddjD|j}|j}d}t|trJ|jjj |d}n|j j |dg}fdd|D}j j dg|R d }jrd dD}n d g|j}jr||S|SdS) NcSsi|]\}}|tt|qSrf)rrm)rkvrfrfrgr4rz;DataFrameFormatter._get_formatted_index.. __index__)rrr)rrc s.g|]&}ttt|dddjdqS)rDrtr)rGrrc)rrrrrcrrrerfrgrDs z;DataFrameFormatter._get_formatted_index..rjrxcSsg|] }t|qSrfrZrrfrfrgrQrrt)ritemsrQrrr{r,rrrrrcrrr_get_column_name_listZnlevelsrP)rerrQrfmtrZadjoinedZ col_headerrfrrgr1s,     z'DataFrameFormatter._get_formatted_indexzlist[Hashable]cCsLg}|jj}t|tr.|dd|jDn||jdur@dn|j|S)Ncss|]}|durdn|VqdS)Nrtrf)rrSrfrfrgr^rz;DataFrameFormatter._get_column_name_list..rt)rrr{r,extendnamesrrS)rerrrfrfrgrZs  z(DataFrameFormatter._get_column_name_list)NNTTrNNNNNTNNNFrFT)(rrrrrCrLrhrpropertyrrrrrrrrrrrrrrrrrrrrrrrrzrrrrrrrrrfrfrfrgrs~  4/    /  ))rc@seZdZdZdddddZd$d d d d d d d d dddZd%d d dd dddZd&dd dddddddd dd d d dd d d!d"d#ZdS)'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. rr])rr_cCs ||_dSr)r)rerrfrfrgrhuszDataFrameRenderer.__init__NF"FilePath | WriteBuffer[str] | Noner[zstr | list | tuple | NonerYzint | bool | None)raencodingclassesnotebookbordertable_id render_linksr_c CsFddlm}m} |r| n|} | |j||||d} | } t| ||dS)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)r#r%r&r'rar")Zpandas.io.formats.htmlr(r)rrsave_to_buffer) rerar"r#r$r%r&r'r(r)ZKlassZhtml_formatterstringrfrfrgto_htmlxs" zDataFrameRenderer.to_htmlr\)rar"rr_cCs0ddlm}||j|d}|}t|||dS)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*)Zpandas.io.formats.stringr.rrr+)rerar"rr.Zstring_formatterr,rfrfrgrs zDataFrameRenderer.to_string,winfer"Tstrictz7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | NonerZzSequence[Hashable] | NonezIndexLabel | Noner9zStorageOptions | None) path_or_bufr"sepr index_labelr compressionquoting quotecharlineterminator chunksize date_format doublequote escapecharerrorsstorage_optionsr_cCsddlm}|dur d}t}nd}||| ||||||||| | | | |||jd}||r~t|tsjJ|}||SdS)z; Render dataframe as comma-separated file. r) CSVFormatterNTF)r4r:r5r"r?r7r8rr6rr;r9r<r=r>r@r)Zpandas.io.formats.csvsrAr rsaver{getvalueclose)rer4r"r5rr6rr7r8r9r:r;r<r=r>r?r@rAZcreated_bufferZ csv_formattercontentrfrfrgto_csvs> zDataFrameRenderer.to_csv)NNNFNNF)NNN)NNr/NNr0r1Nr2NNNTNr3N)rrrrrhr-rrFrfrfrfrgr ds>5r rZr!r[)r,rar"r_cCsZt||d:}|||dur6|WdSWddS1sL0YdS)zQ Perform serialization. Write to buf or return as string if buf is None. )r"N) _get_bufferwriterC)r,rar"fdrfrfrgr+s  r+zIGenerator[WriteBuffer[str], None, None] | Generator[StringIO, None, None])rar"r_ccs|durt|}nt}|dur&d}nt|ts8tdt|drJ|VnVt|trtt|t|d|dd}|VWdq1s0YntddS) 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.rHr0rt)r"newlinez1buf is not a file name and it has no write method) r3r r{rZrhasattrr2open TypeError)rar"frfrfrgrGs     &rGrNrErTr5rrr\zstr | int | Nonerr) valuesrrTrRdigitsrrGrrr8fallback_formatterr_c Cst|jdrt} tt|}nxt|jtr:t} tt|}n\t|jdrXt } tt |}n>t|jt rjt } n,t|jdr~t } nt|jdrt} nt} |durd}|durtd}|durtd}| |||||||||| | 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 r`display.precision) rPrRrTrrrGrrr8rQ)rZ is_np_dtyperU_Datetime64Formatterrr&r{r!_Datetime64TZFormatter_Timedelta64Formatterr(r"_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) rOrrTrRrPrrGrrr8rQZ fmt_klassZfmt_objrfrfrgr7sH)     rc@sPeZdZddd d d d d d d dddd dd ddZddddZddddZdS)r^NrNrVrErTr5rmrrZrrr\rYrr]) rOrPrrRrrTrGrr8 fixed_widthrrQr_c CsL||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rOrPrRrrrTrGrr8rarrQ) rerOrPrrRrrTrGrr8rarrQrfrfrgrhsz_GenericArrayFormatter.__init__rricCs|}t||jSr)_format_stringsrrG)rerrfrfrgr_sz!_GenericArrayFormatter.get_resultc s~jdur0td}|dur6tdfdd}nj}jdurHjn6jdurZjn$jduoljtk}ttjd|dfdd}j }t |t j st d t|t}|t jt|ttd t|jd @}j}|dur|}g}t|D]~\} } || rjdur4|r4|d || q|| rN||| q|d ur^d} nd} || j|| dq|S)Nr`rWcst|dddS)Nz .drN)_trim_zeros_single_floatr) precisionrfrgsz8_GenericArrayFormatter._format_strings..ru)ry quote_stringscsjdurvt|rvt|rv|dur&dS|tur6ttSt|rRt|rRt|S|t uslt |tj tj frpdSjSt |t rt|St |trt|St|SdS)Nr]r)rRrr#rrZrrrisinfrr{Z datetime64Z timedelta64r*r)reprr)rrerfrg_formats  z7_GenericArrayFormatter._format_strings.._formatz=ExtensionArray formatting should use _ExtensionArrayFormatterrjrr Fz{v}z {v}r)rTrrrQr8rr r4r}rOr{rZndarrayrMrZ map_inferrrr$rrangerlshaperrrrformat) rerTrgrjvalsinferredZ is_float_typerrrrZtplrf)rrerergrbsR        z&_GenericArrayFormatter._format_strings) r`NrNrVNrErNTTN)rrrrhr_rbrfrfrfrgr^s(r^csReZdZddfdd Zddddd d d Zd dd dZddddZZS)r\r]ricsHtj|i||jdurD|jdurDd|_t|jrD|j|_d|_dS)NF)superrhrTrracallable)reargskwargs __class__rfrgrhs  zFloatArrayFormatter.__init__Nrz float | Noner)rT thresholdr_csldurjr"fddn fddjdkrHfddndurXSfdd }|S) z;Returns a function to be applied on each value to format itNcs$dus Jt|r|dSjS)Nvalue)r$rRrk)rTrerfrgbase_formatters   z.base_formattercst|rt|SjSr)r$rZrRrkrrfrgrz&srcs|djdS)Nrrj)replacerrk)rzrerfrgdecimal_formatter+sz?FloatArrayFormatter._value_formatter..decimal_formattercs0t|r&t|kr|SdSnjSdS)Ng)r$absrRrx)r|rerwrfrgr4s   z7FloatArrayFormatter._value_formatter..formatter)rTr)rerTrwrrf)rzr|rTrerwrg_value_formatters   z$FloatArrayFormatter._value_formatterz np.ndarrayc slddddddddddddjd ur@jjjSjrPtd nd fd d }jd urjrjd urd}nd}t|jj d}qj}n fdd}||}js|St |dkrt dd|D}|j dk}nd}t j}|dk}|dj k|dk@} | s:|rh|rhjd urLd}nd}t|jj d}||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array r5rrZ)rOrrRcs<t|}tfddt||D|j}|S)Ncs g|]\}}|s|nqSrfrf)rvalrSrrRrfrgrHszWFloatArrayFormatter.get_result_as_array..format_with_na_rep..)r#rarrayrravelreshaperm)rOrrRmask formattedrfrrgformat_with_na_repEs zCFloatArrayFormatter.get_result_as_array..format_with_na_repcSst|}t|}t|t|}}g}t|||||D]\}} } } } | sl| sl|||qF| s||| d|dqF| s|| } | dr||| dq||d| dqF||d|dqFt | |j S)N+j-) rrealrimagr#rrstrip startswithrrrm)rOrrRZ real_valuesZ imag_valuesZ real_maskZ imag_maskZ formatted_lstrZreal_valZimag_valZre_isnaZim_isnaZimag_formattedrfrfrgformat_complex_with_na_repOs,  zKFloatArrayFormatter.get_result_as_array..format_complex_with_na_repNzdisplay.chop_thresholdcs|}jdkr djnj}j}t|}|rF|||}n |||}jr|rjt|j}n t|j}t j |ddS|S)NrDr objectrU) r~rGrRrOrra_trim_zeros_complexr_trim_zeros_floatrasarray)rTrrRrOZ is_complexrrrrerwrfrgformat_values_withus   zCFloatArrayFormatter.get_result_as_array..format_values_withTz{value: .{digits:d}f}z{value:.{digits:d}f})rPcs j|Sr)rTrxrrfrgrfrz9FloatArrayFormatter.get_result_as_array..rcss|]}t|VqdSrrlrrfrfrgrrz:FloatArrayFormatter.get_result_as_array..Fg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rrOrRrarrTrr rnrPrlrrr}r) rerZfmt_strrTZformatted_valuesmaxlenZtoo_longZabs_valsZhas_large_valuesZhas_small_valuesrfrrgget_result_as_array?sB          z'FloatArrayFormatter.get_result_as_arrayrcCs t|Sr)rrrrfrfrgrbsz#FloatArrayFormatter._format_strings)NN)rrrrhr~rrb __classcell__rfrfrurgr\s8r\c@seZdZddddZdS)r]rrics>|jdurdd}ndd}|jp$|fdd|jD}|S)NFcSs|dj|dS)Nrcrrnrrfrfrgrfrz4_IntArrayFormatter._format_strings..cSs|dj|dS)Nz drrrrfrfrgrfrcsg|] }|qSrfrfrrrfrgrrz6_IntArrayFormatter._format_strings..)rrrO)reZ formatter_strrrfrrgrbs    z"_IntArrayFormatter._format_stringsN)rrrrbrfrfrfrgr]sr]csBeZdZUded<ddddddfdd Zd d d d ZZS)rXr&rOrNrZr])rOnat_repr<r_c s$tj|fi|||_||_dSr)rqrhrr<)rerOrr<rtrurfrgrhsz_Datetime64Formatter.__init__rrics<j}jdur"fdd|DS|jjjd}|S)z&we by definition have DO NOT have a TZNcsg|]}|qSrfrrrrfrgrrz8_Datetime64Formatter._format_strings..)rRr<)rOrZ_format_native_typesrr<tolist)rerOrrfrrgrbs z$_Datetime64Formatter._format_strings)rNrrr__annotations__rhrbrrfrfrurgrXs  rXc@s$eZdZUded<ddddZdS)r[r'rOrric Csx|j}|j}d}|dur$|jdd}t|tr8|}ntj|td}t |||j |j |j |j |j|j|j|j|d }|S)NT)Zboxedr) rTrRrPrrGrrr8rQ)rOr _formatterr{r%Z_internal_get_valuesrrrrrTrRrPrrGrrr8)rerOrrQrrrfrfrgrbs,    z(_ExtensionArrayFormatter._format_stringsNrrrrrbrfrfrfrgr[s r[znp.ndarray | Sequence[float]) percentilesr_cCst|}t|r.t|dkr.t|dks6tdd|}t|}||t}t ||}t|r|t }dd|DSt |}t|}tj |t d}||tt ||<|||t ||<dd|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%'] rrjz/percentiles should all be in the interval [0,1]dcSsg|] }|dqS%rfrrrfrfrgr>rz&format_percentiles..rcSsg|] }|dqSrrfrrfrfrgrFr)rrrrr get_precisionroundastypermiscloserZuniqueZ empty_liker)rprecZpercentiles_round_typeZint_idxoutZ unique_pctsrfrfrgformat_percentiles s*"       rrm)rr_cCsx|ddkr|dnd}|ddkr0d|dnd}tj|||d}t|}ttt|t }td|}|S)Nrr)to_beginto_endrj) rZediff1dr}floorlog10rnrrmr)rrrdiffrrfrfrgrIs rrzNaTType | Timestamp)rrr_cCs|tur |St|Sr)rrZ)rrrfrfrg_format_datetime64Ssr)rrr<r_cCs&t|tr|S|r||S|jSdSr)r{rstrftimeZ _date_repr)rrr<rfrfrg_format_datetime64_dateonly\s   rrYr) is_dates_onlyrr<r_cs"|rfddSfddSdS)z]Return a formatter callable taking a datetime64 as input and providing a string as outputcst|dS)N)rr<)rrr<rrfrgrfrsz'get_format_datetime64..cs t|dS)Nr)rrrrfrgrfvrNrf)rrr<rfrrgget_format_datetime64ksrc@s$eZdZUded<ddddZdS)rYr&rOrrics>|jj}|jt}|jp&t||jdfdd|D}|S)zwe by definition have a TZ)r<csg|] }|qSrfrfrrrfrgrrz:_Datetime64TZFormatter._format_strings..)rO_is_dates_onlyrrrrr<)reZidorOrrfrrgrb|s z&_Datetime64TZFormatter._format_stringsNrrfrfrfrgrYys rYcs@eZdZUded<d ddddfdd Zd d d d ZZS)rZr(rOrrZr])rOrr_c stj|fi|||_dSr)rqrhr)rerOrrtrurfrgrhsz_Timedelta64Formatter.__init__rrics,|jpt|j|jddfdd|jDS)NF)rboxcsg|] }|qSrfrfrrrfrgrrz9_Timedelta64Formatter._format_strings..)rget_format_timedelta64rOrrrfrrgrbs z%_Timedelta64Formatter._format_strings)rrrfrfrurgrZs  rZFr(z str | float)rOrrr_cs(|j}|rdndfdd}|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 NlongcsN|dust|rt|rSt|ts.t|}|jd}rJd|d}|S)Nr')rr#r{rZ _repr_base)rrrrnrrfrgrs   z*get_format_timedelta64.._formatter)r)rOrrZ even_daysrrfrrgrs  rzprinting._TextAdjustment | None)rrGrrcr_cst|dks|dkr|S|dur*tn|tfdd|D|durVt|tddurrkrrdddfdd fd d |D}j||d }|S) Nrrc3s|]}|VqdSrrr) adjustmentrfrgrrz$_make_fixed_width..rrZ)rr_cs6dur2dk|k@r2|ddd}|S)Nrrrr)rconf_maxrrfrgjustsz_make_fixed_width..justcsg|] }|qSrfrfr)rrfrgrrz%_make_fixed_width..r)rlr4rbrrrG)rrGrrcrrf)rrrrrgrs  r) str_complexesrr_c sgg}}|D]@}td|}|d|dd|d|ddqt|}t|||}t|dkrvgStdd|Dd fd d 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+-])rtNrcss|]}t|VqdSrr)rpartrfrfrgrrz&_trim_zeros_complex..rjcs6g|].\}}||d|ddddqS)rrjN>rrf)rZreal_ptZimag_ptZ padded_lengthrfrgrsz'_trim_zeros_complex..)rerrrrlrrr) rrZ real_partZ imag_partrtrimmednZ padded_partspaddedrfrrgrs    r) str_floatr_cCs |d}|dr|d7}|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)rrfrfrgrds  rdArrayLike | list[str]) str_floatsrr_csp|}tddddfdd dddfd d }||rXfd d |D}q<fd d |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]*$rYricst|duSr)rmatchr) number_regexrfrgis_number_with_decimalsz1_trim_zeros_float..is_number_with_decimalr)rOr_cs0fdd|D}t|dko.tdd|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. csg|]}|r|qSrfrfrrrfrgr#rz:_trim_zeros_float..should_trim..rcss|]}|dVqdS)rNrrrfrfrgr$rz9_trim_zeros_float..should_trim..)rlr)rOnumbersrrfrg should_trimsz&_trim_zeros_float..should_trimcs$g|]}|r|ddn|qS)Nrrfrrrfrgr'rz%_trim_zeros_float..cs*g|]"}|r"|r"|dn|qS)rrr)rrrfrgr*s)rcompile)rrrrrrf)rrrrgr s  rr+)rQr_cCs$t|trtj|jS|jduSdSr)r{r,comZ any_not_nonerrS)rQrfrfrgr1s  rc@s\eZdZdZdddddddd d d d d ddddddZd!ddddddZddddd ZdS)" EngFormatterzl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter r zarNprurSrtrrRGTPEZY)iiiiiiirrr rVNFr\rYr]accuracyuse_eng_prefixr_cCs||_||_dSrrr)rerrrfrfrgrhTszEngFormatter.__init__floatrZ)numr_c Cstt|}t|rdSt|r(dSd}|dkr>d}| }|dkrfttt|dd}ntd}|t |j }| t|j }t|}|j r|j |}n$|dkrd| d}n d |d}||d |}|j d urd }nd |j dd}|j||d} | 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 rNinfrjrrrzE-02dzE+rNz{mant: g}{prefix}z{mant: .rcz f}{prefix})mantprefix)r rZis_nan is_infinitermmathrrrnr ENG_PREFIXESrrrrn) rerZdnumsignZpow10Z int_pow10rr format_strrrfrfrg__call__Zs4       zEngFormatter.__call__)NF)rrrrrrhrrfrfrfrgr8s,rrr]rcCstdt||dS)a Format float representation in DataFrame with SI notation. Parameters ---------- accuracy : int, default 3 Number of decimal digits after the floating point. use_eng_prefix : bool, default False Whether to represent a value with SI prefixes. Returns ------- None Examples -------- >>> 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)rrrrfrfrgset_eng_float_formats7rrtrzbool | object | strzlist[dict[int, int]])rsentinelr_c Cst|dkrgSdgt|d}g}|D]b}d}i}t|D]2\}}||rX||krXq>d||<||||<|}q>t||||<||q*|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)rlrr) rrcontrolrr Z last_indexlengthsrkeyrfrfrgget_level_lengthss    rzWriteBuffer[str])ralinesr_cCs4tdd|Dr dd|D}|d|dS)z Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. css|]}t|tVqdSr)r{rZrrfrfrgrrz#buffer_put_lines..cSsg|] }t|qSrfrrrfrfrgr rz$buffer_put_lines..rxN)rrHr)rarrfrfrgbuffer_put_liness r )NN)N) NrNNNrErTNN)r)rN)rN)rF)rENN)r)r)rF)rt)r __future__rcollections.abcrrrr contextlibrcsvrrr functoolsr ior rrshutilr typingr rrrrnumpyrZpandas._config.configrrZ pandas._libsrZpandas._libs.missingrZpandas._libs.tslibsrrrZpandas._libs.tslibs.nattyperZpandas.core.dtypes.commonrrrrrrZpandas.core.dtypes.dtypesr r!r"Zpandas.core.dtypes.missingr#r$Zpandas.core.arraysr%r&r'r(Zpandas.core.arrays.string_r)Zpandas.core.baser*Zpandas.core.commoncorecommonrZpandas.core.indexes.apir+r,r-r.Zpandas.core.indexes.datetimesr/Zpandas.core.indexes.timedeltasr0Zpandas.core.reshape.concatr1Zpandas.io.commonr2r3rr4Zpandas._typingr5r6r7r8r9r:r;r<r=r>r?r@ZpandasrArBrCrZVALID_JUSTIFY_PARAMETERSrLrMrrrr r+rGrr^r\r]rXr[rrrrrrYrZrrrrdrrrrrr rfrfrfrgs                 8 8 #!H (&UnJ !?  $"! $`;+