如何使Bokeh Hovertool适用于烛台图表? [英] How to get Bokeh hovertool working for candlesticks chart?

问题描述

目标是将鼠标悬停在烛台上，并在执行操作时显示数据.我能够使Bokeh悬停工具正常工作，但是无法拉出并显示数据.我能够显示(x，y)数据，但其余的却不然.这是我到目前为止的内容:

The goal was to have my mouse hover over the candlesticks and have the data appear while I do so. I was able to get the Bokeh hover tool working but, I am not able to pull and display the data. I was able to get the (x,y) data to appear but, not the rest. This is what I have so far:

#Importing Libraries
import requests
import pandas as pd
import datetime
from bokeh.plotting import ColumnDataSource, figure, output_file, show
from math import pi

#Request ticker symbol
API_KEY = 'YOUR API KEY'
symbol = input('Enter ticker symbol: ')
r = requests.get('https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=' + symbol + '&apikey=' + API_KEY)
print(r.status_code)
result = r.json()
dataForAllDays = result['Time Series (Daily)']

#convert to dataframe
df = pd.DataFrame.from_dict(dataForAllDays, orient='index') 
df = df.reset_index()

#rename columns
df = df.rename(index=str, columns={"index": "date", "1. open": "open", "2. high": "high", "3. low": "low", "4. close": "close","5. volume":"volume"})

#Changing to datetime
df['date'] = pd.to_datetime(df['date'])

#Sort according to date
df = df.sort_values(by=['date'])

#Changing the datatype 
df.open = df.open.astype(float)
df.close = df.close.astype(float)
df.high = df.high.astype(float)
df.low = df.low.astype(float)
df.volume = df.volume.astype(int)

#check the data
df.head()

#Hovertool Tooltips
source = ColumnDataSource(data=dict(date=df['date'], open=df.open, close=df.close))
TOOLTIPS = [
    ("(x,y)", "($x, $y)"),    
    ("date", "@date"),
    ("open", "df.open"),
    ("open", "@open"),
    ("close", "df.close"),
    ("close", "@close"),
    ("percent","@changepercent"),
]

#Check the datatype
df.info()
inc = df.close > df.open
dec = df.open > df.close
w = 12*60*60*1000 # half day in ms
TOOLS = "pan,wheel_zoom,box_zoom,reset,save"
title = symbol + ' Chart'
p = figure(x_axis_type="datetime", tools=TOOLS, tooltips=TOOLTIPS, plot_width=1000, title = title)
p.xaxis.major_label_orientation = pi/4
p.grid.grid_line_alpha=0.3
p.segment(df.date, df.high, df.date, df.low, color="black")
p.vbar(df.date[inc], w, df.open[inc], df.close[inc], fill_color="#a30e15", line_color="black")
p.vbar(df.date[dec], w, df.open[dec], df.close[dec], fill_color="#53680c", line_color="black")

#Store as a HTML file
output_file("stock_information.html", title="candlestick.py")

# Display in browser
show(p)

推荐答案

在工具提示规范中有意义的唯一值是:

The only values that are meaningful in the tooltip specification, are:

以 $ 开头的
• 预定义特殊变量"
• 对ColumnDataSource中列的引用，以 @
开头

因此在这种情况下，诸如"df.open" 之类的东西是没有意义的.制作hovertool的实际代码在浏览器中以JavaScript执行，而Python和Pandas以及您的DataFrame df 不存在.如果要使数据显示在 HoverTool 中，则必须在CDS中放入一列包含该数据的列，并使用 @column_name 语法.

So things like "df.open" are meaningless in this context. The actual code to make the hovertool executes in the browser, in javascript, where Python and Pandas and your DataFrame df do not exist. If you want data to show up in a HoverTool then you will have to put a column in your CDS with that data, and reference it in the hover tool specification using the @column_name syntax.

您可以参考文档以获取更多信息:

You may refer to the documentation for more information:

https://docs.bokeh.org/en/latest/docs/user_guide/tools.html#hovertool

这篇关于如何使Bokeh Hovertool适用于烛台图表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！