o ҷh)@sNUdZddlmZddlmZmZmZmZmZddl m Z ddl m Z m Z ddlmZddlmZddlmZdd lZdd lZdd lmZdd lmZmZmZmZmZmZdd lm Z dd l!Z"dd l#m$Z$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0ddl1m2Z2ddl3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9ddl:m;Z;mm?Z?m@Z@ddlAmBZBmCZCmDZDddlEmFZFddlGmHZHdd lImJmKZLddlMmNZNddlOmPZPmQZQmRZRmSZSddlTmUZUddlVmWZWddlXmYZYddlZm[Z[m\Z\ddl]m^Z^er!ddl_m`Z`maZambZbmcZcmdZdmeZemfZfmgZgmhZhmiZimjZjdd lkmlZlmmZmd!Znd"eod#<d$Zpd%Zqd"eod&<Gd'd(d(ZrGd)d*d*ZsGd+d,d,ZtGd-d.d.etZudd0d1Zvdd3d4Zwdd5d6ZxGd7d8d8ZyGd9d:d:Zz dddAdBZ{e dddDdEZ| F G H I ddd\d]Z}Gd^d_d_Z~Gd`dadae~ZGdbdcdce~ZGdddedee~ZGdfdgdge~ZddjdkZddndoZdddtduZ p dddwdxZ ddd{d|Zdd~dZGdddeZGddde~Z p ddddZ G ddddZddddZdddZ HddddZdddZGdddZddddZ ddddZdddZd S)z Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations) GeneratorHashableIterableMappingSequence)contextmanager) QUOTE_NONEQUOTE_NONNUMERIC)Decimal)partial)StringION)get_terminal_size)IO TYPE_CHECKINGAnyCallableFinalcast)east_asian_width) get_option set_option)lib)NA)NaT Timedelta Timestampget_unit_from_dtypeiNaTperiods_per_day)NaTType)is_complex_dtypeis_float is_integer is_list_likeis_numeric_dtype is_scalar)CategoricalDtypeDatetimeTZDtypeExtensionDtype)isnanotna) Categorical DatetimeArrayTimedeltaArray) StringDtype) PandasObject) extract_array)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)check_parent_directorystringify_path)printing) ArrayLikeAxesColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelStorageOptions 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``. .. versionchanged:: 1.2.0 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@s>eZdZ    ddddZdddZdddZdddZdS)CategoricalFormatterNTNaN categoricalr,bufIO[str] | Nonelengthboolna_repstrfooterreturnNonecCs8||_|dur |ntd|_||_||_||_t|_dSN)rVr rWr[rYr]r quoting)selfrVrWrYr[r]rdK/var/www/html/venv/lib/python3.10/site-packages/pandas/io/formats/format.py__init__s  zCategoricalFormatter.__init__cCsPd}|jr|r |d7}|dt|j7}|j}|r |d7}||7}t|S)Nra, Length:  )rYlenrV_repr_categories_infor\)rcr] level_infordrdre _get_footers z CategoricalFormatter._get_footer list[str]cCst|jdd|j|jdS)N) float_formatr[rb) format_arrayrV_internal_get_valuesr[rbrcrdrdre_get_formatted_valuessz*CategoricalFormatter._get_formatted_valuescCs||j}t|dkr|jr|SdS|}dd|D}d|}d|dg}|jr7|}|r7||td|S) NrracSsg|]}|qSrd)strip.0irdrdre z2CategoricalFormatter.to_string..rg[]ri)rVrjr]rmrsjoinappendr\)rcrV fmt_valuesvaluesresultr]rdrdre to_strings   zCategoricalFormatter.to_string)NTrUT) rVr,rWrXrYrZr[r\r]rZr^r_r^r\r^rn)__name__ __module__ __qualname__rfrmrsrrdrdrdrerTs   rTc@s^eZdZ          d'd(ddZd)ddZd*ddZd+d d!Zd,d#d$Zd*d%d&ZdS)-SeriesFormatterNTrUFseriesrHrWrXrY bool | strheaderrZindexr[r\namero str | Nonedtypemax_rows int | Nonemin_rowsr^r_c Cst||_|dur |nt|_||_||_||_||_||_| |_| |_ |dur*t d}||_ | |_ t |_|dS)Ndisplay.float_format)rr rWrr[rrYrrrrrorget_adjustmentadj _chk_truncate) rcrrWrYrrr[rrorrrrdrdrerf s zSeriesFormatter.__init__cCs||j}|j}|ot|j|k}|j}|rItt|}|r"t||}|dkr0|}|jd|}n|d}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rrrjrrintminilocr8 tr_row_num tr_seriesis_truncated_vertically)rcrrrrrow_numrdrdrer)s$  " zSeriesFormatter._chk_truncatecCs>|jj}d}t|jjdddur&t|jjtttfsJ|d|jjj7}|jdurC|durC|r5|d7}t j |dd}|d|7}|j d usP|j d kr`|j r`|rV|d7}|d t |j7}|jdur|jdurt|jjd d}|r|rz|d7}|d t |7}t|jjtr|jj}|r|d7}||7}t|S)NrafreqzFreq: Frg  ri) escape_charszName: Ttruncaterhrzdtype: ri)rrgetattrr isinstancer6r4r7freqstrr; pprint_thingrYrrjrrr'_valuesrkr\)rcrr] series_name dtype_namerlrdrdrermDs:  zSeriesFormatter._get_footertuple[list[str], bool]cCsX|jj}t|trtdd|jD}|jdd}||fS|jdu}|jdd}||fS)Ncss|]}|VqdSNrdrvrrdrdre qsz7SeriesFormatter._get_formatted_index..T)names)r)rrrr3anyrformatr)rcr have_header fmt_indexrdrdre_get_formatted_indexms   z$SeriesFormatter._get_formatted_indexrncCst|jjd|j|j|jdS)N)ror[ leading_space)rprrror[rrrrdrdrersxsz%SeriesFormatter._get_formatted_valuesc Cs,|j}|}t|dkrt|jjd|dS|\}}|}|jr_d}|j }t t |}|j ||d}|dkrAd} nd} |j j | g|dd d} |||| ||dd |jrs|j jdg|dd|gR} n|j d|} |jr|r|dd | } |r| d |7} td | S) Nrz([], )r...z..rLmoderari)rrmrjtyperrrrsrrrrrrMinsertradjoinrr\r|) rcrr]rrr~ n_header_rowsrwidthdot_strrrdrdrers2   "  zSeriesFormatter.to_string) NTTTrUFNTNN)rrHrWrXrYrrrZrrZr[r\rrZrorrrZrrrrr^r_r^r_r)r^rr) rrrrfrrmrrsrrdrdrdrers"  )  rc@s6eZdZdddZddd ZddddZdddZdS)TextAdjustmentr^r_cCstd|_dS)Nzdisplay.encoding)rencodingrrrdrdrerfszTextAdjustment.__init__textr\rcCst|SrrjrcrrdrdrerjszTextAdjustment.lenrKtextsrmax_lenrrncCstj|||dS)Nr)r;rMrcrrrrdrdrerMzTextAdjustment.justifyspacecOs"tj|g|R|j|jd|S)N)strlenjustfunc)r;rrjrM)rcrlistskwargsrdrdrerszTextAdjustment.adjoinNrrr\r^rrK)rrrrrr\r^rn)rrr^r\)rrrrfrjrMrrdrdrdrers    rcs6eZdZdfdd Zddd Z ddddZZS)EastAsianTextAdjustmentr^r_cs6ttdr d|_nd|_dddddd|_dS)Nz!display.unicode.ambiguous_as_widerr)NaNWFH)superrframbiguous_width_EAW_MAPrr __class__rdrerfs z EastAsianTextAdjustment.__init__rr\rcs(t|ts t|Stfdd|DS)zN Calculate display width considering unicode East Asian Width c3s$|] }jt|jVqdSr)rgetrr)rvcrrrdrers z.EastAsianTextAdjustment.len..)rr\rjsumrrdrrrerjs  zEastAsianTextAdjustment.lenrKr Iterable[str]rrrncsTfdd|dkrfdd|DS|dkr!fdd|DSfdd|DS) Ncs|t|Srr)t)rrcrdre_get_padz1EastAsianTextAdjustment.justify.._get_padrJcg|] }||qSrd)ljustrvxrrdrerxz3EastAsianTextAdjustment.justify..rLcrrd)rLrrrdrerxrcrrd)rjustrrrdrerxrrdrrd)rrrcrerMs zEastAsianTextAdjustment.justifyrrr)rrrrrr\r^rn)rrrrfrjrM __classcell__rdrdrrers   rr^cCstd}|r tStS)Nz display.unicode.east_asian_width)rrr)use_east_asian_widthrdrdrersrdict[str, Any]cCsLddlm}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)rrmax_cols max_colwidthshow_dimensions line_width)pandas.io.formatsrrget_console_size)rr_rdrdreget_dataframe_repr_paramss rcCsNt\}}tddkr |ntd}tddkr|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)rrrrrY)rr)rheightrrrdrdreget_series_repr_paramss   rc@seZdZdZer endZeee7Z                 dtdud(d)Zdvd+d,Zedwd-d.Z edwd/d0Z edwd1d2Z edwd3d4Z edxd5d6Z edwd7d8Zedwd9d:Zedwd;d<Zedwd=d>Zedyd@dAZdzdBdCZd{dEdFZd|dGdHZd}dJdKZd~dMdNZddOdPZddQdRZddSdTZdwdUdVZdwdWdXZdwdYdZZdyd[d\Zdd]d^Zdd_d`Z ddadbZ!dvdcddZ"ddgdhZ#ddkdlZ$ddmdnZ%ddodpZ&ddrdsZ'dS)DataFrameFormatterz;Class for processing dataframe formatting options and data.raNTrUF.framerGcolumns Axes | None col_spaceColspaceArgType | Nonerbool | list[str]rrZr[r\ formattersFormattersType | NonerMrroFloatFormatType | Nonesparsify bool | None index_namesrrrrrrdecimal bold_rowsescaper^r_cCs||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t|_dSr)r_initialize_columnsr_initialize_colspacerrrr[_initialize_formattersr_initialize_justifyrMro_initialize_sparsifyr show_index_namesr r rrrrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerrr)rcrrrrrr[rrMror r rrrrr r rrdrdrerf4s.        zDataFrameFormatter.__init__list[list[str]]cCs*|}|jr||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrrrr)rcstrcols str_indexrdrdre get_strcolscs   zDataFrameFormatter.get_strcolscCs|jdup |jdko |jS)NTr)r is_truncatedrrrdrdreshould_show_dimensionsos z)DataFrameFormatter.should_show_dimensionscCst|jp|jSr)rZis_truncated_horizontallyrrrrdrdreruszDataFrameFormatter.is_truncatedcCt|jo t|j|jkSr)rZrrjrrrrdrdrer!yz,DataFrameFormatter.is_truncated_horizontallycCr"r)rZrrjrrrrdrdrer}r#z*DataFrameFormatter.is_truncated_verticallycCs dt|jdt|jjdS)Nz [z rows x z columns])rjrrrrrdrdredimensions_infos z"DataFrameFormatter.dimensions_infocC t|jjSr) _has_namesrrrrrdrdrehas_index_names z"DataFrameFormatter.has_index_namescCr%r)r&rrrrrdrdrehas_column_namesr(z#DataFrameFormatter.has_column_namescCt|j|j|jfSr)allr'rrrrrdrdreshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namescCr*r)r+r)rrrrrdrdreshow_col_idx_namesr-z%DataFrameFormatter.show_col_idx_namesrcCst|jpt|jt|jSr)rrrjrrrrdrdremax_rows_displayedsz%DataFrameFormatter.max_rows_displayedcC|durtdS|S)Nzdisplay.multi_sparser)rcr rdrdrersz'DataFrameFormatter._initialize_sparsifyrCcCsP|duriSt|jjt|kst|tr|Stdt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rjrrrdict ValueError)rcrrdrdrers  z)DataFrameFormatter._initialize_formatterscCr0)Nzdisplay.colheader_justifyr1)rcrMrdrdrersz&DataFrameFormatter._initialize_justifyr2cCs(|durt|}|j||_|S|jjSr)r5rr)rcrcolsrdrdrers  z&DataFrameFormatter._initialize_columnsr?csduri}|Stttfr#di}|fdd|jjD|SttrDD]}||jjvr?|dkr?td|q,}|St |jjt kr_tdt dt |jjdt t |jj}|S)Nracsi|]}|qSrdrd)rvcolumnrrdre z;DataFrameFormatter._initialize_colspace..z,Col_space is defined for an unknown column: zCol_space length(r2r) rrr\updaterrrkeysr4rjr3zip)rcrrr6rdr7rers0   z'DataFrameFormatter._initialize_colspacecCs,|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr_is_screen_narrow)rcrrrdrdrers   z(DataFrameFormatter._calc_max_cols_fittedcCsP|r t\}}|jdkr||S||r|}n|j}n|j}||S)z,Number of rows with data fitting the screen.r)r=rr_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rcrrrrdrdrers     z(DataFrameFormatter._calc_max_rows_fittedcCs(|rt|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 )rjrrr)rcrrdrdrerAs z#DataFrameFormatter._adjust_max_rowscCst|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)rZrrrrrdrdrer=sz"DataFrameFormatter._is_in_terminalcCst|jdko t|jj|kSNr)rZrrjrr)rc max_widthrdrdrer>sz$DataFrameFormatter._is_screen_narrowcCst|jdko t|j|kSrB)rZrrjr)rc max_heightrdrdrer@sz#DataFrameFormatter._is_screen_shortcCs:d}d}||}|jr|t|j7}|jr|d7}|S)z?Get number of rows occupied by prompt, dots and dimension info.r)rrjr$ splitlinesr)rcdot_row prompt_rownum_rowsrdrdrer?sz0DataFrameFormatter._get_number_of_auxiliary_rowscCs$|jr||jr|dSdS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r!_truncate_horizontallyr_truncate_verticallyrrrdrdrers  zDataFrameFormatter.truncatecCs|jdusJ|jd}|dkrM|jjddd|f}|jjdd| df}t||fdd|_t|jttfrLg|jd||j| d|_ntt |j }|jjddd|f|_||_ dS)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num Nrraxis) rrrr8rrlisttuplerrr tr_col_num)rccol_numrJrKrdrdrerIs     z)DataFrameFormatter._truncate_horizontallycCs|jdusJ|jd}|dkr1|jjd|ddf}|jj| dddf}t||f|_ntt|j}|jjd|ddf|_||_dS)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrr)rrrr8rrrr)rcrheadtailrdrdrerJ9s   z'DataFrameFormatter._truncate_verticallyc sg}tjs1js1tjD]\}}|}t|jtj |dj d}| |q|Stjrct t tj_tjtjkrZtdtjdtjdddjD}nj}jrv|D]}| dqntjD]N\}}||}ttj |dgfd d |DR}|}t|j|j d }tgfd d |D|R} j j|| jd }| ||q{|S)Nr)stringsrMminimumrzWriting z cols but got z aliasescSsg|]}|gqSrdrd)rvlabelrdrdrerxbr9zADataFrameFormatter._get_strcols_without_index..rac3|] }j|VqdSrrrjrrrrdrermz@DataFrameFormatter._get_strcols_without_index..)rTrc3rVrrWrrrrdrertrXr)r$r enumerater format_col_make_fixed_widthrMrrrrr}rrMr\rjrr4_get_formatted_column_labelsr,max) rcrrwrr~ str_columnsrcheaderheader_colwidthrrdrrrerKsP        z-DataFrameFormatter._get_strcols_without_indexrwrnc CsL|j}||}t|jdd|fj||j|j|j|j ||j |j dS)N)ror[rr r) r_get_formatterrprrror[rrrr r)rcrwr formatterrdrdrerZzs zDataFrameFormatter.format_col str | intCallable | NonecCsZt|jttfrt|rtt|}|j|SdSt|r&||jvr&|j|}|j|dSr) rrrMrNr#rrrr)rcrwrdrdreras   z!DataFrameFormatter._get_formattercsddlm}|j}t|tr_|jddd}tt|}jj j }t dd|j Dt t|tt|fddttfd d|D}jrTt|rT||}d d t|D}|S|}jj }t t|tt|fd d t|D}|S) Nr)sparsify_labelsF)r rcss|]}|jVqdSr) is_floating)rvlevelrdrdrerszBDataFrameFormatter._get_formatted_column_labels..cs"|jvr|rsd|S|S)N )r)ry) need_leadsprestrict_formattingrcrdre space_formats zEDataFrameFormatter._get_formatted_column_labels..space_formatc3s$|] fddDVqdS)csg|]}|qSrdrd)rvri)rlrrdrerxzMDataFrameFormatter._get_formatted_column_labels...Nrd)rv)rlrrers"cSg|]}t|qSrd)rMrrdrdrerxryzCDataFrameFormatter._get_formatted_column_labels..cs0g|]\}}|s|rd|n|gqS)rh)ra)rvrwr)rjrcrdrerxs)pandas.core.indexes.multirerrr3rrMr<rdtypesrrlevelsr3mapr%r rjrY)rcrrer fmt_columnsrqr^rd)rjrkrcrlrer\s.       z/DataFrameFormatter._get_formatted_column_labelscsddjD|j}|j}d}t|tr&|jjdj |d}n |jj |dg}fdd|D}j j d g|R d }j rSd dD}nd g|j}jr`||S|S) NcSsi|] \}}|tt|qSrd)rr)rvkvrdrdrer8sz;DataFrameFormatter._get_formatted_index.. __index__F)r rrrb)rrbc s.g|]}ttt|dddjdqS)rJrar)rMrTr)rNr[rMrrrrrcrdrerxsz;DataFrameFormatter._get_formatted_index..rricSrordr\rrdrdrerxryra)ritemsrrrarr3rr r,rrsplitr._get_column_name_listnlevelsr)rcrrrfmtradjoined col_headerrdrxrers,     z'DataFrameFormatter._get_formatted_indexlist[Hashable]cCsNg}|jj}t|tr|dd|jD|S||jdur!dn|j|S)Ncss |] }|dur dn|VqdSr`rdrrdrdrersz;DataFrameFormatter._get_column_name_list..ra)rrrr3extendrr}r)rcrrrdrdrer|s z(DataFrameFormatter._get_column_name_list)NNTTrUNNNNTNNNFrFT)&rrGrrrrrrrrZr[r\rrrMrrorr r r rZrrrrrrrrr r\r rZrrZr^r_)r^rr^rZr)r^r)r r r^rZ)rrr^rC)rMrr^r\)rrr^r2)rrr^r?)r^r)rrr^rr)rwrr^rn)rwrcr^rd)rrGr^r)rrGr^rn)r^r)(rrr__doc__rIrSrfrpropertyr rr!rr$r'r)r,r.r/rrrrrrrrAr=r>r@r?rrIrJrrZrar\rr|rdrdrdrer.s   /                        / )(rc@sreZdZdZd9ddZ      d:d;ddZ   dd?d7d8ZdS)@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. r~rr^r_cCs ||_dSr)r~)rcr~rdrdrerfs zDataFrameRenderer.__init__NFrW"FilePath | WriteBuffer[str] | Nonerrclassesstr | list | tuple | NonenotebookrZborderint | bool | Nonetable_id render_linksc 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)rrrrrWr)pandas.io.formats.htmlrrr~rsave_to_buffer) rcrWrrrrrrrrKlasshtml_formatterstringrdrdreto_htmls" zDataFrameRenderer.to_htmlrrcCs0ddlm}||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)pandas.io.formats.stringrr~rr)rcrWrrrstring_formatterrrdrdrer5s zDataFrameRenderer.to_string,winfer"Tstrict path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Nonesepr\rSequence[Hashable] | None index_labelIndexLabel | Noner compressionr@rb quotecharlineterminator chunksize date_format doublequote escapecharerrorsstorage_optionsStorageOptions | NonecCsddlm}|durd}t}nd}|did|d| d|d |d |d |d |d |d|d|d| d| d| d| d|d|d|j}||rbt|tsXJ|}||SdS)z; Render dataframe as comma-separated file. r) CSVFormatterNTFrrrrrrrbr5rrrrrrrrrbrd)pandas.io.formats.csvsrr r~savergetvalueclose)rcrrrrrrrrbrrrrrrrrrcreated_buffer csv_formattercontentrdrdreto_csvOs^      zDataFrameRenderer.to_csv)r~rr^r_)NNNFNNF)rWrrrrrrrZrrrrrrZr^r)NNN)rWrrrrrr^r)NNrNNrrNrNNNTNrN)"rrrrrr\rrrrrr\rr@rbrrr\rrrrrrrrZrrrr\rrr^r)rrrrrfrrrrdrdrdrers@  5 rrr\rWrrrcCs\t||d}|||dur|WdS WddS1s'wYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) get_bufferwriter)rrWrfrdrdrers $rIGenerator[WriteBuffer[str], None, None] | Generator[StringIO, None, None]ccs|dur t|}nt}|durd}n t|tstdt|dr'|VdSt|trPtt|t|d|dd }|VWddS1sIwYdStd) 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.rrra)rnewlinez1buf is not a file name and it has no write method) r:r rr\r4hasattrr9open TypeError)rWrrrdrdrers       "rrUrKrTrrrbrdrorr[digitsrrstr | int | NonerMr rr rbfallback_formatterrnc Cst|jdr t} n2t|jtrt} n)t|jdrt} nt|jtr&t } nt|jdr0t } n t|jdr:t } nt } |durBd}|durJt d}|durRt d}| |||||||||| | d } | S) a{ Format an array for printing. Parameters ---------- values 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._format_native_types), we don't want the leading space since it should be left-aligned. fallback_formatter Returns ------- List[str] MmfciuN rdisplay.precision) rr[rorbrrMr rrbr)r is_np_dtyperDatetime64Formatterrr(Datetime64TZFormatterTimedelta64Formatterr)ExtensionArrayFormatterFloatArrayFormatterIntArrayFormatterGenericArrayFormatterr get_result) rrbror[rrrMr rrbr fmt_klassfmt_objrdrdrerpsB)  rpc@sBeZdZ           d&d'dd Zd(d"d#Zd(d$d%ZdS))rNrUrrKrTrrrrrbrdr[r\rrcrorrMr rbr fixed_widthrZrr rr^r_c CsL||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rrr[rrbrorMr rbrrr) rcrrrbr[rrorMr rbrrrrdrdrerfs zGenericArrayFormatter.__init__rncCs|}t||jSr)_format_stringsr[rM)rcr~rdrdrer0s z GenericArrayFormatter.get_resultc s|jdurtd}|durtdfdd}nj}jdur$jnjdur-jnjduo6jtk}ttjd|dfdd}t j d d }t |t j sWtd t|t}|t jt|ttd t|jd @}j}|dur{|}g}t|D]:\} } || rjdur|r|d|| q|| r||| q|durd} nd} || j|| dq|S)Nrrcst|dddS)Nz .dr)_trim_zeros_single_floatrn) precisionrdre9sz7GenericArrayFormatter._format_strings..r)r quote_stringsc sjdur;t|r;t|r;z |durWdS|turttWS|tus't|r*WdSWjStt fy:YjSwt |t rDt|St |t rMt |St|S)Nr_r)r[r&r*rr\rnpisnatrr4rr0r/reprrn)rbrcrdre_formatKs&    z6GenericArrayFormatter._format_strings.._formatT extract_numpyz.base_formattercst|rt|SjSr)r+r\r[rrrrdrerrrcs|djdS)Nrr)replacer r)rrcrdredecimal_formattersz?FloatArrayFormatter._value_formatter..decimal_formattercs*t|rt|kr|SdSjS)Ng)r+absr[r)rrcrrdrerbs  z7FloatArrayFormatter._value_formatter..formatter)ror )rcrorrbrd)rrrorcrre_value_formatters  z$FloatArrayFormatter._value_formatter np.ndarrayc sTddddd d jd urjjjSjr td nd fd d}jd urJjrFjdur;d}nd}t|jj d}n j}nfdd}||}jsY|St |dkrpt dd|D}|j dk}nd}t j}|dk}|dj k|dk@} | s|r|rjdurd}nd}t|jj d}||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array rr<rbrr[r\cs<t|}tfddt||D|j}|S)Ncs g|] \}}|s |nqSrdrd)rvvalrrbr[rdrerxszWFloatArrayFormatter.get_result_as_array..format_with_na_rep..)r*rarrayr<ravelreshaper)rrbr[mask formattedrdrreformat_with_na_reps zCFloatArrayFormatter.get_result_as_array..format_with_na_repcSst|}t|}t|t|}}g}t|||||D]R\}} } } } | s6| s6|||q#| sF||| d|dq#| sj|| } | dr^||| dq#||d| dq#||d|dq#t | |j S)N+j-) rrealrimagr*r<r}rt startswithrrr)rrbr[ real_values imag_values real_mask imag_mask formatted_lstrreal_valimag_valre_isnaim_isnaimag_formattedrdrdreformat_complex_with_na_reps,  zKFloatArrayFormatter.get_result_as_array..format_complex_with_na_repNzdisplay.chop_thresholdcs|}jdkrdjnj}j}t|}|r#|||}n|||}jrB|r5t|j}nt|j}t j |ddS|S)NrJrhobjectr) rrMr[rr!r_trim_zeros_complexr _trim_zeros_floatrasarray)rorbr[r is_complexrrrrcrrdreformat_values_withs   zCFloatArrayFormatter.get_result_as_array..format_values_withTz{value: .{digits:d}f}z{value:.{digits:d}f})rcs j|Sr)rorrrrdrer&s z9FloatArrayFormatter.get_result_as_array..rcs|]}t|VqdSrrrrdrdrer2z:FloatArrayFormatter.get_result_as_array..Fg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr<rbrr[r\)rbrr[rrrorr rrrjr]rrr) rcrfmt_strroformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrdrreget_result_as_arraysB           z'FloatArrayFormatter.get_result_as_arrayrncCs t|Sr)rMr%rrrdrdrerHs z#FloatArrayFormatter._format_stringsrNN)rorrrr^r)r^rr)rrrrfrr%rrrdrdrrers 8rc@eZdZdddZdS)rr^rncs>|jdur dd}ndd}|jp|fdd|jD}|S)NFcS|dj|dS)NrrnrrnrdrdrerOz3IntArrayFormatter._format_strings..cSr()Nz drnr)rnrdrdrerQr*cg|]}|qSrdrdrrbrdrerxSryz5IntArrayFormatter._format_strings..)rrbr)rc formatter_strr~rdr,rerMs   z!IntArrayFormatter._format_stringsNrrrrrrdrdrdrerLrcs.eZdZ  ddfd d Zdd dZZS)rrNr3np.ndarray | Series | DatetimeIndex | DatetimeArraynat_repr\rr_r^c $tj|fi|||_||_dSr)rrfr1r)rcrr1rrrrdrerfX zDatetime64Formatter.__init__rncsZj}t|ts t|}jdurtjrfdd|DS|jjjjd}| S)z&we by definition have DO NOT have a TZNcsg|]}|qSrdr,rrrrdrerxkrmz7Datetime64Formatter._format_strings..)r[r) rrr6rbr_data_format_native_typesr1rtolist)rcrr~rdrrrercs z#Datetime64Formatter._format_stringsrN)rr0r1r\rr_r^r_rrrrrfrrrdrdrrerW  rc@r')rr^rnc Cs|t|jdd}|j}d}|dur|jdd}t|tr |}nt|}t |||j |j |j |j |j|j|j|j|d }|S)NTr)boxed) ror[rrrMr rrbr)r1rrb _formatterrr,rqrrrpror[rrrMr rrb)rcrrbrrr~rdrdrerts,     z'ExtensionArrayFormatter._format_stringsNrr.rdrdrdrersr/r percentilesnp.ndarray | Sequence[float]c Cs@t|}t|rt|dkrt|dkstdd|}|t}t||}t|r=|t }dd|DSt |}|ddkrL|dnd}|ddkrZd|dnd}t t t tj|||d t }td|}tj|td }||tt ||<|||t ||<d 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%'] rrz/percentiles should all be in the interval [0,1]dcSg|]}|dqS%rdrurdrdrerxryz&format_percentiles..N)to_beginto_endrcSr?r@rdrurdrdrerxry)rrr%r+r4roundastyperiscloser\uniquefloorlog10rediff1dr] empty_liker)r<percentiles_round_typeint_idxout unique_pctsrCrDprecrdrdreformat_percentiless6 "       rR2np.ndarray | DatetimeArray | Index | DatetimeIndexrZcCs~t|ts |}t|ttfst|}|jdurdS|j}|tk}t|j }t |}t |||dk dk}|r=dSdS)NFrT)rr2rr-r6tzasi8rrrrr logical_andr)r values_intconsider_valuesresoppd even_daysrdrdre is_dates_onlys   r\rrNaTType | Timestampr1cCs|tur|St|Sr)rr\)rr1rdrdre_format_datetime64sr^rcCs"t|tr|S|r||S|jSr)rr strftime _date_repr)rr1rrdrdre_format_datetime64_dateonlys  rais_dates_only_rcs|r fddSfddS)z]Return a formatter callable taking a datetime64 as input and providing a string as outputcst|dS)N)r1r)rarnrr1rdrersz'get_format_datetime64..cs t|dS)Nr1)r^rnrdrdrers rd)rbr1rrdrcreget_format_datetime64s re*np.ndarray | DatetimeArray | DatetimeIndexcCs6t|tjr|jdkr|}t|}|r|pdS|S)z6given values and a date_format, return a string formatrz%Y-%m-%d)rrrndimrr\)rridordrdre!get_format_datetime64_from_valuess ric@r')rr^rncs@t|j}|jt}|jpt||jdfdd|D}|S)zwe by definition have a TZ)rcr+rdrdrr,rdrerx.ryz9Datetime64TZFormatter._format_strings..)r\rrFrrbrer)rcrhrr~rdr,rer's  z%Datetime64TZFormatter._format_stringsNrr.rdrdrdrer&r/rcs.eZdZ  ddfd d ZdddZZS)rrFrnp.ndarray | TimedeltaIndexr1r\boxrZr^r_c r2r)rrfr1rk)rcrr1rkrrrdrerf4r3zTimedelta64Formatter.__init__rncs.|jp t|j|j|jdfdd|jDS)N)r1rkcr+rdrdrr,rdrerxCryz8Timedelta64Formatter._format_strings..)rbget_format_timedelta64rr1rkrrrdr,rer?s z$Timedelta64Formatter._format_stringsrF)rrjr1r\rkrZr^r_rr8rdrdrrer3r9rF,np.ndarray | TimedeltaIndex | TimedeltaArray str | floatrkc s^|tj}|tk}d}||dk}t||}|dk}|r#dndfdd} | 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 l"R:rNlongcsN|dus t|rt|rSt|tst|}|jd}r%d|d}|S)Nr)')r&r*rr _repr_base)rrrkrr1rdrer;es   z*get_format_timedelta64.._formatter)viewrint64rrVr) rr1rkrWrX one_day_nanos not_midnightbothr[r;rdrsrerlFs     rlrSrTrTextAdjustment | Nonecst|dks |dkr |S|durtn|tfdd|D|dur*t|tddur8kr8dfd d fd d |D}j||d }|S)Nrr+c3s|]}|VqdSrrr) adjustmentrdrerz$_make_fixed_width..rrr\r^cs6durdk|k@r|ddd}|S)Nrrrrn)rzconf_maxrrdrejustsz_make_fixed_width..justcr+rdrdr)r}rdrerxryz%_make_fixed_width..r)rr\r^r\)rjrr]rrM)rSrMrTrrrd)rzr|r}rrer[us r[ str_complexesrc sgg}}|D] }td|}|d|dd|d|ddqt|}t|||}t|dkr;gStdd|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+-])raNrcsrrr)rvpartrdrdrerrz&_trim_zeros_complex..rcs6g|]\}}||d|ddddqS)rrN>rrd)rvreal_ptimag_pt padded_lengthrdrerxsz'_trim_zeros_complex..)rer{r}r|rjrr]r<) r~r  real_part imag_partrtrimmedn padded_partspaddedrdrrers    r str_floatcCs |d}|dr|d7}|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)rrdrdrers  r str_floatsnp.ndarray | list[str]csl|}tdddfdd dfd d }||r*fd d |D}||sfd 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]*$r^rZcst|duSr)rmatchrn) number_regexrdreis_number_with_decimalrz1_trim_zeros_float..is_number_with_decimalrrcs0fdd|D}t|dkotdd|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|qSrdrdrrrdrerxsz:_trim_zeros_float..should_trim..rcss|]}|dVqdS)rNrrrdrdrerr{z9_trim_zeros_float..should_trim..)rjr+)rnumbersrrdre should_trimsz&_trim_zeros_float..should_trimcs$g|]}|r|ddn|qS)NrBrdrrrdrerxs$z%_trim_zeros_float..cs*g|]}|r|r|dn|qS)rrr)r rrdrerxsNr)rrr^rZ)rcompile)rr rrrrd)r rrrers  rrr2cCs t|tr tj|jS|jduSr)rr3com any_not_nonerr)rrdrdrer&s   r&c@seZdZdZidddddddd d d d d ddddddddddddddddddd d!d"d#Z %d3d4d,d-Zd5d1d2Zd$S)6 EngFormatterzl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter iriiziairipiriurrrarrurr GrTPEZYNFaccuracyruse_eng_prefixrZr^r_cCs||_||_dSrrr)rcrrrdrdrerf s zEngFormatter.__init__numfloatr\c Cstt|}t|r dSt|rdSd}|dkrd}| }|dkr3ttt|dd}ntd}|t |j }| t|j }t|}|j rX|j |}n|dkrdd| d}nd |d}||d |}|j d urzd }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 rUinfrrrBrzE-02dzE+rNz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r r\is_nan is_infinitermathrIrJrr] ENG_PREFIXESr;rrr) rcrdnumsignpow10 int_pow10rr format_strrrdrdre__call__s4       zEngFormatter.__call__r)rrrrZr^r_)rrr^r\)rrrrrrfrrdrdrdrersP      rrrrrr_cCstdt||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 rN)rrrrdrdreset_eng_float_formatOs7rrarrsentinelbool | object | strlist[dict[int, int]]c Cst|dkrgSdgt|d}g}|D]1}d}i}t|D]\}}||r,||kr,qd||<||||<|}qt||||<||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)rjrYr}) rrrcontrolrrg last_indexlengthsrwkeyrdrdreget_level_lengthss   rWriteBuffer[str]linescCs4tdd|Drdd|D}|d|dS)z Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. css|]}t|tVqdSr)rr\rrdrdrerr{z#buffer_put_lines..cSrordryrrdrdrerxryz$buffer_put_lines..riN)rrr|)rWrrdrdrebuffer_put_liness r)r^r)r^rr&)rr\rWrrrr^rr)rWrrrr^r) NrUNNrKrTNN)rrrbrdrorr[r\rrrrrMr\r r\rr rbrrrdr^rn)r<r=r^rn)rrSr^rZ)r)rr]r1r\r^r\r7)rr]r1r\rrr^r\)rbrZr1r\rrr^r)rrfrrr^rrm)rrnr1rorkrZr^r)rKNN) rSrnrMr\rTrrryr^rn)r)r~rr r\r^rn)rr\r^r\)rrr r\r^rn)rr2r^rZ)rF)rrrrZr^r_)ra)rrrrrr^r)rWrrrnr^r_)r __future__rcollections.abcrrrrr contextlibrcsvr r r r functoolsr ior rrshutilrtypingrrrrrr unicodedatarnumpyrpandas._config.configrr pandas._libsrpandas._libs.missingrpandas._libs.tslibsrrrrrrpandas._libs.tslibs.nattyper pandas.core.dtypes.commonr!r"r#r$r%r&pandas.core.dtypes.dtypesr'r(r)pandas.core.dtypes.missingr*r+pandas.core.arraysr,r-r.pandas.core.arrays.string_r/pandas.core.baser0pandas.core.commoncorecommonrpandas.core.constructionr1pandas.core.indexes.apir2r3r4r5pandas.core.indexes.datetimesr6pandas.core.indexes.timedeltasr7pandas.core.reshape.concatr8pandas.io.commonr9r:rr;pandas._typingr<r=r>r?r@rArBrCrDrErFpandasrGrHrI__annotations___VALID_JUSTIFY_PARAMETERSrSrTrrrrrrrrrrrprrrrrrRr\r^rarerirrrlr[rrrr&rrrrrdrdrdres                    4 ;  @! '  !&C  ( RpJ   E      1 " ! $ `; +