int_hhover = int_hline.select(dict(type=HoverTool))
int_hhover.mode = 'hline'
int_hhover.line_policy = 'interp'
int_vhover = int_vline.select(dict(type=HoverTool))
int_vhover.mode = 'vline'
int_vhover.line_policy = 'interp'
iphover = int_point_line.select(dict(type=HoverTool))
iphover.mode = 'mouse'
iphover.line_policy = 'interp'
tphover = point_line.select(dict(type=HoverTool))
tphover.mode = 'mouse'
shover = scatter.select(dict(type=HoverTool))
shover.mode = 'vline'
shoverp = scatter_point.select(dict(type=HoverTool))
shoverp.mode = 'mouse'
int_vhover.tooltips = int_hhover.tooltips = tphover.tooltips = iphover.tooltips = shover.tooltips = shoverp.tooltips = vhover.tooltips = hhover.tooltips = OrderedDict([
("y", "$~y"),
("x", "$~x"),
# ("data_x", "$~x"),
# ("data_y", "$~y"),
])
show(
vplot(
hplot(hline, vline),
int_hhover = int_hline.select(HoverTool)
int_hhover.mode = 'hline'
int_hhover.line_policy = 'interp'
int_vhover = int_vline.select(HoverTool)
int_vhover.mode = 'vline'
int_vhover.line_policy = 'interp'
iphover = int_point_line.select(HoverTool)
iphover.mode = 'mouse'
iphover.line_policy = 'interp'
tphover = point_line.select(HoverTool)
tphover.mode = 'mouse'
shover = scatter.select(HoverTool)
shover.mode = 'vline'
shoverp = scatter_point.select(HoverTool)
shoverp.mode = 'mouse'
# set up tooltips
int_vhover.tooltips = int_hhover.tooltips = TOOLTIPS
tphover.tooltips = iphover.tooltips = TOOLTIPS
shover.tooltips = shoverp.tooltips = TOOLTIPS
vhover.tooltips = hhover.tooltips = TOOLTIPS
output_file("hover_span.html", title="line.py example")
show(vplot(
hplot(hline, vline),
int_hhover = int_hline.select(dict(type=HoverTool))
int_hhover.mode = 'hline'
int_hhover.line_policy = 'interp'
int_vhover = int_vline.select(dict(type=HoverTool))
int_vhover.mode = 'vline'
int_vhover.line_policy = 'interp'
iphover = int_point_line.select(dict(type=HoverTool))
iphover.mode = 'mouse'
iphover.line_policy = 'interp'
tphover = point_line.select(dict(type=HoverTool))
tphover.mode = 'mouse'
shover = scatter.select(dict(type=HoverTool))
shover.mode = 'vline'
shoverp = scatter_point.select(dict(type=HoverTool))
shoverp.mode = 'mouse'
int_vhover.tooltips = int_hhover.tooltips = tphover.tooltips = iphover.tooltips = shover.tooltips = shoverp.tooltips = vhover.tooltips = hhover.tooltips = OrderedDict(
[
("y", "$~y"),
("x", "$~x"),
# ("data_x", "$~x"),
# ("data_y", "$~y"),
])
show(
vplot(
int_hhover = int_hline.select(HoverTool)
int_hhover.mode = 'hline'
int_hhover.line_policy = 'interp'
int_vhover = int_vline.select(HoverTool)
int_vhover.mode = 'vline'
int_vhover.line_policy = 'interp'
iphover = int_point_line.select(HoverTool)
iphover.mode = 'mouse'
iphover.line_policy = 'interp'
tphover = point_line.select(HoverTool)
tphover.mode = 'mouse'
shover = scatter.select(HoverTool)
shover.mode = 'vline'
shoverp = scatter_point.select(HoverTool)
shoverp.mode = 'mouse'
# set up tooltips
int_vhover.tooltips = int_hhover.tooltips = TOOLTIPS
tphover.tooltips = iphover.tooltips = TOOLTIPS
shover.tooltips = shoverp.tooltips = TOOLTIPS
vhover.tooltips = hhover.tooltips = TOOLTIPS
output_file("hover_span.html", title="hover_span.py example")
show(
vplot(
cursor.execute(sql)
sql = """INSERT INTO prod1 SELECT prod_id, COUNT(cust_id)AS frequency FROM new_schema.cust2 GROUP BY prod_id ORDER BY prod_id;"""
cursor.execute(sql)
sql = """select * from prod1;"""
cursor.execute(sql)
data = cursor.fetchall()
print(data)
df = pd.DataFrame([[ij for ij in i] for i in data])
df.rename(columns={
0: 'Product ID',
1: 'Frequency'
}, inplace=True)
df = df.sort_values(['Product ID'], ascending=[1])
print(df.head(1536))
#from bokeh.sampledata.autompg import autompg as df
from bokeh.charts import Scatter, output_file, show, save
from bokeh.models import HoverTool
scatter = Scatter(df,
x='Product ID',
y='Frequency',
tools='hover',
legend=False)
hover = scatter.select(dict(type=HoverTool))
hover.tooltips = [("Product ID", "$x{int}"), ("Frequency", "$y{int}")]
print(df.head())
output_file('prodscatter.html')
save(scatter)
