HtmlTablePivot Module

class epyk.core.html.tables.HtmlTablePivot.PivotAggregator(page: PageModel, options: Union[OptionsPivot, dict])
absSum(col1: str)
Parameters:

col1 –

custom(name: str, js_def: str)

Add a custom aggregator function.

Related Pages:

Parameters:

  • name – The function name.

  • js_def – The function definition

diffAbsolute(col1: str, col2: str, formula: str = '+= col1 - col2')
Parameters:

  • col1 – The column name.

  • col2 – The column name.

  • formula – The formula to be applied.

max(col1: str)
Parameters:

col1 – The column name.

min(col1: str)
Parameters:

col1 – The column name.

quick(col1: str, name: str, formula: str)

Add a fix formula without input options.

Usage:

tb = page.ui.tables.pivot(languages, ['name'], ['type'])
tb.aggregators.quick("change", "Abs Change", "+= Math.abs(col1)")
Parameters:

  • col1 – The column name.

  • name – The function name.

  • formula – The formula to be applied.

singleFactorFormulas(col1: str, formula: str, name: str)

TODO: Find way to set the column name on init

Usage:

tb = page.ui.tables.pivot(languages, ['name'], ['type'])
tb.aggregators.absSum('rating')
Parameters:

  • col1 – The column name.

  • formula – The formula to be applied.

  • name – The function name.

sum(col1: str)
Parameters:

col1 – The column name.

sumOverSum(cols: list)
Parameters:

cols – The columns to be added up.

twoFactorFormulas(col1: str, col2: str, name: str, formula: str)

Create a two factor function.

TODO: Find way to set the column name on init

Usage:

tb = page.ui.tables.pivot(languages, ['name'], ['type'])
tb.aggregators.diffAbsolute('change', 'rating')
Parameters:

  • col1 – The column name.

  • col2 – The column name.

  • name – The function name.

  • formula – The formula to be applied.

class epyk.core.html.tables.HtmlTablePivot.PivotRenderer(page: PageModel, options: Union[OptionsPivot, dict])
property c3: PivotRendererC3

Property to use the C3 special renderers.

custom(name, js_def)

https://github.com/nicolaskruchten/pivottable/wiki/Renderers

Parameters:

  • name –

  • js_def –

property plotly: PivotRendererPlotly

Property to use the Plotly special renderers.

treemap()

https://pivottable.js.org/examples/plotly.html

class epyk.core.html.tables.HtmlTablePivot.PivotRendererC3(page: PageModel, options: dict)
area()

Area chart from C3.

Related Pages:

bar()

Horizontal bar chart from C3.

Related Pages:

hbar()

Stacked bar chart from C3.

Related Pages:

line()

Line chart from C3.

Related Pages:

scatter()

Scatter chart from C3.

Related Pages:

stacked()

Stacked bar chart from C3.

Related Pages:

class epyk.core.html.tables.HtmlTablePivot.PivotRendererPlotly(page: PageModel, options: dict)
area()

Area chart from Plotly.

Related Pages:

bar()

Bar chart from Plotly.

Related Pages:

hbar()

Horizontal Bar chart from Plotly.

Related Pages:

line()

Line chart from Plotly.

Related Pages:

pies()

Multiple Pies charts from Plotly.

Related Pages:

scatter()

Scatter chart from Plotly.

Related Pages:

class epyk.core.html.tables.HtmlTablePivot.PivotTable(page: PageModel, records, rows, cols, width, height, html_code, helper, options, profile)
property options: OptionsPivot

Pivot Table options.

property style: Pivot

Property to the CSS Style of the component.

class epyk.core.html.tables.HtmlTablePivot.PivotUITable(page: PageModel, records, rows, cols, width, height, html_code, helper, options, profile)
property options: OptionsPivotUI

Pivot Table options