我正在寻求有关图表问题的帮助。
我正在尝试绘制数据框中包含的财务数据,其中日期和小时作为索引,但是,matplotlib 标准日期格式在这里不起作用,因为我不想在 x 轴上均匀分布刻度,因为它显示了营业时间之间的大水平线。
我想出的解决方案是简单地在 x 轴上使用 np.arange 绘制此图,并使用索引作为 x 轴上的标签,因此不使用 matplotlib 日期格式,但仍显示日期我的图表。
我的代码如下:
L = np.arange(len(DAX_M15.index))
def format_date(x, pos=None):
return DAX_M15.index[x].strftime("%Y-%m-%d %H-%M-%S")
fig, ax = plt.subplots()
ax.plot(L, DAX_M15["Open"])
ax.xaxis.set_major_formatter(ticker.FuncFormatter(format_date))
ax.set_title("Custom tick formatter")
fig.autofmt_xdate()
但是,我在使用它时遇到以下错误:
File "D:\Anaconda\lib\site-packages\matplotlib\backends\backend_qt5agg.py", line 197, in __draw_idle_agg
FigureCanvasAgg.draw(self)
File "D:\Anaconda\lib\site-packages\matplotlib\backends\backend_agg.py", line 464, in draw
self.figure.draw(self.renderer)
File "D:\Anaconda\lib\site-packages\matplotlib\artist.py", line 63, in draw_wrapper
draw(artist, renderer, *args, **kwargs)
File "D:\Anaconda\lib\site-packages\matplotlib\figure.py", line 1144, in draw
renderer, self, dsu, self.suppressComposite)
File "D:\Anaconda\lib\site-packages\matplotlib\image.py", line 139, in _draw_list_compositing_images
a.draw(renderer)
File "D:\Anaconda\lib\site-packages\matplotlib\artist.py", line 63, in draw_wrapper
draw(artist, renderer, *args, **kwargs)
File "D:\Anaconda\lib\site-packages\matplotlib\axes\_base.py", line 2426, in draw
mimage._draw_list_compositing_images(renderer, self, dsu)
File "D:\Anaconda\lib\site-packages\matplotlib\image.py", line 139, in _draw_list_compositing_images
a.draw(renderer)
File "D:\Anaconda\lib\site-packages\matplotlib\artist.py", line 63, in draw_wrapper
draw(artist, renderer, *args, **kwargs)
File "D:\Anaconda\lib\site-packages\matplotlib\axis.py", line 1136, in draw
ticks_to_draw = self._update_ticks(renderer)
File "D:\Anaconda\lib\site-packages\matplotlib\axis.py", line 969, in _update_ticks
tick_tups = [t for t in self.iter_ticks()]
File "D:\Anaconda\lib\site-packages\matplotlib\axis.py", line 969, in <listcomp>
tick_tups = [t for t in self.iter_ticks()]
File "D:\Anaconda\lib\site-packages\matplotlib\axis.py", line 916, in iter_ticks
for i, val in enumerate(majorLocs)]
File "D:\Anaconda\lib\site-packages\matplotlib\axis.py", line 916, in <listcomp>
for i, val in enumerate(majorLocs)]
File "D:\Anaconda\lib\site-packages\matplotlib\ticker.py", line 386, in __call__
return self.func(x, pos)
File "D:/Finance python/test_data_formatter.py", line 40, in format_date
return DAX_M15.index[x].strftime("%Y-%m-%d %H-%M-%S")
File "D:\Anaconda\lib\site-packages\pandas\tseries\base.py", line 247, in __getitem__
raise ValueError
ValueError
有人对这里的问题有想法以及如何解决吗?
谢谢。
请您参考如下方法:
如评论中所述,问题在于列表或系列的索引需要是 0 和列表长度之间的整数。 DAX_M15.index[4.5] 之类的东西将不起作用。
为了确保只有那些与数据点相关联的位置才会被选中,您可以使用 matplotlib.ticker.IndexLocator。例如。如果你想标记列表的每五个点,
ax.xaxis.set_major_locator(ticker.IndexLocator(5,0))
ax.xaxis.set_major_formatter(ticker.FuncFormatter(format_date))
在格式化程序中,您还需要确保索引是一个整数并且在允许值的范围内。
def format_date(x, pos=None):
if int(x) >= len(df.index) or int(x) < 0: return ""
return df.index[int(x)].strftime("%Y-%m-%d %H-%M-%S")
一个完整的例子:
import matplotlib.pyplot as plt
import matplotlib.ticker as ticker
import numpy as np
import pandas as pd
inx = pd.DatetimeIndex(start="2017-05-05", freq="7H", periods=45)
df = pd.DataFrame({"open" : np.random.rand(len(inx))}, index=inx)
L = np.arange(len(df.index))
def format_date(x, pos=None):
return df.index[int(x)].strftime("%Y-%m-%d %H-%M-%S")
fig, ax = plt.subplots()
ax.plot(L, df["open"])
ax.xaxis.set_major_locator(ticker.IndexLocator(5,0))
ax.xaxis.set_major_formatter(ticker.FuncFormatter(format_date))
ax.set_title("Custom tick formatter")
fig.autofmt_xdate()
plt.show()
