x\c @sdZddlmZddlmZddlZddlmZddl m Z ddl m Z m Z mZmZddlmZmZmZmZmZdd lmZmZmZmZmZmZmZmZmZm Z m!Z!m"Z"dd l#m$Z$m%Z%m&Z&m'Z'dd l(m)Z)m*Z*dd l+m,Z,dd l-m.Z.ddl/j0j1Z2ddl3m4Z4m5Z5ddl6m7Z7m8Z8ddl9m:Z:ddl;m<Z<m=Z=ddl>m?Z?m@Z@mAZAddlBmCZCdZDdddddddddddf ZEd ZFd!eGfd"YZHd#eGfd$YZId%eGfd&YZJd'eJfd(YZKd)ZLd*eGfd+YZMd,eMfd-YZNeOd.eOeOdd/eOd0ZPd1eGfd2YZQd3eQfd4YZRd5eQfd6YZSd7eQfd8YZTd9eQfd:YZUd;ZVd<ZWeOd=d>ZXd=eOd?ZYd=eOd@ZZdAZ[dBeTfdCYZ\dDeQfdEYZ]d=e^dFZ_deOeOdGZ`d.dHZadIZbdJeGfdKYZcdLe^dMZddNZedOdPZfdQZgdS(Rs{ Internal module for formatting output data in csv, html, and latex files. This module also applies to display formatting. i(tprint_function(tpartialN(tlib(tformat_array_from_datetime(tNaTt Timedeltat TimestamptiNaT(tStringIOtlziptmaptutzip( tis_categorical_dtypetis_datetime64_dtypetis_datetime64tz_dtypetis_extension_array_dtypetis_floattis_float_dtypet is_integertis_integer_dtypet is_list_liketis_numeric_dtypet is_scalartis_timedelta64_dtype(t ABCIndexClasst ABCMultiIndext ABCSeriestABCSparseArray(tisnatnotna(tcompat(t PandasObject(t get_optiont set_option(tIndext ensure_index(t DatetimeIndex(t _expand_usert_stringify_path(tadjointjustifyt pprint_thing(tget_terminal_sizes Parameters ---------- buf : StringIO-like, optional Buffer to write to. columns : sequence, optional, default None The subset of columns to write. Writes all columns by default. col_space : int, optional The minimum width of each column. header : bool, 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 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 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. The result of this function must be a unicode string. 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. .. versionadded:: 0.18.0 tlefttrighttcenterR)s justify-alltstarttendtinherits match-parenttinitialtunsets Returns ------- str (or unicode, depending on data and options) String representation of the dataframe. tCategoricalFormattercBs8eZdededZdZdZdZRS(tNaNcCsO||_|dk r|nttd|_||_||_||_dS(Nt(t categoricaltNoneRR tbuftna_reptlengthtfooter(tselfR7R9R;R:R<((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt__init__os  '  cCs}d}|jrD|r"|d7}n|djdt|j7}n|jj}|rf|d7}n||7}tj|S(NR6s, sLength: {length}R;s (R;tformattlenR7t_repr_categories_infoRt text_type(R=R<t level_info((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt _get_footerws  "  cCs%t|jjdddd|jS(Nt float_formatR:(t format_arrayR7t get_valuesR8R:(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_get_formatted_valuesscCs |j}t|dkr;|jr.|jStdSn|j}g|D]}tdjd|^qN}g|D]}|j^qy}tdj|}td|tdg}|jr|j}|r|j |qnt j tdj|S( NiR6s{i}tis, t[t]s ( R7R@R<RDR RHR?tstriptjointappendRRB(R=R7t fmt_valuesRItresultR<((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt to_strings     +  N(t__name__t __module__R8tTrueR>RDRHRQ(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR4ms     tSeriesFormatterc BsYeZdeeedededd ZdZdZdZdZ dZ RS(R5c Cs||_|dk r|nt|_||_||_||_||_||_| |_ |dkrxt d}n||_ | |_ t |_|jdS(Nsdisplay.float_format(tseriesR8RR9tnameR:theaderR;tindextmax_rowsR!REtdtypet_get_adjustmenttadjt _chk_truncate( R=RVR9R;RXRYR:RWRER[RZ((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>s           cCsddlm}|j}|o1t|j|k}|j}|r|dkre|}|j| }n+|d}||j| |j| f}||_n||_||_dS(Ni(tconcatii( tpandas.core.reshape.concatR_RZR@RVtiloct tr_row_numt tr_seriest truncate_v(R=R_RZRdRVtrow_num((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR^s       cCs|jj}td}t|jjdddk rX|djd|jjj7}n|jtk r|dk r|r|d7}nt |dd}||dk rd jd |nd7}n|j t ks|j d kr|j r|r|d7}n|d jd t |j7}n|jtk r|jdk rt|jjdd}|r|rn|d7}n|djdt |7}qnt|jjr|jjj}|r|d7}n||7}ntj|S(NR6tfreqs Freq: {freq}s, t escape_charss s s u Name: {sname}tsnamettruncatesLength: {length}R;RWu dtype: {typ}ttyp(s s s (RVRWR tgetattrRYR8R?tfreqstrtFalseR*R;RTRdR@R[RcR t_valuesRARRB(R=RWR<t series_nameRC((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRDs8  "   ( " "  cCsz|jj}t|t}|rOtd|jD}|jdt}n!|jdk }|jdt}||fS(Ncss|] }|VqdS(N((t.0RW((s7lib/python2.7/site-packages/pandas/io/formats/format.pys stnamesRW( RcRYt isinstanceRtanyRqR?RTRWR8(R=RYtis_multit have_headert fmt_index((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_get_formatted_indexs cCs.|jj}t|dd|jd|jS(NRER:(Rct_formatting_valuesRFR8RER:(R=tvalues_to_format((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRHs c Cs|j}|j}t|dkr3d|dS|j\}}|j}|jrd}|j}|jj||d}|dkrd} nd} |jj| g|dd d} |j ||| |j |dd n|j r|jj d|d|g} n|jj d|} |j rO|rO|dd | } n|rf| d |7} nt jtd j| S( Nis Series([], t)iis...s..tmodeR.R6s (RcRDR@RwRHRdRbR]R)tinsertRYR(RXRRBR RM( R=RVR<RvRuROt n_header_rowsRetwidthtdot_strRP((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRQs0        " "N( RRRSR8RTRmR>R^RDRwRHRQ(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRUs     ' tTextAdjustmentcBs/eZdZdZddZdZRS(cCstd|_dS(Nsdisplay.encoding(R!tencoding(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>*scCstj|d|jS(NR(RtstrlenR(R=ttext((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR@-sR-cCst||d|S(NR{(R)(R=ttextstmax_lenR{((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR)0scOs"t|d|jd|j||S(NRtjustfunc(R(R@R)(R=tspacetliststkwargs((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR(3s(RRRSR>R@R)R((((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR(s   tEastAsianTextAdjustmentcBs&eZdZdZddZRS(cCs8tt|jtdr+d|_n d|_dS(Ns!display.unicode.ambiguous_as_wideii(tsuperRR>R!tambiguous_width(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>:s  cCstj|d|jd|jS(NRR(Rteast_asian_lenRR(R=R((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR@AsR-csfd}|dkrDg|D]}|j||^q%S|dkrvg|D]}|j||^qWSg|D]}|j||^q}SdS(Ncsj|t|S(N(R@(tt(RR=(s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_get_padGsR,R.(tljustR.trjust(R=RRR{Rtx((RR=s7lib/python2.7/site-packages/pandas/io/formats/format.pyR)Es  & &(RRRSR>R@R)(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR8s  cCs$td}|rtStSdS(Ns display.unicode.east_asian_width(R!RR(tuse_east_asian_width((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR\Rs tTableFormattercBs,eZeZdZedZdZRS(cCs%|jtkp$|jdko$|jS(NRi(tshow_dimensionsRTt is_truncated(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pytshould_show_dimensions_scCsxt|jttfr6t|r/|j|SdSn>t|ra||jkra|j|}n|jj|dSdS(N(Rrt formatterstlistttupleRR8tcolumnstget(R=RI((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_get_formatterds  N( RRRSRmRR8RtpropertyRR(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRZstDataFrameFormattercBseZdZerendZeee7ZdddeedddddedddeddedZdZ dZ dZ dZ dededed Z d Zdedd Zd Zed ZedZedZedZdZdZRS(s Render a DataFrame self.to_string() : console-friendly tabular output self.to_html() : html table self.to_latex() : LaTeX tabular environment table R6R5t.cKs||_|dk r-tt||_n t|_| |_| dkr]td} n| |_| |_ |dk r|ni|_ ||_ ||_ ||_ ||_||_| |_||_||_t|pt|jt|j|_||_||_||_| dkr5td|_n | |_||_|dk rxt||_|j|j|_n |j|_|jt|_dS(Nsdisplay.multi_sparsesdisplay.colheader_justify( tframeR8R&R'R9Rtshow_index_namesR!tsparsifyRERR:tdecimalt col_spaceRXRYt line_widthRZtmax_colstminR@tmax_rows_displayedRttable_idt render_linksR)tkwdsR$RR^R\R](R=RR9RRRXRYR:RR)RERt index_namesRRZRRRRRR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>}sB                        cCsddlm}|j}|j}|dks:|dkrt\}}||_||_|jdkrd}d}|jrd}n|j|||} |j| } | |_ n|dkrt |j j |kr|}n|dkrt |j |kr|}qnt |ds+||_ nt |dsF||_n|j} |j } | opt |j | k} | ot |j | k} |j }| rP| dkrt |j }n| dkr|jddd|f}|}nU| d }||jddd|f|jdd| dffd d}||_n| r| dkr|}|jd|ddf}nO| d }||jd|ddf|j| dddff}||_n||_| |_| |_|jp|j|_dS( sc Checks whether the frame should be truncated. If so, slices the frame up. i(R_iiit max_rows_adjt max_cols_adjNitaxis(R`R_RRZR+twthRRXRR@RRthasattrRRat tr_col_numRbttr_framet truncate_hRdR(R=R_RRZRRtdot_rowt prompt_rowtshow_dimension_rowst n_add_rowsRRRRdRtcol_numRe((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR^sf        $ !          ,  " &    csj}j|}tj rj rg}xt|D]R\}}j|}t|jdjp{ddj }|j |qEWnjtjr t jt j krt djdt j dt jngjD]}|g^q}nj|}g}xt|D]\}}||} tjpgdfd| D} j|}t|jd| dj }ttfd|D| } j j| | d j} |j | |qBW|} jr*| jd|nj} j}| rrj}| jjd d gt |n|r{t |t |}j}xt| D]\}}j j | ||}t}| r||d k}n|d ks|rd }nd}|dkrd}n|r4d}d}nd}j j|g|d |d}| |j|||qWn| S(sP Render a DataFrame to a list of columns (as lists of strings). tminimumiR]s-Writing {ncols} cols but got {nalias} aliasestncolstnaliasc3s!|]}jj|VqdS(N(R]R@(RpR(R=(s7lib/python2.7/site-packages/pandas/io/formats/format.pys sc3s!|]}jj|VqdS(N(R]R@(RpR(R=(s7lib/python2.7/site-packages/pandas/io/formats/format.pys sR{is ...is...s..R,iR-(RRwRRXt enumeratet _format_colt_make_fixed_widthR)RR]RNR@Rt ValueErrorR?t_get_formatted_column_labelstmaxRYR|RRdRRbRm(R=Rt str_indext stringifiedRItcROtlabelt str_columnstcheadertheader_colwidthRtstrcolsRRdRR}Retixtcoltcwidtht is_dot_coltmy_strtdot_modeR((R=s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_to_str_columnsst   "       '     "cCsddlm}|j}t|jdksCt|jdkrtdjdt|jj dt |jdt |j}|}n|j }|j dkr|jjd|}nt|jt s|jdkr|j|}ne|jjd|jd }||jjj}||j}|d}|g|D]!} || jtj^qO} t| } d} x||dkr | dkr | d7} tt| d } | j| }| |}||d8}| j|} t| } qW| |j}t|d }||_|j|j }|jjd|}|jj||jr|jj d jd t|dt|jndS(sJ Render a DataFrame to a console-friendly tabular output. i(tSeriesis(Empty {name} Columns: {col} Index: {idx}RWRtidxis g@is" [{nrows} rows x {ncols} columns]tnrowsRN(!tpandasRRR@RRYR R?ttypeRRR*RRR8R]R(RrRtintt_join_multilinetsplittstrRRtapplytroundtdropRR^R9t writelinesRtwrite(R=RRt info_lineRRRtdiftadj_difteletcol_lenstn_colstcountertmidtmid_ixtcol_lenR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRQFsP *    .         cGs|j}d}t|}|jrr|jd}|tjg|D]}|jj|^qCj|8}ng|D]R}t|dkrtjg|D]}|jj|^qjnd^qy}t ||}t|} |j r|j d} nt|j } g} d} xt |D]\} }|| |!}|jrb|jd|n| dkr|t|kr| | dkr|jdgdg| dq|jdg| n| j|jj|||} q-Wdj| S(Niis \s t s (RRRYtpoptnptarrayR]R@Rt_binifyRdRRRR|RNR(RM(R=Rtlwidtht adjoin_widthRRRt col_widthstcol_binstnbinsRtstr_lsttstRItedtrow((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRs6    3\     "" c Csddlm}||d|d|d|d|d|}|d kr^tjrUdnd }nt|jd r|j|jnat|jtj rdd l } | j |jd d |} |j| Wd QXn t dd S(sU Render a DataFrame to a LaTeX tabular/longtable environment output. i(tLatexFormattert column_formatt longtablet multicolumntmulticolumn_formattmultirowtasciisutf-8RNRRs1buf is not a file name and it has no write method( tpandas.io.formats.latexRR8RtPY2RR9t write_resultRrt string_typestcodecstopent TypeError( R=RRRRRRRtlatex_rendererRtf((s7lib/python2.7/site-packages/pandas/io/formats/format.pytto_latexs   c Csh|j}|j|}|jdd|fj}t||d|jd|jd|jd|jS(NRER:RR( RRRaRxRFRER:RR(R=RIRt formatterRy((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRs   c Csddlm}m}|r"|n|}||d|d|j}t|jdrkt|j|nLt|jtj rt |jd}t||WdQXn t ddS( sG Render a DataFrame to a html table. Parameters ---------- 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.html.border``. .. versionadded:: 0.19.0 i(t HTMLFormattertNotebookFormattertclassestborderRRNs2buf is not a file name and it has no write method( tpandas.io.formats.htmlR R trenderRR9tbuffer_put_linesRrRRRR( R=RtnotebookRR R tKlassthtmlR ((s7lib/python2.7/site-packages/pandas/io/formats/format.pytto_htmlsc sddlm}|j}t|tr4|jdtdt}t|}jj j }t d|j Dt t|tt|fd}ttg|D](}g|D]}|||^q^q} jr t| r || } ngt| D]}t|^q} n|j}jj }t t|tt|gtt||D]?\} \} }j|  r|rd|n|g^q} jrx| D]}|jdqWn| S( Ni(t _sparsifyRR(css|]}|jVqdS(N(t is_floating(Rptl((s7lib/python2.7/site-packages/pandas/io/formats/format.pys scs,|jkr(|r( r(d|S|S(NR(R(Rty(t need_leadsptrestrict_formattingR=(s7lib/python2.7/site-packages/pandas/io/formats/format.pyt space_formatsRR6(tpandas.core.indexRRRrRR?RmR RtdtypesRnRstlevelstdictR R RRRR@RRtshow_row_idx_namesRN( R=RRRt fmt_columnsRRRRRRIR((RRR=s7lib/python2.7/site-packages/pandas/io/formats/format.pyRs0   8(   O  cCst|jjS(N(t _has_namesRRY(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pythas_index_names scCst|jjS(N(R$RR(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pythas_column_namesscCst|j|j|jfS(N(tallR%RYR(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR"s cCst|j|j|jfS(N(R'R&RRX(R=((s7lib/python2.7/site-packages/pandas/io/formats/format.pytshow_col_idx_namess c CsB|j}|j}|jd}t|tr]|jd|jdtd|jd|}n|jd|jd|g}g|D]<}t t t |ddd |j pd d |j ^q}|j jd |jd }|jrg|jD]}djd|^q}ndg|j}|jr:||S|SdS(Nt __index__RR(RqR RWR)R,RiR]is s{x}RR6(RYRRRrRR?RRmR"RRRRR]R(RR(t_get_column_name_listtnlevelsRX( R=RRYRtfmtRvRtadjoinedt col_header((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRw!s&    F + cCsgg}|jj}t|tr>|jd|jDn%|j|jdkrYdn|j|S(Ncss'|]}|dkrdn|VqdS(R6N(R8(RpRW((s7lib/python2.7/site-packages/pandas/io/formats/format.pys FsR6( RRRrRtextendRqRNRWR8(R=RqR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR*Bs  %N(RRRSt__doc__tcommon_docstringtreturn_docstringR8RTRmR>R^RRQRR RRRRR%R&R"R(RwR*(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRps0     - H O < "   * !R5Rc Cs*t|jrt} n{t|r-t} nft|jrEt} nNt|jr]t} n6t |jrut } nt |jrt } nt } |d krtd}n|d krtd}n|d krtd}n| |d|d|d|d|d|d |d |d |} | jS( sV Format an array for printing. Parameters ---------- values formatter float_format na_rep digits space justify decimal leading_space : bool, optional 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] sdisplay.column_spacesdisplay.float_formatsdisplay.precisiontdigitsR:RER RR)Rt leading_spaceN(RR[tDatetime64FormatterRtDatetime64TZFormatterRtTimedelta64FormatterRtExtensionArrayFormatterRtFloatArrayFormatterRtIntArrayFormattertGenericArrayFormatterR8R!t get_result( tvaluesR RER:R3RR)RR4t fmt_klasstfmt_obj((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRFPs0            R;c BsAeZddddddddedd ZdZdZRS( iR5i R-Rc Csg||_||_||_||_||_||_||_||_| |_| |_ | |_ dS(N( R=R3R:RR RER)Rtquotingt fixed_widthR4( R=R=R3R R:RRER)RR@RAR4((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>s          cCs|j}t||jS(N(t_format_stringsRR)(R=RO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR<s c sjdkrTtd}|dkr]djdtdfd}q]n j}jdk rujndfd}j}t|tr|j}nt|t r|j}nt j |t t |@}j}|dkr|j}ng}xt|D]\}}|| ra|ra|jdjd ||q"||r|j||q"|tkrd } nd} |j| jd ||q"W|S( Nsdisplay.float_formats{{x: .{prec:d}g}}tprecsdisplay.precisioncsjd|S(NR(R?(R(tfmt_str(s7lib/python2.7/site-packages/pandas/io/formats/format.pytscSst|ddS(NRgs s s (s s s (R*(R((s7lib/python2.7/site-packages/pandas/io/formats/format.pyREscsjdk rNt|rNt|rN|dkr7dS|tkrGdSjSt|trmdjd|Sdjd|SdS(NR8Ru{x}R(R:R8RRRRrR R?(R(R R=(s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_formats'  u {v}tvu{v}(RER8R!R?R R=RrR#RnRRt map_inferRRR4RsRRNRm( R=RERFtvalst is_float_typeR4RORIRGttpl((RDR R=s7lib/python2.7/site-packages/pandas/io/formats/format.pyRBs<          "   #N(RRRSR8RTR>R<RB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR;s    R9cBs8eZdZdZdddZdZdZRS(s cOshtj||||jdk rd|jdkrdt|_t|jrd|j|_d|_qdndS(N(R;R>RER8R RmRAtcallable(R=targsR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>s   csdkrjnr3fdnfdjdkrffdndkr|Sfd}|S(sDReturns a function to be applied on each value to format it cs t|rd|SjS(Ntvalue(RR:(RG(RER=(s7lib/python2.7/site-packages/pandas/io/formats/format.pytbase_formatterscst|rt|SjS(N(RRR:(RG(R=(s7lib/python2.7/site-packages/pandas/io/formats/format.pyROsRcs|jdjdS(NRi(treplaceR(RG(ROR=(s7lib/python2.7/site-packages/pandas/io/formats/format.pytdecimal_formatterscs@t|r5t|kr(|SdSnjSdS(Ng(RtabsR:(RN(RQR=t threshold(s7lib/python2.7/site-packages/pandas/io/formats/format.pyR  s    N(R8RER(R=RERSR ((RORQRER=RSs7lib/python2.7/site-packages/pandas/io/formats/format.pyt_value_formatters    c sjd k r;tjgjD]}j|^qSjrStdnd fd}jd krjrtdj dj }qj}nfd}||}js|St |dkrt d|D}|j dk}nt }tjd d Mtjj}|d kj}|d j k|dk@j} Wd QX| s|r|rtdj dj }||}n|S(s Returns the float values converted into strings using the parameters given at initialisation, as a numpy array sdisplay.chop_thresholdcsj|}jdkr1dj}n j}j}t|}t|drm|j}ntj|dd}|||<|j }tjg|j |D]}||^q|j |<j rt ||S|S(NR,Rtto_denseR[tobject( RTR)R:R=RRRURRtraveltflatRAt _trim_zeros(RER R:R=tmasktimasktval(R=RS(s7lib/python2.7/site-packages/pandas/io/formats/format.pytformat_values_with$s       0  s{value: .{digits:d}f}R3cs j|S(N(RE(RN(R=(s7lib/python2.7/site-packages/pandas/io/formats/format.pyREGsicss|]}t|VqdS(N(R@(RpR((s7lib/python2.7/site-packages/pandas/io/formats/format.pys Ssitinvalidtignoreg.Ai Ns{value: .{digits:d}e}(R R8RRR=RAR!RERR?R3R@RRmterrstateRRRs( R=RR]REtformatted_valuestmaxlenttoo_longtabs_valsthas_large_valuesthas_small_values((R=RSs7lib/python2.7/site-packages/pandas/io/formats/format.pytget_result_as_arrays:,        cCsB|jdk r2g|jD]}|j|^qSt|jS(N(R R8R=RRg(R=R((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRBhs#N(RRRSR0R>R8RTRgRB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR9s  ) SR:cBseZdZRS(cCs8|jpd}g|jD]}||^q}|S(NcSsdjd|S(Ns{x: d}R(R?(R((s7lib/python2.7/site-packages/pandas/io/formats/format.pyREss(R R=(R=R RRO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRBrs"(RRRSRB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR:psR5cBs eZdddZdZRS(RcKs/tt|j||||_||_dS(N(RR5R>tnat_rept date_format(R=R=RhRiR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>zs cCs|j}t|ts't|}n|jdk ret|jreg|D]}|j|^qLSt|jjdt ||j d|j j |j }|jS(s( we by definition have DO NOT have a TZ R?R:N(R=RrR%R R8RLRtasi8RWt"_get_format_datetime64_from_valuesRiRhtreshapetshapettolist(R=R=RRO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRBs   N(RRRSR8R>RB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR5xsR8cBseZdZRS(cCs|j}t|ttfr*|j}n|jdt}t|jrZ|j }nt j |}t ||d|j d|jd|jd|jd|jd|j}|S(NtboxedRER:R3RR)R4(R=RrRRRnt _formatterRTR R[RGRtasarrayRFRER:R3RR)R4(R=R=R RRO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRBs    (RRRSRB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR8sc Cstj|}tjddMt| s[tj|dk s[tj|dk rjtdnWdQXd|}|jt|k}tj|r|jtjt}g|D]}|d^qStj |}|ddkr|dnd}|d dkrd|d nd}tj tj tj tj|d |d |jt }td|}tj|d t}||jtjt||<||j|jt||>> 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%'] R^R_iis/percentiles should all be in the interval [0,1]Nidt%itto_begintto_endR[(RRqR`RR'RtastypeRRtuniqueR8tfloortlog10Rtediff1dRt empty_likeRVR(t percentilestint_idxtoutRIt unique_pctsRsRtRC((s7lib/python2.7/site-packages/pandas/io/formats/format.pytformat_percentiless*!#  $$  "cCsvt|}|jdk rtS|j}|tk}d}tj||t|dkj dk}|rrt StS(NiQgeAigS$B( R%ttzR8RmRjRRt logical_andRtsumRT(R=t values_inttconsider_valuest one_day_nanost even_days((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_is_dates_onlys    %RcCs|dks$t|r(t|r(|S|dk sDt|t rt|dddk rtt|j|}qt|j|}nt|S(Nttzinfo( R8RRRrRRkt tz_convertt tz_localizeR(RRRh((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_format_datetime64s$cCsd|dks$t|r(t|r(|St|tsFt|}n|rY|j|S|jSdS(N(R8RRRrRtstrftimet _date_repr(RRhRi((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_format_datetime64_dateonlys$ cs-|rdfdSdfdSdS(Ncst|ddS(NRhRi(R(RR(RiRh(s7lib/python2.7/site-packages/pandas/io/formats/format.pyREscst|d|dS(NRRh(R(RR(Rh(s7lib/python2.7/site-packages/pandas/io/formats/format.pyREs(R8(t is_dates_onlyRhRi((RiRhs7lib/python2.7/site-packages/pandas/io/formats/format.pyt_get_format_datetime64scCs t|}|r|pdS|S(s8 given values and a date_format, return a string format s%Y-%m-%d(R(R=RiR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRks  R6cBseZdZRS(cCs_|jjt}t|}|jp9t|d|j}g|D]}||^qC}|S(s we by definition have a TZ Ri(R=RuRVRR RRi(R=R=RR RRO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRB%s    (RRRSRB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR6#sR7cBs eZdedZdZRS(RcKs/tt|j||||_||_dS(N(RR7R>Rhtbox(R=R=RhRR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>4s cCsY|jp't|jd|jd|j}tjg|jD]}||^q:}|S(NRhR(R t_get_format_timedelta64R=RhRRR(R=R RRO((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRB9s   +(RRRSRmR>RB(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR72sc s|jtj}|tk}d}tj|||dkjdk}tj|tj||kjdk}|rdn|rdndfd}|S( s 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 iQgeAitsub_daytlongcsw|dks$t|r(t|r(St|tsFt|}n|jd}rsdjd|}n|S(NR?s'{res}'tres(R8RRRrRt _repr_baseR?(RRP(RR?Rh(s7lib/python2.7/site-packages/pandas/io/formats/format.pyRpZs$gS$BN(RuRtint64RRRRRR8( R=RhRRRRRt all_sub_dayRp((RR?Rhs7lib/python2.7/site-packages/pandas/io/formats/format.pyRAs  '   cst|dks|dkr"|Sdkr:tntfd|D|dk rtt|ntddk rkrnfd}g|D]}||^q}j|d|}|S(NiR'c3s|]}j|VqdS(N(R@(RpR(R](s7lib/python2.7/site-packages/pandas/io/formats/format.pys pssdisplay.max_colwidthcsGdk rCdkj|k@rC|d d}qCn|S(Nis...(R8R@(R(R]tconf_maxR(s7lib/python2.7/site-packages/pandas/io/formats/format.pytjustys R{(R@R8R\RR!R)(tstringsR)RR]RRRP((R]RRs7lib/python2.7/site-packages/pandas/io/formats/format.pyRhs     cs|}fdfd}x?||reg|D]"}|rV|d n|^q:}q'Wg|D]1}|jdr|r|dn|^qmS(sM Trims zeros, leaving just one before the decimal points if need be. cs|ko|jd S(Ntinf(tendswith(R(R:(s7lib/python2.7/site-packages/pandas/io/formats/format.pyt _is_numberscsbg|D]}|r|^q}t|dkoatd|Doatd|D S(Nicss|]}|jdVqdS(t0N(R(RpR((s7lib/python2.7/site-packages/pandas/io/formats/format.pys scss'|]}d|kpd|kVqdS(tetEN((RpR((s7lib/python2.7/site-packages/pandas/io/formats/format.pys s(R@R'Rs(R=Rtfinite(R(s7lib/python2.7/site-packages/pandas/io/formats/format.pyt_conds%(iRR(R(t str_floatsR:ttrimmedRR((RR:s7lib/python2.7/site-packages/pandas/io/formats/format.pyRYs3cCs0t|trtj|jS|jdk SdS(N(RrRtcomt _any_not_noneRqRWR8(RY((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR$st EngFormattercBseZdZidd6dd6dd6dd6d d 6d d 6d d6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d"6Zd%ed#Zd$ZRS(&sl Formats float values according to engineering format. Based on matplotlib.ticker.EngFormatter RitzitaiR itpitniR itmiR6itkitMitGi tTi tPiRitZitYicCs||_||_dS(N(taccuracytuse_eng_prefix(R=RR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyR>s c Csddl}ddl}|jt|}|jj|rCdS|jj|rYdSd}|dkr{d}| }n|dkr|jt|j|jdd}n|jd}|j t |j j }|j t |j j }t|}|j r&|j |}n4|dkrHdjd | }nd jd |}||d |} |jdkrtd } ntd jd|j} | jd| d|} | S(s Formats a number in engineering notation, appending a letter representing the power of 1000 of the original number. Some examples: >>> format_eng(0) # for self.accuracy = 0 ' 0' >>> format_eng(1000000) # for self.accuracy = 1, # self.use_eng_prefix = True ' 1.0M' >>> format_eng("-1e-6") # for self.accuracy = 2 # self.use_eng_prefix = False '-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 iNR5Riiis E-{pow10:02d}tpow10s E+{pow10:02d}i s{mant: g}{prefix}s{{mant: .{acc:d}f}}{{prefix}}tacctmanttprefix(RtmathtDecimalRtis_nant is_infiniteRRwRxRRt ENG_PREFIXEStkeysRR?RR8R ( R=tnumRRtdnumtsignRt int_pow10RRt format_strt formatted((s7lib/python2.7/site-packages/pandas/io/formats/format.pyt__call__s:     /    N(RRRSR0RR8RmR>R(((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRs* icCs4tdt||tdtd|ddS(s 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. sdisplay.float_formatsdisplay.column_spacei i N(R"RR(RR((s7lib/python2.7/site-packages/pandas/io/formats/format.pytset_eng_float_formats c Csd}g}d}t|d}xt|D]\}}||}||7}||krz|d|kot|dk} n|d|ko|dk} | r/|j||}q/q/W|jt||S(Niii(R@RRN( tcolsRRtbinst curr_widtht i_last_columnRIRt w_adjoinedtwrap((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRs     R6c Cst|dkrgStgt|d}g}x|D]}d}i}xQt|D]C\}}||r~||kr~qYt||<||||<|}qYWt||||<|j|q:W|S(sFor 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). i(R@RTRRmRN( R tsentineltcontrolRPtlevelt last_indextlengthsRItkey((s7lib/python2.7/site-packages/pandas/io/formats/format.pytget_level_lengths%s    cCsUtd|Dr;g|D]}tj|^q}n|jdj|dS(s Appends lines to a buffer. Parameters ---------- buf The buffer to write to lines The lines to append. css!|]}t|tjVqdS(N(RrRRB(RpR((s7lib/python2.7/site-packages/pandas/io/formats/format.pys Xss N(RsRRBRRM(R9tlinesR((s7lib/python2.7/site-packages/pandas/io/formats/format.pyRMs %(hR0t __future__Rt functoolsRtnumpyRt pandas._libsRtpandas._libs.tslibRtpandas._libs.tslibsRRRRt pandas.compatRR R R R tpandas.core.dtypes.commonR RRRRRRRRRRRtpandas.core.dtypes.genericRRRRtpandas.core.dtypes.missingRRRRtpandas.core.baseR tpandas.core.commontcoretcommonRtpandas.core.configR!R"RR#R$tpandas.core.indexes.datetimesR%tpandas.io.commonR&R'tpandas.io.formats.printingR(R)R*tpandas.io.formats.terminalR+R1t_VALID_JUSTIFY_PARAMETERSR2RVR4RURRR\RRR8RFR;R9R:R5R8RRRRRRkR6R7RmRRRYR$RRRRR(((s7lib/python2.7/site-packages/pandas/io/formats/format.pytsr "(R";  6   <M ?    '  c  (