如何将爬取的数据进行分析，并生成柱状图表？
{:5_109:} {:5_109:} 闲着没事写了个代码，爬取彩票数据，以生成Excel表格但如何将其进行图表分析呢，求大神讲解一下{:5_110:}import requests
import xlwt
import time
from bs4 import BeautifulSoup
# 获取网页内容
def get_html(url):
headers = {
'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36'
}
response = requests.get(url, headers = headers)
if response.status_code == 200:
return response.text
else:
print('无数据！')
return None
# 解析网页内容
def parse_html(html):
soup = BeautifulSoup(html, 'lxml')
i = 0
for item in soup.select('tr'):
yield{
'time':item.select('td').text,
'issue':item.select('td').text,
'digits':item.select('td em').text,
'ten_digits':item.select('td em').text,
'hundred_digits':item.select('td em').text,
'single_selection':item.select('td').text,
'three_selection':item.select('td').text,
'six_selection':item.select('td').text,
'sales':item.select('td').text,
'return_rates':item.select('td').text
}
# 将数据写入excel表
def write_to_excel():
f = xlwt.Workbook()
sheet1 = f.add_sheet('3D', cell_overwrite_ok=True)
row0 = ['开奖日期','期号','个位数','十位数','百位数','单数','组选3','组选6','销售额','反奖比列']
# 写入第一行
for j in range(0, len(row0)):
sheet1.write(0, j, row0)
# 依次爬取每一个网页,将结果写入excel
i = 0
for k in range(1, 276): #更改数字调节期数
url = 'http://kaijiang.zhcw.com/zhcw/html/3d/list_{}.html'.format(k)
html = get_html(url)
print('正在保存第{}页......'.format(k))
if html != None:
# 写入每一期信息
for item in parse_html(html):
sheet1.write(i+1, 0, item['time'])
sheet1.write(i+1, 1, item['issue'])
sheet1.write(i+1, 2, item['digits'])
sheet1.write(i+1, 3, item['ten_digits'])
sheet1.write(i+1, 4, item['hundred_digits'])
sheet1.write(i+1, 5, item['single_selection'])
sheet1.write(i+1, 6, item['three_selection'])
sheet1.write(i+1, 7, item['six_selection'])
sheet1.write(i+1, 8, item['sales'])
sheet1.write(i+1, 9, item['return_rates'])
i += 1
f.save('3D.xls')
def main():
write_to_excel()
if __name__ == '__main__':
main() 有没有大神能看到，帮忙解决一下{:5_109:}
页:
[1]