接上一篇
可视化代码
#!/usr/bin/python
#-- coding: utf-8 --
import matplotlib.pyplot as plt
from pylab import *
import xlrd
from xlrd import open_workbook
x_data=[]
y_data=[]
x_volte=[]
temp=[]
wb = open_workbook(‘600000.xlsx’)
for s in wb.sheets():
print(‘Sheet:’,s.name)
for row in range(s.nrows):
print(‘the row is:’,row)
values = []
for col in range(s.ncols):
values.append(s.cell(row,col).value)
print(values)
x_data.append(values[0])
y_data.append(values[1])
plt.plot(x_data, y_data, ‘bo-’,label=u"Phase curve",linewidth=1)
plt.annotate(‘zero point’, xy=(180,0), xytext=(60,3), arrowprops=dict(facecolor=‘black’, shrink=0.05),)
plt.title(u"stock")
plt.legend()
ax = gca()
ax.spines[‘right’].set_color(‘none’)
ax.spines[‘top’].set_color(‘none’)
ax.xaxis.set_ticks_position(‘bottom’)
ax.spines[‘bottom’].set_position((‘data’,0))
ax.yaxis.set_ticks_position(‘left’)
ax.spines[‘left’].set_position((‘data’,0))
plt.xlabel(u"date")
plt.ylabel(u"stock value")
plt.show()
print(‘over!’)