o d<@sZUdZddlmZddlmZddlmZmZddlm Z ddl m Z ddl m Z ddlZddlZdd lmZdd lmZmZmZmZmZmZmZmZmZmZmZmZdd lm Z ddl!Z"dd l#m$Z$m%Z%dd l&m'Z'ddl(m)Z)ddl*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0ddl1m2Z2ddl3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;mZ>ddl?m@Z@mAZAmBZBmCZCmDZDmEZEmFZFmGZGmHZHmIZImJZJmKZKddlLmMZMddlNmOZOmPZPddlQmRZRmSZSmTZTddlUmVZVddlWmXZXddlYmZm[Z\ddl]m^Z^ddl_m`Z`maZambZbmcZcddldmeZeddlfmgZgddlhmiZiddljmkZkmlZlddlmmnZner'ddlompZpmqZqd Zrd!esd"<d#Ztd$Zud!esd%<Gd&d'd'ZvGd(d)d)ZwGd*d+d+ZxGd,d-d-exZydd/d0Zzdd2d3Z{dd4d5Z|Gd6d7d7Z}Gd8d9d9Z~  ddd@dAZe dddCdDZ  E   F G H  ddd[d\ZGd]d^d^ZGd_d`d`eZGdadbdbeZGdcddddeZGdedfdfeZddidjZddmdnZdddsdtZ o dddvdwZ dddzd{Zdd}d~ZGdddeZGdddeZ o ddddZ F  ddddZddddZdddZ GddddZdddZGdddZddddZ ddddZdddZdS)z Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations)contextmanager) QUOTE_NONEQUOTE_NONNUMERIC)Decimal)partial)StringION)get_terminal_size) IO TYPE_CHECKINGAnyCallableFinal GeneratorHashableIterableListMappingSequencecast)east_asian_width) get_option set_option)lib)NA)NaT Timedelta Timestampget_unit_from_dtypeiNaTperiods_per_day)NaTType) ArrayLikeAxesColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelStorageOptions WriteBuffer) is_categorical_dtypeis_complex_dtypeis_datetime64_dtypeis_extension_array_dtypeis_floatis_float_dtype is_integeris_integer_dtype is_list_likeis_numeric_dtype is_scalaris_timedelta64_dtype)DatetimeTZDtype)isnanotna) Categorical DatetimeArrayTimedeltaArray) StringDtype) PandasObject) extract_array)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)check_parent_directorystringify_path)printing) 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 : sequence, 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)r[rr\r`r^rbrquoting)selfr[r\r^r`rbriL/app/.heroku/python/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)Nrf, Length:  )r^lenr[_repr_categories_infora)rhrb level_inforirirj _get_footers z CategoricalFormatter._get_footer list[str]cCst|jdd|j|jdS)N) float_formatr`rg) format_arrayr[_internal_get_valuesr`rgrhririrj_get_formatted_valuessz*CategoricalFormatter._get_formatted_valuescCs||j}t|dkr|jr|SdS|}dd|D}d|}d|dg}|jr7|}|r7||td|S) NrrfcSsg|]}|qSri)strip.0iririrj z2CategoricalFormatter.to_string..rl[]rn)r[rorbrrrxjoinappendra)rhr[ fmt_valuesvaluesresultrbririrj to_strings   zCategoricalFormatter.to_string)NTrZT) r[r<r\r]r^r_r`rarbr_rcrdrcrarcrs)__name__ __module__ __qualname__rkrrrxrriririrjrYs   rYc@s^eZdZ          d'd(ddZd)ddZd*ddZd+d d!Zd,d#d$Zd*d%d&ZdS)-SeriesFormatterNTrZFseriesrMr\r]r^ bool | strheaderr_indexr`ranamert str | Nonedtypemax_rows int | Nonemin_rowsrcrdc Cst||_|dur |nt|_||_||_||_||_||_| |_| |_ |dur*t d}||_ | |_ t |_|dS)Ndisplay.float_format)rrr\rr`rr^rrrrrtrget_adjustmentadj _chk_truncate) rhrr\r^rrr`rrtrrrririrjrk s zSeriesFormatter.__init__cCs||j}|j}|ot|j|k}|j}|rItt|}|r"t||}|dkr0|}|jd|}n|d}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rrrorrintminilocrH tr_row_num tr_seriesis_truncated_vertically)rhrrrrrow_numririrjr)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|jjr|jj}|r|d7}||7}t|S)NrffreqzFreq: Frl  rn) escape_charszName: Ttruncatermrzdtype: rn)rrgetattrr isinstancerFrDrGZfreqstrrK pprint_thingr^rrorrr-_valuesrpra)rhrrbZ series_nameZ dtype_namerqririrjrrDs@   zSeriesFormatter._get_footertuple[list[str], bool]cCsX|jj}t|trtdd|jD}|jdd}||fS|jdu}|jdd}||fS)Ncss|]}|VqdSNrir{rririrj qsz7SeriesFormatter._get_formatted_index..T)names)r)rrrrCanyrformatr)rhr have_header fmt_indexririrj_get_formatted_indexms   z$SeriesFormatter._get_formatted_indexrscCst|jjd|j|j|jdS)N)rtr` leading_space)rurrrtr`rrwririrjrxxsz%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..rQmoderfrn)rrrrotyperrrrxrrrrrrRinsertradjoinrrar) rhrrbrrrZ n_header_rowsrwidthZdot_strrririrjrs2   "  zSeriesFormatter.to_string) NTTTrZFNTNN)rrMr\r]r^rrr_rr_r`rarr_rtrrr_rrrrrcrdrcrdr)rcrr) rrrrkrrrrrxrriririrjrs"  )  rc@s6eZdZdddZddd ZddddZdddZdS)TextAdjustmentrcrdcCstd|_dS)Nzdisplay.encoding)rencodingrwririrjrkszTextAdjustment.__init__textrarcCst|SrrorhrririrjroszTextAdjustment.lenrPtextsr max_lenrrscCstj|||dS)Nr)rKrRrhrrrririrjrRzTextAdjustment.justifyspacecOs"tj|g|R|j|jd|S)N)ZstrlenZjustfunc)rKrrorR)rhrlistskwargsririrjrszTextAdjustment.adjoinNrrrarcrrP)rr rrrrarcrs)rrrcra)rrrrkrorRrriririrjrs    rcs6eZdZdfdd Zddd Z ddddZZS)EastAsianTextAdjustmentrcrdcs6ttdr d|_nd|_dddddd|_dS)Nz!display.unicode.ambiguous_as_widerr)ZNaNWFH)superrkrambiguous_width_EAW_MAPrw __class__rirjrks z EastAsianTextAdjustment.__init__rrarcs(t|ts t|Stfdd|DS)zN Calculate display width considering unicode East Asian Width c3s$|] }jt|jVqdSr)rgetrr)r{crwrirjrs z.EastAsianTextAdjustment.len..)rrarosumrrirwrjros  zEastAsianTextAdjustment.lenrPr Iterable[str]rrrscsTfdd|dkrfdd|DS|dkr!fdd|DSfdd|DS) Ncs|t|Srr)t)rrhrirj_get_padz1EastAsianTextAdjustment.justify.._get_padrOcg|] }||qSri)ljustr{xrrirjr}z3EastAsianTextAdjustment.justify..rQcrri)rQrrrirjr}rcrri)rjustrrrirjr}rrirri)rrrhrjrRs zEastAsianTextAdjustment.justifyrrr)rrrrrrarcrs)rrrrkrorR __classcell__ririrrjrs   rrccCstd}|r tStS)Nz display.unicode.east_asian_width)rrr)Zuse_east_asian_widthririrjrsrdict[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_colsZ max_colwidthshow_dimensions line_width)pandas.io.formatsrrZget_console_size)rr_ririrjget_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)rrrrr^)r r)rheightrrririrjget_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.rfNTrZF.framerLcolumnsSequence[Hashable] | None col_spaceColspaceArgType | Nonerbool | Sequence[str]rr_r`ra formattersFormattersType | NonerRrrtFloatFormatType | Nonesparsify bool | None index_namesrrrrrrdecimal bold_rowsescapercrdcCs||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t|_dSr)r_initialize_columnsr_initialize_colspacerrrr`_initialize_formattersr_initialize_justifyrRrt_initialize_sparsifyrshow_index_namesrrrrrrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerrr)rhrrrrrr`rrRrtrrrrrrrrrririrjrk4s.        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)rhstrcolsZ str_indexririrj get_strcolscs   zDataFrameFormatter.get_strcolscCs|jdup |jdko |jS)NTr)r is_truncatedrwririrjshould_show_dimensionsos z)DataFrameFormatter.should_show_dimensionscCst|jp|jSr)r_is_truncated_horizontallyrrwririrjruszDataFrameFormatter.is_truncatedcCt|jo t|j|jkSr)r_rrorrwririrjryz,DataFrameFormatter.is_truncated_horizontallycCrr)r_rrorrwririrjr}rz*DataFrameFormatter.is_truncated_verticallycCs dt|jdt|jjdS)Nz [z rows x z columns])rorrrwririrjdimensions_infos z"DataFrameFormatter.dimensions_infocC t|jjSr) _has_namesrrrwririrjhas_index_names z"DataFrameFormatter.has_index_namescCrr)rrrrwririrjhas_column_namesr!z#DataFrameFormatter.has_column_namescCt|j|j|jfSr)allr rrrwririrjshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namescCr#r)r$r"rrrwririrjshow_col_idx_namesr&z%DataFrameFormatter.show_col_idx_namesrcCst|jpt|jt|jSr)rrrorrwririrjmax_rows_displayedsz%DataFrameFormatter.max_rows_displayedcC|durtdS|S)Nzdisplay.multi_sparser)rhrririrjr sz'DataFrameFormatter._initialize_sparsifyr)cCsP|duriSt|jjt|kst|tr|Stdt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rorrrdict ValueError)rhrririrjr s  z)DataFrameFormatter._initialize_formatterscCr))Nzdisplay.colheader_justifyr*)rhrRririrjr sz&DataFrameFormatter._initialize_justifyrBcCs.|durttt|}|j||_|S|jjSr)rErr#rr)rhrcolsririrjr s  z&DataFrameFormatter._initialize_columnsr%csduri}|Stttfr#di}|fdd|jjD|SttrDD]}||jjvr?|dkr?td|q,}|St |jjt kr_tdt dt |jjdt t |jj}|S)Nrfcsi|]}|qSriri)r{columnrrirj z;DataFrameFormatter._initialize_colspace..z,Col_space is defined for an unknown column: zCol_space length(r+r) rrraupdaterrrkeysr-ror,zip)rhrrr/rir0rjr s0   z'DataFrameFormatter._initialize_colspacecCs,|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr _is_screen_narrow)rhrrririrjrs   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)r6r r_get_number_of_auxillary_rows_is_screen_short_adjust_max_rows)rhrrrririrjrs     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 )rorrr)rhrririrjr:s z#DataFrameFormatter._adjust_max_rowscCst|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)r_rrrwririrjr6sz"DataFrameFormatter._is_in_terminalcCst|jdko t|jj|kSNr)r_rrorr)rh max_widthririrjr7sz$DataFrameFormatter._is_screen_narrowcCst|jdko t|j|kSr;)r_rror)rh max_heightririrjr9sz#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)rror splitlinesr)rhZdot_rowZ prompt_rowZnum_rowsririrjr8 sz0DataFrameFormatter._get_number_of_auxillary_rowscCs$|jr||jr|dSdS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyr_truncate_verticallyrwririrjrs  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 NrrZaxis) rrrrHrrlisttuplerrrZ tr_col_num)rhZcol_numrOrPririrjr?!s     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)rrrrHrrrr)rhrheadtailririrjr@;s   z'DataFrameFormatter._truncate_verticallyc sg}tjs1js1tjD]\}}|}t|jtj |dj d}| |q|Stjrct t tj_tjtjkrZtdtjdtjdddjD}nj}jrv|D]}| dqntjD]L\}}||}ttj |dgfd d |DR}|}t|j|j d }ttfd d |D|} j j|| jd }| ||q{|S)Nr)stringsrRminimumrzWriting z cols but got z aliasescSsg|]}|gqSriri)r{labelririrjr}dr2zADataFrameFormatter._get_strcols_without_index..rfc3|] }j|VqdSrrrorrwrirjroz@DataFrameFormatter._get_strcols_without_index..)rGrc3rIrrJrrwrirjrvrKr)r5r enumerater format_col_make_fixed_widthrRrrrrrrrrarorr-_get_formatted_column_labelsr%max) rhrr|rr str_columnsrZcheaderZheader_colwidthrrirwrjrMsP       z-DataFrameFormatter._get_strcols_without_indexr|rsc CsL|j}||}t|jdd|fj||j|j|j|j ||j |j dS)N)rtr`rrr) r_get_formatterrurrrtr`rrrrr)rhr|r formatterririrjrM|s zDataFrameFormatter.format_col str | intCallable | NonecCsZt|jttfrt|rtt|}|j|SdSt|r&||jvr&|j|}|j|dSr) rrrBrCr3rrrr)rhr|ririrjrRs   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)rrcss|]}|jVqdSr)Z is_floating)r{levelririrjrszBDataFrameFormatter._get_formatted_column_labels..cs"|jvr|rsd|S|S)N )r)ry) need_leadsprestrict_formattingrhrirj space_formatszEDataFrameFormatter._get_formatted_column_labels..space_formatc3s$|] fddDVqdS)csg|]}|qSriri)r{rY)r\rrirjr}zMDataFrameFormatter._get_formatted_column_labels...Nri)r{)r\rrjrs"cSg|]}t|qSri)rBrririrjr}r~zCDataFrameFormatter._get_formatted_column_labels..cs0g|]\}}|s|rd|n|gqS)rX)rR)r{r|r)rZrhrirjr}s)Zpandas.core.indexes.multirVrrrCrrBr5rdtypesrrlevelsr,mapr6rrorL)rhrrVrZ fmt_columnsr`rQri)rZr[rhr\rjrOs.       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|qSri)rr)r{kvririrjr1sz;DataFrameFormatter._get_formatted_index.. __index__F)rrrrS)rrSc s.g|]}ttt|dddjdqS)rOrfr)rRrGr)rCrNrBrrrrrhrirjr}sz;DataFrameFormatter._get_formatted_index..rrncSr_rirarririrjr}r~rf)ritemsrrrRrrCrrr%rrsplitr'_get_column_name_listZnlevelsr)rhrrrfmtrZadjoinedZ col_headerrirfrjrs,     z'DataFrameFormatter._get_formatted_indexlist[Hashable]cCsNg}|jj}t|tr|dd|jD|S||jdur!dn|j|S)Ncss |] }|dur dn|VqdSrerirririrjrsz;DataFrameFormatter._get_column_name_list..rf)rrrrCextendrrr)rhrrririrjrjs z(DataFrameFormatter._get_column_name_list)NNTTrZNNNNTNNNFrFT)&rrLrrrrrrrr_r`rarrrRrrtrrrrr_rrrrrrrrrrarr_rr_rcrd)rcrrcr_r)rcr)rrrcr_)rrrcr))rRrrcra)rrrcrB)rrrcr%)rcr)rrrcrr)r|rrcrs)r|rTrcrU)rrLrcr)rrLrcrs)rcrl)(rrr__doc__rNrXrkrpropertyrrrrrr r"r%r'r(r r r r r rrr:r6r7r9r8rr?r@rrMrRrOrrjriririrjr.s   /                       / )(rc@seZdZdZdDddZ       dEdFddZ      dGdHd!d"Z   dIdJd%d&Z   '   ( )  *    +  , dKdLdBdCZdS)MDataFrameRendereraJClass 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. rkrrcrdcCs ||_dSr)rk)rhrkririrjrks zDataFrameRenderer.__init__NFr\"FilePath | WriteBuffer[str] | None column_formatr longtabler_r multicolumnmulticolumn_formatmultirowcaptionstr | tuple[str, str] | NonerHpositionc  Cs>ddlm} | |j||||||| | d } | } t| ||dS)zU Render a DataFrame to a LaTeX tabular/longtable environment output. r)LatexFormatter)rtrsrurvrwrxrHrzr\r)Zpandas.io.formats.latexr{rkrsave_to_buffer)rhr\rsrtrrurvrwrxrHrzr{Zlatex_formatterstringririrjto_latexs  zDataFrameRenderer.to_latexclassesstr | list | tuple | Nonenotebookborderint | 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)rrrrr|)Zpandas.io.formats.htmlrrrkrr}) rhr\rrrrrrrrZKlassZhtml_formatterr~ririrjto_html$s" 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|)Zpandas.io.formats.stringrrkrr})rhr\rrrZstring_formatterr~ririrjrWs zDataFrameRenderer.to_string,winfer"Tstrict path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Noneseprarr index_labelIndexLabel | Noner compressionr&rg quotecharlineterminator chunksize date_format doublequote escapecharerrorsstorage_optionsr+cCsddlm}|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) CSVFormatterNTFrrrrrrrgr.rrrrrrrrrSri)Zpandas.io.formats.csvsrrrksavergetvalueclose)rhrrrrrrrrgrrrrrrrrrZcreated_bufferZ csv_formattercontentririrjto_csvqs^      zDataFrameRenderer.to_csv)rkrrcrd) NNFNFNFNNN)r\rrrsrrtr_rrrur_rvrrwr_rxryrHrrzrrcr)NNNFNNF)r\rrrrrrrr_rrrrrr_rcr)NNN)r\rrrrrrrcr)NNrNNrrNrNNNTNrN)"rrrrrrarrrrrrarr&rgrrrarrrrrrrr_rrrrarr+rcr) rrrrorkrrrrriririrjrqsV  " 5 rqr~rar\rrrrcCs\t||d}|||dur|WdS WddS1s'wYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) get_bufferwriter)r~r\rfririrjr}s $r}IGenerator[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.rrrf)rnewlinez1buf is not a file name and it has no write method) rJrrrar-hasattrrIopen TypeError)r\rrririrjrs       "rrZrPrTrr rSrUrtrr`digitsrrstr | int | NonerRrrrrgfallback_formatterrsc Cst|jrt} n0t|jtrt} n't|jrt} nt|jr!t } nt |js+t |jr.t } n t |jr6t} nt} |dur>d}|durFtd}|durNtd}| |||||||||| | 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] N rdisplay.precision) rr`rtrSrrRrrrgr)r/rDatetime64Formatterrr9Datetime64TZFormatterr8Timedelta64Formatterr0ExtensionArrayFormatterr2r.FloatArrayFormatterr4IntArrayFormatterGenericArrayFormatterr get_result) rrSrtr`rrrRrrrgrZ fmt_klassZfmt_objririrjrusB )    ruc@sBeZdZ           d&d'dd Zd(d"d#Zd(d$d%ZdS))rNrZrrPrTrr rrrSrUr`rarrTrtrrRrrgr fixed_widthr_rrrrcrdc CsL||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) rrr`rrSrtrRrrgrrr) rhrrrSr`rrtrRrrgrrrririrjrk6s zGenericArrayFormatter.__init__rscCs|}t||jSr)_format_stringsrNrR)rhrririrjrRs 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]:\} } || s|sjdur|d|| q|| r||| q|durd} nd} || j|| dq|S)Nrrcst|dddS)Nz .dr)_trim_zeros_single_floatr^) precisionrirj[sz7GenericArrayFormatter._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)Nrdr)r`r7r:rrarnpZisnatrr-rr@r?reprr^)rSrhrirj_formatms&    z6GenericArrayFormatter._format_strings.._formatTZ extract_numpyz.base_formattercst|rt|SjSr)r;rar`rrwrirjrrrcs|djdS)Nrr)replacerr)rrhrirjdecimal_formattersz?FloatArrayFormatter._value_formatter..decimal_formattercs*t|rt|kr|SdSjS)Ng)r;absr`r)rrhrrirjrSs  z7FloatArrayFormatter._value_formatter..formatter)rtr)rhrtrrSri)rrrtrhrrj_value_formatters  z$FloatArrayFormatter._value_formatter np.ndarrayc stdddjd urjjjSjrtd nd fd d }jd urDjr@jd ur5d}nd}t|jj d}n j}nfdd}||}jsS|St |dkrjt dd|D}|j dk}nd}t j dd"t j}|dk}|dj k|dk@} Wd n1swY| s|r|rjd urd}nd}t|jj d}||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array rr"rSr r`racs<t|}tfddt||D|j}|S)Ncs g|] \}}|s |nqSriri)r{valmrSr`rirjr}szWFloatArrayFormatter.get_result_as_array..format_with_na_rep..)r:rarrayr5ravelZreshaper)rrSr`mask formattedrirrjformat_with_na_reps zCFloatArrayFormatter.get_result_as_array..format_with_na_repNzdisplay.chop_thresholdcsx|}jdkrdj}nj}j}t|}|||}jr:|r-t|j}nt|j}t j |ddS|S)NrOrXobjectr) rrRr`rr.r_trim_zeros_complexr_trim_zeros_floatrasarray)rtrSr`rZ is_complexrrrhrrirjformat_values_withs     zCFloatArrayFormatter.get_result_as_array..format_values_withTz{value: .{digits:d}f}z{value:.{digits:d}f})rcs j|Sr)rtrrwrirjr(s z9FloatArrayFormatter.get_result_as_array..rcss|]}t|VqdSrrrririrjr4sz:FloatArrayFormatter.get_result_as_array..Fignoreinvalidg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr"rSr r`ra)rSrr`rrrtrrrrrorPrerrstaterr) rhrZfmt_strrtZformatted_valuesmaxlenZtoo_longZabs_valsZhas_large_valuesZhas_small_valuesrirrjget_result_as_arraysH          z'FloatArrayFormatter.get_result_as_arrayrscCs t|Sr)rBrrwririrjrMs z#FloatArrayFormatter._format_stringsrNN)rtrrrrcr )rcrr)rrrrkrrrrririrrjrs 8crc@eZdZdddZdS)rrcrscs>|jdur dd}ndd}|jp|fdd|jD}|S)NFcS|dj|dS)Nrr^rr^ririrjrTz3IntArrayFormatter._format_strings..cSr)Nz dr^rr^ririrjrVrcg|]}|qSririrrSrirjr}Xr~z5IntArrayFormatter._format_strings..)rrSr)rhZ formatter_strrrirrjrRs   z!IntArrayFormatter._format_stringsNrrrrrriririrjrQrcs.eZdZ  ddfd d Zdd dZZS)rrNr3np.ndarray | Series | DatetimeIndex | DatetimeArraynat_reprarrdrcc $tj|fi|||_||_dSr)rrkrr)rhrrrrrrirjrk] zDatetime64Formatter.__init__rscsZj}t|ts t|}jdurtjrfdd|DS|jjjjd}| S)z&we by definition have DO NOT have a TZNcsg|]}|qSrirrrwrirjr}pr]z7Datetime64Formatter._format_strings..)r`r) rrrFrSr_dataZ_format_native_typesrrtolist)rhrrrirwrjrhs z#Datetime64Formatter._format_stringsrN)rrrrarrdrcrdrrrrrkrrririrrjr\  rc@r)rrcrsc Cs|t|jdd}|j}d}|dur|jdd}t|tr |}nt|}t |||j |j |j |j |j|j|j|j|d }|S)NTr)Zboxed) rtr`rrrRrrrgr)rArrS _formatterrr<rvrrrurtr`rrrRrrrg)rhrrSrrrririrjrys,     z'ExtensionArrayFormatter._format_stringsNrrriririrjrxrr percentilesnp.ndarray | Sequence[float]c Cslt|}tjddt|rt|dkrt|dks"tdWdn1s,wYd|}|t}t ||}t|rS|t }dd |DSt |}|ddkrb|dnd}|d dkrpd|d nd}t t ttj|||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%'] rrrrz/percentiles should all be in the interval [0,1]NdcSg|]}|dqS%rirzririrjr}r~z&format_percentiles..)to_beginto_endrcSrrrirzririrjr}r~)rrrr6r$r-roundastyperiscloserauniquefloorlog10rZediff1drPZ empty_liker)rZpercentiles_round_typeZint_idxoutZ unique_pctsr r precririrjformat_percentiless< "       r2np.ndarray | DatetimeArray | Index | DatetimeIndexr_cCs~t|ts |}t|ttfst|}|jdurdS|j}|tk}t|j }t |}t |||dk dk}|r=dSdS)NFrT)rrBrr=rFtzZasi8rrrr r logical_andr)r values_intconsider_valuesZresoZppd even_daysririrj is_dates_onlys   rrrNaTType | TimestamprcCs|tur|St|Sr)rra)rrririrj_format_datetime64srrcCs"t|tr|S|r||S|jSr)rr!strftimeZ _date_repr)rrrririrj_format_datetime64_dateonlys  ris_dates_only_r cs|r fddSfddS)z]Return a formatter callable taking a datetime64 as input and providing a string as outputcst|dS)N)rr)rr^rrrirjrsz'get_format_datetime64..cs t|dS)Nr)rr^r!rirjrs ri)rrrrir rjget_format_datetime64s r"*np.ndarray | DatetimeArray | DatetimeIndexcCs6t|tjr|jdkr|}t|}|r|pdS|S)z6given values and a date_format, return a string formatrz%Y-%m-%d)rrrndimrr)rridoririrj!get_format_datetime64_from_valuess r&c@r)rrcrscs>|jt}t|}|jpt||jdfdd|D}|S)zwe by definition have a TZ)rcrririrrrirjr}4r~z9Datetime64TZFormatter._format_strings..)rr rrrSr"r)rhrr%rrirrjr-s z%Datetime64TZFormatter._format_stringsNrrriririrjr,rrcs.eZdZ  ddfd d ZdddZZS)rrFrnp.ndarray | TimedeltaIndexrraboxr_rcrdc rr)rrkrr()rhrrr(rrrirjrk:rzTimedelta64Formatter.__init__rscs.|jp t|j|j|jdfdd|jDS)N)rr(crririrrrirjr}Ir~z8Timedelta64Formatter._format_strings..)rSget_format_timedelta64rrr(rwrirrjrEs z$Timedelta64Formatter._format_stringsrF)rr'rrar(r_rcrdrrririrrjr9rrF,np.ndarray | TimedeltaIndex | TimedeltaArray str | floatr(c 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')r7r:rrZ _repr_base)rrr(rrrirjrks   z*get_format_timedelta64.._formatter)viewrZint64rrr) rrr(rrZ one_day_nanosZ not_midnightZbothrrrir/rjr)Ls     r)rFrGrTextAdjustment | Nonecst|dks |dkr |S|durtn|tfdd|D|dur*t|tddur8kr8dfd d fd d |D}j||d }|S)Nrr$c3s|]}|VqdSrrr) adjustmentrirjrz$_make_fixed_width..rrrarccs6durdk|k@r|ddd}|S)Nrrrr^)r2conf_maxrrirjjustsz_make_fixed_width..justcrririr)r5rirjr}r~z%_make_fixed_width..r)rrarcra)rorrPrrR)rFrRrGrrri)r2r4r5rrjrN{s rN str_complexesrcsDfdd|D}dd|D}t|fddt||D}|S)z Separates the real and imaginary parts from the complex number, and executes the _trim_zeros_float method on each of those. c s$g|]}dttd|qS)rfz([j+-]))rrrerir)rrirjr}sz'_trim_zeros_complex..cSr_rir)r{sririrjr}r~csg|]B\}}|d|ddd |dd||ddd |dd ||dd d|dd|dqS)Nrr0rri)r{r8rc) max_lengthrirjr}s")rPr5)r6rtrimmedlengthspaddedri)rr:rjrs   r str_floatcCs |d}|dr|d7}|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. r9r)rstripendswith)r>ririrjrs  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]*$rcr_cst|duSr)r7matchr^) number_regexrirjis_number_with_decimalrz1_trim_zeros_float..is_number_with_decimalrrBcs0fdd|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|qSririrrErirjr}sz:_trim_zeros_float..should_trim..rcss|]}|dVqdS)r9Nr@rririrjrr3z9_trim_zeros_float..should_trim..)ror$)rnumbersrFrirj should_trimsz&_trim_zeros_float..should_trimcs$g|]}|r|ddn|qS)NrrirrFrirjr}s$z%_trim_zeros_float..cs*g|]}|r|r|dn|qS)r9rGr)rrErirjr}sNrn)rrBrcr_)r7compile)rArr;rIrri)rrErDrjrs  rrrBcCs t|tr tj|jS|jduSr)rrCcomZ any_not_nonerr)rririrjrs   rc@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 irYiziairipiniurrrfrrcrM GrTPEZYNFaccuracyruse_eng_prefixr_rcrdcCs||_||_dSrr_r`)rhr_r`ririrjrk s zEngFormatter.__init__numfloatrac 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 rZinfrrrrzE-02dzE+rNz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)rrais_nan is_infinitermathrrrrP ENG_PREFIXESr4r`r_r) rhrbZdnumsignZpow10Z int_pow10rgrf format_strrririrj__call__s4       zEngFormatter.__call__r)r_rr`r_rcrd)rbrcrcra)rrrrorkrkrnriririrjrLsP      rLrr_rr`rdcCstdt||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)rrLraririrjset_eng_float_formatNs7rorfrasentinelbool | 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)rorLr) rarpcontrolrrW last_indexr<r|keyririrjget_level_lengthss   rvWriteBuffer[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)rrarririrjrr3z#buffer_put_lines..cSr_rirgrririrjr}r~z$buffer_put_lines..rnN)rrr)r\rxririrjbuffer_put_liness ry)rcr)rcrr)r~rar\rrrrrcrr)r\rrrrrcr) NrZNNrPrTNN)rr rSrUrtrr`rarrrrrRrarrarrrgrrrUrcrs)rrrcrs)rrrcr_)r)rrrrarcrar)rrrrarrrcra)rr_rrarrrcr )rr#rrrcrr*)rr+rr,r(r_rcr )rPNN) rFrsrRrarGrrr1rcrs)r)r6rrrarcrs)r>rarcra)rArBrrarcrs)rrBrcr_)rF)r_rr`r_rcrd)rf)rar rprqrcrr)r\rwrxrsrcrd)ro __future__r contextlibrcsvrrrr functoolsriorrjr7shutilr typingr r r r rrrrrrrr unicodedatarnumpyrZpandas._config.configrrZ pandas._libsrZpandas._libs.missingrZpandas._libs.tslibsrrrrrr Zpandas._libs.tslibs.nattyper!Zpandas._typingr"r#r$r%r&r'r(r)r*r+r,Zpandas.core.dtypes.commonr-r.r/r0r1r2r3r4r5r6r7r8Zpandas.core.dtypes.dtypesr9Zpandas.core.dtypes.missingr:r;Zpandas.core.arraysr<r=r>Zpandas.core.arrays.string_r?Zpandas.core.baser@Zpandas.core.commoncorecommonrKZpandas.core.constructionrAZpandas.core.indexes.apirBrCrDrEZpandas.core.indexes.datetimesrFZpandas.core.indexes.timedeltasrGZpandas.core.reshape.concatrHZpandas.io.commonrIrJrrKZpandasrLrMrN__annotations__Z_VALID_JUSTIFY_PARAMETERSrXrYrrrrrrrrqr}rrurrrrrrrrrr"r&rrr)rNrrrrrLrorvryriririrjs      8     48         ;  @! '  !&E@ ( Rp-   F      1 "  $ a; +