MhO%SrSSKJr SSKJrJrJrJr SSKJ r SSK J r SSK J r SSKJr SSKJr SS KrSS KrSS KJr SS KJrJrJrJrJr SS KrSS KJrJ r SS K!J"r" SSK#J$r$ SSK%J&r&J'r'J(r( SSK)J*r* SSK+J,r,J-r-J.r.J/r/J0r0J1r1 SSK2J3r3J4r4J5r5 SSK6J7r7J8r8 SSK9J:r:J;r;JJ?r? SSK@JArA SS KBJCs JDrE SSKFJGrGJHrHJIrIJJrJ SSKKJLrL SSKMJNrN SSKOJPrP SSKQJRrRJSrS SSKTJUrU \(a$SSKVJWrWJXrXJYrYJZrZJ[r[J\r\J]r]J^r^J_r_J`r`JaraJbrb SSKcJdrdJere SrfS \gS!'S"rhS#riS \gS$'"S%S&5rjSNS'jrkSNS(jrl"S)S*5rm"S+S,5rnSOSPS-jjro\ SQSRS.jj5rpSSSTS/jjrq"S0S15rr"S2S3\r5rs"S4S5\r5rt"S6S7\r5ru"S8S9\r5rvSUS:jrwSVS;jrxSWSXS<jjrySYSZS=jjrzSYS[S>jjr{"S?S@\u5r|"SASB\r5r}S\S]SCjjr~S^S_SDjjrS`SaSEjjrSbSFjrS`ScSGjjrSdSHjr"SISJ5rSeSfSKjjrSgShSLjjrSiSMjrg )jz Internal module for formatting output data in csv, html, xml, and latex files. This module also applies to display formatting. ) annotations) GeneratorHashableMappingSequence)contextmanager) QUOTE_NONE)Decimal)partial)StringION)get_terminal_size) TYPE_CHECKINGAnyCallableFinalcast) get_option set_option)lib)NA)NaT Timedelta Timestamp)NaTType)is_complex_dtypeis_float is_integer is_list_likeis_numeric_dtype is_scalar)CategoricalDtypeDatetimeTZDtypeExtensionDtype)isnanotna) Categorical DatetimeArrayExtensionArrayTimedeltaArray) StringDtype) PandasObject)Index MultiIndex PeriodIndex ensure_index) DatetimeIndex)TimedeltaIndex)concat)check_parent_directorystringify_path)printing) ArrayLikeAxesColspaceArgType ColspaceTypeCompressionOptionsFilePathFloatFormatTypeFormattersType IndexLabelSequenceNotStrStorageOptions WriteBuffer) DataFrameSeriesa Parameters ---------- buf : str, Path or StringIO-like, optional, default None Buffer to write to. If None, the output is returned as a string. columns : array-like, optional, default None The subset of columns to write. Writes all columns by default. col_space : %(col_space_type)s, optional %(col_space)s. header : %(header_type)s, optional %(header)s. index : bool, optional, default True Whether to print index (row) labels. na_rep : str, optional, default 'NaN' String representation of ``NaN`` to use. formatters : list, tuple or dict of one-param. functions, optional Formatter functions to apply to columns' elements by position or name. The result of each function must be a unicode string. List/tuple must be of length equal to the number of columns. float_format : one-parameter function, optional, default None Formatter function to apply to columns' elements if they are floats. This function must return a unicode string and will be applied only to the non-``NaN`` elements, with ``NaN`` being handled by ``na_rep``. sparsify : bool, optional, default True Set to False for a DataFrame with a hierarchical index to print every multiindex key at each row. index_names : bool, optional, default True Prints the names of the indexes. justify : str, default None How to justify the column labels. If None uses the option from the print configuration (controlled by set_option), 'right' out of the box. Valid values are * left * right * center * justify * justify-all * start * end * inherit * match-parent * initial * unset. max_rows : int, optional Maximum number of rows to display in the console. max_cols : int, optional Maximum number of columns to display in the console. show_dimensions : bool, default False Display DataFrame dimensions (number of rows by number of columns). decimal : str, default '.' Character recognized as decimal separator, e.g. ',' in Europe. rcommon_docstring) leftrightcenterjustifyz justify-allstartendinheritz match-parentinitialunsetz Returns ------- str or None If buf is None, returns the result as a string. Otherwise returns None. return_docstringc \rSrSrSrSSSSSSSSSS. SSjjrSS jrSS jrSS jrSS jr S r g)SeriesFormatterzP Implement the main logic of Series.to_string, which underlies Series.__repr__. TNaNFN) lengthheaderindexna_repname float_formatdtypemax_rowsmin_rowsc  Xl[5UlX`lXPlX0lX lX@lXlXl Uc [S5nXpl Xl [R"5UlUR!5 g)Ndisplay.float_format)seriesr bufrWrVrTrSrUrZr[rrXrYr5get_adjustmentadj _chk_truncate) selfr^rSrTrUrVrWrXrYrZr[s J/var/www/html/env/lib/python3.13/site-packages/pandas/io/formats/format.py__init__SeriesFormatter.__init__sm :        %&<=L( **, cU URnURnU=(a [UR5U:nURnU(an[ [ U5nU(a [ X5nUS:XaUnURSUnO-US-n[URSUURU*S45nXPl OSUl X@l X0l g)N) r[rZlenr^rintminilocr2 tr_row_num tr_seriesis_truncated_vertically)rcr[rZrqr^row_nums rdrbSeriesFormatter._chk_truncates ====#+"LDKK0@80K "C*Hx21}"Yh/"a-Xg!6 WHI8N OP%O"DO'>$rgcURRnSnURRn[U[[ [ 45(aURbUSUR3- nURSLa,Ub)U(aUS- n[R"USS9nUSU3- nURSLd!URS :Xa8UR(a'U(aUS- nUS [UR53- nURSLa]URbP[UR RS S5nU(a(U(aUS- nUS [R"U53- n[UR R["5(a4UR R$R'5nU(aUS - nX&- n[)U5$)NzFreq: Fz,    ) escape_charszName: TtruncatezLength: rWzdtype: ry)r^rWrU isinstancer0r.r1freqfreqstrr5 pprint_thingrSrqrkrYgetattrrpr!_values_get_repr_footerstr)rcrWfooterrU series_name dtype_name level_infos rd _get_footerSeriesFormatter._get_footers{{ !! u}k>J K K & u}}o. .F 99E !d&6$"//CUVK {m, ,F ;;$  KK: %$*F*F$ T[[!1 23 3F ::U "tzz'= !5!5vtDJdNFGH$9$9*$E#FGG dnn**,< = =//@@BJ$  F6{rgc[URRSURURUR S9$)N)rXrV leading_space) format_arrayrprrXrVrUrcs rd_get_formatted_values%SeriesFormatter._get_formatted_values(s6 NN " " **;;**   rgcDURnUR5n[U5S:Xa%[UR5R SUS3$UR n[U5n[U[5(aHURSSS9n[R"5nUR"S/UQ76RS5nOURSS9nUR!5nUR"(aSnUR$n ['[(U 5n UR*RXyS - 5n U S :aS n OS n UR*R-U /U S S9Sn UR/X-U 5 UR/U S -S5 UR (a#UR*R"S /US SU/Q76n OUR*RS U5n UR0(aU(a USS-U -n U(aU SU-- n [3SR5U 55$)Nrz([], )T) include_namessparsifyrjry include_nameri...z..rGmoderu)rprrktyper^__name__rU _has_namesr|r- _format_multir5r`adjoinsplit _format_flatrrqrorrlrarHinsertrTrjoin) rcr^rrU have_header fmt_indexra fmt_values n_header_rowsrrwidthdot_strresults rd to_stringSeriesFormatter.to_string1s!!# v;! 4;;'001vha@ @  ' eZ ( (++$+NI))+C 11y177=I***=I//1  ' 'MooG3(GHHLLaK!89Eqyhh&&y%h&GJG   g5w ?   Wq[" - ::XX__QE)AB-)DEFXX__Q 3F ;;;q\D(61F  dVm #F2776?##rg)rar_rYrXrTrUrqrSrZr[rVrWr^rorp)r^rCrS bool | strrTboolrUrrVrrWrrX str | NonerYrrZ int | Noner[rreturnNonerrrrr list[str]) r __module__ __qualname____firstlineno____doc__rerbrrr__static_attributes__rgrdrPrPs"#'##     ! @?6(T +$rgrPcSSKJn [S5(aUR5upOSn[S5[S5[S5[S5[S 5US .$) 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)rZr[max_cols max_colwidthshow_dimensions line_width)pandas.io.formatsrrget_console_size)rr_s rdget_dataframe_repr_paramsr_sd"*-..002 A 121245"#9:%&?@  rgc[5up[S5nUS:XaUOUnUS:XaUO [S5nSSUU[S5S.$)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)rWrYr[rZrS)r r)rheight max_rows_optrZr[s rdget_series_repr_paramsrs\"&'ME01L%*v H%*v ;M0NH67  rgcd\rSrSrSr\(a\OSr\\\-- rS'S(SjjrS)Sjr\ S*Sj5r \ S*Sj5r \ S*S j5r \ S*S j5r \ S+S j5r\ S*S j5r\ S*S j5r\ S*Sj5r\ S*Sj5r\ S,Sj5rS-SjrS.SjrS/SjrS0SjrS1SjrS2SjrS2SjrS3SjrS*SjrS*SjrS*SjrS,SjrS4Sjr S4Sjr!S4Sjr"S)S jr#S5S!jr$S6S"jr%S7S#jr&S8S$jr'S9S%jr(S&r)g):DataFrameFormatteriz{ Class for processing dataframe formatting options and data. Used by DataFrame.to_string, which backs DataFrame.__repr__. ruNcLXlURU5UlURU5UlX@lXPlX`lURU5Ul URU5Ul Xl URU 5UlXlUUlUUlUUlXlXlXlXlUR/5UlUR35UlURUlUR95 [:R<"5UlgN) frame_initialize_columnscolumns_initialize_colspace col_spacerTrUrV_initialize_formatters formatters_initialize_justifyrHrX_initialize_sparsifyrshow_index_namesdecimal bold_rowsescaperZr[rr_calc_max_cols_fittedmax_cols_fitted_calc_max_rows_fittedmax_rows_fittedtr_framer{r5r`ra)rcrrrrTrUrVrrHrXr index_namesrZr[rrrrrs rdreDataFrameFormatter.__init__s* //8 229=   55jA//8 (11(; + "    .#99;#99;   **,rgcUR5nUR(a-URUR5nUR SU5 U$)z@ Render a DataFrame to a list of columns (as lists of strings). r)_get_strcols_without_indexrU_get_formatted_indexrr)rcstrcols str_indexs rd get_strcolsDataFrameFormatter.get_strcolss@113 ::11$--@I NN1i (rgcpURSL=(d" URS:H=(a UR$)NTr{)r is_truncatedrs rdshould_show_dimensions)DataFrameFormatter.should_show_dimensionss3##t+  J . D43D3D rgcR[UR=(d UR5$r)ris_truncated_horizontallyrqrs rdrDataFrameFormatter.is_truncatedsD22Rd6R6RSSrgc~[UR=(a" [UR5UR:5$r)rrrkrrs rdr,DataFrameFormatter.is_truncated_horizontallys,D((Wc$,,.?$BVBV.VXXrgc~[UR=(a" [UR5UR:5$r)rrrkrrs rdrq*DataFrameFormatter.is_truncated_verticallys+D((Uc$**o@T@T.TVVrgctS[UR5S[URR5S3$)Nz [z rows x z columns])rkrrrs rddimensions_info"DataFrameFormatter.dimensions_infos0s4::'xDJJ4F4F0G/H RRrgc@[URR5$r)rrrUrs rdhas_index_names"DataFrameFormatter.has_index_namess$****++rgc@[URR5$r)rrrrs rdhas_column_names#DataFrameFormatter.has_column_namess$**,,--rgcZ[URURUR45$r)allrrUrrs rdshow_row_idx_names%DataFrameFormatter.show_row_idx_namess$D(($**d6K6KLMMrgcZ[URURUR45$r)rrrrTrs rdshow_col_idx_names%DataFrameFormatter.show_col_idx_namess$D))4+@+@$++NOOrgc[UR=(d [UR5[UR55$r)rmrZrkrrs rdmax_rows_displayed%DataFrameFormatter.max_rows_displayed s(4==3C OS_EErgc"Uc [S5$U$)Nzdisplay.multi_sparser)rcrs rdr'DataFrameFormatter._initialize_sparsifys  45 5rgcUc0$[URR5[U5:Xd[U[5(aU$[ S[U5S[URR5S35e)NzFormatters length(+) should match DataFrame number of columns(r)rkrrr|dict ValueError)rcrs rdr)DataFrameFormatter._initialize_formatterssx  I ## $J 7:jRV;W;W $S_$56//24::3E3E/F.GqJ rgc"Uc [S5$U$)Nzdisplay.colheader_justifyr )rcrHs rdr&DataFrameFormatter._initialize_justify s ?9: :NrgcvUb![U5nURUUlU$URR$r)r/rr)rcrcolss rdr&DataFrameFormatter._initialize_columns&s7  (DD)DJK::%% %rgcUc0nU$[U[[45(a<SU0nURURR Vs0sHo3U_M sn5 U$[U[ 5(aJUR5H2nX0RR ;dMUS:wdM&[SU35e UnU$[URR 5[U5:wa8[S[U5S[URR 5S35e[[URR U55nU$s snf)Nruz,Col_space is defined for an unknown column: zCol_space length(rr) r|rlrupdaterrrkeysrrkrzip)rcrrcolumns rdr'DataFrameFormatter._initialize_colspace.s>  F$ # C: . .)_F MM4::;M;MN;M9,;MN O  7 + +#..*!3!33" $FvhO+ F 4::%%&#i.8 'I'78336tzz7I7I3J2K1N#djj00)<=F Os E cUR5(d UR$[5upURU5(aU$UR$)z%Number of columns fitting the screen.)_is_in_terminalrr _is_screen_narrow)rcrrs rdr(DataFrameFormatter._calc_max_cols_fittedFsE##%%== $&  ! !% ( (L== rgcUR5(aT[5upURS:XaX R5- $UR U5(aUnOURnO URnUR U5$)z,Number of rows with data fitting the screen.r)rr rZ_get_number_of_auxiliary_rows_is_screen_short_adjust_max_rows)rcrrrZs rdr(DataFrameFormatter._calc_max_rows_fittedQst    ! !)+IA}}! B B DDD$$V,,!==}}H$$X..rgcU(a@[UR5U:a'UR(a[URU5nU$)zAdjust max_rows using display logic. See description here: https://pandas.pydata.org/docs/dev/user_guide/options.html#frequently-used-options GH #37359 )rkrr[rm)rcrZs rdr%#DataFrameFormatter._adjust_max_rowsds2 DJJ(* t}}h7rgc^[URS:H=(d URS:H5$)z/Check if the output is to be shown in terminal.r)rrrZrs rdr"DataFrameFormatter._is_in_terminalrs$DMMQ&<$--1*<==rgc[URS:H=(a" [URR5U:5$Nr)rrrkrr)rc max_widths rdr $DataFrameFormatter._is_screen_narrowvs/DMMQ&N3tzz/A/A+BY+NOOrgcp[URS:H=(a [UR5U:5$r,)rrZrkr)rc max_heights rdr$#DataFrameFormatter._is_screen_shortys(DMMQ&G3tzz?Z+GHHrgcSnSnX-nUR(a&U[URR55- nUR(aUS- nU$)z?Get number of rows occupied by prompt, dots and dimension info.ri)rrkr splitlinesrT)rcdot_row prompt_rownum_rowss rdr#0DataFrameFormatter._get_number_of_auxiliary_rows|sP '    D00;;=> >H ;; MHrgcUR(aUR5 UR(aUR5 gg)zI Check whether the frame should be truncated. If so, slice the frame up. N)r_truncate_horizontallyrq_truncate_verticallyrs rdr{DataFrameFormatter.truncates3  ) )  ' ' )  ' '  % % ' (rgc URceURS-nUS:aURRSS2SU24nURRSS2U*S24n[X#4SS9Ul[ UR [ [45(a&/UR SUQUR U*SQUlO>[[UR5nURRSS2SU24UlXl g)zRemove columns, which are not to be displayed and adjust formatters. Attributes affected: - tr_frame - formatters - tr_col_num Nrjriaxis) rrrnr2r|rlisttuplerrlr tr_col_num)rccol_numrErFs rdr9)DataFrameFormatter._truncate_horizontallys##///&&!+ a<==%%a'k2DMM&&q7()|4E"D=q9DM$//D%=99#__Xg.#__gXY/# 3 .G MM..q(7({;DM!rgcURceURS-nUS:aw[UR5n[R"[R "U5[R "X!- U5/5nURR UUlO>[[UR5nURR SU2SS24UlXl g)zbRemove rows, which are not to be displayed. Attributes affected: - tr_frame - tr_row_num Nrjri) rrkrnphstackarangernrrlrZro)rcrr_len_slices rdr:'DataFrameFormatter._truncate_verticallys##///&&!+ a<t}}%DYY ' 2BIIdnd4STUF MM..v6DM3 .G MM..xx{;DM!rgc 8^/n[TR5(dTR(d[TR5Hjup#TR U5n[ UTR [TRRUS55TRS9nURU5 Ml U$[TR5(a[[[TR5Tl[TR5[TR 5:wa8[#S[TR 5S[TR5S35eTRVs/sHoU/PM nnOTR%TR5nTR&(aUHnURS5 M [TR5Hup#Xbn[)[TRRUS55/U4SjU5Q76n TR U5n[ UTR U TRS9n[)/U4S jU5QU P76n TRR XTR S 9nURX-5 M U$s snf) Nr)stringsrHminimumrazWriting z cols but got z aliasesruc3Z># UH nTRRU5v M" g7frrark.0xrcs rd @DataFrameFormatter._get_strcols_without_index..s0R'Qa'(+)rMrac3Z># UH nTRRU5v M" g7frrOrPs rdrSrTs@ZDHHLLOOZrUr)rrT enumerater format_col_make_fixed_widthrHrlrgetraappendrr?rrkrr_get_formatted_column_labelsrmax) rcricrlabel str_columnsrRcheaderheader_colwidthmax_lens ` rdr-DataFrameFormatter._get_strcols_without_indexs#%DKK((!$--0!__Q/ .& LL 2 21a 89  z*1N  $ $tCy$++6DK4;;3t||#44 s4<<012"4;;/0:15 < u7 K.s%T^E&7&7^cT>UTR;aTU(a T(dSU-$U$)N )r)rRy need_leadsprestrict_formattingrcs rd space_formatEDataFrameFormatter._get_formatted_column_labels..space_formats'T__,#A/7Nrgc3^># UHoVs/sH nT"X5PM snv M gs snf7frr)rQrRrvrys rdrSrr s(K{!151a|A)15{5s -(-rru)pandas.core.indexes.multirnrr|r-rr?rrdtypesranylevelsrmaprrrkrrWrh) rcrrnr fmt_columnsr}str_columns_tuplerRrar^rwrxrys ` @@@rdr\/DataFrameFormatter._get_formatted_column_labelss=-- gz * *!//e/TKsK01KZZ&&..F#&%TW^^%T"T s;4Df0MNOK !%K{KL! }}%6!7!7$34E$F!,/1B,CD,Cq47,CKD"..E.BKZZ&&Fs;4Df0MNOK&k22DA!% 3 3A 6 6;q>qqQ2  E s F*14F/c FURR5VVs0sHup#U[[U5_M nnnURnUR nUR S5n[U[5(a&URURURUS9nOURURUS9/nUV s/sH;n [[[U 5SUR!SS5UR"S95PM= nn UR"R$"S/UQ76R'S 5n UR((a*UR+5V s/sHn [-U 5PM n n OS/UR.-n UR0(aX-$U $s snnfs sn fs sn f) N __index__)rrri)rrirErur)rHrMrariry)ritemsrrlrUrrhr|r-rrrrr@rYr?rZrarrr_get_column_name_listrnlevelsrT) rcrkvrrUrfmtrrRadjoined col_headers rdr'DataFrameFormatter._get_formatted_index1s261E1E1GH1GQS! _1G H --!!+. eZ ( (++"55,I""0G0GSV"WI   !GVY]]2q5Itxx    88??11y177=  " "*.*D*D*FG*FQ#a&*FJGJ/J ;;( (OII  HsFAFFc/nURRn[U[5(a$UR SUR 55 U$UR URcSO UR5 U$)Nc3.# UH ocSOUv M g7f)Nrur)rQrWs rdrS;DataFrameFormatter._get_column_name_list..^sP-$|5-sru)rrr|r-extendnamesr[rW)rcrrs rdr(DataFrameFormatter._get_column_name_listZsb "**$$ gz * * LLP'--P P  LLw||3 F rg)rarrrrrrXrrrTrUrHrrrZrr[rVrrrrArro)NNTTrRNNNNTNNNF.FT)&rrBr Axes | NonerColspaceArgType | NonerTzbool | SequenceNotStr[str]rUrrVrrFormattersType | NonerHrrXFloatFormatType | Noner bool | NonerrrZrr[rrrrrrrrrrrrr)rlist[list[str]]rrr)rrl)rrrr)rrrr=)rHrrr)rrrr,)rrrr9)rr)rZrrrr)r^rlrr)r^ str | intrCallable | None)rrBrr)rrBrr)rzlist[Hashable])*rrrrrrDrNrerpropertyrrrrqrrrrrr rrrrrrrr%rr r$r#r{r9r:rrXrhr\rrrrrgrdrrss !gbG "222G $,0-1,0"/3 $ ###&+'------* -- + --  ----*----------------- $!--"#--$%--&'--( )--^   TTYYWWSS,,..NNPPFF /    &0 !/& >PI ("4"$-^   0'R'Rrgrc\rSrSrSrS SjrS S SjjrS S SjjrSSSjjrSr g)DataFrameRendereridaClass 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. cXlgrr)rcrs rdreDataFrameRenderer.__init__usrgNcSSKJnJn U(aU OUn U "URUUUUS9n U R 5n [ XUS9$)u 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)classesbordertable_id render_linksr_encoding)pandas.io.formats.htmlrrrrsave_to_buffer) rcr_rrnotebookrrrrrKlasshtml_formatterstrings rdto_htmlDataFrameRenderer.to_htmlxsND &.!= HH%   ))+fAArgcdSSKJn U"URUS9nUR5n[ XaUS9$)u Render a DataFrame to a console-friendly tabular output. Parameters ---------- buf : str, path object, file-like object, or None, default None String, path object (implementing ``os.PathLike[str]``), or file-like object implementing a string ``write()`` function. If None, the result is returned as a string. encoding: str, default “utf-8” Set character encoding. line_width : int, optional Width to wrap a line in characters. r)StringFormatter)rr)pandas.io.formats.stringrrrr)rcr_rrrstring_formatterrs rdrDataFrameRenderer.to_strings3( =*488 K!++-fAArgcZSSKJn Uc Sn[5nOSnU"S0SU_SU _SU_S U_S U_S U_S U_S U_SU_SU_SU _SU _SU _SU _SU_SU_SUR_6nUR 5 U(a9[ U[5(deUR 5nUR5 U$g)z+ Render dataframe as comma-separated file. r) CSVFormatterNTF path_or_buflineterminatorseprerrors compressionquotingr index_labelr chunksize quotechar date_format doublequote escapecharstorage_optionsrir)pandas.io.formats.csvsrr rsaver|getvalueclose)rcrrrrrrrrrrrrrrrrrcreated_buffer csv_formattercontents rdto_csvDataFrameRenderer.to_csvs, 8  !N"*K"N$ # )      $    $      $ $ " ,! "hh# &  k844 44!**,G    Nrgr)rrrr)NNNFNNF)r_"FilePath | WriteBuffer[str] | Nonerrrzstr | list | tuple | Nonerrrzint | bool | Nonerrrrrr)NNN)r_rrrrrrr)NN,NNwinferN"NNNTNstrictN)"rz7FilePath | WriteBuffer[bytes] | WriteBuffer[str] | NonerrrrrzSequence[Hashable] | NonerzIndexLabel | Nonerrrr:rrrrrrrrrrrrrrrrrzStorageOptions | Nonerr) rrrrrrerrrrrrgrdrrds  37#-1$(#"1B /1B1B+ 1B  1B " 1B1B1B 1Bj37#!% B /BB B  B8PT#-1)-*1"%) $"& !%15#9L99 9 + 9 ' 99(999#99 999 !9"/#9$ %99rgrc[XS9nURU5 UcUR5sSSS5 $SSS5 g!,(df  g=f)zI Perform serialization. Write to buf or return as string if buf is None. )rN) _get_bufferwriter)rr_rfds rdrrsA S ,  ;;;= - ,  - , ,s$AA Ac#r# Ub [U5nO [5nUcSnO [U[5(d [ S5e[ US5(aUv g[U[5(a.[ [U55 [USUSS9nUv SSS5 g[S5e!,(df  g=f7f) zt 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.rrru)rnewlinez1buf is not a file name and it has no write method) r4r r|rrhasattrr3open TypeError)r_rfs rdrrs S!j S ! !LMMsG C  s3x( #sXr :a G ; :KLL; :sB B7 B&B7& B40B7c [R"URS5(a[n [ [ U5nO[ UR[5(a[n [ [ U5nO[R"URS5(a[n [ [U5nO[ UR[5(a[n O`[R"URS5(a[n O3[R"URS5(a[n O[n UcSnUc [!S5nUc [!S5nU "UUUUUUUUUU U S9 n U R#5$) a= Format an array for printing. Parameters ---------- values : np.ndarray or ExtensionArray formatter float_format na_rep digits space justify decimal leading_space : bool, optional, default True Whether the array should be formatted with a leading space. When an array as a column of a Series or DataFrame, we do want the leading space to pad between columns. When formatting an Index subclass (e.g. IntervalIndex._get_values_for_csv), we don't want the leading space since it should be left-aligned. fallback_formatter Returns ------- List[str] Mmfciu r]display.precision) digitsrVrXrirgrHrrrfallback_formatter)r is_np_dtyperY_Datetime64Formatterrr'r|r"_Datetime64TZFormatter_Timedelta64Formatterr)r#_ExtensionArrayFormatterFloatArrayFormatter_IntArrayFormatter_GenericArrayFormatterr get_result) valuesrirXrVrrgrHrrrr fmt_klassfmt_objs rdrr7s)R v||S))( mV, FLL/ 2 2* mV, s + +) nf- FLL. 1 1, t , ,' t , ,& *  }!"89  ~/0!#- G    rgc~\rSrSrSSSjjrS SjrS SjrSrg) riNc XlX lX@lXPlX0lX`lXplXlXlXl Xl Xl gr) rrrVrgrirXrHrr fixed_widthrr) rcrrrirVrgrXrHrrrrrs rdre_GenericArrayFormatter.__init__sD    "(   &*"4rgcLUR5n[XR5$r)_format_stringsrYrH)rcrs rdr!_GenericArrayFormatter.get_results))+  \\::rgc "^^ ^ TRc [S5nUc[S5m U 4SjnO TRnTRb TRm O[TRb TRm OATRSL=(a TR[ :gn[ [RSUS9m U U4SjnTRn[U[R5(d [S5e[R"U[ 5nU[R""[%U5['[)S[+UR,555S 9-nTR.nUcUR15n/n[3U5HupXi(a TRb#U(aUR5S U"U 535 M>Xi(aUR5U"U 55 M`US LaS n OS n UR5U R7U"U 5S95 M U$)Nr]rc(>[USTSS35$)Nz .dr)_trim_zeros_single_float)rR precisions rd8_GenericArrayFormatter._format_strings..s)AIa=)**rgrv)rz quote_stringscD>TRb[U5(a[U5(aUcgU[La[ [5$[ R "U5(a&[R"U5(a [ U5$U[Ld/[U[R[R45(agTR$[U[5(a [ U5$[U[5(a [U5$[ T"U55$)Nrr)rVr r$rrrrrEisinfrr| datetime64 timedelta64r+r*repr)rRrircs rd_format7_GenericArrayFormatter._format_strings.._formats{{&9Q<> %I  $ $ 0//I LL4S9SM%%/+I  )*{{$ ++O ==x0 ffU4[uU1c$**o-F'GH I  **  )--/M dODA!$(B !!Agaj\"23!!!,q/2 E) C C!!#**wqz*":;$rg) rrrrrXrirHrrVrrgr) NrRrNrFrNTTN)rr6rrlrirrVrrgrrXrrHrrrrrrrrrrrrrr)rrrrrerrrrrgrdrrs%)/3" %).2555# 5  5  5-55555#5,5 58;Jrgrc\^\rSrSrSU4SjjrSS SjjrS SjrS SjrSrU=r $) ric>[TU]"U0UD6 URbIURc;SUl[ UR5(aURUlSUlggggNF)superrerXrircallable)rcargskwargs __class__s rdreFloatArrayFormatter.__init__sh $)&)    (T^^-C$D ))**!%!2!2$(!+.D (rgc^^^^^Tc TRmT(aUU4SjmOU4SjmTRS:waUU4SjmOTmTcT$UUU4SjnU$)z;Returns a function to be applied on each value to format itcR>Tce[U5(aT"US9$TR$)N)value)r%rV)rrXrcs rdbase_formatter.base_formatters7#/// Qxx!q)rgcR>[U5(a [U5$TR$r)r%rrV)rrcs rdr%r&&s!&qs1v:t{{:rgrcJ>T"U5RSTRS5$)Nrri)replacer)rr%rcs rddecimal_formatter?FloatArrayFormatter._value_formatter..decimal_formatter+s!%a(00dllAFFrgcz>[U5(a[U5T:aT"U5$T"S5$TR$)Ng)r%absrV)r$r*rc thresholds rdri7FloatArrayFormatter._value_formatter..formatter4s8U||u: ),U33,S11{{"rg)rXr)rcrXr.rir%r*s``` @@rd_value_formatter$FloatArrayFormatter._value_formattersZ  ,,L   ; <<3  G!/   $ $ #rgc^^ ^ ^ SSjm SSjm TRb(T "TRTRTR5$TR(a [ S5m OSm U U UU 4SjnTR cQTR(a3TR SLaSnOSn[URTRS 9nOTR nOU4S jnU"U5nTR(dU$[U5S :a%[S U55nUTRS -:nOSn[R"TR5nUS:R5nUSTR*-:US :-R5n U (dU(aAU(a:TR SLaSnOSn[URTRS 9nU"U5nU$)zp Returns the float values converted into strings using the parameters given at initialisation, as a numpy array c [U5n[R"[UR 5UR 55VVs/sHupEU(dU"U5OUPM snn5R UR 5nU$s snnfr)r$rEarrayrravelreshaper)rrirVmaskvalr formatteds rdformat_with_na_repCFloatArrayFormatter.get_result_as_array..format_with_na_repEsv.format_complex_with_na_repOsF''&///1K''&///1K#' #4d;6GyM=@  >9x'w!((38 !((Ih,?+@&)KL %.x%8%>%>%@N%0055%,,x7Gq-IJ%,,xq8H-JK!((F81VHA)>?'>(88M*226<<@ @rgNzdisplay.chop_thresholdc>TRUT 5nTRS:XaSTR-O TRnTRn[ U5nU(a T"X1U5nO T"X1U5nTR (aIU(a[ UTR5nO[UTR5n[R"USS9$U$)NrEruobjectrY) r0rHrVrrr_trim_zeros_complexr_trim_zeros_floatrEasarray) rXrirVr is_complexrrNr:rcr.s rdformat_values_withCFloatArrayFormatter.get_result_as_array..format_values_withus--lIFI+/,,&*@S4;;&dkkF[[F)&1J3FvN+FvF0FF.vt||DFzz&99MrgTz{value: .{digits:d}f}z{value:.{digits:d}f})rc">TRU-$r)rX)r$rcs rdr9FloatArrayFormatter.get_result_as_array..s):):U)Brgrc38# UHn[U5v M g7frrkrQrRs rdrS:FloatArrayFormatter.get_result_as_array..s:)9AQ)9rsFg.A z{value: .{digits:d}e}z{value:.{digits:d}e})rr6rirrVr)rirrVrrrXrr rrrkr]rEr-r~) rcrWfmt_strrXformatted_valuesmaxlentoo_longabs_valshas_large_valueshas_small_valuesrNr:r.s ` @@@rdget_result_as_array'FloatArrayFormatter.get_result_as_array?s   A A*2 A> %%dkk4>>4;;O O   "#;>$++FL1,? rgc4[UR55$r)r?rhrs rdr#FloatArrayFormatter._format_stringssD,,.//rg)rrXrirNN)rXrr.z float | Nonerr)rz np.ndarrayr) rrrrrer0rhrr __classcell__r s@rdrrsC )04"&6,6 6  6p~ @00rgrc\rSrSrSSjrSrg)ricURSLaSnOSnUR=(d UnURVs/sH o2"U5PM nnU$s snf)NFc$USRUS9$)NrrRrrrs rdr4_IntArrayFormatter._format_strings..s1ooo&:rgc$USRUS9$)Nz drrrsrrs rdrrts2&6&6&6&;rg)rrir)rc formatter_strrirRrs rdr"_IntArrayFormatter._format_stringssO    &:M;MNN3m ,0KK8KqilK 89sArNr)rrrrrrrrgrdrrsrgrcX^\rSrSr%S\S'SSU4SjjjrS SjrSrU=r$) rir'rc @>[TU]"U40UD6 X lX0lgr)rrenat_repr)rcrrzrrr s rdre_Datetime64Formatter.__init__s" *6* &rgcURnURb!UVs/sHo RU5PM sn$URURURS9nUR 5$s snf)z&we by definition have DO NOT have a TZ)rVr)rri_format_native_typesrzrtolist)rcrrRrs rdr$_Datetime64Formatter._format_stringssk >> %/56v!NN1%v6 600<  fk * *//1EJJvV4E!  **;;;;**LLLL,,LL1  rgrNrrrrrrrrrrgrdrrs rgrct[R"U5n[U5(a<[R"US:5(a[R"US:*5(d [ S5eSU-n[ U5nUR U5R[5n[R"X 5n[R"U5(a*UR[5nUVs/sHoUS-PM sn$[R"U5n[ U5n[R"U[S9nXR 5R[5R[5XC'X)R U5R[5XC)'UVs/sHoUS-PM sn$s snfs snf)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%'] rriz/percentiles should all be in the interval [0,1]d%rR)rErUrrr get_precisionroundastyperliscloserunique empty_likerQ) percentilesprecpercentiles_round_typeint_idxoutr^ unique_pctss rdformat_percentilesr s]D**[)K [ ) )vvkQ&''vvkQ&''JKK #K  %D(..t4;;C@jj/=G vvg$++C0!$%AC%%))K(K  %D -- 6 2C'--/66s;BB3GCL)//5<D t9D HHRXXbffTl+ , 3 3C 8 8D q$[UTTS9$)N)rzr)r)rRrrzs rdr'get_format_datetime64..rs4 wK rgc>[UTS9$)Nrz)rrs rdrrvs +Aw?rgr) is_dates_onlyrzrs ``rdget_format_datetime64rks   @?rgc*\rSrSr%S\S'SSjrSrg)riyr'rcURRnURR[5nUR=(d [ XR S9nUVs/sH oC"U5PM nnU$s snf)zwe by definition have a TZ)r)r_is_dates_onlyrrQrirr)rcidorrirRrs rdr&_Datetime64TZFormatter._format_strings|sikk((##F+NN &; --' -33FqilF 34s A5rNrrrrgrdrrys  rgrcR^\rSrSr%S\S'SSU4SjjjrS SjrSrU=r$) rir)rc 4>[TU]"U40UD6 X lgr)rrerz)rcrrzrr s rdre_Timedelta64Formatter.__init__s *6* rgcUR=(d [URURSS9nURVs/sH o!"U5PM sn$s snf)NF)rzbox)riget_format_timedelta64rrz)rcrirRs rdr%_Timedelta64Formatter._format_stringssINN &< KK5' '+kk2k ! k222sArr)rr)rzrrrrrrns@rdrrs>    33rgrcL^^^URnU(aSmOSmUUU4SjnU$)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 Nlongc>Ub [U5(a[U5(aT$[U[5(d [U5nUR TS9nT(aSUS3nU$)Nrs')r r$r|r _repr_base)rRrrrrzs rdr*get_format_timedelta64.._formattersZ 91$q''N!Y''! AV, ]F rg)r)rrzr even_daysrrs `` @rdrrs*%%I  rgcR^^^ [U5S:XdUS:XaU$Uc[R"5mOUm[U4SjU55m Ub [UT 5m [ S5mTbT T:aTm SUUU 4SjjnUVs/sH oT"U5PM nnTR UT US9nU$s snf)Nrrc3F># UHnTRU5v M g7frr\)rQrR adjustments rdrS$_make_fixed_width..s5W*..##Ws!rcb>Tb*TS:TRU5T:-(a USTS- S-nU$)Nrrr\)rRrconf_maxrds rdjust_make_fixed_width..justs=  1 !2W!<=m! $u,rgr)rRrrr)rkr5r`r]rrH) rLrHrMrarrRrrrrds @@@rdrYrYs  7|qGu, {,,.  5W55Ggw'01H( 2 !((1tAwG(   w  ?F M)s>B$c//p2UH`n[R"SU5nURSRUSS55 URSRUSS55 Mb [ U5n[ X#-U5n[ U5S:Xa/$[ SU55S- n[USUXvS5V V s/sHupU U S-U SSS U3-S -PM n n n U $s sn n f) z} Separates the real and imaginary parts from the complex number, and executes the _trim_zeros_float method on each of those. z([j+-])ruNrc38# UHn[U5v M g7frr\)rQparts rdrS&_trim_zeros_complex..s;ldD lrsri>r>)rerr[rrkrTr]r) str_complexesr real_part imag_partrRtrimmedn padded_parts padded_lengthreal_ptimag_ptpaddeds rdrSrSs ry  ((:q)"./B01 MA$Y%:GDL <A ;l;;a?M !$L!$4l26F G  !H G  !*  QR[=/) * ,  !H   Ms="C$c^URS5nURS5(aUS- nU$)zL Trims trailing zeros after a decimal point, leaving just one if necessary. 0r)rstripendswith) str_floats rdrrs5   %I#S rgcj^^Un[R"SUS35mSU4SjjmS U4SjjnU"U5(a3UVs/sHnT"U5(aUSSOUPM nnU"U5(aM3UVs/sH-nT"U5(aURU5(aUS-OUPM/ nnU$s snfs snf) zy 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]*$c6>[R"TU5SL$r)rmatch)rR number_regexs rdis_number_with_decimal1_trim_zeros_float..is_number_with_decimalsxx a(44rgc>UVs/sHnT"U5(dMUPM nn[U5S:=(a [SU55$s snf)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. rc3B# UHoRS5v M g7f)rN)rr]s rdrS9_trim_zeros_float..should_trim..$s'IA 3)rkr)rrRnumbersrs rd should_trim&_trim_zeros_float..should_trimsF%Bf(>q(A1fB7|aIC'I'I$IICs A A Nrrr)rArrayLike | list[str]rr)rcompiler) str_floatsrrrrRrrrs @@rdrTrT sG::!27)7CDL5 J g  GNOw!3A661Sb6A=wO g   A*!,,G1D1DC!K  MPs B+34B0c[U[5(a[R"UR6$UR SL$r)r|r-com any_not_nonerrW)rUs rdrr1s3%$$--zz%%rgc\rSrSrSr0SS_SS_SS_S S _S S _S S_SS_SS_SS_SS_SS_SS_SS_SS_SS _S!S"_S#S$_rS)S*S&jjrS+S'jrS(rg%), EngFormatteri8z` Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter irviziairipiriurrrurrr_r GrTPEZYNcXlX lgraccuracyuse_eng_prefix)rcr r s rdreEngFormatter.__init__Ts! ,rgc[[U55n[R"U5(ag[R"U5(agSnUS:aSnU*nUS:wa=[[ [ R "UR5S- 5S-55nO [S5nUR[URR555nUR[URR555n[ U5nUR(aURUnOUS:aSU*S3nOS US3nX2-S U-- nURcS nOS URS S3nURXvS9n U $)aq 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 rRinfrirrrzE-02dzE+r`z{mant: g}{prefix}z{mant: .rz f}{prefix})mantprefix)r ris_nan is_infiniterlmathrrrmr] ENG_PREFIXESrr r r) rcnumdnumsignpow10 int_pow10rr format_strr9s rd__call__EngFormatter.__call__Zsa(s3x  >>$     t $ $ !8D5D 19C 4::>> df = pd.DataFrame([1e-9, 1e-3, 1, 1e3, 1e6]) >>> df 0 0 1.000000e-09 1 1.000000e-03 2 1.000000e+00 3 1.000000e+03 4 1.000000e+06 >>> pd.set_eng_float_format(accuracy=1) >>> df 0 0 1.0E-09 1 1.0E-03 2 1.0E+00 3 1.0E+03 4 1.0E+06 >>> pd.set_eng_float_format(use_eng_prefix=True) >>> df 0 0 1.000n 1 1.000m 2 1.000 3 1.000k 4 1.000M >>> pd.set_eng_float_format(accuracy=1, use_eng_prefix=True) >>> df 0 0 1.0n 1 1.0m 2 1.0 3 1.0k 4 1.0M >>> pd.set_option("display.float_format", None) # unset option r]N)rrr s rdset_eng_float_formatr sn%|H'MNrgc [U5S:Xa/$S/[US5-n/nUHXnSn0n[U5H!upxX'(aX:XaMSX''Xu- Xe'UnM# [U5U- Xe'URU5 MZ U$)am 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)rkrWr[) rsentinelcontrolrrq last_indexlengthsr^keys rdget_level_lengthsr's$ 6{a fs6!9~%G F &FAzco" &'n# '"%j:5 g Mrgc[SU55(aUVs/sHn[U5PM nnURSRU55 gs snf)zq Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. c3B# UHn[U[5v M g7fr)r|rr]s rdrS#buffer_put_lines..s -u!:a  urryN)r~rrr)r_linesrRs rdbuffer_put_linesr,sG -u ---!&'AQ'IIdii(sA)rzdict[str, Any]rl)rrr_rrrrrr)r_rrrrzIGenerator[WriteBuffer[str], None, None] | Generator[StringIO, None, None]) NrRNNrFrTNN)rr6rirrXrrVrrrrgzstr | int | NonerHrrrrrrrrrrr)rnp.ndarray | Sequence[float]rr)r4r-rrlr)rRNaTType | Timestamprzrrrr)rRr.rzrrrrr)rrrzrrrrr)rF)rr)rzz str | floatrrrr)rFNN) rLrrHrrMrrazprinting._TextAdjustment | Nonerr)r)rr6rrrr)rrrr)rrrrrr)rUr,rr)rF)r rlr rrr)ru)rrr"zbool | object | strrzlist[dict[int, int]])r_zWriteBuffer[str]r+rrr)r __future__rcollections.abcrrrr contextlibrcsvr rr functoolsr ior rrshutilr typingrrrrrnumpyrEpandas._config.configrr pandas._libsrpandas._libs.missingrpandas._libs.tslibsrrrpandas._libs.tslibs.nattyperpandas.core.dtypes.commonrrrrrr pandas.core.dtypes.dtypesr!r"r#pandas.core.dtypes.missingr$r%pandas.core.arraysr&r'r(r)pandas.core.arrays.string_r*pandas.core.baser+pandas.core.commoncorecommonrpandas.core.indexes.apir,r-r.r/pandas.core.indexes.datetimesr0pandas.core.indexes.timedeltasr1pandas.core.reshape.concatr2pandas.io.commonr3r4rr5pandas._typingr6r7r8r9r:r;r<r=r>r?r@rApandasrBrCrDrVALID_JUSTIFY_PARAMETERSrNrPrrrrrrrrrrrrrrrrrrrrrYrSrrTrrr r'r,rrgrdrNs# & $ # 0   3)  89-'     6%6p %_$_$DB>BBJZZ~/3    +    DHM +M7AMNMMP,0"!%*.R R R )R   R  R  R R R R R (R R jkk\F00F0R/#1#65B<".<"<"~"       JN @ @"% @