o Ti)@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-parentinitialZunsetz 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)rUr rVrZrXr\r quoting)selfrUrVrXrZr\rcX/var/www/html/evchargy.com/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)Nr`, Length:  )rXlenrU_repr_categories_infor[)rbr\ level_inforcrcrd _get_footers z CategoricalFormatter._get_footer list[str]cCst|jdd|j|jdS)N) float_formatrZra) format_arrayrU_internal_get_valuesrZrarbrcrcrd_get_formatted_valuessz*CategoricalFormatter._get_formatted_valuescCs||j}t|dkr|jr|SdS|}dd|D}d|}d|dg}|jr7|}|r7||td|S) Nrr`cSsg|]}|qSrc)strip.0ircrcrd z2CategoricalFormatter.to_string..rf[]rh)rUrir\rlrrjoinappendr[)rbrU fmt_valuesvaluesresultr\rcrcrd to_strings   zCategoricalFormatter.to_string)NTrTT) rUr,rVrWrXrYrZr[r\rYr]r^r]r[r]rm)__name__ __module__ __qualname__rerlrrrrcrcrcrdrSs   rSc@s^eZdZ          d'd(ddZd)ddZd*ddZd+d d!Zd,d#d$Zd*d%d&ZdS)-SeriesFormatterNTrTFseriesrHrVrWrX bool | strheaderrYindexrZr[namern str | Nonedtypemax_rows int | Nonemin_rowsr]r^c Cst||_|dur |nt|_||_||_||_||_||_| |_| |_ |dur*t d}||_ | |_ t |_|dS)Ndisplay.float_format)rr rVrrZrrXrrrrrnrget_adjustmentadj _chk_truncate) rbrrVrXrrrZrrnrrrrcrcrdre s zSeriesFormatter.__init__cCs||j}|j}|ot|j|k}|j}|rItt|}|r"t||}|dkr0|}|jd|}n|d}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rrrirrintminilocr8 tr_row_num tr_seriesis_truncated_vertically)rbrrrrrow_numrcrcrdr)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)Nr`freqzFreq: Frf  rh) escape_charszName: Ttruncatergrzdtype: rh)rrgetattrr isinstancer6r4r7Zfreqstrr; pprint_thingrXrrirrr'_valuesrjr[)rbrr\Z series_nameZ dtype_namerkrcrcrdrlDs:  zSeriesFormatter._get_footertuple[list[str], bool]cCsX|jj}t|trtdd|jD}|jdd}||fS|jdu}|jdd}||fS)Ncss|]}|VqdSNrcrurrcrcrd qsz7SeriesFormatter._get_formatted_index..T)names)r)rrrr3anyrformatr)rbr have_header fmt_indexrcrcrd_get_formatted_indexms   z$SeriesFormatter._get_formatted_indexrmcCst|jjd|j|j|jdS)N)rnrZ leading_space)rorrrnrZrrqrcrcrdrrxsz%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..rLmoder`rh)rrlrityperrrrrrrrrrrMinsertradjoinrr[r{) rbrr\rrr}Z n_header_rowsrwidthZdot_strrrcrcrdrs2   "  zSeriesFormatter.to_string) NTTTrTFNTNN)rrHrVrWrXrrrYrrYrZr[rrYrnrrrYrrrrr]r^r]r^r)r]rr) rrrrerrlrrrrrcrcrcrdrs"  )  rc@s6eZdZdddZddd ZddddZdddZdS)TextAdjustmentr]r^cCstd|_dS)Nzdisplay.encoding)rencodingrqrcrcrdreszTextAdjustment.__init__textr[rcCst|SrrirbrrcrcrdriszTextAdjustment.lenrKtextsrmax_lenrrmcCstj|||dS)Nr)r;rMrbrrrrcrcrdrMzTextAdjustment.justifyspacecOs"tj|g|R|j|jd|S)N)ZstrlenZjustfunc)r;rrirM)rbrlistskwargsrcrcrdrszTextAdjustment.adjoinNrrr[r]rrK)rrrrrr[r]rm)rrr]r[)rrrrerirMrrcrcrcrdrs    rcs6eZdZdfdd Zddd Z ddddZZS)EastAsianTextAdjustmentr]r^cs6ttdr d|_nd|_dddddd|_dS)Nz!display.unicode.ambiguous_as_widerr)ZNaNWFH)superrerambiguous_width_EAW_MAPrq __class__rcrdres z EastAsianTextAdjustment.__init__rr[rcs(t|ts t|Stfdd|DS)zN Calculate display width considering unicode East Asian Width c3s$|] }jt|jVqdSr)rgetrr)rucrqrcrdrs z.EastAsianTextAdjustment.len..)rr[risumrrcrqrdris  zEastAsianTextAdjustment.lenrKr Iterable[str]rrrmcsTfdd|dkrfdd|DS|dkr!fdd|DSfdd|DS) Ncs|t|Srr)t)rrbrcrd_get_padz1EastAsianTextAdjustment.justify.._get_padrJcg|] }||qSrc)ljustruxrrcrdrwz3EastAsianTextAdjustment.justify..rLcrrc)rLrrrcrdrwrcrrc)rjustrrrcrdrwrrcrrc)rrrbrdrMs zEastAsianTextAdjustment.justifyrrr)rrrrrr[r]rm)rrrrerirM __classcell__rcrcrrdrs   rr]cCstd}|r tStS)Nz display.unicode.east_asian_width)rrr)Zuse_east_asian_widthrcrcrdrsrdict[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_rcrcrdget_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)rrrrrX)rr)rheightrrrcrcrdget_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.r`NTrTF.framerGcolumns Axes | None col_spaceColspaceArgType | Nonerbool | list[str]rrYrZr[ formattersFormattersType | NonerMrrnFloatFormatType | Nonesparsify bool | None index_namesrrrrrrdecimal bold_rowsescaper]r^cCs||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t|_dSr)r_initialize_columnsr_initialize_colspacerrrrZ_initialize_formattersr_initialize_justifyrMrn_initialize_sparsifyrshow_index_namesrrrrrrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerrr)rbrrrrrrZrrMrnrrrrrrrrrrcrcrdre4s.        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_indexrrr r)rbstrcolsZ str_indexrcrcrd get_strcolscs   zDataFrameFormatter.get_strcolscCs|jdup |jdko |jS)NTr)r is_truncatedrqrcrcrdshould_show_dimensionsos z)DataFrameFormatter.should_show_dimensionscCst|jp|jSr)rYis_truncated_horizontallyrrqrcrcrdruszDataFrameFormatter.is_truncatedcCt|jo t|j|jkSr)rYr rirrqrcrcrdryz,DataFrameFormatter.is_truncated_horizontallycCrr)rYr rirrqrcrcrdr}rz*DataFrameFormatter.is_truncated_verticallycCs dt|jdt|jjdS)Nz [z rows x z columns])rirrrqrcrcrddimensions_infos z"DataFrameFormatter.dimensions_infocC t|jjSr) _has_namesrrrqrcrcrdhas_index_names z"DataFrameFormatter.has_index_namescCrr)rrrrqrcrcrdhas_column_namesrz#DataFrameFormatter.has_column_namescCt|j|j|jfSr)allrrrrqrcrcrdshow_row_idx_namesz%DataFrameFormatter.show_row_idx_namescCrr)rrrrrqrcrcrdshow_col_idx_namesr z%DataFrameFormatter.show_col_idx_namesrcCst|jpt|jt|jSr)rrrirrqrcrcrdmax_rows_displayedsz%DataFrameFormatter.max_rows_displayedcC|durtdS|S)Nzdisplay.multi_sparser)rbrrcrcrdrsz'DataFrameFormatter._initialize_sparsifyrCcCsP|duriSt|jjt|kst|tr|Stdt|dt|jjd)NzFormatters length(+) should match DataFrame number of columns(r)rirrrdict ValueError)rbrrcrcrdrs  z)DataFrameFormatter._initialize_formatterscCr#)Nzdisplay.colheader_justifyr$)rbrMrcrcrdrsz&DataFrameFormatter._initialize_justifyr2cCs(|durt|}|j||_|S|jjSr)r5rr)rbrcolsrcrcrdrs  z&DataFrameFormatter._initialize_columnsr?csduri}|Stttfr#di}|fdd|jjD|SttrDD]}||jjvr?|dkr?td|q,}|St |jjt kr_tdt dt |jjdt t |jj}|S)Nr`csi|]}|qSrcrc)rucolumnrrcrd z;DataFrameFormatter._initialize_colspace..z,Col_space is defined for an unknown column: zCol_space length(r%r) rrr[updaterrrkeysr'rir&zip)rbrrr)rcr*rdrs0   z'DataFrameFormatter._initialize_colspacecCs,|s|jSt\}}||r|S|jS)z%Number of columns fitting the screen.)_is_in_terminalrr_is_screen_narrow)rbrrrcrcrdr s   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)r0rr_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rbrrrrcrcrdr s     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 )rirrr)rbrrcrcrdr4s z#DataFrameFormatter._adjust_max_rowscCst|jdkp |jdkS)z/Check if the output is to be shown in terminal.r)rYrrrqrcrcrdr0sz"DataFrameFormatter._is_in_terminalcCst|jdko t|jj|kSNr)rYrrirr)rb max_widthrcrcrdr1sz$DataFrameFormatter._is_screen_narrowcCst|jdko t|j|kSr5)rYrrir)rb max_heightrcrcrdr3sz#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)rrir splitlinesr)rbZdot_rowZ prompt_rowZnum_rowsrcrcrdr2sz0DataFrameFormatter._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_verticallyrqrcrcrdrs  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) r r rr8rrlisttuplerrrZ tr_col_num)rbZcol_numrJrKrcrcrdr9s     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)r r rr8rrrr)rbrheadtailrcrcrdr:9s   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|]}|gqSrcrc)rulabelrcrcrdrwbr,zADataFrameFormatter._get_strcols_without_index..r`c3|] }j|VqdSrrrirrqrcrdrmz@DataFrameFormatter._get_strcols_without_index..)rArc3rCrrDrrqrcrdrtrEr)r$r enumerater  format_col_make_fixed_widthrMrrrrr|rr<r[rirr'_get_formatted_column_labelsrmax) rbrrvrr} str_columnsrZcheaderZheader_colwidthrrcrqrdrKsP        z-DataFrameFormatter._get_strcols_without_indexrvrmc CsL|j}||}t|jdd|fj||j|j|j|j ||j |j dS)N)rnrZrrr) r _get_formatterrorrrnrZrrrrr)rbrvr formatterrcrcrdrGzs zDataFrameFormatter.format_col str | intCallable | NonecCsZt|jttfrt|rtt|}|j|SdSt|r&||jvr&|j|}|j|dSr) rrr<r=r#rrrr)rbrvrcrcrdrLs   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)rulevelrcrcrdrszBDataFrameFormatter._get_formatted_column_labels..cs"|jvr|rsd|S|S)N )r)ry) need_leadsprestrict_formattingrbrcrd space_formats zEDataFrameFormatter._get_formatted_column_labels..space_formatc3s$|] fddDVqdS)csg|]}|qSrcrc)rurS)rVrrcrdrwzMDataFrameFormatter._get_formatted_column_labels...Nrc)ru)rVrrdrs"cSg|]}t|qSrc)r<rrcrcrdrwrxzCDataFrameFormatter._get_formatted_column_labels..cs0g|]\}}|s|rd|n|gqS)rR)rL)rurvr)rTrbrcrdrws)Zpandas.core.indexes.multirPrrr3rr<r/rdtypesrrlevelsr&mapr%rrirF)rbrrPrZ fmt_columnsrZrKrc)rTrUrbrVrdrIs.       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|qSrc)rr)rukvrcrcrdr+sz;DataFrameFormatter._get_formatted_index.. __index__F)rrrrM)rrMc s.g|]}ttt|dddjdqS)rJr`r)rMrAr)r=rHr<rrrrrbrcrdrwsz;DataFrameFormatter._get_formatted_index..rrhcSrYrcr[rrcrcrdrwrxr`)ritemsrrrLrr3rrrrrsplitr!_get_column_name_listZnlevelsr)rbrrrfmtrZadjoinedZ col_headerrcr`rdrs,     z'DataFrameFormatter._get_formatted_indexlist[Hashable]cCsNg}|jj}t|tr|dd|jD|S||jdur!dn|j|S)Ncss |] }|dur dn|VqdSr_rcrrcrcrdrsz;DataFrameFormatter._get_column_name_list..r`)rrrr3extendrr|r)rbrrrcrcrdrds z(DataFrameFormatter._get_column_name_list)NNTTrTNNNNTNNNFrFT)&rrGrrrrrrrrYrZr[rrrMrrnrrrrrYrrrrrrrrrr[rrYrrYr]r^)r]rr]rYr)r]r)rrr]rY)rrr]rC)rMrr]r[)rrr]r2)rrr]r?)r]r)rrr]rr)rvrr]rm)rvrNr]rO)rrGr]r)rrGr]rm)r]rf)(rrr__doc__rIrRrerpropertyrrrrrrrrr!r"rrrrrr r r4r0r1r3r2rr9r:rrGrLrIrrdrcrcrcrdr.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. rerr]r^cCs ||_dSr)re)rbrercrcrdres zDataFrameRenderer.__init__NFrV"FilePath | WriteBuffer[str] | Nonerrclassesstr | list | tuple | NonenotebookrYborderint | 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)rmrprrrsrVr)Zpandas.io.formats.htmlrtrurersave_to_buffer) rbrVrrmrorprrrsrtruZKlassZhtml_formatterstringrcrcrdto_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)rrv)Zpandas.io.formats.stringrzrerrw)rbrVrrrzZstring_formatterrxrcrcrdr5s zDataFrameRenderer.to_string,winfer"Tstrict path_or_buf7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | Nonesepr[rSequence[Hashable] | None index_labelIndexLabel | Noner compressionr@ra 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) CSVFormatterNTFrrrrrrrar(rrrrrrrrrMrc)Zpandas.io.formats.csvsrr resavergetvalueclose)rbrrrrrrrrarrrrrrrrrZcreated_bufferZ csv_formattercontentrcrcrdto_csvOs^      zDataFrameRenderer.to_csv)rerr]r^)NNNFNNF)rVrlrrrmrnrorYrprqrrrrsrYr]r)NNN)rVrlrrrrr]r)NNr{NNr|r}Nr~NNNTNrN)"rrrrrr[rrrrrr[rr@rarrr[rrrrrrrrYrrrr[rrr]r)rrrrireryrrrcrcrcrdrks@  5 rkrxr[rVrlrrcCs\t||d}|||dur|WdS WddS1s'wYdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) get_bufferwriter)rxrVrfrcrcrdrws $rwIGenerator[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.rr|r`)rnewlinez1buf is not a file name and it has no write method) r:r rr[r'hasattrr9open TypeError)rVrrrcrcrdrs       "rrTrKrTr~rrMrOrnrrZdigitsrrstr | int | NonerMrrrrafallback_formatterrmc 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) rrZrnrMrrMrrrar)rZ is_np_dtyperDatetime64Formatterrr(Datetime64TZFormatterTimedelta64Formatterr)ExtensionArrayFormatterFloatArrayFormatterIntArrayFormatterGenericArrayFormatterr get_result) r~rMrnrZrrrMrrrarZ fmt_klassZfmt_objrcrcrdrosB)  roc@sBeZdZ           d&d'dd Zd(d"d#Zd(d$d%ZdS))rNrTrrKrTr~rrrrMrOrZr[rrNrnrrMrrar fixed_widthrYrrrr]r^c CsL||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ dSr) r~rrZrrMrnrMrrarrr) rbr~rrMrZrrnrMrrarrrrcrcrdres zGenericArrayFormatter.__init__rmcCs|}t||jSr)_format_stringsrHrM)rbr}rcrcrdr0s 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_floatrX) precisionrcrd9sz7GenericArrayFormatter._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)rZr&r*rr[rnpZisnatrr'rr0r/reprrX)rMrbrcrd_formatKs&    z6GenericArrayFormatter._format_strings.._formatTZ extract_numpyz.base_formattercst|rt|SjSr)r+r[rZrrqrcrdrrrcs|djdS)Nrr)replacerr)rrbrcrddecimal_formattersz?FloatArrayFormatter._value_formatter..decimal_formattercs*t|rt|kr|SdSjS)Ng)r+absrZr)rrbrrcrdrMs  z7FloatArrayFormatter._value_formatter..formatter)rnr)rbrnrrMrc)rrrnrbrrd_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 r~r<rMrrZr[cs<t|}tfddt||D|j}|S)Ncs g|] \}}|s |nqSrcrc)ruvalrrMrZrcrdrwszWFloatArrayFormatter.get_result_as_array..format_with_na_rep..)r*rarrayr/ravelreshaper)r~rMrZmask formattedrcrrdformat_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|rs startswithrrr)r~rMrZZ real_valuesZ imag_valuesZ real_maskZ imag_maskZ formatted_lstrZreal_valZimag_valZre_isnaZim_isnaZimag_formattedrcrcrdformat_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)NrJrRobjectr) rrMrZr~r!r_trim_zeros_complexr_trim_zeros_floatrasarray)rnrMrZr~Z is_complexrrrrbrrcrdformat_values_withs   zCFloatArrayFormatter.get_result_as_array..format_values_withTz{value: .{digits:d}f}z{value:.{digits:d}f})rcs j|Sr)rnrrqrcrdr&s z9FloatArrayFormatter.get_result_as_array..rcs|]}t|VqdSrrrrcrcrdr2z:FloatArrayFormatter.get_result_as_array..Fg.A z{value: .{digits:d}e}z{value:.{digits:d}e})r~r<rMrrZr[)rMr~rZrrrnrr rrrirJrrr) rbrZfmt_strrnZformatted_valuesmaxlenZtoo_longZabs_valsZhas_large_valuesZhas_small_valuesrcrrdget_result_as_arraysB           z'FloatArrayFormatter.get_result_as_arrayrmcCs t|Sr)r<rrqrcrcrdrHs z#FloatArrayFormatter._format_stringsrNN)rnrrrr]r)r]rr)rrrrerrrrrcrcrrdrs 8rc@eZdZdddZdS)rr]rmcs>|jdur dd}ndd}|jp|fdd|jD}|S)NFcS|dj|dS)NrrXrrXrcrcrdrOz3IntArrayFormatter._format_strings..cSr)Nz drXrrXrcrcrdrQrcg|]}|qSrcrcrrMrcrdrwSrxz5IntArrayFormatter._format_strings..)rrMr~)rbZ formatter_strr}rcrrdrMs   z!IntArrayFormatter._format_stringsNrrrrrrcrcrcrdrLrcs.eZdZ  ddfd d Zdd dZZS)rrNr~3np.ndarray | Series | DatetimeIndex | DatetimeArraynat_repr[rr^r]c $tj|fi|||_||_dSr)rrerr)rbr~rrrrrcrdreX zDatetime64Formatter.__init__rmcsZj}t|ts t|}jdurtjrfdd|DS|jjjjd}| S)z&we by definition have DO NOT have a TZNcsg|]}|qSrcrrrqrcrdrwkrWz7Datetime64Formatter._format_strings..)rZr) r~rr6rMr_dataZ_format_native_typesrrtolist)rbr~r}rcrqrdrcs z#Datetime64Formatter._format_stringsrN)r~rrr[rr^r]r^rrrrrerrrcrcrrdrW  rc@r)rr]rmc Cs|t|jdd}|j}d}|dur|jdd}t|tr |}nt|}t |||j |j |j |j |j|j|j|j|d }|S)NTr)Zboxed) rnrZrrrMrrrar)r1r~rM _formatterrr,rprrrornrZrrrMrrra)rbr~rMrrr}rcrcrdrts,     z'ExtensionArrayFormatter._format_stringsNrrrcrcrcrdrsrr 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%rcrtrcrcrdrwrxz&format_percentiles..N)to_beginto_endrcSrrrcrtrcrcrdrwrx)rrr%rr'roundastyperiscloser[uniquefloorlog10rZediff1drJZ empty_liker)rZpercentiles_round_typeZint_idxoutZ unique_pctsrrprecrcrcrdformat_percentiless6 "       r2np.ndarray | DatetimeArray | Index | DatetimeIndexrYcCs~t|ts |}t|ttfst|}|jdurdS|j}|tk}t|j }t |}t |||dk dk}|r=dSdS)NFrT)rr2rr-r6tzZasi8rrrrr logical_andr)r~ values_intconsider_valuesZresoZppd even_daysrcrcrd is_dates_onlys   rrrNaTType | TimestamprcCs|tur|St|Sr)rr[)rrrcrcrd_format_datetime64srrcCs"t|tr|S|r||S|jSr)rr strftimeZ _date_repr)rrrrcrcrd_format_datetime64_dateonlys  ris_dates_only_rcs|r fddSfddS)z]Return a formatter callable taking a datetime64 as input and providing a string as outputcst|dS)N)rr)rrXrrrcrdrsz'get_format_datetime64..cs t|dS)Nr)rrXrrcrdrs rc)rrrrcrrdget_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)r~ridorcrcrd!get_format_datetime64_from_valuess r!c@r)rr]rmcs@t|j}|jt}|jpt||jdfdd|D}|S)zwe by definition have a TZ)rcrrcrcrrrcrdrw.rxz9Datetime64TZFormatter._format_strings..)rr~rrrMrr)rbr r~r}rcrrdr's  z%Datetime64TZFormatter._format_stringsNrrrcrcrcrdr&rrcs.eZdZ  ddfd d ZdddZZS)rrFr~np.ndarray | TimedeltaIndexrr[boxrYr]r^c rr)rrerr#)rbr~rr#rrrcrdre4rzTimedelta64Formatter.__init__rmcs.|jp t|j|j|jdfdd|jDS)N)rr#crrcrcrrrcrdrwCrxz8Timedelta64Formatter._format_strings..)rMget_format_timedelta64r~rr#rqrcrrdr?s z$Timedelta64Formatter._format_stringsrF)r~r"rr[r#rYr]r^rrrcrcrrdr3rrF,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')r&r*rrZ _repr_base)rrr#rrrcrdres   z*get_format_timedelta64.._formatter)viewrZint64rrr) r~rr#rrZ one_day_nanosZ not_midnightZbothrrrcr*rdr$Fs     r$r@rArTextAdjustment | Nonecst|dks |dkr |S|durtn|tfdd|D|dur*t|tddur8kr8dfd d fd d |D}j||d }|S)Nrrc3s|]}|VqdSrrr) adjustmentrcrdrz$_make_fixed_width..rrr[r]cs6durdk|k@r|ddd}|S)NrrrrX)r-conf_maxrrcrdjustsz_make_fixed_width..justcrrcrcr)r0rcrdrwrxz%_make_fixed_width..r)rr[r]r[)rirrJrrM)r@rMrArrrc)r-r/r0rrdrHus rH 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+-])r`Nrcsrrr)rupartrcrcrdrrz&_trim_zeros_complex..rcs6g|]\}}||d|ddddqS)rrN>rrc)ruZreal_ptZimag_ptZ padded_lengthrcrdrwsz'_trim_zeros_complex..)rercr|r{rirrJr/) r1rZ real_partZ imag_partrtrimmednZ padded_partspaddedrcr6rdrs    r str_floatcCs |d}|dr|d7}|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith)r;rcrcrdrs  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]rYcst|duSr)r7matchrX) number_regexrcrdis_number_with_decimalrz1_trim_zeros_float..is_number_with_decimalr~r@cs0fdd|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|qSrcrcrrCrcrdrwsz:_trim_zeros_float..should_trim..rcss|]}|dVqdS)r<Nr>rrcrcrdrr.z9_trim_zeros_float..should_trim..)rir)r~numbersrDrcrd should_trimsz&_trim_zeros_float..should_trimcs$g|]}|r|ddn|qS)NrrcrrDrcrdrws$z%_trim_zeros_float..cs*g|]}|r|r|dn|qS)r<rEr)rrCrcrdrwsNrh)r~r@r]rY)r7compile)r?rr8rGrrc)rrCrBrdrs  rrr2cCs t|tr tj|jS|jduSr)rr3comZ any_not_nonerr)rrcrcrdrs   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 irSiziairipir9iurrr`rr]rr GrTPEZYNFaccuracyruse_eng_prefixrYr]r^cCs||_||_dSrr[r\)rbr[r\rcrcrdre 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 rTinfrrrrzE-02dzE+rNz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r r[is_nan is_infinitermathr r rrJ ENG_PREFIXESr.r\r[r) rbr^ZdnumsignZpow10Z int_pow10rcrb format_strrrcrcrd__call__s4       zEngFormatter.__call__r)r[rr\rYr]r^)r^r_r]r[)rrrrirgrerjrcrcrcrdrJsP      rJrr[rr\r^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)rrJr]rcrcrdset_eng_float_formatOs7rkr`r[sentinelbool | 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)rirFr|) r[rlcontrolrrQZ last_indexlengthsrvkeyrcrcrdget_level_lengthss   rrWriteBuffer[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[rrcrcrdrr.z#buffer_put_lines..cSrYrcrarrcrcrdrwrxz$buffer_put_lines..rhN)rrr{)rVrtrcrcrdbuffer_put_liness ru)r]r)r]rr)rxr[rVrlrrr]rr)rVrlrrr]r) NrTNNrKrTNN)r~rrMrOrnrrZr[rrrrrMr[rr[rrrarrrOr]rm)rrr]rm)r~rr]rY)r)rrrr[r]r[r)rrrr[rrr]r[)rrYrr[rrr]r)r~rrrr]rr%)r~r&rr'r#rYr]r)rKNN) r@rmrMr[rArrr,r]rm)r)r1rrr[r]rm)r;r[r]r[)r?r@rr[r]rm)rr2r]rY)rF)r[rr\rYr]r^)r`)r[rrlrmr]rn)rVrsrtrmr]r^)ri __future__rcollections.abcrrrrr contextlibrcsvr r rr functoolsr ior rfr7shutilrtypingrrrrrr unicodedatarnumpyrZpandas._config.configrrZ pandas._libsrZpandas._libs.missingrZpandas._libs.tslibsrrrrrrZpandas._libs.tslibs.nattyper Zpandas.core.dtypes.commonr!r"r#r$r%r&Zpandas.core.dtypes.dtypesr'r(r)Zpandas.core.dtypes.missingr*r+Zpandas.core.arraysr,r-r.Zpandas.core.arrays.string_r/Zpandas.core.baser0Zpandas.core.commoncorecommonrIZpandas.core.constructionr1Zpandas.core.indexes.apir2r3r4r5Zpandas.core.indexes.datetimesr6Zpandas.core.indexes.timedeltasr7Zpandas.core.reshape.concatr8Zpandas.io.commonr9r:rr;Zpandas._typingr<r=r>r?r@rArBrCrDrErFZpandasrGrHrI__annotations__Z_VALID_JUSTIFY_PARAMETERSrRrSrrrrrrrrkrwrrorrrrrrrrrrr!rrr$rHrrrrrJrkrrrurcrcrcrds                    4 ;  @! '  !&C  ( RpJ   E      1 " ! $ `; +