x\c@sdZddlmZddlmZddlZddlmZddlm Z ddl m Z ddl Z ddlmZdd lmZdd lmZmZdd lmZddlZdd lmZmZddljjZdd l m!Z!ddl"m#Z#ddl$m%Z%m&Z&y&ddl'm(Z(m)Z)m*Z*m+Z+Wne,k rce,dnXy)ddl-j.Z/ddl0m1Z1e2Z3Wne,k re4Z3dZ5nXedZ6de7fdYZ8dZ9e:dZ;dZ<dS(sF Module for applying conditional formatting to DataFrames and Series. i(t defaultdict(tcontextmanagerN(tpartial(tproduct(tuuid1(trange(tAppender(tis_floattis_string_like(t ABCSeries(t is_dict_liket is_list_like(t get_option(t _shared_docs(t_maybe_numeric_slicet_non_reducing_slice(t PackageLoadert Environmentt ChoiceLoadertFileSystemLoadersapandas.Styler requires jinja2. Please install with `conda install Jinja2` or `pip install Jinja2`(tcolorss{0} requires matplotlib.ccs0trttfVnttj|jdS(N(thas_mpltpltRt ImportErrortno_mpl_messagetformatt__name__(tfunc((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt_mpl/stStylercBseZdZeddZededeZejdZ dCdCdCdCdCedZ dZ e eded d d d d ddddddddCdCeedCdddCedCdedCdZdZdCdZdZdZedZdZdZdZd ZddCd!ZddCd"ZdCd#ZdCd$ZdCdCd%Zd&Z d'Z!d(Z"d)Z#d*Z$d+Z%d,Z&d-Z'd.Z(e)d/Z*d0d1Z+d2ddddCd3d4Z,e)d2ddd3d5Z-dCd6Z.e)d7dCdCd8Z/dCdd9d7d:dCdCd;Z0dCd<dd=Z1dCd<dd>Z2dCd<dCed?Z3e)d<ed@Z4e5dAZ6dBZ7RS(Ds Helps style a DataFrame or Series according to the data with HTML and CSS. Parameters ---------- data : Series or DataFrame precision : int precision to round floats to, defaults to pd.options.display.precision table_styles : list-like, default None list of {selector: (attr, value)} dicts; see Notes uuid : str, default None a unique identifier to avoid CSS collisions; generated automatically caption : str, default None caption to attach to the table cell_ids : bool, default True If True, each cell will have an ``id`` attribute in their HTML tag. The ``id`` takes the form ``T__row_col`` where ```` is the unique identifier, ```` is the row number and ```` is the column number. Attributes ---------- env : Jinja2 Environment template : Jinja2 Template loader : Jinja2 Loader See Also -------- pandas.DataFrame.style Notes ----- Most styling will be done by passing style functions into ``Styler.apply`` or ``Styler.applymap``. Style functions should return values with strings containing CSS ``'attr: value'`` that will be applied to the indicated cells. If using in the Jupyter notebook, Styler has defined a ``_repr_html_`` to automatically render itself. Otherwise call Styler.render to get the generated HTML. CSS classes are attached to the generated HTML * Index and Column names include ``index_name`` and ``level`` where `k` is its level in a MultiIndex * Index label cells include * ``row_heading`` * ``row`` where `n` is the numeric position of the row * ``level`` where `k` is the level in a MultiIndex * Column label cells include * ``col_heading`` * ``col`` where `n` is the numeric position of the column * ``evel`` where `k` is the level in a MultiIndex * Blank cells include ``blank`` * Data cells include ``data`` tpandassio/formats/templatestloadert trim_blocksshtml.tplcs8tt_g_t|tjtjfsBtdn|j dkr`|j }n|j j sz|j j rtdn|_|j _ |j _ |_|_|_|dkrtd}n|_|_t_g_|_fdtfd_dS(Ns&``data`` must be a Series or DataFrameis.style is not supported for non-unique indices.sdisplay.precisioncs*t|r"dj|djS|SdS(Ns{:>.{precision}g}t precision(RRR!(tx(tself(s6lib/python2.7/site-packages/pandas/io/formats/style.pytdefault_display_funcs csS(N(((R$(s6lib/python2.7/site-packages/pandas/io/formats/style.pyts(Rtlisttctxt_todot isinstancetpdtSeriest DataFramet TypeErrortndimtto_frametindext is_uniquetcolumnst ValueErrortdatatuuidt table_stylestcaptiontNoneR R!ttable_attributestFalset hidden_indexthidden_columnstcell_idst_display_funcs(R#R4R!R6R5R7R9R=((R$R#s6lib/python2.7/site-packages/pandas/io/formats/style.pyt__init__zs.             cCs |jS(sB Hooks into Jupyter notebook rich display system. (trender(R#((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt _repr_html_stto_exceltaxessindex, columnstklassRtaxes_single_args{0 or 'index', 1 or 'columns'}t optional_bysi by : str or list of str Name or list of names which refer to the axis items.tversionadded_to_excels .. versionadded:: 0.20tSheet1titinfcCs{ddlm}||d|d|d|d|d|d|d | d |}|j|d |d | d | d|d| dS(Ni(tExcelFormattertna_reptcolstheadert float_formatR0t index_labelt merge_cellstinf_rept sheet_nametstartrowtstartcolt freeze_panestengine(tpandas.io.formats.excelRKtwrite(R#t excel_writerRSRLROR2RNR0RPRTRURWRQtencodingRRtverboseRVRKt formatter((s6lib/python2.7/site-packages/pandas/io/formats/style.pyRBs    c,Cs|jp g}|j}|j}|j}|j}|j}|jp]ttj dd}d}d} d} d} d} d} d }t |j }t |j |}t }|jj j}|jj j}|jj j}|jj j}|d kr$g|D]}|g^q }n|d krOg|D]}|g^q7}ntt|}g}g}xt|D]}id d 6| d 6| d6| d6dj| gd6g|d }|jj j|}|d0kr| n| djd|g}|d0kr| n|}|jid d 6|d 6|d6dj|d6| d6|rzx t||D]\}}| djd|djd|g}|j|jdij|ij|gid d 6|d 6|d6dj|d6t|||d6}|j||fd} | d krQ|idd6| d 6g|dtilocR=tcounttsplitR9R (,R#R6R7R'R!R;R<R5tROW_HEADING_CLASStCOL_HEADING_CLASStINDEX_NAME_CLASSt DATA_CLASSt BLANK_CLASSt BLANK_VALUERet idx_lengthst col_lengthst cell_contexttn_rlvlstn_clvlstrlabelstclabelsR"R{Rztrtrow_estnametcstcRhtesRptindex_header_rowR|tidxtridRuRnR]trow_dictRxt table_attrt use_mathjax((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt _translates     $     !  % $"  $1   7          c Css|dkr<tt|j}tt|jj}nst|}t|dkro||jjf}n|jj|}|jjj|j}|jjj|j}t |r'x|j D]X\}}t |}|jjj|gd}x!|D]} ||j | |f>> df = pd.DataFrame(np.random.randn(4, 2), columns=['a', 'b']) >>> df.style.format("{:.2%}") >>> df['c'] = ['a', 'b', 'c', 'd'] >>> df.style.format({'c': str.upper}) iiN(R8RRR4R2RtlocR0tget_indexer_forR titemst_maybe_wrap_formatterR>R( R#R]tsubsettrow_locstcol_locstsub_dfRnt col_formattertcol_numtrow_numtlocstitj((s6lib/python2.7/site-packages/pandas/io/formats/style.pyRds(%      cKst|j|j}g|dD]&}td|dDr!|^q!}||d<|j||jj|S(s: Render the built up styles to HTML. Parameters ---------- `**kwargs` : Any additional keyword arguments are passed through to ``self.template.render``. This is useful when you need to provide additional variables for a custom template. .. versionadded:: 0.20 Returns ------- rendered : str the rendered HTML Notes ----- ``Styler`` objects have defined the ``_repr_html_`` method which automatically calls ``self.render()`` when it's the last item in a Notebook cell. When calling ``Styler.render()`` directly, wrap the result in ``IPython.display.HTML`` to view the rendered HTML in the notebook. Pandas uses the following keys in render. Arguments passed in ``**kwargs`` take precedence, so think carefully if you want to override them: * head * cellstyle * body * uuid * precision * table_styles * caption * table_attributes R{css|]}t|VqdS(N(tany(t.0ty((s6lib/python2.7/site-packages/pandas/io/formats/style.pys sRx(t_computeRRtupdatettemplateR@(R#tkwargstdR"ttrimmed((s6lib/python2.7/site-packages/pandas/io/formats/style.pyR@s&  &  c Csx|jD]\}}x|jD]{\}}|jj|gd}|jj|gd}x:|jdjdD] }|j||fj|q}Wq&Wq WdS(s> Update the state of the Styler. Collects a mapping of {index_label: [': ']}. attrs : Series or DataFrame should contain strings of ': ;: ' Whitespace shouldn't matter and the final trailing ';' shouldn't matter. it;N( titerrowst iteritemsR0t get_indexerR2trstripRR'R( R#tattrst row_labeltvt col_labelRnRRRd((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt _update_ctxs c Cst|jd|jd|jd|jd|j}|rftj|j|_tj|j |_ n|j|_|j |_ |S(NR!R7R5R6( RR4R!R7R5R6tcopytdeepcopyR'R((R#Rtstyler((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt_copys   cCs|jdtS(s' Deep copy by default. R(RR:(R#((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt__copy__scCs|jdtS(NR(RtTrue(R#tmemo((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt __deepcopy__scCs|jjg|_dS(sa Reset the styler, removing any previously applied styles. Returns None. N(R'tclearR((R#((s6lib/python2.7/site-packages/pandas/io/formats/style.pyRs cCs<|}x/|jD]$\}}}||||}qW|S(s Execute the style functions built up in `self._todo`. Relies on the conventions that all style functions go through .apply or .applymap. The append styles to apply as tuples of (application method, *args, **kwargs) (R((R#RRtargsR((s6lib/python2.7/site-packages/pandas/io/formats/style.pyRs c Ksc|dkrtdn|}t|}|jj|}|dk rs|j|d|dd|}|j|_n|||}t|tj st dj d|n|j j |j o|jj |jsdj d|}t|n|j}|jj|j} || krRdj d|d|jd | }t|n|j||S( Ntaxist result_typetexpandsVFunction {func!r} must return a DataFrame when passed to `Styler.apply` with axis=NoneRsEResult of {func!r} must have identical index and columns as the inputs^Function {func!r} returned the wrong shape. Result has shape: {res} Expected shape: {expect}trestexpect(R8tsliceRR4RtapplyR2R)R*R,R-RR0tequalsR3tshapeR( R#RRRRR4tresulttmsgt result_shapetexpected_shape((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt_applys6            cKs)|jjd|||f|f|S(sP Apply a function column-wise, row-wise, or table-wise, updating the HTML representation with the result. Parameters ---------- func : function ``func`` should take a Series or DataFrame (depending on ``axis``), and return an object with the same shape. Must return a DataFrame with identical index and column labels when ``axis=None`` axis : int, str or None apply to each column (``axis=0`` or ``'index'``) or to each row (``axis=1`` or ``'columns'``) or to the entire DataFrame at once with ``axis=None`` subset : IndexSlice a valid indexer to limit ``data`` to *before* applying the function. Consider using a pandas.IndexSlice kwargs : dict pass along to ``func`` Returns ------- self : Styler Notes ----- The output shape of ``func`` should match the input, i.e. if ``x`` is the input row, column, or table (depending on ``axis``), then ``func(x).shape == x.shape`` should be true. This is similar to ``DataFrame.apply``, except that ``axis=None`` applies the function to the entire DataFrame at once, rather than column-wise or row-wise. Examples -------- >>> def highlight_max(x): ... return ['background-color: yellow' if v == x.max() else '' for v in x] ... >>> df = pd.DataFrame(np.random.randn(5, 2)) >>> df.style.apply(highlight_max) cSs t|dS(NR(tgetattr(tinstance((s6lib/python2.7/site-packages/pandas/io/formats/style.pyR%bs(R(R(R#RRRR((s6lib/python2.7/site-packages/pandas/io/formats/style.pyR5s-cKs^t||}|dkr(tj}nt|}|jj|j|}|j||S(N( RR8R*t IndexSliceRR4RtapplymapR(R#RRRR((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt _applymapfs    cKs&|jjd||f|f|S(s* Apply a function elementwise, updating the HTML representation with the result. Parameters ---------- func : function ``func`` should take a scalar and return a scalar subset : IndexSlice a valid indexer to limit ``data`` to *before* applying the function. Consider using a pandas.IndexSlice kwargs : dict pass along to ``func`` Returns ------- self : Styler See Also -------- Styler.where cSs t|dS(NR(R(R((s6lib/python2.7/site-packages/pandas/io/formats/style.pyR%s(R(R(R#RRR((s6lib/python2.7/site-packages/pandas/io/formats/style.pyRosc s:dkrdn|jfdd||S(s  Apply a function elementwise, updating the HTML representation with a style which is selected in accordance with the return value of a function. .. versionadded:: 0.21.0 Parameters ---------- cond : callable ``cond`` should take a scalar and return a boolean value : str applied when ``cond`` returns true other : str applied when ``cond`` returns false subset : IndexSlice a valid indexer to limit ``data`` to *before* applying the function. Consider using a pandas.IndexSlice kwargs : dict pass along to ``cond`` Returns ------- self : Styler See Also -------- Styler.applymap RIcs|rSS(N((tval(tcondtotherRh(s6lib/python2.7/site-packages/pandas/io/formats/style.pyR%sRN(R8R(R#RRhRRR((RRRhs6lib/python2.7/site-packages/pandas/io/formats/style.pytwheres  cCs ||_|S(s Set the precision used to render. Parameters ---------- precision : int Returns ------- self : Styler (R!(R#R!((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt set_precisions cCs ||_|S(s Set the table attributes. These are the items that show up in the opening ```` tag in addition to to automatic (by default) id. Parameters ---------- attributes : string Returns ------- self : Styler Examples -------- >>> df = pd.DataFrame(np.random.randn(10, 4)) >>> df.style.set_table_attributes('class="pure-table"') # ...
... (R9(R#Rr((s6lib/python2.7/site-packages/pandas/io/formats/style.pytset_table_attributess cCs|jS(s Export the styles to applied to the current Styler. Can be applied to a second style with ``Styler.use``. Returns ------- styles : list See Also -------- Styler.use (R((R#((s6lib/python2.7/site-packages/pandas/io/formats/style.pytexportscCs|jj||S(s> Set the styles on the current Styler, possibly using styles from ``Styler.export``. Parameters ---------- styles : list list of style functions Returns ------- self : Styler See Also -------- Styler.export (R(R(R#tstyles((s6lib/python2.7/site-packages/pandas/io/formats/style.pytusescCs ||_|S(s Set the uuid for a Styler. Parameters ---------- uuid : str Returns ------- self : Styler (R5(R#R5((s6lib/python2.7/site-packages/pandas/io/formats/style.pytset_uuids cCs ||_|S(s Set the caption on a Styler Parameters ---------- caption : str Returns ------- self : Styler (R7(R#R7((s6lib/python2.7/site-packages/pandas/io/formats/style.pyt set_caption s cCs ||_|S(sC Set the table styles on a Styler. These are placed in a ``