def test_multi_index_df_to_jinja_table():
# Create multi-index table
idx = np.array([['super1', 'super1', 'super1', 'super1', 'super2', 'super2', 'super2'],
['a', 'a', 'b', 'b', 'c', 'c', 'c'],
['aa', 'aa', 'ba', 'bb', 'ca', 'cb', 'cc']])
idx_tuples = list(zip(*idx))
multi_index = pd.MultiIndex.from_tuples(idx_tuples, names=['super-level', 'a-level', 'aa-level'])
columns = ['This is an incredibly long column name', 'column2', 'column3', 'column4', 'column5']
data = pd.DataFrame(np.random.rand(7, 5) * 2 - 1, index=multi_index, columns=columns)
fmt_expand_multi_index = tf.FmtExpandMultiIndex(operator=tf.OP_SUM, bold=True,
hline_color=colors.DARK_BLUE)
fmt_nDecimal = tf.FmtDecimals(n=2)
fmt_align_cells = tf.FmtAlignCellContents(alignment='right')
fmt_heatmap_1 = tf.FmtHeatmap(columns=['column2', 'column3'], rows=['aa', 'ac'], threshold=0., axis=0)
fmt_heatmap_2 = tf.FmtHeatmap(columns=['column4', 'column5'], rows=['ca', 'cc'], threshold=0.3,
min_color=colors.PURPLE, max_color=colors.ORANGE)
fmt_stripes_bg = tf.FmtStripeBackground(first_color=colors.LIGHT_GREY)
fmt_rotate_header = tf.FmtHeader(fixed_width='500px', top_padding='200px')
formatters = [fmt_expand_multi_index, fmt_align_cells, fmt_stripes_bg, fmt_heatmap_1, fmt_heatmap_2,
fmt_rotate_header, fmt_nDecimal]
# Create table
table = Block(data, formatters=formatters)
filename = 'Multi_index_table.pdf'
table.save(filename)
# And clean up file afterwards
os.remove(filename)
def test_FmtStripeBackground():
fmt = pbtf.FmtStripeBackground(first_color=colors.BLACK, second_color=colors.RED, header_color=colors.GREEN)
# Check header color is applied
data = FormatterData(0., pbtf.HEADER_ROW_NAME, pbtf.INDEX_COL_NAME, df)
res = fmt._create_cell_level_css(data)
assert res == (pbtf.CSS_BACKGROUND_COLOR + colors.css_color(colors.GREEN))
# Check that first line is filled with first_color
data = FormatterData(0., 'a', 'aa', df)
res = fmt._create_cell_level_css(data)
assert res == (pbtf.CSS_BACKGROUND_COLOR + colors.css_color(colors.BLACK))
# Check that second line is filled with second color
data = FormatterData(0., 'b', pbtf.INDEX_COL_NAME, df)
res = fmt._create_cell_level_css(data)
assert res == (pbtf.CSS_BACKGROUND_COLOR + colors.css_color(colors.RED))
def get_weights_html(self):
fmt_pct = tf.FmtPercent(1, apply_to_header_and_index=False)
fmt_align = tf.FmtAlignTable("left")
fmt_background = tf.FmtStripeBackground(
first_color=tf.colors.LIGHT_GREY,
second_color=tf.colors.WHITE,
header_color=tf.colors.BLACK)
targetweights = Block(self.InputList[3],
formatters=[fmt_pct, fmt_align, fmt_background],
use_default_formatters=False)._repr_html_()
targetweights = {'targetweights_table': targetweights}
effectiveweights = Block(
self.InputList[4],
formatters=[fmt_pct, fmt_align, fmt_background],
use_default_formatters=False)._repr_html_()
effectiveweights = {'effectiveweights_table': effectiveweights}
return targetweights, effectiveweights
def test_FmtStripeBackground_headerandindex(apply_to_header_and_index):
fmt = pbtf.FmtStripeBackground(
apply_to_header_and_index=apply_to_header_and_index)
assert fmt.apply_to_header_and_index == apply_to_header_and_index
def get_performance_stats_html(self):
pct_rows = [('P&L', 'Total return'), ('P&L', 'Annual return'),
('P&L', 'Annual return (asset mode)'),
('Risk-adjusted return based on Drawdown',
'Max percentage drawdown')]
dec_rows = [
('P&L', 'Starting cash'),
('P&L', 'End value'),
('Risk-adjusted return based on Drawdown', 'Max money drawdown'),
# Distribution
('Distribution moments', 'Returns volatility'),
('Distribution moments', 'Returns skewness'),
('Distribution moments', 'Returns kurtosis'),
# Risk-adjusted return based on Volatility
('Risk-adjusted return based on Volatility', 'Treynor ratio'),
('Risk-adjusted return based on Volatility', 'Sharpe ratio'),
('Risk-adjusted return based on Volatility', 'Information ratio'),
# Risk-adjusted return based on Value at Risk
('Risk-adjusted return based on Value at Risk', 'VaR'),
('Risk-adjusted return based on Value at Risk',
'Expected Shortfall'),
('Risk-adjusted return based on Value at Risk', 'Excess var'),
('Risk-adjusted return based on Value at Risk',
'Conditional sharpe ratio'),
# Risk-adjusted return based on Lower Partial Moments
('Risk-adjusted return based on Lower Partial Moments',
'Omega ratio'),
('Risk-adjusted return based on Lower Partial Moments',
'Sortino ratio'),
('Risk-adjusted return based on Lower Partial Moments',
'Kappa three ratio'),
('Risk-adjusted return based on Lower Partial Moments',
'Gain loss ratio'),
('Risk-adjusted return based on Lower Partial Moments',
'Upside potential ratio'),
# Risk-adjusted return based on Drawdown
('Risk-adjusted return based on Drawdown', 'Calmar ratio')
]
fmt_pct = tf.FmtPercent(1,
rows=pct_rows,
apply_to_header_and_index=False)
fmt_dec = tf.FmtDecimals(2,
rows=dec_rows,
apply_to_header_and_index=False)
fmt_align = tf.FmtAlignTable("left")
fmt_background = tf.FmtStripeBackground(
first_color=tf.colors.LIGHT_GREY,
second_color=tf.colors.WHITE,
header_color=tf.colors.BLACK)
fmt_multiindex = tf.FmtExpandMultiIndex(operator=tf.OP_NONE)
perf_data = Block(self.InputList[2],
formatters=[
fmt_multiindex, fmt_pct, fmt_dec, fmt_align,
fmt_background
],
use_default_formatters=False)._repr_html_()
perf_data = {'performance_table': perf_data}
return perf_data
