Python爬虫数据并存入MySQL数据库，实现可视化。

接上一篇

可视化代码

#!/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.xaxi