a oEb  @sdZddlmZddlmZddlmZmZddlZddl m Z ddl m Z ddl Z ddlZddlmZdd lmZmZmZmZmZmZmZmZmZmZdd lmZddlZdd l m!Z!m"Z"dd l#m$Z$dd l%m&Z&ddl'm(Z(m)Z)m*Z*m+Z+ddl,m-Z-ddl.m/Z/m0Z0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8ddl9m:Z:m;Z;mZ>m?Z?m@Z@mAZAmBZBmCZCmDZDmEZEmFZFddlGmHZHmIZIddlJmKZKmLZLmMZMddlNmOZOddlPmQmRZSddlTmUZUddlVmWZWmXZXmYZYmZZZddl[m\Z\ddl]m^Z^ddl_m`Z`ddlambZbmcZcddldmeZemfZfmgZger(ddlhmiZimjZjdZkdZldZmGd d!d!ZnGd"d#d#ZoGd$d%d%ZpGd&d'd'epZqd%d(d)d*Zrd+d(d,d-Zsd+d(d.d/ZtGd0d1d1ZuGd2d3d3Zvdd4d5d6d6d7d8d9Zwedd5d6d:d;d<ZxddAdBdCd4dDdEd4d4dFdDdGdH dIdJZyGdKdLdLZzGdMdNdNezZ{GdOdPdPezZ|GdQdRdRezZ}GdSdTdTezZ~dUdGdVdWdXZdYdZd[d\d]Zdd_d4d4d`dadbZdd_d4d6d4dcdddeZddZd4d6dfdgdhdiZdjd6d6dkdldmZGdndodoe}ZGdpdqdqezZddsd4dZdfdtdudvZddGd4dDdwdGdxdydzZdd{d4dGd|d}d~Zd4d4dddZddd4dGdddZddZdddZGdddZdddZddddZddAdddddZddGddddZdS)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_NONNUMERICN)partial)StringIO)get_terminal_size) IO TYPE_CHECKINGAnyCallableHashableIterableListMappingSequencecast)east_asian_width) get_option set_option)lib)NA)NaT Timedelta TimestampiNaT)NaTType) ArrayLikeColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelStorageOptions WriteBuffer) is_categorical_dtypeis_complex_dtypeis_datetime64_dtypeis_datetime64tz_dtypeis_extension_array_dtypeis_floatis_float_dtype is_integeris_integer_dtype is_list_likeis_numeric_dtype is_scalaris_timedelta64_dtype)isnanotna) Categorical DatetimeArrayTimedeltaArray) PandasObject) extract_array)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)check_parent_directorystringify_path)adjoinjustify pprint_thing) 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. ) leftrightcenterrEz justify-allstartendinheritz match-parentinitialunsetz Returns ------- str or None If buf is None, returns the result as a string. Otherwise returns None. c@sNeZdZdddddddd d Zdd d d Zdd ddZdd ddZdS)CategoricalFormatterNTNaNr6IO[str] | Noneboolstr) categoricalbuflengthna_repfootercCs8||_|dur|ntd|_||_||_||_t|_dSN)rVrrWrYrXrZrquoting)selfrVrWrXrYrZr_X/home/ja/django-apps/lartica_env/lib/python3.9/site-packages/pandas/io/formats/format.py__init__s zCategoricalFormatter.__init__returncCsPd}|jr*|r|d7}|dt|j7}|j}|r@|d7}||7}t|S)Nr\, Length:  )rXlenrV_repr_categories_inforU)r^rZ level_infor_r_r` _get_footers z CategoricalFormatter._get_footer list[str]cCst|jdd|j|jdS)N) float_formatrYr]) format_arrayrV_internal_get_valuesrYr]r^r_r_r`_get_formatted_valuessz*CategoricalFormatter._get_formatted_valuescCs||j}t|dkr$|jr |SdS|}dd|D}d|}d|dg}|jrn|}|rn||td|S) Nrr\cSsg|] }|qSr_)strip.0ir_r_r` z2CategoricalFormatter.to_string..rd[]rf)rVrgrZrjrpjoinappendrU)r^rV fmt_valuesvaluesresultrZr_r_r` to_strings   zCategoricalFormatter.to_string)NTrRT)__name__ __module__ __qualname__rarjrpr~r_r_r_r`rQs rQc @sveZdZddddddd dd dd d d d dZddddZd dddZddddZddddZd dddZdS)SeriesFormatterNTrRFrHrS bool | strrTrU str | None int | None) seriesrWrXheaderindexrYnamerldtypemax_rowsmin_rowsc Cst||_|dur|nt|_||_||_||_||_||_| |_| |_ |durTt d}||_ | |_ t |_|dS)Ndisplay.float_format)rrrWrrYrrXrrrrrlrget_adjustmentadj _chk_truncate) r^rrWrXrrrYrrlrrrr_r_r`raszSeriesFormatter.__init__NonerbcCs||j}|j}|o t|j|k}|j}|rtt|}|rDt||}|dkr`|}|jd|}n*|d}t|jd||j| df}||_ nd|_ ||_ ||_ dS)N) rrrgrrintminilocrA tr_row_num tr_seriesis_truncated_vertically)r^rrrrrow_numr_r_r`r's$  "zSeriesFormatter._chk_truncatecCsB|jj}d}t|jjdddurLt|jjtttfs8J|d|jjj7}|jdur|dur|rj|d7}t |dd}|d|7}|j d us|j d kr|j r|r|d7}|d t |j7}|j dur |j dur t|jj d d}|r |r|d7}|d t |7}t|jj r:|jj}|r2|d7}||7}t|S)Nr\freqzFreq: Frd  rf) escape_charszName: Ttruncatererzdtype: rf)rrgetattrr isinstancer?r=r@ZfreqstrrFrXrrgrrr'_valuesrhrU)r^rrZZ series_nameZ dtype_namerir_r_r`rjBs@   zSeriesFormatter._get_footerztuple[list[str], bool]cCsR|jj}t|tr4tdd|jD}|jdd}n|jdu}|jdd}||fS)Ncss|] }|VqdSNr_rsrr_r_r` orvz7SeriesFormatter._get_formatted_index..T)names)r)rrrr<anyrformatr)r^r have_header fmt_indexr_r_r`_get_formatted_indexks   z$SeriesFormatter._get_formatted_indexrkcCst|jjd|j|j|jdS)N)rlrY leading_space)rmrrrlrYrror_r_r`rpvsz%SeriesFormatter._get_formatted_valuesc Cs2|j}|}t|dkr2t|jjd|dS|\}}|}|jrd}|j }t t |}|j ||d}|dkrd} nd} |j j | g|dd d} |||| ||dd |jr|j jdg|dd|gR} n|j d|} |jr|r|dd | } |r$| d |7} td | S) Nrz([], )r...z..rKmoder\rf)rrjrgtyperrrrprrrrrrEinsertrrDrrUry) r^rrZrrr{Z n_header_rowsrwidthZdot_strr}r_r_r`r~s2   " zSeriesFormatter.to_string) NTTTrRFNTNN) rrrrarrjrrpr~r_r_r_r`rs $ )  rc@sJeZdZddZdddddZdd ddd d d d ZdddddZdS)TextAdjustmentcCstd|_dS)Nzdisplay.encoding)rencodingror_r_r`raszTextAdjustment.__init__rUrtextrccCst|Srrgr^rr_r_r`rgszTextAdjustment.lenrJr rktextsmax_lenrrccCst|||dS)Nr)rEr^rrrr_r_r`rEszTextAdjustment.justify)spacerccOs t|g|R|j|jd|S)N)ZstrlenZjustfunc)rDrgrE)r^rlistskwargsr_r_r`rDszTextAdjustment.adjoinN)rJ)rrrrargrErDr_r_r_r`rsrcsBeZdZfddZdddddZdd ddd d d d ZZS)EastAsianTextAdjustmentcs6ttdrd|_nd|_dddddd|_dS)Nz!display.unicode.ambiguous_as_widerr)ZNaNWFH)superrarambiguous_width_EAW_MAPro __class__r_r`ras  z EastAsianTextAdjustment.__init__rUrrcs(t|tst|Stfdd|DS)zN Calculate display width considering unicode East Asian Width c3s"|]}jt|jVqdSr)rgetrr)rscror_r`rsz.EastAsianTextAdjustment.len..)rrUrgsumrr_ror`rgs   zEastAsianTextAdjustment.lenrJz Iterable[str]rkrcsXfdd|dkr(fdd|DS|dkrBfdd|DSfdd|DSdS) Ncs|t|Srr)t)rr^r_r`_get_padsz1EastAsianTextAdjustment.justify.._get_padrIcsg|]}||qSr_)ljustrsxrr_r`rurvz3EastAsianTextAdjustment.justify..rKcsg|]}||qSr_)rKrrr_r`rurvcsg|]}||qSr_)rjustrrr_r`rurvr_rr_)rrr^r`rEs zEastAsianTextAdjustment.justify)rJ)rrrrargrE __classcell__r_r_rr`rs  rrbcCstd}|rtStSdS)Nz display.unicode.east_asian_width)rrr)Zuse_east_asian_widthr_r_r`rsrzdict[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)Zpandas.io.formatsrrZget_console_size)rr_r_r_r`get_dataframe_repr_paramss rcCsNt\}}tddkr|ntd}tddkr2|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)rheightrrr_r_r`get_series_repr_paramss   rc@sVeZdZdZerendZeee7Zdidd d d d d ddddd ddddd d d dddZddddZed dddZ ed dddZ ed ddd Z ed dd!d"Z ed dd#d$Z ed dd%d&Zed dd'd(Zed dd)d*Zed dd+d,Zed-dd.d/Zdd d0d1d2Zdd3d4d5d6Zdd d7d8d9Zd d:d;dd?d@dAZdddBdCZdddDdEZdddFdGdHZd ddIdJZd ddKdLZd ddMdNZd-ddOdPZdQddRdSZdQddTdUZ dQddVdWZ!dddXdYZ"d-dZd[d\d]Z#d^d_d[d`daZ$dddbdcddZ%ddZdbdedfZ&dZddgdhZ'dS)jDataFrameFormatterz;Class for processing dataframe formatting options and data.r\NTrRF.rGzSequence[str] | NonezColspaceArgType | Nonezbool | Sequence[str]rTrUzFormattersType | NonerFloatFormatType | None bool | Nonerr)framecolumns col_spacerrrY formattersrErlsparsify index_namesrrrrdecimal bold_rowsescapecCs||_|||_|||_||_||_||_|||_ | ||_ | |_ | | |_| |_||_||_||_| |_| |_||_||_||_||_|j|_|t|_dSr)r_initialize_columnsr_initialize_colspacerrrrY_initialize_formattersr_initialize_justifyrErl_initialize_sparsifyrshow_index_namesrrrrrrr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framerrr)r^rrrrrrYrrErlrrrrrrrrrr_r_r`ra0s.       zDataFrameFormatter.__init__zlist[list[str]]rbcCs*|}|jr&||j}|d||S)zP Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrrrr)r^strcolsZ str_indexr_r_r` get_strcols_s   zDataFrameFormatter.get_strcolscCs|jdup|jdko|jS)NTr)r is_truncatedror_r_r`should_show_dimensionsks z)DataFrameFormatter.should_show_dimensionscCst|jp |jSr)rTis_truncated_horizontallyrror_r_r`rqszDataFrameFormatter.is_truncatedcCst|jot|j|jkSr)rTrrgrror_r_r`rusz,DataFrameFormatter.is_truncated_horizontallycCst|jot|j|jkSr)rTrrgrror_r_r`rysz*DataFrameFormatter.is_truncated_verticallycCs dt|jdt|jjdS)Nz [z rows x z columns])rgrrror_r_r`dimensions_info}sz"DataFrameFormatter.dimensions_infocCs t|jjSr) _has_namesrrror_r_r`has_index_namessz"DataFrameFormatter.has_index_namescCs t|jjSr)rrrror_r_r`has_column_namessz#DataFrameFormatter.has_column_namescCst|j|j|jfSr)allrrrror_r_r`show_row_idx_namessz%DataFrameFormatter.show_row_idx_namescCst|j|j|jfSr)rrrrror_r_r`show_col_idx_namessz%DataFrameFormatter.show_col_idx_namesrcCst|jpt|jt|jSr)rrrgrror_r_r`max_rows_displayedsz%DataFrameFormatter.max_rows_displayed)rrccCs|durtdS|S)Nzdisplay.multi_sparser)r^rr_r_r`rsz'DataFrameFormatter._initialize_sparsifyr#)rrccCsT|dur iSt|jjt|ks*t|tr.|Stdt|dt|jjddS)NzFormatters length(+) should match DataFrame number of columns(r)rgrrrdict ValueError)r^rr_r_r`rs  z)DataFrameFormatter._initialize_formatters)rErccCs|durtdS|SdS)Nzdisplay.colheader_justifyr )r^rEr_r_r`rsz&DataFrameFormatter._initialize_justifyr;)rrccCs,|dur t|}|j||_|S|jjSdSr)r>rr)r^rcolsr_r_r`rs  z&DataFrameFormatter._initialize_columnsr)rrccsduri}ntttfrBdi}|fdd|jjDnttrD]&}||jjvrT|dkrTtd|qT}nHt |jjt krtdt dt |jjdt t |jj}|S)Nr\csi|] }|qSr_r_)rscolumnrr_r` rvz;DataFrameFormatter._initialize_colspace..z,Col_space is defined for an unknown column: zCol_space length(r r) rrrUupdaterrrkeysr rgr zip)r^rr}rr_rr`rs(    z'DataFrameFormatter._initialize_colspacecCs0|s|jSt\}}||r&|S|jSdS)z%Number of columns fitting the screen.N)_is_in_terminalrr_is_screen_narrow)r^rrr_r_r`rs   z(DataFrameFormatter._calc_max_cols_fittedcCsP|r@t\}}|jdkr(||S||r8|}qF|j}n|j}||S)z,Number of rows with data fitting the screen.r)rrr_get_number_of_auxillary_rows_is_screen_short_adjust_max_rows)r^rrrr_r_r`rs    z(DataFrameFormatter._calc_max_rows_fitted)rrccCs(|r$t|j|kr$|jr$t|j|}|S)zAdjust max_rows using display logic. See description here: https://pandas.pydata.org/docs/dev/user_guide/options.html#frequently-used-options GH #37359 )rgrrr)r^rr_r_r`rs z#DataFrameFormatter._adjust_max_rowscCst|jdkp|jdkS)z/Check if the output is to be shown in terminal.r)rTrrror_r_r`rsz"DataFrameFormatter._is_in_terminalcCst|jdkot|jj|kSNr)rTrrgrr)r^ max_widthr_r_r`rsz$DataFrameFormatter._is_screen_narrowcCst|jdkot|j|kSr)rTrrgr)r^ max_heightr_r_r`rsz#DataFrameFormatter._is_screen_shortcCs:d}d}||}|jr(|t|j7}|jr6|d7}|S)z?Get number of rows occupied by prompt, dots and dimension info.r)rrgr splitlinesr)r^Zdot_rowZ prompt_rowZnum_rowsr_r_r`rsz0DataFrameFormatter._get_number_of_auxillary_rowsrcCs |jr||jr|dS)zY Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyr_truncate_verticallyror_r_r`rszDataFrameFormatter.truncatecCs|jdusJ|jd}|dkr|jjddd|f}|jjdd| df}t||fdd|_t|jttfrg|jd||j| d|_n&tt |j }|jjddd|f|_||_ dS)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num NrrZaxis) rrrrArrlisttuplerrrZ tr_col_num)r^Zcol_numrIrJr_r_r`rs   z)DataFrameFormatter._truncate_horizontallycCs|jdusJ|jd}|dkrb|jjd|ddf}|jj| dddf}t||f|_n&tt|j}|jjd|ddf|_||_dS)zRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrr)rrrrArrrr)r^rheadtailr_r_r`r5s  z'DataFrameFormatter._truncate_verticallyc sg}tjsbjsbtjD]>\}}|}t|jtj |dj d}| |q|Stjrt t tj_tjtjkrtdtjdtjdddjD}n j}jr|D]}| dqtjD]\}}||}ttj |dgfd d |DR}|}t|j|j d }ttfd d |D|} j j|| jd }| ||q|S)Nr)stringsrEminimumrzWriting z cols but got z aliasescSsg|] }|gqSr_r_)rslabelr_r_r`ru^rvzADataFrameFormatter._get_strcols_without_index..r\c3s|]}j|VqdSrrrgrror_r`rirvz@DataFrameFormatter._get_strcols_without_index..)r&rc3s|]}j|VqdSrr(rror_r`rprvr)r0r enumerater format_col_make_fixed_widthrErrrrrzrrrUrgrr _get_formatted_column_labelsrmax) r^rrtrr{ str_columnsrZcheaderZheader_colwidthrr_ror`rGsP       z-DataFrameFormatter._get_strcols_without_indexrk)rtrcc CsL|j}||}t|jdd|fj||j|j|j|j ||j |j dS)N)rlrYrrr) r_get_formatterrmrrrlrYrrrrr)r^rtr formatterr_r_r`r*vs zDataFrameFormatter.format_col str | intCallable | NonecCs`t|jttfr2t|r,tt|}|j|SdSn*t|rN||jvrN|j|}|j|dSdSr) rrr!r"r.rrrr)r^rtr_r_r`r/s   z!DataFrameFormatter._get_formatter)rrccsddlm}|j}t|tr|jddd}tt|}jj j }t dd|j Dt t|tt|fddttfd d|D}jrt|r||}d d t|D}n<|}jj }t t|tt|fd d t|D}|S) Nr)sparsify_labelsF)rrDcss|] }|jVqdSr)Z is_floating)rslevelr_r_r`rrvzBDataFrameFormatter._get_formatted_column_labels..cs"|jvr|rsd|S|S)N )r)ry) need_leadsprestrict_formattingr^r_r` space_formatszEDataFrameFormatter._get_formatted_column_labels..space_formatc3s"|]fddDVqdS)csg|]}|qSr_r_)rsr6)r9rr_r`rurvzMDataFrameFormatter._get_formatted_column_labels...Nr_)rs)r9rr`rrvcSsg|] }t|qSr_)r!rr_r_r`rurvzCDataFrameFormatter._get_formatted_column_labels..cs0g|](\}}|s&|r&d|n|gqS)r5)r/)rsrtr)r7r^r_r`rus)Zpandas.core.indexes.multir3rrr<rr!rrdtypesrrlevelsr mapr1rrgr))r^rr3rZ fmt_columnsr;r.r_)r7r8r^r9r`r,s,      z/DataFrameFormatter._get_formatted_column_labelscsddjD|j}|j}d}t|trL|jjdj |d}n|jj |dg}fdd|D}j j d g|R d }j rd dD}n d g|j}jr||S|SdS) NcSsi|]\}}|tt|qSr_)rr)rskvr_r_r`rrvz;DataFrameFormatter._get_formatted_index.. __index__F)rrDrr0)rr0c s.g|]&}ttt|dddjdqS)rIr\r)rEr&r)r"r+r!rrrrr^r_r`rus z;DataFrameFormatter._get_formatted_index..rrfcSsg|] }t|qSr_rUrr_r_r`rurvr\)ritemsrrr/rr<rrrrrDsplitr_get_column_name_listZnlevelsr)r^rrrfmtrZadjoinedZ col_headerr_rAr`rs,     z'DataFrameFormatter._get_formatted_indexcCsLg}|jj}t|tr.|dd|jDn||jdur@dn|j|S)Ncss|]}|durdn|VqdSr[r_rr_r_r`rrvz;DataFrameFormatter._get_column_name_list..r\)rrrr<extendrrzr)r^rrr_r_r`rEs  z(DataFrameFormatter._get_column_name_list)NNTTrRNNNNTNNNFrFT)(rrr__doc__common_docstringreturn_docstringrarpropertyrrrrrrrrrr rrrrrrrrrrrrrrrrr*r/r,rrEr_r_r_r`r*s~  2/    /  )(rc@seZdZdZddddZd%dd d d d d d d d d d d d d Zd&dd dd dd d d dddZd'dd dd dddZd(dd ddddd ddd dd d d dd!d d"d#d$ZdS))DataFrameRendereraJClass for creating dataframe output in multiple formats. Called in pandas.core.generic.NDFrame: - to_csv - to_latex Called in pandas.core.frame.DataFrame: - to_html - to_string Parameters ---------- fmt : DataFrameFormatter Formatter with the formatting options. rrFcCs ||_dSrrM)r^rFr_r_r`raszDataFrameRenderer.__init__NF"FilePath | WriteBuffer[str] | NonerrT) rW column_format longtabler multicolumnmulticolumn_formatmultirowcaptionr'positionrcc  Cs>ddlm} | |j||||||| | d } | } t| ||dS)zU Render a DataFrame to a LaTeX tabular/longtable environment output. r)LatexFormatter)rPrOrQrRrSrTr'rUrWr)Zpandas.io.formats.latexrVrFr~save_to_buffer)r^rWrOrPrrQrRrSrTr'rUrVZlatex_formatterstringr_r_r`to_latexs  zDataFrameRenderer.to_latexzstr | list | tuple | Noner)rWrclassesnotebookbordertable_id render_linksrcc CsFddlm}m} |r| n|} | |j||||d} | } t| ||dS)uJ Render a DataFrame to a html table. Parameters ---------- buf : str, path object, file-like object, or None, default None String, path object (implementing ``os.PathLike[str]``), or file-like object implementing a string ``write()`` function. If None, the result is returned as a string. encoding : str, default “utf-8” Set character encoding. classes : str or list-like classes to include in the `class` attribute of the opening ```` tag, in addition to the default "dataframe". notebook : {True, False}, optional, default False Whether the generated HTML is for IPython Notebook. border : int A ``border=border`` attribute is included in the opening ``
`` tag. Default ``pd.options.display.html.border``. table_id : str, optional A css id is included in the opening `
` tag if specified. render_links : bool, default False Convert URLs to HTML links. r) HTMLFormatterNotebookFormatter)r[r]r^r_rW)Zpandas.io.formats.htmlr`rarFr~rX) r^rWrr[r\r]r^r_r`raZKlassZhtml_formatterrYr_r_r`to_htmls" zDataFrameRenderer.to_html)rWrrrccCs0ddlm}||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)rrW)Zpandas.io.formats.stringrcrFr~rX)r^rWrrrcZstring_formatterrYr_r_r`r~Qs zDataFrameRenderer.to_string,winfer"Tstrictz7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | NonerUzSequence[Hashable] | NonezIndexLabel | Noner r%) path_or_bufrsepr index_labelr compressionr] quotecharline_terminator chunksize date_format doublequote escapecharerrorsstorage_optionsrccCsddlm}|dur d}t}nd}||| ||||||||| | | | |||jd}||r~t|tsjJ|}||SdS)z; Render dataframe as comma-separated file. r) CSVFormatterNTF)rirnrjrrsrlr]rrkrrormrprqrrrtr0)Zpandas.io.formats.csvsrurrFsavergetvalueclose)r^rirrjrrkrrlr]rmrnrorprqrrrsrtruZcreated_bufferZ csv_formattercontentr_r_r`to_csvks> zDataFrameRenderer.to_csv) NNFNFNFNNN)NNNFNNF)NNN)NNrdNNrerfNrgNNNTNrhN) rrrrHrarZrbr~rzr_r_r_r`rLsT$"5rLrUrNr)rYrWrrccCsZt||d:}|||dur6|WdSWddS1sL0YdS)zQ Perform serialization. Write to buf or return as string if buf is None. )rN) get_bufferwriterw)rYrWrfr_r_r`rXs  rXrWccs|durt|}nt}|dur&d}nt|ts8tdt|drJ|VnVt|trtt|t|d|dd}|VWdq1s0YntddS) z Context manager to open, yield and close buffer for filenames or Path-like objects, otherwise yield buf unchanged. Nzutf-8z1buf is not a file name and encoding is specified.r|rer\)rnewlinez1buf is not a file name and it has no write method) rCrrrUr hasattrrBopen TypeError)rWrr}r_r_r`r{s     &r{rRrJrTr r2rrzstr | int | Nonerrk) r|r0rlrYdigitsrrErrr]rcc Cst|jrt} n^t|jr t} nNt|jr0t} n>t|jr@t} n.t |jsTt |jrZt } nt |jrjt } nt} |dur~td}|durtd}|durtd}| |||||||||| d } | S)ad 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. Returns ------- List[str] Ndisplay.column_spacerdisplay.precision) rrYrlr0rrErrr])r)rDatetime64Formatterr*Datetime64TZFormatterr3Timedelta64Formatterr+ExtensionArrayFormatterr-r(FloatArrayFormatterr/IntArrayFormatterGenericArrayFormatterr get_result) r|r0rlrYrrrErrr]Z fmt_klassZfmt_objr_r_r`rms@'      rmc @sLeZdZddd d d d d d d dddd ddZddddZddddZdS)rNrR rJrTr rr2rUr1rrrTr) r|rr0rYrrlrErr] fixed_widthrc CsF||_||_||_||_||_||_||_||_| |_| |_ | |_ dSr) r|rrYrr0rlrErr]rr) r^r|rr0rYrrlrErr]rrr_r_r`ra(szGenericArrayFormatter.__init__rkrbcCs|}t||jSr)_format_stringsr+rE)r^r{r_r_r`rBsz GenericArrayFormatter.get_resultc sfjdur0td}|dur6tdfdd}nj}jdurHjn"jduoZjtk}ttd|dfdd}tjd d }t |t j st d t |t}|t jt|ttd t|jd @}j}|dur|}g}t|D]r\} } || s|r|d|| q|| r6||| q|durFd} nd} || j|| dq|S)Nrrcst|dddS)Nz .dr})_trim_zeros_single_floatr:) precisionr_r`Ksz7GenericArrayFormatter._format_strings..r)r quote_stringsc sjdurtt|rtt|rtz<|dur*WdS|tur._formatTZ extract_numpyz.base_formattercst|rt|SjSr)r5rUrYrror_r`rsrcs|djdS)Nrr)replacerr)rr^r_r`decimal_formattersz?FloatArrayFormatter._value_formatter..decimal_formattercs0t|r&t|kr|SdSnjSdS)Ng)r5absrYr)rr^rr_r`r0s   z7FloatArrayFormatter._value_formatter..formatter)rlr)r^rlrr0r_)rrrlr^rr`_value_formatters   z$FloatArrayFormatter._value_formatter np.ndarrayrbc sddddddjdur.jjjSjr>tdndfd d }jdurjrjd urrd }nd }t|jj d}qj}n fdd}||}js|St |dkrt dd|D}|j dk}nd}t j ddDt j}|dk}|dj k|dk@} Wdn1s80Y| sT|r|rjd urfd}nd}t|jj d}||}|S)z Returns the float values converted into strings using the parameters given at initialisation, as a numpy array rr rU)r|r0rYcs<t|}tfddt||D|j}|S)Ncs g|]\}}|s|nqSr_r_)rsvalmr0rYr_r`ruszWFloatArrayFormatter.get_result_as_array..format_with_na_rep..)r4rarrayrravelZreshaper)r|r0rYmask formattedr_rr`format_with_na_reps zCFloatArrayFormatter.get_result_as_array..format_with_na_repNzdisplay.chop_thresholdcsx|}jdkr"dj}nj}j}t|}|||}jrt|rZt|j}n t|j}t j |ddS|S)NrIr5objectr) rrErYr|r(r_trim_zeros_complexr_trim_zeros_floatrasarray)rlr0rYr|Z is_complexr}rr^rr_r`format_values_withs     zCFloatArrayFormatter.get_result_as_array..format_values_withTz{value: .{digits:d}f}z{value:.{digits:d}f})rcs j|Sr)rlrror_r`rrvz9FloatArrayFormatter.get_result_as_array..rcss|]}t|VqdSrrrr_r_r`r rvz:FloatArrayFormatter.get_result_as_array..Fignoreinvalidg.A z{value: .{digits:d}e}z{value:.{digits:d}e})r0r|rYrrrlrrrrrgr-rerrstaterr) r^rZfmt_strrlZformatted_valuesmaxlenZtoo_longZabs_valsZhas_large_valuesZhas_small_valuesr_rr`get_result_as_arraysD        & z'FloatArrayFormatter.get_result_as_arrayrkcCs t|Sr)r!rror_r_r`r9sz#FloatArrayFormatter._format_strings)NN)rrrrarrrrr_r_rr`rs  8crc@seZdZddddZdS)rrkrbcs>|jdurdd}ndd}|jp$|fdd|jD}|S)NFcSs|dj|dS)Nrr:rr:r_r_r`r@rvz3IntArrayFormatter._format_strings..cSs|dj|dS)Nz dr:rr:r_r_r`rBrvcsg|] }|qSr_r_rr0r_r`ruDrvz5IntArrayFormatter._format_strings..)rr0r|)r^Z formatter_strr{r_rr`r>s    z!IntArrayFormatter._format_stringsNrrrrr_r_r_r`r=srcs6eZdZd ddddfdd Zd d d d ZZS)rrNz3np.ndarray | Series | DatetimeIndex | DatetimeArrayrUr)r|nat_reprpc s$tj|fi|||_||_dSr)rrarrp)r^r|rrprrr_r`raIszDatetime64Formatter.__init__rkrbcsZj}t|tst|}jdur>tjr>fdd|DS|jjjjd}| S)z&we by definition have DO NOT have a TZNcsg|]}|qSr_rrror_r`ru\rvz7Datetime64Formatter._format_strings..)rYrp) r|rr?r0r_dataZ_format_native_typesrrptolist)r^r|r{r_ror`rTs z#Datetime64Formatter._format_strings)rNrrrrarrr_r_rr`rHs rc@seZdZddddZdS)rrkrbc Csvt|jdd}|j}|dur(|jdd}t|tr<|}n t|}t |||j |j |j |j |j|j|j|jd }|S)NTr)Zboxed)rlrYrrrErrr])r:r|r0 _formatterrr6rnrrrmrlrYrrrErrr])r^r|r0rr{r_r_r`res(     z'ExtensionArrayFormatter._format_stringsNrr_r_r_r`rdsrz@np.ndarray | list[int | float] | list[float] | list[str | float]) percentilesrcc Csft|}tjdd<t|r>> 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]NdcSsg|] }|dqS%r_rrr_r_r`rurvz&format_percentiles..)to_beginto_endrcSsg|] }|dqSrr_rrr_r_r`rurv)rrrr1rr iscloseastyperrUuniquefloorlog10rZediff1dr-Z empty_likerround)rZint_idxoutZ unique_pctsrrprecr_r_r`format_percentiless6"   &   rz2np.ndarray | DatetimeArray | Index | DatetimeIndexrTr|rccCsft|ts|}t|}|jdur(dS|j}|tk}d}t||t |dk dk}|rbdSdS)NF"R:rT) rr;rr?tzZasi8rr logical_andrr)r| values_intconsider_values one_day_nanos even_daysr_r_r` is_dates_onlys  rrzNaTType | Timestamp)rrrccCs|tur |St|Sr)rrU)rrr_r_r`_format_datetime64sr)rrrprccCs$|tur |S|r||S|jSdSr)rstrftimeZ _date_repr)rrrpr_r_r`_format_datetime64_dateonlys  rr )rrrprccs"|rfddSfddSdS)Ncst|dS)N)rrp)rr:rprr_r`rsz'get_format_datetime64..cs t|dS)Nr)rr:rr_r`rrvr_)rrrpr_rr`get_format_datetime64srz*np.ndarray | DatetimeArray | DatetimeIndex)r|rprccCs6t|tjr|jdkr|}t|}|r2|p0dS|S)z6given values and a date_format, return a string formatrz%Y-%m-%d)rrrndimrr)r|rpidor_r_r`!get_format_datetime64_from_valuess rc@seZdZddddZdS)rrkrbcs>|jt}t|}|jp&t||jdfdd|D}|S)zwe by definition have a TZ)rpcsg|] }|qSr_r_rrr_r`rurvz9Datetime64TZFormatter._format_strings..)r|rrrr0rrp)r^r|rr{r_rr`rs z%Datetime64TZFormatter._format_stringsNrr_r_r_r`rsrcs6eZdZd ddddfdd Zd d d d ZZS)rrFznp.ndarray | TimedeltaIndexrUrT)r|rboxc s$tj|fi|||_||_dSr)rrarr)r^r|rrrrr_r`raszTimedelta64Formatter.__init__rkrbcs.|jpt|j|j|jdfdd|jDS)N)rrcsg|] }|qSr_r_rrr_r`ru,rvz8Timedelta64Formatter._format_strings..)r0get_format_timedelta64r|rrror_rr`r(s z$Timedelta64Formatter._format_strings)rFrr_r_rr`rs rFz,np.ndarray | TimedeltaIndex | TimedeltaArray)r|rrrcc s^|tj}|tk}d}||dk}t||}|dk}|rFdndfdd} | 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 rrNlongcsN|dust|rt|rSt|ts.t|}|jd}rJd|d}|S)Nr')r2r4rrZ _repr_base)rr}rrrr_r`rNs   z*get_format_timedelta64.._formatter)viewrZint64rrr) r|rrrrrZ not_midnightZbothrrr_rr`r/s     rzTextAdjustment | None)r%rEr&rrccst|dks|dkr|S|dur(tn|tfdd|D|durTt|tddurpkrpdddfdd fd d |D}j||d }|S) Nrrc3s|]}|VqdSrrr) adjustmentr_r`rkrvz$_make_fixed_width..rrU)rrccs6dur2dk|k@r2|ddd}|S)Nrrrr:)rconf_maxrr_r`justtsz_make_fixed_width..justcsg|] }|qSr_r_r)rr_r`ruzrvz%_make_fixed_width..r)rgrr-rrE)r%rEr&rr}r_)rrrrr`r+\s r+r) str_complexesrrccsDfdd|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)r\z([j+-]))ryrrerDr)rr_r`rusz'_trim_zeros_complex..cSsg|] }t|qSr_r)rssr_r_r`rurvcsg|]\}}|d|ddd |dd||ddd |dd ||dd d|dd|dqS)Nrr0rr_)rsrr>) max_lengthr_r`rus")r-r)rrtrimmedlengthspaddedr_)rrr`rs   r) str_floatrccCs |d}|dr|d7}|S)zX Trims trailing zeros after a decimal point, leaving just one if necessary. rr)rstripendswith)rr_r_r`rs  rnp.ndarray | list[str]) str_floatsrrccsj|}tddfdddddfdd }||rRfd d |D}q6fd 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]*$cst|duSr)rmatchr:) number_regexr_r`is_number_with_decimalsz1_trim_zeros_float..is_number_with_decimalrrTrcs0fdd|D}t|dko.tdd|DS)z Determine if an array of strings should be trimmed. Returns True if all numbers containing decimals (defined by the above regular expression) within the array end in a zero, otherwise returns False. csg|]}|r|qSr_r_rrr_r`rurvz:_trim_zeros_float..should_trim..rcss|]}|dVqdS)rNrrr_r_r`rrvz9_trim_zeros_float..should_trim..)rgr)r|numbersrr_r` should_trimsz&_trim_zeros_float..should_trimcs$g|]}|r|ddn|qS)Nrr_rrr_r`rurvz%_trim_zeros_float..cs*g|]"}|r"|r"|dn|qS)rrr)rrr_r`rus)rcompile)rrrrr}r_)rrrr`rs   rr;)rrccCs$t|trtj|jS|jduSdSr)rr<comZ any_not_nonerr)rr_r_r`rs  rc@sZeZdZdZdddddddd d d d d ddddddZd dddddZdddddZdS)! EngFormatterzl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter r6zar}pnurr\r>MGTPEZY)iiiiiiirrr rNFrrTaccuracyuse_eng_prefixcCs||_||_dSrr)r^rrr_r_r`raszEngFormatter.__init__z int | floatrU)numrcc Cs tt|}tj|rdStj|r.dSd}|dkrDd}| }|dkrnttt|dd}n td}| t |j }| t |j }t|}|j r|j |}n$|dkrd| d}n d |d}||d |}|jd urd }nd |jdd}|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 rRinfrrrrzE-Z02dzE+rNz{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)rDecimalrUis_nan is_infinitermathrrrr- ENG_PREFIXESrrrr) r^r ZdnumsignZpow10Z int_pow10r#r" format_strrr_r_r`__call__s4  "    zEngFormatter.__call__)NF)rrrrHr(rar+r_r_r_r`r s*r rrr)rrrccCs(tdt||tdtd|ddS)z Alter default behavior on how float is formatted in DataFrame. Format float in engineering format. By accuracy, we mean the number of decimal digits after the floating point. See also EngFormatter. rrrrN)rr r-rr_r_r`set_eng_float_format.sr,r\zbool | object | strzlist[dict[int, int]])r<sentinelrcc Cst|dkrgSdgt|d}g}|D]b}d}i}t|D]2\}}||rX||krXq>d||<||||<|}q>t||||<||q*|S)a For each index in each level the function returns lengths of indexes. Parameters ---------- levels : list of lists List of values on for level. sentinel : string, optional Value which states that no new index starts on there. Returns ------- Returns list of maps. For each level returns map of indexes (key is index in row and value is length of index). rTF)rgr)rz) r<r-controlr}r4 last_indexrrtkeyr_r_r`get_level_lengths:s    r1zWriteBuffer[str])rWlinesrccCs4tdd|Dr dd|D}|d|dS)z Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. css|]}t|tVqdSr)rrUrr_r_r`rprvz#buffer_put_lines..cSsg|] }t|qSr_rBrr_r_r`ruqrvz$buffer_put_lines..rfN)rr|ry)rWr2r_r_r`buffer_put_lineses r3)NN)N)NrRNNrJrTN)r)rN)rN)rF)rJNN)r)r)rF)r\)rH __future__r contextlibrcsvrrr functoolsriorr'rshutilrtypingr r r r r rrrrr unicodedatarnumpyrZpandas._config.configrrZ pandas._libsrZpandas._libs.missingrZpandas._libs.tslibsrrrrZpandas._libs.tslibs.nattyperZpandas._typingrrrr r!r"r#r$r%r&Zpandas.core.dtypes.commonr'r(r)r*r+r,r-r.r/r0r1r2r3Zpandas.core.dtypes.missingr4r5Zpandas.core.arraysr6r7r8Zpandas.core.baser9Zpandas.core.commoncorecommonr Zpandas.core.constructionr:Zpandas.core.indexes.apir;r<r=r>Zpandas.core.indexes.datetimesr?Zpandas.core.indexes.timedeltasr@Zpandas.core.reshape.concatrAZpandas.io.commonrBrCZpandas.io.formats.printingrDrErFZpandasrGrHrIZ_VALID_JUSTIFY_PARAMETERSrJrQrrrrrrrrLrXr{rmrrrrrrrrrrrrrrr+rrrrr r,r1r3r_r_r_r`s     0    0 <     ; @!'!&C@$$Oj- E   /# $_ +