def create_datatable(df, tablename="mytable"):
cols = OrderedDict([("position", {
"label": "Position"
}), ("office", {
"label": "Office"
}), ("start_date", {
"label": "Start Date"
}),
("salary_lower", {
"label": "Salary Range",
"confidence": {
"lower": "salary_lower",
"upper": "salary_upper"
}
})])
addfunc = ("""
confidence_interval(this.api().column(3,
{{"page":"current"}}).data(), "{tablename}");
""".format(tablename=tablename))
drawfunc = ("""
confidence_interval(this.api().column(3,
{{"page":"current"}}).data(), "{tablename}");
""".format(tablename=tablename))
_table = DataTable(tablename,
"/api/{}/".format(tablename),
df,
columns=cols,
paging=True,
pageLength=9,
scrollX=True,
columnDefs=[{
"render":
"""<svg width="156" height="20"><g></g></svg>""",
"orderable": False,
"targets": 3
}],
sDom='<"top">rt<"bottom"lp><"clear">',
deferRender=True,
initComplete=addfunc,
drawCallback=drawfunc)
return _table
});
confidence_interval(this.api().column(3, {"page":"current"}).data(), "mytable");
"""
drawfunc = """
confidence_interval(this.api().column(3, {"page":"current"}).data(), "mytable");
"""
tb = DataTable(
"mytable",
"/mytable/",
df,
columns=cols,
paging=True,
pageLength=9,
scrollX=True,
columnDefs=[{"render": """<svg width="156" height="20"><g></g></svg>""", "orderable": False, "targets": 3}],
sDom='<"top">rt<"bottom"lp><"clear">',
deferRender=True,
initComplete=addfunc,
drawCallback=drawfunc,
)
app = Flask(__name__)
tb.register_route(app)
ui = SimpleComponent("Table", "./static/bower_components/pyxley/build/pyxley.js", "component_id", tb.params)
sb2 = SelectButton("SelectButton", ["Item1", "Item2"], "slide2", tb.params)
ui2 = SimpleComponent("SelectButton", "./static/bower_components/pyxley/build/pyxley.js", "slide2", sb2.params)
f = lambda x: '_'.join(x) if (len(x[1]) > 0) and x[1] != 'sum' else x[0]
gf.columns = [f(c) for c in gf.columns]
gf = gf.sort_index(by="week", ascending=False)
gf["Date_amin"] = gf["Date_amin"].apply(lambda x: x.strftime("%Y-%m-%d"))
gf["Date_amax"] = gf["Date_amax"].apply(lambda x: x.strftime("%Y-%m-%d"))
cols = OrderedDict([
("week", {"label": "Week"}),
("Date_amin", {"label": "Start Date"}),
("Date_amax", {"label": "End Date"}),
("Calories Burned", {"label": "Calories Burned"}),
("Steps", {"label": "Steps"}),
("Distance", {"label": "Distance (mi)", "format": "%5.2f"})
])
tb = DataTable("mytable", "/mytable/", gf, columns=cols, paging=True, pageLength=5)
ui.add_chart(tb)
app = Flask(__name__)
sb = ui.render_layout(app, "./static/layout.js")
@app.route('/', methods=["GET"])
@app.route('/index', methods=["GET"])
def index():
_scripts = ["./layout.js"]
return render_template('index.html',
title=TITLE,
base_scripts=scripts,
page_scripts=_scripts,
css=css)
});
confidence_interval(this.api().column(3, {"page":"current"}).data(), "mytable");
"""
drawfunc = """
confidence_interval(this.api().column(3, {"page":"current"}).data(), "mytable");
"""
tb = DataTable("mytable",
"/mytable/",
df,
columns=cols,
paging=True,
pageLength=9,
scrollX=True,
columnDefs=[{
"render": """<svg width="156" height="20"><g></g></svg>""",
"orderable": False,
"targets": 3
}],
sDom='<"top">rt<"bottom"lp><"clear">',
deferRender=True,
initComplete=addfunc,
drawCallback=drawfunc)
app = Flask(__name__)
tb.register_route(app)
ui = SimpleComponent("Table",
"./static/bower_components/pyxley/build/pyxley.js",
"component_id", tb.params)