Parameters

df : DataFrame or Styler

na_rep: na representation :

float_format : str, default None

Format string for floating point numbers

cols : sequence, optional

Columns to write

header : bool or sequence of str, default True

Write out column names. If a list of string is given it is assumed to be aliases for the column names

index : bool, default True

output row names (index)

index_label : str or sequence, default None

Column label for index column(s) if desired. If None is given, and :None:None:`header` and :None:None:`index` are True, then the index names are used. A sequence should be given if the DataFrame uses MultiIndex.

merge_cells : bool, default False

Format MultiIndex and Hierarchical Rows as merged cells.

inf_rep : str, default `'inf'`

representation for np.inf values (which aren't representable in Excel) A :None:None:`'-'` sign will be added in front of -inf.

style_converter : callable, optional

This translates Styler styles (CSS) into ExcelWriter styles. Defaults to CSSToExcelConverter() . It should have signature css_declarations string -> excel style. This is only called for body cells.

Class for formatting a DataFrame to a list of ExcelCells,

Examples

See :

Local connectivity graph

Hover to see nodes names; edges to Self not shown, Caped at 50 nodes.

Using a canvas is more power efficient and can get hundred of nodes ; but does not allow hyperlinks; , arrows or text (beyond on hover)

SVG is more flexible but power hungry; and does not scale well to 50 + nodes.

All aboves nodes referred to, (or are referred from) current nodes; Edges from Self to other have been omitted (or all nodes would be connected to the central node "self" which is not useful). Nodes are colored by the library they belong to, and scaled with the number of references pointing them

---

File: /pandas/io/formats/excel.py#441
type: <class 'type'>
Commit: