import scoretools
import pandas as pd

tbl = pd.DataFrame({"A": [1, 2], "B": [4, 3]}, index=["R1", "R2"])

# Initialize table writer object.
wb = scoretools.TableWriter()
wb.write_table(tbl, 1, 1)

# Open excel document
wb.open_file()

import seaborn as sns
import scoretools as sts

df = sns.load_dataset("titanic")

pclass_freq = sts.freq_tab(df.pclass)
pclass_bivar = sts.single_bivar(data=df, main_var="deck", bivar="survived")

wb = sts.TableWriter()

# Write tables... If several tables are written to the
# same sheet, no row column indexes are needed, the tables
# will be written one after the other below one another.
wb.write_table(pclass_freq)
wb.write_table(pclass_bivar)

# Change options for the default format
wb.default_format(header_color="#e5d9fc", font="Times New Roman")

# If the row column index is changed for the first table,
# the subsequent tables will be written below from that point.
wb.write_table(pclass_freq, row=1, col=1, sheetname="New Sheet")
wb.write_table(pclass_bivar, sheetname="New Sheet")

# Open workbook
wb.open_file()