U
|
¬ý°dW ã
|
@ s d dl mZ d dlmZ d dlmZ d dlZd dlmZm Z m
|
Z
|
m Z m Z m Z mZmZmZmZ d dlmZ d dlZd dlmZ d dlmZ d d lmZm Z d d
|
l m Z d d l m Z m!Z!m"Z" d d l#m$Z$ d d l%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+ d dl,m-Z- d dl.m/ m0Z1 e dddZ2d dl3m4Z5 ee6e f Z7ee7e ee e7 f f Z8ee6ee6e9f f Z:e e: Z;ee6e;f Z<G dd deZ=e e= Z>ee?ee'f Z@G dd dZAdddddd d d ZBdid d!d"d#d$ZCdjd%dd&d'd(d)d*ZDdd+d,d-ZEd.d.d/d0d1ZFdkdd&ddd3d4d5ZGd6ddd6d7d8d9ZHd:d; ZId<d= ZJdld?dd@ddddd6dAdBdCZKdDdEdFdGZLdHdIdJdKdLZMdMd%dNdOdPdQZNG dRdS dSZOd.dddTdUdVZPd.dddWdXdYZQdmdIddddZd[d\ZRdnd]dddddd^d_d`ZSdadddbdcddZTdIdId/dedfZUdgdh ZVdS )oé )Ú annotations)Ú defaultdict)ÚpartialN)
|
ÚAnyÚCallableÚ DefaultDictÚDictÚListÚOptionalÚSequenceÚTupleÚ TypedDictÚUnion)Úuuid4)Ú
|
get_option)Úlib)ÚAxisÚLevel)Úimport_optional_dependency)Ú
|
is_complexÚis_floatÚ
|
is_integer)Ú ABCSeries)Ú DataFrameÚIndexÚ
|
IndexSliceÚ
|
MultiIndexÚSeriesÚisna)Ú is_list_likeÚjinja2z DataFrame.style requires jinja2.)Úextra©Úescapec @ s e Zd ZU ded< ded< dS )ÚCSSDictÚstrÚselectorÚ CSSPropertiesÚpropsN)Ú__name__Ú
|
__module__Ú __qualname__Ú__annotations__© r- r- úUd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/io/formats/style_render.pyr$ ; s
|
r$ c @ sè e Zd ZdZe dd¡ZejeddZe d¡Z
|
e d¡Z e d¡Z e d ¡Z e d
|
¡ZdWd ddddddddd ddZdXdddddddd ZdYdddddd d d Zddddd d!d"ZdZdddddd d#d$Zd%d& Zd[dddddd(d)d*d+Zddd,d-d.Zd/dd0d1d2d3Zd/dd0d1d4d5Zd0ddd6d7d8Zd\ddd:ddddd;d<d=Zdd:d>d?d@Zd/dd0dAdBdCZ d0dddDdEdFZ d]dHdIddddddd dJ dKdLZ d^dHdNdOddddddd dP
|
dQdRZ d_dSdNdOd dTdUdVZ d S )`ÚStylerRendererzT
|
Base class to process rendering a Styler with a specified jinja2 template.
|
Úpandaszio/formats/templatesT)ÚloaderZ trim_blockszhtml.tplzhtml_table.tplzhtml_style.tplz latex.tplz
|
string.tplNé zDataFrame | Seriesú
|
str | NoneÚintzCSSStyles | Nonezstr | tuple | list | NoneÚboolú
|
int | NoneÚNone) ÚdataÚuuidÚuuid_lenÚ table_stylesÚtable_attributesÚcaptionÚcell_idsÚ precisionÚreturnc st t |tr| ¡ }t |ts$td|| _|j| _|j| _t |trL|dk rTtd|plt j
|
d t d|
| _ t | j | _|| _|| _|| _|| _ddddd d
|
d d d ddd | _g | _d| _d| _dg| jj | _dg| jj | _g | _g | _t t | _ t t | _ t t | _ t t!| _"g | _#d | _$ d kr6t%dn t fdd| _&t fdd| _'t fdd| _(d S )Nz&``data`` must be a Series or DataFramer z1``uuid_len`` must be an integer in range [0, 32].é Ú row_headingÚ col_headingÚ
|
index_nameÚcolÚrowÚcol_trimÚrow_trimÚlevelr8 ÚblankÚfoot) rB rC rD rE rF rG rH rI r8 rJ rK Fústyler.format.precisionc s t t dS ©N©r? ©r Ú_default_formatterr- rN r- r. Ú<lambda> ó z)StylerRenderer.__init__.<locals>.<lambda>c s t t dS rM rO r- rN r- r. rQ rR c s t t dS rM rO r- rN r- r. rQ rR ))Ú
|
isinstancer Zto_framer Ú TypeErrorr8 ÚindexÚcolumnsr4 r ÚhexÚminr9 Úlenr: r; r< r= r> ÚcssÚ concatenatedÚhide_index_namesÚhide_column_namesÚnlevelsÚ hide_index_Ú hide_columns_Ú hidden_rowsÚhidden_columnsr ÚlistÚctxÚ ctx_indexÚ ctx_columnsr% Ú cell_contextÚ_todoÚtooltipsr Ú_display_funcsÚ_display_funcs_indexÚ_display_funcs_columns) Úselfr8 r9 r: r; r< r= r> r? r- rN r. Ú__init__Q s`
|
|
õ
|
|
|
|
ÿþþþzStylerRenderer.__init__Ú r% )Ú sparse_indexÚsparse_columnsÚmax_rowsÚmax_colsrJ c C s | ¡ g }t| j}t| jD ]Ö\}} | j| _| j| _| jd | }
|
| j|
|
d|
|
d|
|
d|
|
dd| _| |||||¡} | | ¡ | j
|
¡ D ] \\} } }|| j
|
| | | f< q| j ¡ D ] \\} } }|| j | | | f< qÈ|t| j7 }q | ||||||¡}|S )zâ
|
Computes and applies styles and then generates the general render dicts.
|
|
Also extends the `ctx` and `ctx_index` attributes with those of concatenated
|
stylers for use within `_translate_latex`
|
rK Ú_dataZ _row_headingÚ_rowZ_foot)r8 rB rF rK )Ú_computerY rU Ú enumerater[ r_ rb rZ Ú_renderÚappendrd Úitemsre Ú
|
_translate)rm rp rq rr rs rJ ÚdxsZctx_lenÚir[ rK ÚdxÚrÚcÚvÚdr- r- r. rx sF
|
û
|
ÿ
|
ÿzStylerRenderer._render)rp rq rr rs r@ c K s8 | ||||d¡}| |¡ | jjf || j| jdS )z
|
Renders the ``Styler`` including all applied styles to HTML.
|
Generates a dict with necessary kwargs passed to jinja2 template.
|
ú )Zhtml_table_tplZhtml_style_tpl)rx ÚupdateÚ template_htmlÚrenderÚtemplate_html_tableÚtemplate_html_style©rm rp rq rr rs Úkwargsr r- r- r. Ú _render_htmlÁ s
|
ýzStylerRenderer._render_html)rp rq Úclinesr@ c K sf | ||dd¡}| j||d t| jjd< t| jjd< t| jjd< t| jjd< | |¡ | jj f |S )z1
|
Render a Styler in latex format
|
N)r Z
|
parse_wrapZ parse_tableZ
|
parse_cellÚ parse_header)
|
rx Ú_translate_latexÚ_parse_latex_table_wrappingÚtemplate_latexÚglobalsÚ_parse_latex_table_stylesÚ_parse_latex_cell_stylesÚ_parse_latex_header_spanr r )rm rp rq r r r r- r- r. Ú _render_latexÕ s
|
z StylerRenderer._render_latexc K s( | ||||¡}| |¡ | jjf |S )z2
|
Render a Styler in string format
|
)rx r Útemplate_stringr r r- r- r. Ú_render_stringä s
|
z StylerRenderer._render_stringc C sF | j ¡ | j ¡ | j ¡ | }| jD ]\}}}|| ||}q(|S )a
|
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)
|
)rd Úclearre rf rh )rm r ÚfuncÚargsr r- r- r. rv ó s
|
|
|
zStylerRenderer._computer zlist[dict] | None)rp Ú sparse_colsrr rs rJ r| c C sÚ |dkr g }|| j d< | jt| jp$g | jd}td}|r@|ntd}|rP|ntd}tt| jj t| jj
|
|||\}}t t | _ | ||¡} | d| i¡ t| j ||| j}
|
| d|
|
i¡ t t | _t t | _| |
|
||¡} | d | i¡ d
|
d d d } | ¡ D ]0\} }dd t| | ¡ D }| | |i¡ q|D ]<}|d |d ¡ |d |d ¡ |d |d ¡ q:| j}tds²|pd}d|krª| dd¡}n|d7 }| d|i¡ | jrÖ| j | |¡}|S )aj
|
Process Styler data and settings into a dict for template rendering.
|
|
Convert data and settings from ``Styler`` attributes such as ``self.data``,
|
``self.tooltips`` including applying any methods in ``self._todo``.
|
|
Parameters
|
----------
|
sparse_index : bool
|
Whether to sparsify the index or print all hierarchical index elements.
|
Upstream defaults are typically to `pandas.options.styler.sparse.index`.
|
sparse_cols : bool
|
Whether to sparsify the columns or print all hierarchical column elements.
|
Upstream defaults are typically to `pandas.options.styler.sparse.columns`.
|
max_rows, max_cols : int, optional
|
Specific max rows and cols. max_elements always take precedence in render.
|
blank : str
|
Entry to top-left blank cells.
|
dxs : list[dict]
|
The render dicts of the concatenated Stylers.
|
|
Returns
|
-------
|
d : dict
|
The following structure: {uuid, table_styles, caption, head, body,
|
cellstyle, table_attributes}
|
NÚ blank_value)r9 r; r= zstyler.render.max_elementszstyler.render.max_rowszstyler.render.max_columnsÚheadÚ index_lengthsÚbodyÚ cellstyle_mapÚcellstyle_map_indexÚcellstyle_map_columns)Ú cellstyleÚcellstyle_indexZcellstyle_columnsc S s g | ]\}}t ||d qS ))r( Ú selectors)rc )Ú.0r( r¥ r- r- r. Ú
|
<listcomp>Y s ÿz-StylerRenderer._translate.<locals>.<listcomp>r£ r¤ zstyler.html.mathjaxro zclass="zclass="tex2jax_ignore z class="tex2jax_ignore"r< ) rZ r9 Úformat_table_stylesr; r= r Ú_get_trimming_maximumsrY r8 rU rV r rc r¢ Ú_translate_headerr Ú_get_level_lengthsra r r¡ Ú_translate_bodyrz ÚgetattrÚextendr< Úreplaceri r{ )rm rp r rr rs rJ r| r Ú max_elementsr Ú idx_lengthsr Zctx_mapsÚkÚattrÚmapr~ Z
|
table_attrr- r- r. r{ sx $
|
ý
|
|
û
|
þ ÿÿþý þÿ
|
|
|
zStylerRenderer._translate)Ú sparsify_colsrs c
|
C sÊ t | j||| j}| jj ¡ }| jjjdkr:dd |D }tt| }g }t| j D ].\}}|sT|sfqT|
|
||f||¡}| |¡ qT| jj j rÆtj| jj j rÆt| jsÆ| jsÆ| |||¡} | | ¡ |S )aN
|
Build each <tr> within table <head> as a list
|
|
Using the structure:
|
+----------------------------+---------------+---------------------------+
|
| index_blanks ... | column_name_0 | column_headers (level_0) |
|
1) | .. | .. | .. |
|
| index_blanks ... | column_name_n | column_headers (level_n) |
|
+----------------------------+---------------+---------------------------+
|
2) | index_names (level_0 to level_n) ... | column_blanks ... |
|
+----------------------------+---------------+---------------------------+
|
|
Parameters
|
----------
|
sparsify_cols : bool
|
Whether column_headers section will add colspan attributes (>1) to elements.
|
max_cols : int
|
Maximum number of columns to render. If exceeded will contain `...` filler.
|
|
Returns
|
-------
|
head : list
|
The associated HTML elements needed for template rendering.
|
é c S s g | ]
|
}|gqS r- r- ©r¦ Úxr- r- r. r§ s z4StylerRenderer._translate_header.<locals>.<listcomp>)r« rV rb r8 Útolistr^ rc Úziprw r` Ú_generate_col_header_rowry rU ÚnamesÚcomZ any_not_noneÚallr_ r\ Ú_generate_index_names_row)
|
rm rµ rs Ú col_lengthsÚclabelsr r ZhideZ
|
header_rowZindex_names_rowr- r- r. rª t sF ÿ ÿ ÿþýü ÿ
|
z StylerRenderer._translate_headerÚtupleÚdict)Úiterrs rÀ c C s |\}}t d| jd | jd dg| jjt| j d }| jjj| }t d|dkrr| jd d| jd | n | jd d| jd | |dk r | j s |n| jd t
|
| j g}g } d
|
}
|
t || D ]¦\} } t | ||} | rú|
|
| || fd
|
¡7 }
|
| |
|
|| d| jd d| jd | d| jd ¡r: qvt d| jd d| jd | d| jd | | | | j|| f | | || fd
|
¡dkr¬d| || fd
|
¡ dndd}| jrâ| jd | d| jd | |d< | rj|| f| jkrj| j|| f rj| jd | d| jd | |d< | jt| j|| f | jd | d| jd | ¡ | |¡ qÌ|| | S )aD
|
Generate the row containing column headers:
|
|
+----------------------------+---------------+---------------------------+
|
| index_blanks ... | column_name_i | column_headers (level_i) |
|
+----------------------------+---------------+---------------------------+
|
|
Parameters
|
----------
|
iter : tuple
|
Looping variables from outer scope
|
max_cols : int
|
Permissible number of columns
|
col_lengths :
|
c
|
|
Returns
|
-------
|
list of elements
|
ÚthrJ r Tr¶ Nú rI rD r rC rG rE ú colspan="ú"ro ©Ú display_valueÚ
|
attributesÚ_Úid)Ú_elementrZ rU r^ Úsumr_ r8 rV r¼ r] r¾ rw Ú _is_visibleÚgetÚ _check_trimrl r> rf r¢ r ry )rm rÄ rs rÀ r rÁ Z index_blanksÚnameZ column_nameZcolumn_headersÚvisible_col_countr ÚvalueÚheader_element_visibleÚheader_elementr- r- r. r» ° sr ÿþÿ ÿÿ
|
öÿ (û,ÿ ô&ÿ þ ý& ÿ z'StylerRenderer._generate_col_header_rowc sì |} fddt jjjD }g }d}|rä jjd }t || D ]\} }
|
t| ||} | rd|d7 } |||d jd d jd | d jd jd
|
¡r¨ qä| t
|
d jd d jd | jd
|
| j k¡ qD|| S ) a
|
Generate the row containing index names
|
|
+----------------------------+---------------+---------------------------+
|
| index_names (level_0 to level_n) ... | column_blanks ... |
|
+----------------------------+---------------+---------------------------+
|
|
Parameters
|
----------
|
iter : tuple
|
Looping variables from outer scope
|
max_cols : int
|
Permissible number of columns
|
|
Returns
|
-------
|
list of elements
|
c sR g | ]J\}}t d jd d jd | |dkr> jd n| j| qS )rÅ rD rÆ rI Nr ©rÎ rZ r_ )r¦ r rÓ ©rm r- r. r§ # s ú
|
üz<StylerRenderer._generate_index_names_row.<locals>.<listcomp>r r¶ rÅ rJ rÆ rE rG r ) rw r8 rU r¼ rV r^ rÐ rÒ rZ ry rÎ rb ) rm rÄ rs rÀ rÁ Z index_namesZ column_blanksrÔ Z
|
last_levelr rÕ rÖ r- rÙ r. r¿ s<
|
ù
|
(ú üÿ z(StylerRenderer._generate_index_names_row)r± rr rs c
|
s j j ¡ }t j jts(dd |D }g }d} fddt j ¡ D D ]B\}}|d7 } |||d¡rp q |||f||¡} | | ¡ qL|S )aó
|
Build each <tr> within table <body> as a list
|
|
Use the following structure:
|
+--------------------------------------------+---------------------------+
|
| index_header_0 ... index_header_n | data_by_column ... |
|
+--------------------------------------------+---------------------------+
|
|
Also add elements to the cellstyle_map for more efficient grouped elements in
|
<style></style> block
|
|
Parameters
|
----------
|
sparsify_index : bool
|
Whether index_headers section will add rowspan attributes (>1) to elements.
|
|
Returns
|
-------
|
body : list
|
The associated HTML elements needed for template rendering.
|
c S s g | ]
|
}|gqS r- r- r· r- r- r. r§ b s z2StylerRenderer._translate_body.<locals>.<listcomp>r c s g | ]}|d j kr|qS ©r ©ra )r¦ ÚzrÙ r- r. r§ f s r¶ rF )
|
r8 rU r¹ rS r rw Z
|
itertuplesrÒ Ú_generate_body_rowry )
|
rm r± rr rs Úrlabelsr Úvisible_row_countr Úrow_tupZbody_rowr- rÙ r. r¬ J s.
|
ÿü ÿ z StylerRenderer._translate_bodyú...rc )ÚcountÚmaxÚobjÚelementrZ rÕ r@ c C sB ||kr>|dkr"| | |¡¡ n| t|||ddd¡ dS dS )aÿ
|
Indicates whether to break render loops and append a trimming indicator
|
|
Parameters
|
----------
|
count : int
|
The loop count of previous visible items.
|
max : int
|
The allowable rendered items in the loop.
|
obj : list
|
The current render collection of the rendered items.
|
element : str
|
The type of element to append in the case a trimming indicator is needed.
|
css : str, optional
|
The css to add to the trimming indicator element.
|
value : str, optional
|
The value of the elements display if necessary.
|
|
Returns
|
-------
|
result : bool
|
Whether a trimming element was required and appended.
|
rF Tro ©rË F)ry Ú_generate_trimmed_rowrÎ )rm râ rã rä rå rZ rÕ r- r- r. rÒ x s zStylerRenderer._check_trim)rs r@ c sÌ fddt jjjD }g }d}t jD ]\}}| jk}|rL|d7 } |||d jd d jd d jd ¡r qÄ| t
|
d jd d jd
|
| d jd d |d d ¡ q.|| S )zÿ
|
When a render has too many rows we generate a trimming row containing "..."
|
|
Parameters
|
----------
|
max_cols : int
|
Number of permissible columns
|
|
Returns
|
-------
|
list of elements
|
c sL g | ]D}t d jd d jd | d jd d j| ddqS )rÅ rB rÆ rI rH rá ro ræ rØ )r¦ r rÙ r- r. r§ s ö(
|
øz8StylerRenderer._generate_trimmed_row.<locals>.<listcomp>r r¶ Útdr8 rÆ rH rG rE rá ro ræ ) Úranger8 rU r^ rw rV rb rÒ rZ ry rÎ )rm rs Ú index_headersr8 rÔ r rÌ Údata_element_visibler- rÙ r. rç s6
|
õ
|
$û(ûÿ
|
z$StylerRenderer._generate_trimmed_row)rÄ rs r± c C s< |\}}}g }t || D ]V\}} t|||o:| j| }
|
td| jd d| jd | d| jd | | |
|
| j||f | | ||fd¡dkr¬d| ||fd¡ d nd
|
d } | jrà| jd | d | jd | | d < |
|
rh||f| jkrh| j||f rh| jd | d | jd | | d < | j t
|
| j||f | jd | d | jd | ¡ | | ¡ qg } d} t |dd
D ]¤\}} || j koª|| j k}|rº| d7 } | | || d| jd d| jd | d| jd ¡rú q4d
|
}||f| jkr d| j||f }td| jd d| jd | d| jd | | | |d
|
| j||f | d}| jr| jd | d | jd | |d < |r&||f| jkr&| j||f r&| jd | d | jd | |d < | jt
|
| j||f | jd | d | jd | ¡ | |¡ q|| S )a¿
|
Generate a regular row for the body section of appropriate format.
|
|
+--------------------------------------------+---------------------------+
|
| index_header_0 ... index_header_n | data_by_column ... |
|
+--------------------------------------------+---------------------------+
|
|
Parameters
|
----------
|
iter : tuple
|
Iterable from outer scope: row number, row data tuple, row index labels.
|
max_cols : int
|
Number of permissible columns.
|
idx_lengths : dict
|
A map of the sparsification structure of the index
|
|
Returns
|
-------
|
list of elements
|
rÅ rB rÆ rI rF r r¶ ú rowspan="rÈ ro rÉ rÌ rÍ Nrè r8 rG rE )rË rÊ )rw rÐ r_ rÎ rZ rk rÑ r> re r¡ r ry rb ra rÒ rg rj rd r )rm rÄ rs r± r rà rÞ rê r rÕ rÖ r× r8 rÔ rë ÚclsZ data_elementr- r- r. rÝ Ö s
|
ÿ,ÿô þÿÿ þ ý& ÿ ÿ(û0÷ &&& ÿz!StylerRenderer._generate_body_row)r r r@ c sì j j}|tj fddt|d D |d< fdd fdd}g }t||d D ]f\}tjr|g }n fd dt|d
|
|
D }fd dt||d
|
D }| || ¡ qd||d< |d krìtd | d|d
|
k rèd|kr|d rt |nd} t
|
t |d< fddt t j j D }
|
fddt |D } t|
|
D ]\} t| D ]t\} }||d krd|krqn|d |fd
|
¡}|d
|
k rn|d | | d| d dt | | d¡ qnq^d
|
S )aÈ
|
Post-process the default render dict for the LaTeX template format.
|
|
Processing items included are:
|
- Remove hidden columns from the non-headers part of the body.
|
- Place cellstyles directly in td cells rather than use cellstyle_map.
|
- Remove hidden indexes or reinsert missing th elements if part of multiindex
|
or multirow sparsification (so that \multirow and \multicol work correctly).
|
c s* g | ]"\ } fd dt |D qS )c s2 g | ]*\}}|d r|dj | f iqS )Ú
|
is_visibler£ )rf ©r¦ r rE )r rm Úvisible_index_level_nr- r. r§ T s þz>StylerRenderer._translate_latex.<locals>.<listcomp>.<listcomp>)rw )r¦ rF )rm rð )r r. r§ S s ûþz3StylerRenderer._translate_latex.<locals>.<listcomp>r c sN | fddttjD ¡ tj7 jD ]}| | q8 S )z`
|
Extract all visible row indices recursively from concatenated stylers.
|
c s g | ]}|j kr| qS r- rÛ ©r¦ r ©Únrä r- r. r§ a s
|
zWStylerRenderer._translate_latex.<locals>._concatenated_visible_rows.<locals>.<listcomp>)r® ré rY rU r[ )rä ró Ú row_indicesr[ ©Ú_concatenated_visible_rowsrò r. rö \ s ÿ
|
zCStylerRenderer._translate_latex.<locals>._concatenated_visible_rowsc s g } | d| |S ©Nr r- )rä rô rõ r- r. Úconcatenated_visible_rowsh s zBStylerRenderer._translate_latex.<locals>.concatenated_visible_rowsr c sN g | ]F\}}|d dkrj | s||d r4|d ndj |f dqS )ÚtyperÅ rî rÊ ro )rÊ r£ )r_ re rï ©r rm r- r. r§ w s
|
ùÿ
|
ûNc s: g | ]2\}}|d r|d dkr|dj |f iqS )rî rù rè r£ )rd rï rú r- r. r§ s þ)Nzall;dataz all;indexzskip-last;datazskip-last;indexz`clines` value of zj is invalid. Should either be None or one of 'all;data', 'all;index', 'skip-last;data', 'skip-last;index'.r8 r r c s g | ]}| j kr|qS r- rÛ rñ rÙ r- r. r§ s
|
c s g | ]} j | s|qS r- )r_ ©r¦ r} rÙ r- r. r§ s
|
r¶ z skip-lastr z\cline{ú-Ú})rU r^ rÏ r_ rw rº r¾ ry Ú
|
ValueErrorrY r rc ré r8 rÑ )rm r r Z index_levelsrø r rF Zrow_body_headersZrow_body_cellsZdata_lenZvisible_row_indexesZvisible_index_levelsÚrnZlvlnÚlvlZidx_lenr- )rö r rm rð r. r G sR
|
|
ú
|
|
ø þ
|
ÿ
|
|
ÿ
|
ÿ
|
ÿz StylerRenderer._translate_latexÚ.zExtFormatter | Nonez Subset | None) Ú formatterÚsubsetÚna_repr? ÚdecimalÚ thousandsr# Ú
|
hyperlinksr@ c
|
sð t dk|dk|dk|dk|dk|dk|dk|dkfrF| j ¡ | S |dkrVtdn|}t|}| jj| } t ts fdd| j D | j
|
| j ¡}
|
| j
|
| j ¡} |
|
D ]>} t | j | ¡||||||d} | D ]}| | j|| f< qÖq¬| S )uL
|
Format the text display value of cells.
|
|
Parameters
|
----------
|
formatter : str, callable, dict or None
|
Object to define how values are displayed. See notes.
|
subset : label, array-like, IndexSlice, optional
|
A valid 2d input to `DataFrame.loc[<subset>]`, or, in the case of a 1d input
|
or single key, to `DataFrame.loc[:, <subset>]` where the columns are
|
prioritised, to limit ``data`` to *before* applying the function.
|
na_rep : str, optional
|
Representation for missing values.
|
If ``na_rep`` is None, no special formatting is applied.
|
precision : int, optional
|
Floating point precision to use for display purposes, if not determined by
|
the specified ``formatter``.
|
|
.. versionadded:: 1.3.0
|
|
decimal : str, default "."
|
Character used as decimal separator for floats, complex and integers.
|
|
.. versionadded:: 1.3.0
|
|
thousands : str, optional, default None
|
Character used as thousands separator for floats, complex and integers.
|
|
.. versionadded:: 1.3.0
|
|
escape : str, optional
|
Use 'html' to replace the characters ``&``, ``<``, ``>``, ``'``, and ``"``
|
in cell display string with HTML-safe sequences.
|
Use 'latex' to replace the characters ``&``, ``%``, ``$``, ``#``, ``_``,
|
``{``, ``}``, ``~``, ``^``, and ``\`` in the cell display string with
|
LaTeX-safe sequences.
|
Escaping is done before ``formatter``.
|
|
.. versionadded:: 1.3.0
|
|
hyperlinks : {"html", "latex"}, optional
|
Convert string patterns containing https://, http://, ftp:// or www. to
|
HTML <a> tags as clickable URL hyperlinks if "html", or LaTeX \href
|
commands if "latex".
|
|
.. versionadded:: 1.4.0
|
|
Returns
|
-------
|
Styler
|
|
See Also
|
--------
|
Styler.format_index: Format the text display value of index labels.
|
|
Notes
|
-----
|
This method assigns a formatting function, ``formatter``, to each cell in the
|
DataFrame. If ``formatter`` is ``None``, then the default formatter is used.
|
If a callable then that function should take a data value as input and return
|
a displayable representation, such as a string. If ``formatter`` is
|
given as a string this is assumed to be a valid Python format specification
|
and is wrapped to a callable as ``string.format(x)``. If a ``dict`` is given,
|
keys should correspond to column names, and values should be string or
|
callable, as above.
|
|
The default formatter currently expresses floats and complex numbers with the
|
pandas display precision unless using the ``precision`` argument here. The
|
default formatter does not adjust the representation of missing values unless
|
the ``na_rep`` argument is used.
|
|
The ``subset`` argument defines which region to apply the formatting function
|
to. If the ``formatter`` argument is given in dict form but does not include
|
all columns within the subset then these columns will have the default formatter
|
applied. Any columns in the formatter dict excluded from the subset will
|
be ignored.
|
|
When using a ``formatter`` string the dtypes must be compatible, otherwise a
|
`ValueError` will be raised.
|
|
When instantiating a Styler, default formatting can be applied be setting the
|
``pandas.options``:
|
|
- ``styler.format.formatter``: default None.
|
- ``styler.format.na_rep``: default None.
|
- ``styler.format.precision``: default 6.
|
- ``styler.format.decimal``: default ".".
|
- ``styler.format.thousands``: default None.
|
- ``styler.format.escape``: default None.
|
|
.. warning::
|
`Styler.format` is ignored when using the output format `Styler.to_excel`,
|
since Excel and Python have inherrently different formatting structures.
|
However, it is possible to use the `number-format` pseudo CSS attribute
|
to force Excel permissible formatting. See examples.
|
|
Examples
|
--------
|
Using ``na_rep`` and ``precision`` with the default ``formatter``
|
|
>>> df = pd.DataFrame([[np.nan, 1.0, 'A'], [2.0, np.nan, 3.0]])
|
>>> df.style.format(na_rep='MISS', precision=3) # doctest: +SKIP
|
0 1 2
|
0 MISS 1.000 A
|
1 2.000 MISS 3.000
|
|
Using a ``formatter`` specification on consistent column dtypes
|
|
>>> df.style.format('{:.2f}', na_rep='MISS', subset=[0,1]) # doctest: +SKIP
|
0 1 2
|
0 MISS 1.00 A
|
1 2.00 MISS 3.000000
|
|
Using the default ``formatter`` for unspecified columns
|
|
>>> df.style.format({0: '{:.2f}', 1: '£ {:.1f}'}, na_rep='MISS', precision=1)
|
... # doctest: +SKIP
|
0 1 2
|
0 MISS £ 1.0 A
|
1 2.00 MISS 3.0
|
|
Multiple ``na_rep`` or ``precision`` specifications under the default
|
``formatter``.
|
|
>>> (df.style.format(na_rep='MISS', precision=1, subset=[0])
|
... .format(na_rep='PASS', precision=2, subset=[1, 2])) # doctest: +SKIP
|
0 1 2
|
0 MISS 1.00 A
|
1 2.0 PASS 3.00
|
|
Using a callable ``formatter`` function.
|
|
>>> func = lambda s: 'STRING' if isinstance(s, str) else 'FLOAT'
|
>>> df.style.format({0: '{:.1f}', 2: func}, precision=4, na_rep='MISS')
|
... # doctest: +SKIP
|
0 1 2
|
0 MISS 1.0000 STRING
|
1 2.0 MISS FLOAT
|
|
Using a ``formatter`` with HTML ``escape`` and ``na_rep``.
|
|
>>> df = pd.DataFrame([['<div></div>', '"A&B"', None]])
|
>>> s = df.style.format(
|
... '<a href="a.com/{0}">{0}</a>', escape="html", na_rep="NA"
|
... )
|
>>> s.to_html() # doctest: +SKIP
|
...
|
<td .. ><a href="a.com/<div></div>"><div></div></a></td>
|
<td .. ><a href="a.com/"A&B"">"A&B"</a></td>
|
<td .. >NA</td>
|
...
|
|
Using a ``formatter`` with LaTeX ``escape``.
|
|
>>> df = pd.DataFrame([["123"], ["~ ^"], ["$%#"]])
|
>>> df.style.format("\\textbf{{{}}}", escape="latex").to_latex()
|
... # doctest: +SKIP
|
\begin{tabular}{ll}
|
{} & {0} \\
|
0 & \textbf{123} \\
|
1 & \textbf{\textasciitilde \space \textasciicircum } \\
|
2 & \textbf{\$\%\#} \\
|
\end{tabular}
|
|
Pandas defines a `number-format` pseudo CSS attribute instead of the `.format`
|
method to create `to_excel` permissible formatting. Note that semi-colons are
|
CSS protected characters but used as separators in Excel's format string.
|
Replace semi-colons with the section separator character (ASCII-245) when
|
defining the formatting here.
|
|
>>> df = pd.DataFrame({"A": [1, 0, -1]})
|
>>> pseudo_css = "number-format: 0§[Red](0)§-§@;"
|
>>> filename = "formatted_file.xlsx"
|
>>> df.style.applymap(lambda v: pseudo_css).to_excel(filename) # doctest: +SKIP
|
|
.. figure:: ../../_static/style/format_excel_css.png
|
Nr c s i | ]
|
}| qS r- r- )r¦ rE ©r r- r. Ú
|
<dictcomp>} s z)StylerRenderer.format.<locals>.<dictcomp>©r r? r r r# r )r¾ rj r ÚsliceÚnon_reducing_slicer8 ÚlocrS rà rV Zget_indexer_forrU Ú_maybe_wrap_formatterrÑ )rm r r r r? r r r# r r8 ZcisZrisÚciÚ format_funcÚrir- r r. Úformat sD =øÿ
|
|
ù zStylerRenderer.formatr r úLevel | list[Level] | None)
|
r ÚaxisrI r r? r r r# r r@ c
|
|
s | j ¡ dkr$| j| j }
|
n| j| j }
|
t|} tdk|dk|dk|dk|dk|dk|dk| dkfr|
|
¡ | S t t
|
sfdd| D nfdd ¡ D | D ]Jt ¡|||||| d} fdd ttD D ] } | |
|
| < qôq¸| S )
|
aº
|
Format the text display value of index labels or column headers.
|
|
.. versionadded:: 1.4.0
|
|
Parameters
|
----------
|
formatter : str, callable, dict or None
|
Object to define how values are displayed. See notes.
|
axis : {0, "index", 1, "columns"}
|
Whether to apply the formatter to the index or column headers.
|
level : int, str, list
|
The level(s) over which to apply the generic formatter.
|
na_rep : str, optional
|
Representation for missing values.
|
If ``na_rep`` is None, no special formatting is applied.
|
precision : int, optional
|
Floating point precision to use for display purposes, if not determined by
|
the specified ``formatter``.
|
decimal : str, default "."
|
Character used as decimal separator for floats, complex and integers.
|
thousands : str, optional, default None
|
Character used as thousands separator for floats, complex and integers.
|
escape : str, optional
|
Use 'html' to replace the characters ``&``, ``<``, ``>``, ``'``, and ``"``
|
in cell display string with HTML-safe sequences.
|
Use 'latex' to replace the characters ``&``, ``%``, ``$``, ``#``, ``_``,
|
``{``, ``}``, ``~``, ``^``, and ``\`` in the cell display string with
|
LaTeX-safe sequences.
|
Escaping is done before ``formatter``.
|
hyperlinks : {"html", "latex"}, optional
|
Convert string patterns containing https://, http://, ftp:// or www. to
|
HTML <a> tags as clickable URL hyperlinks if "html", or LaTeX \href
|
commands if "latex".
|
|
Returns
|
-------
|
Styler
|
|
See Also
|
--------
|
Styler.format: Format the text display value of data cells.
|
|
Notes
|
-----
|
This method assigns a formatting function, ``formatter``, to each level label
|
in the DataFrame's index or column headers. If ``formatter`` is ``None``,
|
then the default formatter is used.
|
If a callable then that function should take a label value as input and return
|
a displayable representation, such as a string. If ``formatter`` is
|
given as a string this is assumed to be a valid Python format specification
|
and is wrapped to a callable as ``string.format(x)``. If a ``dict`` is given,
|
keys should correspond to MultiIndex level numbers or names, and values should
|
be string or callable, as above.
|
|
The default formatter currently expresses floats and complex numbers with the
|
pandas display precision unless using the ``precision`` argument here. The
|
default formatter does not adjust the representation of missing values unless
|
the ``na_rep`` argument is used.
|
|
The ``level`` argument defines which levels of a MultiIndex to apply the
|
method to. If the ``formatter`` argument is given in dict form but does
|
not include all levels within the level argument then these unspecified levels
|
will have the default formatter applied. Any levels in the formatter dict
|
specifically excluded from the level argument will be ignored.
|
|
When using a ``formatter`` string the dtypes must be compatible, otherwise a
|
`ValueError` will be raised.
|
|
.. warning::
|
`Styler.format_index` is ignored when using the output format
|
`Styler.to_excel`, since Excel and Python have inherrently different
|
formatting structures.
|
However, it is possible to use the `number-format` pseudo CSS attribute
|
to force Excel permissible formatting. See documentation for `Styler.format`.
|
|
Examples
|
--------
|
Using ``na_rep`` and ``precision`` with the default ``formatter``
|
|
>>> df = pd.DataFrame([[1, 2, 3]], columns=[2.0, np.nan, 4.0])
|
>>> df.style.format_index(axis=1, na_rep='MISS', precision=3) # doctest: +SKIP
|
2.000 MISS 4.000
|
0 1 2 3
|
|
Using a ``formatter`` specification on consistent dtypes in a level
|
|
>>> df.style.format_index('{:.2f}', axis=1, na_rep='MISS') # doctest: +SKIP
|
2.00 MISS 4.00
|
0 1 2 3
|
|
Using the default ``formatter`` for unspecified levels
|
|
>>> df = pd.DataFrame([[1, 2, 3]],
|
... columns=pd.MultiIndex.from_arrays([["a", "a", "b"],[2, np.nan, 4]]))
|
>>> df.style.format_index({0: lambda v: upper(v)}, axis=1, precision=1)
|
... # doctest: +SKIP
|
A B
|
2.0 nan 4.0
|
0 1 2 3
|
|
Using a callable ``formatter`` function.
|
|
>>> func = lambda s: 'STRING' if isinstance(s, str) else 'FLOAT'
|
>>> df.style.format_index(func, axis=1, na_rep='MISS')
|
... # doctest: +SKIP
|
STRING STRING
|
FLOAT MISS FLOAT
|
0 1 2 3
|
|
Using a ``formatter`` with HTML ``escape`` and ``na_rep``.
|
|
>>> df = pd.DataFrame([[1, 2, 3]], columns=['"A"', 'A&B', None])
|
>>> s = df.style.format_index('$ {0}', axis=1, escape="html", na_rep="NA")
|
... # doctest: +SKIP
|
<th .. >$ "A"</th>
|
<th .. >$ A&B</th>
|
<th .. >NA</td>
|
...
|
|
Using a ``formatter`` with LaTeX ``escape``.
|
|
>>> df = pd.DataFrame([[1, 2, 3]], columns=["123", "~", "$%#"])
|
>>> df.style.format_index("\\textbf{{{}}}", escape="latex", axis=1).to_latex()
|
... # doctest: +SKIP
|
\begin{tabular}{lrrr}
|
{} & {\textbf{123}} & {\textbf{\textasciitilde }} & {\textbf{\$\%\#}} \\
|
0 & 1 & 2 & 3 \\
|
\end{tabular}
|
r Nr c s i | ]
|
}| qS r- r- )r¦ rI r r- r. r 5 s z/StylerRenderer.format_index.<locals>.<dictcomp>c s i | ]\}} |¡|qS r- )Ú_get_level_number)r¦ rI Z
|
formatter_©rä r- r. r 7 s ÿ r
|
c s$ g | ] } d kr|fn|fqS rÚ r- rû )r r r- r. r§ G s z/StylerRenderer.format_index.<locals>.<listcomp>)r8 Ú_get_axis_numberrk rU rl rV Úrefactor_levelsr¾ r rS rà rz r rÑ ré rY )rm r r rI r r? r r r# r Údisplay_funcs_Úlevels_r Úidxr- )r r r rä r. Ú format_index sJ
|
øÿ
|
|
þù
|
zStylerRenderer.format_indexzSequence | Index)Úlabelsr rI r@ c sh | j |¡}|dkr2| j| j }}| j| j n | j| j }}| j| j t
|
|t
|
t }t
|
||kr~t d| d|dkrfddt |jD }t||}dd }t fd dt t
|
|D D ]\} }
|
t
|
|d
|
kr |dk rú|
|
|d fn
|
|d |
|
f} t||| d || < qÎt|D ]<\} } |dkr>|
|
| fn| |
|
f} t||| | d || < q$qÎ| S ) aa
|
Relabel the index, or column header, keys to display a set of specified values.
|
|
.. versionadded:: 1.5.0
|
|
Parameters
|
----------
|
labels : list-like or Index
|
New labels to display. Must have same length as the underlying values not
|
hidden.
|
axis : {"index", 0, "columns", 1}
|
Apply to the index or columns.
|
level : int, str, list, optional
|
The level(s) over which to apply the new labels. If `None` will apply
|
to all levels of an Index or MultiIndex which are not hidden.
|
|
Returns
|
-------
|
Styler
|
|
See Also
|
--------
|
Styler.format_index: Format the text display value of index or column headers.
|
Styler.hide: Hide the index, column headers, or specified data from display.
|
|
Notes
|
-----
|
As part of Styler, this method allows the display of an index to be
|
completely user-specified without affecting the underlying DataFrame data,
|
index, or column headers. This means that the flexibility of indexing is
|
maintained whilst the final display is customisable.
|
|
Since Styler is designed to be progressively constructed with method chaining,
|
this method is adapted to react to the **currently specified hidden elements**.
|
This is useful because it means one does not have to specify all the new
|
labels if the majority of an index, or column headers, have already been hidden.
|
The following produce equivalent display (note the length of ``labels`` in
|
each case).
|
|
.. code-block:: python
|
|
# relabel first, then hide
|
df = pd.DataFrame({"col": ["a", "b", "c"]})
|
df.style.relabel_index(["A", "B", "C"]).hide([0,1])
|
# hide first, then relabel
|
df = pd.DataFrame({"col": ["a", "b", "c"]})
|
df.style.hide([0,1]).relabel_index(["C"])
|
|
This method should be used, rather than :meth:`Styler.format_index`, in one of
|
the following cases (see examples):
|
|
- A specified set of labels are required which are not a function of the
|
underlying index keys.
|
- The function of the underlying index keys requires a counter variable,
|
such as those available upon enumeration.
|
|
Examples
|
--------
|
Basic use
|
|
>>> df = pd.DataFrame({"col": ["a", "b", "c"]})
|
>>> df.style.relabel_index(["A", "B", "C"]) # doctest: +SKIP
|
col
|
A a
|
B b
|
C c
|
|
Chaining with pre-hidden elements
|
|
>>> df.style.hide([0,1]).relabel_index(["C"]) # doctest: +SKIP
|
col
|
C c
|
|
Using a MultiIndex
|
|
>>> midx = pd.MultiIndex.from_product([[0, 1], [0, 1], [0, 1]])
|
>>> df = pd.DataFrame({"col": list(range(8))}, index=midx)
|
>>> styler = df.style # doctest: +SKIP
|
col
|
0 0 0 0
|
1 1
|
1 0 2
|
1 3
|
1 0 0 4
|
1 5
|
1 0 6
|
1 7
|
>>> styler.hide((midx.get_level_values(0)==0)|(midx.get_level_values(1)==0))
|
... # doctest: +SKIP
|
>>> styler.hide(level=[0,1]) # doctest: +SKIP
|
>>> styler.relabel_index(["binary6", "binary7"]) # doctest: +SKIP
|
col
|
binary6 6
|
binary7 7
|
|
We can also achieve the above by indexing first and then re-labeling
|
|
>>> styler = df.loc[[(1,1,0), (1,1,1)]].style
|
>>> styler.hide(level=[0,1]).relabel_index(["binary6", "binary7"])
|
... # doctest: +SKIP
|
col
|
binary6 6
|
binary7 7
|
|
Defining a formatting function which uses an enumeration counter. Also note
|
that the value of the index key is passed in the case of string labels so it
|
can also be inserted into the label, using curly brackets (or double curly
|
brackets if the string if pre-formatted),
|
|
>>> df = pd.DataFrame({"samples": np.random.rand(10)})
|
>>> styler = df.loc[np.random.randint(0,10,3)].style
|
>>> styler.relabel_index([f"sample{i+1} ({{}})" for i in range(3)])
|
... # doctest: +SKIP
|
samples
|
sample1 (5) 0.315811
|
sample2 (0) 0.495941
|
sample3 (2) 0.067946
|
r zS``labels`` must be of length equal to the number of visible labels along ``axis`` (z).Nc s g | ]} | s|qS r- r- rû )Ú hidden_lvlsr- r. r§ × s z0StylerRenderer.relabel_index.<locals>.<listcomp>c S s t |tr| | ¡S |S ©N)rS r% r )r¸ rÕ r- r- r. Úalias_Ú s
|
|
z,StylerRenderer.relabel_index.<locals>.alias_c s g | ]}| kr|qS r- r- rû )Ú hidden_labelsr- r. r§ ß s r¶ )rÕ )r8 r rk rU ra r_ rl rV rb r` rY Úsetrþ ré r^ r rw r )rm r r rI r rä Z visible_lenr r Zair} r Zajr r- )r! r r. Ú relabel_indexL s. |
|
ÿ
|
&" z StylerRenderer.relabel_index)Nr2 NNNTN)NNro )NN)NN)NNr N)Nrá )NNNNr NNN) Nr NNNr NNN)r N)!r) r* r+ Ú__doc__r Z PackageLoaderr1 Ú EnvironmentÚenvZ get_templater
r r r r rn rx r r r rv r{ rª r» r¿ r¬ rÒ rç rÝ r r r r# r- r- r- r. r/ D s
|
|
|
|
|
÷ G ú1 û û ùp<]=4 ù (6qh ÷ f ö" @ ür/ r% r3 r r5 rà )Ú html_elementÚ
|
html_classrÕ rî r@ c K s" d|kr||d< | |||d|S )z]
|
Template to return container with information for a <td></td> or <th></th> element.
|
rÊ )rù rÕ Úclassrî r- )r' r( rÕ rî r r- r- r. rÎ ë s
|
üûrÎ çé?Úfloatztuple[int, int])Úscaling_factorr@ c sX fdd}|r | |kr |n| } |r4||kr0|n|}| | |krP|| |\} }q4| |fS )a:
|
Recursively reduce the number of rows and columns to satisfy max elements.
|
|
Parameters
|
----------
|
rn, cn : int
|
The number of input rows / columns
|
max_elements : int
|
The number of allowable elements
|
max_rows, max_cols : int, optional
|
Directly specify an initial maximum rows or columns before compression.
|
scaling_factor : float
|
Factor at which to reduce the number of rows / columns to fit.
|
|
Returns
|
-------
|
rn, cn : tuple
|
New rn and cn values that satisfy the max_elements constraint
|
c s, || kr| t | fS t | |fS d S r )r4 )rÿ Úcn©r, r- r. Ú
|
scale_down s z*_get_trimming_maximums.<locals>.scale_downr- )rÿ r- r° rr rs r, r/ r- r. r. r© s r© r r4 zSequence[int] | None)rU ÚsparsifyÚ max_indexÚhidden_elementsc C st t | tr | jtjdd}n| ¡ }|dkr0g }i }t | tsht|D ] \}}||krFd|d|f< qF|S t|D ]ì\}}d} t|D ]Ö\}
|
} | |kr qp|sº|
|
|kr¸d|||
|
f< | d7 } q| tjk ræ|
|
|kræ|
|
} d||| f< | d7 } q| tjk r|
|
} d||| f< q|
|
|kr| d7 } | |kr" qp||| f dkrF|
|
} d||| f< q||| f d7 < qqpdd | ¡ D } | S )aZ
|
Given an index, find the level length for each element.
|
|
Parameters
|
----------
|
index : Index
|
Index or columns to determine lengths of each element
|
sparsify : bool
|
Whether to hide or show each distinct element in a MultiIndex
|
max_index : int
|
The maximum number of elements to analyse along the index due to trimming
|
hidden_elements : sequence of int
|
Index positions of elements hidden from display in the index affecting
|
length
|
|
Returns
|
-------
|
Dict :
|
Result is a dictionary of (level, initial_position): span
|
F)r0 ZadjoinNr¶ r c S s i | ]\}}|d kr||qS )r¶ r- )r¦ rå Úlengthr- r- r. r w s z&_get_level_lengths.<locals>.<dictcomp>)rS r r r Z
|
no_defaultrw rz )rU r0 r1 r2 ÚlevelsÚlengthsr} rÕ r rß ÚjrF Z
|
last_labelZnon_zero_lengthsr- r- r. r« - sN
|
|
|
|
|
ÿr« ©r@ c C s || f|kS )z/
|
Index -> {(idx_row, idx_col): bool}).
|
r- )Zidx_rowZidx_colr5 r- r- r. rÐ ~ s rÐ Ú CSSStyles)Ústylesr@ c C s dd | D S )zÒ
|
looks for multiple CSS selectors and separates them:
|
[{'selector': 'td, th', 'props': 'a:v;'}]
|
---> [{'selector': 'td', 'props': 'a:v;'},
|
{'selector': 'th', 'props': 'a:v;'}]
|
c S s. g | ]&}|d d¡D ]}||d dqqS )r& ú,r( ©r& r( )Úsplit)r¦ Zcss_dictr& r- r- r. r§ s þz'format_table_styles.<locals>.<listcomp>r- )r9 r- r- r. r¨
s þr¨ F)r¸ r? r r@ c C sT t | st| r4|r$| d| dS | d| dS t| rP|rH| dS | dS | S )aµ
|
Format the display of a value
|
|
Parameters
|
----------
|
x : Any
|
Input variable to be formatted
|
precision : Int
|
Floating point precision used if ``x`` is float or complex.
|
thousands : bool, default False
|
Whether to group digits with thousands separated with ",".
|
|
Returns
|
-------
|
value : Any
|
Matches input type, or string if input is float or complex or int with sep.
|
z,.Úfr z,.0fz.0f)r r r )r¸ r? r r- r- r. rP s
|
$rP r )r r r r@ c s fdd}|S )zÉ
|
Takes a string formatting function and wraps logic to deal with thousands and
|
decimal parameters, in the case that they are non-standard and that the input
|
is a (float, complex, int).
|
c s¨ t | st| st| r dkrPd k rPdkrP| dd¡ d ¡ d¡S dkrxd kshdkrx| d ¡S dkr d k r dkr | d¡S | S )Nr r: u §_§-)r r r r¯ ©r¸ ©r r r r- r. Úwrapperµ s$ ÿ þ ýÿz(_wrap_decimal_thousands.<locals>.wrapperr- )r r r r@ r- r? r. Ú_wrap_decimal_thousands¬ s rA c C s< t | tr8|dkrt| S |dkr*t| S td| | S )z/if escaping: only use on str, else return inputÚhtmlÚlatexz2`escape` only permitted in {'html', 'latex'}, got )rS r% Ú escape_htmlÚ _escape_latexrþ )r¸ r# r- r- r. Ú _str_escapeÇ s
|
ÿrF c sL t | trH|dkrd n|dkr&d ntdd}t | fdd| ¡S | S ) zMuses regex to detect a common URL pattern and converts to href tag in format.rB z%<a href="{0}" target="_blank">{0}</a>rC z\href{{{0}}}{{{0}}}z3``hyperlinks`` format can only be 'html' or 'latex'zE((http|ftp)s?:\/\/|www.)[\w/\-?=%.:@]+\.[\w/\-&?=%.,':;~!@#$*()\[\]]+c s | d¡¡S r÷ )r Úgroup)Úm©Úhrefr- r. rQ ß rR z _render_href.<locals>.<lambda>)rS r% rþ ÚreÚsub)r¸ r Úpatr- rI r. Ú _render_hrefÕ s
|
rN r zBaseFormatter | Noner6 )r r r? r r r# r r@ c sê t trfddnPtr&nBdkrV|dkr>tdn|}tt||dk dntdt dk r fdd}n}|dks|dk r¬|d kr¬t|||d
|
n|dk rÈfd dndkrØS fd dS dS ) zº
|
Allows formatters to be expressed as str, callable or None, where None returns
|
a default formatting function. wraps with na_rep, and precision where they are
|
available.
|
c s
|
| ¡S r ©r r> r r- r. rQ ó rR z'_maybe_wrap_formatter.<locals>.<lambda>NrL )r? r z*'formatter' expected str or callable, got c s t | dS )Nr" )rF r> )r# Úfunc_0r- r. rQ rR r r: )r r c s t | dS )NrO )rN r> )Úfunc_2r r- r. rQ rR c s t | dkrS | S )NT)r r> )Úfunc_3r r- r. rQ rR ) rS r% Úcallabler r rP rT rù rA )r r r? r r r# r Zfunc_1r- )r# r rP rQ rR r r r. r ã s2
|
ÿ ÿr ÚSubset)Úslice_c sv t tjtttf}t| |r*tdd
| f } dddd t| s\t| t sT| gg} qn| g} n fdd| D } t
|
| S )z¶
|
Ensure that a slice doesn't reduce to a Series or Scalar.
|
|
Any user-passed `subset` should have this called on it
|
to make sure we're always working with DataFrames.
|
Nr5 r7 c S s2 t | tr tdd | D S t | tp,t| S dS )z
|
Returns
|
-------
|
bool
|
True if slice does *not* reduce,
|
False if `part` is a tuple.
|
c s s | ]}t |tpt|V qd S r )rS r r )r¦ Úsr- r- r. Ú <genexpr>2 s z3non_reducing_slice.<locals>.pred.<locals>.<genexpr>N)rS r Úanyr r )Úpartr- r- r. Úpred& s
|
|
z non_reducing_slice.<locals>.predc s g | ]} |r|n|gqS r- r- )r¦ Úp©rZ r- r. r§ @ s z&non_reducing_slice.<locals>.<listcomp>) r ÚnpZndarrayr rc r% rS r r r r )rU Úkindsr- r\ r. r s
|
|
|
r r' ÚCSSList)Ústyler@ c C sN t | trJ| d¡}zdd |D W S tk
|
rH td| dY nX | S )zÌ
|
Convert css-string to sequence of tuples format if needed.
|
'color:red; border:1px solid black;' -> [('color', 'red'),
|
('border','1px solid red')]
|
ú;c S s< g | ]4}| ¡ d kr| d¡d ¡ | d¡d ¡ fqS )ro ú:r r¶ )Ústripr< r· r- r- r. r§ M s þz/maybe_convert_css_to_tuples.<locals>.<listcomp>zSStyles supplied as string must follow CSS rule formats, for example 'attr: val;'. 'z ' was given.)rS r% r< Ú
|
IndexErrorrþ )r` rV r- r- r. Úmaybe_convert_css_to_tuplesD s
|
|
þ
|
ÿ
|
re r z list[int])rI rä r@ c sl | dkrt t j}nPt| tr*| g}n>t| trB | ¡g}n&t| t r` fdd| D }ntd|S )aX
|
Returns a consistent levels arg for use in ``hide_index`` or ``hide_columns``.
|
|
Parameters
|
----------
|
level : int, str, list
|
Original ``level`` arg supplied to above methods.
|
obj:
|
Either ``self.index`` or ``self.columns``
|
|
Returns
|
-------
|
list : refactored arg with a list of levels to hide
|
Nc s$ g | ] }t |ts |¡n|qS r- )rS r4 r )r¦ Zlevr r- r. r§ s s ÿz#refactor_levels.<locals>.<listcomp>z4`level` must be of type `int`, `str` or list of such)rc ré r^ rS r4 r% r rþ )rI rä r r- r r. r Z s
|
|
|
|
þr c @ sl e Zd ZdZddddddgde fd d
|
d d d ddZedd Zd
|
d
|
ddd
|
dddZdddddZ dS ) ÚTooltipsa
|
An extension to ``Styler`` that allows for and manipulates tooltips on hover
|
of ``<td>`` cells in the HTML result.
|
|
Parameters
|
----------
|
css_name: str, default "pd-t"
|
Name of the CSS class that controls visualisation of tooltips.
|
css_props: list-like, default; see Notes
|
List of (attr, value) tuples defining properties of the CSS class.
|
tooltips: DataFrame, default empty
|
DataFrame of strings aligned with underlying Styler data for tooltip
|
display.
|
|
Notes
|
-----
|
The default properties for the tooltip CSS class are:
|
|
- visibility: hidden
|
- position: absolute
|
- z-index: 1
|
- background-color: black
|
- color: white
|
- transform: translate(-20px, -20px)
|
|
Hidden visibility is a key prerequisite to the hover functionality, and should
|
always be included in any manual properties specification.
|
)Ú
|
visibilityÚhidden)ÚpositionÚabsolute)zz-indexr¶ )úbackground-colorZblack)ÚcolorZwhite)Z transformztranslate(-20px, -20px)zpd-tr' r% r r7 )Ú css_propsÚcss_nameri r@ c C s || _ || _|| _g | _d S r )Ú
|
class_nameÚclass_propertiesÚtt_datar; )rm rm rn ri r- r- r. rn s zTooltips.__init__c C s d| j t| jdgS )a
|
Combine the ``_Tooltips`` CSS class name and CSS properties to the format
|
required to extend the underlying ``Styler`` `table_styles` to allow
|
tooltips to render in HTML.
|
|
Returns
|
-------
|
styles : List
|
r r; )ro re rp rÙ r- r- r. Ú _class_styles¬ s
|
þÿzTooltips._class_stylesr4 )r9 rÓ rF rE Útextc C sZ d| d t | d t | }|d| dgd|d| d d d
|
| d
|
fgdgS ) a:
|
For every table data-cell that has a valid tooltip (not None, NaN or
|
empty string) must create two pseudo CSS entries for the specific
|
<td> element id which are added to overall table styles:
|
an on hover visibility change and a content change
|
dependent upon the user's chosen display string.
|
|
For example:
|
[{"selector": "T__row1_col1:hover .pd-t",
|
"props": [("visibility", "visible")]},
|
{"selector": "T__row1_col1 .pd-t::after",
|
"props": [("content", "Some Valid Text String")]}]
|
|
Parameters
|
----------
|
uuid: str
|
The uuid of the Styler instance
|
name: str
|
The css-name of the class used for styling tooltips
|
row : int
|
The row index of the specified tooltip string data
|
col : int
|
The col index of the specified tooltip string data
|
text : str
|
The textual content of the tooltip to be displayed in HTML.
|
|
Returns
|
-------
|
pseudo_css : List
|
z#T_ru Z_colz:hover .)rg Zvisibler; z .z::afterÚcontentrÈ )r% )rm r9 rÓ rF rE rs Z selector_idr- r- r. Ú _pseudo_css¾ s þþûzTooltips._pseudo_cssr/ rà )Ústylerr c sÔ j j¡_ j jr |S jj ¡ j d¡B dd fddttj j D D _
|
j
|
rÐ|d D ]8}|D ].}|d dkr~t |d d j d
|
|d< q~qv|d j ¡ |d j
|
¡ |S ) a=
|
Mutate the render dictionary to allow for tooltips:
|
|
- Add ``<span>`` HTML element to each data cells ``display_value``. Ignores
|
headers.
|
- Add table level CSS styles to control pseudo classes.
|
|
Parameters
|
----------
|
styler_data : DataFrame
|
Underlying ``Styler`` DataFrame used for reindexing.
|
uuid : str
|
The underlying ``Styler`` uuid for CSS id.
|
d : dict
|
The dictionary prior to final render
|
|
Returns
|
-------
|
render_dict : Dict
|
ro c S s g | ]}|D ]}|q qS r- r- )r¦ Zsublistr` r- r- r. r§ s
|
õz'Tooltips._translate.<locals>.<listcomp>c sh g | ]`}t tjjD ]J} j||f s|jks|jks j||t jj||f ¡qqS r- )
|
ré rY rq rV Zilocra rb ru r9 r% )r¦ r} r6 ©ÚmaskrÓ rm rv r- r. r§ s
|
|
úr rù rè rÊ z <span class="z "></span>r; )rq Z reindex_liker8 Úemptyro r Úeqré rY rU r; r% r® rr )rm rv r rF Úitemr- rw r. r{ é s* þþ
|
ÿÿ
|
zTooltips._translateN)
|
r) r* r+ r$ r rn Úpropertyrr ru r{ r- r- r- r. rf | s úõ
|
+rf )r; r= r@ c s2 ddddg | dk r*t fdd| D p0|dk S )a8
|
Indicate whether LaTeX {tabular} should be wrapped with a {table} environment.
|
|
Parses the `table_styles` and detects any selectors which must be included outside
|
of {tabular}, i.e. indicating that wrapping must occur, and therefore return True,
|
or if a caption exists and requires similar.
|
ZtopruleZmidruleZ
|
bottomruleZ column_formatNc 3 s | ]}|d kV qdS )r& Nr- )r¦ r ©ZIGNORED_WRAPPERSr- r. rW . s z._parse_latex_table_wrapping.<locals>.<genexpr>)rX )r; r= r- r} r. r " s þýr )r; r& r@ c C sD | ddd
D ]0}|d |krt |d d d dd¡ S qdS ) uy
|
Return the first 'props' 'value' from ``tables_styles`` identified by ``selector``.
|
|
Examples
|
--------
|
>>> table_styles = [{'selector': 'foo', 'props': [('attr','value')]},
|
... {'selector': 'bar', 'props': [('attr', 'overwritten')]},
|
... {'selector': 'bar', 'props': [('a1', 'baz'), ('a2', 'ignore')]}]
|
>>> _parse_latex_table_styles(table_styles, selector='bar')
|
'baz'
|
|
Notes
|
-----
|
The replacement of "§" with ":" is to avoid the CSS problem where ":" has structural
|
significance and cannot be used in LaTeX labels, but is often required by them.
|
Néÿÿÿÿr& r( r r¶ õ §rb )r% r¯ )r; r& r` r- r- r. r 2 s "r )Ú latex_stylesrÊ Ú convert_cssr@ c
|
C sÀ |r t | } | ddd
D ] \}}d| d| dd| d| d| d| d| d| dd| d | dd
|
}d| | d | }d D ],}|t|kr|| d t||d¡} qqq|S )a
|
Mutate the ``display_value`` string including LaTeX commands from ``latex_styles``.
|
|
This method builds a recursive latex chain of commands based on the
|
CSSList input, nested around ``display_value``.
|
|
If a CSS style is given as ('<command>', '<options>') this is translated to
|
'\<command><options>{display_value}', and this value is treated as the
|
display value for the next iteration.
|
|
The most recent style forms the inner component, for example for styles:
|
`[('c1', 'o1'), ('c2', 'o2')]` this returns: `\c1o1{\c2o2{display_value}}`
|
|
Sometimes latex commands have to be wrapped with curly braces in different ways:
|
We create some parsing flags to identify the different behaviours:
|
|
- `--rwrap` : `\<command><options>{<display_value>}`
|
- `--wrap` : `{\<command><options> <display_value>}`
|
- `--nowrap` : `\<command><options> <display_value>`
|
- `--lwrap` : `{\<command><options>} <display_value>`
|
- `--dwrap` : `{\<command><options>}{<display_value>}`
|
|
For example for styles:
|
`[('c1', 'o1--wrap'), ('c2', 'o2')]` this returns: `{\c1o1 \c2o2{display_value}}
|
Nr~ z{\z --to_parse rý ú\z --to_parse} z --to_parse{z --to_parse}{)ú--wrapú--nowrapú--lwrapú--rwrapú--dwraprÆ )r r r
r r z
|
--to_parse©rÕ Úarg)Ú_parse_latex_css_conversionr% r¯ Ú_parse_latex_options_strip)r rÊ r ÚcommandÚoptionsr r r- r- r. r I s$ û
|
ÿr zdict[str, Any])ÚcellÚmultirow_alignÚmulticol_alignÚwrapr r@ c C s\ t | d | d |}d| krB| d }d|kræ|| d¡d d
}t|d| d¡
}d|kr|rrd | d
|
n| }|rd nd } || |d S d|krÎ|r¬d | d
|
n| }|rºdnd} | |d | S d| d| d| d
|
S d|krB|dk rþ|S || d¡d d
}
|
t|
|
d|
|
d¡
}
|
d| d|
|
d| d
|
S |rTd | d
|
S |S dS )aè
|
Refactor the cell `display_value` if a 'colspan' or 'rowspan' attribute is present.
|
|
'rowspan' and 'colspan' do not occur simultaneouly. If they are detected then
|
the `display_value` is altered to a LaTeX `multirow` or `multicol` command
|
respectively, with the appropriate cell-span.
|
|
``wrap`` is used to enclose the `display_value` in braces which is needed for
|
column headers using an siunitx package.
|
|
Requires the package {multirow}, whereas multicol support is usually built in
|
to the {tabular} environment.
|
|
Examples
|
--------
|
>>> cell = {'cellstyle': '', 'display_value':'text', 'attributes': 'colspan="3"'}
|
>>> _parse_latex_header_span(cell, 't', 'c')
|
'\\multicolumn{3}{c}{text}'
|
r£ rÊ rË rÇ é NrÈ znaive-lÚ{rý z & {}z &r¶ znaive-rz{} & z& z \multicolumn{z}{rì Znaivez
|
\multirow[z]{z}{*}{)r Úfindr4 ) r r r r r Z display_valÚattrsZcolspanÚoutZblanksZrowspanr- r- r. r y s8 ÿ
|
|
|
r z str | float)rÕ r r@ c C s$ t | |d¡ dd¡ dd¡ ¡ S )zÐ
|
Strip a css_value which may have latex wrapping arguments, css comment identifiers,
|
and whitespaces, to a valid string for latex options parsing.
|
|
For example: 'red /* --wrap */ ' --> 'red'
|
ro z/*z*/)r% r¯ rc r r- r- r. r ° s r c C sÐ dd }dd }dd }|t |ddd t |d
|
d d |d }g }| D ]\}}t|trrd |krr| || d d ¡f¡ ||krBd }dD ]$} | t|kr| t|| }} q¨q|| ||}
|
|
|
dk rB| |
|
g¡ qB|S )z²
|
Convert CSS (attribute,value) pairs to equivalent LaTeX (command,options) pairs.
|
|
Ignore conversion if tagged with `--latex` option, skipped if no conversion found.
|
c S s | dkrd| fS d S )N)ZboldZbolderZbfseriesr- r r- r- r. Ú font_weightÁ s
|
z0_parse_latex_css_conversion.<locals>.font_weightc S s( | dkrd| fS | dkr$d| fS d S )NZitalicZitshapeZobliqueZslshaper- r r- r- r. Ú
|
font_styleÆ s
|
|
|
z/_parse_latex_css_conversion.<locals>.font_stylec S sÔ |dkr |n|}| d dkrHt | dkrH|d| dd
¡ d| fS | d dkr¨t | d kr¨| d ¡ d
|
| d
|
¡ d
|
| d ¡ d
|
}|d| d| fS | dd
d kr¼t d | ¡d ¡ }d|krêt|dd
d n
|
t|d }t d| ¡d ¡ }d|kr(t|dd
d n
|
t|d }| d dkrXt d| ¡d ¡ }nt d| ¡d ¡ }d|krt|dd
d n
|
t|d }|d|dd|dd|dd| fS |d| d| fS dS )aË
|
CSS colors have 5 formats to process:
|
|
- 6 digit hex code: "#ff23ee" --> [HTML]{FF23EE}
|
- 3 digit hex code: "#f0e" --> [HTML]{FF00EE}
|
- rgba: rgba(128, 255, 0, 0.5) --> [rgb]{0.502, 1.000, 0.000}
|
- rgb: rgb(128, 255, 0,) --> [rbg]{0.502, 1.000, 0.000}
|
- string: red --> {red}
|
|
Additionally rgb or rgba can be expressed in % which is also parsed.
|
ro r ú#é z[HTML]{r¶ Nrý é é é Zrgbz(?<=\()[0-9\s%]+(?=,)ú%r~ éd éÿ z(?<=,)[0-9\s%]+(?=,)Úaz(?<=,)[0-9\s%]+(?=\))z[rgb]{z.3fz, r )rY ÚupperrK Úfindallrc r+ r4 ) rÕ Zuser_argr Úcomm_argr Úvalr ÚgÚbr- r- r. rl Í s" 4(**&z*_parse_latex_css_conversion.<locals>.colorZ cellcolorr
)r r¤ rl ro )z font-weightrk rl z
|
font-stylez--latex)r r r
r r N)r rS r% ry r¯ r r® ) r9 r r rl ZCONVERTED_ATTRIBUTESr Ú attributerÕ r r¸ Z latex_styler- r- r. r º s, " ü r c C st | dd¡ dd¡ dd¡ dd¡ d d
|
¡ d d ¡ d d¡ dd¡ dd¡ dd¡ dd¡ dd¡ dd¡ dd¡S ) al
|
Replace the characters ``&``, ``%``, ``$``, ``#``, ``_``, ``{``, ``}``,
|
``~``, ``^``, and ``\`` in the string with LaTeX-safe sequences.
|
|
Use this if you need to display text that might contain such characters in LaTeX.
|
|
Parameters
|
----------
|
s : str
|
Input to be escaped
|
|
Return
|
------
|
str :
|
Escaped string
|
r u ab2§=§8yzu ab2§=§8yz u ab2§=§8yz\space ú&z\&r z\%ú$z\$r z\#rÌ z\_r z\{rý z\}z~ z~\space ú~z\textasciitilde z^ z^\space ú^z\textasciicircum z\textbackslash )r¯ )rV r- r- r. rE sR ÿ þ ý ü û ú ù ø ÷
|
ö õ ô óÿrE )NNr* )N)F)NNNr NNN)F)FF)WÚ
|
__future__r Ú collectionsr Ú functoolsr rK Útypingr r r r r r
|
r r r r r9 r Únumpyr] Zpandas._configr Z pandas._libsr Zpandas._typingr r Zpandas.compat._optionalr Zpandas.core.dtypes.commonr r r Zpandas.core.dtypes.genericr r0 r r r r r r Zpandas.api.typesr Zpandas.core.commonÚcoreÚcommonr½ r Z
|
markupsafer# rD r% Z BaseFormatterZ ExtFormatterr+ ZCSSPairr_ r' r$ r8 r rT r/ rÎ r© r« rÐ r¨ rP rA rF rN r r re r rf r r r r r r rE r- r- r- r. Ú<module> s 0 2 ú1 üQ ù 6+" ' ÿ4 û7
|
L
|
